Question: Excel Forecasting Homework Problem Method: Weighted Moving Average with n = 2 and weights of 0.30 and 0.70 . The data for this problem is

Excel Forecasting Homework Problem

Method: Weighted Moving Average with n = 2 and weights of 0.30 and 0.70.

The data for this problem is shown in the table below. Note: changes from the original problem dataset table are highlighted in yellow with bold font.

Time (t)	Actual A(t)
1	586.5
2	582.3
3	561.2
4	564.8
5	543.7
6	552.2
7	541.9
8	556.8
9	573.2
10	588.3
11	don't have yet

What is the Forecast for Time Period 11 using this method? ["543.830", "583.770", "555.215", "555.110", "576.512", "542.025", "589.525", "578.260"]

What is the value for Mean Absolute Error (MAE) using this method? ["14.480", "8.351", "18.622", "8.558", "17.528", "13.116", "8.614", "13.466"]

What is the value for Mean Square Error (MSE) using this method? ["218.626", "284.727", "93.824", "111.646", "479.017", "428.492", "113.447", "243.603"]

What is the value for Mean Absolute Percent Error (MAPE) using this method? ["2.392%", "1.529%", "2.540%", "1.570%", "1.498%", "2.364%", "1.847%", "3.231%"]

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!

What is forecast for time period 11? MAE MSE MAPE with excel form please! Question 2 25 pts Excel Forecasting Homework Problem Method: Weighted Moving Average with n = 2 and weights of 0.25 and 0.75....

Excel Forecasting Homework Problem Method: Exponential Smoothing with initial alpha = = 0.20 . F(1) is not given. The data for this problem is shown in the table below. Note: changes from the...

Time (t),Actual A(t) ,1,"2,385" ,2,"2,324" ,3,"2,309" ,4,"2,356" ,5,"2,315" ,6,"2,398" ,7,"2,326" ,8,"2,375" ,9,"2,343" ,10,"2,354" ,11, Create forecasts of the data using the following methods:...

Please show the formulas that i may put into microsoft excel i must show my professor the formulas in the cells on excel below. Styles Cells Inactive. lo use for free, sign in and use the Web...

Solve with only correct answers INSTRUCTIONS: ANSWER ALL QUESTIONS QUESTION A1 [25 marks] The Delux Nut Company produces a deluxe mix composed of almonds, cashews, peanuts and walnuts. The deluxe mix...

please help me and show the steps clearly Would be preferable under the circumstances. (Before solving the question, select an integer value from the given interval (except wi, W2, W3, a.), fill in...

Suppose that you work as an engineer in the planning department of a company. You consider to forecast the demand for an item which exhibits a steady demand pattern. Based on your research, you find...

. (40 points) Suppose that you work as an engineer in the planning department of a company. You consider to forecast the demand for an item which exhibits a steady demand pattern. Based on your...

Please solve it manually. Do not use excel. Consider the following forecasting method: Weighted moving average (WMA) method is basically the same as moving averages, with one major exception. With...

Forecasting Problems ( ANSWER PROBLEM 3 , WEIGHTED MOVING AVERAGE ) I strongly encourage you to attempt these problems by working through the problems on paper and using your calculators for...

Explain how efficient inventory management affects the liquidity and profitability of the firm.

For a replacement analysis, the cost of a challenger is $(10,000+ D8 100) and the current market value of the defender is $(2,000 + D8 50). Given that the MARR is 10% per year. The market values...

What is the purpose of requesting a discharge of personal liability for fiduciaries ( Form 5 4 9 5 ) ? a . To protect the fiduciary from future claims by the IRS b . To avoid filing the decedent s...

As the manager of Smith Construction, you need to make a decision on the number of homes to build in a new residential area where you are the only builder. Unfortunately, you must build the homes...