Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Consider the following data: Monthly Profit of an Auto Repair Shop Month Jan-14 Feb-14 Mar-14 Apr-14 May-14 Jun-14 Jul-14 Aug-14 Sep-14 Profit ($) 16,517 16,667
Consider the following data: Monthly Profit of an Auto Repair Shop Month Jan-14 Feb-14 Mar-14 Apr-14 May-14 Jun-14 Jul-14 Aug-14 Sep-14 Profit ($) 16,517 16,667 15,455 17,521 19,163 17,250 19,137 18,512 20,301 Step 1 of 4: Determine the three-period moving average for the next time period. If necessary, round your answer to one decimal place.Step 2 of 4: Determine the three-period weighted moving average for the next time period with weights of3 (most recent}, 2 (second latest time period}, and l (oldest time period}. If necessary, round your answer to one decimal place. Step 3 of 4: Determine the exponential smoothing forecast for the next time period using a smoothing constant of 0.50. If necessary, round your answer to one decimal place. Step 4 of 4: Which forecasting method is best and why?IL") Comparing the MAD scores, Exponential Smoothing is best since the MAD score is lowest. 0 Comparing the forecasts, Weighted Moving Average is best since it has the forecast closest to the latest actual observation. 0 Comparing the forecasts. Weighted Moving Average is best since it has the highest forecast. 0 Comparing the MAD scores. Weighted Moving Average is best since the MAD score is highest
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started