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.

Managerial Accounting: The Cornerstone of Business Decision-Making
7th Edition
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Chapter3: Cost Behavior And Cost Forecasting
Section: Chapter Questions
Problem 54E: Income Statements under Absorption and Variable Costing In the coming year, Kalling Company expects...
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
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Principles of Cost Accounting
Principles of Cost Accounting
Accounting
ISBN:
9781305087408
Author:
Edward J. Vanderbeck, Maria R. Mitchell
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Survey of Accounting (Accounting I)
Survey of Accounting (Accounting I)
Accounting
ISBN:
9781305961883
Author:
Carl Warren
Publisher:
Cengage Learning