PROBLEM 3-16 High-Low Method; Contribution Format Income Statement [LO3, LO4] 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 Advertising expense Sales commissions $35 per unit sold $210,000 per quarter 6% of sales Shipping expense. Administrative salaries ? $145,000 per quarter $9,000 per quarter $76,000 per quarter Insurance expense Depreciation expense. 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: Shipping Expense Quarter Units Sold Year 1: First $119,000 $175,000 $190,000 $164,000 10,000 Second 16,000 Third 18,000 Fourth 15,000 Year 2: First 11,000 17,000 $130,000 $185,000 $210,000 $147,000 Second Third 20,000 Fourth 13,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. In the first quarter of Year 3, the company plans to sell 12,000 units at a selling price of $100 per unit. Prepare a contribution format income statement for the quarter. 2.

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
Question

using the hig low method, estimate a cost formula for shipping expense

PROBLEM 3-16 High-Low Method; Contribution Format Income Statement [LO3, LO4]
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
Advertising expense
Sales commissions.
Shipping expense
$35 per unit sold
$210,000 per quarter
6% of sales
Administrative salaries
$145,000 per quarter
$9,000 per quarter
$76,000 per quarter
Insurance expense
Depreciation expense
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:
Shipping
Expense
Quarter
Units Sold
Year 1:
First
10,000
16,000
$119,000
$175,000
$190,000
$164,000
Second
Third
18,000
Fourth
15,000
Year 2:
First.
11,000
17,000
$130,000
$185,000
$210,000
$147,000
Second
Third
20,000
13,000
Fourth
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.
In the first quarter of Year 3, the company plans to sell 12,000 units at a selling price of $100
per unit. Prepare a contribution format income statement for the quarter.
2.
Transcribed Image Text:PROBLEM 3-16 High-Low Method; Contribution Format Income Statement [LO3, LO4] 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 Advertising expense Sales commissions. Shipping expense $35 per unit sold $210,000 per quarter 6% of sales Administrative salaries $145,000 per quarter $9,000 per quarter $76,000 per quarter Insurance expense Depreciation expense 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: Shipping Expense Quarter Units Sold Year 1: First 10,000 16,000 $119,000 $175,000 $190,000 $164,000 Second Third 18,000 Fourth 15,000 Year 2: First. 11,000 17,000 $130,000 $185,000 $210,000 $147,000 Second Third 20,000 13,000 Fourth 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. In the first quarter of Year 3, the company plans to sell 12,000 units at a selling price of $100 per unit. Prepare a contribution format income statement for the quarter. 2.
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 3 images

Blurred answer
Knowledge Booster
Cost classification
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education