Using the attached template, use What-If Analysis to determine the following: 1. An additional $750,000 was found that can be spent on salary. Use Goal Seek to find the raise (a percentage) that can be given. Copy the result of Goal Seek to another cell and label it Copy and paste the value to another cell, rather than making a reference. Failing to do so may cause the result of Goal Seek to be inadvertently wiped out when using the Scenario Manager in the next question on this assignment. 2. The company is considering not only a raise, but also a holiday bonus of a flat amount to all employees. Create the following rules in the scenario manager to calculate the total cost for the year to compensate employees: Scenario Raise Bonus Original scenario 09 SO Raise 59 $0 Bonus 09 $1000 Combination higher ons 20 $750 Combination, higher raise 3 $250 Note: To make the calculation easier, you may want to simply multiply the number of employees by the bonus and add it to the total compensation 3. Create a scenario summary that shows the manipulated fields and the total compensation for the year. Using the attached template, use What-If Analysis to determine the following: 1. An additional $750,000 was found that can be spent on salary. Use Goal Seek to find the raise (a percentage) that can be given. Copy the result of Goal Seek to another cell and label it Copy and paste the value to another cell, rather than making a reference. Failing to do so may cause the result of Goal Seek to be inadvertently wiped out when using the Scenario Manager in the next question on this assignment. 2. The company is considering not only a raise, but also a holiday bonus of a flat amount to all employees. Create the following rules in the scenario manager to calculate the total cost for the year to compensate employees: Scenario Raise Bonus Original scenario 09 SO Raise 59 $0 Bonus 09 $1000 Combination higher ons 20 $750 Combination, higher raise 3 $250 Note: To make the calculation easier, you may want to simply multiply the number of employees by the bonus and add it to the total compensation 3. Create a scenario summary that shows the manipulated fields and the total compensation for the year