Chapter 6: Using Excel to Make Decisions at Current Designs Part 1 (a, b)
Data
Rotomolded Composite Total
Sales price/unit
$950 $2,000
Variable costs/unit
$570 $1,340
Required
Follow the step-by-step directions to perform cost-volume-profit analysis for multiple products.
(a)
Rotomolded
Kayaks
Composite
Kayaks
Break-even distribution:
Before
Rounding
After
Rounding
Rotomolded kayaks 1,504.80 1,505
Weighted
Average Unit
Contribution
Margin
Chapter 6: Using Excel to Make Decisions at Current Designs Part 1 (c)
Data
Rotomolded Composite Total
Sales price/unit
$950 $2,000
Variable costs/unit
$570 $1,340
Total fixed costs $820,000
Required
Follow the step-by-step directions to perform cost-volume-profit analysis for multiple products.
(a)
Rotomolded
Kayaks
Composite
Kayaks
(b) Break-even point in units 6,077.59
Break-even units rounded 6,078
Break-even distribution:
Before
Rounding
After
Rounding
Weighted
Average Unit
Contribution
Margin
Chapter 6: Using Excel to Make Decisions at Current Designs Part 1 (d, e)
Data
Rotomolded Composite Total
Sales revenue
$950 $2,000 $3,000,000
Required
Follow the step-by-step directions to perform cost-volume-profit analysis for multiple products.
Part 2
Rotomolded Composite
Sales 2,000,000$ 1,000,000$
Chapter 6: Using Excel to Make Decisions at Current Designs Part 2
Data
Rotomolded Composite Total
Sales revenue
$950 $2,000 $3,000,000
Variable costs/unit
$570 $1,340
Allocated fixed costs $660,000 $160,000 $820,000
Sales mix:
Required
Follow the step-by-step directions to perform cost-volume-profit analysis for multiple products.
(d)
Rotomolded Composite
Sales 2,400,000$ 600,000$
Variable costs 1,440,000 402,000
Contribution margin 960,000 198,000
Fixed costs 660,000 160,000