Master Schedule Creation

This assignment is due 12 noon EST on 11/17/2019.

Do not bid if you do not have a robust understanding of Supply Chain Management. 
 You must only use the resources included as links in the MASTER SCHEDULE CREATION Word Doc that is attached for citation. The paper needs to have a robust amount of citations.  

You must write to the grading rubric that located in the MASTER SCHEDULE CATION Word Doc attached. 

You must use the previous temple in the attached Excel file. The previous assignment results are attached. 

Purpose:
The purpose of this assignment is to illustrate your understanding of how the master schedule is created and how it is used to create an MRP schedule.

Using the scenario below
Create a 12-month master schedule.
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). If uncertain how to write in the third person, view this link: 
http://www.quickanddirtytips.com/education/grammar/first-second-and-third-person ;

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;