Jambo D$$cor manager is strategizing on ordering different d$$cor pieces for the Summer season. It has been in business with a vendor who supplies the pieces on a discounted rate depending on the units ordered. The regular selling price for each piece will be $$120$ and a fixed cost of $$3,700.$ At the end of the season, all the unsold pieces will be placed on clearance at a clearance selling piece of $$50.$ In addition, there is a polishing cost of $$10$ for each piece. There has been uncertain demand in the market for d$$cor pieces ranging between $5001200$ units. Consider the quantity discount table below and help the manager build a spreadsheet model to experiment with the uncertain demand of $700$ and the order quantity of $1050$ units.

Quantity Discount Table$($Unit order cost$)$

$0$

$40$

$300$

$38$

$600$

$37$

$900$

$36\mathrm{.}5$

$1200$

$35$

$1500$

$33$