Question

Which of the following conclusions can be drawn based on the following data? Month Actual Forecast Sales January 68 40 February 48 50 March 50 60 April 30 30 Tracking signal is 1.6 so the forecast method does not need to be reviewed Tracking signal is 1.6 so the forecast method needs to be reviewed Tracking signal is 10 so the forecast method does not need to be reviewed Tracking signal is 10 so the forecast method needs to be reviewed MAD is 10 so the forecast method does not need to be reviewed

0 0
Add a comment Improve this question Transcribed image text
Answer #1

In this problem the RSFE (running sum of forecast error) is (68-40)+(48-50)+(50-60)+(30-30) = 16.

The MAD (mean absolute deviation) is (|28|+|12|+|10|+|0|)/4 = 10

The tracking signal is RSFE/MAD = 1.6

Now that the data is verified, we know that MAD alone does not tell us anything. This means we can discard the last three options. Tracking signal on the other hand shows the level of bias present in the forecasting method. The acceptable values range from -4 to +4. Since our TS within this range we can proceed with this method without any review.

Correct answer: Tracking signal is 1.6 so the forecast method does not need to be reviewed.

Add a comment
Know the answer?
Add Answer to:
Which of the following conclusions can be drawn based on the following data? Month Actual Forecast...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • [18-22The following table shows monthly actual and forecast air passenger demand on Stockton Airlines ACTUAL FORECAST...

    [18-22The following table shows monthly actual and forecast air passenger demand on Stockton Airlines ACTUAL FORECAST ERROR RSFE MAD 180 TIME PERIOD Jan Feb Mar Apr 2 7 210 130 190 NA 2 30 2 2 NA TRACKING SIGNAL -10 2 ? NA 2 2 NA NA Using exponential smoothing (0.5) what will be the air passenger demand in April? O A 16725 8.171.25 c. 17425 0.17625 QUESTION 19 25 points In March, what is the running sum of the...

  • Here are the actual tabulated demands for an item for a nine-month period (January through September)....

    Here are the actual tabulated demands for an item for a nine-month period (January through September). Your supervisor wants to test two forecasting methods to see which method was better over this period. MONTH ACTUAL January 110 February 130 March 150 April 170 May    160 June      180 July    140 August 130 September 140 A. Forecast April through September using a three-month moving average. B. Use simple exponential smoothing with an alpha of 0.3 to estimate April through...

  • Calculate MAD and fill out table for the forecast: A forecasting method resulted in the following forecasts shown by the data in the following table a) Use the data to calculate the MAD for this fore...

    Calculate MAD and fill out table for the forecast: A forecasting method resulted in the following forecasts shown by the data in the following table a) Use the data to calculate the MAD for this forecast. Use the regression equation (given below) to forecast demand for period 11. And calculate the MAD for this regression method Is the regression method preferred over the method used? Why or why not? b) c) PeriodDemand Forecast A-F 54 48 68 36 68 45...

  • A manager has been using a certain technique to forecast demand for project management software at...

    A manager has been using a certain technique to forecast demand for project management software at her store. Actual demand and her corresponding predictions are shown below: MonthActual Demand Manager's Forecast March4545April4250May3445June4840July3845 a. What was the manager's forecast error for each month?b. What is the mean error (ME), the mean squared error (MSE), the mean absolute deviation (MAD), and the tracking signal for these five months of forecasting?c. If the manager had used a 3-month moving average instead of her technique, what would have...

  • Problem 22 Consider the following forecast results. Caloulate MFE, MAD, and MAPE, using the data for...

    Problem 22 Consider the following forecast results. Caloulate MFE, MAD, and MAPE, using the data for the months January through June. Does the forecast model under- or overforecast? Actual Forecast Month Demand January February March 968 1,091 1,089 1,063 1,054 898 1,029 1,113 June 1,013 1.100 The MFE slag (Enter your response rounded to one decimal place and include The MAD is(Enter your response rounded to one decimal place,) a minus sign if necessary)

  • 690 The manager of the Petroco Service Station wants to forecast the demand for unleaded gasoline next month so that...

    690 The manager of the Petroco Service Station wants to forecast the demand for unleaded gasoline next month so that the proper number of gallons can be ordered from the distributor. The owner has accumulated the following data on demand for unleaded gasoline from sales during the past 12 months: Month Gasoline Demanded (gal.) October 800 November 725 December 630 January 500 February 645 March 730 May 810 June 1,200 980 August 1,000 September 850 e. Compute linear trend line...

  • You are given the following budgeted and actual data for the Grey Company for each of...

    You are given the following budgeted and actual data for the Grey Company for each of the months January through June of the current year. In December of the prior year, sales were forecasted as follows: January, 93 units; February, 88 units; March, 95 units; April, 100 units; May, 107 units; June, 115 units. In January of the current year, sales for the months February through June were reforecasted as follows: February, 83 units; March, 95 units, April, 95 units;...

  • Homework: Homework #2 Score: 0 of 4 pts Problem 22 Save 5 of 22 (17 complete)>...

    Homework: Homework #2 Score: 0 of 4 pts Problem 22 Save 5 of 22 (17 complete)> HYV Score: 60%, 18 of 30 pt 1,4 Show Work | Question Help * Consider the following forecast results. Calculate MFE, MAD, and MAPE, using the data for the months January through June. Does the forecast model under-or overforecast? Actual Demand 1,008 972 923 1,059 1.137 991 Month Forecast January February March April May June 1,061 1,042 910 1,014 1,127 1,035 The MFE is(Enter...

  • You are given the following budgeted and actual data for the Grey Company for each of...

    You are given the following budgeted and actual data for the Grey Company for each of the months January through June of the current year. In December of the prior year, sales were forecasted as follows: January, 97 units; February, 92 units; March, 99 units; April, 104 units; May, 111 units; June, 119 units. In January of the current year, sales for the months February through June were reforecasted as follows: February, 87 units; March, 99 units; April, 99 units;...

  • Janus Inc. needs to prepare a cash budget. The following are actual and forecasted sales figures:...

    Janus Inc. needs to prepare a cash budget. The following are actual and forecasted sales figures: Actual Forecast November December January February March April $200,000 $220,000 $280,000 $320,000 $340,000 $330,000 Thirty percent of each month's sales are in cash, 50% are paid the month after sale and 20% are paid two months after sale. Materials cost 30% of sales and are purchased one month prior to sale and paid for 30 days later. Labor expense is 40% of sales, selling...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT