Solve using formulas- excel problems-Quantitative Assignment

NewModule8ProblemWorkbook.xlsx

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

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

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