Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
image text in transcribedimage text in transcribedimage text in transcribedimage text in transcribedimage text in transcribed
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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Calculus Single And Multivariable

Authors: Deborah Hughes Hallett, Andrew M Gleason, William G McCallum, Daniel E Flath, Patti Frazer Lock, Sheldon P Gordon, David O Lomen, David Lovelock, Brad

6th Edition

1118475712, 9781118475713

More Books

Students also viewed these Mathematics questions

Question

5. Give examples of binary thinking.

Answered: 1 week ago