Please Answer the following in Excel

EOS The following information was provided to us by a brownie baker (BB). In an attempt to understand costs. We will use the following information to perform calculations. BB can buy pans of brownies from a factory for $8 a pan. BB estimates he will sell 4,100 pans of brownies per year. The factory charges an ordering fee of $20 every time he makes an order. Renting a refrigerated facility to hold the brownies will cost BB $1.2 per pan. BB works 364 days per year. The lead time is 2 working days. Provide answers to the following questions. Round your answers up to a whole number. Please note that youmust show your calculations and your solution must indicate the units of measurement. Compute the economic order quantity What would be his average inventory? According to the computed EOQ, how many orders will be placed per year? Compute the reorder point. Compute the number of days between orders. Compute annual setup and holding costs for this project. What is total cost for managing the inventory? 2 Parameters Amount Unit Price Anuual Demand Ordering Fee Holding Fee Lead time Working Days Parameters Amount Unit EOQ Avg Inventory Number of Orders/Year Orders/Year Reorder Point (ROP) Number of Days Between Orders Setup Cost Holding Cost Total Cost 0 0