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
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