$($Hint $-$ this is an EPQ, not a pure EOQ model$)($Please use excel and take a picture of results and put them in answer section$)$

The Union Street Microbrewery makes The Union Forever beer, which it bottles and sells in its adjoining restaurant and by the case. It costs $$1,700$ to set up$,$ brew, and bottle a batch of the beer. The annual cost to store the beer in inventory is $$1\mathrm{.}25$ per bottle. The annual demand for the beer is $18,000$ bottles, and the brewery has the effective capacity to produce $30,000$ bottles annually $(365$ days$).$

a$.$ What is the optimal order size?

b$.$ What is the minimum total annual inventory cost?

c$.$ If the microbrewery has only enough storage space to hold a maximum of $2,500$ bottles of beer in cycle inventory, how will that effect total inventory costs?