Unlimited Attempts Allowed

Details

Using the following information please create a spreadsheet similar to Figure $3\mathrm{.}4$ on page $49$ of the text that outlines the cost of the program:

There are $15$ classes: $10$ of the classes meet $1$ time each week for $10$ weeks; $5$ classes meet $3$ times per week for $5$ weeks; all class periods are one hour in duration.

The rate of pay for the swim instructor is $$22\mathrm{.}00$ per hour, plus $$150\mathrm{.}00$ per class for the pool rental

The agency has determined that indirect costs $($or costs the agency has that the program needs to help pay for$)$ should be charged at a rate of $10\mathrm{.}5\%$ of direct costs and added to the total cost of the program.

There are $12$ participants per class.

The program fee is designed to recover costs $($it should neither lose nor make money$).$