Mintendo Case: Using that excel template there needs to be $9$ excel tabs answering these questions.

$1.$ Which option delivers the maximum profit for the supply chain: Sandras plan, Bill's plan, or no promotion plan at all? Assume the starting and ending inventory of $0.$

$2.$ How does the answer change if a discount of $$10$ must be given to reach the same level of impact that the $$5$ discount received?

$3.$ Suppose Sandra's fears about increasing outsourcing costs come to fruition and the cost rises to $$22/$unit for subcontracting. Does this change the decision when the discount is $$5?$