{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

New Microsoft Office Excel Worksheet

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

Info iconThis preview shows pages 1–5. 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 Document Right 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 Document Right Arrow Icon
Expendable 32960 Facility 19992 Admin 10216 Total Expense Enriques Activities Variances 7 Variable 5300 5280 Budget Flexible Bug Variable 37100 36960 140 Selling 131980 131968 12 Revenue 244330 243408 922 Spending Directlabor Direcct material Manufacture Overhead Admin Expense
Background image of page 4
Image of page 5
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}