Bridgeport Company has monthly fixed costs totaling $200,000 and variable costs of $40 per unit. Each unit of product is sold for $50. Bridgeport expects to sell 30,000 units each month (this is the base case). Each of the Scenarios below is independent 9 Each time we start over from the baSe case. For each of the first three situations below (scenarios 1 through 3) assume that the number of units sold remains at 30,000. Base case: Prepare a contribution-margin income statement for the base case in Google Sheets. Use the form shown below. Copy your form clown the page and reuse it for each scenario. (NOTE: If you build a good form using formulas, this exercise becomes quite straightforward because as soon as you make the changes, your copied form will correctly\") recalculate.) "m mmmm Units Sales Variable Costs Contribution Margin Fixed Costs Operating Income Scenarios with One Change from the Base Case Scenario 1: Refer to the ham case. what would the operating profit be if the per unit sales price increases 10 percent? Scenario 2: Refer to the base case. What would the operating profit be if the per unit variable cost decreases 10 percent? Scenario 3: Refer to the ham case. what would the operating prot be if total xed costs decrease 10 percent? Scenario 4: Refer to the base case. What would the operating profit be if unit sales increase 10 percent? Scenario 4: Refer to the base caSe. What would the operating profit be if unit sales increase 10 percent? Scenarios with Multiple Changes from the Base Case Scenario 5: Refer to the base case. What would the operating profit be if the per unit sales price increaSes 10 percent but unit sales decline by 10% as a result? Managerial Accounting Page 1 Scenario 6: Refer to the base caSe. What would the operating profit be if the per unit variable cost decreaSes 20 percent but unit sales decrease by 20% due to the drop in quality? Scenario 7: Refer to the base case. What would the operating profit be if total fixed costs decrease 20 percent but unit sales decline by 10% due to a drop in quality control