Problem 3-16 Obtain estimates of daily relatives for the number of customers at
ID: 384991 • Letter: P
Question
Problem 3-16
Obtain estimates of daily relatives for the number of customers at a restaurant for the evening meal, given the following data.
Use the centered moving average method. (Hint: Use a seven-day moving average.) (Round your intermediate calculations and final answers to 4 decimal places.)
b. Use the SA method. (Round your intermediate calculations to 3 decimals and final answers to 4 decimals.)
Served Day Number
Served 1 80 15 84 2 75 16 78 3 78 17 83 4 95 18 96 5 130 19 135 6 136 20 140 7 40 21 44 8 82 22 87 9 77 23 82 10 80 24 88 11 94 25 99 12 131 26 144 13 137 27 144 14 42 28 48
Explanation / Answer
A.
So average is for 7 days= 7 day MA.
Then 2 values mean is calculated = Centered MA
B.
So now finding Y/T (As defined below:
Then the seasonal Averages are calculated for 7 day span:
Day No 7 day MA Centred MA 1 80 2 75 3 78 4 95 90.571 90.7143 5 130 90.857 91.0000 6 136 91.143 91.2857 7 40 91.429 91.3571 8 82 91.286 91.3571 9 77 91.429 91.5000 10 80 91.571 91.7143 11 94 91.857 92.0000 12 131 92.143 92.2143 13 137 92.286 92.5000 14 42 92.714 92.8571 15 84 93.000 93.2857 16 78 93.571 93.7857 17 83 94.000 94.1429 18 96 94.286 94.5000 19 135 94.714 95.0000 20 140 95.286 95.6429 21 44 96.000 96.2143 22 87 96.429 97.0714 23 82 97.714 98.0000 24 88 98.286 98.5714 25 99 98.857 26 144 27 144 28 48Related Questions
drjack9650@gmail.com
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.