Math homework

QUESTION 6

1. The number of cans of soft drinks sold in a machine each week is recorded below. Develop forecasts using a three-period moving average. 338, 219, 276, 265, 314, 323, 299, 257, 287, 302

Report the forecast for period 6 (use 2 numbers after the decimal point).

5 points   

QUESTION 7

1. The number of cans of soft drinks sold in a machine each week is recorded below. Develop forecasts using a three-period moving average. 338, 219, 276, 265, 314, 323, 299, 257, 287, 302

Report the forecast value for period 9 (use 2 numbers after the decimal point)

5 points   

QUESTION 8

1. The number of cans of soft drinks sold in a machine each week is recorded below. Develop forecasts using a three-period moving average. 338, 219, 276, 265, 314, 323, 299, 257, 287, 302

Report the forecasting value for period 10 (use 2 numbers after the decimal point).

5 points   

QUESTION 9

1. The number of cans of soft drinks sold in a machine each week is recorded below. Develop forecasts using a three-period moving average. 338, 219, 276, 265, 314, 323, 299, 257, 287, 302

Report the Forecast error for period 5 (use 2 numbers after the decimal point)

5 points   

QUESTION 10

1. The number of cans of soft drinks sold in a machine each week is recorded below. Develop forecasts using a three-period moving average. 338, 219, 276, 265, 314, 323, 299, 257, 287, 302

Report the forecast error for period 8 (use absolute value and only two numbers after the decimal point)

5 points   

QUESTION 11

1. The number of cans of soft drinks sold in a machine each week is recorded below. Develop forecasts using a three-period moving average.

338, 219, 276, 265, 314, 323, 299, 257, 287, 302

Report the Mean Absolute Deviation for this forecast problem (MAD). Use 2 numbers after the decimal point.

5 points   

QUESTION 12

1. A hospital records the number of floral deliveries its patients receive each day. For a two-week period, the records show 15, 27, 26, 24, 18, 21, 26, 19, 15, 28, 25, 26, 17, 23

 Use exponential smoothing with a smoothing constant of .3 to forecast the number of deliveries.  Report the forecast for period 2 using 2 numbers after the decimal point.

5 points   

QUESTION 13

1. A hospital records the number of floral deliveries its patients receive each day. For a two-week period, the records show 15, 27, 26, 24, 18, 21, 26, 19, 15, 28, 25, 26, 17, 23 Use exponential smoothing with a smoothing constant of .3 to forecast the number of deliveries.

Report the value of the forecast for period 6 using 2 numbers after the decimal point.

5 points   

QUESTION 14

1. A hospital records the number of floral deliveries its patients receive each day. For a two-week period, the records show 15, 27, 26, 24, 18, 21, 26, 19, 15, 28, 25, 26, 17, 23 Use exponential smoothing with a smoothing constant of .3 to forecast the number of deliveries.

Report the forecast value for period 11, using 2 numbers after the decimal point.

5 points   

QUESTION 15

1. A hospital records the number of floral deliveries its patients receive each day. For a two-week period, the records show 15, 27, 26, 24, 18, 21, 26, 19, 15, 28, 25, 26, 17, 23 Use exponential smoothing with a smoothing constant of .3 to forecast the number of deliveries.

Report the forecast error for period 4 using 2 numbers after the decimal point.

5 points   

QUESTION 16

1. A hospital records the number of floral deliveries its patients receive each day. For a two-week period, the records show 15, 27, 26, 24, 18, 21, 26, 19, 15, 28, 25, 26, 17, 23 Use exponential smoothing with a smoothing constant of .3 to forecast the number of deliveries.

Report the forecast error for period 9 in absolute value and using 2 numbers after the decimal point.

5 points   

QUESTION 17

1. A hospital records the number of floral deliveries its patients receive each day. For a two-week period, the records show 15, 27, 26, 24, 18, 21, 26, 19, 15, 28, 25, 26, 17, 23 Use exponential smoothing with a smoothing constant of .3 to forecast the number of deliveries.

Report the forecast error for period 13 in absolute value and using 2 numbers after the decimal point.

5 points   

QUESTION 18

1. A hospital records the number of floral deliveries its patients receive each day. For a two-week period, the records show 15, 27, 26, 24, 18, 21, 26, 19, 15, 28, 25, 26, 17, 23 Use exponential smoothing with a smoothing constant of .3 to forecast the number of deliveries.

Report the MAD for the period of forecasting. Use 2 numbers after the decimal point.

5 points   

QUESTION 19

1. Using the attached Excel file (Gasoline) prepare a line chart, and answer the following question.

Does the data reflect any trend during the period?

Answer the question by writing one of these 3 options:

downward,

upward,

horizontal.