Question

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: $310.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

Answer 1

fixed cost	bus trip	2000
	administrative	1000
	miscellaneous	100
	total fixed cost	3100
variable costs	cleanup	12
	paint	25
	food	150
	total variale costs	187
	camp price	310
	contribution per unit	123
	breakeven unit	25.20325

break-even point = $\frac{fixed cost}{revenue - variable costs}$

= 26 students