Question: I need help finding the forecast for period 5 on the problem below. I solved for period 4, but am unsure as to how to

I need help finding the forecast for period 5 on the problem below. I solved for period 4, but am unsure as to how to calculate for period 5 using the 3 period moving average. In case I've attached my work for period 4 below, and thank you for your help!

Use a 3 period moving average to do a forecast for periods 4 and 5 . Demand Forecast 1234524202221 For the toolbar, press ALT +F10(PC) or ALT+FN+F10 (Mar) Forecast for poriod 4 363320+22+2121

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

. Note: Please do all the question please QUESTION 4 Your manager is trying to determine what forecasting method to use. He has asked for your help because he knows that you have learnt demand...

. Note: Please solve of the answer please QUESTION 4 Your manager is trying to determine what forecasting method to use. He has asked for your help because he knows that you have learnt demand...

QUESTION 4 Your manager is trying to determine what forecasting method to use. He has asked for your help because he knows that you have learnt demand forecasting techniques at Abu Dhabi University...

ha brief sertence, explain 1 diiadvartage of ualee the s mele moving average ovet the weighted moving average. Imerf amsarhere: The Barbecue fBecj coinpany you work for recently Bired a niw demand...

11:08 Document (35) *** TABLE:3 22300 32000 4 1600 $ 2500 6 3500 7 3300 X 3200 to 4700 11 4100 12 400 13 a.. Calculate the forecast for the data using a four-year moving average b. Use the data to...

please show work for calculations CALCULATE THE FORECAST FOR PERIOD 5 USING WEIGHTED MOVING AVERAGE - same weights as used in the solved example (i.e., Question 2t=0.5,t1=0.3,t2=0.2 )...

Question Completion Status: QUESTION 4 Your manager is trying to determine what forecasting method to use. He has asked for your help because he knows that you have learnt demand forecasting...

Period Demand forecast Weighted Moving average forecast Exponential Smoothing forecast X 2 xy 1 1600 2 2200 3 2000 4 1600 5 2500 6 3500 7 3300 8 3200 9 3900 10 4700 11 4300 12 4400 13 a. Calculate...

Period Demand forecast Weighted Moving average forecast Exponential Smoothing forecast X 2 xy 1 1600 2 2200 3 2000 4 1600 5 2500 6 3500 7 3300 8 3200 9 3900 10 4700 11 4300 12 4400 13 . Calculate the...

Expxy TABLE:3 Period Demand forecast Weight Weighted Moving Smoothing average forecast 11600 2 2200 3 2000 4 1600 52500 6 3500 7 3300 8 3200 9 3900 10 4700 11 4300 12 4400 13 a. Calculate the...

a. Calculate the risk-adjusted on-balance-sheet assets of the bank as defined under Basel II. b. Calculate the risk-adjusted off-balance-sheet assets of the bank as defined under Basel II. Calculate...

A machine costing RM900,000, which can be used for five years with no salvage value left, can generate yearly income before interest and tax of RM280,000. Required: a) Compute the annual rate of...

The following end - of - year account balance information is from the accounting records of Smithfield Company. Use these data to prepare the closing entries for the year. Which ONE of the following...

The project _ _ _ _ _ answers the questions of what, when, how much, and at times where.

The company has fair promotion/advancement policies.

Refer to the Lets Talk Business feature that opens this chapter. Decide whether each of the proposals discussed there would be internal or external, unsolicited or solicited, and formal or informal....

How does the Attention/Interest/Desire/Action plan (described in Chapter 9) for writing a persuasive message apply to writing an unsolicited internal proposal? (Objectives 1 and 3)