I need step by step solution in Excel. Please show fomulas as well. Thank You

a) Determine the common economic order quantity. No decimals.

b) Determine the cost associated with the EOQ. No decimals.

c) Determine the cost associated with 2nd price bracket. No decimals.

d) Determine the cost associated with 3rd price bracket. No decimals.

e) Determine the cost associated with 4th price bracket. No decimals.

13-31. The 21,000-seat Air East Arena houses the local professional ice hockey, basketball, indoor soccer, and arena football teams as well as various trade shows, wrestling and boxing matches, tractor pulls, and circuses. Arena vending annually sells large quantities of soft drinks and beer in plastic cups with the name of the arena and the various team logos on them. The local container cup manufacturer that supplies the cups in boxes of 100 has offered arena management the following discount price schedule for cups: Order Quantity (boxes) 2000-6999 7000-11,999 12,000-19,999 Price per Box $47 43 41 38 20,000+ The annual demand for cups is 2.3 million, the annual carrying cost per box of cups is $1.90, and ordering cost is $320. Determine the optimal order quantity and total annual inventory cost