Question

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 expense    $174,000 per quarter
  Sales commissions    8% of sales
  Shipping expense    ?
  Administrative salaries    $84,000 per quarter
  Insurance expense    $9,400 per quarter
  Depreciation expense    $54,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 follow:

  Quarter     Units Sold Shipping
Expense
  Year 1:
      First 20,000    $ 164,000
      Second 22,000      $ 179,000
      Third 27,000      $ 221,000
      Fourth 23,000      $ 184,000
  Year 2:
      First 21,000    $ 174,000
      Second 24,000    $ 189,000
      Third 38,000    $ 236,000
      Fourth 35,000     $ 212,000

     Milden Company’s president 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 29,000 units at a selling price of $54 per unit. Prepare a contribution format income statement for the quarter. (Do not round your intermediate calculations.)

       

Garrison 15e Recheck 2014-12-16

Next Visit question map

Question11of12Total11 of 12

Prev

Homework Answers

Answer #1

1.

High low method (shipping expense)  = $236,000 - 164,000 / 38,000 - 20,000

Variable cost per unit = $72,000 / 18,000 = $4 per unit

Fixed cost = $236,000 - $152,000 (38,000*$4) = $84,000

2.

MILDEN COMPANY

Contribution Format Income Statement

Sales (29,000*$54) $1,566,000
Variable costs:
Cost of goods sold (29,000*$24) 696,000
Shipping expense (29,000*$4) 116,000
Sales commission ($1,566,000*8%) 125,280
Total variable costs 937,280
Contribution margin 628,720
Fixed costs:
Advertising expense 174,000
Shipping expense 84,000
Administrative salaries 84,000
Insurance expense 9,400
Depreciation expense 54,000
Total fixed costs 405,400
Net income $223,320
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
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...
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...
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...
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 . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . . ....
Exercise 2-11 Varying Plantwide Predetermined Overhead Rates [LO2-1, LO2-2, LO2-3] Kingsport Containers Company makes a single...
Exercise 2-11 Varying Plantwide Predetermined Overhead Rates [LO2-1, LO2-2, LO2-3] Kingsport Containers Company makes a single product that is subject to wide seasonal variations in demand. The company uses a job-order costing system and computes plantwide predetermined overhead rates on a quarterly basis using the number of units to be produced as the allocation base. Its estimated costs, by quarter, for the coming year are given below:     Quarter    First Second Third Fourth Direct materials $ 280,000 $ 140,000...
Exercise 1-6 Traditional and Contribution Format Income Statements [LO1-6] Cherokee Inc. is a merchandiser that provided...
Exercise 1-6 Traditional and Contribution Format Income Statements [LO1-6] Cherokee Inc. is a merchandiser that provided the following information: Amount Number of units sold 13,000 Selling price per unit $ 17 Variable selling expense per unit $ 1 Variable administrative expense per unit $ 2 Total fixed selling expense $ 22,000 Total fixed administrative expense $ 14,000 Beginning merchandise inventory $ 9,000 Ending merchandise inventory $ 22,000 Merchandise purchases $ 90,000 Required: 1. Prepare a traditional income statement. 2. Prepare...
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...
Problem 12-20 Prepare a contribution margin format income statement; answer what-if questions LO 7, 8, 9,...
Problem 12-20 Prepare a contribution margin format income statement; answer what-if questions LO 7, 8, 9, 12 Shown here is an income statement in the traditional format for a firm with a sales volume of 16,500 units: Revenues $ 198,000 Cost of goods sold ($11,000 + $2.85/unit) 58,025 Gross profit $ 139,975 Operating expenses: Selling ($2,000 + $1.25/unit) 22,625 Administration ($4,750 + $0.35/unit) 10,525 Operating income $ 106,825 Required: a. Prepare an income statement in the contribution margin format. b....
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT