Calculate the mad, Calculate the MAD, the MAPE, the MSE and

Calculate the mad

Assignment Help Operation Management

Reference no: EM13222128

The Multifacted Garden Store uses two forecasting techniques to predict annual national sales of their lawnmowers at their various franchises. The actual sales and the corresponding forecasts for techniques 1 & 2 for the period spring 2012 to spring 2013 are given below:

Spring 12 Summer 12 Fall 12 Winter 12 Spring 13
Actual 17178 11452 6106 1527 18183
FC 1 16948 11250 6308 1604 18007
FC 2 17453 12102 6006 1445 18504

a. Calculate the MAD, the MAPE, the MSE and the tracking signal for Forecast 1
b. Calculate the MAD, the MAPE, the MSE and the tracking signal for Forecast 2
c. Compare results obtained in parts a and b
d. The company is interested in developing forecasts for their lawnmower sales during the summer of 2011. which of the two forecasting techniques would you recommend that they use, and why
e. Actual sales figures for the previous three years are given below

Spring Summer Fall Winter Total
2010 15125 9650 4195 1230 30200
2011 16095 10730 5300 1327 33452
2012 17178 11452 6106 1527 36263

Can you suggest an appropriate technique that might yield reasonable forecasts for this time series? Use the method you selected to forecast sales for spring 2013.

Reference no: EM13222128

Questions Cloud

What is the average time spent by each order waiting : An automobile brake supplier receives an average of 1,000 orders per week. An average of 500 orders are waiting to be processed.

What is the resulting inventory policy : Identify the tradeoff that I-mart must consider when deciding whether to go with the airfreight option. What would you recommend? Why? Quantify the costs and benefits of the change.

How will events impact the equilibrium price and quantity : You are the manager of a firm that produces and markets a generic type of soft drink in a competitive market. In addition to the large number of generic type of soft products in your market, you also compete against major brands such as Coca-Cola ..

What is the theoretical flow time of the process : During rush hour, demand exceeds capacity and long lines form. Does it make sense to add a pizza assembler? Why or why not? Please limit your answer to 2-3 sentences.

Calculate the mad : Calculate the MAD, the MAPE, the MSE and the tracking signal for Forecast 1

How would you decide what was best level of emission : Sometimes market activities (production, buying, and selling) have unintended positive or negative effects outside the market's scope. These are called externalities. As a policy maker concerned with correcting the effects of gases and particulate..

What is the percent increase for revenues : What is the percent increase for revenues which have grown from $150 (million) last year to $200 (million) this year. Show all steps.

What can you expect to happen to the price you pay for ram : You are the manager of a midsized company that assembles personal computers. You purchase most components-such as random access memory (RAM)-in a comptetitve market. Based on your marketing research, consumers earnings over $75,000 purchase 1.3 ti..

What implications does this quote have for business : Do you agree or disagree that "...all economic activity is dependent upon that environment and its underlying resource base ..."? Please include examples with your comments.

User Account

All Pages