Prob 7.4a

# Prob 7.4a - Prob7. CostData ReservedMeal ExtraMeal \$18.00...

This preview shows pages 1–4. Sign up to view the full content.

Prob 7.4a Simulation of Wedding Reception using Excel Only Cost Data ReservationsAverage Total Costs Reserved Meal  \$18.00   \$2,933.50  Extra Meal  \$25.00  140  \$3,018.40  145  \$2,983.65  Demand Distribution- Binomial 150  \$2,951.30  Invited 200 155  \$2,929.30  P(Show up) 0.8 160  \$2,933.50  165  \$2,981.85  Decision Variable 170  \$3,061.15  Reservations 160 175  \$3,150.15  180  \$3,240.00  Average Cost 2933.5 Iteration Guests Total Cost 1 144 0 2880 0 2880 2 166 6 2880 150 3030 3 156 0 2880 0 2880 4 168 8 2880 200 3080 5 157 0 2880 0 2880 6 172 12 2880 300 3180 7 164 4 2880 100 2980 8 146 0 2880 0 2880 9 148 0 2880 0 2880 10 161 1 2880 25 2905 11 153 0 2880 0 2880 12 167 7 2880 175 3055 13 157 0 2880 0 2880 14 155 0 2880 0 2880 15 162 2 2880 50 2930 16 162 2 2880 50 2930 17 162 2 2880 50 2930 18 158 0 2880 0 2880 19 159 0 2880 0 2880 20 168 8 2880 200 3080 21 161 1 2880 25 2905 22 163 3 2880 75 2955 23 169 9 2880 225 3105 24 161 1 2880 25 2905 25 158 0 2880 0 2880 26 166 6 2880 150 3030 27 158 0 2880 0 2880 28 156 0 2880 0 2880 Extra meals  needed Reserved  Meal Cost Extra Meal  Cost Every simula will be differe but 155 com the most ofte the lowest average tota

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
29 153 0 2880 0 2880 30 160 0 2880 0 2880 31 154 0 2880 0 2880 32 153 0 2880 0 2880 33 157 0 2880 0 2880 34 159 0 2880 0 2880 35 151 0 2880 0 2880 36 162 2 2880 50 2930 37 159 0 2880 0 2880 38 166 6 2880 150 3030 39 162 2 2880 50 2930 40 159 0 2880 0 2880 41 158 0 2880 0 2880 42 163 3 2880 75 2955 43 157 0 2880 0 2880 44 163 3 2880 75 2955 45 168 8 2880 200 3080 46 170 10 2880 250 3130 47 157 0 2880 0 2880 48 161 1 2880 25 2905 49 158 0 2880 0 2880 50 163 3 2880 75 2955 51 160 0 2880 0 2880 52 168 8 2880 200 3080 53 159 0 2880 0 2880 54 159 0 2880 0 2880 55 160 0 2880 0 2880 56 165 5 2880 125 3005 57 157 0 2880 0 2880 58 165 5 2880 125 3005 59 150 0 2880 0 2880 60 159 0 2880 0 2880 61 157 0 2880 0 2880 62 155 0 2880 0 2880 63 161 1 2880 25 2905 64 161 1 2880 25 2905 65 162 2 2880 50 2930 66 162 2 2880 50 2930 67 156 0 2880 0 2880 68 147 0 2880 0 2880 69 159 0 2880 0 2880 70 166 6 2880 150 3030 71 159 0 2880 0 2880 72 166 6 2880 150 3030 73 161 1 2880 25 2905
74 164 4 2880 100 2980 75 160 0 2880 0 2880 76 160 0 2880 0 2880 77 163 3 2880 75 2955 78 165 5 2880 125 3005 79 149 0 2880 0 2880 80 151 0 2880 0 2880 81 161 1 2880 25 2905 82 160 0 2880 0 2880 83 171 11 2880 275 3155 84 171 11 2880 275 3155 85 169 9 2880 225 3105 86 159 0 2880 0 2880 87 164 4 2880 100 2980 88 156 0 2880 0 2880 89 157 0 2880 0 2880 90 165 5 2880 125 3005 91 163 3 2880 75 2955 92 161 1 2880 25 2905 93 147 0 2880 0 2880 94 156 0 2880 0 2880 95 154 0 2880 0 2880 96 162 2 2880 50 2930 97 166 6 2880 150 3030 98 158 0 2880 0 2880 99 162 2 2880 50 2930 100 157 0 2880 0 2880 101 155 0 2880 0 2880 102 152 0 2880 0 2880 103 154 0 2880 0 2880 104 164 4 2880 100 2980 105 165 5 2880 125 3005 106 162 2 2880 50 2930 107 156 0 2880 0 2880 108 161 1 2880 25 2905 109 160 0 2880 0 2880 110 157 0 2880 0 2880 111 162 2 2880 50 2930 112 149 0 2880 0 2880 113 164 4 2880 100 2980

This preview has intentionally blurred sections. Sign up to view the full version.

View Full Document
This is the end of the preview. Sign up to access the rest of the document.

{[ snackBarMessage ]}

### Page1 / 24

Prob 7.4a - Prob7. CostData ReservedMeal ExtraMeal \$18.00...

This preview shows document pages 1 - 4. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online