please solve using this same excel template. please post formulas. thank you!

B D 160 10 99.7% 4 days 1 Daily demand mean 2 Daily demand std deviation 3 Service level 4 Lead time 5 Z 6 Safety Stock 7 Reorder point 8 9 Constant daily demand 10 Annual demand (1yr=360 days) 11 Unit purchase cost 12 Annual per unit holding cost 13 Fixed ordering costs 14 EOQ 15 Order cycle in days (1yr = 360 days) 16 100 0.025 1 Question 1 (EOQ Model, 40 points). A fast-food restaurant buys hamburger buns from a national bakery supplier. The daily usage of buns at the restaurant is normally distributed with an average of 160 and standard deviation of 10. It takes 4 days for the supplier to deliver. The purchasing agent at the restaurant has established a 99.7% service level. Construct your model on worksheet Q1 to determine: a) The Safety Stock and Reorder Point for the restaurant (in whole numbers). b) The fast-food restaurant now considers ordering hamburger buns from a local bakery. To estimate its costs, the restaurant assumes now those buns are used at the constant rate of 100 per day and are purchased at $0.025 per bun. And it costs $1 for each order placed and the annual inventory holding cost per unit is 25% of the unit purchase cost. How much should be ordered each time to minimize the restaurant's total annual costs? And what is the length of order cycles (i.e time between orders) in days? Assume the restaurant operates 360 days per year