Question
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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started