Answered: 1. Food trucks have become a common…

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

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