Breakeneven worksheet 2 2011

Breakeneven worksheet 2 2011 - BEU x SP = BER TUG x VC =...

Info iconThis preview shows page 1. Sign up to view the full content.

View Full Document Right Arrow Icon
Sample Breakeven Analysis Exercise Table This table was created as a recording grid to record the totals following the calculations of each of the elements at the head of each column. Use the “Breakeven Analysis Checklist” distributed earlier to translate the coded titles at the top of each column. Note and use the formulas on the checklist to help you complete your calculations. __FC __ FC BE = SP – VC = MU = BEU TUG x SP = TRG TVCBEU + TVCPPU = TVCG __PP__ PP PPU = SP – VC = MU = PPU
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: BEU x SP = BER TUG x VC = TVCG BEU + PPU = TUG PPU x SP = PPR BEU x VC = TVCBEU BER + PPR = TRG PPU x VC = TVCPPU TRG – (TVC + TFC) = ??? Fixed Cost: $ 580,000 Projected Profit: $ 95,800 Product CC% SP% VC$ CC$FC CC$PP MU $ BEU BER $ PPU PPR $ TVCBE $ TVCPP $ TVC $ TUG TRG $ A 18 35 22 104,400 17,244 13 8,031 281,085 1,327 46,445 176,682 29,194 205,876 9358 327,530 B 28 62 41 C 14 47 21 D 10 28 12 E 30 90 64 Totals 100% xxx xxx $580,000 $ 95,800 xxx xxx $ xxx $ $ $ $ xxx $...
View Full Document

This note was uploaded on 08/30/2011 for the course BUS 121 taught by Professor Staff during the Spring '11 term at Community College of Philadelphia.

Ask a homework question - tutors are online