must use excel & show formulas #6

6) The manager of QuikStop (open 365 days a year) sells 50 cases of water each day. Order costs are $20 per order, and water costs $0.15 per bottle (each case of water contains 24 bottles). Daily holding costs are equal to 4 percent of the cost of the water. What is the economic order quantity for water? (15 pts)