Hello. I'm looking for help in creating a production schedule in excel, Gantt chart style. The schedule is for Mon - Fri, 10 hour shifts. Id like the schedule to show in 1 column the routed time in units per hour to show how many units should be produced every hour, based on the total units required for that particular part number. Then on the same column, when the next part runs, the the process repeats. Basically, I want the schedule to populate for the entire day based on the production data that is loaded. See below for example.
Any help with the formulas would be greatly appreciated.
<colgroup><col width="64" style="width: 48pt;">
<col width="68" style="width: 51pt; mso-width-source: userset; mso-width-alt: 2373;">
<col width="63" style="width: 48pt; mso-width-source: userset; mso-width-alt: 2210;">
<col width="64" style="width: 48pt;">
<tbody>
</tbody>
Any help with the formulas would be greatly appreciated.
Part 1 | Part 2 | ||
Demand | 100 | 50 | |
Units/hr | 50 | 25 | |
Cycle time | 2 | 2 | |
Set up | 1 | 1 | |
Clean up | 1 | 1 | |
Start time | 5:00 AM | ||
Day | Hour | Routing 1 | Actual 1 |
Monday | 5:00 AM | 0 | |
Monday | 5:30 AM | 0 | |
Monday | 6:00 AM | 25 | |
Monday | 6:30 AM | 25 | |
Monday | 7:00 AM | 25 | |
Monday | 7:30 AM | 25 | |
Monday | 8:00 AM | 0 | |
Monday | 8:30 AM | 0 | |
Monday | 9:00 AM | 0 | |
Monday | 9:30 AM | 0 | |
Monday | 10:00 AM | 12.5 | |
Monday | 10:30 AM | 12.5 | |
Monday | 11:00 AM | 12.5 | |
Monday | 11:30 AM | 12.5 | |
Monday | 12:00 PM | 0 | |
Monday | 12:30 PM | 0 | |
Monday | 1:00 PM | ||
Monday | 1:30 PM | ||
Monday | 2:00 PM | ||
Monday | 2:30 PM | ||
Monday | 3:00 PM | ||
Monday | 3:30 PM | |