I have to calculate this in Excel. How can I answer 1A, 1B, 1C? Do I use Goalseek? How?

Open the associated data file for this homework in Excel. In the sheet labeled "GS and DT", add the following assumptions and values to top left corner of the sheet. Format appropriately. - Base Sales =$26,525,000 - Margin Rate (\% Sales) =33.35% - G\&A Expense Rate excluding Bonus (\% Sales) =11.5% - Bonus Rate (\% Sales) =0% (to begin) - Sales Increase =0% (to begin) Profit Formula Somewhere below your assumptions, add a profit formula (listed below). = Base Sales * (1+ Sales Increase ) * Margin Rate - Base Sales * (1+ Sales Increase ) * G\&A Expense Rate - Base Sales * (1+ Sales Increase) * Bonus Rate B 2 1A) What is your company's current profit? Round to two decimal places. At what bonus % do you break even with a 10% sales increase? Round to at least 4 decimal places (e.g., 0.0000% ) What sales increase 7% is needed to break even with a 5% bonus? Round to at least 4 decimal places. Which emplovee generated the highest profit for the company? Did your company at least break even? What was the total bonus you paid out in vear 2 ? Round to two decimal places, At what bonus \% would you break even given actual sales results? Round to at least 4 decimal places. What bonus % would allow you to earn an additional $500,000 versus last year? Round to at least 4 decimal places. Copy and paste your chart below per the instructions