Excel Assignment
Samta
LC_toubasey_Exp19_Excel_Ch02_ML1_Payrolledited13.xlsxSubmission - MarkUp
| Submission MarkUp | |||
| This is a machine generated report of your submission document containing error details as annotations. | |||
| Details of all points deducted in the submitted document are listed on this sheet. | |||
| Assignment Details | |||
| Submission ID | 4866280700 | ||
| Assignment Name | Excel Chapter 2 Mid-Level 1 - Metropolitan Zoo (PC and Mac) | ||
| Submission Date | 12 March, 2021 | ||
| Report Generated on | 18 March, 2021 | ||
| Points Obtained | 85/100 (85%) | ||
| Worksheet: Extra/Missing information (Points Deducted: 0.000) | |||
| Points Deducted | Details | Error Description | |
| 0.000 | Missing: Sheet (Overtime) | This action did not result in any loss of points. | |
| Worksheet: 'Payroll Data' (Points Deducted: 15.000) | |||
| Points Deducted | Details | Error Description | |
| 10.000 | Cell level Incorrect Actions | 11 cell(s) commented inplace. Please check the sheet. | |
| 5.000 | Incorrect Actions: Header(s)/Footer(s) | 5.000 point(s) deducted in instruction #9: -In the Sheet 'Payroll Data' the 'Center Footer Content' was not set to '&[Tab]'. -In the Sheet 'Payroll Data' the 'Right Footer Content' was not set to '&[File]'. | |
| 0.000 | Missing: Cell M1 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N1 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M2 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N2 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M3 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N3 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M4 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N4 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M5 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N5 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M6 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N6 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M7 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N7 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M8 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N8 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M9 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N9 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M10 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N10 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M11 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N11 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M12 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N12 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M13 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N13 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M14 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N14 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M15 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N15 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M16 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N16 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M17 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N17 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M18 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N18 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M19 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N19 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M20 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N20 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M21 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N21 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M22 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N22 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M23 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N23 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M24 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N24 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M25 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N25 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M26 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N26 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M27 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N27 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M28 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N28 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M29 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N29 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M30 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N30 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M31 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N31 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M32 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N32 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M33 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N33 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell M34 | This action did not result in any loss of points. | |
| 0.000 | Missing: Cell N34 | This action did not result in any loss of points. |
Payroll Data
| Metropolitan Zoo | |||||||||||||||||
| Gift Shop Department | |||||||||||||||||
| Name | No. of Dependents | Hourly Wage | Hours Worked | Regular Pay | Overtime Pay | Gross Pay | Taxable Pay | Federal Withholding Tax | FICA | Net Pay | |||||||
| Abram | 2 | $ 9.95 | 48 | $ 398.00 | $ 119.40 | $ 517.40 Project Error:: Project Error: 2 point(s) deducted in instruction #2: - In the Cell 'G5' of Sheet 'Payroll Data', the 'Formula' was not set to 'E5+F5'. | $ 417.40 | $ 104.35 | $ 39.58 | $ 373.47 | |||||||
| Acosta | 1 | $ 9.55 | 48 | 382.00 | 114.60 | 496.60 | 446.60 | 111.65 | 37.99 | 346.96 | |||||||
| Bordeaux | 3 | $ 11.75 | 50 | 470.00 | 176.25 Project Error:: Project Error: 1 point(s) deducted in instruction #5: - In the Cell 'F7' of Sheet 'Payroll Data', the 'Formula' was not set to 'IF(D7>$B$21,(D7-$B$21)*C7*$B$22,0)'. | 646.25 | 496.25 | 138.95 | 49.44 | 457.86 | |||||||
| Higinbotham | 1 | $ 11.75 | 35 | 411.25 | - 0 | 411.25 | 361.25 | 90.31 | 31.46 | 289.48 | |||||||
| Ianziti | 1 | $ 10.00 | 40 | 400.00 Project Error:: Project Error: 1 point(s) deducted in instruction #5: - In the Cell 'E9' of Sheet 'Payroll Data', the 'Formula' was not set to 'IF(D9<=$B$21,D9,$B$21)*C9'. | - 0 | 400.00 | 350.00 | 87.50 | 30.60 | 281.90 | |||||||
| Jaussi | 1 | $ 9.55 | 44 | 382.00 | 57.30 | 439.30 | 389.30 | 97.33 | 33.61 | 308.37 | |||||||
| Ling | 3 | $ 15.75 | 40 | 630.00 | - 0 | 630.00 | 480.00 | 134.40 | 48.20 | 447.41 | |||||||
| Munoz | 2 | $ 12.25 | 20 | 245.00 | - 0 | 245.00 | 145.00 | 21.75 | 18.74 | 204.51 | |||||||
| Riley | 3 | $ 13.35 | 38 | 507.30 | - 0 | 507.30 | 357.30 | 89.33 | 38.81 | 379.17 | |||||||
| Sabey | 2 | $ 10.00 | 45 | 400.00 | 75.00 | 475.00 | 375.00 | 93.75 | 36.34 | 344.91 | |||||||
| Trujillo | 1 | $ 9.95 | 15 | 149.25 | - 0 | 149.25 | 99.25 | 14.89 | 11.42 | 122.94 | |||||||
| Weston | 2 | $ 11.75 | 41 | 470.00 | 17.63 Project Error:: Project Error: 1 point(s) deducted in instruction #5: - In the Cell 'F16' of Sheet 'Payroll Data', the 'Formula' was not set to 'IF(D16>$B$21,(D16-$B$21)*C16*$B$22,0)'. | 487.63 | 387.63 | 96.91 | 37.30 | 353.42 | |||||||
| Totals | $ 4,844.80 Project Error:: Project Error: 0.714 point(s) deducted in instruction #7: - In the Cell(s) 'E17', 'F17', 'G17', 'H17', 'I17', 'J17', 'K17' of Sheet 'Payroll Data', the 'Cell Style Name' was not set to 'Total'. | $ 560.18 Project Error:: Project Error: 0.714 point(s) deducted in instruction #7: - In the Cell(s) 'E17', 'F17', 'G17', 'H17', 'I17', 'J17', 'K17' of Sheet 'Payroll Data', the 'Cell Style Name' was not set to 'Total'. | $ 5,404.98 Project Error:: Project Error: 0.714 point(s) deducted in instruction #7: - In the Cell(s) 'E17', 'F17', 'G17', 'H17', 'I17', 'J17', 'K17' of Sheet 'Payroll Data', the 'Cell Style Name' was not set to 'Total'. | $ 4,304.98 Project Error:: Project Error: 0.714 point(s) deducted in instruction #7: - In the Cell(s) 'E17', 'F17', 'G17', 'H17', 'I17', 'J17', 'K17' of Sheet 'Payroll Data', the 'Cell Style Name' was not set to 'Total'. | $ 1,081.11 Project Error:: Project Error: 0.715 point(s) deducted in instruction #7: - In the Cell(s) 'E17', 'F17', 'G17', 'H17', 'I17', 'J17', 'K17' of Sheet 'Payroll Data', the 'Cell Style Name' was not set to 'Total'. | $ 413.48 Project Error:: Project Error: 0.714 point(s) deducted in instruction #7: - In the Cell(s) 'E17', 'F17', 'G17', 'H17', 'I17', 'J17', 'K17' of Sheet 'Payroll Data', the 'Cell Style Name' was not set to 'Total'. |
Project Error:: Project Error: 2 point(s) deducted in instruction #2: - In the Cell 'G5' of Sheet 'Payroll Data', the 'Formula' was not set to 'E5+F5'. | $ 3,910.39 Project Error:: Project Error: 0.715 point(s) deducted in instruction #7: - In the Cell(s) 'E17', 'F17', 'G17', 'H17', 'I17', 'J17', 'K17' of Sheet 'Payroll Data', the 'Cell Style Name' was not set to 'Total'. |
|||||||||
|
Project Error:: Project Error: 1 point(s) deducted in instruction #5: - In the Cell 'F7' of Sheet 'Payroll Data', the 'Formula' was not set to 'IF(D7>$B$21,(D7-$B$21)*C7*$B$22,0)'. |
Project Error:: Project Error: 1 point(s) deducted in instruction #5: - In the Cell 'E9' of Sheet 'Payroll Data', the 'Formula' was not set to 'IF(D9<=$B$21,D9,$B$21)*C9'. | Assumptions | Taxable Pay | Tax Rate | Summary Statistics | # of Hours | Gross Pay | Net Pay | |||||||||
| Base Work Hours | 40 | $0 | 15% | Average | 38.7 | $ 450.41 | $ 325.87 | ||||||||||
| Overtime rate | 1.5 | $250 | 22% | Highest | 50.0 | $ 646.25 | $ 457.86 | ||||||||||
| FICA rate | 7.65% | $300 | 25% | Lowest | 15.0 | $ 149.25 | $ 122.94 | ||||||||||
| Deduct per Depend | $ 50.00 | $450 | 28% | ||||||||||||||
| $525 | 31% | ||||||||||||||||
| Notes | |||||||||||||||||
| 1. The base workweek is 40 hours. Regular pay is based on hourly wage and hours worked up to 40. | |||||||||||||||||
| 2. Overtime pay is based on overtime hours, the hourly wage, and the overtime rate. | |||||||||||||||||
| 3. The gross pay is the total of the regular pay and overtime pay. | |||||||||||||||||
| 4. The taxable pay is the difference between the gross pay and the product of the number of dependents and deduction per dependent. | |||||||||||||||||
| 5. Federal withholding tax is calculated on the taxable pay based on the tax table. | |||||||||||||||||
| 6. FICA is calculated on the employee's gross pay. | |||||||||||||||||
| 7. The net pay is based on the gross pay, federal withholding tax, and FICA. |
toubasey Exp_Excel_Ch02_ML1_Payroll 2019 Project
