Hello,
I am trying to create a Manufacturing ProductionSchedule. I am looking for help with a formula that once given start date/time,will then calculate the end date/time. The formula for the time betweenthe start date and end date, is calculated by using the Machine/CycleTime (Kept on a separate Page) divided by the available minutes in a work shiftat 90% which is 25900.
That end date/time would then be the start date/time forthe next production order, etc. Production only runs Monday-Friday and notholidays, but does run three shifts.
Any help in this would be greatly appreciated. I have been trying to figure this out for acouple of months now!
MLBrown
I am trying to create a Manufacturing ProductionSchedule. I am looking for help with a formula that once given start date/time,will then calculate the end date/time. The formula for the time betweenthe start date and end date, is calculated by using the Machine/CycleTime (Kept on a separate Page) divided by the available minutes in a work shiftat 90% which is 25900.
That end date/time would then be the start date/time forthe next production order, etc. Production only runs Monday-Friday and notholidays, but does run three shifts.
Any help in this would be greatly appreciated. I have been trying to figure this out for acouple of months now!
MLBrown