8_UNITED Phase 3

8_UNITED Phase 3 - $5,181,000 $6,953,125 $2,835,400...

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

View Full Document Right Arrow Icon
11/09/2011 16:58:38 United Instruments Phase 3 8e0ae95e4b185886fce0d23ae62e4d7369a3344d.xls Page 1 United Instruments - Phase 3 Budget Market Share Price Cost =(Actual) EM EI Total EM EI Total EM EI Total EM EI Total EM EI Total Market (units) 1,248,000 440,000 886,063 690,800 886,063 690,800 886,063 690,800 886,063 690,800 Share % 10% 15% 10% 15% 16% 9% 16% 9% 16% 9% Unit Sales 124,800 66,000 190,800 88,606 103,620 192,226 141,770 62,172 203,942 141,770 62,172 203,942 141,770 62,172 203,942 Price $40 $180 $40 $180 $40 $180 $30 $206 $30 $206 Cost-Var. $20 $50 $20 $50 $20 $50 $20 $50 $21 $54 -Fixed $8,548,000 $8,548,000 $8,548,000 $8,548,000 $7,576,000 Sales $4,992,000 $11,880,000 $16,872,000 $3,544,250 $18,651,600 $22,195,850 $5,670,800 $11,190,960 $16,861,760 $4,253,100 $12,807,432 $17,060,532 $4,253,100 $12,807,432 $17,060,532 Var. Cost $2,496,000 $3,300,000 $5,796,000 $1,772,125
Background image of page 1
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: $5,181,000 $6,953,125 $2,835,400 $3,108,600 $5,944,000 $2,835,400 $3,108,600 $5,944,000 $2,977,170 $3,357,288 $6,334,458 Contrib. Marg. $2,496,000 $8,580,000 $11,076,000 $1,772,125 $13,470,600 $15,242,725 $2,835,400 $8,082,360 $10,917,760 $1,417,700 $9,698,832 $11,116,532 $1,275,930 $9,450,144 $10,726,074 less Fix Costs 8,548,000 8,548,000 8,548,000 8,548,000 7,576,000 Profit $2,528,000 $6,694,725 $2,369,760 $2,568,532 $3,150,074 Variance: $4,166,725 $(4,324,965) $198,772 $581,542 $622,074 Mkt. EM $(723,875) Share EM $1,063,275 Price EM $(1,417,700) Var Mfg. EM $(141,770) $(1,220,070) EI $4,890,600 EI (5,388,240) EI $1,616,472 EI $(248,688) $870,144 Fixed Costs $972,000 $972,000 TOTAL VARIANCE $622,074 Fixed Costs-Mfg $342,000 $342,000 -Mktg $416,000 $416,000 -Admin $(334,000) $(334,000)-R&D $548,000 $548,000 $972,000...
View Full Document

This note was uploaded on 11/08/2011 for the course MA 827 taught by Professor Wain during the Summer '11 term at BC.

Ask a homework question - tutors are online