{"text_format":"3","workbook":"xls","n_sheets":2,"sheets":["Headcount and Payroll Planning","Salary and Benefits Chart"],"not_rendered":{"charts":1,"external_links":1,"defined_names":1},"unopened":[{"sheet":"Salary and Benefits Chart","index":1,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"Headcount and Payroll Planning","index":0,"n_rows":124,"n_cols":14,"rows_kept":124,"merged":[[100,3,100,4],[100,8,100,9],[100,11,100,12],[100,13,100,14],[101,3,101,4],[101,8,101,9],[101,11,101,12],[101,13,101,14],[102,3,102,4],[102,8,102,9],[102,11,102,12],[102,13,102,14],[103,3,103,4],[103,8,103,9],[103,11,103,12],[103,13,103,14],[104,3,104,4],[104,8,104,9],[104,11,104,12],[104,13,104,14],[105,3,105,4],[105,8,105,9],[105,11,105,12],[105,13,105,14],[106,3,106,4],[106,8,106,9],[106,11,106,12],[106,13,106,14],[107,3,107,4],[107,8,107,9],[107,11,107,12],[107,13,107,14],[108,3,108,4],[108,8,108,9],[108,11,108,12],[108,13,108,14],[109,3,109,4],[109,8,109,9],[109,11,109,12],[109,13,109,14],[110,3,110,4],[110,8,110,9],[110,11,110,12],[110,13,110,14],[111,8,111,9],[111,13,111,14],[113,3,113,4],[114,3,114,4],[115,3,115,4],[115,9,115,10],[116,3,116,4],[117,3,117,4],[118,3,118,4],[119,3,119,4],[120,3,120,4],[121,3,121,4],[122,3,122,4],[123,3,123,4]],"flags":["formulas_cached_only"]}
[null,"[Company Name]"]
[null,"Headcount and Payroll Planning"]
[null,"[Year]"]
[]
[null,"HEADCOUNT SUMMARY",null,"Q1","Q2","Q3","Q4","Annual total","Annual salary","Q1 cost","Q2 cost","Q3 cost","Q4 cost","Annual cost"]
[null,"Executive"]
[null,"Chief executive officer",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":300000,"d":"$300,000"},{"v":75000,"d":"$75,000"},{"v":75000,"d":"$75,000"},{"v":75000,"d":"$75,000"},{"v":75000,"d":"$75,000"},{"v":300000,"d":"$300,000"}]
[null,"Chief financial officer",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":250000,"d":"250,000 "},{"v":62500,"d":"62,500 "},{"v":62500,"d":"62,500 "},{"v":62500,"d":"62,500 "},{"v":62500,"d":"62,500 "},{"v":250000,"d":"250,000 "}]
[null,"Chief operating officer",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":225000,"d":"225,000 "},{"v":56250,"d":"56,250 "},{"v":56250,"d":"56,250 "},{"v":56250,"d":"56,250 "},{"v":56250,"d":"56,250 "},{"v":225000,"d":"225,000 "}]
[null,"Chief information officer",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":225000,"d":"225,000 "},{"v":56250,"d":"56,250 "},{"v":56250,"d":"56,250 "},{"v":56250,"d":"56,250 "},{"v":56250,"d":"56,250 "},{"v":225000,"d":"225,000 "}]
[null,"President",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":240000,"d":"240,000 "},{"v":60000,"d":"60,000 "},{"v":60000,"d":"60,000 "},{"v":60000,"d":"60,000 "},{"v":60000,"d":"60,000 "},{"v":240000,"d":"240,000 "}]
[{"$nulls":7},{"v":0,"d":"0.00"},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total",null,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"},{"v":5,"d":"5.00"},{"v":5,"d":"5.00"},{"v":20,"d":"20.00"},null,{"v":310000,"d":"$310,000"},{"v":310000,"d":"$310,000"},{"v":310000,"d":"$310,000"},{"v":310000,"d":"$310,000"},{"v":1240000,"d":"$1,240,000"}]
[]
[null,"Finance"]
[null,"Vice president",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":200000,"d":"$200,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":50000,"d":"$50,000"},{"v":200000,"d":"$200,000"}]
[null,"Financial planning director",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":125000,"d":"125,000 "},{"v":31250,"d":"31,250 "},{"v":31250,"d":"31,250 "},{"v":31250,"d":"31,250 "},{"v":31250,"d":"31,250 "},{"v":125000,"d":"125,000 "}]
[null,"Financial analyst",null,{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":8,"d":"8.00"},{"v":100000,"d":"100,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":200000,"d":"200,000 "}]
[null,"Credit analyst",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":70000,"d":"70,000 "},{"v":17500,"d":"17,500 "},{"v":17500,"d":"17,500 "},{"v":17500,"d":"17,500 "},{"v":17500,"d":"17,500 "},{"v":70000,"d":"70,000 "}]
[null,"Advisor",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":85000,"d":"85,000 "},{"v":21250,"d":"21,250 "},{"v":21250,"d":"21,250 "},{"v":21250,"d":"21,250 "},{"v":21250,"d":"21,250 "},{"v":85000,"d":"85,000 "}]
[{"$nulls":7},{"v":0,"d":"0.00"},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total",null,{"v":6,"d":"6.00"},{"v":6,"d":"6.00"},{"v":6,"d":"6.00"},{"v":6,"d":"6.00"},{"v":24,"d":"24.00"},null,{"v":170000,"d":"$170,000"},{"v":170000,"d":"$170,000"},{"v":170000,"d":"$170,000"},{"v":170000,"d":"$170,000"},{"v":680000,"d":"$680,000"}]
[]
[null,"Human Resources"]
[null,"Vice president",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":140000,"d":"$140,000"},{"v":35000,"d":"$35,000"},{"v":35000,"d":"$35,000"},{"v":35000,"d":"$35,000"},{"v":35000,"d":"$35,000"},{"v":140000,"d":"$140,000"}]
[null,"Director",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":100000,"d":"100,000 "},{"v":25000,"d":"25,000 "},{"v":25000,"d":"25,000 "},{"v":25000,"d":"25,000 "},{"v":25000,"d":"25,000 "},{"v":100000,"d":"100,000 "}]
[null,"Senior human resource representative",null,{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":8,"d":"8.00"},{"v":80000,"d":"80,000 "},{"v":40000,"d":"40,000 "},{"v":40000,"d":"40,000 "},{"v":40000,"d":"40,000 "},{"v":40000,"d":"40,000 "},{"v":160000,"d":"160,000 "}]
[null,"Benefits coordinator",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":75000,"d":"75,000 "},{"v":18750,"d":"18,750 "},{"v":18750,"d":"18,750 "},{"v":18750,"d":"18,750 "},{"v":18750,"d":"18,750 "},{"v":75000,"d":"75,000 "}]
[null,"Compensation manager",null,{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":8,"d":"8.00"},{"v":75000,"d":"75,000 "},{"v":37500,"d":"37,500 "},{"v":37500,"d":"37,500 "},{"v":37500,"d":"37,500 "},{"v":37500,"d":"37,500 "},{"v":150000,"d":"150,000 "}]
[null,"Human resource generalist",null,{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":8,"d":"8.00"},{"v":65000,"d":"65,000 "},{"v":32500,"d":"32,500 "},{"v":37500,"d":"37,500 "},{"v":37500,"d":"37,500 "},{"v":37500,"d":"37,500 "},{"v":145000,"d":"145,000 "}]
[null,"Payroll",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":65000,"d":"65,000 "},{"v":16250,"d":"16,250 "},{"v":16250,"d":"16,250 "},{"v":16250,"d":"16,250 "},{"v":16250,"d":"16,250 "},{"v":65000,"d":"65,000 "}]
[null,"Trainer",{"$nulls":5},{"v":0,"d":"0.00"},{"v":65000,"d":"65,000 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Recruiter",{"$nulls":5},{"v":0,"d":"0.00"},{"v":65000,"d":"65,000 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[{"$nulls":7},{"v":0,"d":"0.00"},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total",null,{"v":10,"d":"10.00"},{"v":10,"d":"10.00"},{"v":10,"d":"10.00"},{"v":10,"d":"10.00"},{"v":40,"d":"40.00"},null,{"v":205000,"d":"$205,000"},{"v":210000,"d":"$210,000"},{"v":210000,"d":"$210,000"},{"v":210000,"d":"$210,000"},{"v":835000,"d":"$835,000"}]
[]
[null,"Information Technology"]
[null,"Vice president",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":140000,"d":"$140,000"},{"v":35000,"d":"$35,000"},{"v":35000,"d":"$35,000"},{"v":35000,"d":"$35,000"},{"v":35000,"d":"$35,000"},{"v":140000,"d":"$140,000"}]
[null,"Director",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":110000,"d":"110,000 "},{"v":27500,"d":"27,500 "},{"v":27500,"d":"27,500 "},{"v":27500,"d":"27,500 "},{"v":27500,"d":"27,500 "},{"v":110000,"d":"110,000 "}]
[null,"Systems engineer",null,{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":8,"d":"8.00"},{"v":90000,"d":"90,000 "},{"v":45000,"d":"45,000 "},{"v":45000,"d":"45,000 "},{"v":45000,"d":"45,000 "},{"v":45000,"d":"45,000 "},{"v":180000,"d":"180,000 "}]
[null,"Systems analyst",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":90000,"d":"90,000 "},{"v":22500,"d":"22,500 "},{"v":22500,"d":"22,500 "},{"v":22500,"d":"22,500 "},{"v":22500,"d":"22,500 "},{"v":90000,"d":"90,000 "}]
[null,"Technician",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":6,"d":"6.00"},{"v":80000,"d":"80,000 "},{"v":20000,"d":"20,000 "},{"v":20000,"d":"20,000 "},{"v":40000,"d":"40,000 "},{"v":40000,"d":"40,000 "},{"v":120000,"d":"120,000 "}]
[null,"Support",null,{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":8,"d":"8.00"},{"v":75000,"d":"75,000 "},{"v":37500,"d":"37,500 "},{"v":37500,"d":"37,500 "},{"v":37500,"d":"37,500 "},{"v":37500,"d":"37,500 "},{"v":150000,"d":"150,000 "}]
[null,"Architect",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":80000,"d":"80,000 "},{"v":20000,"d":"20,000 "},{"v":20000,"d":"20,000 "},{"v":20000,"d":"20,000 "},{"v":20000,"d":"20,000 "},{"v":80000,"d":"80,000 "}]
[null,"Programmer",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":80000,"d":"80,000 "},{"v":20000,"d":"20,000 "},{"v":20000,"d":"20,000 "},{"v":20000,"d":"20,000 "},{"v":20000,"d":"20,000 "},{"v":80000,"d":"80,000 "}]
[{"$nulls":7},{"v":0,"d":"0.00"},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total",null,{"v":10,"d":"10.00"},{"v":10,"d":"10.00"},{"v":11,"d":"11.00"},{"v":11,"d":"11.00"},{"v":42,"d":"42.00"},null,{"v":227500,"d":"$227,500"},{"v":227500,"d":"$227,500"},{"v":247500,"d":"$247,500"},{"v":247500,"d":"$247,500"},{"v":950000,"d":"$950,000"}]
[]
[null,"Accounting"]
[null,"Vice president",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":130000,"d":"$130,000"},{"v":32500,"d":"$32,500"},{"v":32500,"d":"$32,500"},{"v":32500,"d":"$32,500"},{"v":32500,"d":"$32,500"},{"v":130000,"d":"$130,000"}]
[null,"Controller",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":95000,"d":"95,000 "},{"v":23750,"d":"23,750 "},{"v":23750,"d":"23,750 "},{"v":23750,"d":"23,750 "},{"v":23750,"d":"23,750 "},{"v":95000,"d":"95,000 "}]
[null,"Accounting manager",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":75000,"d":"75,000 "},{"v":18750,"d":"18,750 "},{"v":18750,"d":"18,750 "},{"v":18750,"d":"18,750 "},{"v":18750,"d":"18,750 "},{"v":75000,"d":"75,000 "}]
[null,"Accounts receivable",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":55000,"d":"55,000 "},{"v":13750,"d":"13,750 "},{"v":13750,"d":"13,750 "},{"v":13750,"d":"13,750 "},{"v":13750,"d":"13,750 "},{"v":55000,"d":"55,000 "}]
[null,"Accounts payable",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":55000,"d":"55,000 "},{"v":13750,"d":"13,750 "},{"v":13750,"d":"13,750 "},{"v":13750,"d":"13,750 "},{"v":13750,"d":"13,750 "},{"v":55000,"d":"55,000 "}]
[null,"Treasury",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":75000,"d":"75,000 "},{"v":18750,"d":"18,750 "},{"v":18750,"d":"18,750 "},{"v":18750,"d":"18,750 "},{"v":18750,"d":"18,750 "},{"v":75000,"d":"75,000 "}]
[null,"General accountant",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":55000,"d":"55,000 "},{"v":13750,"d":"13,750 "},{"v":13750,"d":"13,750 "},{"v":13750,"d":"13,750 "},{"v":13750,"d":"13,750 "},{"v":55000,"d":"55,000 "}]
[{"$nulls":7},{"v":0,"d":"0.00"},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total",null,{"v":7,"d":"7.00"},{"v":7,"d":"7.00"},{"v":7,"d":"7.00"},{"v":7,"d":"7.00"},{"v":28,"d":"28.00"},null,{"v":135000,"d":"$135,000"},{"v":135000,"d":"$135,000"},{"v":135000,"d":"$135,000"},{"v":135000,"d":"$135,000"},{"v":540000,"d":"$540,000"}]
[]
[null,"Sales"]
[null,"Vice president",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":120000,"d":"$120,000"},{"v":30000,"d":"$30,000"},{"v":30000,"d":"$30,000"},{"v":30000,"d":"$30,000"},{"v":30000,"d":"$30,000"},{"v":120000,"d":"$120,000"}]
[null,"Regional director",null,{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":2,"d":"2.00"},{"v":8,"d":"8.00"},{"v":100000,"d":"100,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":50000,"d":"50,000 "},{"v":200000,"d":"200,000 "}]
[null,"Business development",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":90000,"d":"90,000 "},{"v":22500,"d":"22,500 "},{"v":22500,"d":"22,500 "},{"v":22500,"d":"22,500 "},{"v":22500,"d":"22,500 "},{"v":90000,"d":"90,000 "}]
[null,"Direct sales representative",null,{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":4,"d":"4.00"},{"v":16,"d":"16.00"},{"v":90000,"d":"90,000 "},{"v":90000,"d":"90,000 "},{"v":90000,"d":"90,000 "},{"v":90000,"d":"90,000 "},{"v":90000,"d":"90,000 "},{"v":360000,"d":"360,000 "}]
[null,"Inside sales",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":75000,"d":"75,000 "},{"v":18750,"d":"18,750 "},{"v":18750,"d":"18,750 "},{"v":18750,"d":"18,750 "},{"v":18750,"d":"18,750 "},{"v":75000,"d":"75,000 "}]
[null,"Sales operations",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":75000,"d":"75,000 "},{"v":18750,"d":"18,750 "},{"v":18750,"d":"18,750 "},{"v":18750,"d":"18,750 "},{"v":18750,"d":"18,750 "},{"v":75000,"d":"75,000 "}]
[null,"Channel sales representative",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":80000,"d":"80,000 "},{"v":20000,"d":"20,000 "},{"v":20000,"d":"20,000 "},{"v":20000,"d":"20,000 "},{"v":20000,"d":"20,000 "},{"v":80000,"d":"80,000 "}]
[{"$nulls":7},{"v":0,"d":"0.00"},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total",null,{"v":11,"d":"11.00"},{"v":11,"d":"11.00"},{"v":11,"d":"11.00"},{"v":11,"d":"11.00"},{"v":44,"d":"44.00"},null,{"v":250000,"d":"$250,000"},{"v":250000,"d":"$250,000"},{"v":250000,"d":"$250,000"},{"v":250000,"d":"$250,000"},{"v":1000000,"d":"$1,000,000"}]
[]
[null,"Operations"]
[null,"Vice president",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":150000,"d":"$150,000"},{"v":37500,"d":"$37,500"},{"v":37500,"d":"$37,500"},{"v":37500,"d":"$37,500"},{"v":37500,"d":"$37,500"},{"v":150000,"d":"$150,000"}]
[null,"Director",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":100000,"d":"100,000 "},{"v":25000,"d":"25,000 "},{"v":25000,"d":"25,000 "},{"v":25000,"d":"25,000 "},{"v":25000,"d":"25,000 "},{"v":100000,"d":"100,000 "}]
[null,"Manager",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":85000,"d":"85,000 "},{"v":21250,"d":"21,250 "},{"v":21250,"d":"21,250 "},{"v":21250,"d":"21,250 "},{"v":21250,"d":"21,250 "},{"v":85000,"d":"85,000 "}]
[null,"Floor manager",null,{"v":5,"d":"5.00"},{"v":5,"d":"5.00"},{"v":5,"d":"5.00"},{"v":5,"d":"5.00"},{"v":20,"d":"20.00"},{"v":65000,"d":"65,000 "},{"v":81250,"d":"81,250 "},{"v":81250,"d":"81,250 "},{"v":81250,"d":"81,250 "},{"v":81250,"d":"81,250 "},{"v":325000,"d":"325,000 "}]
[null,"Assistant",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":45000,"d":"45,000 "},{"v":11250,"d":"11,250 "},{"v":11250,"d":"11,250 "},{"v":11250,"d":"11,250 "},{"v":11250,"d":"11,250 "},{"v":45000,"d":"45,000 "}]
[{"$nulls":7},{"v":0,"d":"0.00"},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total",null,{"v":9,"d":"9.00"},{"v":9,"d":"9.00"},{"v":9,"d":"9.00"},{"v":9,"d":"9.00"},{"v":36,"d":"36.00"},null,{"v":176250,"d":"$176,250"},{"v":176250,"d":"$176,250"},{"v":176250,"d":"$176,250"},{"v":176250,"d":"$176,250"},{"v":705000,"d":"$705,000"}]
[]
[null,"Marketing"]
[null,"Vice president",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":135000,"d":"$135,000"},{"v":33750,"d":"$33,750"},{"v":33750,"d":"$33,750"},{"v":33750,"d":"$33,750"},{"v":33750,"d":"$33,750"},{"v":135000,"d":"$135,000"}]
[null,"Director",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":105000,"d":"105,000 "},{"v":26250,"d":"26,250 "},{"v":26250,"d":"26,250 "},{"v":26250,"d":"26,250 "},{"v":26250,"d":"26,250 "},{"v":105000,"d":"105,000 "}]
[null,"Product manager",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":90000,"d":"90,000 "},{"v":22500,"d":"22,500 "},{"v":22500,"d":"22,500 "},{"v":22500,"d":"22,500 "},{"v":22500,"d":"22,500 "},{"v":90000,"d":"90,000 "}]
[null,"Market research",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":75000,"d":"75,000 "},{"v":18750,"d":"18,750 "},{"v":18750,"d":"18,750 "},{"v":18750,"d":"18,750 "},{"v":18750,"d":"18,750 "},{"v":75000,"d":"75,000 "}]
[null,"Market analyst",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":75000,"d":"75,000 "},{"v":18750,"d":"18,750 "},{"v":18750,"d":"18,750 "},{"v":18750,"d":"18,750 "},{"v":18750,"d":"18,750 "},{"v":75000,"d":"75,000 "}]
[null,"Product manager",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":90000,"d":"90,000 "},{"v":22500,"d":"22,500 "},{"v":22500,"d":"22,500 "},{"v":22500,"d":"22,500 "},{"v":22500,"d":"22,500 "},{"v":90000,"d":"90,000 "}]
[null,"Merchandiser",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":70000,"d":"70,000 "},{"v":17500,"d":"17,500 "},{"v":17500,"d":"17,500 "},{"v":17500,"d":"17,500 "},{"v":17500,"d":"17,500 "},{"v":70000,"d":"70,000 "}]
[null,"Assistant",null,{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":1,"d":"1.00"},{"v":4,"d":"4.00"},{"v":50000,"d":"50,000 "},{"v":12500,"d":"12,500 "},{"v":12500,"d":"12,500 "},{"v":12500,"d":"12,500 "},{"v":12500,"d":"12,500 "},{"v":50000,"d":"50,000 "}]
[{"$nulls":7},{"v":0,"d":"0.00"},null,{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "},{"v":0,"d":"0 "}]
[null,"Total",null,{"v":8,"d":"8.00"},{"v":8,"d":"8.00"},{"v":8,"d":"8.00"},{"v":8,"d":"8.00"},{"v":20,"d":"20.00"},null,{"v":172500,"d":"$172,500"},{"v":172500,"d":"$172,500"},{"v":172500,"d":"$172,500"},{"v":172500,"d":"$172,500"},{"v":690000,"d":"$690,000"}]
[]
[null,"Corporate totals",null,{"v":66,"d":"66.00"},{"v":66,"d":"66.00"},{"v":67,"d":"67.00"},{"v":67,"d":"67.00"},{"v":254,"d":"254.00"},null,{"v":1646250,"d":"$1,646,250"},{"v":1651250,"d":"$1,651,250"},{"v":1671250,"d":"$1,671,250"},{"v":1671250,"d":"$1,671,250"},{"v":6640000,"d":"$6,640,000"}]
[]
[]
[null,"KEY MODEL INPUTS"]
[null,"Fringe benefit percentage",null,{"v":0.25,"d":"25.0%"}]
[null,"Fiscal revenue",null,{"v":5256000,"d":"$5,256,000"}]
[]
[]
[null,"SUMMARY DATA BY DEPARTMENT"]
[null,"Department",null,"Total number \nof employees",null,"Total salary","Benefits","Salary +\nbenefits","Variable \ncompensation %",null,"Variable \npay","Stock-based \ncompensation",null,"Total compensation"]
[null,"Executive",null,{"v":20,"d":"20 "},null,{"v":1240000,"d":"$1,240,000"},{"v":310000,"d":"$310,000"},{"v":1550000,"d":"$1,550,000"},{"v":0.15,"d":"15.0%"},null,{"v":186000,"d":"$186,000"},{"v":200000,"d":"$200,000"},null,{"v":1936000,"d":"$1,936,000"}]
[null,"Finance",null,{"v":24,"d":"24 "},null,{"v":680000,"d":"680,000 "},{"v":170000,"d":"170,000 "},{"v":850000,"d":"850,000 "},{"v":0.1,"d":"10.0%"},null,{"v":68000,"d":"68,000.00"},{"v":50000,"d":"50,000.00"},null,{"v":968000,"d":"968,000.00"}]
[null,"Human Resources",null,{"v":40,"d":"40 "},null,{"v":835000,"d":"835,000 "},{"v":208750,"d":"208,750 "},{"v":1043750,"d":"1,043,750 "},{"v":0.05,"d":"5.0%"},null,{"v":41750,"d":"41,750.00"},{"v":0,"d":"0.00"},null,{"v":1085500,"d":"1,085,500.00"}]
[null,"Information Technology",null,{"v":42,"d":"42 "},null,{"v":950000,"d":"950,000 "},{"v":237500,"d":"237,500 "},{"v":1187500,"d":"1,187,500 "},{"v":0.05,"d":"5.0%"},null,{"v":47500,"d":"47,500.00"},{"v":0,"d":"0.00"},null,{"v":1235000,"d":"1,235,000.00"}]
[null,"Accounting",null,{"v":28,"d":"28 "},null,{"v":540000,"d":"540,000 "},{"v":135000,"d":"135,000 "},{"v":675000,"d":"675,000 "},{"v":0.05,"d":"5.0%"},null,{"v":27000,"d":"27,000.00"},{"v":0,"d":"0.00"},null,{"v":702000,"d":"702,000.00"}]
[null,"Sales",null,{"v":44,"d":"44 "},null,{"v":1000000,"d":"1,000,000 "},{"v":250000,"d":"250,000 "},{"v":1250000,"d":"1,250,000 "},{"v":0.4,"d":"40.0%"},null,{"v":400000,"d":"400,000.00"},{"v":0,"d":"0.00"},null,{"v":1650000,"d":"1,650,000.00"}]
[null,"Operations",null,{"v":36,"d":"36 "},null,{"v":705000,"d":"705,000 "},{"v":176250,"d":"176,250 "},{"v":881250,"d":"881,250 "},{"v":0.1,"d":"10.0%"},null,{"v":70500,"d":"70,500.00"},{"v":0,"d":"0.00"},null,{"v":951750,"d":"951,750.00"}]
[null,"Marketing",null,{"v":20,"d":"20 "},null,{"v":690000,"d":"690,000 "},{"v":172500,"d":"172,500 "},{"v":862500,"d":"862,500 "},{"v":0.05,"d":"5.0%"},null,{"v":34500,"d":"34,500.00"},{"v":0,"d":"0.00"},null,{"v":897000,"d":"897,000.00"}]
[]
[null,"Corporate Totals",null,{"v":254,"d":"254 "},null,{"v":6640000,"d":"$6,640,000"},{"v":1660000,"d":"$1,660,000"},{"v":8300000,"d":"$8,300,000"},null,null,{"v":875250,"d":"$875,250"},{"v":250000,"d":"$250,000"},null,{"v":9425250,"d":"$9,425,250"}]
[]
[]
[null,"Department",null,"Total number \nof employees",null,"% of total","Total comp","% of total",null,"Key metrics:"]
[null,"Executive",null,{"v":20,"d":"20 "},null,{"v":0.07874015748031496,"d":"7.9%"},{"v":1936000,"d":"$1,936,000"},{"v":0.20540569215670673,"d":"20.5%"},null,"Revenue/employee",null,{"v":20692.91338582677,"d":"$20,693"}]
[null,"Finance",null,{"v":24,"d":"24 "},null,{"v":0.09448818897637795,"d":"9.4%"},{"v":968000,"d":"968,000 "},{"v":0.10270284607835337,"d":"10.3%"},null,"Total compensation/employee",null,{"v":37107.28346456693,"d":"$37,107"}]
[null,"Human Resources",null,{"v":40,"d":"40 "},null,{"v":0.15748031496062992,"d":"15.7%"},{"v":1085500,"d":"1,085,500 "},{"v":0.11516935890294687,"d":"11.5%"}]
[null,"Information Technology",null,{"v":42,"d":"42 "},null,{"v":0.16535433070866143,"d":"16.5%"},{"v":1235000,"d":"1,235,000 "},{"v":0.13103100713508925,"d":"13.1%"},null,"Quarterly metrics:"]
[null,"Accounting",null,{"v":28,"d":"28 "},null,{"v":0.11023622047244094,"d":"11.0%"},{"v":702000,"d":"702,000 "},{"v":0.07448078300310336,"d":"7.4%"},null,null,"Salary","Benefits","Salary + benefits"]
[null,"Sales",null,{"v":44,"d":"44 "},null,{"v":0.1732283464566929,"d":"17.3%"},{"v":1650000,"d":"1,650,000 "},{"v":0.17506166945173868,"d":"17.5%"},null,"Q1",{"v":1646250,"d":"$1,646,250"},{"v":411562.5,"d":"$411,563"},{"v":2057812.5,"d":"$2,057,813"}]
[null,"Operations",null,{"v":36,"d":"36 "},null,{"v":0.14173228346456693,"d":"14.2%"},{"v":951750,"d":"951,750 "},{"v":0.10097875387920745,"d":"10.1%"},null,"Q2",{"v":1651250,"d":"1,651,250 "},{"v":412812.5,"d":"412,813 "},{"v":2064062.5,"d":"2,064,063 "}]
[null,"Marketing",null,{"v":20,"d":"20 "},null,{"v":0.07874015748031496,"d":"7.9%"},{"v":897000,"d":"897,000 "},{"v":0.0951698893928543,"d":"9.5%"},null,"Q3",{"v":1671250,"d":"1,671,250 "},{"v":417812.5,"d":"417,813 "},{"v":2089062.5,"d":"2,089,063 "}]
[{"$nulls":9},"Q4",{"v":1671250,"d":"1,671,250 "},{"v":417812.5,"d":"417,813 "},{"v":2089062.5,"d":"2,089,063 "}]
[{"$nulls":3},{"v":254,"d":"254 "},null,{"v":1,"d":"100.0%"},{"v":9425250,"d":"$9,425,250"},{"v":0.9999999999999999,"d":"100.0%"},null,null,{"v":6640000,"d":"$6,640,000"},{"v":1660000,"d":"$1,660,000"},{"v":8300000,"d":"$8,300,000"}]