Please use given MRP planning schedule for item to answer the following questions: Unit Cost $20 Setup cost $60 Inventory holding cost per week 1.5% of unit cost Beginning inventory 60 Lead time 1 week 0 Week Demand 1 45 2 38 3 60 4 80 5 25 a Select adequate EOQ model to calculate the optimal order quantity (round up to the nearest whole number). b. Indicate the correct net requirements, planned-order receipts, and planned order releases to meet the demand in the provided table. c. Calculate the total inventory holding cost and fixed ordering cost for these 5 weeks in the provided table 0 2 3 4 5 TC Week: Item: Gross requirements OH: Scheduled receipts LT: Projected available balance SS: Net requirements Q: Planned order receipts Planned order releases Inventory Holding Cost 0 2 3 4 5 TC Week: Item: Gross requirements OH: Scheduled receipts LT: Projected available balance SS: Net requirements Q: Planned order receipts Planned order releases Inventory Holding Cost Fixed Ordering/Set-up Cost Assume that Product Z is made of three units of A and two units of B. A is made of four units of C and three of D. Dis made of three units of E. Lead times for purchase or fabrication of each unit to final assembly are: Z takes 1 week: A, B, C, and D take two week each; and takes one week 30 units of Product Z are required in Period 7. 10 units of in-incoming orders will arrive in Period 7. Z B C D E On-hand Inv. 10 15 20 50 30 10 (Lot Size) L4L LAL 200 150 LAL L4L Lead Time 1 weeks 2 weeks 2 weeks 2 weeks 2 weeks 1 week Safety Stock 0 0 0 0 0 0 1 1 Please draw the bill-of-material diagram as your own your reference to complete the MRP schedule in the provided table (Only fill out the required boxes) Weeks: 2 3 4 5 6 7 Gross Item requirement Z s : 1 Scheduled o receipts Projected LT: available balance Net SS: requirement 0 s Planned Q: order receipts Planned LAL order releases Gross requirement s Scheduled OH: 5 receipts Item 1 LT: SS: Q: Projected available 2 balance Net requirement 0 S Planned order receipts Planned order releases Gross requirement B S 2 Scheduled o receipts Projected available 2 balance L4L Item : OH: LT: Net SS: Q: 200 requirement 0 S Planned order receipts Planned order releases Gross requirement C s 5 Scheduled o receipts Item . OH: Projected LT: available 2 balance Net SS: requirement 0S Planned Q: order receipts Planned 150 order releases Gross Item requirement DS : 3 Scheduled o receipts Projected LT: available 2 balance Net SS: requirement 0 s Planned Q order receipts Planned LAL order releases Gross Item requirement E s 1 Scheduled OH: 0 receipts LT: 1 SS: 0 Projected available balance Net requirement S Planned order receipts Planned order releases Q: L4L