Assignment requirements are attached. Needing assignment completed in Excel with calculations provided.
Matrix Original Analysis AnalysisF or VDriverMetric Registration fee9,440VNo. of Teams32 teams * $295 fee per team T-Shirts4,800 Concessions17,280 Soccer clinic4,320 Contributions14,000 Total Revenue49,840 T-Shirts1,920VNo. Players32 teams * 10 players per team * $6 cost = $1,920 Concessions8,640 Soccer clinic2,592 Player insurance2,304 Registration with YSL1,500 City field rental1,200 Soccer balls432 Referees6,400 Trophies900 Hotels4,000 Face books450 Marketing and advertising2,200 CYSL salaries - Renaldo6,300 CYSL salaries - Jansten12,000 CYSL rent2,700 Total expense53,538 Contribution(3,698) Step 2 Profit Statement for 32 teams Step 3 Profit Statement for 64 teams Step 4 THE CRADDOCK CUP Business Case requirements 1) Complete the schedule provided. (The Matrix Excel file) 2) On a new tab in Excel, develop a corrected profit statement at 32 teams. Include detail of revenue and expenses similar to the proposed profit statement shown in the Case. State specific reasons for any changes you make to the proposed profit statement. You can simply make notes at the bottom of the worksheet. 3) Develop a profit statement at 64 teams. Include detail of revenue and expenses similar to the profit statement in the case. 4) Calculate the breakeven increase in registration fees per team for 64 teams given a $1,000 increase in advertising expense, 15 more college recruiters, and 20 additional face books. To get partial credit you must show your calculations. If I see that your logic is correct but you had a minor calculation error I will give you most of the credit only if you show me your calculations and how you arrived at your answers.