Question: please solve by formula calculation not excel thank you 2-The last seven weeks of demand at a new car dealer are shown below. Use a

please solve by formula calculation not excel thank you

2-The last seven weeks of demand at a new car dealer are shown below. Use a three-period weighted-moving average forecast to determine a forecast for the 8th week using weights of 7, 2, and 1 (where the most recent week receives the highest weight). (Round all forecasts to the nearest whole unit.) Calculate the MAD for this forecast (covering all weeks in which error comparisons can be made). What does the MAD indicate? Week vau WN 2 3 4 5 6 7 Sales 25 30 27 31 27 24 30

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!

Problem 1 The last seven weeks of demand at a new car dealer are shown below. Use a three-period weighted-moving averages method with n=3 to determine a forecast for the 8th week using weights of 3,...

The last seven weeks of demand at a new car dealer are shown below. Use a three-period weighted moving average to determine a forecast for the 8th week using weights of 1, 2, and 3. Calculate the MAD...

The last seven weeks of demand at a new car dealer are shown below. The last seven weeks of demand at a new car dealer are shown below. Week 1 2 3 Sales 25 30 2 B 27 4 31 5 38 5 6 6 40 42 7 8 a a)...

Problem 2 (25 points) The last seven weeks of demand at a new car dealer are shown below. Week 6 Demand 25 30 27 31 27 29 8 7 30 a- Use a two period moving average to determine the forecast for the...

PLEASE ANSWER BOTH QUESTIONS THANK YOU SO MUCH! QUESTION 2 The last seven weeks of demand at a new car dealer are shown below. What is the forecast for the 8th week using a three-period...

I need help in this question. Please do it correctly and dont make it wrong. Please do it on MS WORD and copy/paste here and use the below formulas to do it. Question 5 (40 points) The last seven...

3 The last seven weeks of demand at a new car dealer are shown below. Use a three-period weighted-moving average forecast to determine a forecast for the 8th week using weights of 3, 2, and 1 (where...

The last seven weeks of demand at a new car dealer are shown below. a) Use a three-period weighted-moving average to determine a forecast for the 8th week using weights of 3, 2, and 1. Calculate the...

Ethics, managers performance evaluation. (A. Spero, adapted) Hamilton Semiconductors manufactures specialized chips that sell for $20 each. Hamiltons manufacturing costs consist of variable cost of...

Multiple Choice Questions The following apply to evaluating results of audit sampling for tests of details of balances. For each one, select the best response. a. While performing a substantive test...

What does Extended Business Income provide coverage for? Group of answer choices To assist the insured while recovering to the level where operations were prior to the loss For new business ventures...

Read the articles on journaling and review the template provided. Identify what approach, to journaling, in the articles you found useful and why. Post to the discussion forum that you have reviewed...