Question: Please use the data from figure 1 to answer the following questions. Please show your work to demonstrate the proper calculations. Round all calculations to

Please use the data from figure 1 to answer the following questions. Please show your work to demonstrate the proper calculations. Round all calculations to one decimal place.
Figure 1: Realestate Loans (billions)(monthly)
\table[[Month,Dud,Month,Dud],[1,59.4,13,59],[2,59.8,14,59.3],[3,60,15,59.5],[4,60,16,59.5],[5,60,3,37,59.5],[6,60.1,18,59.7],[7,59.7,19,59.7],[8,59.5,20,60.5],[9,59.4,21,60.7],[10,59.3,22,61.3],[11,59.2,23,61.4],[12,59.1,24,61.8]]
Question 1(6 points)
Develop forecasts using a 4-month simple moving averge, a 4-month weighted moving average (Wt=.5,Wt-1=.25,Wt-2=.125, and (:Wt-3=.125}, and an exponental smoothing forecast (723=61.8,524=62.5,=3) for periods 24 and 25.
Question 2(2 points)
Please the error rates of the forecasts you created in the previous question using MAD and MAPE. Actual demand for month 25 was 62.1.
Question 3(2 points)
Which forecasting method would you recommend and why?
 Please use the data from figure 1 to answer the following

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!