Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

image text in transcribed

image text in transcribed

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Coffee Plus Math Equal To Audit

Authors: Marina Peters

1st Edition

B08BDSDFR6, 979-8654153418

More Books

Students also viewed these Accounting questions

Question

Evaluate the importance of diversity in the workforce.

Answered: 1 week ago

Question

Identify the legal standards of the recruitment process.

Answered: 1 week ago