Question: How to solve using excel Given the following historical demand data, detelmine a forecast for period 30 (Fan) under each method listed below the data.

How to solve using excel

Given the following historical demand data, detelmine a forecast for period 30 (Fan) under each method listed below the data. I D: 22 678 23 688 24 700 25 692 26 698 27 709 28 688 29 704 30 a] Simple Moving Average forecast [use n = 4] Fan: 1)] Weighted Moving Average forecast [use weights of 0.5, 0.3, 0.1, 0.1 where the 0.5 weight is on most recent demand] Fag: C] Exponential Smoothing forecast [use alpha of 0.4 and assume that F29 was found to be 695.04] Fag

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

1. Lehigh University wants to design a control chart to monitor whether course registration forms are being completed correctly. The university intends to use the chart to see if improvements in the...

Select an appropriate forecasting method and use the method to forecast the demand for quarters I, II, III, and IV for years 6 to 8. PLEASE NOTE: THIS HAS NOTHING TO DO WITH CLEAR OR BLACK PLASTIC!!...

The sales are $10 million this and expected to grow at 5% in real terms for the next three years. The appropriate nominal discount rate is 10%. The inflation is expected to be 2% per year during the...

Part 1: Finding information: Each of the following questions should be answered within the table provided in file entitled "PART 1 TABLE." American Eagle's 2009 10-K is in the file entitled...

answer only question 3 AutoSave C - Glos Demand forecasting Fire Exercise NEF (1) Excel Scarch Rajesh Dip File Home Insert Page Layout Formulas Data Review View Help Share Comments Calibri AutoSum 12...

The following table shows the historical demand data for product A in AusCandy Co. Answer the following questions. Period 1 6 00 OWN Actual demand 77.00 45.28 48.03 47.87 78.88 51.85 53.51 58.54...

AutoSave C - Globo Demand forecasting Fire Exercise NEE (1) Excel Scarch Rajesh Dip File Home Insert Page Layout Formulas Data Review View Help Share Comments X Out Calibri Auto Sum AA == 89 Wrap...

I need the following homework exercise completed. All of the information is within the attached files. I require no explanations, just the answers. Part 1: Finding information: Each of the following...

Kindly help me with this and give me the right solution. Thanks Best Regards OPERATIONS MANAGEMENT ASSIGNMENT Assignment 1 (Individual Assignment) 20% of overall mark), Due date: 4 March 2022 10 pm...

In September 1954, using $500 to buy some basic equipment and a bicycle for deliveries, the Saputo family founded the company in Montreal bearing their name. Today, Saputo produces, markets, and...

What is the relative brightness of the Sun as seen from Jupiter as compared to its brightness from Earth? (Jupiter is 5.2 times farther from the Sun than the Earth).

8. A circle is inscribed in a square. The circumference of the circle is increasing at a constant rate of 6 inches per second. As the circle expands, the square expands to maintain the condition of...

what discount rate is used to discount future cash flows to the present

Securities is a mutable map, and we want to value it against an immutable map prices.The formula is: value = securities(symbol) prices(symbol) for every symbolsecurities. We would like to do...