Please do NOT answer these questions if you do NOT know OPERATIONS MANAGEMENT and if you will NOT be using Excel to answer it. Please USE Excel to answer and operations management equations shown in your work on excel. Thank you. Please select the correct answer as well (A-E) OR (A-H) for each question to confirm your answer matches up with one of the multiple-choice answers above. Thank you

Part B. Assume a constant demand, D=260 items/month, lead time, LT=1.5 weeks, safety stock, SS=10, unit ordering cost, Co=$24/order, and unit carrying cost, Cc=$26/item/year. Question 7. If the lot size, Q=240, then how many of the following statements are true?. (A)0 (B)1 (c)2 (D) 3 (E) 4 Statement 1. The inventory period is 4 weeks Statement 2. The order frequency is 13/year Statement 3. The annual average inventory is 122 Statement 4. The reorder point is 100 Question 8. Which of the following represents the total carrying cost during one lead time? (A) $18.69 (B) $27.00 (C) $21.40 (D) $36.00 (E) $41.25 Part C. Assume: constant demand, D=1560 items/year, lead time, LT= 1.5 weeks, safety stock, SS=20 items, unit ordering cost, Co-$390/order, unit carrying cost, Cc=$1.50/item/month, order frequency, F=2 orders/quarter. Question 9. Which of the following represents the inventory policy for a periodic review system? (A) (65, 195 ) (B) (1.5 weeks , 195) (C) ( 45, 195) (D) (1.5 weeks , 260 ) (E) (65, 260) (F) (6.5 weeks , 195 ) (G) ( 45 , 260) (H) (6.5 weeks , 260) Question 10. Which of the following represents the inventory policy for a continuous review system? (A) (6.5 weeks, 195 ) (B) (45, 195) (C) (1.5 weeks, 195) (D) (65, 195 ) (E) (6.5 weeks , 260) (F) (65, 260) (G) ( 1.5 weeks , 260 ) (H) ( 45 , 260) Part B. Assume a constant demand, D=260 items/month, lead time, LT=1.5 weeks, safety stock, SS=10, unit ordering cost, Co=$24/order, and unit carrying cost, Cc=$26/item/year. Question 7. If the lot size, Q=240, then how many of the following statements are true?. (A)0 (B)1 (c)2 (D) 3 (E) 4 Statement 1. The inventory period is 4 weeks Statement 2. The order frequency is 13/year Statement 3. The annual average inventory is 122 Statement 4. The reorder point is 100 Question 8. Which of the following represents the total carrying cost during one lead time? (A) $18.69 (B) $27.00 (C) $21.40 (D) $36.00 (E) $41.25 Part C. Assume: constant demand, D=1560 items/year, lead time, LT= 1.5 weeks, safety stock, SS=20 items, unit ordering cost, Co-$390/order, unit carrying cost, Cc=$1.50/item/month, order frequency, F=2 orders/quarter. Question 9. Which of the following represents the inventory policy for a periodic review system? (A) (65, 195 ) (B) (1.5 weeks , 195) (C) ( 45, 195) (D) (1.5 weeks , 260 ) (E) (65, 260) (F) (6.5 weeks , 195 ) (G) ( 45 , 260) (H) (6.5 weeks , 260) Question 10. Which of the following represents the inventory policy for a continuous review system? (A) (6.5 weeks, 195 ) (B) (45, 195) (C) (1.5 weeks, 195) (D) (65, 195 ) (E) (6.5 weeks , 260) (F) (65, 260) (G) ( 1.5 weeks , 260 ) (H) ( 45 , 260)