Solve using formulas- excel problems-Quantitative Assignment
P696-10-Slow
| Renting a copier | ||||||||
| Inputs (for slow system) | ||||||||
| Unit of time | hour | |||||||
| Arrival rate | 1 | customers/hour | ||||||
| Service rate | 2 | customers/hour | ||||||
| Outputs | ||||||||
| Direct outputs from inputs | Distribution of number in system | Distribution of time in queue | ||||||
| Mean time between arrivals | 1.000 | hours | n (customers) | P(n in system) | t (in hours) | P(wait > t) | ||
| Mean time per service | 0.500 | hours | 4 | 0.031 | 2.000 | 0.068 | ||
| Traffic intensity | 0.500 | |||||||
| Summary measures | ||||||||
| Expected number in system | 1.000 | customers | ||||||
| Expected number in queue | 0.500 | customers | ||||||
| Expected time in system | 1.000 | hours | ||||||
| Expected time in queue | 0.500 | hours | ||||||
| Percentage who don't wait in queue | 50.0% | |||||||
| Cost analysis | ||||||||
| Employee cost/hr | ||||||||
| Rental cost/hour | ||||||||
| Waiting cost/hour | ||||||||
| Total Cost/hour | ||||||||
Problem 11.11
P696-10-Fast
| Renting a copier | ||||||||
| Inputs (for slow system) | ||||||||
| Unit of time | hour | |||||||
| Arrival rate | 1 | customers/hour | ||||||
| Service rate | 2 | customers/hour | ||||||
| Outputs | ||||||||
| Direct outputs from inputs | Distribution of number in system | Distribution of time in queue | ||||||
| Mean time between arrivals | 1.000 | hours | n (customers) | P(n in system) | t (in hours) | P(wait > t) | ||
| Mean time per service | 0.500 | hours | 4 | 0.031 | 2.000 | 0.068 | ||
| Traffic intensity | 0.500 | |||||||
| Summary measures | ||||||||
| Expected number in system | 1.000 | customers | ||||||
| Expected number in queue | 0.500 | customers | ||||||
| Expected time in system | 1.000 | hours | ||||||
| Expected time in queue | 0.500 | hours | ||||||
| Percentage who don't wait in queue | 50.0% | |||||||
| Cost analysis | ||||||||
| Employee cost/hr | ||||||||
| Rental cost/hour | ||||||||
| Waiting cost/hour | ||||||||
| Total Cost/hour |
Problem 11.11
P764-32
| Day | Peak Load Christopher J. Zappe, Ph.D.: In megawatts. | Daily High Temperature Christopher J. Zappe, Ph.D.: In degrees F. |
| 1 | 118.5 | 89 |
| 2 | 136.0 | 94 |
| 3 | 143.6 | 100 |
| 4 | 153.2 | 97 |
| 5 | 140.7 | 95 |
| 6 | 151.9 | 100 |
| 7 | 135.1 | 92 |
| 8 | 178.2 | 106 |
| 9 | 101.6 | 67 |
| 10 | 96.5 | 67 |
| 11 | 103.9 | 74 |
| 12 | 113.4 | 84 |
| 13 | 106.2 | 79 |
| 14 | 111.4 | 85 |
| 15 | 116.5 | 89 |
| 16 | 96.3 | 68 |
| 17 | 150.1 | 98 |
| 18 | 105.1 | 86 |
| 19 | 114.7 | 87 |
| 20 | 189.3 | 108 |
| 21 | 131.7 | 96 |
| 22 | 100.9 | 76 |
| 23 | 92.5 | 71 |
| 24 | 132.0 | 90 |
| 25 | 116.4 | 88 |
P764-35
| Month | Advertising | Units Sold |
| 1 | $1,000 | 4,000,000 |
| 2 | $2,000 | 4,800,000 |
| 3 | $3,000 | 5,000,000 |
| 4 | $20,000 | 7,500,000 |
| 5 | $30,000 | 8,000,000 |
| 6 | $50,000 | 9,000,000 |
| 7 | $80,000 | 9,900,000 |
| 8 | $100,000 | 10,200,000 |