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

Material Requirements Planning POM