Operations & Supply Chain Exam Math: EOQ, MRP, Capacity & Forecast Error (CPIM/CSCP-Style Practice)

What you'll build

What you will be able to do

Each lab ends with a concrete result that you build yourself and the checker confirms, cell by cell.

• Measure eight months of forecast error for the fictional pump maker Brightwell Pumps and find out, with the tracking signal, whether the forecast is biased.
• Calculate the EOQ for a seal kit, compare the total annual cost of three order quantities, including a price break, and pick the cheapest.
• Turn a MAD into a standard deviation, pick the safety factor for a 95 % service level, and size the safety stock and the reorder point for a housing.
• Explode the pump's planned orders into impeller requirements, net them against stock, scheduled receipts and safety stock, offset by the lead time, and pass the result down to the casting.
• Project the pump's available balance from forecast and orders, calculate discrete ATP for each MPS lot, and work out the largest new order you can promise.
• Turn planned orders into standard hours at the machining work centre, compare them with rated capacity, find the overloaded weeks and chart load against capacity.
• Calculate Brightwell's inventory turns and days of supply for the year, the carrying cost a turns target would save, and the weeks of supply per item.
• Rank ten pump parts by annual dollar usage, classify them A, B and C with cumulative shares, and plan how many cycle counts a year the policy needs.