2. You have taken over the finance function of a large and successful outdoor gear store that sells primarily camping equipment such as tents, cooking gear, backpacks, and other smaller items. The owner of this store wants to get a better handle on the variation of sales of tents over the course of the year. She asks you to develop a process by which sales forecasts of tents can be made with more reliability. Up to now, there has not been a systematic process in place for forecasting tent sales, she just looked at what sales were each month, and estimated what she thought they might be in the future, based purely on her intuition. You decide to create a table for three forecasting methods to illustrate each approach to the store owner, compute the forecast for January 2022 for each approach, and provide an indication of which approach is best. You should do one of the following to complete this table. 1. Recreate the table below in excel and include it in your submitted assignment (each cell should contain the excel formula used to arrive at the number shown in each OV. OR 2. You may compute the numbers in the cells by hand and type the number in the cells. A. Compute the forecasts, differences, and deviations for EACH approach and EACH month in 2021 and place your answers in the appropriate box in the table. If you used gevell, the formulas for each cell's answer should be identifiable by the instructor. If you computed the table by hand, show the general formula used to arrive at the answer for the forecast, difference, deviation, and mean (NOT for each cell, but each type of data) B. Given the information in the table above, compute the January 2022 forecasts for each method. C. What forecasting model would you report to the store owner as the most effective? How did you determine this? Show any computations necessary and put the answers in the appropriate boxes or write your answers in the space below. 2. You have taken over the finance function of a large and successful outdoor gear store that sells primarily camping equipment such as tents, cooking gear, backpacks, and other smaller items. The owner of this store wants to get a better handle on the variation of sales of tents over the course of the year. She asks you to develop a process by which sales forecasts of tents can be made with more reliability. Up to now, there has not been a systematic process in place for forecasting tent sales, she just looked at what sales were each month, and estimated what she thought they might be in the future, based purely on her intuition. You decide to create a table for three forecasting methods to illustrate each approach to the store owner, compute the forecast for January 2022 for each approach, and provide an indication of which approach is best. You should do one of the following to complete this table. 1. Recreate the table below in excel and include it in your submitted assignment (each cell should contain the excel formula used to arrive at the number shown in each OV. OR 2. You may compute the numbers in the cells by hand and type the number in the cells. A. Compute the forecasts, differences, and deviations for EACH approach and EACH month in 2021 and place your answers in the appropriate box in the table. If you used gevell, the formulas for each cell's answer should be identifiable by the instructor. If you computed the table by hand, show the general formula used to arrive at the answer for the forecast, difference, deviation, and mean (NOT for each cell, but each type of data) B. Given the information in the table above, compute the January 2022 forecasts for each method. C. What forecasting model would you report to the store owner as the most effective? How did you determine this? Show any computations necessary and put the answers in the appropriate boxes or write your answers in the space below