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 $500-1200$ 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. 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$)$ Calculate total revenue $(3$Pts $)$ G$.$ Calculate total profit $(3$Pts $)$ H$.$ How many orders will enable Jambo Decor to break even? $(2$Pts$)$ 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 $500-1500$ 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 $500-1500$ with an increment of $100.(3$Pts$)$ Conclusion $(1$Pt