You are required to: a) Complete the MRP sheet using Lot-for-Lot technique b) Calculate total cost of Lot-For-Lot Technique c) Calculate the value of EOQ using the information given in the MRP sheet d) Calculate total cost including Setup cost and holding cost of EOQ e) Find the value of Order Size (New EOQ) using your SAP ID (for SAP ID 70077555, sum all values 7+0+0+7+5+1+9+6=35) Order Size (New EOQ) would be 35 f) Calculate total cost including Setup cost and holding cost of Order Size (New EOQ). g) Compare the total cost of part b, d and f and select the optimal option Weeks 1 2 3 4 5 6 7 8 Gross requirements 47 21 63 11 41 21 43 39 Scheduled receipts 10 20 20 Projected on hand 37 Net requirements Planned order receipts Planned order releases Additional Information: Setup cost $200, Holding cost $3 per unit/per week, Lead time 2 weeks.