Headcount and payroll planning1[1]

%5bCompany+Name%5d+Headcount+and+Payroll+Planning+%5bYear%5d%0d%0aAnnual+total%0d%0a4.00+4.00+4.00+4.00+4.00+0.00+20.00%0d%0a%0d%0aHEADCOUNT+SUMMARY%0d%0aExecutive+Chief+executive+officer+Chief+financial+officer+Chief+operating+officer+Chief+information+officer+President+Total+Finance+Vice+president+Financial+planning+director+Financial+analyst+Credit+analyst+Advisor+Total+Human+Resources+Vice+president+Director+Senior+human+resource+representative+Benefits+coordinator+Compensation+manager+Human+resource+generalist+Payroll+Trainer+Recruiter+Total+Information+Technology+Vice+president+Director+Systems+engineer+Systems+analyst+Technician+Support+Architect+Programmer+Total+Accounting+Vice+president+Controller+Accounting+manager+Accounts+receivable+Accounts+payable+Treasury+General+accountant+Total+Sales+Vice+president+Regional+director+Business+development%0d%0a%0d%0aQ1%0d%0a1.00+1.00+1.00+1.00+1.00+5.00%0d%0a%0d%0aQ2%0d%0a1.00+1.00+1.00+1.00+1.00+5.00%0d%0a%0d%0aQ3%0d%0a1.00+1.00+1.00+1.00+1.00+5.00%0d%0a%0d%0aQ4%0d%0a1.00+1.00+1.00+1.00+1.00+5.00%0d%0a%0d%0aAnnual+salary%0d%0a%24300%2c000+250%2c000+225%2c000+225%2c000+240%2c000%0d%0a%0d%0aQ1+cost%0d%0a%2475%2c000+62%2c500+56%2c250+56%2c250+60%2c000+0+%24310%2c000%0d%0a%0d%0aQ2+cost%0d%0a%2475%2c000+62%2c500+56%2c250+56%2c250+60%2c000+0+%24310%2c000%0d%0a%0d%0aQ3+cost%0d%0a%2475%2c000+62%2c500+56%2c250+56%2c250+60%2c000+0+%24310%2c000%0d%0a%0d%0aQ4+cost%0d%0a%2475%2c000+62%2c500+56%2c250+56%2c250+60%2c000+0+%24310%2c000%0d%0a%0d%0aAnnual+cost%0d%0a%24300%2c000+250%2c000+225%2c000+225%2c000+240%2c000+0+%241%2c240%2c000%0d%0a%0d%0a1.00+1.00+2.00+1.00+1.00+6.00%0d%0a%0d%0a1.00+1.00+2.00+1.00+1.00+6.00%0d%0a%0d%0a1.00+1.00+2.00+1.00+1.00+6.00%0d%0a%0d%0a1.00+1.00+2.00+1.00+1.00+6.00%0d%0a%0d%0a4.00+4.00+8.00+4.00+4.00+0.00+24.00%0d%0a%0d%0a%24200%2c000+125%2c000+100%2c000+70%2c000+85%2c000%0d%0a%0d%0a%2450%2c000+31%2c250+50%2c000+17%2c500+21%2c250+0+%24170%2c000%0d%0a%0d%0a%2450%2c000+31%2c250+50%2c000+17%2c500+21%2c250+0+%24170%2c000%0d%0a%0d%0a%2450%2c000+31%2c250+50%2c000+17%2c500+21%2c250+0+%24170%2c000%0d%0a%0d%0a%2450%2c000+31%2c250+50%2c000+17%2c500+21%2c250+0+%24170%2c000%0d%0a%0d%0a%24200%2c000+125%2c000+200%2c000+70%2c000+85%2c000+0+%24680%2c000%0d%0a%0d%0a1.00+1.00+2.00+1.00+2.00+2.00+1.00%0d%0a%0d%0a1.00+1.00+2.00+1.00+2.00+2.00+1.00%0d%0a%0d%0a1.00+1.00+2.00+1.00+2.00+2.00+1.00%0d%0a%0d%0a1.00+1.00+2.00+1.00+2.00+2.00+1.00%0d%0a%0d%0a10.00%0d%0a%0d%0a10.00%0d%0a%0d%0a10.00%0d%0a%0d%0a10.00%0d%0a%0d%0a4.00+4.00+8.00+4.00+8.00+8.00+4.00+0.00+0.00+0.00+40.00%0d%0a%0d%0a%24140%2c000+100%2c000+80%2c000+75%2c000+75%2c000+65%2c000+65%2c000+65%2c000+65%2c000%0d%0a%0d%0a%2435%2c000+25%2c000+40%2c000+18%2c750+37%2c500+32%2c500+16%2c250+0+0+0+%24205%2c000%0d%0a%0d%0a%2435%2c000+25%2c000+40%2c000+18%2c750+37%2c500+37%2c500+16%2c250+0+0+0+%24210%2c000%0d%0a%0d%0a%2435%2c000+25%2c000+40%2c000+18%2c750+37%2c500+37%2c500+16%2c250+0+0+0+%24210%2c000%0d%0a%0d%0a%2435%2c000+25%2c000+40%2c000+18%2c750+37%2c500+37%2c500+16%2c250+0+0+0+%24210%2c000%0d%0a%0d%0a%24140%2c000+100%2c000+160%2c000+75%2c000+150%2c000+145%2c000+65%2c000+0+0+0+%24835%2c000%0d%0a%0d%0a1.00+1.00+2.00+1.00+1.00+2.00+1.00+1.00+10.00%0d%0a%0d%0a1.00+1.00+2.00+1.00+1.00+2.00+1.00+1.00+10.00%0d%0a%0d%0a1.00+1.00+2.00+1.00+2.00+2.00+1.00+1.00+11.00%0d%0a%0d%0a1.00+1.00+2.00+1.00+2.00+2.00+1.00+1.00+11.00%0d%0a%0d%0a4.00+4.00+8.00+4.00+6.00+8.00+4.00+4.00+0.00+42.00%0d%0a%0d%0a%24140%2c000+110%2c000+90%2c000+90%2c000+80%2c000+75%2c000+80%2c000+80%2c000%0d%0a%0d%0a%2435%2c000+27%2c500+45%2c000+22%2c500+20%2c000+37%2c500+20%2c000+20%2c000+0+%24227%2c500%0d%0a%0d%0a%2435%2c000+27%2c500+45%2c000+22%2c500+20%2c000+37%2c500+20%2c000+20%2c000+0+%24227%2c500%0d%0a%0d%0a%2435%2c000+27%2c500+45%2c000+22%2c500+40%2c000+37%2c500+20%2c000+20%2c000+0+%24247%2c500%0d%0a%0d%0a%2435%2c000+27%2c500+45%2c000+22%2c500+40%2c000+37%2c500+20%2c000+20%2c000+0+%24247%2c500%0d%0a%0d%0a%24140%2c000+110%2c000+180%2c000+90%2c000+120%2c000+150%2c000+80%2c000+80%2c000+0+%24950%2c000%0d%0a%0d%0a1.00+1.00+1.00+1.00+1.00+1.00+1.00+7.00%0d%0a%0d%0a1.00+1.00+1.00+1.00+1.00+1.00+1.00+7.00%0d%0a%0d%0a1.00+1.00+1.00+1.00+1.00+1.00+1.00+7.00%0d%0a%0d%0a1.00+1.00+1.00+1.00+1.00+1.00+1.00+7.00%0d%0a%0d%0a4.00+4.00+4.00+4.00+4.00+4.00+4.00+0.00+28.00%0d%0a%0d%0a%24130%2c000+95%2c000+75%2c000+55%2c000+55%2c000+75%2c000+55%2c000%0d%0a%0d%0a%2432%2c500+23%2c750+18%2c750+13%2c750+13%2c750+18%2c750+13%2c750+0+%24135%2c000%0d%0a%0d%0a%2432%2c500+23%2c750+18%2c750+13%2c750+13%2c750+18%2c750+13%2c750+0+%24135%2c000%0d%0a%0d%0a%2432%2c500+23%2c750+18%2c750+13%2c750+13%2c750+18%2c750+13%2c750+0+%24135%2c000%0d%0a%0d%0a%2432%2c500+23%2c750+18%2c750+13%2c750+13%2c750+18%2c750+13%2c750+0+%24135%2c000%0d%0a%0d%0a%24130%2c000+95%2c000+75%2c000+55%2c000+55%2c000+75%2c000+55%2c000+0+%24540%2c000%0d%0a%0d%0a1.00+2.00+1.00%0d%0a%0d%0a1.00+2.00+1.00%0d%0a%0d%0a1.00+2.00+1.00%0d%0a%0d%0a1.00+2.00+1.00%0d%0a%0d%0a4.00+8.00+4.00%0d%0a%0d%0a%24120%2c000+100%2c000+90%2c000%0d%0a%0d%0a%2430%2c000+50%2c000+22%2c500%0d%0a%0d%0a%2430%2c000+50%2c000+22%2c500%0d%0a%0d%0a%2430%2c000+50%2c000+22%2c500%0d%0a%0d%0a%2430%2c000+50%2c000+22%2c500%0d%0a%0d%0a%24120%2c000+200%2c000+90%2c000%0d%0a%0d%0a%0cDirect+sales+representative+Inside+sales+Sales+operations+Channel+sales+representative+Total+Operations+Vice+president+Director+Manager+Floor+manager+Assistant+Total+Marketing+Vice+president+Director+Product+manager+Market+research+Market+analyst+Product+manager+Merchandiser+Assistant+Total+Corporate+totals%0d%0a%0d%0a4.00+1.00+1.00+1.00+11.00%0d%0a%0d%0a4.00+1.00+1.00+1.00+11.00%0d%0a%0d%0a4.00+1.00+1.00+1.00+11.00%0d%0a%0d%0a4.00+1.00+1.00+1.00+11.00%0d%0a%0d%0a16.00+4.00+4.00+4.00+0.00+44.00%0d%0a%0d%0a90%2c000+75%2c000+75%2c000+80%2c000%0d%0a%0d%0a90%2c000+18%2c750+18%2c750+20%2c000+0+%24250%2c000%0d%0a%0d%0a90%2c000+18%2c750+18%2c750+20%2c000+0+%24250%2c000%0d%0a%0d%0a90%2c000+18%2c750+18%2c750+20%2c000+0+%24250%2c000%0d%0a%0d%0a90%2c000+18%2c750+18%2c750+20%2c000+0+%24250%2c000%0d%0a%0d%0a360%2c000+75%2c000+75%2c000+80%2c000+0+%241%2c000%2c000%0d%0a%0d%0a1.00+1.00+1.00+5.00+1.00+9.00%0d%0a%0d%0a1.00+1.00+1.00+5.00+1.00+9.00%0d%0a%0d%0a1.00+1.00+1.00+5.00+1.00+9.00%0d%0a%0d%0a1.00+1.00+1.00+5.00+1.00+9.00%0d%0a%0d%0a4.00+4.00+4.00+20.00+4.00+0.00+36.00%0d%0a%0d%0a%24150%2c000+100%2c000+85%2c000+65%2c000+45%2c000%0d%0a%0d%0a%2437%2c500+25%2c000+21%2c250+81%2c250+11%2c250+0+%24176%2c250%0d%0a%0d%0a%2437%2c500+25%2c000+21%2c250+81%2c250+11%2c250+0+%24176%2c250%0d%0a%0d%0a%2437%2c500+25%2c000+21%2c250+81%2c250+11%2c250+0+%24176%2c250%0d%0a%0d%0a%2437%2c500+25%2c000+21%2c250+81%2c250+11%2c250+0+%24176%2c250%0d%0a%0d%0a%24150%2c000+100%2c000+85%2c000+325%2c000+45%2c000+0+%24705%2c000%0d%0a%0d%0a1.00+1.00+1.00+1.00+1.00+1.00+1.00+1.00+8.00+66.00%0d%0a%0d%0a1.00+1.00+1.00+1.00+1.00+1.00+1.00+1.00+8.00+66.00%0d%0a%0d%0a1.00+1.00+1.00+1.00+1.00+1.00+1.00+1.00+8.00+67.00%0d%0a%0d%0a1.00+1.00+1.00+1.00+1.00+1.00+1.00+1.00+8.00+67.00%0d%0a%0d%0a4.00+4.00+4.00+4.00+4.00+4.00+4.00+4.00+0.00+20.00+254.00%0d%0a%0d%0a%24135%2c000+105%2c000+90%2c000+75%2c000+75%2c000+90%2c000+70%2c000+50%2c000%0d%0a%0d%0a%2433%2c750+26%2c250+22%2c500+18%2c750+18%2c750+22%2c500+17%2c500+12%2c500+0+%24172%2c500+%241%2c646%2c250%0d%0a%0d%0a%2433%2c750+26%2c250+22%2c500+18%2c750+18%2c750+22%2c500+17%2c500+12%2c500+0+%24172%2c500+%241%2c651%2c250%0d%0a%0d%0a%2433%2c750+26%2c250+22%2c500+18%2c750+18%2c750+22%2c500+17%2c500+12%2c500+0+%24172%2c500+%241%2c671%2c250%0d%0a%0d%0a%2433%2c750+26%2c250+22%2c500+18%2c750+18%2c750+22%2c500+17%2c500+12%2c500+0+%24172%2c500+%241%2c671%2c250%0d%0a%0d%0a%24135%2c000+105%2c000+90%2c000+75%2c000+75%2c000+90%2c000+70%2c000+50%2c000+0+%24690%2c000+%246%2c640%2c000%0d%0a%0d%0aKEY+MODEL+INPUTS%0d%0aFringe+benefit+percentage+Fiscal+revenue+25.0%25+%245%2c256%2c000%0d%0a%0d%0aSUMMARY+DATA+BY+DEPARTMENT%0d%0aDepartment+Executive+Finance+Human+Resources+Information+Technology+Accounting+Sales+Operations+Marketing+Corporate+Totals+Total+number+of+employees+20+24+40+42+28+44+36+20+254+Total+salary+%241%2c240%2c000+680%2c000+835%2c000+950%2c000+540%2c000+1%2c000%2c000+705%2c000+690%2c000+%246%2c640%2c000+Benefits+%24310%2c000+170%2c000+208%2c750+237%2c500+135%2c000+250%2c000+176%2c250+172%2c500+%241%2c660%2c000+Salary+%2b+benefits+%241%2c550%2c000+850%2c000+1%2c043%2c750+1%2c187%2c500+675%2c000+1%2c250%2c000+881%2c250+862%2c500+%248%2c300%2c000+Variable+compensation+%25+15.0%25+10.0%25+5.0%25+5.0%25+5.0%25+40.0%25+10.0%25+5.0%25+Variable+pay+%24186%2c000+68%2c000.00+41%2c750.00+47%2c500.00+27%2c000.00+400%2c000.00+70%2c500.00+34%2c500.00+%24875%2c250+Stock-based+compensation+%24200%2c000+50%2c000.00+0.00+0.00+0.00+0.00+0.00+0.00+%24250%2c000+Total+compensation+%241%2c936%2c000+968%2c000.00+1%2c085%2c500.00+1%2c235%2c000.00+702%2c000.00+1%2c650%2c000.00+951%2c750.00+897%2c000.00+%249%2c425%2c250%0d%0a%0d%0aDepartment+Executive+Finance+Human+Resources+Information+Technology+Accounting+Sales+Operations+Marketing%0d%0a%0d%0aTotal+number+of+employees+20+24+40+42+28+44+36+20+254%0d%0a%0d%0a%25+of+total%0d%0a%0d%0aTotal+comp%0d%0a%0d%0a%25+of+total+20.5%25+10.3%25+11.5%25+13.1%25+7.4%25+17.5%25+10.1%25+9.5%25+100.0%25%0d%0a%0d%0aKey+metrics%3a+Revenue%2femployee+Total+compensation%2femployee+Quarterly+metrics%3a%0d%0aSalary+Benefits+Salary+%2b+benefits%0d%0a%0d%0a7.9%25+%241%2c936%2c000+9.4%25+968%2c000+15.7%25+1%2c085%2c500+16.5%25+1%2c235%2c000+11.0%25+702%2c000+17.3%25+1%2c650%2c000+14.2%25+951%2c750+7.9%25+897%2c000+100.0%25+%249%2c425%2c250%0d%0a%0d%0a%2420%2c693+%2437%2c107%0d%0a%0d%0aQ1+Q2+Q3+Q4%0d%0a%0d%0a%241%2c646%2c250+1%2c651%2c250+1%2c671%2c250+1%2c671%2c250+%246%2c640%2c000%0d%0a%0d%0a%24411%2c563+412%2c813+417%2c813+417%2c813+%241%2c660%2c000%0d%0a%0d%0a%242%2c057%2c813+2%2c064%2c063+2%2c089%2c063+2%2c089%2c063+%248%2c300%2c000%0d%0a%0d%0a%0cQuarterly+Analysis+of+Salary+and+Benefits%0d%0a%242%2c500%2c000%0d%0a%0d%0a%242%2c000%2c000%0d%0a%0d%0a%241%2c500%2c000%0d%0a%0d%0aSalary+Benefits+Salary+%2b+benefits%0d%0a%0d%0a%241%2c000%2c000%0d%0a%0d%0a%24500%2c000%0d%0a%0d%0a%240+Q1+Q2+Q3+Q4%0d%0a%0d%0aQuarter%0d%0a%0d%0a%0c