Practical Management Learned Through Excel! A-Z (Part-II)

DY Management Research Institute

(Director Ryu Dae-young, Ph.D. in Business Administration/Management Consultant (Finance))

• YouTube : www.youtube.com/@dy-4714

• N Blog : https://blog.naver.com/udae025

• Email: daeyoung.lyu@gmail.com

I am Ryu Dae-young, who operates 'DY Management Research Institute' on YouTube and Naver Blog.

Based on my company experience and business administration studies, I want to help those working in related fields. I provide a very practical approach that can immediately help with cost accounting, management, accounting, finance, business planning, investment attraction, and overall management. If you want to collaborate on the lectures I've uploaded or in my areas of expertise, please contact me via email!

※ Area of Expertise:

• Management/Cost Consulting, Business Feasibility Review, Financial Business Plan Development, Management Simulation, Financial Projection Development for Investment Attraction.

• Excel practical training, Excel data visualization, work efficiency improvement using Excel. We'll cut your work time in half.

• I welcome lecture requests, work requests, and Q&A related to specialized fields and YouTube videos.

This course was created by compiling Excel materials into instructional videos covering highly practical aspects needed for company operations or business tasks. This will likely be an essential resource package for working professionals and small to medium-sized business owners.

I divided it into two parts because there is a large amount of materials and lectures.

It consists of Practical Business Management with Excel Part-I & Part-II.

***** Practical Business Management with Excel Part-I ******

This course is divided into three parts.

One free video is provided for each part. Please be sure to refer to the free videos before making a purchase.

I. Understanding Business Processes Through Accounting Treatment

1. Process-1 (Raw Material Purchase > Manufacturing > Sales)

- Raw material purchase > Raw material input > Processing cost input > Cost → Work-in-process input > Product completion > Product shipment > Sales billing processing > Accounts receivable collection > SG&A expenses incurred

Through the above business operations, I will explain how the manufacturing cost flow, trial balance, income statement, and balance sheet are created.

2. Process-2 (Equipment Purchase, Interest Expense, Corporate Tax Added)

3. Process-3 (Startup, Dividend Addition)

4. Process-4 (Inventory, Receivables, etc. Receipts and Disbursements): Inventory Asset Receipt and Disbursement Statement

Many office workers often only know about the tasks they perform at their company.

Through this Excel data and lectures, if you understand how the entire company process flows, your perspective on corporate life will become much broader.

In particular, we help people in non-accounting positions such as sales, logistics, and production management develop a holistic perspective.

II. Business Analysis

We provide explanations of various management methods needed for practical company operations and offer Excel templates.

The Excel template can be used according to the buyer's company, which will easily improve the company's management level.

1. Break-Even Point Analysis (BEP Analysis)

2. Financial Ratio Analysis

3. Manufacturing Cost Analysis: Variable Cost Analysis (Quantity Variance, Unit Variance, Price Variance)

4. Unit Processing Cost Analysis

Due to the large amount of materials and lectures, I have divided them into two parts.

The content below is for the "Practical Business Management with Excel Part-II" product.

***** Practical Business Management with Excel Part-II ******

5. Support Department Cost Allocation

6. Overhead Allocation and Processing Costs by Product

7. Cost Reduction Indicators and Performance Aggregation

8. Inventory Management and Inventory Valuation

III. Management Decision Making

I will explain the business management approach to decision-making that needs to be made while running a company. As always, using the provided video and Excel templates, you will be able to easily apply them directly to your company right away.

By purchasing this material SET, your management know-how will be upgraded to the next level. I highly recommend this as essential material for financial managers such as CFOs and management team leaders.

1. Investment Feasibility Analysis

2. Estimating Cost of Equity and Weighted Average Cost of Capital

3. Corporate Valuation

4. Price-to-Earnings Ratio (PER), Price-to-Book Ratio (PBR)

5. Make or Buy (In-house Production or Outsourcing)

6. Sell or Not (To Sell or Not to Sell?)