Please answer the three question of this case on EXCEL file and explanation. Thank you. (Its from SUPPLY CHAIN ANALYTICS COURSE) PLEASE

during the holiday shopping period. costs down, given that her bonus depends on the level of production costs. performance of their products. He would like to maximize the Game Girl market share in the handheld electronic game market. Both Sandra's and Bill's teams produce a joint forecast of demand over the next six months, as shown in Table 9-7 of each of the following two months of demand would occur in September as forward buys. She believes strongly that this leveling of demand will help the company. as forward buying. Bill wants to increase revenue and sees no better way to do this than to offer a promotion during the peak season. Questions 1. Which option delivers the maximum profit for the supply chain: Sandra's plan, Bill's plan, or no promotion plan at all? Assume 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