Show with work and the correct formulas please

The EOQ and Reorder Point Assiznment is due on December 4, 2022 at 11:59 PM CST. You must show all of your work for each question except for any True or False questions, If you do not show your work, then you will receive a 0 score for the assignment, The work must consist of formulas in each cell that I can see. Hard-coded values are not acceptable and will result in a 0 score for the assignment. The assienment is worth 100 points and contains 15 questions below. Question 1 The annual demand for a smartphone is 7,000 units with an annual inventory holding cost of 20% of the unit price of $40. The cost to place an order for smartphones is $200. The lead timefor smartphones is 2 weeks. What is the economic order quantity (EOO) for this scenario? Question 2 What is the safety stock for bottled water when the awerage demand is 150 bottles and the standard deviation is 30 bottles? The service level requirement for bottled water is 95%. Question 3 A tire company had an averagetire demand of 1,800 tires per week with a weekly standard deviation of 70 tires. The lead time for tires is 3 weeks. Based on this scenario and assuming a 95% service level, what is the reorder point value? Question 4 sku One is sold at retail store for $8 per unit. 5Ku Che has a weekJ demand of 975 units with an averape lead time of 5 weeks and a standard deviation of lead time of 2 weeks. Based on the information and a 95% servicelevel, what is the reorder point for 5KU One? Question 5 A tire company had an averape tire demand of 800 tires per week with a weekly standard deviation of 35 tires. The lead time for tires is 3 weeks with a 0.5 week standard deviation. Based on this scenario and assuming a 95% servicelevel, what is the reorder point value? Question 6 What happens to the safety stock for a reorder point model when the service level increases while all other variablevalues remain the same? No shown work is required-just answer the question. Question 7 The cemand for gallons of milk is 980 gallons and the lead time is unknown. What is the safecy stock value for gallons of milk when the servicelevel is 955% ? Question 8 The annual demand for an item is 15,000 units with an annual unit holding cost of 540 . The cost to place an order is $110. Based on the properly calculated EOQ value, how many orders will be placed annually? Question 9 The annual demand for an item is 15,000 units with an annual unit holding cost of 540 . The cost to place an order is $110. Based on the properly calculated Ecovalue, what is the total annual cost