Potomac University Delivery Times at Snow Pea Restaurant Case Discussion & Sheet Requirements. Chapter 8, Case 8.3 Delivery Times at Snow Pea Restaurant.

Potomac University Delivery Times at Snow Pea Restaurant Case Discussion & Sheet Requirements.

Chapter 8, Case 8.3 Delivery Times at Snow Pea Restaurant. I’ve attached the question in as chapter 8 and chapter case study (Please check the two images for questions). Case file is inn excel C08_03.xlsx

Please answer all the questions in chapter 8 case 3.1 Delivery Times at Snow Pea Restaurant. Check both the pages 366 and 367.

Must submit an APA formatted paper answering the questions

Must embed excel answers in the APA formatted paper

Must have abstract and conclusion

Must be properly cited & referenced

Plagiarism less than 10% Order
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
Deliverer
3
1
1
3
2
2
2
3
2
1
1
2
1
1
2
3
1
1
1
2
4
3
4
1
4
2
3
1
2
4
1
2
1
3
4
2
4
3
4
1
3
2
3
Prep Time
13.0
10.9
9.2
7.2
14.5
9.5
7.1
8.5
9.8
14.3
12.0
13.0
14.9
9.7
10.0
10.8
12.1
9.9
7.9
17.2
10.2
15.0
12.5
11.0
15.7
10.1
8.2
9.2
18.7
11.0
9.3
10.1
11.4
18.0
14.0
15.4
6.1
13.9
9.5
10.3
14.4
9.4
6.6
Travel Time
30.0
17.8
9.2
14.7
21.9
8.1
31.6
29.0
4.9
13.4
12.9
8.8
8.7
29.9
18.2
22.9
5.0
9.9
9.0
6.5
29.3
24.0
19.5
10.5
29.0
2.6
19.0
13.4
8.9
9.3
22.8
14.5
26.1
10.8
28.8
21.2
6.9
21.9
17.8
9.5
29.7
23.5
17.0
Distance
13.3
8.6
4.7
4.3
12.2
3.6
11.3
10.3
2.6
5.3
4.5
4.1
4.2
11.7
9.5
8.8
1.7
4.5
3.7
3.4
3.4
9.8
5.4
5.0
7.9
1.4
7.5
7.0
5.6
2.2
8.2
7.7
12.9
3.8
11.7
10.7
2.8
8.4
4.6
4.3
6.9
12.2
6.3
This is fictitious data.
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
4
2
1
1
4
1
1
1
3
4
4
4
1
4
4
4
1
3
3
3
4
3
2
2
3
2
2
1
3
1
1
1
2
15.6
9.7
14.0
11.7
12.7
14.6
9.5
7.1
8.5
9.9
14.3
12.0
13.0
16.2
10.3
8.5
9.5
13.1
8.4
17.0
14.2
8.8
12.9
10.9
9.7
13.4
8.7
17.3
7.0
9.0
13.1
11.0
12.0
18.5
13.8
5.3
3.3
0.7
1.9
12.6
7.2
7.3
26.2
28.7
23.1
12.6
28.3
9.4
29.8
21.6
10.1
24.1
6.0
18.6
13.6
29.5
17.8
23.8
18.9
7.0
16.6
31.3
3.5
11.9
11.6
7.5
5.9
9.2
2.5
1.4
0.2
0.6
6.5
3.3
3.0
5.2
8.9
7.7
7.2
8.2
4.1
13.0
11.6
3.1
5.8
2.8
2.4
4.6
14.0
6.9
6.4
10.1
2.9
9.3
8.6
1.5
4.4
3.6
3.3
CASE 8.3 Delivery Times at SnowPea Restaurant
The Snow Pea Restaurant is a Chinese carryout/delivery
restaurant. Most of Snow Pea’s deliveries are within a 10-mile
radius, but it occasionally delivers to customers more than 10
miles away. SnowPea employs a number of delivery people,
four of whom are relatively new hires. The restaurant has
recently been receiving customer complaints about exces-
sively long delivery times. Therefore, Snow Pea has collected
data on a random sample of deliveries by its four new deliv-
ery people during the peak dinner time. The data are in the
file C08_03.xlsx. The variables are as follows:
• Deliverer: which person made the delivery
Prep Time: time from when order was placed until deliv-
ery person started driving it to the customer
• Travel Time: time to drive from Snow Pea to customer
• Distance: distance (miles) from Snow Pea to customer
Solve the following problems and then, based on your
analysis, write a report that makes reasonable recommenda-
tions to Snow Pea management.
1. Snow Pea is concerned that one or more of the new
delivery people might be slower than others.
a. Let Mpi and uri be the mean delivery time and mean
total time for delivery person i, where the total time is
the sum of the delivery and prep times. Calculate 95%
confidence intervals for each of these means for each
delivery person. Although these might be interesting,
give two reasons why they are not really fair measures
for comparing the efficiency of the delivery people.
b. Responding to the criticisms in part a, calculate a 95%
confidence interval for the mean speed of delivery
for each delivery person, where speed is measured as
.
Conclusion
367
miles per hour during the trip from Snow Pea to the
customer. Then calculate 95% confidence intervals for
the mean difference in speed between each pair of de-
livery people.
2. Snow Pea would like to advertise that it can achieve a to-
tal delivery time of no more than M minutes for all cus-
tomers within a 10-mile radius. On all orders that take
more than M minutes, SnowPea will give the customers
a $10 certificate on their next purchase.
a. Assuming for now that the delivery people in the sam-
ple are representative of all of SnowPea’s delivery
people, calculate a 95% confidence interval for the
proportion of deliveries (within the 10-mile limit) that
will be on time if M = 25 minutes; if M = 30 min-
utes; if M = 35 minutes.
b. Suppose Snow Pea makes 1000 deliveries within the
10-mile limit. For each of the values of M in part a,
calculate a 95% confidence interval for the total dollar
amount of certificates it will have to pay for being late.
3. The policy in the previous problem is simple to state and
simple to administer. However, it is somewhat unfair to
customers who live close to Snow Pea—they will never
get $ 10 certificates. A fairer, but more complex, policy
is the following. SnowPea first analyzes the data and
finds that total delivery times can be predicted fairly well
with the equation
Predicted Delivery Time = 14.8 + 2.06*Distance
(This is based on regression analysis, the topic of
Chapters 10 and 11.) Also, most of these predictions are
within 5 minutes of the actual delivery times. Therefore,
whenever Snow Pea receives an order over the phone, it
looks up the customer’s address in its computerized ge-
ographical database to find distance, calculates the pre-
dicted delivery time based on this equation, rounds this
to the nearest minute, adds 5 minutes, and guarantees
this delivery time or else a $10 certificate. It does this for
all customers, even those beyond the 10-mile limit.
a. Assuming again that the delivery people in the sample
are representative of all of Snow Pea’s delivery people,
calculate a 95% confidence interval for the proportion
of all deliveries that will be within the guaranteed total
delivery time.
b. Suppose Snow Pea makes 1000 deliveries. Calculate a
95% confidence interval for the total dollar amount of
certificates it will have to pay for being late.

Purchase answer to see full
attachment