If benefits are figured at $8\mathrm{.}5\%$ what is the total cost only for the two$-$month seasons. In addition What is the total cost of the program $($all seasons and benefits$)?$

Budget Problems

Harpers Ferry Parks and Recreation Department has asked us to create budgets for their skate park and for

their ice arena. In this exercise, the administrators have provided us with all the information they could. These

will be two different budgets. I know you have got this!

Complete the following budgets using Excel. All calculations should also be done in Excel.

The Skate Park

The skate park is open $4$ months $(125$ days$)$ out of the year on a daily basis $($Sunday through Saturday$)$ from

$9$:$00$ am to $8$:$00$ pm$.$

It is staffed by three attendants and a supervisor at all times.

The three attendants operate the $1)$ concessions, $2)$ entry gate, and $3)$ provide supervision of the skate park.

During peak hours $1$:$00$ pm to $8$:$00$ pm two assistant attendants are on duty $($except in the shoulder season$).$

The supervisor arrives $\frac{1}{2}$ hour before opening and stays $\frac{1}{2}$ hour after closing.

The shoulder season is the $2$ months prior and following the full$-$time season and the park is open Friday

through Sunday.

On Friday its hours are $2$:$30$ pm to $7$:$00$ pm$.$

On Saturday and Sunday its hours are $11$:$00$ am to $7$:$00$ p$.$m$.$

There are a total of $16$ weekends in the shoulder season the facility is staffed.

The rate of pay for the supervisor is $$10\mathrm{.}25$ per hour.

The attendants make $$8\mathrm{.}50$ per hour and the assistant attendants make $$6\mathrm{.}45$ per hour.