Excel Production Schedule
Budget: $250 – $750 NZD
We are a manufacturing business who manufactures a lot of small products that come together and make a big product. We sell the big product. Each order/job is different. We manufacture the product to order. If it helps, the product we make is installed on a vehicle.
There are several staff with different hours available during the week. For example, staff member A may be available (or capable of producing) 6 hours per day, 5 days a week. Staff member B may be available (or capable of producing) 3 hours per day 4 days a week. We need to be able to set the hours per day and days per week for each individual staff member. We need the ability to remove shifts for sickness and holidays, add new staff members etc.
There is only one task – called ‘Production’. All staff members work on this task. So all hours available are essentially a pool of capacity.
There are hundreds of different products with times against those products. We can export this list out of our currently scheduling software.
One order looks something like this:
Part 1000 – 30mins
Part 1013 – 90mins
Part 1027 – 120mins
Part 1035 – 5mins
Part 1040 – 15mins
Part 2345 – 60mins
The next order would be completely different. Somehow we would need to be able to select the parts in an order to calculate the time required.
Every job has a due date. We can have months worth of jobs in the schedule at any given time.
The result we are wanting is to know whether we are running ahead, on time or behind. We need to know when our next available date is to sell a product to a customer. Our staff need to know what they are working on next.
Here is an example of data that is relevant:
Staff member A 6 hours per day 5 days per week
Staff member B 5 hours per day 4 days per week
Staff member C 1.5 hours per day 5 days per week
Staff member D 3.5 hours per day 3 days per week
Orders in system (made up of lots of smaller parts that need to be scheduled)
Order number Total hours Due date
1023 17 hours 30/10/2023
1024 19 hours 31/10/2023
1025 12 hours 2/11/2023
1026 23 hours 6/11/2023
1027 8 hours 7/11/2023
1028 16 hours 9/11/2023
1029 12 hours 10/11/2023
1030 11 hours 13/11/2023
1031 14 hours 15/11/2023
1032 30 hours 16/11/2023
Attached is examples of what we’re currently working with and data of parts and times
There are several staff with different hours available during the week. For example, staff member A may be available (or capable of producing) 6 hours per day, 5 days a week. Staff member B may be available (or capable of producing) 3 hours per day 4 days a week. We need to be able to set the hours per day and days per week for each individual staff member. We need the ability to remove shifts for sickness and holidays, add new staff members etc.
There is only one task – called ‘Production’. All staff members work on this task. So all hours available are essentially a pool of capacity.
There are hundreds of different products with times against those products. We can export this list out of our currently scheduling software.
One order looks something like this:
Part 1000 – 30mins
Part 1013 – 90mins
Part 1027 – 120mins
Part 1035 – 5mins
Part 1040 – 15mins
Part 2345 – 60mins
The next order would be completely different. Somehow we would need to be able to select the parts in an order to calculate the time required.
Every job has a due date. We can have months worth of jobs in the schedule at any given time.
The result we are wanting is to know whether we are running ahead, on time or behind. We need to know when our next available date is to sell a product to a customer. Our staff need to know what they are working on next.
Here is an example of data that is relevant:
Staff member A 6 hours per day 5 days per week
Staff member B 5 hours per day 4 days per week
Staff member C 1.5 hours per day 5 days per week
Staff member D 3.5 hours per day 3 days per week
Orders in system (made up of lots of smaller parts that need to be scheduled)
Order number Total hours Due date
1023 17 hours 30/10/2023
1024 19 hours 31/10/2023
1025 12 hours 2/11/2023
1026 23 hours 6/11/2023
1027 8 hours 7/11/2023
1028 16 hours 9/11/2023
1029 12 hours 10/11/2023
1030 11 hours 13/11/2023
1031 14 hours 15/11/2023
1032 30 hours 16/11/2023
Attached is examples of what we’re currently working with and data of parts and times