(1) Chap 3 Forecasting, Analytics Exercise: Starbucks Corp, (p 91): Q #1, #3, #4 (18 pts). Please show all your work and summarize your answers using the following table.

3-week moving avg	ATL	BOS	CHI	DAL	LA	Sum of DCs	Aggregating demand at one single DC
MAD
MAPE
TS
5-week moving avg	ATL	BOS	CHI	DAL	LA	Sum of DCs
MAD
MAPE
TS

(2) Chap 10 Quality Management, Analytics Exercise: Tesla, Part B: Quality Control Analytics (p 350) (16 pts)

Observation

^Sample 1 2 3 4 5 6 7 8 9 10

1 1.9 2.0 1.9 1.8 2.2 1.7 2.0 1.9 1.7 1.8

2 1.8 2.2 2.1 2.2 1.9 1.8 2.1 1.6 1.8 1.6

3 2.1 2.4 2.2 2.1 2.1 2.0 1.8 1.7 1.9 1.9

4 2.1 2.0 2.4 1.7 2.2 2.0 1.6 2.0 2.1 2.2

(a) Setup X-bar and Range (R) control charts for the current process. Assume the operators took four samples of 10 washers (n=10, k=4) at a time. Use Exhibit 10.13 (p331) to obtain A2, D3, and D4 values. (8 pts)

(b) Plot the data on your control charts. Does the current process appear to be in control? Explain. (Remember: you have only four samples) (4 pts)

(c) If upper and lower specifications are 2.4 and 1.4, what is the process capability index (C_pk)? Is the current process capable if the critical value is 1.33? (Note: you can compute the grant average X-bar bar = 1.96 and std deviation = .21.) (4 pts)