Site Search                  

Loading

Home page     Downloads      Privacy policy     Disclaimer & terms of use     Contact us     Advertise with us     About us      Link to us

Home » Gross Profit Analysis » Gross Profit Analysis Based on Budgets and Standard Costs
 

Dear visitor! Accountingformanagement.com requests you to share this site with your friends. Thanks.

Gross Profit Analysis Based on Budgets and Standard Costs:

As the basis for illustrating the analysis of gross profit using budgets and standard costs, three financial statements for a company are presented:

  1. The budgeted income statement prepared at the beginning of the period
  2. The actual income statement prepared at the end of the period.
  3. An income statement prepared at the end of the period on the basis of actual sales at budgeted sales prices and at standard costs.

Statement 1:

Income Statement (Budgeted)

Product Units Sales Cost Gross Profit
    Unit price Amount Unit cost Amount Per unit Amount
A 6,000 $15.00 $90,000 $12.00 $72,000 $3.00 $18,000
B 3,500 $12.00 $42,000 $10.00 $35,000 $2.00 $7,000
C 1,000 $10.00 $10,000 $8.75 $8,750 $1.25 $1,250
  ------- ------- -------- ------- ------- ------- --------
  10,500 $13.52* $142,000 $11.02* $115,750 $2.50* $26,250
===== ===== ===== ===== ===== ===== =====

*Weighted average

Statement 2:

Income Statement (Actual)

Product Units Sales Cost Gross Profit
    Unit price Amount Unit cost Amount Per unit Amount
A 5,112 $16.00 $81,792 $13.98 $71,466 $2.02 $10,326
B 4,208 $12.00 $50,496 $9.72 $40,902 $2.28 $9,594
C 1,105 $9.00 $9,945 $8.83 $9,757 $0.17 $188
  ------- ------- -------- ------- ------- ------- --------
10,425 $13.64* $142,233 $11.71* $122,125 $1.93* $20,108
===== ===== ===== ===== ===== ===== =====

*Weighted average

Statement 3:

Income Statement (Actual units at budgeted prices and costs)

Product Units Sales Cost Gross Profit
    Unit price Amount Unit cost Amount Per unit Amount
A 5,112 $15.00 $76,680 $12.00 $61,344 $3.00 $15,338
B 4,208 $12.00 $50,496 $10.00 $42,080 $2.00 $8,416
C 1,105 $10.00 $11,050 $8.75 $9,669 $1.25 $1,381
  ------- ------- -------- ------- ------- ------- --------
  10,425 $13.26* $138,226 $10.85* $113,093 $2.41* $25,133
===== ===== ===== ===== ===== ===== =====

*Weighted average

According to statement 1, the company expected a gross profit of $26,250, based on an estimated production of 10,500 units and an average gross profit of $2.50 per unit. As shown in statement 2, the company actually made a gross profit of only $20,108, or $1.93 per unit. Statement 3 Indicates that the average gross profit for the actual units sold would have been $2.41 per unit if the budgeted sales price and costs per unit had been achieved.

The $6,142 difference between the budgeted gross profit and the actual gross profit is the result of changes in sales price, sales volume, sales mix, and costs. For example, on the basis of the budget, A is the most profitable product and C is the least profitable per unit. Due to variations in sales price and cost, B is actually the most profitable while C is the least profitable per unit. The dollar effect of such changes is shown by the calculation of the sales price, sales volume, cost price, cost volume, sales mix and final sales volume variances.

Calculation of sales price variance and sales volume variance:

Using the figures from the statements above, the sales price variance and sales volume variance for the company are calculated as follows:

Actual sales $142,233
Actual sales at budgeted price $138,226
  -----------
Favorable sales price variance $4,007
  =======
Actual sales at budgeted price $138,226
Budgeted sales 142,000
  ------------
Unfavorable sales volume variance $3,774
  ========

Calculation of Cost Price Variance and Cost Volume Variance:

Using the figures from the statements above, the cost price variance and cost volume variance for the company are calculated as follows:

Cost of goods sold - Actual $122,125
Budgeted cost of actual units sold $113,093
  -----------
