Please show Excel Formulas.

Demand for smartphones at online retailer is 5,000 per month. The annual holding cost is 30% and the company incurs a fixed cost of $500 for each order placed. The supplier offers an all-unit quantity discount with a price of $200 per phone for under 10,000 units; a price of $196 for orders of 10,000 or more but under 20,000 units; and $192 for all orders of 20,000 units or more. How many phones should the company order during replenishment? Highlight the row in the Quantity \& cost table in the Excel file that provides the lowest cost Demand for smartphones at online retailer is 5,000 per month. The annual holding cost is 30% and the company incurs a fixed cost of $500 for each order placed. The supplier offers an all-unit quantity discount with a price of $200 per phone for under 10,000 units; a price of $196 for orders of 10,000 or more but under 20,000 units; and $192 for all orders of 20,000 units or more. How many phones should the company order during replenishment? Highlight the row in the Quantity \& cost table in the Excel file that provides the lowest cost