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 25,000 units at a selling price of $52 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
100%
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 Formula
$22 per unit sold
$172,000 per quarter
5% of sales
Cost
Cost of good sold
Advertising expense
Sales commissions
Shipping expense
Administrative salaries
$82,e00 per quarter
$9, 200 per quarter
$52,e00 per quarter
Insurance expense
Depreciation expense
Because shipping expense is a mixed cost, the company needs to estimate the varlable shipping expense per unit sold and
the fixed shipping expense per quarter using the following data:
Shipping
Expense
Quarter
Year 1:
Units Sold
$ 162,000
$ 177,809
$ 219,800
$ 182,889
First
18,808
20,000
25,000
Second
Third
Fourth
21,000
Year 2:
$ 172,000
$ 187,800
$ 234,000
$ 210,008
First
19,000
22,000
30,000
27,000
Second
Third
Fourth
Required:
1. Using the high-ow 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 25,000 units at a selling price of $52 per unit. Prepare a contribution
format Income statement for the quarter.
Complete this question by entering your answers in the tabs below.
Required 1
Required 2
Using the high-low method, estimate a cost formula for shipping expense in the form Y = a + bx. (Round the Variable cost
per unit to 2 decimal places.)
Transcribed Image Text: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 Formula $22 per unit sold $172,000 per quarter 5% of sales Cost Cost of good sold Advertising expense Sales commissions Shipping expense Administrative salaries $82,e00 per quarter $9, 200 per quarter $52,e00 per quarter Insurance expense Depreciation expense Because shipping expense is a mixed cost, the company needs to estimate the varlable shipping expense per unit sold and the fixed shipping expense per quarter using the following data: Shipping Expense Quarter Year 1: Units Sold $ 162,000 $ 177,809 $ 219,800 $ 182,889 First 18,808 20,000 25,000 Second Third Fourth 21,000 Year 2: $ 172,000 $ 187,800 $ 234,000 $ 210,008 First 19,000 22,000 30,000 27,000 Second Third Fourth Required: 1. Using the high-ow 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 25,000 units at a selling price of $52 per unit. Prepare a contribution format Income statement for the quarter. Complete this question by entering your answers in the tabs below. Required 1 Required 2 Using the high-low method, estimate a cost formula for shipping expense in the form Y = a + bx. (Round the Variable cost per unit to 2 decimal places.)
Year 1:
$ 162,880
$ 177,000
$ 219,000
$ 182,000
First
18,000
20,008
25,000
21,000
Second
Third
Fourth
Year 2:
First
Second
Third
19,000
22,000
30,000
27,880
$ 172,000
$ 187,000
$ 234,000
$ 210,880
Fourth
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 25,000 units at a selling price of $52 per unit. Prepare a
contribution format Income statement for the quarter.
Complete this question by entering your answers in the tabs below.
Required 1
Required 2
In the first quarter of Vear 3, the company plans to sell 25,000 units at a selling price of $52 per unit. Prepare a contribution
format income statement for the quarter.
Milden Company
Budgeted Contribution Format Income Statement
For the First Quarter, Year 3
Variable expenses:
Total variable expenses
Fixed expenses:
Total fixed expenses
Transcribed Image Text:Year 1: $ 162,880 $ 177,000 $ 219,000 $ 182,000 First 18,000 20,008 25,000 21,000 Second Third Fourth Year 2: First Second Third 19,000 22,000 30,000 27,880 $ 172,000 $ 187,000 $ 234,000 $ 210,880 Fourth 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 25,000 units at a selling price of $52 per unit. Prepare a contribution format Income statement for the quarter. Complete this question by entering your answers in the tabs below. Required 1 Required 2 In the first quarter of Vear 3, the company plans to sell 25,000 units at a selling price of $52 per unit. Prepare a contribution format income statement for the quarter. Milden Company Budgeted Contribution Format Income Statement For the First Quarter, Year 3 Variable expenses: Total variable expenses Fixed expenses: Total fixed expenses
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 3 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