Note: Data for these problems are in the Module 2 Individual Assignments Data file - there is a tab for each problem, A...
All answers should be entered using two decimal places unless otherwise specified. If both decimal places are zeros – then just enter the integer value. Percentages should be entered without “%” sign - 3.45% should be entered as 3.45. M 2 _ IND 1 . Mariah Henderson is a WCU studen t who has just finished her junior year. The data in Worksheet IND 1 summarizes her grade point average (GPA) for each of the last 9 semesters. a) Compute...
Forecasting Models. This is one problem that requires the use of Excel newly created, blank Excel file, with no use of copy and pasting anything into the spreadsheet or use any kind of a template. (a) Calculate the forecast of Jeannette's GPA for the fall semester of her senior year using a 3-period moving average. (b) Calculate the forecast of Jeannette's GPA for the fall semester of her senior year using a 3-period weighted moving average, with the weights 1,...
1Year Sales (in $1000s) 283 288 336 388 406 412 416 435 428 435 462 452 474 476 497 487 523 528 532 552 4 4 6 6 9 10 11 10 12 11 13 12 14 13 1514 16 15 17 16 18 17 19 18 20 19 21 20 23 24 Module 2 Assisted Problems Note: Data for these problems are in the Module 2 Assisted Assignments Data file-there is a tab for each problem. All answers should...
answer 1-3 please don't copy from previous post. good luck Problems #3, 5, 7 (P3) The owner of the Chocolate Outlet Store wants to forecast chocolate demand. Demand for the preceding four years is shown in the following table: Year Demand (Pounds) 1 68,800 2 71,000 3 75,500 4 71,200 Forecast demand for Year 5 using the following approaches: (1) a three-year moving average; (2) a three-year weighted moving average using .40 for Year 4, .20 for Year 3, and...
Name 1. Observations of the demand for a certain part stocked at a parts supply depot during the calendar year 1999 were Month Janua Demand 89 57 144 221 Februa March ril Ma June Jul August September October November December 280 223 286 212 275 188 312 Determine the forecasts for July though December of the year 1999 considering 2, 3, and 6- month moving averages Compute the MAD for the obtained forecasts. Which method gave you better results? Determine...
1. Regression is always a superior forecasting method to exponential smoothing, so regression should be used whenever the appropriate software is available. (Points :1)TrueFalse2. Time-series models rely on judgment in an attempt to incorporate qualitative or subjective factors into the forecasting model. (Points : 1)TrueFalse3. A trend-projection forecasting method is a causal forecasting method. (Points : 1)TrueFalse4. Qualitative models attempt to incorporate judgmental or subjective factors into the forecasting model. (Points : 1)TrueFalse5. The naive forecast for the next period...
Consider the following time series data. Week 1 2 3 4 5 6 Value 19 13 16 12 18 14 a. Which of the following is a correct time series plot for this data? - Select your answer -plot #1plot #2plot #3Item 1 What type of pattern exists in the data? - Select your answer -VerticalHorizontalScatterItem 2 b. Develop the three-week moving average forecasts for this time series. Compute MSE and a forecast for week (to 2 decimals if necessary)....
4. The following data are monthly sales of jeans at a local department store. The buyer would like to forecast sales of jeans for the next month, July. (a) Forecast sales of jeans for March through June using the naive method, a two-period moving average, and exponential smoothing with an a = 0.2. (Hint: Use naive to start the exponential smoothing process.) (b) Compare the forecasts using MAD and decide which is best. (c) Using your method of choice, make a forecast for...
PLEASE ONLY ANSWER IF YOU CAN DO WHAT IS BLANK, I DON'T NEED HELP WITH WHAT IS FILLED OUT ALREADY. THANK YOU! Problem 15-03 (Algorithmic) Consider the following time series data. Week 1 2 3 4 5 6 Value 1914 16 10 17 15 Using the naive method (most recent value) as the forecast for the next week, compute the following measures of forecast accuracy: a. Mean absolute error (MAE) b. Mean squared error (MSE) c. Mean absolute percentage error...
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...