Compute weighted three month moving average forecast

Assignment Help Business Management

Reference no: EM1378238

The manager of the Carpet City outlet requires to make an accurate forecast of demand for Soft Shag carpet (its biggest seller). Assume if the manager does not order enough carpet from the carpet mill, consumers will purchase their carpet from one of Carpet City's many competitors. The manager has collected the following demand data for the past eight months.

Month Demand for Soft Shag Carpet (1,000 yd)

1 8
2 12
3 7
4 9
5 15
6 11
7 10
8 12

a) Calculate a three-month moving average forecast for months 4 through 9
b) Calculate a weighted three-month moving average forecast for months 4 through 9 Assign weights of .55, .33, and .12 to the months in sequence, starting with the most recent month.
c) Compare the two forecasts using MAD (mean absolute deviation). Which forecast appears to be more accurate?

Reference no: EM1378238

Questions Cloud

Examine funding opportunities for small businesses : Examine funding opportunities for small businesses including the role of the Small Business Administration

Buy analysis question : Lawson Industries creates portable CD Players. A new model has been constructed that needs a new design of a display unit. LI is contemplating whether to purchase the units from a supplier,

Which of the subsequent is correct : The normal price is $150.00 as well as the sale price must have read $135.00 but the advertisement says $15.00.

Presume you are in charge of developing the strategy : Presume you are in charge of developing the strategy for a beer making company in the U.S. You are observing at expanding your sales outside the U.S.

Compute weighted three month moving average forecast : The manager of the Carpet City outlet requires to make an accurate forecast of demand for Soft Shag carpet. Assume if the manager does not order enough carpet from the carpet mill, consumers will purchase their carpet from one of Carpet City's many c..

Is there anything they be able to do about it : Should Mary as well as the others accept the decision? Why or why not? Is there anything they be able to do about it? If yes, what?

Strategic alliance is a cooperative strategy in which firms : Strategic alliance is a cooperative strategy in which firms syndicate some of their resources and capabilities for the determination of creating a competitive advantage.

Clarify role of the generations skipping transfer tax : Clarify the role of the generations skipping transfer tax and Gene purchases an insurance policy on Mary's life and designates Ashley as beneficiary. Ashley dies first one year later.

Questions related to waiting time in restaurant : Discuss what options would a manager have to minimize the wait time and maximize the utilization of the facility and staff?

User Account

All Pages