Reference no: EM131104983
Quality Bikes is a wholesale firm that specializes in the distribution of bicycles. In the past, the company has maintained ample inventories of bicycles to enable filling orders immediately, so informal rough forecasts of demand were sufficient to make the decisions on when to replenish inventory. However, the company's new president, Marcia Salgo, intends to run a tighter ship. Scientific inventory management is to be used to reduce inventory levels and minimize total variable inventory costs. At the same time, Marcia has ordered the development of a computerized forecasting system based on statistical forecasting that considers seasonal effects. The system is to generate three sets of forecasts-one based on the moving-average method, a second based on the exponential smoothing method, and a third based on exponential smoothing with trend. The average of these three forecasts for each month is to be used for inventory management purposes. The following table gives the available data on monthly sales of 10-speed bicycles over the past three years. The last column also shows monthly sales this year, which is the first year of operation of the new forecasting system.
(a) Determine the seasonal factors for the 12 months based on with the following sales history. past sales.
(b) After considering seasonal effects, apply the moving-average method based on the most recent three months to forecast monthly sales this year.
(c) After considering seasonal effects, apply the exponential smoothing method to forecast monthly sales this year. Use an initial estimate of 420 and a smoothing constant of α = 0.2.
(d) After considering seasonal effects, apply exponential smoothing with trend to forecast monthly sales this year. Use initial estimates of 420 for the expected value and 0 for the trend, along with smoothing constants of α = 0.2 and ß = 0.2.
(e) Compare the MAD values obtained in parts (b), (c), and (d).
(f) Calculate the combined forecast for each month by averaging the forecasts for that month obtained in parts (b), (c), and (d). Then calculate the MAD for these combined forecasts.
(g) Based on these results, what is your recommendation for how to do the forecasts next year?
|
How are deferred taxes recorded on the balance sheet
: How are deferred taxes recorded on the balance sheet? Which of the following items should alert the analyst to the potential for manipulation when analyzing accounts receivable and the allowances for doubtful accounts?
|
|
The sales data for a certain product
: Reconsider the sales data for a certain product given in Prob. 20.5-4. The company's management now has decided to discontinue incorporating seasonal effects into its forecasting procedure for this product because there does not appear to be a sub..
|
|
Determine the value of the call at expiration
: Using your computer, generate 1hv normally distributed random variables with mean zero and variance √2. Obtain one simulated trajectory for the St. Choose ?t = .2. Determine the value of the call at expiration.
|
|
Question regarding the determinants of demand
: Suppose the demand (in millions) for a computer game takes the form of the following equation: Q = 250 - 10P + 20P(y)
|
|
Firm that specializes in the distribution of bicycles
: Quality Bikes is a wholesale firm that specializes in the distribution of bicycles. In the past, the company has maintained ample inventories of bicycles to enable filling orders immediately, so informal rough forecasts of demand were sufficient t..
|
|
Discuss what the rule of law is
: Discuss what the rule of law is. What are the branches of government and their composition
|
|
Find the output if current
: Assume that the RF signal is applied to the sum port of the hybrid, and that the LO signal is applied to the difference port.
|
|
Implementing community policing per the text
: In doing so, speak to the five (5) challenges to implementing community policing per the text.
|
|
The management of transcontinental airlines
: Reconsider Prob. 20.7-12. The economy is beginning to boom so the management of Transcontinental Airlines is predicting that the number of people flying will steadily increase this year over the relatively flat (seasonally adjusted) level of last ..
|