Answer Happy

I just need problem 2 answered. Also the calculation must be in excell. for full credit.
Problem 2 Given the below data set, calculate the optimal production batch size, the annual set up and holding costs for the optimal policy. . Product cost is $250 with a holding cost of 24 percent. Fixed cost for each order your organization places with the vendor is $1,000 The production rate is 5,000. Problem Set 3 - Q2 Data Set (XLXS) . . Problem 3 Weekly demand for a product at your retail store is normally distributed with a mean of Z (provided in the data set below) and a stand Inventory is continuously monitored and an order of 1,000 products is placed each time the inventory drops to 950 units. The replenis three weeks. Respond to the prompts below using the following data set: Problem Set 3-Q3 Data Set (XLXS) • How much safety inventory does your store carry? What is the CSL? • Assume that the supply lead-time from the supplier is normally distributed with a mean of 3 weeks and a standard deviation of 2 safety inventory should your store carry if it wants to provide a CSL of 97 percent? INDONES Formulas Ready A Problem Set - Question 2 Question 2 Accessibility: Good to go B Input Annual demand, D Production rate, P Cost per unit, C Holding cost, h Fixed cost per order, S Optimal Lot Size Economic production quantity, Q Number of setups per year Annual setup cost Annual holding cost C 2,533 D