supply chain

  Rea d the Materials Requirements Planning at A-Cat Corp case in the online coursepacket. Download the Excel template for the A-Cat Corp case from Canvas. Assume that the current status of A-Cat Corp is as described in the case and that the analysis is being performed by “a colleague of Menon who is skilled in operations management”. Fill in the Excel spreadsheet with the appropriate data and formulas to compute the required information. Note that the excel file has THREE worksheets which need to be completed. Use the following tables for Exhibits 1, 3, 4 and 5 instead of the Exhibits 1, 3, 4 and 5 tables found on pages 4 and 5 in the case. Assume that a minimum safety stock level of 21 units is required for each part number (i.e., P0110, P0X, P0Y, P1X1, P1X2).