Business Modeling Simulation HW1

profileLmarshall11
newsvendor-1.xls
Home>Business & Finance homework help>Management homework help>Business Modeling Simulation HW1

Sheet1

Newsvendor Problem -- 30 Days
q = 100 q = 120 q = 140 q = 160 q = 180
INPUT DATA Day Demand Sold Scrap Profit Sold Scrap Profit Sold Scrap Profit Sold Scrap Profit Sold Scrap Profit
Wholesale price c = $0.55 1 131 100 0 45.00 120 0 54.00 131 9 54.27 131 29 43.87 131 49 33.47
Retail price r = $1.00 2 150 100 0 45.00 120 0 54.00 140 0 63.00 150 10 62.30 150 30 51.90
Scrap price s = $0.03 3 120 100 0 45.00 120 0 54.00 120 20 43.60 120 40 33.20 120 60 22.80
Demand parameter m = 135.70 4 133 100 0 45.00 120 0 54.00 133 7 56.21 133 27 45.81 133 47 35.41
Demand parameter s = 27.10 5 148 100 0 45.00 120 0 54.00 140 0 63.00 148 12 60.36 148 32 49.96
6 129 100 0 45.00 120 0 54.00 129 11 52.33 129 31 41.93 129 51 31.53
7 57 57 43 3.29 57 63 -7.11 57 83 -17.51 57 103 -27.91 57 123 -38.31
8 212 100 0 45.00 120 0 54.00 140 0 63.00 160 0 72.00 180 0 81.00
9 126 100 0 45.00 120 0 54.00 126 14 49.42 126 34 39.02 126 54 28.62
10 135 100 0 45.00 120 0 54.00 135 5 58.15 135 25 47.75 135 45 37.35
11 144 100 0 45.00 120 0 54.00 140 0 63.00 144 16 56.48 144 36 46.08
12 157 100 0 45.00 120 0 54.00 140 0 63.00 157 3 69.09 157 23 58.69
13 134 100 0 45.00 120 0 54.00 134 6 57.18 134 26 46.78 134 46 36.38
14 104 100 0 45.00 104 16 38.48 104 36 28.08 104 56 17.68 104 76 7.28
15 201 100 0 45.00 120 0 54.00 140 0 63.00 160 0 72.00 180 0 81.00
16 119 100 0 45.00 119 1 53.03 119 21 42.63 119 41 32.23 119 61 21.83
17 103 100 0 45.00 103 17 37.51 103 37 27.11 103 57 16.71 103 77 6.31
18 151 100 0 45.00 120 0 54.00 140 0 63.00 151 9 63.27 151 29 52.87
19 117 100 0 45.00 117 3 51.09 117 23 40.69 117 43 30.29 117 63 19.89
20 158 100 0 45.00 120 0 54.00 140 0 63.00 158 2 70.06 158 22 59.66
21 130 100 0 45.00 120 0 54.00 130 10 53.30 130 30 42.90 130 50 32.50
22 128 100 0 45.00 120 0 54.00 128 12 51.36 128 32 40.96 128 52 30.56
23 158 100 0 45.00 120 0 54.00 140 0 63.00 158 2 70.06 158 22 59.66
24 78 78 22 23.66 78 42 13.26 78 62 2.86 78 82 -7.54 78 102 -17.94
25 160 100 0 45.00 120 0 54.00 140 0 63.00 160 0 72.00 160 20 61.60
26 128 100 0 45.00 120 0 54.00 128 12 51.36 128 32 40.96 128 52 30.56
27 138 100 0 45.00 120 0 54.00 138 2 61.06 138 22 50.66 138 42 40.26
28 138 100 0 45.00 120 0 54.00 138 2 61.06 138 22 50.66 138 42 40.26
29 121 100 0 45.00 120 0 54.00 121 19 44.57 121 39 34.17 121 59 23.77
30 159 100 0 45.00 120 0 54.00 140 0 63.00 159 1 71.03 159 21 60.63
E(Profit/Day) 42.90 E(Profit/Day) 49.41 E(Profit/Day) 50.36 E(Profit/Day) 45.29 E(Profit/Day) 36.19
± 3.15 ± 5.04 ± 7.03 ± 8.80 ± 9.53
Prob(Loss) 0.00 Prob(Loss) 0.03 Prob(Loss) 0.03 Prob(Loss) 0.07 Prob(Loss) 0.07
Histogram Data Bin Tops Cum. Freq. Cum. Freq. Cum. Freq. Cum. Freq. Cum. Freq.
-40 0 0 0 0 0 0 0 0 0 0
-20 0 0 0 0 0 0 1 1 1 1
0 0 0 1 1 1 1 2 1 2 1
20 1 1 2 1 2 1 4 2 5 3
40 2 1 4 2 4 2 9 5 17 12
60 30 28 30 26 17 13 20 11 26 9
80 30 0 30 0 30 13 30 10 28 2
100 30 0 30 0 30 0 30 0 30 2

Sheet1

3.14877918 3.14877918
5.0398059434 5.0398059434
7.0332145284 7.0332145284
8.8019184585 8.8019184585
9.5295917822 9.5295917822
q (papers)
Mean Daily Profit ($)