please show work in excel.

Problem 9 - Economic Order Quantity The manufacturer of a large comercial product has forecast demand for the next year to be 24,000 units (i.e. 2000 a month). The company uses a large crate to ship the product, which it purchases in bulk from a supplier. The cost of a crate is $5. The company estimates the annual holding cost for a crate to be 30% of the crate cost. The purchasing department of the company estimates the cost to place an order is $15. Based on this information answer the following 4 questions. 1) The purchasing manager currently orders crates once a month, what would be the annual holding cost for crates held in stock under this approach? 2) Under the current ordering policy (i.e. once a month) What is the annual ordering cost for these crates? 3) What would the EOQ be for the Crates? (round to nearest whole number.) 4) How much would the company save in terms of Annual Holding plus Annual Ordring costs if it switched to using the EO