Question #1:

First Total the salaries and benefits for every position. Use the Model given to you in the question for creating the Excel spreadsheet. The total compensation (salaries and benefits) is $360, 972. Your spreadsheet must show how you arrive at that number

The Benefits are Medicare, Social Security, Medical Coverage, Pensions, Dental Insurance. Make sure to create a total for those costs

If done correctly the sum of all benefits for all positions, Full and Part Time is $76, 372.

Read the instructions carefully because Full Time Employees and Part Time Employees differ in terms of what benefits they receive. You do have to know how to calculate percent of something.

Question # 2

Fill in the following blanks and do the arithmetic in an Excel spreadsheet . The answer is obtained by dividing the ______________ cost by the ________ ___________ costs. Answer is 21%.

Question # 3.

Seems complicated its not:

A. Cut one circulation Clerks Salary and include the benefit cut (you calculate)

B. Cut one Part Time Circulation Clerk wage/salary and include the benefit cut ($10,750)

Add the two sets of costs that were cut (A+B) = The Total Cost Reduction. (TCR)

Question #4: Is a thought question. If you want to raise revenue say specifically how and who would have to bare that cost. If you want to cut a program (think about what libraries do) what would you cut. Why?

Question #6.

This last question wants you to construct a performance/managerial budget and calculate unit costs (the cost of 1 unit). Add together the Operating Costs (e.g. acquisitions etc), they give you in the table with the Total Personnel Costs which they also give to you. I want you to calculate the Unit Cost for:

Serving 8, 200 Patron

Answering 1,100 reference questions

Circulating 65, 874 items. The answer for this last one is: $7.35.