Please show work on excel and this is for Operations Management so please do NOT do it if you don't know operations management equations for inventory theory and if you are NOT planning on using excel. Thank you. Please choose from the multiple-choice for each question.

Part A. For Questions 1-6, assume a constant demand, D=3120 items/year, lead time, LT=1.3 weeks, safety stock, SS=5, unit ordering cost, Co=$40/order, and the unit carrying cost, Cc=$3/item/week. Question 1. If the lot size, Q=30, then which of the following represents the weekly inventory period? (A) 0.10 (B) 1.25 (C) 0.50 (D) 2.50 (E) 3.00 Question 2. If the lot size, Q=30, then which of the following represents the annual order frequency? (A) 104.0 (B) 10.0 (C)2.3 (D) 26.0 (E)130.0 Question 3. If the lot size, Q=30, then which of the following represents the average inventory per inventory period? (A) 45 (B)15 (C)22 (D) 29 (E) 20 Question 4. If the lot size, Q=30, then which of the following represents the reorder point?. (A) 20 (B) 30 (C) 50 (D) 85 (E) 105 Question 5. If the lot size, Q=30, then which of the following represents the total annual inventory cost, TIC (where TIC-TOC+TCC)?_ (A) $8320.00 (B) $7280.00 (C) $6240.00 (D) $625.00 (E) $6420.00 Question 6. If the unit carrying cost, Cc=$39/item/quarter, then which of the following represents the economic order quantity? (A) 40 (B) 57 (0)14 (D) 28 (E) 70