Question: Develop a single exponential smoothing forecast for Periods 2 through 9, using the data below. Each time you develop a forecast, round your answer off

Develop a single exponential smoothing forecast for Periods 2 through 9, using the data below. Each time you develop a forecast, round your answer off to a whole number (ex. -2012.6 = 2013.) Use a smoothing constant value of 0.3.

Week 1 2 3 4 5 6 7 8 9 Actual Demand

Week 1 2 3 4 5 6 7 8 9 Actual Demand 6541 5887 6214 6672 6018 6999 6279 6803 Forecast

Step by Step Solution

★★★★★

3.37 Rating (163 Votes )

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock

To develop a single exponential smoothing forecast well use the formula Ft alpha times Dt1 1 alpha t... View full answer

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 Accounting Questions!

Q:

Develop two exponential smoothing forecasts for periods 2 through 11. For the rst forecast, use a = 0.2. For the second, use a = 0.7. Assume that your forecast for period 1 was 250. Plot the results....

Q:

Develop a last period forecast for periods 2 through 11. Calculate the MFE, MAD, and MAPE values for periods 2 through 10. Is this a good model? Why? PERIOD DEMAND 1............ 221 2............ 247...

Q:

Develop a single exponential smoothing model using = 0.20. Use as a starting value the average of the first 6 years data. Determine the forecasted value for year 2010. a. Compute the MAD for this...

Q:

forcasting ( using excel) C F G J9 XV fx A B D E F H 1 Chapter 9: Forecasting 2 3 4 DIRECTIONS Enter your 4-digit number to generate the homework key. 5 6 Name: 7 4-digit number: 2000 8 9 10 Develop...

Q:

supply chain mangment forecasting using excel - show your work B C D E F G H K 1 Chapter 9: Forecasting 4 DIRECTIONS Enter your 4-digit number to generate the homework key. Name: *** KEY *** 4-digit...

Q:

Please explain your answer. Thank you (: Develop a single exponential smoothing forecast for Periods 2 through 9, using the data below. Each time you develop a forecast, round your answer off to a...

Q:

Develop a single exponential smoothing forecast for Periods 2 through 9, using the data below. Each time you develop a forecast, round your answer off to a whole number (ex. - 2012.6 = 2013). Use a...

Q:

Please explain with all the formulas!! Thank you! Develop a single exponential smoothing forecast for Periods 2 through 9, using the data below. Each time you develop a forecast, round your answer...

Q:

Please explain the steps taken to solve. Develop a single exponential smoothing forecast for Periods 2 through 9, using the data below. Each time you develop a forecast, round your answer off to a...

Q:

Manchester United, it's a public company believe it or not. Stock symbol is MANU. Questions: MANU has many companies, so it needs to do consolidated accounting, what is the main risk with...

Q:

Which of the following statements about budgeting is false? O Budgeting is an aid to planning and control. Budgets create standards for performance evaluation. Budgets help coordinate the activities...

Q:

On 1 June 2018, Zaqim Najah established ZN Enterprise for undertaking brokerage services. The following transactions had taken place during the month of June 2018. Eljay invested RM150,000 cash in...

Q:

Which of the following statements is correct the interest rate on a new issue of noncallable bonds is likely to exceed that on a similar issue of collateral bonds. Noncollectible bonds are higher or...

Q:

Element 'A' belongs to Group VIIA and element 'B' belongs to group IA of the periodic table. Out of the following assumptions, the correct one is (A) A and B are metals (B) A and B are non-metals (C)...

Q:

Two spheres each of mass 'm', each moving with velocity u moving in directions at 30S of E and 30N of E respectively collide at point O and stick to each other. The velocity of the combination later...

Q:

match the country with the common type of flood insurance available there. Question 2 options: 1 New Zealand Brazil Germany United Kingdom South Africa Denmark Australia United States France Belgium...

Q:

Develop a single exponential smoothing forecast for Periods 2 through 9 , using the data below Develop a single exponential smoothing forecast for Periods 2 through 9, using the data below. Each time...

Q:

Your manager is trying to determine what forecasting method to use. Based upon the following historical data, calculate the following forecast and specify what procedure you would utilize. MONTH...

Q:

c. Calculate the single exponential smoothing forecast for periods 212 using an initial forecast (F 1 ) of 64 and anof 0.40. Calculate the weighted three-month moving average for periods 412 using...

Q:

A retail store records customer demand during each sales period. The data has been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to develop the single...

Q:

A retail store records customer demand during each sales period. The data has been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to develop the single...

Q:

A retail store records customer demand during each sales period. The data has been collected in the Microsoft Excel Online file below. Use the Microsoft Excel Online file below to develop the single...