Submitted by: Submitted by maggie2013
Views: 131
Words: 2848
Pages: 12
Category: Business and Industry
Date Submitted: 10/27/2013 11:19 AM
Al
B Id El
D
F
dj
H
_I
IJIKILIMIN
2
j
Whirlpool Europe 2000 2,271 5477,784 S418,925 $58,859 S210.37 Si 84.46 525.92 t2.3° 45 51,648 45 51,648 45 51,648 45 51,648 45 51,648 45 51,648 * i2.30 12.3 12.3 12.3° l2.3°n S210.37 S184.46 S25.92 S210.37 5184.46 S25.92 S210.37 Si 84.46 S25.92 5210.37 SI 84.46 S25.92 S210.37 Si 84.46 S25.92 2,271 S477,784 S418,925 $58,859 2,271 S477,784 S418,925 $58,859 2,271 S477,784 S418,925 $58,859 2,271 S477,784 S418,925 $58,859 2,271 * S477,784 * S418,925 * $58,859 * 2001 2002 2003 2004 2005
3
4
Income Statement - West Wave
6 7 8 9
Units sold (cx. 3) Revenue (cx. 3) Cost of salcs(calc) 61-09 Gross margin (cx. 3
Price per Unit (calc) 01
11 12 13
Cost of sales per Unit (calgi D Marginpcrunitcalc) oqfo6
O
15
Percentage margin calc
Di
0
17
DSI (cx. 3)
18
Inventory (calc) cii
13i5 a
_________
19
Impact of the ERP System Cumulative additional units (see below) Cumulative margin increase (cx. 5) Cumulative reduction in DSI ga.9.sc C SO 36 0.06% 3.0 2000 2,307 S485,357 S425,274 $60,083 S210.37 5184.33 S26.04
i2.40o
93 0.25% 7.8 2001 2,364 S497,349 S434,836 $62,513 52111.37 S183.93 S26.44 12.6°x 37.2 44,318 33 40,145 33 40,145 l2.6°6 12.6°o I2.6°o 33 40,145 S210.37 S183.93 S26.44 S210.37 S183.93 S26.44 5211)37 S183.93 S26.44 S210.37 S183.93 S26,44 I2.6°o 33 40,145 * 2,414 S507,867 S444,033 $63,835 2,414 S507,867 S444,033 $63,835 2,414 5507,867 S444,033 $63,835 2,414 * S507,867 * S444,033 * $63,835 * 2002 2003 2004 2005
20 22 23 24 25 26 143 0.25% 12.0 143 0.25% 12.0 143 0.25% 12.0 143 0.25% 12.0
Assumed reduction ri DSI
28 29 30 31
33 34 35 42 48,936
______________________________________ Forecast with the ERP System Units sold Dl + 030 a 03 3 Revenue Cost of sales oi.0' a Gross margin Price per unit Ott Cost of sales per unit D33 P3
Margin per unit o33
37
Percentage margin DiS
b 31 0
39
DSI Oil -oa Inventory
° 0.30...