Equity in college athletics

The video presentation does not need to be done by you me and my group members will do that part.

The AD tasked you to prepare a cost analysis in Excel and a four-to-six minute long video presentation (for its advisory board made up of key parties) about the following analysis, findings, and recommendation:

Don't use plagiarized sources. Get Your Custom Essay on
Equity in college athletics
Get a plagiarism free paper Just from \$13/Page
1. Collect data – select a school and collect the athletic department data:
a. Go to the U.S. Department of Education’s Equity in Athletics Data Analysis (EADA) database.
b. Select a school that is in the ‘NCAA Division I-FBS’ Sanctioning Body (e.g., a Pac-12 school).
d. Identify the following: total direct costs by team, total indirect costs, total number of male athletes,total number of female athletes, total number of teams, and total FTEs (full time employees).
2. Compute costs and analyze the indirect cost reallocation and operational change options – compute the total cost per male athlete and the total cost per female athlete for each of the following:
a. Using ‘total number of athletes’ as an allocation basis for indirect costs
b. Using ‘total number of teams’ as an allocation basis for indirect costs
c. Using ‘total number of FTEs’ as an allocation basis for indirect costs
d. Decreasing the number of existing male athletes by eliminating the football team.
e. Increasing the number of female athletes by starting a new women’s team. Assume that the additionalnumber of female athletes is equal to the average number of existing athletes per female team; and thatthe additional cost is equal to the existing average total direct cost per female team.
(Hint for d and e only: first, categorize each indirect cost as fixed or variable, and if the latter, with respect to what operational activity; then, briefly explain the extent to which each operational change likely impacts the indirect costs incurred. Use ‘total number of athletes’ as an allocation basis for indirect costs).
Then, to analyze each option, think about how each option impacts the total cost per athlete metrics.
3. Plot the stakeholders and match to options – plot stakeholders’ power and interest, and match to options a. Plot the key stakeholders (see Appendix A) in the power-interest matrix using stakeholder analysis.
b. Match each of the options (in #2a to 2e) in the stakeholder power-interest matrix based on whichoption best meets the needs of each stakeholder. Briefly explain your reasoning for plots and matches.
4. Compute costs and analyze the activity-based costing option – compute the total cost per male athlete and the total cost per female athlete using activity-based costing. Assume that the total indirect costs are attributable to the following activities: training & practicing (15%), playing games & special events (20%), therapeutic & medical care (30%), academics & advising (20%), and maintenance & repairs (15%). a. For each these activity, identify the activity level (e.g., unit, batch, organization-sustaining, etc.)
b. For each activity, compute the amount of the total indirect costs attributable to it
c. For each activity, identify an appropriate cost driver (and briefly explain your reasoning)
d. For each activity, compute the activity rates
e. Compute the total applied overhead for male and total applied overhead for female
f. Compute the total cost per male athlete and the total cost per female athlete.
g. Match this option in the stakeholder power-interest matrix (in #3). Briefly explain your reasoning.
5. Recommendation –which one of the six options (#2a to 2e, or 4) does your team recommend? Briefly explain your reasoning based on your analyses above (#2-4) and consider each of the following concerns: a. Title IX viewpoints (Hint: consider both the metric used and the underlying principle in Title IX)
b. Stakeholder viewpoints (Hint: consider the stakeholders who benefit and those who are harmed)c. Ethical viewpoints (Hint: consider one supported versus one violated ethical viewpoint per Appendix B)
6. Peer evaluation due 24 hours after Exam 1 – very soon after the due date for these deliverables, you will be assigned another team’s video presentation to evaluate in Canvas using the grading criteria on page 3. Three different students will also evaluate your team’s video presentation using the same grading criteria. These peer evaluations will inform team case points.

Order Now And Get A 20% Discount!
Pages (550 words)
Approximate price: -

Advantages of using our writing services

Custom Writing From Scratch

All our custom papers are written by qualified writers according to your instructions, thus evading any case of plagiarism. Our team consists of native writers from the USA, Canada, and the Uk, making it convenient for us to find the best to handle your order.

Unlimited Free Revisions

If you feel your paper didn't meet all your requirements, we won't stop till it's perfect. You're entitled to request a free revision within 7 days after we submit your paper.

Quality Writing In Any Format

If you have issues with citing sources and referencing, you need not worry. Our writers are highly knowledgeable in referencing, including APA/MLA/Havard/Chicago/Turabian and all other formatting styles.

All our custom papers are delivered on time, even the most urgent. If we need more time to perfect your paper, we may contact you via email or phone regarding the deadline extension.

Originality & Security

At Master Homework, your security and privacy is our greatest concern. For this reason, we never share your personal information with third parties. We use several writing tools to ensure your paper is original and free from plagiarism.

Our agents are online 24 hours a day, 7 days a week, and are always ready to serve you. Feel free to contact us through email or talk to our live agents whenever you need assistance with your order.

Try it now!

Calculate the price of your order

We'll send you the first draft for approval by at
Total price:
\$0.00

How it works?

Fill in the order form and provide all details of your assignment.

Proceed with the payment

Choose the payment system that suits you most.

Our Services

We work nonstop to see the best client experience.

Flexible Pricing

We offer pocket-friendly prices that coincide with the preferred client's deadline.