You will be using Microsoft Excel to answer this question. Follow the steps below to complete the question.Click here to view a brief video demonstrating downloading the Excel file, completing your work in either Excel or Google Sheets, and uploading your response file successfully, with troubleshooting. Alternatively, see written instructions here.

?

Transcribed Image Text:

1 Formula: Multiply, Divide, Subtract; Cell Referencing 2 3 E3.2 - Using Excel for Breakeven Analysis Student Work Area 4 PROBLEM Required: Provide input into cells shaded in yellow in this template, 5 Scott Confectionery sells Stack-o-Choc candy bars, Information 6 concerning the candy bars is presented here. using mathematical formulas with cell references to the Problem area and the work area as indicated. 7 Selling price of each candy bar Variable cost per candy bar 8 0.80 9 0.45 a. What is the contribution margin per unit for the Stack-o-Choc candy 10 Total fixed costs 175,000 bar? 11 12 Contribution margin per unit 13 14 b. What is the contribution margin ratio for the Stack-o-Choc candy 15 bar? 16 17 Contribution margin ratio 18 19 c. What is the breakeven point in units? In sales dollars? 20 21 Breakeven point in units 22 23 Breakeven point in sales dollars 24 d. If an increase in chocolate prices causes the variable cost per unit to increase, what will happen to the breakeven point? 25 26 27 28 New variable cost per unit 0.55 29 30 New breakeven point in units 31 32 New breakeven point in sales dollars 33 The breakeven point will by 34 35 units 36 and by sales dollars 37 38 39 40 41 42 43 44 45 46 1 Formula: Multiply, Divide, Subtract; Cell Referencing 2 3 E3.2 - Using Excel for Breakeven Analysis Student Work Area 4 PROBLEM Required: Provide input into cells shaded in yellow in this template, 5 Scott Confectionery sells Stack-o-Choc candy bars, Information 6 concerning the candy bars is presented here. using mathematical formulas with cell references to the Problem area and the work area as indicated. 7 Selling price of each candy bar Variable cost per candy bar 8 0.80 9 0.45 a. What is the contribution margin per unit for the Stack-o-Choc candy 10 Total fixed costs 175,000 bar? 11 12 Contribution margin per unit 13 14 b. What is the contribution margin ratio for the Stack-o-Choc candy 15 bar? 16 17 Contribution margin ratio 18 19 c. What is the breakeven point in units? In sales dollars? 20 21 Breakeven point in units 22 23 Breakeven point in sales dollars 24 d. If an increase in chocolate prices causes the variable cost per unit to increase, what will happen to the breakeven point? 25 26 27 28 New variable cost per unit 0.55 29 30 New breakeven point in units 31 32 New breakeven point in sales dollars 33 The breakeven point will by 34 35 units 36 and by sales dollars 37 38 39 40 41 42 43 44 45 46

Answer rating: 100% (QA)

la contribution margin per unit sales price pee un... View the full answer