Suppose a four period weighted average is being used to forecast demand. Weights for the periods...
Suppose a four period weighted average is being used to forecast demand. Weights for the periods are:
wt-4 = 0.1
wt-3 = 0.2
wt-2 = 0.35
wt-1 = 0.35
Demand observed in the previous four periods was:
At-4 = 15890
At-3 = 14970
At-2 = 14478
At-1 = 14628
What will be the demand forecast for period t? (Keep one decimal place in your answer).
Homework Answers
Demand forecast for period t
= Wt-1 x at-1 + Wt-2 x At-2 + Wt-3 x At-3 + Wt-4 x At-4
= 0.35 x 14628 + 0.35 x 14478 + 0.2 x 14970 + 0.1 x 15890
= 5119.80 + 5067.3 + 2994 + 1589
= 14770.1
|
Demand forecast for period t = 14470.1 |
Add Answer to:
Suppose a four period weighted average is being used to forecast
demand. Weights for the periods...
Suppose a four period weighted average is being used to forecast demand. Weights for the periods...
Suppose a four period weighted average is being used to forecast demand. Weights for the periods are: wt-4 = 0.05 wt-3 = 0.15 wt-2 = 0.35 wt-1 = 0.45 Demand observed in the previous four periods was: At-4 = 10245 At-3 = 9800 At-2 = 9796 At-1 = 9714 What will be the demand forecast for period t? (Keep one decimal place in your answer).
Develop a two-period weighted moving average forecast for periods 12 through 15. Use weights of 0.9...
Develop a two-period weighted moving average forecast for periods 12 through 15. Use weights of 0.9 and 0.1, with the most recent observation weighted higher Demand 229 389 461 330 406 Period 10 12 13 Calculate the forecasts for periods 12-15 by using a two-period weighted moving average model (enter your responses rounded to the nearest whole number) Demand 229 389 461 330 Forecast Period 10 12 13 14 406
"The MAD for the forecast developed using a weighted 2-year moving average with weights of 0.45...
"The MAD for the forecast developed using a weighted 2-year
moving average with weights of 0.45 and 0.55 = __ miles (round
your response to one decimal place). (Hint: You will have only 3
years of matched data.)"
Score: 0 of 1 pt 3 of 5 (1 complete) HW Score: 0%, 0 of 5 pts Problem 4.5 Question Help The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to...
For problerms 7 througl use the following time serles data:l Th fol PERIOD DEMAND 221 247 228 233...
Use
excel, show excel commands. #8
For problerms 7 througl use the following time serles data:l Th fol PERIOD DEMAND 221 247 228 233 240 152 163 155 167 158 4 5 7 10 7. () Develop a last period forecast for periods 2 through 11. Calculate the MFE, MAD, and MAPE values for periods 2 through 10. Is this a good model? Why? 8. () Develop a three-period weighted moving average forecast for periods 4 through 11. Use weights...
The ollowing 12 periods of actual demand are to be used to produce a double exponential smoothin forecast or period 13. Use a smoothing constant α e 10 se 70 as the inna al to orecast values ll Click...
The ollowing 12 periods of actual demand are to be used to produce a double exponential smoothin forecast or period 13. Use a smoothing constant α e 10 se 70 as the inna al to orecast values ll Click the icon to view the demand for the previous 12 periods Complete the table below for a double exponential smoothing forecast (enter your responses rounded to one decimal place). More Info Period at FD(DES) 64 Period 35 70 41 64 35...
2. The historical demand for a product is below. Please forecast the demand in April. Month...
2. The historical demand for a product is below. Please forecast the demand in April. Month Sales (a) Use a 3-month simple moving average. 1 (January) 33 (b) Use a 3-month weighted moving average with weights of 0.6, 0.3, and 0.1. 2 (February) 36 © Use exponential smoothing with a = 0.8 and a March forecast = 37. 3 (March) 39 (d) Find trend line y=a+bx, and then forecast demand. (3 points)
2. The historical demand for a product is below. Please forecast the demand in April. Month...
2. The historical demand for a product is below. Please forecast the demand in April. Month Sales (a) Use a 3-month simple moving average. 1 (January) 33 (b) Use a 3-month weighted moving average with weights of 0.6, 0.3, and 0.1. 2 (February) 36 (c) Use exponential smoothing with a = 0.8 and a March forecast = 37. 3 (March) 39 (d) Find trend line y = a+bx, and then forecast demand. (3 points)
PART 1) USE A WEIGHTED MOING AVERAGE OF THE following data with weights of 3, 2...
PART 1) USE A WEIGHTED MOING AVERAGE OF THE following data with weights of 3, 2 (MOST RECENT TO OLDEST). PART 2) WHat is the MAPE value for your forecast? Month Actual DEMAND 1 15 2 10 3 30 4 25
rue False 6. Going lean if done properly will increase quality defects. True False 7. Price...
rue False 6. Going lean if done properly will increase quality defects. True False 7. Price is not a factor in the basic EOQ formula. True False ate ue Fals 13. A process that exhibits random variability would be judged to be out of control. True False 14. A p-chart is used to monitor the fraction of defectives in the output of a process True False 15. Run tests are useful in helping to identify nonrandom variations in a process....
This Question: 1 pt 15 of 111 (14 complete) Use the following 12 periods of demand...
This Question: 1 pt 15 of 111 (14 complete) Use the following 12 periods of demand to produce a double exponential smoothing forecast for period 13. Use a smoothing constant, a, equal to 0.30. Use 508 as the initial forecast values. Click the icon to view the demand for the previous 12 periods. Complete the table below for a double exponential smoothing forecast (enter your responses rounded to one decimal place). Period at FD (DES) 558 OOOOOOOOOOL 893 819 854...
Develop a two-period weighted moving average forecast for periods 12 through 15. Use weights of 0.9 and 0.1, with the most recent observation weighted higher Demand 229 389 461 330 406 Period 10 12 13 Calculate the forecasts for periods 12-15 by using a two-period weighted moving average model (enter your responses rounded to the nearest whole number) Demand 229 389 461 330 Forecast Period 10 12 13 14 406
"The MAD for the forecast developed using a weighted 2-year
moving average with weights of 0.45 and 0.55 = __ miles (round
your response to one decimal place). (Hint: You will have only 3
years of matched data.)"
Score: 0 of 1 pt 3 of 5 (1 complete) HW Score: 0%, 0 of 5 pts Problem 4.5 Question Help The Carbondale Hospital is considering the purchase of a new ambulance. The decision will rest partly on the anticipated mileage to...
Use
excel, show excel commands. #8
For problerms 7 througl use the following time serles data:l Th fol PERIOD DEMAND 221 247 228 233 240 152 163 155 167 158 4 5 7 10 7. () Develop a last period forecast for periods 2 through 11. Calculate the MFE, MAD, and MAPE values for periods 2 through 10. Is this a good model? Why? 8. () Develop a three-period weighted moving average forecast for periods 4 through 11. Use weights...
The ollowing 12 periods of actual demand are to be used to produce a double exponential smoothin forecast or period 13. Use a smoothing constant α e 10 se 70 as the inna al to orecast values ll Click the icon to view the demand for the previous 12 periods Complete the table below for a double exponential smoothing forecast (enter your responses rounded to one decimal place). More Info Period at FD(DES) 64 Period 35 70 41 64 35...
2. The historical demand for a product is below. Please forecast the demand in April. Month Sales (a) Use a 3-month simple moving average. 1 (January) 33 (b) Use a 3-month weighted moving average with weights of 0.6, 0.3, and 0.1. 2 (February) 36 © Use exponential smoothing with a = 0.8 and a March forecast = 37. 3 (March) 39 (d) Find trend line y=a+bx, and then forecast demand. (3 points)
2. The historical demand for a product is below. Please forecast the demand in April. Month Sales (a) Use a 3-month simple moving average. 1 (January) 33 (b) Use a 3-month weighted moving average with weights of 0.6, 0.3, and 0.1. 2 (February) 36 (c) Use exponential smoothing with a = 0.8 and a March forecast = 37. 3 (March) 39 (d) Find trend line y = a+bx, and then forecast demand. (3 points)
rue False 6. Going lean if done properly will increase quality defects. True False 7. Price is not a factor in the basic EOQ formula. True False ate ue Fals 13. A process that exhibits random variability would be judged to be out of control. True False 14. A p-chart is used to monitor the fraction of defectives in the output of a process True False 15. Run tests are useful in helping to identify nonrandom variations in a process....
This Question: 1 pt 15 of 111 (14 complete) Use the following 12 periods of demand to produce a double exponential smoothing forecast for period 13. Use a smoothing constant, a, equal to 0.30. Use 508 as the initial forecast values. Click the icon to view the demand for the previous 12 periods. Complete the table below for a double exponential smoothing forecast (enter your responses rounded to one decimal place). Period at FD (DES) 558 OOOOOOOOOOL 893 819 854...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 10 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 10 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 10 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 10 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 10 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 10 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 10 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 10 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 10 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 10 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 10 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 10 months ago