Question

In: Finance

Special Note: The teacher wants the question to be explain step by step, not worked out....

Special Note: The teacher wants the question to be explain step by step, not worked out.

Given is a historical time series for job services demand in the prior 6 months. Month Demand 1 11 2 13 3 14 4 12 5 13 6 14 a) In your own words, explain (do not show how to solve) how to compute MSE based on the 3 months moving average method b) In your own words, explain (do not show how to solve) how to compute MAD based on the 3 months moving average method c) In your own words, explain (do not show how to solve) how to compute MAD based on the Exponential smoothing α = 0.2 method The teacher wants question to be explain step by step not worked out.

Solutions

Expert Solution

(a)

MSE is the Mean Squared error

First we need to find the forecasted values. Since we are using 3 months moving average, we will find the forecasted values for months 4, 5 and 6. The 3 months moving average is the average of last 3 months services demand i.e. Ft = (At-1 + At-2 + At-3)/3

Now we need to find the squared error for these 3 months. The squared error is the square of the difference between the actual value and the forecasted vale. Find this for months 4, 5, 6.

Once we find the squared errors, we find the average of the squared errors for months 4, 5, and 6. This average value is the MSE

(b)

MAD is the Mean Absolute error

First we need to find the forecasted values. Since we are using 3 months moving average, we will find the forecasted values for months 4, 5 and 6. The 3 months moving average is the average of last 3 months services demand i.e. Ft = (At-1 + At-2 + At-3)/3

Now we need to find the absolute error for these 3 months. The absolute error is the absolute difference between the actual value and the forecasted vale. Find this for months 4, 5, 6.

Once we find the absolute errors, we find the average of the squared errors for months 4, 5, and 6. This average value is the MAD

(c)

We need to first find the exponential smoothened forecast using the exponential smoothening coefficient. For period 1 we assume that the forecast is same as the actual value.

Exponential forecast values for other months is calculated as sum of forecast for previous month plus the smoothened difference between the actual value in last month and forecast in last month i.e. Ft = Ft-1 + α(At-1 + Ft-1)

Now we need to find the absolute error for months 1 to 6. The absolute error is the absolute difference between the actual value and the forecasted vale. Find this for months 1, 2, 3, 4, 5, 6.

Once we find the absolute errors, we find the average of the squared errors for months 1, 2, 3, 4, 5, and 6. This average value is the MAD


Related Solutions

Note: I need a step by step answer to the question with an explanation of your...
Note: I need a step by step answer to the question with an explanation of your answer so that I can understand how to reproduce the steps. Marsha Inc. has the following budgeted data for 2016: Cash balance, beginning $15,000 Collections from customers 145,000 Direct materials purchases 25,000 Expenses: Operating expenses 50,000 Payroll 75,000 Income taxes 6,000 Other: Machinery purchases 30,000 Operating expenses include $20,000 depreciation for buildings and equipment. All purchases of materials are paid for in the period...
Note: I need a step by step answer to the question with an explanation of your...
Note: I need a step by step answer to the question with an explanation of your answers: White Corporation’s budget calls for the following sales for next year: Quarter 1 90,000 Quarter 3 68,000 Quarter 2 76,000 Quarter 4 96,000 Each unit of the product requires 3 pounds of direct materials. The company’s policy is to begin each quarter with an inventory of product equal to 5% of that quarter’s estimated sales requirements and an inventory of direct materials equal...
XYZ Co. wants to get a special instrument to control a critical step in their production...
XYZ Co. wants to get a special instrument to control a critical step in their production line. The instrument has an acquisition cost of $25,000 and will lead to a savings of $10,000 per year for 5 years. They want to evaluate different methods of financing the acquisition. Assume that if they buy it they will use MACRS depreciation for 3-year property. Their effective income tax rate is 44%, and their after-tax MARR is 16%. The rest of the corporation...
QUESTION TWO A teacher has worked in the same primary school for two years. While chatting...
QUESTION TWO A teacher has worked in the same primary school for two years. While chatting to the children, she is concerned to find that the majority of them come to school without having eaten a healthy breakfast. In her opinion, children who eat ‘a decent breakfast’learn to read more quickly and are better behaved than children who do not. She now wants to set up a pre-school breakfast club for the children so that they can all have this...
Can I please get a step by step (either video or written out) for this question....
Can I please get a step by step (either video or written out) for this question. I don't know where to find the step by step videos. They are EXTREMELY helpful. The inverse demand for a homogeneous-product Stackelberg duopoly is P = 16,000 -4Q. The cost structures for the leader and the follower, respectively, are CL(QL) = 3,000QL and CF (QF) = 6,000QF.. a. What is the follower’s reaction function? b. Determine the equilibrium output level for both the leader...
Often times, the special education teacher and general education teacher have opinions on when a student...
Often times, the special education teacher and general education teacher have opinions on when a student needs a change in placement, whether it be less restrictive, or more restrictive; however, the student is left out of the dialogue. At what grade/age is it important to bring the student’s insight into the discussion? Why is it important to include the student’s opinion into the decision? ?
The question: A teacher is trying to figure out how fast he can throw a Baseball,...
The question: A teacher is trying to figure out how fast he can throw a Baseball, but doesn't have a radar gun. He does have the following: - Baseball - Soft styrofoam Block ( In which the ball could become embedded into during a collision) - A level tabletop - A metre stick - A balance scale. The teacher also has determined the coefficient of friction between the block and table. NOTE: The kinetic coefficient of friction is determined while...
Explain the way to construct pad footing step by step with sketch. 1) Setting Out 2)...
Explain the way to construct pad footing step by step with sketch. 1) Setting Out 2) Excavation Works 3) Install Formwork 4) Install Reinforcement 5) Inspection of workdone before concreting 6) Concreting work
Please clear writing and explain step by step this should be a simple question Consider the...
Please clear writing and explain step by step this should be a simple question Consider the function f : [0,1]→R defined by (f(x) =0 if x = 0) and (f(x)=1 if 0 < x≤1) (i)Compute L(f) andU(f). (ii) Is f Riemann integrable on [0,1]?
9. Explain the different systems of measurements with special focus on SI System. note: neet it...
9. Explain the different systems of measurements with special focus on SI System. note: neet it in word file
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT