(All Steps) points Perkins Manufacturing produces two types of products, A and B. Each unit of A requires 3 units of C, 3 units of D, and one unit of E. Product
Question: 30 points
Perkins Manufacturing produces two types of products, A and B. Each unit of A requires 3 units of C, 3 units of D, and one unit of E. Product B requires 3 units of C and 2 units of D. D requires one unit of E, and C requires 2 units of E.
The following table shows Information for MPS quantity start dates for next 10 weeks:
| Product | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 |
| A | 180 | 260 | 98 | 240 | ||||||
| B | 95 | 124 | 200 |
There is no safety stock requirement for any of the items and lot-sizing rule is FOQ. Order quantity for C, D, and E is 100, 300, and 600 respectively. Scheduled receipts are 100 item C for week 2, 300 item D for week 1, and 600 item E for week 2.
Determine the materials requirement plan for items C, D, and E for the next 10 weeks.
Deliverable: Word Document 