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$

A$.$ Color code your work $(2$Pt$)$

B$.$ Create and paste range names used $(2$Pts$)$

C$.$ Calculate units to be sold at regular selling price using IF function $(4$Pts$)$

D$.$ Calculate units to be sold at clearance selling price using IF function $(4$Pts$)$

E$.$ Calculate total cost $(3$Pts$)$

F$.$ Calculate total revenue $(3$Pts$)$

G$.$ Calculate total profit $(3$Pts$)$

H$.$ How many orders will enable Jambo Decor to break even? $(2$Pts$)$

I. How many orders should Jambo Decor make, to earn at least a profit of $$30,500?(2$Pts$)$

J$.$ Show how a change in order units affects profit. Have the order units range from $5001500$ with increment of $100.$

$-$ Setup a one$-$way data table $(2$Pts$)$

$-$ Conclusion $(1$Pts$)$

$-$ Create a line chart $($Edit your chart accordingly$)$ Title, axis labels, horizontal axis scale $(2$Pts$)$

$-$ Conclusion $(1$Pts$)$

K$.$ Show how a change in order units and demand jointly affect profit.

$-$ Set up a two$-$way data table with order units along side and demand units along top ranging from $5001500$ with an increment of $100.(3$Pts$)$

$-$ Conclusion $(1$Pts$)$