I need help answering the part in RED. All other information is for background purposes. Please show Excel formulas in answer.

10.15. Given the following MRP record and an EOQ of 200 units, calculate the plannea order receipts using the economic order quantity. Next, calculate the period order quantities and the planned order receipts. In both cases, calculate the ending inven- tory and the total inventory carried over the 10 weeks. 6 + 3 7 8 5 9 Total 1 10 2. Weck Net Requirements 70 00 0 TOO 80 75 VO 80 65 0 Planned Order Receipt Ending NV For Question 10.15, complete the portion asked for in the book. In addition, assume the order cost/order (S) is $200 and the holding cost/week (h) is $0.75/unit. Determine the 10 week total ordering cost and total carrying cost using the EOQ method, and recalculate the 10 week total ordering cost and total carrying costs using the POQ method. Which method will you recommend and why? 1 2 . 4 5 6 8 9 10 Total 3 60 & Co 70 O 100 80 7 70 200 O 80 Week Net Requirements Planned Order Receipt Ending Inventory 600 75 200 200 600 125 55 195 195 95 15 145 80 80 0 985