example $0\mathrm{.}245,$ please enter $0\mathrm{.}245$ and not $\mathrm{.}245.$ For final answers see the text highlighted in green

You may use excel as a calculator, but show your work by hand.

A sport store sells baseballs at a steady rate of $400$ baseballs$/$yr$.$ There are $3$ suppliers for baseballs.

Supplier A:

Irrespective of order quantity, cost is $$\frac{2}{?}$ ball.

order cost is $$60$

Supplier B:

IF the cost is $$\frac{2\mathrm{.}05}{?}$ ball.

If $Q250,$ the cost is $$\frac{1\mathrm{.}95}{?}$ ball for the entire order.

order cost is $$70$

The store estimates a holding cost based on a $20$ percent annual interest rate.

Answer the questions below. For $Q,$ round up next number and for total cost round up using $2$ significant digits.

Supplier A

Order Quantity: Q $=$ round up to the next number

Total Cost: $ round up to $2$ decimals