EXCEL ASSIGNMENT - Summer 2022 OMGT 3123 - Ch. 9 Forecasting Problem Below is tabled historical information for Widget Sales. Read the assignment completely before starting. TABLE 1. Historical Sales of Widgets During the last 12 months Assignment: For the widget sales data given above, your boss wants you to compare the following models using the Mean Absolute Deviation (MAD) measure of error: 1. Exponential Smoothing model for an alpha of 0.55 and a Month 1 forecast of 155 widgets. 2. Naive model with a Month 1 forecast of 155 widgets. On sheet 1 of the file build an appropriate table in Excel that includes period, actual demand, forecasts and Absolute Deviation columns for calculating MAD for the two models. Use one decimal place on all calculated numbers. In each case, be sure to calculate the MAD and make a forecast for Month 13. Also make sure there are equations behind all calculated numbers in the spreadsheet. Develop one graph for the two models of Widgets versus Month comparing actual demand to forecast demand. Make sure the graph is placed on a separate sheet (i.e., page 2), Include appropriate title for the Graph using 14-point font size on all text. On the vertical axis make sure the maximum is set to a value of 170 and the minimum value to 150 . On the horizontal axis make sure time increments are 1 month. Use the Line Chart (you can exclude the Month column). Report to your boss in a text box just below the Table on sheet 1: 1. Your full name. 2. The model that is best for the MAD measure and the corresponding Month 13 forecast. 3. Without doing any calculations, recommend a model (based on the visual result of the graph) that you think may give a better forecast than the models you have been asked to study. Explain why you think this