a. Compute the MAD of forecast errors. (Round your answers to 2 declmal places.) Week MAD 1 2 3 4 7 8
a. Compute the MAD of forecast errors. (Round your answers to 2 declmal places.) Week MAD 1 2 3 4 7 8
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...
Related questions
Question
![Harlen Industries has a simple forecasting model: Take the actual demand for the same month last year and divide that by the number
of fractional weeks in that month. This gives the average weekly demand for that month. This weekly average is used as the weekly
forecast for the same month this year. This technique was used to forecast eighnt weeks for this year, which are shown below along
with the actual demand that occurred.
The following eight weeks show the forecast (based on last year) and the demand that actually occurred:
ITT
FORECAST
ACTUAL
WEEK
DEMAND
DEMAND
130
1
127
2
130
123
3
146
149
4
144
159
5
146
179
156
169
150
184
145
205
a. Compute the MAD of forecast errors. (Round your answers to 2 decimal places.)
Week
MAD
1
2
4
7
b. Using the RSFE, compute the tracking signal. (Round your answers to 2 decimal places. Negative values should be Indicated by a
mlnus sign.)
Tracking
Week
Signal
1
2
4
7
8
c. Based on your answers to parts a and b, comment on Harlen's method of forecasting.
O The forecast should be considered poor.
O The forecast should be considered good.](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F9da8044b-8d4c-475d-be39-5b4e20eea398%2F3707dddf-6276-4d19-a58f-f4b40484fafa%2Fyfmrx7w_processed.png&w=3840&q=75)
Transcribed Image Text:Harlen Industries has a simple forecasting model: Take the actual demand for the same month last year and divide that by the number
of fractional weeks in that month. This gives the average weekly demand for that month. This weekly average is used as the weekly
forecast for the same month this year. This technique was used to forecast eighnt weeks for this year, which are shown below along
with the actual demand that occurred.
The following eight weeks show the forecast (based on last year) and the demand that actually occurred:
ITT
FORECAST
ACTUAL
WEEK
DEMAND
DEMAND
130
1
127
2
130
123
3
146
149
4
144
159
5
146
179
156
169
150
184
145
205
a. Compute the MAD of forecast errors. (Round your answers to 2 decimal places.)
Week
MAD
1
2
4
7
b. Using the RSFE, compute the tracking signal. (Round your answers to 2 decimal places. Negative values should be Indicated by a
mlnus sign.)
Tracking
Week
Signal
1
2
4
7
8
c. Based on your answers to parts a and b, comment on Harlen's method of forecasting.
O The forecast should be considered poor.
O The forecast should be considered good.
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 2 steps with 2 images
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
![Practical Management Science](https://www.bartleby.com/isbn_cover_images/9781337406659/9781337406659_smallCoverImage.gif)
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
![Operations Management](https://www.bartleby.com/isbn_cover_images/9781259667473/9781259667473_smallCoverImage.gif)
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
![Operations and Supply Chain Management (Mcgraw-hi…](https://www.bartleby.com/isbn_cover_images/9781259666100/9781259666100_smallCoverImage.gif)
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
![Business in Action](https://www.bartleby.com/isbn_cover_images/9780135198100/9780135198100_smallCoverImage.gif)
![Purchasing and Supply Chain Management](https://www.bartleby.com/isbn_cover_images/9781285869681/9781285869681_smallCoverImage.gif)
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
![Production and Operations Analysis, Seventh Editi…](https://www.bartleby.com/isbn_cover_images/9781478623069/9781478623069_smallCoverImage.gif)
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.