Question

McKenzie Company has decided to use a contribution format income statement for internal planning purposes. The...

McKenzie Company has decided to use a contribution format income statement for internal planning purposes. The company has analyzed its expenses and has developed the following cost formulas:


  Cost Cost Formula
  Cost of goods sold    $31 per unit sold
  Advertising expense    $187,000 per quarter
  Sales commissions    7% of sales
  Administrative salaries    $97,000 per quarter
  Shipping expense      ?
  Depreciation expense    $67,000 per quarter


     Management has concluded that shipping expense is a mixed cost, containing both variable and fixed cost elements. Units sold and the related shipping expense over the last eight quarters are given below:


  Quarter Units Sold Shipping
Expense
  Year 1:
      First 33,000       $ 177,000      
      Second 35,000       $ 192,000      
      Third 40,000       $ 234,000      
      Fourth 36,000       $ 197,000      
  Year 2:
      First 34,000       $ 187,000      
      Second 37,000       $ 202,000      
      Third 48,750       $ 240,000      
      Fourth 45,750       $ 216,000      


     Management would like a cost formula derived for shipping expense so that a budgeted contribution format income statement can be prepared for the next quarter.


Required:
1.

Using the high-low method, estimate a cost formula for shipping expense based on the data for the last eight quarters above.


     

2.

In the first quarter of Year 3, the company plans to sell 43,000 units at a selling price of $60 per unit. Prepare a contribution format income statement for the quarter.

Homework Answers

Answer #1
1
Units Sold Shipping Expense
High level 48750 240000
Low level 33000 177000
Change 15750 63000
Unit variable cost = 63000/15750 = $4
Fixed cost = 240000-(48750*4)= $45000
Y = $45000+$4X
2
Budgeted Income Statement
For the first quarter of Year 3
Sales 2580000 =43000*60
Variable expenses:
Cost of goods sold 1333000 =43000*31
Shipping expense 172000 =43000*4
Sales commissions 180600 =43000*60*7%
Total Variable expenses 1685600
Contribution margin 894400
Fixed expenses:
Advertising expense 187000
Depreciation expense 67000
Administrative salaries 97000
Shipping expense 45000
Total Fixed expenses 396000
Net operating income 498400
Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
Problem 2-23 High-Low Method; Contribution Format Income Statement [LO2-5, LO2-6] Milden Company has an exclusive franchise...
Problem 2-23 High-Low Method; Contribution Format Income Statement [LO2-5, LO2-6] Milden Company has an exclusive franchise to purchase a product from the manufacturer and distribute it on the retail level. As an aid in planning, the company has decided to start using a contribution format income statement. To have data to prepare such a statement, the company has analyzed its expenses and has developed the following cost formulas:   Cost Cost Formula   Cost of good sold    $24 per unit sold   Advertising...
Milden Company is a distributor who wants to start using a contribution format income statement for...
Milden Company is a distributor who wants to start using a contribution format income statement for planning purposes. The company has analyzed its expenses and developed the following cost formulas: Cost Cost FormulaCost of good sold $28 per unit soldAdvertising expense $185,000 per quarterSales commissions 6% of salesShipping expense ?Administrative salaries $95,000 per quarterInsurance expense $10,500 per quarterDepreciation expense $65,000 per quarter Because shipping expense is a mixed cost, the company needs to estimate the variable shipping expense per unit...
milden company has an exclusive franchise to purchase a product from the manufacturer and distribut it...
milden company has an exclusive franchise to purchase a product from the manufacturer and distribut it on the retail level. As an aid in planning, the company has decided to start using a contribution format income statement. To have data to prepare such a statement, the company has analyzed its expenses and has developed the following cost formulas: cost                                                   cost formula cost of good sold                             $29 per unit sold advertising expense                        $179,ooo per quarter sales commissions                          8% shipping expenses                           ? administrative...
Traditional and Contribution Format Income Statement [LO3] Haaki Shop Inc. is a large retailer of surfboards....
Traditional and Contribution Format Income Statement [LO3] Haaki Shop Inc. is a large retailer of surfboards. The company assembled the information shown below for the quarter ended May 31: Amount Total sales revenue . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ....
Mastery Problem: CVP and the Contribution Margin Income Statement For planning and control purposes, managers have...
Mastery Problem: CVP and the Contribution Margin Income Statement For planning and control purposes, managers have a powerful tool known as cost-volume-profit (CVP) analysis. CVP shows how revenues, expenses, and profits behave as volume changes. In CVP analysis, costs are classified according to behavior: variable or fixed. Costs are classified by behavior on the income statement in CVP analysis to arrive at operating income. This format is known as the contribution margin income statement. Complete the following table to illustrate...
1. In a contribution format income statement for a merchandising company, the cost of goods sold...
1. In a contribution format income statement for a merchandising company, the cost of goods sold reports the product costs attached to the merchandise sold during the period. True/ false 2. The salary paid to the president of a company would be classified on the income statement as a(n): manufacturing overhead cost. manufacturing overhead cost, selling expense, direct labor cost , admin expense 3.Differential costs can: only be fixed costs, be sunk costs, only be variable costs, be either fixed...
1-4 Oslo Company prepared the following contribution format income statement based on a sales volume of...
1-4 Oslo Company prepared the following contribution format income statement based on a sales volume of 1,000 units (the relevant range of production is 500 units to 1,500 units): Sales $ 25,000 Variable expenses 17,500 Contribution margin 7,500 Fixed expenses 4,200 Net operating income $ 3,300 What is the contribution margin per unit? What is the contribution margin ratio? What is the variable expense ratio? f sales increase to 1,001 units, what would be the increase in net operating income?
Oslo Company prepared the following contribution format income statement based on a sales volume of 1,000...
Oslo Company prepared the following contribution format income statement based on a sales volume of 1,000 units (the relevant range of production is 500 units to 1,500 units Sales $105,000 Variable expense 73,500 Contribution margin 31,500 Fixed expenses 27,720 Net operating income $3,780 If sales decline to 900 units, what would be the net operating income? Net operating income- If the selling price increases by $2 per unit and the sales volume decreases by 100 units, what would be the...
DartmountCorporation has provided its contribution format income statement for June. The company produces and sells a...
DartmountCorporation has provided its contribution format income statement for June. The company produces and sells a single product. Sales (2,900 units) = $269,700. Variable costs = $107,300. Contribution margin = $162,400. Fixed costs = $137,100. Operating profit = $25,300. If the company sells 3,100 units, its total contribution margin should be closest to: A) $173,600. B) $162,400. C) $181,000. D) $27,045.
Oslo Company prepared the following contribution format income statement based on a sales volume of 1,000...
Oslo Company prepared the following contribution format income statement based on a sales volume of 1,000 units (the relevant range of production is 500 units to 1,500 units):      Sales $ 23,900       Variable expenses 13,300       Contribution margin 10,600       Fixed expenses 7,632       Net operating income $ 2,968         Required: What is the degree of operating leverage Oslo Company prepared the following contribution format income statement based on a sales volume of 1,000 units (the relevant range...