help me with this excel problem is I am a little stuck?

AutoBave = DFF Final Exam - Template - Read-Only ASFO Draw Page Layout Home Insert Formulas Dhia Review View Tell me Share Comments - 11 - A A = abwe Text Accounting Accenta Accenta Acants ACTIE Ay. FC LM Pase X Out Calibri (ody) Copy BIU A for C4C15 Mits FU C *- -- Mees Center Cora Condon Format Tarating web Currency Insert Dalane Forna Delete Finds Select Analyze Duca Sonstity no 027 A B D E F G H 1 J K L M N N o Q Question 2: Target 1 2 2 3 4 5 5 6 Target purchases home goods made by a supplier in China. Target's stores in the United States sell 200,000 units of home goods each month. Each unit costs $10 and the company has an annual holding cost of 20 percent. Placing a replenishment order incurs clerical costs of $500/order. The shipping company charges $5,000 as a fixed cost per shipment along with a variable cost of $0.10 per unit shipped. What is the optimal order size for Target? What is the annual holding cost of the optimal policy? How many orders per year does Target place? What is the annual fixed transportation cost? What is the annual variable transportation cost? What is the annual clerical cost? 7 8 9 9 10 11 $ 12 13 Input Annual demand, D Cost per unit, Holding cost, Fixed transportation cost per order Fixed clerical cost per order Variable shipping cost per unit 2,400,000 10.00 20% 5,000.00 500.00 0.10 14 15 $ $ $ 16 17 18 Intermediate Calculation Fixed cost incurred per order, S , 5 19 20 21 22 23 24 25 26 27 Optimal Order Policy Optimal batch size, Q* Annual holding cost Number of orders per year Annual fixed transportation cost Annual variable transportation cost Annual clerical cost 34,641 $ 34,641.00 69.28 $ 592,487.11 $ 240,000.00 $ S 34,641.02 28 29 30 31 Question 1 Question 2 Question Question 4 Questions Question Question + IH 11 -- + 17%