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 Solved Problems
 

Gross Profit Analysis Solved Problems:

Learning Objective:

  1. Calculate sales price variance, sales volume variance, cost price variance, cost volume variance, sales mix variance, and final sales volume variance.

Problem 1:

A cost analyst of the Memphis Company has prepared a monthly gross profit analysis, comparing actual to budget for its two products, Alco and Bacco. June actual and budget data show:

              Sales Cost of Goods Sold Gross Profit
  Units Unit Price Amount Unit Cost Amount Per unit Amount
Budget:              
Alco 8,000 $20.00 $160,000 $16.00 $128,000 $4.00 $32,000
Bacco 4,200 14.00 58,800 12.00 50,400 2.00 8,400
  ---------- ---------- ---------- ----------- ---------- ---------- -----------
Total budget 12,200 $17.9344* $218,800 $14.6229* $178,400 $3.3115* $40,400
  ====== ====== ====== ====== ====== ====== ======
               
Actual:              
Alco 7,500 $21.00 $157,500 $16.50 $123,750 $4.50 $33,750
Bacco 4,500 13.50 60,750 11.50 51,750 2.00 9,000
  ---------- ---------- ----------- ----------- ---------- ----------- -----------
Total actual 12,000 $18.1875* $218,250 $14.625* $175,500 $3.5625* $42750
               
*Weighted average

Required:

  • Calculate price and volume variances for sales and cost.
  • Calculate sales mix variance and final sales volume variances.

Solution:

Actual sales   $218,250
Actual sales at budgeted price:
     Alco: 7,500 @ $20 $150,000
     Bacco: 4,500 @ 14 63,000 213,000
    --------------
Favorable sales price variance $5,250
    =======
Actual sales at budgeted price 213,000
Budgeted sales 218,800
--------------
Unfavorable sales volume variance $5,800
    =======
Cost of goods sold actual $175,500
Budgeted costs of actual units sold:
     Alco: 7,500 @ $16 $120,000  
     Bacco: 4,500 @ $12 54,000  
--------------- 174,000
    --------------
Unfavorable cost price variance $1,500
========
Budgeted costs of actual units sold   $174,000
Budgeted costs of budgeted units sold   178,400
    ---------------
Favorable cost volume variance $4,400
========

Interim Recapitulation:

Favorable sales volume variance   $5,250
Less unfavorable volume variance (net) consisting of:    
     Unfavorable sales volume variance $5,800  
     Less favorable cost volume variance 4,400  
  ---------- 1,400
    -------
    $3,850
Less unfavorable cost price variance   1,500
----------
Increase in gross profit $2,350
=======

Problem 2:

The Summers Sporting Goods Shop presents the following data for two types of racquetball gloves, leather and fabric, for 19A and 19B.

  19A 19B
  Units Per unit Amount Units Per unit Amount
Sales:            
    Leather racquetball gloves 8,000 $8.00 $64,000 12,000 $10.00 $120,000
    Fabric racquetball gloves 8,000 $4.00 $32,000 20,000 $6.00 $120,000
      ----------     ---------
      $96,000     $240,000
      =======     ======
Cost of Goods Sold            
    Leather racquetball gloves 8,000 $6.00 $48,000 12,000 9.00 $108,000
    Fabric racquetball gloves 8,000 $3.00 $24,000 20,000 5.00 100,000
      ------------     ----------
      $72,000     $208,000
      ------------     ----------
Gross profit 16,000 $1.50 $24,000 32,000 $1.00 $32,000
      =======     ======

Required:

  • Calculate price and volume variances for sales and cost.
  • The sales mix and final sales volume variances.

Solution:

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 Accounting Book
Downloadable Self-Study Materials ( Available in Word Editable Format)
Help in preparation of Online Exams (Available in Word Editable Formatt)
Solved Accounting Problems
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

About us !

 
Also see formula of gross margin ratio method with financial analysis, balance sheet and income statement analysis tutorials for free download on Accounting4Management.com.Accounting students can take help from Video lectures, handouts, helping materials, assignments solution, Online Quizzes, GDB, Past Papers, books and Solved problems. Also learn latest Accounting & management software technology with tips and tricks.

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 2014 Accounting For Management. All rights reserved.