Discount

Answer the questions below in MS Word and execute all calculations in MS Excel. A thorough and complete analysis shall be executed. If your answers are not supported via the MS Excel calculations, no points will be awarded.

What is the quantity of units that shall be ordered per order?

What is the price per unit that will be paid per unit?

Quantity Price

$1-999$ $$92$

$1,000-2,999$ $$87$

$3,000-5,999$ $$82$

$*$Holding Cost $/$ Unit $14\%$

Demand $37,550$

Order Cost $$280$

$*$the holding cost is a percentage, $14\%,$ of the unit price.