Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please use excel teach me how to solve this problem. 7. The 2014/2015 salary schedule for GISD teachers follows BA BA+18 MA MA+15 536,326 $38,239

Please use excel teach me how to solve this problem. image text in transcribed
7. The 2014/2015 salary schedule for GISD teachers follows BA BA+18 MA MA+15 536,326 $38,239 $40,339 $42,558 $38,239 $40,239 $42,558 $44,897 Step 3 $40,239 $42.357 $44 897 $47,369 4 $42,357 $44,582 $47.369 $49,972 5 $44,582 $46,919 $49,972 $52,721 6|$46.919-1 $49.383.. $52,721 | $55,622| 7 $49,383 $51,972 $55,622 $58,681 8 551.972 $54,703 $58,681 $61,907 9$54,703 $57,578 $61,907 $65,313 1 $57,578 S60,597 $65,313 $68,908 Placement on the salary scale is based on education level (BA, BA+18, MA, and MA+15) and years of service with the district (each step represents year of service). The annual salary is based on a 185 day work year and assumes an 8 hour work day Longevity pay is set as follows: Years of Experience 12 to 19 Years 20 to 24 Years 25 to 29 Years 30 Years or More Amount $800 $1,300 $1,700 Total compensation for teachers includes the employer's portion of FICA at 7.65% of salaries, mandatory district retirement contribution of 34.54% of salaries, and worker compensation of 1.5% of salaries. Using Microsoft Excel, prepare a spreadsheet showing detailed compensation costs for each of the GISD teachers listed in the following table. For each employee, show each component of total compensation, along with totals for each employee and totals for each component of total compensation. Also include in your schedule the daily rate and hourly rate for each employee. The spreadsheet shall contain the following columns Daily Rate, Hourly Rate, Annual Salary, Longevity Pay, FICA, Retirement, Worker Compensation, and Total Compensation. Years of Service 13 26 Education Level Teacher Name Bella Thomas Edward Cullen Jacob Smith Harry Potter Ronald Weasley Yogi Bear BA+18 MA+15 BA+18 32 When you have completed the spreadsheet, print it to the default printer. Also, save your file to the computer's Desktop, using your last name and "Payroll as the filename (example: "Smith Payroll")

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Cost-Benefit Analysis

Authors: E.J. Mishan, Euston Quah

6th Edition

1138492752, 978-1138492752

More Books

Students also viewed these Accounting questions