Shop Load Report - Load Hours

And not sure if this will help with your question but here is the section for Calculating Load from the answerbook 6132MPS

Spread the load hours for each operation into the appropriate time slots, by working backward from the operation Due Date/Due Hour a day at a time, until all load hours have been applied. Production hours are applied first, then setup hours (moving backwards in time, this fits with the logical progression of the job. The assumption is that setup must be done before production.
The calculations for the load hours depend on the Load Relieved By setting in the Job Management module configuration.

  • First determine what time slot the operation due date falls into (the first End Date >= JobOper.DueDate)
  • Calculate the production load hours. (If the operation is NOT subcontract.)
  • If relieving load by quantity:
    Production Load = Estimated Hours per Piece * Qty Remaining
    Production load equals zero if the quantity completed to date exceeds the original planned quantity.
  • If relieving load by hours:
    Production load = Estimated Production Hours - Actual Hours to-date
    Production load equals zero if the hours to date exceeds the original estimate.
  • If the operation is marked as Production Complete, the load hours are always zero.
  • If the operation is scheduled to run on more than one machine, the load is divided by the number of machines.
  • If the operation is subcontract, the load = Days Out for the operation x Hours per Machine for the resource group.
  • Apply the production hours backwards, beginning with the operation due date and due hour. The first day applied is a special case, since the operation Due Time probably does not fall exactly at the end of the work day, so apply only the Due Hour as the maximum number of hours for the first day filled.
  • Calculate the setup load hours. Setup is always 0 if production has started, and for a subcontract operation.
  • If relieving load by quantity :
    Setup Load = Setup Standard - (Setup Standard * Setup Percent Complete)
  • If relieving load by hours:
    Setup load = Setup Standard - Setup hours to date
  • Setup Load hours are zero if the operation is marked as Setup Complete or the setup hours to date exceed the estimate for setup.
  • Apply the setup hours backwards, beginning where you left off with production.
3 Likes