Please complete the tasks on the excel sheet (Tasks 1 and 2 in the image).

EXAMPLE SHEET MENTIONED IN THE PICTURE

Home Insert Draw Page Layout Formulas Data Review View Data Mining Analytic Solver U Search Sheet Select destination and press ENTER or choose Paste 225Pr (2) Q v Search Sheet Home Insert Draw Page Layout Formulas Data Review View Data Mining Analytic Solver x cut Copy General Format Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? J1fx c fx D Conditional Format Formatting as Table Styles AutoSum Fill v Clear v Sort \& e+ Share ClearVFilterSelect Yes No Periods Beginning inventory Order placed Inventory after order ar Demand (current period) Inventory carried over to I Back order Inventory Ordering charges 104 \begin{tabular}{|r|r|r|r|} \hline 101 & 3 & 0 & 26.75 \\ \hline 101 & 6 & 0 & 28.25 \\ \hline 101 & 9 & 0 & 29.75 \\ \hline 114 & 0 & 1 & 28.25 \\ \hline 101 & 2 & 0 & 26.5 \\ \hline 113 & 0 & 7 & 26.5 \\ \hline 112 & 0 & 15 & 26 \\ \hline 114 & 0 & 25 & 26 \\ \hline 103 & 0 & 24 & 26 \\ \hline 109 & 0 & 29 & 26 \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline & & & \\ \hline \end{tabular} the non-uniform demand case creates lots of backorders. Solution: 1) adjusting the order quantity, adjusting order quantity only when back orders go above a critical level (say 10), using EOQ Project Single period Model Project Select destination and press ENTER or choose Paste +100% Book1 Q. Search Sheet Home Insert Draw Page Layout Formulas Data Review View Data Mining Analytic Solver Open recovered workbooks? Your recent changes were saved. Do you want to continue working where you left off? B3 v^fx