Prepare an Excel worksheet that illustrates cost-volume-profit (CVP) analysis, also referred to as breakeven analysis. Assume that a particular product sold at Astro Ltd a US toy company has a sales price per unit of $4.00; variable cost per unit of $2.20; and total fixed cost of $90,000. 1) Calculate the contribution margin per unit, the break-even point in units of sales, and the break-even point in dollars of sales. In the input area, show sales price per unit, variable cost per unit, and total fixed cost. In the output area, show contribution margin per unit, breakeven point in units, and breakeven point in dollars computed using appropriate formulas. 2) Assume that the planning team at Astro Ltd estimates that for the next planning period selling price for this product will increase 40%; variable expenses will decrease 25%; and that total fixed cost will decrease 25%. Compute the new values for sales price per unit, variable cost per unit, and total fixed costs and then show contribution margin per unit, breakeven point in units, and breakeven point in dollars. Please do question 2
Prepare an Excel worksheet that illustrates cost-volume-profit (CVP) analysis, also referred to as breakeven analysis. Assume that a particular product sold at Astro Ltd a US toy company has a sales price per unit of $4.00; variable cost per unit of $2.20; and total fixed cost of $90,000.
1)
Calculate the contribution margin per unit, the break-even point in units of sales, and the break-even point in dollars of sales. In the input area, show sales price per unit, variable cost per unit, and total fixed cost. In the output area, show contribution margin per unit, breakeven point in units, and breakeven point in dollars computed using appropriate formulas.
2)
Assume that the planning team at Astro Ltd estimates that for the next planning period selling price for this product will increase 40%; variable expenses will decrease 25%; and that total fixed cost will decrease 25%.
Compute the new values for sales price per unit, variable cost per unit, and total fixed costs and then show contribution margin per unit, breakeven point in units, and breakeven point in dollars.
Please do question 2
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
