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 Formula Cost of good sold $28 per unit sold Advertising expense $178,000 per quarter Sales commissions 6% of sales Shipping expense ? Administrative salaries $88,000 per quarter Insurance expense $9,800 per quarter Depreciation expense $58,000 per quarter     Because shipping expense is a mixed cost, the company needs to estimate the variable shipping expense per unit sold and the fixed shipping expense per quarter using the following data:   Quarter Units Sold Shipping Expense Year 1:         First 24,000 $ 168,000   Second 26,000 $ 183,000   Third 31,000 $ 225,000   Fourth 27,000 $ 188,000   Year 2:         First 25,000 $ 178,000   Second 28,000 $ 193,000   Third 38,400 $ 240,000   Fourth 35,400 $ 216,000       Required: 1. Using the high-low method, estimate a cost formula for shipping expense in the form Y = a + bX. 2. In the first quarter of Year 3, the company plans to sell 31,000 units at a selling price of $58 per unit. Prepare a contribution format income statement for the quarter.

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

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 Formula
Cost of good sold $28 per unit sold
Advertising expense $178,000 per quarter
Sales commissions 6% of sales
Shipping expense ?
Administrative salaries $88,000 per quarter
Insurance expense $9,800 per quarter
Depreciation expense $58,000 per quarter
 

 

Because shipping expense is a mixed cost, the company needs to estimate the variable shipping expense per unit sold and the fixed shipping expense per quarter using the following data:

 

Quarter Units Sold Shipping
Expense
Year 1:        
First 24,000 $ 168,000  
Second 26,000 $ 183,000  
Third 31,000 $ 225,000  
Fourth 27,000 $ 188,000  
Year 2:        
First 25,000 $ 178,000  
Second 28,000 $ 193,000  
Third 38,400 $ 240,000  
Fourth 35,400 $ 216,000  
 

 

Required:

1. Using the high-low method, estimate a cost formula for shipping expense in the form Y = a + bX.

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

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 3 steps with 1 images

Blurred answer
Knowledge Booster
Cost volume profit (CVP) analysis
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