60.1K

Verified Solution

Link Copied!

How do we find the following under break even analysis when the only variable costs we know of is the %?

ACCG200 2018 S2 Excel Assessment.xlsm a- Search Sheet Home Insert Page Layout Formulas DataReview View t Share e Trass procedura Calculate Now Insert Nutos.m ecently Financial Logical Text Cate & Lookup s wath & More Creste rem Si enmulas Checkingtions Cost Volume Profit Analysis Product Name Unit Sales Price Total Urits Sold Break-Even Analysi Cantributian Margin per Unit Break Even Volume in Urits Broak EvenSlos Value 4900.00 350 Variable Manufacturing Casts Direct Material Direct Labour Factory Overhead Other Variable Manufacturing Costs Total Variable Manufacturing Costs 1,877.22 120.00 Fhed Cost Items 9 Rent 10 tlities 11 Acrmin Costs 12 Loan Repayments 50,000.00 5 14,100.00 22,600.00 68,280.00 1250.0n 167480.00 riable Selling and Admin Casts 5a es Commission5 Variable Admin Conts Total Variable Seling and Adrmin Costs Break Even Variable Costs Direct Material Direct Labour arable Factary Overhead Other Varable Manufacturing Costs 5.0% 14 TtalRxed Costs 15 6.5% Varable Admin Costs Total Variable Costs 17 18 State Tax Federal Tax 10 056 Contribution Margin Prafit Before Incame Tax 21 26 28 30 Inrmaan Labour Costs CVP Analysis Potit Voluma Forecast Invantary+ Ready

Answer & Explanation Solved by verified expert

See Answer