Instructions

Use an excel spreadsheet to solve the following problem. Please submit your spreadsheet with your answer. Make sure to use variable costs and fixed cost appropriately.

You have been asked to perform a break-even analysis on the summer art camp. You need to determine how many students must attend in order for the camp to break-even this summer. Setup an Excel spreadsheet with the data below and use the goal seek option in Excel to determine your answer. Submit the Excel spreadsheet for this assignment. Work individually.

Camp Price: $300.00

Costs

Per Student:

Cleanup: $12.00

Paint: $25.00

Food: $150.00

Camp:

Bus Trip to Art Museum: $2,000.00

Administrative: $1,000.00

Miscellaneous: $100.00