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