The task is based on Inventory Models. It will provide you with demands for some periods. It will ask you to use an appropriate inventory method to manage the demand. This may require some approximation/adjustment, etc. You need to describe how the policy will be implemented, what adjustment will you make, the impact of the adjustment, and your comments/recommendations based on the implementation. Please complete the task found within the excel sheet ( Task 1) and 2) found in the picture ).

Excel Project (Basic EOQ) NOTE: Please put your student ID and then write 2023 in the cell "B2" (cell just below your ID, yellow cell ). Excel will generate the data randomly and modify the value of cell B2 (from 2023 to 2021). If you feel that your ID is wrong, then correct your ID and put 2023 again. Excel Project: 1) Use the demand data to develop the APPROXIMATE EOQ policy (compute total costs, order size, average inventory, etc.). 2) Compute the real cost based on the implementation plan. Provide your brief opinion based on the difference. Please see the example sheet (available on Moodle)