{"text_format":"1","workbook":"xlsx","n_sheets":1,"sheets":["Payroll Data"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"Payroll Data","index":0,"n_rows":34,"n_cols":11,"rows_kept":34,"cut":false,"hidden":false,"merged":[[30,0,30,6],[31,0,31,6],[32,0,32,6],[33,0,33,6],[0,0,0,10],[1,0,1,10],[27,0,27,6],[28,0,28,6],[29,0,29,6]]}
["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.9499999999999993,48]
["Acosta",1,9.5500000000000007,48]
["Bordeaux",3,11.75,50]
["Higinbotham",1,11.75,35]
["Ianziti",1,10,40]
["Jaussi",1,9.5500000000000007,44]
["Ling",3,15.75,40]
["Munoz",2,12.25,20]
["Riley",3,13.35,38]
["Sabey",2,10,45]
["Trujillo",1,9.9499999999999993,15]
["Weston",2,11.75,41]
["Totals"]
[]
[]
["Assumptions",null,null,"Taxable Pay","Tax Rate",null,null,"Summary Statistics","# of Hours","Gross Pay","Net Pay"]
["Base Work Hours",40,null,0,0.15,null,null,"Average"]
["Overtime rate",1.5,null,250,0.22,null,null,"Highest"]
["FICA rate",7.6499999999999999E-2,null,300,0.25,null,null,"Lowest"]
["Deduct per Depend",50,null,450,0.28000000000000003]
[null,null,null,525,0.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\n    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."]