Use Exponential Smmothire to forecast the demand Porinds \begin{tabular}{|r|r|} \hline & Domand \\ \hline 1 & 100 \\ \hline 2 & 120 \\ \hline 3 & 110 \\ 4 & 99 \\ \hline 5 & 115 \\ \hline 6 & 116 \\ 7 & 121 \\ \hline 8 & 154 \\ \hline 9 & 111 \\ \hline 10 & 112 \\ \hline 11 & 118 \\ 12 & 114 \\ \hline 13 & 121 \\ \hline 14 & 117 \\ \hline 15 & 107 \\ \hline 16 & 116 \\ \hline 17 & 111 \\ \hline 18 & 123 \\ \hline 19 & 115 \\ \hline 20 & \\ \hline & \\ \hline \end{tabular} A news person sells a newspaper whoes demand history is provided in Column B. The person purchases the newspaper from a publisher by $5 /unit and then sell them to the market by $10/ unit. At the end of the day, the person can return the leftovers to the publisher by $3 /unit (the publisher pays back $3 for each leftover). What is the optimal number of the newspaper (optimal order quantity) that the person should buy from the publisher? In order to solve the problem, you need to watch the video. You can solve the problem by taking the following steps: 1. Use Exponential smoothing to forecast the demand (that is the expected demand); column B should be used for the forecast. 2. Calculate the MSE (mean squared error) to obtain the standard deviation af the demand. 3. Calculate the service level { S.L. . 4. Obtain the Z value by using the S.L. 5. Finally, obtain the optimal order quantity. Use Exponential Smmothire to forecast the demand Porinds \begin{tabular}{|r|r|} \hline & Domand \\ \hline 1 & 100 \\ \hline 2 & 120 \\ \hline 3 & 110 \\ 4 & 99 \\ \hline 5 & 115 \\ \hline 6 & 116 \\ 7 & 121 \\ \hline 8 & 154 \\ \hline 9 & 111 \\ \hline 10 & 112 \\ \hline 11 & 118 \\ 12 & 114 \\ \hline 13 & 121 \\ \hline 14 & 117 \\ \hline 15 & 107 \\ \hline 16 & 116 \\ \hline 17 & 111 \\ \hline 18 & 123 \\ \hline 19 & 115 \\ \hline 20 & \\ \hline & \\ \hline \end{tabular} A news person sells a newspaper whoes demand history is provided in Column B. The person purchases the newspaper from a publisher by $5 /unit and then sell them to the market by $10/ unit. At the end of the day, the person can return the leftovers to the publisher by $3 /unit (the publisher pays back $3 for each leftover). What is the optimal number of the newspaper (optimal order quantity) that the person should buy from the publisher? In order to solve the problem, you need to watch the video. You can solve the problem by taking the following steps: 1. Use Exponential smoothing to forecast the demand (that is the expected demand); column B should be used for the forecast. 2. Calculate the MSE (mean squared error) to obtain the standard deviation af the demand. 3. Calculate the service level { S.L. . 4. Obtain the Z value by using the S.L. 5. Finally, obtain the optimal order quantity