Question: PLEASE POST EXCEL HOW TO DO IT a. Use a three-week weighted-moving average forecast to determine a forecast for the 8th week using weights of

PLEASE POST EXCEL HOW TO DO IT

a. Use a three-week 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). b. Calculate the MAD for this forecast (covering weeks 4 to 7). a. 3-week Weighted b. MAD Week 1 2 3 4 Sales 25 30 27 31 27 24 30 5 6 7 8 MAD

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!

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...

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...

Question 2 I. Differentiate between independent and dependent variable in forecasting ii. The last seven weeks of sales at KC car dealership can be seen in Table 2 below. Table 2 Week Sales 1 25 2 30...

i. Differentiate between independent and dependent variable in forecasting.[2 marks] ii. The last seven weeks of sales at KC car dealership can be seen in Table 2 below. Week Sales 1 25 2 30 3 27 4...

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...

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...

a. 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 most recent week receives the highest weight). (Round all...

ii. The last seven weeks of sales at KC car dealership can be seen in Table 2 below. Table 2 Week Sales 1 25 2 30 3 27 4 31 5 27 6 29 7 30 8 a. Use a three-period weighted-moving average forecast to...

Question i. Differentiate between independent and dependent variable in forecasting.[2 marks] ii. The last seven weeks of sales at KC car dealership can be seen in Table 2 below. Table 2 Week Sales 1...

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...

With the following data, prepare a statement of income and a statement of financial position. You will have fill in the missing financial statement accounts. Cost of sales ............$ 700,000...

Refer to the financial statements of Abercrombie & Fitch and Aeropostale that are supplied with this text. Required: Answer the following questions: 1. Determine the amounts in the accounting...

In a loan participation, which of the following is / are true? I. The loan buyer has no part in the original underlying credit agreement, even after purchase of the loan. II . If the selling bank...

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...