solve it in excel

0 PROTECTED VIEW Be careful--Tiles from the Internet can contain Viruses. Unless you need to edit, it's safe to stay in teda U25 A N 0 1 2 Question 6: 3 4 5 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 O, and lead time of 1 week. What are the costs of using all three methods for this to week period? a) LAL b) EOG c) POQ 7 8 9 10 11 12 Week 0 1 2 1 4 5 6 7 9 10 0 0 13 50 0 0 0 15 100 14 15 Gross Requirement Schedule Recept Project onhand Net Requirement Planned Recept Planned order Release 16 17 TB 19 20 22 20 24 26 29 30 ai 30 34 35 30 30 04) SS-PM (5) IM (Dependent) Q3) SS-PMI Q1J ODM 02) SS-Know Stock out