please do it in excell and show me the formula as well

B N C D E F G H KIM Question 6: Hip Replacements, Inc., has a master production schedule for its newest model, as shown below, a setup cost of $50, a holding cost per week of $2, beginning inventory of 0, and lead time of 1 week. What are the costs of using all three methods for this 10- week period? a) L4L b) EOQ c) POQ 3 1 0 ON 6 4 0 8 9 On 10 50 7 15 35 0 100 0 Week 0 Gross Requirement Schedule Reciept Project onhand Net Requirement Planned Reciept Planned order Release