Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

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

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_2

Step: 3

blur-text-image_3

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

Bookkeeping And Accounting For Beginners

Authors: Warren Piper Ruell

1st Edition

1654626090, 978-1654626099

More Books

Students also viewed these Accounting questions

Question

I didnt know who to talk to.

Answered: 1 week ago

Question

Th e complaint department was closed over the lunch hour.

Answered: 1 week ago

Question

Th ey probably would have treated me like a criminal.

Answered: 1 week ago