Question: 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.




View Solution:


Sale on SolutionInn
Sales0
Views77
Comments
  • CreatedApril 10, 2015
  • Files Included
Post your question
5000