Answered step by step
Verified Expert Solution
Question
1 Approved Answer
How do we find the following under break even analysis when the only variable costs we know of is the %? ACCG200 2018 S2 Excel
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+ ReadyStep 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