Use Excel to answer

3. (30 points) Tonio Battery Supply is a major supplier of the most popular Motolite car battery to dealers, auto mechanics, and car owners in Iloilo. The annual demand is approximately 60,000 batteries. The supplier pays P5,000 for each battery and estimates that the annual holding cost is P300 per battery per year. It costs approximately P10,000 to place an order (managerial and clerical costs). The supplier currently orders 5,000 batteries per month. The company is operates 300 days per year. Assume the condition of certainty exists. a. Determine the ordering, holding, and total inventory costs for the current order quantity. b. Determine the economic order quantity (EOQ). C. How many orders will be placed per year using the EOQ? d. Determine the ordering, holding, and total inventory costs for the EOQ. How has ordering cost changed? Holding cost? Total inventory cost? e. How much is the reorder point if it takes 3 days for an order to arrive in Iloilo from a factory in Manila? f. The factory offers a 3%-price discount on purchase orders of 3,000 batteries or more. Shall Tonio Battery Supply avail the price discount? Why? Upon closer inspection, the supplier determines that the demand for batteries is normally distributed with mean of 210 batteries per day and standard deviation 20 batteries per day. It usually takes about 3 days to receive an order from the factory with a one-day standard deviation. g. What is the expected demand during the lead time? h. Determine the reorder point needed to achieve a service level of 95 percent. i. What is the safety stock? j. How would your analysis change if the service level changed to 98 percent