Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Hi, I need some help finishing this analysis under break-even variable costs. please include formulas and excel functions if used. Fixed Costs $174,977.40 Product Information

Hi, I need some help finishing this analysis under break-even variable costs. please include formulas and excel functions if used.

image text in transcribed

Fixed Costs $174,977.40 Product Information Unit Sales Price Units Manufactured and Sold Sales Mix (% of total units sold) WB500 $325.00 5190 60% WB660 $480.00 3425 40% Vary-with-Revenue Costs Sales Commissions 3.5% Weighted Average Contribution Margin Break Even Units (weighted) $189.80 922 Vary with Unit Costs Direct Material Direct Labor Other Vary-with-Unit Costs Total Vary with Unit Costs WB500 $96.79 $42.00 $16.84 $155.63 WB660 $150.99 $56.00 $18.22 $225.21 Break Even Variable Costs Direct Material Direct Labor Other Vary-with-Unit Costs Sales Commissions Total Variable Costs Break Even Analysis Contribution Margin Per Unit WB500 $158.00 WB660 $237.99 $0.00 Break Even Point in Units/Product Break Even in Sales Dollars 1107 $359,933.26 735 $352,910.42 Break Even Contribution Margin Break Even 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

Financial And Managerial Accounting

Authors: John J Wild

6th Edition

1259621758, 978-1259621758

More Books

Students also viewed these Accounting questions