Connelly Incorporated, a manufacturer of quality electric ice cream makers, has experienced a steady growth in sales over the past few years. Because her business has grown, Jan DeJaney, the president, believes she needs an aggressive advertising campaign next year to maintain the company’s growth. To prepare for the growth, the accountant prepared the following data for the current year:   Variable costs per ice cream maker   Direct labor $ 10.00 Direct materials 12.00 Variable overhead 5.00 Total variable costs $ 27.00 Fixed costs   Manufacturing $ 118,000 Selling 58,000 Administrative 512,000 Total fixed costs $ 688,000 Selling price per unit $ 50 Expected sales (units) 60,000   Required: 1. If the costs and sales price remain the same, what is the projected operating profit for the coming year? 2. What is the breakeven point in units for the coming year? 3. Jan has set the sales target for 67,000 ice cream makers, which she thinks she can achieve by an additional fixed selling expense of $213,280 for advertising. All other costs remain as per the data in the above table. What will be the operating profit if the additional $213,280 is spent on advertising and sales rise to 67,000 units?

Principles of Accounting Volume 2
19th Edition
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax
Chapter3: Cost-volume-profit Analysis
Section: Chapter Questions
Problem 10EB: Keleher Industries manufactures pet doors and sells them directly to the consumer via their web...
icon
Related questions
Question

Connelly Incorporated, a manufacturer of quality electric ice cream makers, has experienced a steady growth in sales over the past few years. Because her business has grown, Jan DeJaney, the president, believes she needs an aggressive advertising campaign next year to maintain the company’s growth. To prepare for the growth, the accountant prepared the following data for the current year:

 

Variable costs per ice cream maker  
Direct labor $ 10.00
Direct materials 12.00
Variable overhead 5.00
Total variable costs $ 27.00
Fixed costs  
Manufacturing $ 118,000
Selling 58,000
Administrative 512,000
Total fixed costs $ 688,000
Selling price per unit $ 50
Expected sales (units) 60,000

 

Required:

1. If the costs and sales price remain the same, what is the projected operating profit for the coming year?

2. What is the breakeven point in units for the coming year?

3. Jan has set the sales target for 67,000 ice cream makers, which she thinks she can achieve by an additional fixed selling expense of $213,280 for advertising. All other costs remain as per the data in the above table. What will be the operating profit if the additional $213,280 is spent on advertising and sales rise to 67,000 units?

4-a. What will be the new breakeven point if the additional $213,280 is spent on advertising?

4-b. Prepare a contribution income statement at the new breakeven point.

4-c. What is the percentage change in both fixed costs and in the breakeven point?

5. If the additional $213,280 is spent for advertising in the next year, what is the sales level (in units) needed to equal the current year’s operating profit at 60,000 units?

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

please answer 4a,b,c and 5 only. 

 

4-a. What will be the new breakeven point if the additional $213,280 is spent on advertising?

4-b. Prepare a contribution income statement at the new breakeven point.

4-c. What is the percentage change in both fixed costs and in the breakeven point?

5. If the additional $213,280 is spent for advertising in the next year, what is the sales level (in units) needed to equal the current year’s operating profit at 60,000 units

Required:
1. Using the data from 2022 in Gaming Table Cost Data, create an Excel spreadsheet to provide a sensitivity analysis of
the effect on operating profit of potential changes in demand for HFI Incorporated, ranging from a 20 percent decrease to
a 20 percent increase. Use Contribution Income Statements and What-If Sensitivity Analysis as a guide. Assume that
two-thirds of fixed costs are manufacturing related; the remaining one-third are selling-related. The variable
manufacturing cost per unit is $30, while the variable selling cost per unit is $5. (Hint: Calculate the DOL for 2022 at a
sales volume of 3,000 units.)
2. Using the spreadsheet you created, compute the new operating profit assuming a 10% decrease in demand.
Complete this question by entering your answers in the tabs below.
Gaming Table
Contribution
Income
Statements
What If
Sensitivity
Analysis
Required 1
Required 2
Cost Data
Per Unit
2022
84,000
Fixed costs (per year)
Selling price
Variable cost
Planned production
Planned sales volume
Gaming Table
Required 1
Cost Data
Percent
Notes
Sales
$
225,000
100.00 % $
247,500
22,500
Variable costs
105,000
115,500
10,500
46.67
53.33 % S
Total contribution margin
$
120,000
84,000
132,000
84,000
12,000 53.33% is the contribution margin
0
Fixed costs
Operating profit
$
36,000
$
48,000
12,000 12,000=0.5333 × 22,500
Complete this question by entering your answers in the tabs below.
What If
Gaming Table
Cost Data
Contribution
Income
Statements
Required 1
Required 2
Sensitivity
Analysis
Units Sold
Variable Cost
per Unit
Fixed Costs
S
30
S
84,000
75
35
84,000
75
40
84,000
75
45
84,000
75
<Contribution Income Statements
2,100
2,100
2,100
2,100
Contribution
Income
Statements
S
What If
Sensitivity
Analysis
Amount
75
35
$
2022
3,000 units
3,000 units
Selling Price
per Unit
$
2023
$ 84,000
3,300 units
3,300 units
Required 2
Amount
2023
Operating
Profit
S
Percent
100.00 % S
46.67
53.33 % S
$
10,500
0
-10500
-21000
Change
Required 1 >
Transcribed Image Text:Required: 1. Using the data from 2022 in Gaming Table Cost Data, create an Excel spreadsheet to provide a sensitivity analysis of the effect on operating profit of potential changes in demand for HFI Incorporated, ranging from a 20 percent decrease to a 20 percent increase. Use Contribution Income Statements and What-If Sensitivity Analysis as a guide. Assume that two-thirds of fixed costs are manufacturing related; the remaining one-third are selling-related. The variable manufacturing cost per unit is $30, while the variable selling cost per unit is $5. (Hint: Calculate the DOL for 2022 at a sales volume of 3,000 units.) 2. Using the spreadsheet you created, compute the new operating profit assuming a 10% decrease in demand. Complete this question by entering your answers in the tabs below. Gaming Table Contribution Income Statements What If Sensitivity Analysis Required 1 Required 2 Cost Data Per Unit 2022 84,000 Fixed costs (per year) Selling price Variable cost Planned production Planned sales volume Gaming Table Required 1 Cost Data Percent Notes Sales $ 225,000 100.00 % $ 247,500 22,500 Variable costs 105,000 115,500 10,500 46.67 53.33 % S Total contribution margin $ 120,000 84,000 132,000 84,000 12,000 53.33% is the contribution margin 0 Fixed costs Operating profit $ 36,000 $ 48,000 12,000 12,000=0.5333 × 22,500 Complete this question by entering your answers in the tabs below. What If Gaming Table Cost Data Contribution Income Statements Required 1 Required 2 Sensitivity Analysis Units Sold Variable Cost per Unit Fixed Costs S 30 S 84,000 75 35 84,000 75 40 84,000 75 45 84,000 75 <Contribution Income Statements 2,100 2,100 2,100 2,100 Contribution Income Statements S What If Sensitivity Analysis Amount 75 35 $ 2022 3,000 units 3,000 units Selling Price per Unit $ 2023 $ 84,000 3,300 units 3,300 units Required 2 Amount 2023 Operating Profit S Percent 100.00 % S 46.67 53.33 % S $ 10,500 0 -10500 -21000 Change Required 1 >
Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
Cost allocation
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
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