inflearn logo

Standardize proposal pricing for small and midsize businesses! (Excel template included)

Many small and medium-sized businesses struggle to calculate proposal prices. By understanding the pricing criteria explained in this course and using the Excel template provided, you can easily and accurately calculate your proposal price.

6 learners are taking this course

Level Basic

Course period Unlimited

cost reduction
cost reduction
Accounting
Accounting
Financial Management
Financial Management
cost reduction
cost reduction
Accounting
Accounting
Financial Management
Financial Management

What you will gain after the course

  • Proposal Price Calculation

  • Estimated cost of the quote

  • Pricing decision

  • Selling price determination

DY Management Research Institute

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

I’m Ryu Dae-young, and I run “DY Management Research Institute” on YouTube and N Blog.

Drawing on my experience in business and my studies in business administration, I aim to help professionals working in related fields. I offer highly practical approaches that can provide immediate help with costs, management, accounting, financial business planning, fundraising, and business operations in general. If you’d like to collaborate on one of my courses or in one of my areas of expertise, please contact me by email!


※ Areas of Expertise:

  • Management and cost consulting, feasibility studies, financial business plan development, management simulations, and financial projections for fundraising.

  • Practical Excel training, data visualization using Excel, and improving work efficiency with Excel. I’ll cut your work time in half.

  • I welcome requests for lectures or project work, as well as Q&A, related to my areas of expertise and YouTube videos.



Executives at small and medium-sized enterprises may find it very challenging to determine proposed prices.

To help with this, I created a template that makes it easy to do in Excel.

​

This is an Excel template that helps you organize prior-year or planned costs, derive several indicators, and use them to easily “calculate a proposed price.”


This material consists of two parts: “Calculating the Proposed Price” and “How Costs Are Aggregated in Financial Statements and Break-Even Analysis.”



※ Proposed Price Calculation Template

​

1. First, define the costs incurred as follows: manufacturing expenses and selling, general, and administrative expenses. Break manufacturing costs down into materials, labor, and expenses.

2. Using the data compiled in Step 1, derive the manufacturing overhead rate, selling and administrative expense rate, and profit margin.

3. Derive the average labor rate metric. This can be calculated by dividing the company’s total direct labor costs by its total available labor hours.

4. You can now use the metrics calculated above to standardize the process of preparing price proposals. (See the attached photo.)




※ Let’s learn how financial statements are prepared using the cost summary as a reference.

​

1. Statement of Cost of Goods Manufactured: This is one of the most important statements for a manufacturing company. I worked out in Excel how it is prepared.

2. Income Statement: This explains in Excel how the cost of goods manufactured flows into the income statement.

3. Activity Level–Contribution Margin Graph: The graph below shows how profit changes with activity level. This is a very important concept for decision-making in managerial accounting.

4. Variable Cost (Direct Cost) Income Statement: Costs are divided into fixed and variable costs to create a variable costing income statement.

5. Using a variable costing income statement, you can simulate profits at different sales levels, as shown below. You can also perform break-even point (BEP) analysis.

6. You can also calculate the sales revenue needed to achieve a target profit.

​

This concludes the explanation of the material.

If you understand just the points explained above, they will be a great help in running a small or medium-sized business.




















Recommended for
these people

Who is this course right for?

  • Sales representative

  • Cost Manager

  • Small and medium-sized enterprise executives

Need to know before starting?

  • Cost Accounting

Hello
This is dymanagementlab

276

Learners

33

Reviews

5

Answers

4.7

Rating

16

Courses

I am Daeyoung Ryu, and I run 'DY Management Research Institute' on YouTube and Naver Blog.

Based on my professional experience and studies, I aim to provide practical assistance to those working in related fields. I offer highly hands-on approaches that can be immediately applied across various areas, including costing, management, accounting, financial business planning, investment attraction, and overall business management.

I am here to help. I provide highly practical and immediate solutions across cost accounting, management, accounting, financial business planning, investment attraction, and overall business management.

  • YouTube DY Management Research Institute: www.youtube.com/@dy-4714

  • Naver Blog DY Management Research Institute: https://blog.naver.com/udae025

※ Areas of Expertise:

  • Management/cost consulting, feasibility studies, financial business planning, management simulation, and financial projections for investment attraction.

  • Practical Excel training, data visualization using Excel, and improving work efficiency through Excel. I will cut your working time in half.

  • I welcome inquiries regarding lectures, project requests, and Q&A related to my areas of expertise and YouTube videos.

Data visualization and business efficiency using Excel. I will cut your work time in half. I welcome requests for lectures, projects, and Q&A regarding my areas of expertise and YouTube videos.

More

Curriculum

All

4 lectures ∙ (43min)

Course Materials:

Lecture resources
Published: 
Last updated: 

Reviews

Not enough reviews.
Please write a valuable review that helps everyone!

dymanagementlab's other courses

Check out other courses by the instructor!

Similar courses

Explore other courses in the same field!

25% off for new members

$16.40

25%

$26.40