0 2 170 5. [CH, 14. Lot Sizing in Material Requirement System (MRP) (10 pts) Thomas, who is a senior at APU, recently got a job as a production planner at Tesla Assembly Plant in Fremont, CA. His first task on the job training is to review a production plan/master production plan (MPS) as shown below: (Initial inventory = 170 units, Ordering cost = $250 per order, Lead time = 1 weck, Holding cost = $3 per unit per week. No penalty cost for shortage/stock-outs.) Part: Period Lot-for-Lot Lot Sizing 1 3 4 5 Gross requirements 100 170 200 150 10 Develop an ordering plan and costs for this plant using the following techniques. (a) Develop the lot-for-lot MRP table and calculate the total relevant costs. (3 points) Part: Period Lot-for-Lot Lot Sheing 0 1 2 3 4 5 Gross requirements 100 200 150 10 Scheduled receipts Projected available (Begining.) 170 Inv. On hand (End of period) Net requirements Planned order receipts Planned order releases Lead time 1 wk Lot size Holding Cost = Ordering Cost = Total Cost = (6) Develop the Economic Order Quantity (EOQ) lot sizing technique. (Assume EOQ = 220) (3 points) EOQ Lot Sizing EOQ TO 1 2 3 4 5 Gross requirements 170 200 150 Scheduled receipts Projected available (Beg.) 170 Inv. On hand (End of period) Net requirements Planned order receipts Planned order releases Lead time wk Lot size Holding Cost = Ordering Cost Total Cost 100 10 (c) Develop the Periodic Order Quantity (POQ) lot sizing technique. (POQ Interval = 3 weeks) 3 points) POQ Interval 3 wks POQ Lot Sizing 1 2 3 4 5 Gross requirements 100 170 200 150 10 0