Compute the 12-period moving average for the inventory data and check the proc print results. At...
Compute the 12-period moving average for the inventory data and check the proc print results. At what period does the moving average start? For your analysis, you should use SAS only.
| Inventory |
| 119.402 |
| 117.954 |
| 136.853 |
| 135.441 |
| 141.18 |
| 141.864 |
| 141.164 |
| 146.759 |
| 140.513 |
| 144.393 |
| 151.838 |
| 191.472 |
| 127.55 |
| 123.44 |
| 141.594 |
| 140.627 |
| 149.643 |
| 148.708 |
| 145.846 |
| 151.856 |
| 144.856 |
| 146.45 |
| 157.284 |
| 194.854 |
| 130.9 |
| 133.434 |
| 146.628 |
| 147.447 |
| 158.666 |
| 152.745 |
| 152.803 |
| 159.851 |
| 147.371 |
| 156.473 |
| 164.872 |
| 201.187 |
| 140.539 |
| 136.278 |
| 155.319 |
| 151.703 |
| 164.132 |
| 157.726 |
| 160.679 |
| 165.064 |
| 155.001 |
| 163.314 |
| 168.301 |
| 209.406 |
Homework Answers
12-period moving average starts from period 13.
Moving average for period 13 = Average of previous 12 periods.
FORMULAS:
| Period | Inventory | Moving Average |
| 1 | 119.402 | |
| 2 | 117.954 | |
| 3 | 136.853 | |
| 4 | 135.441 | |
| 5 | 141.18 | |
| 6 | 141.864 | |
| 7 | 141.164 | |
| 8 | 146.759 | |
| 9 | 140.513 | |
| 10 | 144.393 | |
| 11 | 151.838 | |
| 12 | 191.472 | |
| 13 | 127.55 | =AVERAGE(B2:B13) |
| 14 | 123.44 | =AVERAGE(B3:B14) |
| 15 | 141.594 | =AVERAGE(B4:B15) |
| 16 | 140.627 | =AVERAGE(B5:B16) |
| 17 | 149.643 | =AVERAGE(B6:B17) |
| 18 | 148.708 | =AVERAGE(B7:B18) |
| 19 | 145.846 | =AVERAGE(B8:B19) |
| 20 | 151.856 | =AVERAGE(B9:B20) |
| 21 | 144.856 | =AVERAGE(B10:B21) |
| 22 | 146.45 | =AVERAGE(B11:B22) |
| 23 | 157.284 | =AVERAGE(B12:B23) |
| 24 | 194.854 | =AVERAGE(B13:B24) |
| 25 | 130.9 | =AVERAGE(B14:B25) |
| 26 | 133.434 | =AVERAGE(B15:B26) |
| 27 | 146.628 | =AVERAGE(B16:B27) |
| 28 | 147.447 | =AVERAGE(B17:B28) |
| 29 | 158.666 | =AVERAGE(B18:B29) |
| 30 | 152.745 | =AVERAGE(B19:B30) |
| 31 | 152.803 | =AVERAGE(B20:B31) |
| 32 | 159.851 | =AVERAGE(B21:B32) |
| 33 | 147.371 | =AVERAGE(B22:B33) |
| 34 | 156.473 | =AVERAGE(B23:B34) |
| 35 | 164.872 | =AVERAGE(B24:B35) |
| 36 | 201.187 | =AVERAGE(B25:B36) |
| 37 | 140.539 | =AVERAGE(B26:B37) |
| 38 | 136.278 | =AVERAGE(B27:B38) |
| 39 | 155.319 | =AVERAGE(B28:B39) |
| 40 | 151.703 | =AVERAGE(B29:B40) |
| 41 | 164.132 | =AVERAGE(B30:B41) |
| 42 | 157.726 | =AVERAGE(B31:B42) |
| 43 | 160.679 | =AVERAGE(B32:B43) |
| 44 | 165.064 | =AVERAGE(B33:B44) |
| 45 | 155.001 | =AVERAGE(B34:B45) |
| 46 | 163.314 | =AVERAGE(B35:B46) |
| 47 | 168.301 | =AVERAGE(B36:B47) |
| 48 | 209.406 | =AVERAGE(B37:B48) |
Add Answer to:
Compute the 12-period moving average for the inventory data and
check the proc print results. At...
a. Given the following holding period returns, compute the average returns and the standard deviations for...
a. Given the following holding period returns, compute the average returns and the standard deviations for the Zen Corporation and for the market b. Zomb is 106 and ther e is 7 percent we would be an expected return for an investor o m Because the precedings are based on m to make them comprate with skrerateFor simplicity you can convert from m y to your by gyng e rgement returns by 12) C. How does Zem's historical average retum...
a. Given the following holding-period returns, compute the average returns and the standard deviations for the...
a. Given the following holding-period returns, compute the
average returns and the standard deviations for the Zemin
Corporation and for the market.
b. If Zemin's beta is 1.98 and the risk-free rate is 7
percent, what would be an expected return for an investor owning
Zemin? (Note: Because the preceding returns are based on monthly
data, you will need to annualize the returns to make them
comparable with the risk-free rate. For simplicity, you can
convert from monthly to...
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 actual values for 12 periods (shown in order) are: Period Data 1 45 2 52...
The actual values for 12 periods (shown in order) are: Period Data 1 45 2 52 3 48 4 59 5 55 6 55 7 64 8 58 9 73 10 66 11 69 12 74 In Excel, create forecasts for periods 6-13 using each of the following methods: -------- -5 period simple moving average; Using a 5 period simple moving average, the forecast for period 13 will be: 68 -4 period weighted moving average (0.63, 0.26, 0.08, 0.03); Using...
(CAPM and expected returns) a Given the following holding period retums, mh compute the average rums...
(CAPM and expected returns) a Given the following holding period retums, mh compute the average rums and the standad deviations for the Zemin Coporation and for the market b. If Zemin's beta is 1.32 and the risk-free rate is 7 percent, what would be an expected returs for an investor owning Zemin? (Note Because the precedng retus are based on montly daa, you wil reod to avuaire the retums to make them comparable with the risk-fhee rate. For smplicity, ycan...
1. Compute Three- week and five-week moving averages for the time series. 2. Compute the MSE for Three- week and five-week moving average forecasts. 3. What appears to be the best number of weeks...
1. Compute Three- week and five-week moving averages for the time series. 2. Compute the MSE for Three- week and five-week moving average forecasts. 3. What appears to be the best number of weeks of past data (three or five) to use in the moving average computation? Week Sale (1000s of Gallons) three-week five-week 17 21 19 23 18 16 20 18 10 20 15 12 31 34 31 14 15 16 17 18 19 20 28 32 29 34...
Understanding Variation/Managing Chaos Compute Average Moving Range, Natural Process Limits,Upper Range Limit Please answer ONLY questions...
Understanding Variation/Managing Chaos
Compute Average Moving Range, Natural Process Limits,Upper Range
Limit
Please answer ONLY questions 5, 6 and 7. Page 60 and 137
formulas provided here in image 4 and 5. Thanks
Understanding Variation/Managing Chas WHAT SHOULD YOU DO NOW? Scatistics has never been a spectator sport. Process behavior chart no exception. You should see if you can compute the limits and an XmR chart 1、 The US. Trade Deficits for the last halfof 1988 are shown in Fi...
Zane Corporation has an inventory conversion period of 69 days, an average collection period of 43...
Zane Corporation has an inventory conversion period of 69 days, an average collection period of 43 days, and a payables deferral period of 23 days. Assume 365 days in year for your calculations. What is the length of the cash conversion cycle? Round your answer to two decimal places. days If Zane's annual sales are $2,181,245 and all sales are on credit, what is the investment in accounts receivable? Do not round intermediate calculations. Round your answer to the nearest...
Zane Corporation has an inventory conversion period of 83 days, an average collection period of 33...
Zane Corporation has an inventory conversion period of 83 days, an average collection period of 33 days, and a payables deferral period of 40 days. Assume 365 days in year for your calculations. a. What is the length of the cash conversion cycle? Round your answer to two decimal places. 76 days b. If Zane's annual sales are $4,278,570 and all sales are on credit, what is the investment in accounts receivable? Round your answer to the nearest cent. Do...
please i need asap answer 1. Given the data below, compute for the following: a) Forecasts...
please i need asap
answer
1. Given the data below, compute for the following: a) Forecasts for P5 to P12 using a 4-period simple moving average b) Forecasts for P5 to P12 using a 4-month weighted moving average with the following weights: Most recent period = 0.40 2nd most recent period = 0.30 3rd most recent period = 0.20 4th most recent period = 0.10 Assuming a forecast of 5,000 units for Period 4 and a = 0.30, compute for...
a. Given the following holding period returns, compute the average returns and the standard deviations for the Zen Corporation and for the market b. Zomb is 106 and ther e is 7 percent we would be an expected return for an investor o m Because the precedings are based on m to make them comprate with skrerateFor simplicity you can convert from m y to your by gyng e rgement returns by 12) C. How does Zem's historical average retum...
a. Given the following holding-period returns, compute the
average returns and the standard deviations for the Zemin
Corporation and for the market.
b. If Zemin's beta is 1.98 and the risk-free rate is 7
percent, what would be an expected return for an investor owning
Zemin? (Note: Because the preceding returns are based on monthly
data, you will need to annualize the returns to make them
comparable with the risk-free rate. For simplicity, you can
convert from monthly to...
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
(CAPM and expected returns) a Given the following holding period retums, mh compute the average rums and the standad deviations for the Zemin Coporation and for the market b. If Zemin's beta is 1.32 and the risk-free rate is 7 percent, what would be an expected returs for an investor owning Zemin? (Note Because the precedng retus are based on montly daa, you wil reod to avuaire the retums to make them comparable with the risk-fhee rate. For smplicity, ycan...
1. Compute Three- week and five-week moving averages for the time series. 2. Compute the MSE for Three- week and five-week moving average forecasts. 3. What appears to be the best number of weeks of past data (three or five) to use in the moving average computation? Week Sale (1000s of Gallons) three-week five-week 17 21 19 23 18 16 20 18 10 20 15 12 31 34 31 14 15 16 17 18 19 20 28 32 29 34...
Understanding Variation/Managing Chaos
Compute Average Moving Range, Natural Process Limits,Upper Range
Limit
Please answer ONLY questions 5, 6 and 7. Page 60 and 137
formulas provided here in image 4 and 5. Thanks
Understanding Variation/Managing Chas WHAT SHOULD YOU DO NOW? Scatistics has never been a spectator sport. Process behavior chart no exception. You should see if you can compute the limits and an XmR chart 1、 The US. Trade Deficits for the last halfof 1988 are shown in Fi...
Zane Corporation has an inventory conversion period of 83 days, an average collection period of 33 days, and a payables deferral period of 40 days. Assume 365 days in year for your calculations. a. What is the length of the cash conversion cycle? Round your answer to two decimal places. 76 days b. If Zane's annual sales are $4,278,570 and all sales are on credit, what is the investment in accounts receivable? Round your answer to the nearest cent. Do...
please i need asap
answer
1. Given the data below, compute for the following: a) Forecasts for P5 to P12 using a 4-period simple moving average b) Forecasts for P5 to P12 using a 4-month weighted moving average with the following weights: Most recent period = 0.40 2nd most recent period = 0.30 3rd most recent period = 0.20 4th most recent period = 0.10 Assuming a forecast of 5,000 units for Period 4 and a = 0.30, compute for...
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