A scheduler's job is to take outputs from S&OP, aggregate planning, MRP and MPS and to make this data usable to the organization in the form of a production schedule. Based on this production schedule other departments can plan human resources, maintenance etc.

Based on the supplied Master Production Schedule and production constraints build a daily (by shift) breakfast cereal production schedule for six weeks in 2020 by line by product.

• A summary as to your thinking and strategy. Why did you choose this particular strategy? Do you have any conclusions regarding the schedule?
• Percentage of demand in total, by family and by sku that you produced by this plan
• The number of changeovers that were necessary to complete your plan
• The total dollar contribution if you were able to produce every case and the percentage of that which was actually produced

Version 1 instructions:

• Choose four of the five production lines to create production plans
• Create a by shift by day by sku (stock keeping unit) by line production plan for the six weeks beginning in mid-November (the 16^th) and running through to the start of Christmas holidays beginning on December 24.
• You must not exceed line capacity
• If you have two weeks in a month to schedule remember to split the monthly volume
• You may encounter situations where you have too much or too little capacity; in the latter it will be up to you to determine priority skus to produce
• Complete the assignment using the Excel template provided

Version 1 constraints:

• Due to freshness concerns one can only build inventory six weeks in advance
• Families need to be run together
• The plant runs 3 shifts a day 5 days a week. Overtime is available, but overtime costs 1.5 times more than regular shifts and the plant is restricted to two overtime shifts a week
• Due to Christmas vacation the plant is down the last week of December
• Due to Family Day, there is a vacation day the third Monday of February
• Due to Thanksgiving, there is a vacation day the second Monday of October
• There is one cleaning shift per week, typically the last shift of the week
• Line 1 is down for one week in November for Maintenance
• Line 2 is down for one week in January for Maintenance
• Line 3 is down for one week in October for Maintenance
• Line 4 is down for one week in February for Maintenance
• Line 5 is down for one week in March for Maintenance