Year QTR 1 2 Qtr 1 Qtr 2 Qtr 3 Qtr 4 Qtr 1 Qtr 2 Qtr 3 Qtr 4 Qtr 1 Qtr 2 Qtr 3 Qtr 4 Qtr 1 Qtr 2 Qtr 3 Qtr 4 Spools by Quarter 165251 149380 186240 208550 185513 120360 184300 212721 189223 152383 201000 220145 193007 184000 187210 212546 3 Forecast 32 Plotting the quarterly data, what forecast technique would you recommend? 33 Backfilling your technique for forecasting, what is the value of your forecast for year 3 quarter 1? 34 Backfilling your technique for forecasting, what is the value of your forecast for year 3 quarter 2? 35 Backfilling your technique for forecasting, what is the value of your forecast for year 3 quarter 3? 36 Backfilling your technique for forecasting, what is the value of your MAD for year 3 quarter 1? 37 Backfilling your technique for forecasting, what is the value of your MAD for year 3 quarter 2? 38 Backfilling your technique for forecasting, what is the value of your MAD for year 3 quarter 3? 39 Backfilling your technique for forecasting, what is the value of your MAPE for year 3 quarter 1? 40 Backfilling your technique for forecasting, what is the value of your MAPE for year 3 quarter 2? 41 Backfilling your technique for forecasting, what is the value of your MAPE for year 3 quarter 3? 42 Backfilling your technique for forecasting, what is the value of your track signal for year 3 quarter 1? 43 Backfilling your technique for forecasting, what is the value of your track signal for year 3 quarter 2? 44 Backfilling your technique for forecasting, what is the value of your track signal for year 3 quarter 3? 45 What is your forecast for year 5 for the total spools sold? 46 What is your forecast for year 5 quarter one for the total spools sold? 47 What is your forecast for year 5 quarter two for the total spools sold? 48 What is your forecast for year 5 quarter three for the total spools sold? 49 What is your forecast for year 5 quarter four for the total spools sold? 50 What quarters did your tracking signal violate the limits? Word Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number 4 Did your model violate any of the limits on the tracking signal? What are you forecasted spool sales for the next year? What is your forecast for quarter one, two, three and four? Year QTR 1 2 Qtr 1 Qtr 2 Qtr 3 Qtr 4 Qtr 1 Qtr 2 Qtr 3 Qtr 4 Qtr 1 Qtr 2 Qtr 3 Qtr 4 Qtr 1 Qtr 2 Qtr 3 Qtr 4 Spools by Quarter 165251 149380 186240 208550 185513 120360 184300 212721 189223 152383 201000 220145 193007 184000 187210 212546 3 Forecast 32 Plotting the quarterly data, what forecast technique would you recommend? 33 Backfilling your technique for forecasting, what is the value of your forecast for year 3 quarter 1? 34 Backfilling your technique for forecasting, what is the value of your forecast for year 3 quarter 2? 35 Backfilling your technique for forecasting, what is the value of your forecast for year 3 quarter 3? 36 Backfilling your technique for forecasting, what is the value of your MAD for year 3 quarter 1? 37 Backfilling your technique for forecasting, what is the value of your MAD for year 3 quarter 2? 38 Backfilling your technique for forecasting, what is the value of your MAD for year 3 quarter 3? 39 Backfilling your technique for forecasting, what is the value of your MAPE for year 3 quarter 1? 40 Backfilling your technique for forecasting, what is the value of your MAPE for year 3 quarter 2? 41 Backfilling your technique for forecasting, what is the value of your MAPE for year 3 quarter 3? 42 Backfilling your technique for forecasting, what is the value of your track signal for year 3 quarter 1? 43 Backfilling your technique for forecasting, what is the value of your track signal for year 3 quarter 2? 44 Backfilling your technique for forecasting, what is the value of your track signal for year 3 quarter 3? 45 What is your forecast for year 5 for the total spools sold? 46 What is your forecast for year 5 quarter one for the total spools sold? 47 What is your forecast for year 5 quarter two for the total spools sold? 48 What is your forecast for year 5 quarter three for the total spools sold? 49 What is your forecast for year 5 quarter four for the total spools sold? 50 What quarters did your tracking signal violate the limits? Word Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number Number 4 Did your model violate any of the limits on the tracking signal? What are you forecasted spool sales for the next year? What is your forecast for quarter one, two, three and four