End unit P is composed of four K subassemblies and one W. K is assembled using t
ID: 455391 • Letter: E
Question
End unit P is composed of four K subassemblies and one W. K is assembled using three Gs and two Hs, While Ws are assembled using three Ms and two Ns. Your only on hand inventories are 50 Ks and 120 Gs. Assemble time for P is 1 day; assembly time for K is 1 day; and lead time for G is 2 days. There are scheduled deliveries of 1600 Gs at the start of day 2 and 2000 Gs at the start of day 4. Ks are only made in lot sizes of 200 (and therefore can order only multiples of this), but Gs may be ordered on a lot-for-lot basis. A) You have two orders of finishhed product for days 5 and 7 as shown below. Avoid backorders and negative inventories. Complete the MRP for Finished product, P Assembly K, and Part G. B) How many and when do Part G's need to be ordered? C) How maby K's are left over at the end of week 7?Explanation / Answer
Projected On Hand Calculation = Last Period Closing + Scheduled Receipt + Planned Receipt - Gross Requirement Net Requirement = Last Period Closing + Scheduled Receipt - Gross Requirement (If the above calculation results in negative amount, then such amount is taken as Net Requirement, else 0) Planned Receipt = If Net Requirement > 0, Planned Receipt as per Lot Size Planned Order Release = If Planned Receipt >0, Order as per Lead Time to be placed Item = P Q = 25 SS = 0 LT : 1 Period 0 1 2 3 4 5 6 7 Gross Requirement 0 0 0 0 150 0 250 Scheduled Receipts 0 0 0 0 0 0 0 Projected On Hand 0 0 0 0 0 0 0 0 Net Requirements 0 0 0 0 150 0 250 Planned Receipts 0 0 0 0 150 0 250 Planned Order Release 0 0 0 150 0 250 0 4 Units of K are required when order for A is released. Item = K Q=200 SS = 0 LT : 1 Period 0 1 2 3 4 5 6 7 Gross Requirement 0 0 0 600 0 1000 0 Scheduled Receipts 0 0 0 0 0 0 0 Projected On Hand 50 50 50 50 50 50 50 50 Net Requirements 0 0 0 550 0 950 0 Planned Receipts 0 0 0 600 0 1000 0 Planned Order Release 0 0 600 0 1000 0 0 3 Units of G are required when order for K is released. Item = G L4L SS = 0 LT : 2 Period 0 1 2 3 4 5 6 7 Gross Requirement 0 0 1800 0 3000 0 0 Scheduled Receipts 0 1600 0 2000 0 0 0 Projected On Hand 120 120 1720 0 2000 0 0 0 Net Requirements 0 0 80 0 1000 0 0 Planned Receipts 0 0 80 0 1000 0 0 Planned Order Release 80 0 1000 0 0 0 0 80 and 1000 units of G needs to be ordered in period 1 and 3 respectively 50 units of K are left over at the end of Week 7
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.