Create a forecast for each month

Assignment Help Operation Management

Reference no: EM131919702

Question: The following data show the number of laptop computers sold each month at a retail store:

709_Unit sales.png

a. Assuming the estimated trend from May to June was 2 4 and the forecast for June was 190, use trend-adjusted exponential smoothing with a = 0.3 and b = 0.2 to forecast sales for each of the seven following months: July, August, September, October, November, December, and January.

b. Use regression for the data from January to June to create a forecast for each month from July to the following January.

c. Compare the two sets of forecasts generated in parts a and b. Which forecast model produces a better MFE? MAD?

Reference no: EM131919702

Questions Cloud

How many of part will now be needed : How many of part J will be needed if 40 units of end item A are needed? Managers have decided to outsource part G. Revise the BOM for end item A.

What are the benefits and drawbacks to each approach : Complete the MRP record for a bicycle frame using a L4L lot-sizing strategy. Considering the lead time, where should scheduled receipts be shown?

Write essay about medical problems related to liver diseases : You are required to write an essay of no more than 2 pages about at least 3 serious medical problems that are related to liver diseases and alcohol abuse

Equipment for MACRS-GDS depreciation : An investment of $1,250,000 is made in equipment that qualifies as 7-year equipment for MACRS- GDS depreciation.

Create a forecast for each month : Use regression for the data from January to June to create a forecast for each month from July to the following January.

What will the wacc be after recapitalization : Bruce will borrow $61,000 and use the proceeds to repurchase shares. What will the WACC be after recapitalization?

Compare the forecasts given by the models : A ski repair shop at a resort in Colorado sells replacement poles each season. The shop needs to develop a forecast of next season's sales.

Identical operating risk profile and identical pretax income : Both A & B have identical after-tax profit $1,200,000 and it is given that both have identical operating risk profile and identical pretax income.

What is the total cost of a chase production plan : A firm must plan production for the next six months. Each unit costs $250 to produce and it has an inventory holding cost of $10 per unit per month based.

User Account

All Pages