Firm that specializes in the distribution of bicycles

Assignment Help Basic Statistics
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?

Reference no: EM131104983

Questions Cloud

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

Reviews

Write a Review

Basic Statistics Questions & Answers

  Statistics-probability assignment

MATH1550H: Assignment:  Question:  A word is selected at random from the following poem of Persian poet and mathematician Omar Khayyam (1048-1131), translated by English poet Edward Fitzgerald (1808-1883). Find the expected value of the length of th..

  What is the least number

MATH1550H: Assignment:  Question:     what is the least number of applicants that should be interviewed so as to have at least 50% chance of finding one such secretary?

  Determine the value of k

MATH1550H: Assignment:  Question:     Experience shows that X, the number of customers entering a post office during any period of time t, is a random variable the probability mass function of which is of the form

  What is the probability

MATH1550H: Assignment:Questions: (Genetics) What is the probability that at most two of the offspring are aa?

  Binomial distributions

MATH1550H: Assignment:  Questions:  Let’s assume the department of Mathematics of Trent University has 11 faculty members. For i = 0; 1; 2; 3; find pi, the probability that i of them were born on Canada Day using the binomial distributions.

  Caselet on mcdonald’s vs. burger king - waiting time

Caselet on McDonald’s vs. Burger King - Waiting time

  Generate descriptive statistics

Generate descriptive statistics. Create a stem-and-leaf plot of the data and box plot of the data.

  Sampling variability and standard error

Problems on Sampling Variability and Standard Error and Confidence Intervals

  Estimate the population mean

Estimate the population mean

  Conduct a marketing experiment

Conduct a marketing experiment in which students are to taste one of two different brands of soft drink

  Find out the probability

Find out the probability

  Linear programming models

LINEAR PROGRAMMING MODELS

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd