Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Business Case requirements Complete the schedule provided. (The Matrix Excel file) Identify the cost as fixed or variable. State if the cost is relevant or
Business Case requirements
- Complete the schedule provided. (The Matrix Excel file)
- Identify the cost as fixed or variable.
- State if the cost is relevant or irrelevant to the decision.
- Detail the metrics and methodology used to calculate the total dollar amount of the cost or revenue.
- 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.
- Develop a profit statement at 64 teams. Include detail of revenue and expenses similar to the profit statement in the case.
- Identify 4 non-financial things that should be considered in making a decision whether to operate the tournament with 32 teams, 64 teams or some other scenario.
- State your recommendation (eliminate Craddock Cup tournament, 32 teams, 64 teams, something else) and support your recommendation with financial data from your calculation in steps 2 and 3 above and non-financial considerations from step #3. Present this as if you were presenting it to the tournament committee so ensure it is complete, clear, logical and convincing.
- 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.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started