Al Maha Plastic manufacturing Companies last Six weekly values of Sales were 90, 110, 115, 135, 140, 150 and 160 units. Forecasts (same for all the six weeks) were 110 units for all the weeks. Calculate MAD, and Tracking Signal for these six weeks. Wee k Actual Sales Forecaste d Sale Error Cumulative Error Absolute Error Cumulative Absolute Error MAD Tracking Signal 1 2 3 4 5 6 7

Al Maha Plastic manufacturing Companies last Six weekly values of Sales were 90, 110, 115, 135, 140, 150 and 160 units. Forecasts (same for all the six weeks) were 110 units for all the weeks. Calculate MAD, and Tracking Signal for these six weeks. Wee k Actual Sales Forecaste d Sale Error Cumulative Error Absolute Error Cumulative Absolute Error MAD Tracking Signal 1 2 3 4 5 6 7

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter13: Regression And Forecasting Models

Section13.6: Moving Averages Models

Problem 22P: The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six...

See similar textbooks

Similar questions

Under what conditions might a firm use multiple forecasting methods?
The file P13_22.xlsx contains total monthly U.S. retail sales data. While holding out the final six months of observations for validation purposes, use the method of moving averages with a carefully chosen span to forecast U.S. retail sales in the next year. Comment on the performance of your model. What makes this time series more challenging to forecast?
Given the following history, use a three-quarter moving average to forecast the demandfor the third quarter of this year. Note that the 1st quarter is Jan, Feb, and Mar; 2ndquarter Apr, May, Jun; 3rd quarter Jul, Aug, Sep; and 4th quarter Oct, Nov, JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DECLast year 120 140 145 195 205 220 165 155 145 220 245 265This year 140 145 200 210 240 255
Daily demand for newspapers for the last 10 days has been as follows: 12, 13, 16, 15, 12, 18, 14, 12, 13,15 (listed from oldest to most recent). Forecast sales for the next day using a three-day weighted moving average where the weights are 3, 1, and 1 (the highest weight is for the most recent number). Sample paper answers: 1) None of the provided options.2) 13.03) 12.84) 70.014.0
Zeus Computer Chips, Incorporated used to have major contracts to produce the Centrino-type chips. The market has been declining during the past three years because of the quad-core chips, which it cannot produce, so Zeus has the unpleasant task of forecasting next year. The task is unpleasant because the firm has not been able to find replacement chips for its product lines. Here is demand over the past 12 quarters: QUARTER TWOYEARS AGO DEMAND QUARTER LASTYEAR DEMAND QUARTER THISYEAR DEMAND 1 4,800 1 3,500 1 3,200 2 3,500 2 2,700 2 2,100 3 4,300 3 3,500 3 2,700 4 3,000 4 2,400 4 1,700 Use the regression and seasonal indexes to forecast demand for the next four quarters. Note: Do not round intermediate calculations. Round your answers to 2 decimal places. Period Forecast 1 2 3 4
Herman Hahn is attempting to set up an integrated forecasting and inventory controlsystem for his hardware store, Hahn’s Hardware. When Herman indicates that outdoorlights are a seasonal item on the computer, he is prompted by the program to input theseasonal factors by quarter.Unfortunately, Herman has not kept any historical data, but he estimates that firstquarter demand for the lights is about 30 percent below average, the second-quarterdemand about 20 percent below average, third-quarter demand about average, andfourth-quarter demand about 50 percent above average. What should he input for theseasonal factors?
The Yummy Ice Cream Company projects the demand for ice cream by using first-order exponential smoothing. Last week the forecast was 100,000 gallons of ice cream, and 90,000 gallons was actually sold. Using alpha=.1, prepare a forecast for next week. Calculate the forecast using Alpha=.2 and Alpha=.3 for this problem. Which values of Alpha gave the best forecast, assuming actual demand for next week ends up being 95,000 gallons?
Please do not give solution in image formate thanku. Bradley's Copiers sells and repairs photocopy machines. The manager needs weekly forecasts of service calls so that he can schedule service personnel. Use the actual demand in the first period for the forecast for the first week so error measurement begins in the second week. The manager uses exponential smoothing with α = 0.5 Forecast the number of calls for week 6, which is next week. WEEK ACTUAL SERVICE CALLS 1 28 2 32 3 40 4 27 5 30
The following are historical demand data: YEAR SEASON ACTUALDEMAND 2011 Spring 203 Summer 144 Fall 382 Winter 565 2012 Spring 471 Summer 271 Fall 686 Winter 955 Use regression analysis on deseasonalized demand to forecast demand in summer 2013. (Do not round intermediate calculations. Round your answer to the nearest whole number.)
Q5) Monthly sales for a six month period are as follows: Month SalesJan 18,000Feb 22,000Mar 16,000Apr 18,000May 20,000June 24,000 Compute the sales forecast for July using the following approaches: (1) Four-month moving average; (2) Weighted three-month moving average using .50 for June, .30 for May and .20 for April;(3) Exponential smoothing with α (smoothing constant) equal to .40, assuming a February forecast of 18,000
Given the following history, use a three-quarter moving average to forecast the demand for the third quarter of this year. Note that the 1st quarter is Jan, Feb, and Mar; 2nd quarter Apr, May, Jun; 3rd quarter Jul, Aug, Sep; and 4th quarter Oct, Nov, Dec. (Round final answer to a whole number.) JAN FEB MAR APR MAY JUN JUL AUG SEP OCT NOV DEC Last year 165 185 200 230 240 265 210 200 195 265 290 315 This year 175 200 165 260 260 200 Forecast for the third quarter
Given the demand data, answer the following questions below. Year Sales 1 - 123 2 - 118 3 - 109 4 - 112 5 -100 6 -110 7 -124 8 - ? What will be the forecast demand in Year 8 using Naïve method?a.) 120b.) 110c.) 115d.) 124