Below are data that need to be placed in an excel spreadsheet. The challenge is to create a proposed budget for the public library of Smithtown. Here is all the information you need: Proposed Budget:

5 percent increase in salaries except for clerical staff, who get a 6.5 percent increase

Assume fringe benefits as given (12% health insurance, 20% pension, 6% Social Security, 2% disability)

One chief librarian at a salary of $75, 893

Two librarian positions at Level II at a salary of $61, 234 each

Four librarian positions at Level I at a salary of $54, 469 each

One MIS position at a salary of $71, 089

Five clericals, three of who are budgeted for half time at a fulltime salary of $31,789, and the other two are full-time.

Complete the spreadsheet and answer the following questions: 1) What is the salary plus fringe benefits for one Level II librarian? 2) What is the total number of positions, not people? 3) How much is the library spending on health insurance for a Level I librarian in the proposed budget? 4) What is the total proposed budget for the library?