Question
Sam has a cleaning service. To better allocate his resources, he would like to forecast his weekly orders based on the order number he received
Sam has a cleaning service. To better allocate his resources, he would like to forecast his weekly orders based on the order number he received in the past 13 weeks as shown in the following table.
Week | Demand |
Week 1 | 11 |
Week 2 | 14 |
Week 3 | 16 |
Week 4 | 10 |
Week 5 | 15 |
Week 6 | 17 |
Week 7 | 11 |
Week 8 | 14 |
Week 9 | 17 |
Week 10 | 12 |
Week 11 | 14 |
Week 12 | 16 |
Week 13 | 15 |
Part 1) Using a three week moving average, Sam's forecast for his Week 14 order number is _______________ . (Please round to two decimal points and include no units.)
Part 2) Using a three week weighted moving average with weights 3, 2, and 1 given to the most recent, second most recent, and third most recent week, respectively, Sam's forecast for his Week 14 order number is ___________ . (Please round to two decimal points and include no units.)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started