We are trying to refine our job shop scheduling system
I would like an accumulated total for available hours minus sheduled hours to determine if our work load is leveled.
60 hours are available per day.
Each day has many jobs with scheduled times for each.
I need to subtract each scheduled time from a 60 hour day accumulating the difference to the following day, etc.
The example below shows "Hrs" for each job
3/17 would have 60 hours available at days end as there are no "hrs" required.
4/22 would then start with 120 hours (60 hours carried over) and end with 113.33 (6.67 job subtracted)
4/30 would then start with 173.33 and end with 172.75
5/8 has multiple jobs. Each job would be subtracted from the running balance start total efore the next day 60 hours would be added
Can anyone help with a solution?
|Due Date||Part #||To Ship||Customer||On Hand||S/O||BU/SO||Bin||U/M||Hrs||Description||PO #|
|03/17/15||4080231||4.00||1||4.00||214844||212484||ASSEMBLY||12.0||0.00||03/17/15 B2124849 408023||4080232|
|04/30/15||1176-00007||1.00||TAPC0001||0.00||214958||214957||ASSEMBLY||35.0||0.58||04/30/15 B214957 1ST ART||PO206932|
|05/01/15||N4511255502||13.00||OMP0001||13.00||215692||215693||ASSEMBLY||25.0||0.00||05/01/15 B215693 L1||703945|
|05/06/15||39000020||10.00||HERA0001||0.00||215717||215718||ASSEMBLY||60.0||10.00||05/06/15 B215718 1ST BL||4020155482|
|05/08/15||GENISYS||22.00||1||0.00||214991||214993||ASSEMBLY||64.0||23.47||05/08/15 B214993 N169096||N16909601|
|05/08/15||GENISYS||30.00||1||0.00||214992||214996||ASSEMBLY||64.0||32.00||05/08/15 B214996 N169096||N16909601|
|05/08/15||MLK II||22.00||1||0.00||214991||214995||ASSEMBLY||44.0||16.13||05/08/15 B214995 N169096||N16909601|
|05/08/15||MLK II||30.00||1||0.00||214992||214998||ASSEMBLY||44.0||22.00||05/08/15 B214998 N169096||N16909601|