In B20 calculate the total Vary with Unit Costs percentage.

In E5 calculate the Contribution Margin per Unit for the product in B4. (This is the Unit Sales Price less the Variable Manufacturing Cost per unit and the Vary with Revenue costs).

In E6 calculate the break-even volume (in units). Apply an appropriate rounding function to get the answer to 0 decimal places

In E7 calculate the Break-Even Sales Value ($ value of break-even unit sales)

In E10 to E15 calculate the Break-Even Variable Costs

In E18 calculate the Break-Even Contribution Margin (contribution margin for the break-even units rather than just a single unit.)

In E19 calculate the Break-Even Profit Before Tax.

Pls provide function

Fixed Costs and Pricing for the Year Fixed Cost Items Rent Utilities Admin Costs Insurance AAAA $ $ $ $ Strata 56,300.00 13,450.00 26,000.00 12,750.00 $ Unit Sales Price Production Hours per Unit Unit Sales Estimate 4,465.00 4 330 D E A B Cost Volume Profit Analysis for Strata Bikes $ Product Name Unit Sales Price Unit Sales Estimate Total Fixed Costs Strata 4,465.00 330 108,500.00 Break-Even Analysis Contribution Margin Per Unit Break Even Volume in Units Break Even Sales Value $ Variable Costs per Unit Vary with Unit Costs Direct Labor Direct Material Factory Overhead Other Vary-with-Unit Costs Total Vary with Unit Costs $ $ $ $ $ 2,146.42 2,242.73 127.84 65.54 4,582.53 Break Even Variable Costs Direct Labor Direct Material Factory Overhead Other Vary-with-Unit Costs Sales Commissions Other Vary-with-Revenue Costs Total Variable Costs $ Vary-with-Revenue Costs Sales Commissions Other Vary-with-Revenue Costs Total Vary with Revenue Costs 4.5% 1.5% Contribution Margin Profit Before Tax