Using the scenario below

1. Create a 12-month master schedule.
2. Create a MRP schedule that supports the master schedule.

Jones Company now needs to develop a master schedule and an MRP schedule based on the customer demand forecast you developed for the X52 power supply back in Assignment 1. Theyve asked for your assistance. Use this forecast: JAN THROUGH APRIL 2,700 per month; MAY THROUGH AUGUST 3,000 per month; SEPTEMBER THROUGH DECEMBER 3,300 per month. Lot sizes for X52 are 3,000 and to produce one X52, you need two units of 23A, one unit of 46B, and three units of 29C. You currently have 6,000 units of 23A in stock, 4,000 of 46B and 9,000 of 29C. Lead time to buy each of these three components is one month.

Required Elements of the 12- Month Master Schedule:

• Use a spreadsheet or a template you develop to create a 12 month master schedule. Make sure to include all requirements for each month.
• Explain in detail, using the data created by you and the course material, how you arrived at the schedule entries. Be sure to explain the logic applied to arrive at the conclusions drawn and support your logic with assigned course readings and videos.

Required Formatting of MRP Schedule:

• Use the template format to create a MRP schedule. Make sure to complete all requirements for each month.
• Explain in detail, using the data created by you and the course material, how you arrived at the schedule entries. Be sure to explain the logic applied to arrive at the conclusions drawn and support your logic with assigned course readings and videos.