Inventory models

 

what is the best inventory model to use if the demand is not deterministic? please see attached file for the data under consideration. thanks.

Document Preview:

Sheet3
Sheet2
Sheet1
feb ’11
4 boxes
10 boxes
dec ’10
5 boxes
sep ’10
2 boxes
jul ’10
may ’10
jan ’10
3 boxes
s1(@ 9.00)
s2 (@ 17.00)
Month
Quantity
feb
mar
s1 = 288/box
s2 = 144/box
apr
Demand (pcs.)
may
jun
jul
aug
sep
oct
nov
dec
jan
Stock Replenishment
assumption : non-zero starting inventory
mean
stdev
feb
Supply is replenished every 2 to 3 months
stock replenishment
demand
1152.00
4.00
288.00
1440.00
10.00
144.00
1387.00
53.00
0.00
720.00
5.00
144.00
576.00
2.00
288.00
576.00
4.00
144.00
1152.00
4.00
288.00
720.00
5.00
144.00
576.00
2.00
288.00
576.00
4.00
144.00
864.00
3.00
288.00
432.00
3.00
144.00
5.00
55.00
864.00
432.00
15.00
60.00
0.00
0.00
113.00
255.00
0.00
0.00
150.00
220.00
0.00
0.00
126.00
233.00
576.00
576.00
80.00
315.00
0.00
0.00
140.00
170.00
1152.00
720.00
40.00
295.00
0.00
0.00
20.00
258.00
576.00
576.00
107.00
375.00
0.00
0.00
20.00
25.00
0.00
0.00
25.00
40.00
0.00
720.00
244.00
222.00
0.00
0.00
477.00
505.00
1152.00
1440.00
92.00
258.00
0.00
0.00
268.00
318.00
0.00
0.00
396.00
437.00
0.00
0.00
136.35
237.71
132.84
133.13
scotchtape 1″
scotchtape 2″
Month
Quantity
Demand
Sheet3
Sheet2
Sheet1
feb ’11
4 boxes
10 boxes
dec ’10
5 boxes
sep ’10
2 boxes
jul ’10
may ’10
jan ’10
3 boxes
s1(@ 9.00)
s2 (@ 17.00)
Month
Quantity
feb
mar
s1 = 288/box
s2 = 144/box
apr
Demand (pcs.)
may
jun
jul
aug
sep
oct
nov
dec
jan
Stock Replenishment
assumption : non-zero starting inventory
mean
stdev
feb
Supply is replenished every 2 to 3 months
stock…

Attachments:

data.xls

• Need a Professional Writer to Work on this Paper and Give you a 100 % Original Paper? Click Here and Get this Essay Done………………