Question

OBLEM ONE (30 POINTS) Wombat International operates a major assembly facility in Oolitic, Indiana. The primary product assembled at their Oolitic facility is the "A." Here is the Bill of Materials for the "A:" c(2) D(2) Here is additional inventory data about the items mentioned above: Lead Time Lot-Sizing Rule Lot-for-lot Scheduled Receipts Beginning!nventory 10 20 SKU none Lot-for-lot 40(week 1) none 100 Finally, here is the Master Production Schedule for the current planning window: Week Units of A 40 10 Please complete the following three tasks for the situation described above. Please complete the Materials Requirements Planning (MRP) analysis for the situation. You may use the "MRP Grid" sheet printed on the next page, or you may use the work the Excel file that is attached to the Canvas Assignment for this exam. 1. sheet named 01-MRP-GRID in Assume that the MRP analysis you prepared in part (1) appears on your screen on Monday morning of week one. Please describe, as specifically as possible, any immediate decisions that you must resolve. Then describe, in general, anticipatory issues you must consider due to the plan. Five sentences or less, please. 2. On Wednesday morning of Week 1, you ask someone to perform a cycle count on the "A" inventory in the warehouse. She discovers that although the data above states there should be ten units in inventory entering Week 1, there are really only five units of "A" in the warehouse at that time. How 3. does this affect your plans? Be specific about the effects on plans for item "A." Five sentences or less, please

Answer 1

Steps to create the MRP table 1) Enter the gross requirement as per Master Planning Schedule (MPS). Gross requirement of components is calculated as per usage in parent item 2) Enter Schedule Order Receipts (SOR), if there are any 3) Project On hand is calculated by this formula = Previous period project on hand +scheduled receipts + Planned order receipts - gross requirement 4) Net requirement Gross requirement - Projected on hand 5) Planned Order Release (POR) is manually entered such that time phased planned order receipt is equal to net requirement For example, if lead time is 1 period, and there is net requirement of 80 units in period 3, then there is a planned order release for 80 units in period 2, i.e. 1 period prior to the period in which requirement occurs. Planned Order Release quantity is as per the Lot size specified, i.e. LFL, or Fixed Order Quantity, or PoQ or EOQ or in Multiples of a specified quantity 6) If there is safety stock specified for an item, then safety stock quantity is added in Planned Order Release so that Project On Hand remains greater than or equal to safety stock as specified MRP TABLE I Item Beg. Inv.1 Gross Requirement Scheduled Recei Proiected on Hand Net Requirement Planned Order Receipt Planned Order Release 10 SOR = 10 10 10 LFL 10 Item Beg. Inv.1 Gross Requirement Scheduled Recei Proiected on Hand Net Requirement Planned Order Receipt Planned Order Release 10 SOR- 20 20 20 20 10 20 30 10 30 30 Item Beg. Inv.1 Gross Requirement 20 SOR4 Scheduled Receipt Proiected on Hand Net Requirement Planned Order Receipt Planned Order Release 20 20 LFL Item Beg. Inv.1 Gross Requirement Scheduled Recei Proiected on Hand Net Requirement Planned Order Receipt Planned Order Release 20 SOR- 100 100 30 30 30 30 30 20