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...
3. (40 points) Smith Nevada, the managing editor of Your Horoscope magazine, needs to develop a forecasting system for monthly newsstand sales in order to schedule press runs. Sales in thousands of copies for the first 6 months of publication were: Year 2018 Month January February March Sales 80 65 75 70 65 72 May June Smith does not believe that there is a seasonal pattern. He considers four different forecasting methods. Naive, Three-period Moving Average, Simple Exponential Smoothing with...
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...
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)....
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...
4,10,11,18,20 Sales (in thousands) 25 40 Training Hours 10 12 12 15 ses expo- monthly er, the ary. The been 200 sales have mand for 50 uses a Com (a) Compute the correlation coefficient for the data. g trend for What is your interpretation of this value? (b) Using the data, what would you expect sales to be a seasonal ter, as this me ski de- he summer n come for ntain trails. make a fore- l annual de- s....
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...