The following ﬁgure shows a Microsoft Excel spreadsheet that calculates the number of kanban production cards needed, based on the MRP planned orders. Re-create this spreadsheet in Excel. Your spreadsheet should calculate new results any time a change is made to any of the highlighted cells. Your formatting does not need to be the same, but your answers should be.
To test your spreadsheet, change the production lead time to 2.5 hours and the container size to 144. The number of production cards (not rounded up) for week 1 should be 6.84, and there should be 2.69 hours' worth of inventory.