Question: 1. (15 Points) Develop forecasts for periods 7 through 10 for the demand data in the table below, using a) a three period weighted moving

1. (15 Points) Develop forecasts for periods 7 through 10 for the demand data in the table below, using a) a three period weighted moving average using 0.6 (for oldest data), 0.3, and 0.1 (for most recent data) b) exponential smoothing with alpha=0.7. Use a 6th period forecast of 135 as the starting point for the exponential smoothing technique, c) Calculate MAD and indicate which one of these two forecasting approaches is better for this data. Provide comments regarding results. Period Actual WMA Exp. Smoothing 1 64 2 84 3 91 4 97 5 115 6 135 7 7 137 8 9 153 10 171

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!

A). Develop forecasts for periods 7 through 10 for the demand data in the table using a three period moving average, a weighted moving average using 0.6, 0.3, and 0.1, and exponential smoothing with...

Develop forecasts for periods 7 through 10 for the demand data in the table using a three period moving average, a weighted moving average using 0.6, 0.3, and 0.1, and exponential smoothing with...

What is the forecast for period 10 using the three period weighted moving average with weights (t-1=6, t-2=0.2, t-3=0.2)? AJ Question 5 (1 point) What is the forecast for period 5 using the two...

Use the information provided below to answer the following questions. As a demand planner at Grootegeluk Mine, you want to determine the monthly sales forecast of coal (in tonnes). Table 1, below,...

To test this backup system, they use the following historical data from a cloud - based system. Jan Feb Mar Apr May Jun Jul Aug Sept Oct Nov Dec 1 2 , 0 0 0 1 4 , 0 0 0 1 1 , 0 0 0 1 5 , 0 0 0 1 5 ,...

Calculate a forecast using a three-period weighted moving average. Using the following weights. (Excel formulas included with solution) Excel File Edit View Insert Format Tools Data Window Help 70%O...

QUESTION 5 (20 Marks) Use the information provided below to answer the following questions. As a demand planner at Groolegeluk Mine, you want to determine the monthly sales forecast of coal lin...

Use the information provided below to answer the following questions. As a demand planner at Grootegeluk Mine, you want to determine the monthly sales forecast of coal (in tonnes). Table 1, below,...

QUESTION 5 (20 Marks) Use the information provided below to answer the following questions. As a demand planner at Grootegeluk Mine, you want to determine the monthly sales forecast of coal (in...

AutoSave OFF ayvc E ASSIGNMENT A - Saved to my Mac Home Insert Draw Design Layout References Mailings Review View Table Design Layout Tell me Share Comments Calibri (Bo... v 11 fo - AI Aa A V V TO AL...

With respect to Table 2.5, indicate in each case whether or not trade is possible and the basis for trade. Table 2.5 Production Possibilities in the United States and the United Kingdom Case A Case B...

A z-shaped rigid bar ABCD is suspended by a pin at B, and is loaded with vertical force P = 43750lbs. At A, a steel tie rod AF with area = 0.195 in^2, connects the section to a firm ground support at...

( 1 7 marks: 3 4 minutes ) Question 2 Assume all amownts are inclusive of VAT, whless stated otherwise. 1 5 I. You are the newly appointed accountant of Lily Enterprises ( referred to as "Lily" ) ....

Case Greenbuilders Pte Lid ("GPL") is a local construction company which specialises in providing bespoke Design and Build construction services for private residential homes that are designed to be...