Simulation on Excel

profilel3o0hd_s
Problem1617Studentworksheet3.xlsx
Home>Mathematics homework help>Statistics homework help>Simulation on Excel

Sheet1

Time Beginning Random Demand Sold Ending Inv. Position Lost Place Random Lead Carrying Costs Lost Sales Ordering Costs Total Cost Demand for Mercedes Freq. Probability Cumulative Probability Random # Interval
1 30 1
2 47 6 3 0.083 0.083 00-08
3 96 79 7 4 0.111
4 16 8 6 0.167
5 85 9 12 0.333
6 45 10 9 0.25
7 42 46 11 1 0.028
8 48 12 1 0.028
9 33 36
10 48 70
11 10
12 50
13 74 59 Lead Prob. Cumulative Probability Random # Interval
14 88
15 46 1 0.44
16 81 87 2 0.33
17 16 3 0.16
18 44 4 0.07
19 25
20 25 91 Ordering amount Reorder Point
21 2 14 12
22 9
23 5
24 29 86
201 108 73 93 43800 404550 3990 452340