Show work in Excel

Problem 2 On the south side of Des Moines is a place called Classic Custard that sells various flavors of frozen custard. They do a very healthy business. I estimate that they use 22 gallons of custard mix each day and they are open 7 days a week. In reality, demand varies throughout the year, but let's pretend like it doesn't. a. what is annual demand for the mix? gallons b. It is estimated that it costs her $40 to place and handle an order. This is a very perishable product, so holding cost is $6 per MONTH per gallon. Compute an economic order quantity of mix, in gallons. EOQ c. What are the inventory related costs, given the value you computed for H ? HCOCTC d. If they pay $7.25 per gallon for the mix, what is the annual cost of the mix, itself? annual mix cost