Create a model considering an order level of $400$ orders and demand of $500$ units.

a$)$ Color code your model $(2$pts$)$

b$)$ Create range names $(2$pts$)$

c$)$ Use IF Statement to get the different units to be sold at $($regular price, leftover price$)$

$(6$pts$)$

d$)$ Use VLOOKUP to get the unit cost to be charged for the ordered units $(3$pts$)$

e$)$ Calculate revenue, cost, profit $(6$pts$)$

f$)$ How many units will have to be ordered to break even $(2$pts$)$

g$)$ How many units will have to be ordered to get a profit of $$2,500(2$pts$)$

h$)$ How does a change in order units affect profit for order units $100-600$ with increment of $50$ units. Create a one way data table and a tine chart. Write down your observations $(3$pts$)$

i$)$ How does a change in order units and demand units jointly affect the profit. Set up a two$-$way data table with profit as the output and order as the input with order quantities ranging from $100-600$ with increment of $50$ units and demand units is another input ranging from with increment of $50$ units $(2$pts$)$

j$)$ Clearly note your observations $(2$pts$)$