Whirpool Case

Submitted by: Submitted by

Views: 131

Words: 2848

Pages: 12

Category: Business and Industry

Date Submitted: 10/27/2013 11:19 AM

Report This Essay

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...