Use the contribution margin approach to compute the Julie's monthly breakeven in units.

$\backslash$table$[[$Breakeven in Units,Round up to the neare,number$],[$Use the contribution margin ratio approach to compute the breakeven point in sales dollars.$],[$Contribution margin ratio,Round to $2$ decimals,$],[$Breakeven in Dollars,Round to the nearest whole dollar$]]$

Use the contribution margin approach to compute the monthly sales level $($in units$)$ required to earn a target operating income of $$10,000.$ Cost Classification

Variable

Fixed Julie wants to know if she will be able to sell enough wedding cakes each month to be able to

pay the bills. Use the expenses listed in #$1$ and the selling price of cakes in #$2$ to categorize the

business costs as Variable or Fixed in Excel.

After categorizing the expenses, calculate the estimated number of wedding cakes that Julie will

need to sell to breakeven, assuming she will produce $60$ cakes in the first month.

If Julie wants to make a profit of $$10,000,$ how many wedding cakes would she need to sell?

If Julie thinks she is likely to sell $50$ cakes, what will her operating income be$?$Requirement $4$

Identify the following as either a variable or fixed cost and the corresponding amount

Calculate the total variable and fixed cost, then calculate the variable cost per unit and gather the data needed to find breakeven in units.

Total Variable Costs

Wedding Cakes Produced

Variable Cost per Wedding Cake

Round to two decimals

Total Fixed Costs

Round to two decimals

Round to two decimals