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. They’ve 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.

Additional Requirements:

• The explanation of each part of the assignment must be doubled spaced and should be at least two pages in length.
• Third person writing is required. Third person means that there are no words such as “I, me, my, we, or us” (first person writing), nor is there use of “you or your” (second person writing).
• Contractions are not used in business writing, so you are expected NOT to use contractions in writing this assignment;
• Use APA formatting for in-text citations and reference page. You are expected to paraphrase and not use quotes. Deductions will be taken when quotes are used and found to be unnecessary;
• The expectation is that you provide a robust use of the course resources. No books or outside references can be used. When using a source document, the expectation is that the information is cited and referenced with a page or paragraph number;