Please help solve a-c on problem #2 in excel with formulas. I’m am having trouble seeing how to get the forecast especially.
(C) F=56.3 is one answer.
Fall 2017-MGT 3110 HW04-Cho4-1 DUE: 9/17/2017 points Use 4 decimal places for roundingl 1. Use the data given in Problem #4.1 in the textbook for this question. Find forecasts for week 2 to 2. istory Bookmarks People Window / roblemx =c4c1x fBu Ch04-Cl X week 6 using the Naive method. Compute the values of CFE, MAD, MAPE, and MSE Problem #4.7 (textbook) Problem #4.13 (textbook). (b). For (b) use as many errors as possible. answering (b), no credit if you do.) https://etext.pearson.com/#/book/BAKX98 3. Use forecast errors for Year 2 to year 5 for computing MAD except for (If you are using Excel do not use Data Analysis for 4, Problem #426 (textbook). After computing the seasonal indices find a forecast for all the four 5. Problem 28 (textbook), instead of year 26 find the forecast for the four quarters of year 30. SHOW ALL YOUR WORK FOR FULL CREDIT NO WORK NO CREDIT!!!!! Completed homework must be uplooded to Blackboard. Acceptable file formats are pdf, docx, xlsx. quarters of year 5. Assume the annual demand for year will increase by 5% compared to year 4. asting > Problems Files of any other format will NOT be graded. Emailed homework will NOT be groded Your method uses four actual deman levels, with weights of 0.333 on the present period, 0.25 one period ago, 0.25 two periods ago, and 0.167 three Partial answer key (round to 4 decimal places): 1. MAD-19.6 2 (c) F 56.3 3 (a) For α-09 MAD . 3.6549; (c) F,-61.8 4. For Fall 1630 15 20 periods ago a. What is the value of your WEEK ACTUAL NO. OF PATIENTS forecast? Px b. If instead the weights were 20 65 15, 15, and 10, respectively, ho would the forecast change? Explain why. 2 62 c. What if the weights were 0.40, 3 70 0.30, 0.20, and 0.10, respectively? Now what is the forecast for week 7? 4 48 Assignment 2 quest docx . 63 6 52