Core Manufacturing uses MRP to schedule its production. Due to the current recession and the need to cut costs, the company has targeted the inventory investment area for cost reduction. However, the company does not want to reduce its customer service level in the process. Demand and inventory data for a standard Part 9250 are given in the following table. Complete an MRP record/table for Part 9250 using: (a) L4L (Lot for Lot) (b) minimum of 150 parts (c) P=2 weeks (start with the first week you do not have enough parts in inventory to cover next week's demand) (d) EOQ = 300 parts Determine the cost of each method based on ordering and holding costs. Which lot sizing rule do you recommend? Ordering cost =$100 per order Holding cost = $1 per part per week Lead time = 1 week Beginning inventory = 200 Part 9250 2 3 5 1 Week 180 220 135 Demand 150 190 Core Manufacturing uses MRP to schedule its production. Due to the current recession and the need to cut costs, the company has targeted the inventory investment area for cost reduction. However, the company does not want to reduce its customer service level in the process. Demand and inventory data for a standard Part 9250 are given in the following table. Complete an MRP record/table for Part 9250 using: (a) L4L (Lot for Lot) (b) minimum of 150 parts (c) P=2 weeks (start with the first week you do not have enough parts in inventory to cover next week's demand) (d) EOQ = 300 parts Determine the cost of each method based on ordering and holding costs. Which lot sizing rule do you recommend? Ordering cost =$100 per order Holding cost = $1 per part per week Lead time = 1 week Beginning inventory = 200 Part 9250 2 3 5 1 Week 180 220 135 Demand 150 190