1.    Food trucks have become a common sight on American campuses.  They serve scores of hungry students through campus and looking for trendy food served fast. The owner of a food truck collects data on the number of students he serves on weekdays on a small campus in California. Use the FOODTRUCK sheet (refer to Excel file). Determine the 3-period moving average to make forecast for Week 4 to Week 41. 2.  The manager of a trendy downtown cafe in Columbus, Ohio, collects weekly data on the number of customers it serves.  Use the simple exponential smoothing technique with =0.2 to make a forecast in the entire data. Weekday Students 1 84 2 66 3 108 4 113 5 74 6 115 7 110 8 116 9 128 10 114 11 97 12 85 13 119 14 151 15 187 16 144 17 139 18 108 19 71 20 28 21 22 22 61 23 65 24 100 25 53 26 73 27 52 28 29 29 65 30 35 31 48 32 84 33 104 34 96 35 121 36 116 37 97 38 143 39 154 40 166

Purchasing and Supply Chain Management
6th Edition
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
ChapterC: Cases
Section: Chapter Questions
Problem 5.3SD: Scenario 4 Sharon Gillespie, a new buyer at Visionex, Inc., was reviewing quotations for a tooling...
icon
Related questions
Question

1.    Food trucks have become a common sight on American campuses.  They serve scores of hungry students through campus and looking for trendy food served fast. The owner of a food truck collects data on the number of students he serves on weekdays on a small campus in California. Use the FOODTRUCK sheet (refer to Excel file). Determine the 3-period moving average to make forecast for Week 4 to Week 41.

2.  The manager of a trendy downtown cafe in Columbus, Ohio, collects weekly data on the number of customers it serves.  Use the simple exponential smoothing technique with =0.2 to make a forecast in the entire data.

Weekday Students
1 84
2 66
3 108
4 113
5 74
6 115
7 110
8 116
9 128
10 114
11 97
12 85
13 119
14 151
15 187
16 144
17 139
18 108
19 71
20 28
21 22
22 61
23 65
24 100
25 53
26 73
27 52
28 29
29 65
30 35
31 48
32 84
33 104
34 96
35 121
36 116
37 97
38 143
39 154
40 166
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps with 2 images

Blurred answer
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Purchasing and Supply Chain Management
Purchasing and Supply Chain Management
Operations Management
ISBN:
9781285869681
Author:
Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:
Cengage Learning
Contemporary Marketing
Contemporary Marketing
Marketing
ISBN:
9780357033777
Author:
Louis E. Boone, David L. Kurtz
Publisher:
Cengage Learning
Marketing
Marketing
Marketing
ISBN:
9780357033791
Author:
Pride, William M
Publisher:
South Western Educational Publishing