Unfavorable cost price variance $9,032
  =======
Budgeted cost of actual units sold $113,093
Budgeted cost of budgeted units sold 115,570
  ------------
Favorable cost volume variance $2,657
  ========

Calculation of the Sales Mix and Final Sales Volume Variance:

In the above calculation two volume variances appear:

Unfavorable sales volume variance $3,774
Favorable cost volume variance $2,657
--------
Net unfavorable volume variance $1,117
  =====

The net volume variance should be further analyzed to determine the sales mix and final sales volume variance. These variances are computed as follows:

Actual sales at budgeted prices   $138,266.00
Budgeted cost of actual units sold   113,093.00
    --------------
Difference   $25,133.00
Budgeted gross profit of actual units sold    
10,425 actual units × $2.50 budgeted gross profit per unit   $26062.50
    ---------------
Unfavorable sales mix variance   $929.50
    =======
Budgeted gross profit of actual units sold   $26062.50
Budgeted sales $142,000  
Budgeted cost of budgeted units sold $115,750  
  ------------- 26,250.00
    ---------------
Unfavorable final sales volume variance   $187.50
    ========

Check:

Unfavorable sales mix variance $929.50
Unfavorable final sales volume variance 187.50
  -----------
Net unfavorable volume variance 1,117.00
  ======

Recapitulation of Variances:

  Gains Losses
Gain due to increased sales prices $4,007  
Loss due to increased cost   $9,032.00
Loss due to shift in sales mix   929.50
Loss due to decrease in units sold   187.50
    ---------------
Total   $10,149.00
Less   4,007.00
    ---------------
Net decrease in gross profit   $6,142.00
    =======
New Page 3

You may also be interested in other articles from "Gross Profit Analysis" chapter:

  1. Gross Profit Analysis Based on the Previous Years Figures
  2. Gross Profit Analysis Based on Budgets and Standard costs
  3. Discussion Questions and Answers about Gross Profit Analysis
  4. Gross Profit Analysis Solved Problems
  5. Gross Profit Analysis Case Study
 

Downloadable Materials

Learn Accounting Easily With AccountingCoach Pro

View Online or Download all of the materials to Your Computer and Print Immediately

What is Included in AccountingCoach Pro
Downloadable Self-Study Materials (Also Available in PDF-Format)
Downloadable Online Exams (Also Available in PDF-Format)
Downloadable 87 Useful Business Forms in Excel and PDF Format
Downloadable Seminars on Bookkeeping and Financial Statements

Back to Home Page | Back To Gross Profit Analysis Page

Managerial Accounting

 
Introduction to Managerial Accounting
Business and Quality Improvement Programs
Cost Terms, Concepts and Classification
Job Order Costing system
Process Costing System
Process Costing System - Addition of Materials & Beginning Inventory
Controlling and Costing Materials
Materials and Inventory Cost Control
By Products and Joint Products Costing
Cost-Volume-Profit-Relationship
Variable Costing System
Activity Based Costing System
Budgeting and Planning
Standard Costing and Variance Analysis
Gross Profit Analysis
Linear Programming Technique
Segment Reporting and Transfer Pricing
Capital Budgeting Decisions
Service Department Costing
Cash Flow statement
Financial statement Analysis
Pricing Products and Services
Managerial Accounting Terms and Definitions
Managerial / Cost Accounting Formulas

Financial Accounting

 
Bookkeeping and Bookkeeping Terms
Accounting Principles and Accounting Equation
Journal
Ledger
Accounting For Bills of Exchange
Subdivision of Journal
Final Accounts
Capital and Revenue Items
Single Entry System/Accounting From Incomplete Records
Accounting For Non-Trading Concerns
Accounting for Consignment / Consignment Accounts
Accounting for Joint Ventures
Accounting for Depreciation


Home page   Download Material   Privacy policy   Disclaimer & terms of use   Contact us   Advertise with us   About us   Useful links   Link to us

Copyrights of all content on this web site are owned by Accounting For Management except where indicated in source or copyright statements. Accounting For Management must be contacted for permission to copy or redistribute any material published on this website.
Copyright 2011 Accounting For Management. All rights reserved.