ZuoTi.Pro
Question

The following are monthly actual and forecast demand levels for May through December for units of...

The following are monthly actual and forecast demand levels for May through December for units of a product manufactured by the D. Bishop company in Des Moines:

Month Actual demand Forecast demand
may 100 100
june 80 104
july 110 99
august 115 101
septmeber 105 104
october 110 104
november 125 105
december 120 109

What is the value of the tracking signal as of the end of december?

business   Operations-Management   
0 0
Add a comment Improve this question Transcribed image text
Next > < Previous
Sort answers by oldest

Homework Answers

✔ Recommended Answer
Answer #1

Actual Forecast Month error(Dt-ft) dt -ft demand(Dt) demand(ft) 100 80 110 115 100 2 ma 3 june 4 jul 5 august 0 24 0 24 104 1

0 0
Add a comment
Know the answer?
Add Answer to:
The following are monthly actual and forecast demand levels for May through December for units of...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Log In

Sign Up

Similar Homework Help Questions

  • John Taylor Salons want to forecast monthly customer demand from June through August using trend ...

    Using Excel John Taylor Salons want to forecast monthly customer demand from June through August using trend adjusted exponential smoothing. Given alpha (a) 0.20, Beta (B) -0.40, the Forecast for May 45 (FMay-45) customers, and the trend for May 0 (Tmay-0), forecast a FIT (forecast including trend) for the months of June through August. 3. Month Actual Sales May June July August 50 61 73 80 Jay Sharp Guard wants to compare the accuracy of two methods that it has...

  • [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...

  • Demand 21,520 Period September 2018 October 201823,670 November 2018 December 2018 Period Demand 22,820 March 2018...

    Demand 21,520 Period September 2018 October 201823,670 November 2018 December 2018 Period Demand 22,820 March 2018 April 2018 May 2018 23,280 24,490 24,810 June 2018 22,370 25,250 July 2018 August 2018 What is the forecast demand for March 2019 considering trend and seasonality? January 2019 25,990 February 2019 24,260 19,940 20,860 Demand 21,520 Period September 2018 October 201823,670 November 2018 December 2018 Period Demand 22,820 March 2018 April 2018 May 2018 23,280 24,490 24,810 June 2018 22,370 25,250 July 2018...

  • 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...

  • 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...

  • How do I plot a series graph with this data provided? Month 1987 1988 1989 1990...

    How do I plot a series graph with this data provided? Month 1987 1988 1989 1990 1991 1992 1993 1994 1995 1996 Jan 95 104 101 88 132 125 111 127 119 147 Feb 94 100 96 110 109 118 123 129 147 146 Mar 98 99 82 129 101 121 121 132 164 133 Apr 96 88 84 113 111 140 139 108 135 148 May 95 89 85 114 140 141 119 115 124 141 Jun 115 108...

  • The Actual demands in the last 4 periods are given. Which of the following statement is...

    The Actual demands in the last 4 periods are given. Which of the following statement is not true? Period Ai Weight 1 10 2 20 0.3 3 30 0.3 4 20 0.4 A. F5=23.33 using Moving Average and n=3 B. F5=20 using Naive Approach C. When the business environment is more dynamic, we tend to choose smaller smoothing constant value. D. F5=23 using Weighted Moving Average when n=3 and the weight is 0.4, 0.3, and 0.3 for period 4, 3,...

  • 1. Forecast demand for Year 4. a. Explain what technique you utilized to forecast your demand....

    1. Forecast demand for Year 4. a. Explain what technique you utilized to forecast your demand. b. Explain why you chose this technique over others. Year 3 Year 1 Year 2 Actual Actual Actual Forecast Forecast Forecast Demand Demand Demand Week 1 52 57 63 55 66 77 Week 2 49 58 68 69 75 65 Week 3 47 50 58 65 80 74 Week 4 60 53 58 55 78 67 57 Week 5 49 57 64 76 77...

  • 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;...

  • Block Commodities has gathered the following information concerning rock salt deliveries (tons) to its clients, which it believes are highly seasonal:

    1.      Block Commodities has gathered the following information concerning rock salt deliveries (tons) to its clients, which it believes are highly seasonal:      MonthYear 1Year 2Year 3Year 4Average Monthly January 75769511790.75February4834345242March3548125637.75April2234352529May261215.25June352105July2833352831August14598109120118September181197162145171.25October190201220180197.75November10010111098102.25December8170878881.5Total 910903913920 a.       Suppose Block Commodities calculated a set of seasonal relatives to express this monthly variation in rock salt deliveries, using this set of data. What would the value of the seasonal relative for the month of each month?b.      Block Commodities believes that this year will be a busy year...

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