EXCEL SPREADSHEET: ACCOUNTING

Maxwell Training
	Orientation	Tech Skills	Soft Skills	Product	Mandatory
Trainer cost per day	$ 360	$ 480	$ 480	$ 375	$ 400
Materials cost	$ 65	$ 35	$ 55	$ 120	$ 100
Total cost	$ 425	$ 515	$ 535	$ 495	$ 500
Maximum trainees per day	24	8	32	24	32
Enrolled trainees per day	15	6	24	16	12
Training fee per person	$ 75	$ 125	$ 100	$ 80	$ 95
Average profit per program	$ 700	$ 235	$ 1,865	$ 785	$ 640
Average profit per trainee	$ 46.67	$ 39.17	$ 77.71	$ 49.06	$ 53.33

1. Go to the New Fees worksheet. DeShawn is considering whether to change the fees for the small-group training sessions. He has created three scenarios on the New Fees worksheet showing the profit with a $10 or $15 fee increase or a $5 fee decrease. Compare the average profit per program based on the scenarios as follows:
   1. Create a Scenario Summary report using the average profit per program (range B10:F10) as the result cells to show how the average profit changes depending on the fee changes.
   2. Use New Fees Scenario Report as the name of the worksheet containing the report.