Required: Objectives: To perform CVP analysis with multiple cost drivers To practice using the Goal Seek and Salver functions in Excel Due Date: Thursday, November 14 by 11:59PM Grading Criteria: Point allocation Criteria Correct analysis of casts given in case Correct use of formulas 8: cell references 8: general formatting Correct set up and use of Coal Seek Correct set up and use of Solver Total 1. Prepare a spreadsheet to budget income for the club. Your spreadsheet should have three sections. Section 1 should be titled Data and should contain the numbers given in the case. Joe wants to play with the number of players per team, the number of teams, and the fee charged for each player; so the spreadsheet should be set up to allow these three amounts to vary. This is Section 2 of your spreadsheet, title it Variables. Section should contain the schedule calculating forecasted income, title it budget. When constructing your budget, create a schedule that shows the detailed numbers for expenses with subtotals organized by cost driver (club-level, team-level, and player-level costs). Your format should be understandable and useful but does not