The following gure shows a Microsoft Excel spreadsheet that calculates
The following figure 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.

Membership TRY NOW
  • Access to 800,000+ Textbook Solutions
  • Ask any question from 24/7 available
  • Live Video Consultation with Tutors
  • 50,000+ Answers by Tutors
Relevant Tutors available to help