Hi there,

Please see the screenshots below. Please note, I'm aware of how to obtain the break-even analysis, which is broken down below; however, I don't know how to illustrate that in excel while using the goal seek tool. A step by step response would be greatly appreciated. Thank you in advance.

BREAK-EVEN ANALYSIS Use an excel spreadsheet to solve the following problem. 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. Camp Price: $310.00 Costs Per Student: Cleanup: $12.00 Paint: $25.00 Food: $150.00 Camp Expenses: Bus Trip to Art Museum: $2,000.00 Administrative: $1,000.00 Miscellaneous: $100.00 Fixed Costs: Bus trip $2,000 administrative $1,000 miscellaneous $100 Total fixed cost: $3,100 Variable Costs: Cleanup $12.00 Paint $25.00 Food $150.00 Total variable costs: $187 Break-even Number of Students = Fixed Cost / (Camp Price Costs per Student) Break-even Number of Students =($2000+$1000+$100)/($310($12+$25 +150)) =3,100/310187 =3,100/123 =25.203252