Description

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$).$

Budgeting Basics

$49$

Data Presented on a Spreadsheet:

$\backslash$table$[[,$A$,8,$C$,0,$E$,$F$,$G$,$H$],[1,$Position,Mumbs,$\backslash$table$[[$Number of$],[$Classos$]],\backslash$table$[[$Program$],[$Length fin$],[$Woules$]],\backslash$table$[[$Mootings$],[$Por week$]],\backslash$table$[[$Hours per$],[$Class$],[$Mooting$]],\backslash$table$[[$Rute of$],[$Pay$]],$Total Cost$],[2,1-$Time a Week Class Meoting$],[3,$Intructer,$1,7,,1,1,$$$18\mathrm{.}00,$$$1,003\mathrm{.}00$

Description

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$).$