Please provide the Excel formula for all questions! Information is provided. Thank you

Project Description The folks at BBB have noticed that a lot of ground beef has been spoiling, usually because there is too much stock left over after the daily demand is met. It has come to attention that a rival food truck company, Aubie Roadkill, does not have this issue due to its accurate forecasting methods. This saves Aubie Roadkill thousands of dollars each month. The current forecasting method for ground beef is simply to buy as much ground beef as the butcher has on hand for the following day. However, this forecasting method is very inaccurate, and it is leading to a major expense that BBB needs to avoid. There should be a better way to forecast the usage of ground beef. BBB has data detailing the daily demand for all the ground beef they have sold over the past two years (units are in ounces). They have provided this data in the BBB - FC Student file. The company has hired you, an outside consultant, to create a better forecasting method using this data. The folks at BBB have asked that you try the Exponential Smoothing and Weighted Noving Average forecasting methods. When using the Exponential Smoothing method, you have been asked to use an of 0.20 . For the Weighted Moving Average method, you have been asked to use a three-period weighted moving average with weights of 5,3 , and 1 , (from most recent period to latest period). "Exponential Smoothing Data" Sheet -Each column holds information you may find helpful in your analysis. The following is a data dictionary for the listed information: "Date" - Date of Usage "Day" - Day of the week (Monday - Friday) "Ground Beef Demanded (oz.)" - How many ounces of ground beef were demanded by customers on this day "Exponential Smoothing"-Insert the formula you would like to use for exponential smoothing here. "Deviations"-Insert the formula you would like to use to find the deviations for each day of data "Absoluted Deviations"-Insert the function you would like to use to find the absolute deviations for each day of data Cell range H1:I1- This cell holds the Alpha that you should be referencing for when you are calculating your Exponential Smoothing. Cell range +14:14 - This cell holds where you will calculate the final step of Mean Absolute Deviation (MAD)