Consider the following time series data.Week12346Value191416111814a. Construct a time series plot.1Time Series Value20104Week2Time SeriesValue20-104WeekTime SeriesValue TimeSeriesValue-20F10245Week- Select your answer - vWhat type of pattern exists in the data?- Select your answer - vb. Develop the three-week moving average forecasts for this time series. Compute MSE and a forecast for week 7 (to 2 decimals if necessary).MSEThe forecast for week 7c. Use a = 0.2 to compute the exponential smoothing forecasts for the time series. Compute MSE and a forecast for week 7 (to 2 decimals).MSEThe forecast for week 7d. Compare the three-week moving average approach with the exponential smoothing approach using a = 0.2 Which appears to provide more accurate forecasts based onMSE? Explain.The three-week moving average provides aSelect your answer - v forecast than the exponential smoothing approach since it has aSelect your answer - v MSE.e. Use a smoothing constant of a = 0.4 to compute the exponential smoothing forecasts. Compute MSE (to 2 decimals).Does a smoothing constant of 0.2 or 0.4 appear to provide more accurate forecasts based on MSE? Explain.The exponential smoothing forecast using a = 0.4 provides aSelect your answer - v forecast than the exponential smoothing forecast using a = 0.2 since it has a- Select your answer - v MSE.

1) plot 1 horizontal b) Time period Actual Value(A) Moving avg. Forecast(F) Forecast error…

Answered: Week 1 2 3 4 5 6 Value 19 14 16 11 18…

Week 1 2 3 4 5 6 Value 19 14 16 11 18 14 . Construct a time series plot. Time Series Value 20 F10 4 5 Week Time Series Value 20 F10 4 Week

Practical Management Science

6th Edition

ISBN:9781337406659

Author:WINSTON, Wayne L.

Publisher:WINSTON, Wayne L.

Chapter2: Introduction To Spreadsheet Modeling

Section: Chapter Questions

Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...

See similar textbooks

Similar questions

Month# Jan Feb Mar Apr May June Forecast# 1800 1500 1100 1500 2100 1600 Name Labor hours per unit (hr/unit) Initial number of workers Safety Stock (units) Working hours in a day(hr/day) Beginning inventory(units) Value 5 30 0 9 450 Month# Jan Feb Mar Apr May June Working Days available 21 21 21 21 21 19 The tables present forecasts, production, and cost information for aggregate planning. Using a level strategy with backorders to produce at average demand, now many workers are required each month? (Round up the calculated number of workers to the nearest whole number, and round the production rate to the nearest whole number
4. Spears Rowbuck has recorded the following sales figures. Calculate the seasonal indices for Thursday and Friday. Week 1 Week 2 Week 3 Week 4 Monday 43 51 40 66.0 Tuesday 45 41 57 58.6 Wednesday 22 37 30 34.7 Thursday 25 22 33 36.7 Friday 31 25 37 25.0 a. Thursday = 29.18, Friday = 29.50 b. Thursday = 0.2074, Friday = 1.1632 c. None of the other options. d. Thursday = 0.7678, Friday = 0.7763 e. Thursday = 0.6142, Friday = 0.6211
need help with this question! Note:- • Do not provide handwritten solution. Maintain accuracy and quality in your answer. Take care of plagiarism. • Answer completely. • You will get up vote for sure.
A store’s demand figures are given in the table. According to this, what is the linear regression forecast for Week 12?
t sales 1 324 2 245 3256 4 567 5 346 6 357 7 357 8 257 9 1678 What is the predicted future sales for time period 13?
1. 1.Alabama llc collected sales dara for four months, janurary through april. the data is janurary-17, feburary -24, march -25 and april -26. usung a three month moving average. the forcaste calue of may is a. 21 b.22 c.23 d.24 2. a decision tree branch has an expectrd monrtary value of 108. the probability of success is .6 with an outcome value of 200. what is the outcome value of failure?
Given below are the demands of a certain product over the past 10 weeks. Week | 1 2 3 4 | 5 67|89 | 10 Demand 50 64 66 68 67 63 69 67 65 66 (a) Forecast the demand for the 13th week using the following techniques: i. 3- week weighted moving average with weights 0.2, 0.3, and 0.5 ii. Exponential smoothing with a smoothing constant equal to 0.85 ii. Adjusted exponential smoothing with a smoothing constant equal to 0.85 and smoothing constant for trend equal to 0.65 (b) Compute for the accuracy of each model using the mean squared error. Based on the computed MSE, what is the best forecasting technique for this time series?
c4 need urgent in 15 minutes
Enter the correct shirt order number from the Payoff Table: 1. Maximin Rule: ____ Shirt order 2. Maximax Rule: ____ Shirt order 3. Expected Payoff Rule: ____ Shirt order Decision $ Payoff Table by Game Outcome Shirt Order Win Lose Tie Options Prob=0.5 0.4 0.1 0 0 0 0 1000 800 -200 200 2000 1600 -1500 100
php?attempt=104149&cmid%330865 aline Services v OS Ticket system My Dispense Academic Calendar N My courses 3) v Q b) Calculate the weighted moving average for periods 7 through 10 using weights of 0.6, 0.3, and 0.1. n Lo S : Cha Weighted moving Period Actual average 1 64 2 84 3 91 4 97 115 6. 135 7. 137 8. 144 6. 153 10 171 beriods 7 through 10. Use 5.
Sheet 9: Q8 Planning model Q8. Use below table to to find the profit of the company, (production plan is 3000) Y slope 2500 2000 5500 65000 7500 95000 Unit price 15.5 Units 3000 Fixed cost 19000 Y(pkp) X(pkp) alope Var cot sotal cost Sale
Week 1 2 4 Forecast Method 1 0.90 1.05 0.97 1.22 Actual Demand 0.72 1.05 1.00 0.97 Week 1 2 3 4 Forecast Method 2 0.82 1.19 0.90 1.17 Actual Demand 0.72 1.05 1.00 0.97 0 The MAD for Method 1 = thousand gallons (round your response to three decimal places). The mean squared error (MSE) for Method 1 = thousand gallons (round your response to three decimal places). The MAD for Method 2 = thousand gallons (round your response to three decimal places). The mean squared error (MSE) for Method 2 = thousand gallons (round your response to three decimal places).