Question
The Clark Sports Camp operates three sports programs: basketball, lacrosse and field hockey. The camp provides a unique opportunity for boys and girls to engage
The Clark Sports Camp operates three sports programs: basketball, lacrosse and field hockey. The camp provides a unique opportunity for boys and girls to engage in intensive summer sports activities. Parents often bring their all of children for the six week session. Due to diminishing profits in the basketball program, they are considering eliminating the basketball program. Camp owner Mikey Matheny has asked you to review the income statement, determine the impact on profit from dropping the basketball program and make a recommendation.
Clark Sports Camp Project Income Statement | ||||
---|---|---|---|---|
Total | Basketball | Lacrosse | Field Hockey | |
Camp Tuition | $190,000 | $75,000 | $65,000 | $50,000 |
Variable Costs for Food and Staff | $26,000 | $12,000 | $8,000 | $6,000 |
Contribution Margin | $164,000 | $63,000 | $57,000 | $44,000 |
Fixed Expenses | ||||
Rent - Traceable | $25,000 | $10,000 | $7,500 | $7,500 |
Salaries of Sports Program Directors* | $21,000 | $10,000 | $10,000 | $1,000 |
Allocated Common Fixed Expenses** | $90,000 | $41,538 | $27,692 | $20,769 |
Total Fixed Expenses | $136,000 | $61,538 | $45,192 | $29,269 |
Net Operating Income (Loss) | $28,000 | $1,462 | $11,808 | $14,731 |
*There is NO alternative work for the sports directors, if the sport program is eliminated, the sport program director will be eliminated. **Common Fixed Costs are allocated based upon the number of campers but will remain constant. |
Use the information above to answer questions 1-3.
1. What is the impact on profit if the basketball program is dropped?
2. For partial credit on the problem above, you can upload a spreadsheet here. (You will not receive full credit for the problem shown above if you do not upload a spreadsheet.)
3. Assume now that we are able to eliminate $50,000 of the allocated fixed costs if we drop the basketball program. What do you recommend? Write a memo to Mr. Matheny outlining your recommendation and your reasoning. Be sure to consider all of the stakeholders and use an appropriate decision model.
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