Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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 2020 by line by product. Include in your submission: 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 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 50 and is worth 17.5% of the course grade. Version 3 instructions: Choose four 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 21 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 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 23,24,25)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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions