Material Requirements Planning POM

Material Requirements Planning POM

The assignment is listed below along with required guidelines.

There are 2 questions to be answered.

The write up should be in 12 font APA format for the written part of the assignment. The calculations should be in Word but also the calculations should be either spelled out in the Word document for all questions and if Excel used to calculate the excel spreadsheets should be provided as well.

Submit correct solutions:

oThe required elements for problem 15-12: (a) correctly calculate the on-hand quantity for each of the eight periods, (b) correctly calculate the order size base on the lot size and production needs, (c) correctly determine when to place the order based on the lag time, and (d) correctly show when the purchased orders will arrive.

oFor problem 15-13: (a) correctly calculate the on-hand quantity for each of the eight periods, (b) correctly calculate the order size base on the lot size and production needs, (c) correctly determine when to place the order based on the lag time, and (d) correctly show when the purchased orders will arrive.

2.Write 1–3 paragraphs that demonstrate your knowledge of the concepts from the assigned reading related to the problem solutions

3.Write 1–3 paragraphs that explain the solution using the concepts from the assigned reading that relate to the solution.

The required elements for problem 15-12: (a) correctly calculate the on-hand quantity for each of the eight periods, (b) correctly calculate the order size base on the lot size and production needs, (c) correctly determine when to place the order based on the lag time, and (d) correctly show when the purchased orders will arrive.

Complete the following MRP matrix for item A:

Item: A	LLC: 1	Period
Lot Size: Mult 50	LT: 2	1	2	3	4	5	6	7	8
Gross Requirements		10	15	25	75	60	85	45	60
Scheduled Receipts
Projected on Hand	50
Net Requirements
Planned Order Receipts
Planned Order Releases

15-13

For problem 15-13: (a) correctly calculate the on-hand quantity for each of the eight periods, (b) correctly calculate the order size base on the lot size and production needs, (c) correctly determine when to place the order based on the lag time, and (d) correctly show when the purchased orders will arrive.

Complete the following MRP matrix for Item X. Determine when orders should be released and the size of those orders.

Item: X	LLC: 0	Period
Lot Size: Min 50	LT: 2	1	2	3	4	5	6	7	8
Gross Requirements		25	30	56	25	100	40	30	20
Scheduled Receipts			50
Projected on Hand	30
Net Requirements
Planned Order Receipts
Planned Order Releases