Name:_________________ /40 Demand Management Scheduling Take Home Assignment Version 3 A schedulers 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 2023 by line by product. Include in your submission: A summary as to your thinking and strategy. Why did you choose these particular strategies and tactics? 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 What version of the assignment you are working on Please save your assignment in the following form Assignment 4-version x- name Place in Dropbox by due date Failure to include the above in the submission will result in significant reduction in grade The assignment will be marked both objectively and subjectively. Please ensure that your submission contains each of the points above. It will be marked out of 40 (summary worth 24 and Excel worth 16) and is worth 17.5% of the course grade. Version 3 instructions: Choose three of the five production lines to make plans for Create a by shift by day by sku (stock keeping unit) by line production plan for the six weeks beginning in September 23 and running through to the end of October 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 3 constraints: Due to freshness concerns one can only build inventory six weeks in advance Families need to be run together as much as possible Each family change incurs a changeover; each changeover is one half shift (4 hours) Each change of families incurs a large changeover worth one full shift (8 hours) 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 New Years Day there is a vacation day on January 1 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 three days (September 25,26,27) 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