New Microsoft Office Excel Worksheet

New Microsoft Office Excel Worksheet - 1, Erdmann Sale...

Info iconThis preview shows pages 1–4. Sign up to view the full content.

View Full Document Right Arrow Icon
1, Erdmann 8900 7600 Sale 836600 714400 Variable 551800 471200 243200 2, Mitch Corp Sales 828000 Variable cost 554760 0.67 Contribution m 273240 0.33 Fixed cost 82000 Net operating 191240 3, Riven Corp per unit Sale 1620000 15 Variable 540000 7.5 Contribution 540000 Fixed Expense 284000 Net Operating 256000 4, Contribution m ratio Contribution/ Sale 0.43 Break even Contribution margin per unit contribution margin / unit sold Fixed Expense/ Contribution M per unit Increase in net operating income 3840 d (fixed exp + net income)/64 11600 e Sales per unit 148
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Multiply breakeven 902800 740000 f DOL 2.22 5, Ringstaff 260 Units * Contribution M of 115.2 per unit 29952 28952 1000 6, breakeven Sale 9000 Sale price 18 var Exp 12 Contribution 3000 6 Fixed 3000 7, Hilty U77D D86D Sale 44200 64800 Variable 14450 28060 Fix exp/ contribution m 76200 9, Contribution / Sale 0.48
Background image of page 2
10050 67000 65000 104500 23000 269550 cash receive 65000 Razor Revenue Variance Flexible Revenue 102060 Spending Wages 22640
Background image of page 3

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 4
This is the end of the preview. Sign up to access the rest of the document.

This note was uploaded on 05/10/2011 for the course IBUS 1301 taught by Professor Dj during the Spring '11 term at Richland Community College.

Page1 / 18

New Microsoft Office Excel Worksheet - 1, Erdmann Sale...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online