In some ordering problems, like the one in Example $1\mathrm{.}4,$ whenever demand exceeds existing inventory, the excess demand is not lost but is filled by expedited orders$-$at a premium cost to the company. Change Sam$$s model to reflect this behavior. Assume that the unit cost of expediting is $$40,$ well above the highest regular unit cost.

Set your new demand to $3,000$ units and add inputs, add calculation lines, and modify formulas as you feel is appropriate to get it to calculate the Profit with the added $500$ units being expedited and sold. There is not just one way to do this, we could each come up with a little different way, just make sure your way looks nice and the profit calculates properly. Hint: Your new profit should be over $$14,000.$