Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please provide the Excel formula I should use. xponential Smoothing Data Sheet -Each column holds information you may find helpful in your analysis. The lowing

Please provide the Excel formula I should use. image text in transcribed
image text in transcribed
xponential Smoothing Data" Sheet -Each column holds information you may find helpful in your analysis. The lowing 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:11- This cell holds the Alpha that you sbould be referencing for when you are calculating your Exponential Smoothing. Cell range H4:14- This cell holds where you will calculate the final step of Mean Absolute Deviation (MAD) Sheet Deliverables: - In cell range 03:D1045, insert a formula that will calculate the Exponential Smoothing forecast for each day. Ensure you cell reference the alpha () that is located in I1. - In cell range E2:E1045, to start calculating MAD, insert a formula that will calculate the deviation of the forecast away from the actual daily demand. - In cell range F2:F1045, to continue calculating MAD, insert a function that will calculate the absolute value of the deviations you calculated in column E. - In 14, to finish calculating MAD, insert a function that will calculate the mean of the absolute deviations you calculated in column F. \begin{tabular}{|c|c|c|c|c|c|c|c|c|c|c|c|c|} \hline 1 & A & & c & 0 & E. & F & G & H & 1 & 1 & k & \\ \hline & cos & & & & & & & & 02 & & & \\ \hline & & & 5,4544.314 & 6.146.914 & & & & & & & & \\ \hline & 1/ANO & Tunder & 4,755 & 4542 & & & & MAD & & & & \\ \hline & & FinderMonder & 1,87651959 & 3.4546,753 & & & & & & & & \\ \hline & & vondy & & 3.159 & & & & & & & & \\ \hline & & WrontearyThundir & 41141016 & & & & & & & & & \\ \hline & & Finder & & 4.316 & & & & & & & & \\ \hline & & Nonderruester & 4,4104.53 & 3.5n3.436 & & & & & & & & \\ \hline & & WoesuaderThundar & 5.0504.020 & 4.4104.30141.10 & & & & & & & & \\ \hline & & Irider & 4,735 & 4.028 & & & & & & & & \\ \hline & & Tueser & 6.6163,1.01 & 4.7955.050 & & & & & & & & \\ \hline & & & & 6.6163.103 & & & & & & & & \\ \hline & & Frier & & 4.420 & & & & & & & & \\ \hline & 1/21/2 & MonderTuestri & 6.1773.100 & 6.0381982 & & & & & & & & \\ \hline & & & 3.355.724 & 3760 & & & & & & & & \\ \hline & & Foder & 3,154,69 & & & & & & & & & \\ \hline & & Mondy & & & & & & & & & & \\ \hline 23 & 2 & & & & & & & & & & & \\ \hline & & & & 729605 & & & & & & & & \\ \hline & & mender & & 6.94 & & & & & & & & \\ \hline & & & & 6,179 & & & & & & & & \\ \hline & & & & 3,325,200 & & & & & & & & \\ \hline & & under & 4+170 & & & & & & & & & \\ \hline & & & 4.105 & & & & & & & & & \\ \hline & & & 61506,900 & & & & & & & & & \\ \hline & 23n & Wonder & 3163 & 1.950 & & & & & & & & \\ \hline \end{tabular}

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Project Management A Managerial Approach

Authors: Jack R. Meredith, Samuel J. Mantel Jr.

8th edition

470533021, 978-0470533024

More Books

Students also viewed these General Management questions