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 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 Actual sale | MA (3) Exponential Forecast Smoothing 56 76 58

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!

Part B L /101 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...

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

Procter & Gamble is a well known organization that focusing on dairy and vary types of products are Looking after enhancement and beyond of it by improving the sales on specific brand Tide in...

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

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

Go to the (ISC)2 Web site at www.isc2.org. Research the knowledge areas included in the tests for both the CISSP and the SSCP. What areas must you study that are not included in this text?

If a company employs the gross method of recording accounts receivable from customers, then sales discounts taken should be reported as a) an item of "other expense" in the income statement. b) a...

13. The probability of a twenty-year-old man living to age seventy is .74, and the probability of a twenty-year-old woman living to the same age is .82. If a recently married couple, both age twenty,...

I don't understand to how slove this problem Exercise and Stress Many studies have shown that people who engage in any exercise have improved mental health over those that never exercise. In...