Using the Case Exhibit 3, set up a model for minimum and maximum inventory levels for Westa Petroleum Services (WPS). In your opinion, is the algorithm used for lead time and quantity that ahmed devised appropriate? What would be the impact on cost of bringing the inventory to the maximum level immediately?

22/733C For the exclusive use of D. Carbungco, 2023. Inventory Management at Westa Petroleum Services EXHIBIT 3: INVENTORY ITEMS CONSUMED IN THE LAST TWO YEARS Exhibit 3 (in the supplemental Excel file) shows the details of various inventory items held by WPS in the past two years. Column A: the serial number. Column B: the number of units of each inventory item consumed in the past 2 years. Column C: the locations where these inventory items were imported from. Column D: the name of the inventory item. Column E: the manufacturer from which the inventory was bought. Column F: the distinct part numbers of the items. Column H: the number of units held in the current inventory for each inventory item. Column G: the units of measurement of inventory. Column I: the price per unit. Column J: the dollar value of each inventory item which was obtained by multiplying Column H and Column J. Some inventory items had a cost per unit of zero because these items had passed their certified life.