The Tiernan Gallery and Art Museum distributes to its visitors a printed guide to its collections. The museum has about $18,000$ visitors per year. Holding costs for the brochures are $20\%,$ and it costs $$30$ to place an order with the printer. The cost of printing each guide is $$2\mathrm{.}50.$ The printer has offered the following discount schedule:$$please show work in excel

$$

Category $|$ Order Size $|$ Unit Cost

$1|01499|0\%$

$2|15002999|1\%$

$3|3000$ and over $|2\%$

$$

$1.$ What is the order quantity if the supplier agrees to an all unit quantity discount?$$What is the total cost including cost of purchasing?

$2.$ What is the order quantity if the supplier agrees to marginal unit quantity discount? What is the total cost including cost of purchasing?