Excel Online Activity: EOQ been collected in the Microsoft Excel Online file below. Open the spreadsheet and perform the required analysis to answer the questions below.

X

Open spreadsheet

Questions

$1.$ What is the minimum$-$cost economic order quantity? Round your answer to the nearest whole number.

cases

$2.$ What is the annual ordering cost based on the minimum$-$cost economic order quantity? Use the rounded EOQ value in your calculations. Round your answer to the nearest cent.

$\backslash (\backslash$$ $3\backslash )$

$3.$ What is the annual inventory holding cost based on the minimum$-$cost economic order quantity? Use the rounded EOQ value in your calculations. Round your answer to the nearest cent.

$\backslash$$ $5$

$4.$ What is the total annual cost based on the minimum$-$cost economic order quantity? Use the rounded EOQ value in your calculations. Round your answer to the nearest cent.

$\backslash$$ $1781\mathrm{.}5556$

$\backslash$$

$6.$ Choose the correct graph for the cost functions.

The correct graph is