The manager of the Carpet City outlet needs to make an accurate forecast of the demand for Soft Shag carpet (its biggest
-
- Site Admin
- Posts: 899603
- Joined: Mon Aug 02, 2021 8:13 am
The manager of the Carpet City outlet needs to make an accurate forecast of the demand for Soft Shag carpet (its biggest
In the carpet city problem, according to the result from Excel and/or POM-QM (3-month moving average), the forecast for month 9 is (type number only, two decimals) 11
1 In the carpet city problem, compute the mean absolute deviation (MAD) for the 3-month moving average forecasts. It is (type number only, two decimals) 2.16
In the carpet city problem, compute a weighted 3-month moving average forecast for month 4 through month 9. Assign weights of .55, .33 and .12 to the months in sequence, starting with the most recent month. According to the result from Excel and/or POM-QM, the forecast for month 4 is (type number only, two decimals) 8.80
In the carpet city problem, according to the result from Excel and/or POM-QM (weighted 3-month moving average), the forecast for month 9 is (type number only, two decimals) 11.20
In the carpet city problem, compute the mean absolute deviation (MAD) via Excel and/or POM- QM for the weighted 3-month moving average forecasts. It is (type number only, two decimals)
For the carpet city problem, upload your Excel file that shows 3-month moving average and the weighted 3-month moving average forecasts with weights of .55, .33 and .12. The mean absolute deviation (MAD) computations of the two forecasts should also be included in the excel. Upload Choose a File