Notice that the background color of this cell turns red if this date is older than today. When is this Revision scheduled to be reviewed for changes? Tip: To change date format - Right-click > Format Cells > Number tab When situations arise in the future that have similar conditions for lead time, demand, buffer, and safety. So that you can continuously improve your kanban calculations So that you can (optionally) track stock outs and emergency kanbans, You can also (optionally) use the 'RevLog' sheet to keep a history of revisions.Īnd notice that the Revision Log sheet has an extra column for 'Reasons for Misses' Learn more about how to personalize your Excel templates.
0 Comments
Leave a Reply. |