Question: 1. Given the data in the table below, calculate the following; (1) forecast of month 8 using a three-month simple moving average and (2) forecast

1. Given the data in the table below, calculate

1. Given the data in the table below, calculate the following; (1) forecast of month 8 using a three-month simple moving average and (2) forecast of month 8 using exponential smoothing with an alpha value of 0.3. (2 pt.) Month MA (3) Exponential Forecast Smoothing Actual sale 56 76 58 67 75 76 60

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!

1. Given the data in the table below, calculate the following: (1) forecast of month 8 using a three-month simple moving average and (2) forecast of month 8 using exponential smoothing with an alpha...

12.11 The following is the historical demand for a product. Month Jan. Feb. Mar. Apr. May Jun. Demand 15 11 12 12 16 17 (a) What is the forecast for July using a simple moving average for 3 months?...

What could be the demand forecast of the 13th week? How do I compute for the /A-F/? How do I get the MAD, MSE, and MAPE and what are the requirements to recommend a forecasting model to the manager...

Manufacturing Planning and control A company has below given sales records for the past 5 periods. a. Calculate the forecast for the 6th period using exponential smoothing method! (a=0,5 ; Forecast...

I have attached 15 questions on excel. I would like the answers and the problems worked out in excel. An insurance company wants to design a control chart to monitor whether insurance claim forms are...

Case Study: Demand Forecast, Inventory Management and Capacity design at Pharma.Tech Pharma Tech is a company specialized in manufacturing and selling paramedical equipment varying from needles to...

(3 pts.) Austin Tashus Auto sells luxury sedans and SUV's. Sales for their most popular SUV, the Behemoth, for January through April were 30 (Jan) 25 (Feb), 31 (Mar), and 35 (Apr). For full credit on...

sales: 4 4 1 0 , 4 5 4 0 , 4 5 2 0 , 4 4 8 0 , 4 3 9 0 , 4 5 3 0 Calculate the forecast for the 4 th , 5 th , 6 th and 7 th months using 3 - month simple moving average, and 3 - month weighted moving...

SweetWhite SweetWhite Average Using five-months simple moving average, the forecast for 1/1/2017 is ; (Report the answer with one decimal place) the forecast for 1/1/2018 is ; (Report the answer with...

You are an investment advisor to a wealthy Swiss family who wish to extend their exposure to stocks traded abroad. You use a model of the Swiss asset market that has a factor structure with two...

Each of the double pulleys shown has a mass moment of inertia of 20 kg ?? m2 and is initially at rest. The outside radius is 400 mm, and the inner radius is 200 mm. Determine (a) The angular...

You are asked to educate the audit committee on the benefits of continuous monitoring. Which of the following benefits would not be included in your presentation because it is incorrect? Question 3...

3. Consider a household with well-behaved preferences over two goods represented by a general utility function "(C, ), with each good priced at P, and P2. The household receives an exogenous amount...