Q9) Please show your work in the file submission to receive…
Q9) Please show your work in the file submission to receive partial credit. An MRP system is used to plan production for a finished product. The planned lead time for the product is 2 weeks. The system uses Lot-for-Lot production. Determine the Planned Order Releases for weeks 1 – 6. Please fill in the Scheduled Receipts, the Net Requirements, and the Planned Order Releases below. Week 0 Week 1 Week 2 Week 3 Week 4 Week 5 Week 6 Gross Requirements 3475 2282 3496 1865 3268 2003 Scheduled Receipts/On-hand 5000 Net Requirements Planned Order Releases On-Hand Week 1 = [OnHandW1]; On-Hand Week 2 = [OnHandW2]; On-Hand Week 3 = [OnHandW3]; On-Hand Week 4 = [OnHandW4]; On-Hand Week 5 = [OnHandW5]; On-Hand Week 6 = [OnHandW6]; Net Req. Week 1 = [NetW1]; Net Req. Week 2 = [NetW2]; Net Req. Week 3 = [NetW3]; Net Req. Week 4 = [NetW4]; Net Req. Week 5 = [NetW5]; Net Req. Week 6 = [NetW6]; POR Week 0 = [PORW0]; POR Week 1 = [PORW1]; POR Week 2 = [PORW2]; POR Week 3 = [PORW3]; POR Week 4 = [PORW4]; POR Week 5 = [PORW5]; POR Week 6 = [PORW6];
Read Details