Explore BrainMass
Share

Forecasts Calculations

This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

Question 4 A rendering plant wishes to use the data (sales records from a few local businesses and the month of the year) to help determine their supply level for the coming months. The records shown in the table provide an excellent opportunity for you to assist them with their forecasting. Which answer below?

Month Sales Pounds

Jan 45 54.3

Feb 57 63.8

Mar 32 39.5

Apr 44 49.8

May 51 52.3

Jun 34 39.9

What is the three-period weighted moving average for July using the weights 0.5 (most recent), 0.3, and 0.2? Which answer below?

48.99

45.6

49.51

46.09

Question 5 A rendering plant wishes to use the data (sales records from a few local businesses and the month of the year) to help determine their supply level for the coming months. The records shown in the table provide an excellent opportunity for you to assist them with their forecasting. Which answer below?

Month Sales Pounds

Jan 45 54.3

Feb 57 63.8

Mar 32 39.5

Apr 44 49.8

May 51 52.3

Jun 34 39.9

Using 1 to represent January, 2 to represent February, and so on, what is the intercept for the regression equation that predicts the pounds of supplies available? Which answer below?

0.55

-2.74

59.55

8.87

Question 6 A rendering plant wishes to use the data (sales records from a few local businesses and the month of the year) to help determine their supply level for the coming months. The records shown in the table provide an excellent opportunity for you to assist them with their forecasting. Which answer below?

Month Sales Pounds

Jan 45 54.3

Feb 57 63.8

Mar 32 39.5

Apr 44 49.8

May 51 52.3

Jun 34 39.9

What is the forecast for July if exponential smoothing with an alpha=.04 generated a forecast of 43.0 for June? Which answer below?

41.25

40.64

43.16

42.88

Question 7

A rendering plant wishes to use the data (sales records from a few local businesses and the month of the year) to help determine their supply level for the coming months. The records shown in the table provide an excellent opportunity for you to assist them with their forecasting. Which answer below?

Month Sales Pounds

Jan 45 54.3

Feb 57 63.8

Mar 32 39.5

Apr 44 49.8

May 51 52.3

Jun 34 39.9

What is the slope of the regression equation developed when the Sales data are used to predict the Pounds? Which answer below?

0.92

0.86

0.80

0.71

The manager of "Skis 4 U" is preparing a forecast for January of 2014. Demand exhibits both trend and seasonality. A trend equation to estimate annual demand has been generated using annual demand of the past 12 years (from 2002 through 2013). The equation is?y?= 4375 + 800X, where X=1 represents year 2002. The seasonal factor for January is computed to be 0.23. Make a seasonally adjusted forecast for demand in January 2014. Round off your answer to the nearest integer.

3398
4583
5668
6769