Type Your Name Annual Salary Report Names Anderson, J. Brooks, T. Caldwell, T. Cook, A. Jackson, S. Washington, B. Ford, A. Johnson, R. Roberts, I. Marshall, C. Brown, M. Thomas, E. Williams, Y. Simms, L. Cunningham, W. Martin, D. Nichols, N. Parker, F. Green, E. Edwards, Y. Employee ID 112-21-3489 332-43-3213 394-32-3331 748-74-9605 573-90-2373 848-38-9048 940-84-8393 899-89-8989 754-48-8490 233-23-4491 223-89-4648 112-89-6788 442-43-9098 676-67-9874 432-98-5678 563-78-9803 678-23-8934 843-80-8993 450-97-5394 823-58-6484 Department Management Management Personnel Customer Service Sales Sales Technical Support Technical Support Personnel Management Sales Maintenance Public Relations Sales Customer Support Shipping Shipping Maintenance Development Development Hours Worked Hourly Wage 1950 1920 1920 1940 1880 1870 1960 1966 1920 1920 1860 1920 1800 1870 1940 1920 1920 1920 2000 2000 Gross Pay State Tax Federal Tax 25 18 12 12 10 10 15 15 12 20 11 9 10 10 10 8,5 8,5 9 18 18 Totals Averages INSTRUCTIONS: Using cell address formulas calculate: Gross Pay State Tax is 9% of Gross Pay Federal Tax is 23% of Gross Pay FICA is 4% of Gross Pay Calculate Net Pay Calculate totals for all columns in the spreadsheets Calculate Averages for all columns in the spreadsheet OTHER INSTUCTIONS Column widths should be wide enough for everything in the cells to be seen clearly Place currency sign on all columns referring to currency, and increase numbers to 2 decimals in all columns Increase Hours worked column to 2 decimals Merge cells for the heading (Your Name/ Annual Salary Report) Make sure the heading in each column is centered or justified as appropriate Use background colors different fonts etc. to highlight important details in the spreadsheet Setup the spreadsheet as though you were going to print it landscape (but do not print) Save the Spreadsheet Submit your file FICA Net Pay ORGL 3400 Excel Assignment Rubric No. 1 Criteria Headings and titles are set up nicely Excellent (20) Good (10)  Not Acceptable (0)               2 3 4 5 Column widths are appropriately formatted to make data readable All calculations are done using appropriate Excel formulas (not manual) Calculated Results/Graphs are correct Overall layout is as instructed Total Key: Excellent – No errors or recommendations Good – Very few (1-2) errors; few recommendations Fair – Multiple (3-4) corrections or recommendations Not acceptable – Five or more corrections or recommendations Subtotals
Purchase answer to see full attachment