XYCorp

Headcount & Pay Schedule

1/31/15 2/28/15 3/31/15 4/30/15 5/31/15 6/30/15 7/31/15 8/31/15 9/30/15 10/31/15 11/30/15 12/31/15

Employee Office Role Group 2014 BASE Start Date End Date Bonus xx xx xx xx T&E Total Salary
Name 1 NYC Support DESIGN 68,952 7/27/2010 68,952
Name 2 NYC Support DESIGN 150,000 1/1/2011 150,000
Name 3 NYC Support DESIGN 65,000 8/12/2013 65,000
Name 4 NYC Support DESIGN 65,000 7/1/2015 32,500
Name 5 NYC Support DESIGN 35,000 6/29/2015 17,694
Name 6 NYC Support DESIGN 50,000 1/1/2015 50,000
Name 7 NYC Support DESIGN 40,000 6/22/2015 21,000
Name 8 NYC Support DESIGN 69,000 1/1/2015 69,000
Name 9 NYC Support DESIGN 100,000 8/15/2015 37,903
Name 10 NYC Support DESIGN 46,000 4/20/2015 6/12/2015 7,539
Name 11 NYC Support DESIGN 65,000 1/1/2015 65,000
11
Totals $ - $ - $ - $ - $ - $ - $ 584,589

$ -

Month Ending,
1/31/15 2/28/15 3/31/15 4/30/15 5/31/15 6/30/15 7/31/15 8/31/15 9/30/15 10/31/15 11/30/15 12/31/15
Wages and Salaries
Name 1 NYC Support DESIGN $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746
Name 2 NYC Support DESIGN $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500
Name 3 NYC Support DESIGN $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417
Name 4 NYC Support DESIGN $ - $ - $ - $ - $ - $ - $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417
Name 5 NYC Support DESIGN $ - $ - $ - $ - $ - $ 194 $ 2,917 $ 2,917 $ 2,917 $ 2,917 $ 2,917 $ 2,917
Name 6 NYC Support DESIGN $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167
Name 7 NYC Support DESIGN $ - $ - $ - $ - $ - $ 1,000 $ 3,333 $ 3,333 $ 3,333 $ 3,333 $ 3,333 $ 3,333
Name 8 NYC Support DESIGN $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750
Name 9 NYC Support DESIGN $ - $ - $ - $ - $ - $ - $ - $ 4,570 $ 8,333 $ 8,333 $ 8,333 $ 8,333
Name 10 NYC Support DESIGN $ - $ - $ - $ 1,406 $ 3,833 $ 2,300 $ - $ - $ - $ - $ - $ -
Name 11 NYC Support DESIGN $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417
Total Wages and Salaries $ 38,996 $ 38,996 $ 38,996 $ 40,402 $ 42,829 $ 42,490 $ 50,663 $ 55,233 $ 58,996 $ 58,996 $ 58,996 $ 58,996
Monthly Head Count 6 6 6 7 7 9 9 10 10 10 10 10

in every cell, a single formula needs to produce this:

12/31/15
Pay, Bonus,
Employee Office Role Group 2014 BASE Start Date + Tax
Name 1 NYC Support DESIGN 68,952 7/27/2010 68,952
Name 2 NYC Support DESIGN 150,000 1/1/2011 150,000
Name 3 NYC Support DESIGN 65,000 8/12/2013 65,000
Name 4 NYC Support DESIGN 65,000 7/1/2015 32,500
Name 5 NYC Support DESIGN 35,000 6/29/2015 17,694
Name 6 NYC Support DESIGN 50,000 1/1/2015 50,000
Name 7 NYC Support DESIGN 40,000 6/22/2015 21,000
Name 8 NYC Support DESIGN 69,000 1/1/2015 69,000
Name 9 NYC Support DESIGN 100,000 8/15/2015 37,903
Name 10 NYC Support DESIGN 46,000 4/20/2015 7,539
Name 11 NYC Support DESIGN 65,000 1/1/2015 65,000
11
Totals $ 584,589

FYE
12/31/15
Wages and Salaries
Name 1 NYC Support DESIGN $ 68,952
Name 2 NYC Support DESIGN $ 150,000
Name 3 NYC Support DESIGN $ 65,000
Name 4 NYC Support DESIGN $ 32,500
Name 5 NYC Support DESIGN $ 17,694
Name 6 NYC Support DESIGN $ 50,000
Name 7 NYC Support DESIGN $ 21,000
Name 8 NYC Support DESIGN $ 69,000
Name 9 NYC Support DESIGN $ 37,903
Name 10 NYC Support DESIGN $ 7,539
Name 11 NYC Support DESIGN $ 65,000
Total Wages and Salaries $ 584,589
Monthly Head Count
XYCorp
Headcount & Pay Schedule
(Real Dollars)

1/31/15 2/28/15 3/31/15 4/30/15 5/31/15 6/30/15 7/31/15 8/31/15 9/30/15 10/31/15 11/30/15 12/31/15

Employee Office Role Group 2014 BASE Start Date End Date Bonus xx xx xx xx T&E Total Salary
Name 1 NYC Support DESIGN 68,952 7/27/2010 68,952
Name 2 NYC Support DESIGN 150,000 1/1/2011 150,000
Name 3 NYC Support DESIGN 65,000 8/12/2013 65,000
Name 4 NYC Support DESIGN 65,000 7/1/2015 32,500
Name 5 NYC Support DESIGN 35,000 6/29/2015 20,417
Name 6 NYC Support DESIGN 50,000 1/1/2015 50,000
Name 7 NYC Support DESIGN 40,000 6/22/2015 23,333
Name 8 NYC Support DESIGN 69,000 1/1/2015 69,000
Name 9 NYC Support DESIGN 100,000 8/15/2015 41,667
Name 10 NYC Support DESIGN 46,000 4/20/2015 6/12/2015 11,500
Name 11 NYC Support DESIGN 65,000 1/1/2015 65,000
11
Totals $ - $ - $ - $ - $ - $ - $ 597,369

$ -

Month Ending,
1/31/15 2/28/15 3/31/15 4/30/15 5/31/15 6/30/15 7/31/15 8/31/15 9/30/15 10/31/15 11/30/15 12/31/15
Wages and Salaries
Name 1 NYC Support DESIGN $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746
Name 2 NYC Support DESIGN $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500
Name 3 NYC Support DESIGN $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417
Name 4 NYC Support DESIGN $ - $ - $ - $ - $ - $ - $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417
Name 5 NYC Support DESIGN $ - $ - $ - $ - $ - $ 2,917 $ 2,917 $ 2,917 $ 2,917 $ 2,917 $ 2,917 $ 2,917
Name 6 NYC Support DESIGN $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167
Name 7 NYC Support DESIGN $ - $ - $ - $ - $ - $ 3,333 $ 3,333 $ 3,333 $ 3,333 $ 3,333 $ 3,333 $ 3,333
Name 8 NYC Support DESIGN $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750
Name 9 NYC Support DESIGN $ - $ - $ - $ - $ - $ - $ - $ 8,333 $ 8,333 $ 8,333 $ 8,333 $ 8,333
Name 10 NYC Support DESIGN $ - $ - $ - $ 3,833 $ 3,833 $ 3,833 $ - $ - $ - $ - $ - $ -
Name 11 NYC Support DESIGN $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417
Total Wages and Salaries $ 38,996 $ 38,996 $ 38,996 $ 42,829 $ 42,829 $ 49,079 $ 50,663 $ 58,996 $ 58,996 $ 58,996 $ 58,996 $ 58,996
Monthly Head Count 6 6 6 7 7 9 9 10 10 10 10 10
XYCorp
Headcount & Pay Schedule
(Real Dollars)

12/31/15
Pay, Bonus,
Employee Office Role Group 2014 BASE Start Date + Tax
Name 1 NYC Support DESIGN 68,952 7/27/2010 68,952
Name 2 NYC Support DESIGN 150,000 1/1/2011 150,000
Name 3 NYC Support DESIGN 65,000 8/12/2013 65,000
Name 4 NYC Support DESIGN 65,000 7/1/2015 32,500
Name 5 NYC Support DESIGN 35,000 6/29/2015 20,417
Name 6 NYC Support DESIGN 50,000 1/1/2015 50,000
Name 7 NYC Support DESIGN 40,000 6/22/2015 23,333
Name 8 NYC Support DESIGN 69,000 1/1/2015 69,000
Name 9 NYC Support DESIGN 100,000 8/15/2015 41,667
Name 10 NYC Support DESIGN 46,000 4/20/2015 11,500
Name 11 NYC Support DESIGN 65,000 1/1/2015 65,000
11
Totals $ 597,369

FYE
12/31/15
Wages and Salaries
Name 1 NYC Support DESIGN $ 68,952
Name 2 NYC Support DESIGN $ 150,000
Name 3 NYC Support DESIGN $ 65,000
Name 4 NYC Support DESIGN $ 32,500
Name 5 NYC Support DESIGN $ 20,417
Name 6 NYC Support DESIGN $ 50,000
Name 7 NYC Support DESIGN $ 23,333
Name 8 NYC Support DESIGN $ 69,000
Name 9 NYC Support DESIGN $ 41,667
Name 10 NYC Support DESIGN $ 11,500
Name 11 NYC Support DESIGN $ 65,000
Total Wages and Salaries $ 597,369
Monthly Head Count
XYCorp
Headcount & Pay Schedule
(Real Dollars)

1/31/15 2/28/15 3/31/15 4/30/15 5/31/15 6/30/15 7/31/15 8/31/15 9/30/15 10/31/15 11/30/15 12/31/15

Employee Office Role Group 2014 BASE Start Date End Date Bonus xx xx xx xx T&E Total Salary
Name 1 NYC Support DESIGN 68,952 7/27/2010 67,655
Name 2 NYC Support DESIGN 150,000 1/1/2011 147,177
Name 3 NYC Support DESIGN 65,000 8/12/2013 63,777
Name 4 NYC Support DESIGN 65,000 7/1/2015 37,387
Name 5 NYC Support DESIGN 35,000 6/29/2015 20,323
Name 6 NYC Support DESIGN 50,000 1/1/2015 49,059
Name 7 NYC Support DESIGN 40,000 6/22/2015 23,978
Name 8 NYC Support DESIGN 69,000 1/1/2015 67,702
Name 9 NYC Support DESIGN 100,000 8/15/2015 45,430
Name 10 NYC Support DESIGN 46,000 4/20/2015 6/12/2015 6,677
Name 11 NYC Support DESIGN 65,000 1/1/2015 63,777
11
Totals $ - $ - $ - $ - $ - $ - $ 592,942

$ -

Month Ending,
1/31/15 2/28/15 3/31/15 4/30/15 5/31/15 6/30/15 7/31/15 8/31/15 9/30/15 10/31/15 11/30/15 12/31/15
Wages and Salaries
Name 1 NYC Support DESIGN $ 5,190 $ 5,746 $ 5,561 $ 5,746 $ 5,561 $ 5,746 $ 5,746 $ 5,561 $ 5,746 $ 5,561 $ 5,746 $ 5,746
Name 2 NYC Support DESIGN $ 11,290 $ 12,500 $ 12,097 $ 12,500 $ 12,097 $ 12,500 $ 12,500 $ 12,097 $ 12,500 $ 12,097 $ 12,500 $ 12,500
Name 3 NYC Support DESIGN $ 4,892 $ 5,417 $ 5,242 $ 5,417 $ 5,242 $ 5,417 $ 5,417 $ 5,242 $ 5,417 $ 5,242 $ 5,417 $ 5,417
Name 4 NYC Support DESIGN $ - $ - $ - $ - $ - $ 5,236 $ 5,417 $ 5,242 $ 5,417 $ 5,242 $ 5,417 $ 5,417
Name 5 NYC Support DESIGN $ - $ - $ - $ - $ 94 $ 2,917 $ 2,917 $ 2,823 $ 2,917 $ 2,823 $ 2,917 $ 2,917
Name 6 NYC Support DESIGN $ 3,763 $ 4,167 $ 4,032 $ 4,167 $ 4,032 $ 4,167 $ 4,167 $ 4,032 $ 4,167 $ 4,032 $ 4,167 $ 4,167
Name 7 NYC Support DESIGN $ - $ - $ - $ - $ 860 $ 3,333 $ 3,333 $ 3,226 $ 3,333 $ 3,226 $ 3,333 $ 3,333
Name 8 NYC Support DESIGN $ 5,194 $ 5,750 $ 5,565 $ 5,750 $ 5,565 $ 5,750 $ 5,750 $ 5,565 $ 5,750 $ 5,565 $ 5,750 $ 5,750
Name 9 NYC Support DESIGN $ - $ - $ - $ - $ - $ - $ 4,301 $ 8,065 $ 8,333 $ 8,065 $ 8,333 $ 8,333
Name 10 NYC Support DESIGN $ - $ - $ 1,237 $ 3,833 $ 1,608 $ - $ - $ - $ - $ - $ - $ -
Name 11 NYC Support DESIGN $ 4,892 $ 5,417 $ 5,242 $ 5,417 $ 5,242 $ 5,417 $ 5,417 $ 5,242 $ 5,417 $ 5,242 $ 5,417 $ 5,417
Total Wages and Salaries $ 35,222 $ 38,996 $ 38,975 $ 42,829 $ 40,300 $ 50,482 $ 54,964 $ 57,093 $ 58,996 $ 57,093 $ 58,996 $ 58,996
Monthly Head Count 6 6 7 7 9 9 10 10 10 10 10 10
XYCorp
Headcount & Pay Schedule
(Real Dollars)

12/31/15
Pay, Bonus,
Employee Office Role Group 2014 BASE Start Date + Tax
Name 1 NYC Support DESIGN 68,952 7/27/2010 67,655
Name 2 NYC Support DESIGN 150,000 1/1/2011 147,177
Name 3 NYC Support DESIGN 65,000 8/12/2013 63,777
Name 4 NYC Support DESIGN 65,000 7/1/2015 37,387
Name 5 NYC Support DESIGN 35,000 6/29/2015 20,323
Name 6 NYC Support DESIGN 50,000 1/1/2015 49,059
Name 7 NYC Support DESIGN 40,000 6/22/2015 23,978
Name 8 NYC Support DESIGN 69,000 1/1/2015 67,702
Name 9 NYC Support DESIGN 100,000 8/15/2015 45,430
Name 10 NYC Support DESIGN 46,000 4/20/2015 6,677
Name 11 NYC Support DESIGN 65,000 1/1/2015 63,777
11
Totals $ 592,942

FYE
12/31/15
Wages and Salaries
Name 1 NYC Support DESIGN $ 67,655
Name 2 NYC Support DESIGN $ 147,177
Name 3 NYC Support DESIGN $ 63,777
Name 4 NYC Support DESIGN $ 37,387
Name 5 NYC Support DESIGN $ 20,323
Name 6 NYC Support DESIGN $ 49,059
Name 7 NYC Support DESIGN $ 23,978
Name 8 NYC Support DESIGN $ 67,702
Name 9 NYC Support DESIGN $ 45,430
Name 10 NYC Support DESIGN $ 6,677
Name 11 NYC Support DESIGN $ 63,777
Total Wages and Salaries $ 592,942
Monthly Head Count
XYCorp
Headcount & Pay Schedule
(Real Dollars)

1/31/15 2/28/15 3/31/15 4/30/15 5/31/15 6/30/15 7/31/15 8/31/15 9/30/15 10/31/15 11/30/15 12/31/15

Employee Office Role Group 2014 BASE Start Date End Date Bonus xx xx xx xx T&E Total Salary
Name 1 NYC Support DESIGN 68,952 7/27/2010 68,952
Name 2 NYC Support DESIGN 150,000 1/1/2011 150,000
Name 3 NYC Support DESIGN 65,000 8/12/2013 65,000
Name 4 NYC Support DESIGN 65,000 7/1/2015 32,500
Name 5 NYC Support DESIGN 35,000 6/29/2015 17,694
Name 6 NYC Support DESIGN 50,000 1/1/2015 50,000
Name 7 NYC Support DESIGN 40,000 6/22/2015 21,000
Name 8 NYC Support DESIGN 69,000 1/1/2015 69,000
Name 9 NYC Support DESIGN 100,000 8/15/2015 37,903
Name 10 NYC Support DESIGN 46,000 4/20/2015 6/12/2015 6,772
Name 11 NYC Support DESIGN 65,000 1/1/2015 65,000
11
Totals $ - $ - $ - $ - $ - $ - $ 583,822

$ -

Month Ending,
1/1/15 2/1/15 3/1/15 4/1/15 5/1/15 6/1/15 7/1/15 8/1/15 9/1/15 10/1/15 11/1/15 12/1/15
Wages and Salaries
Name 1 NYC Support DESIGN $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746
Name 2 NYC Support DESIGN $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500
Name 3 NYC Support DESIGN $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417
Name 4 NYC Support DESIGN $ - $ - $ - $ - $ - $ - $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417
Name 5 NYC Support DESIGN $ - $ - $ - $ - $ - $ 194 $ 2,917 $ 2,917 $ 2,917 $ 2,917 $ 2,917 $ 2,917
Name 6 NYC Support DESIGN $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167
Name 7 NYC Support DESIGN $ - $ - $ - $ - $ - $ 1,000 $ 3,333 $ 3,333 $ 3,333 $ 3,333 $ 3,333 $ 3,333
Name 8 NYC Support DESIGN $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750
Name 9 NYC Support DESIGN $ - $ - $ - $ - $ - $ - $ - $ 4,570 $ 8,333 $ 8,333 $ 8,333 $ 8,333
Name 10 NYC Support DESIGN $ - $ - $ - $ 1,406 $ 3,833 $ 1,533 $ - $ - $ - $ - $ - $ -
Name 11 NYC Support DESIGN $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417
Total Wages and Salaries $ 38,996 $ 38,996 $ 38,996 $ 40,402 $ 42,829 $ 41,724 $ 50,663 $ 55,233 $ 58,996 $ 58,996 $ 58,996 $ 58,996
Monthly Head Count 6 6 6 7 7 9 9 10 10 10 10 10
XYCorp
Headcount & Pay Schedule
(Real Dollars)

12/31/15
Pay, Bonus,
Employee Office Role Group 2014 BASE Start Date + Tax
Name 1 NYC Support DESIGN 68,952 7/27/2010 68,952
Name 2 NYC Support DESIGN 150,000 1/1/2011 150,000
Name 3 NYC Support DESIGN 65,000 8/12/2013 65,000
Name 4 NYC Support DESIGN 65,000 7/1/2015 32,500
Name 5 NYC Support DESIGN 35,000 6/29/2015 17,694
Name 6 NYC Support DESIGN 50,000 1/1/2015 50,000
Name 7 NYC Support DESIGN 40,000 6/22/2015 21,000
Name 8 NYC Support DESIGN 69,000 1/1/2015 69,000
Name 9 NYC Support DESIGN 100,000 8/15/2015 37,903
Name 10 NYC Support DESIGN 46,000 4/20/2015 6,772
Name 11 NYC Support DESIGN 65,000 1/1/2015 65,000
11
Totals $ 583,822

FYE
12/31/15
Wages and Salaries
Name 1 NYC Support DESIGN $ 68,952
Name 2 NYC Support DESIGN $ 150,000
Name 3 NYC Support DESIGN $ 65,000
Name 4 NYC Support DESIGN $ 32,500
Name 5 NYC Support DESIGN $ 17,694
Name 6 NYC Support DESIGN $ 50,000
Name 7 NYC Support DESIGN $ 21,000
Name 8 NYC Support DESIGN $ 69,000
Name 9 NYC Support DESIGN $ 37,903
Name 10 NYC Support DESIGN $ 6,772
Name 11 NYC Support DESIGN $ 65,000
Total Wages and Salaries $ 583,822
Monthly Head Count
XYCorp
Headcount & Pay Schedule
(Real Dollars)

1/31/15 2/28/15 3/31/15 4/30/15 5/31/15 6/30/15 7/31/15 8/31/15 9/30/15 10/31/15 11/30/15 12/31/15

Employee Office Role Group 2014 BASE Start Date End Date Bonus xx xx xx xx T&E Total Salary
Name 1 NYC Support DESIGN 68,952 7/27/2010 68,952
Name 2 NYC Support DESIGN 150,000 1/1/2011 150,000
Name 3 NYC Support DESIGN 65,000 8/12/2013 65,000
Name 4 NYC Support DESIGN 65,000 7/1/2015 32,500
Name 5 NYC Support DESIGN 35,000 6/29/2015 17,500
Name 6 NYC Support DESIGN 50,000 1/1/2015 50,000
Name 7 NYC Support DESIGN 40,000 6/22/2015 20,000
Name 8 NYC Support DESIGN 69,000 1/1/2015 69,000
Name 9 NYC Support DESIGN 100,000 8/15/2015 41,667
Name 10 NYC Support DESIGN 46,000 4/20/2015 6/12/2015 7,667
Name 11 NYC Support DESIGN 65,000 1/1/2015 65,000
11
Totals $ - $ - $ - $ - $ - $ - $ 587,285

$ -

Month Ending,
1/1/15 2/1/15 3/1/15 4/1/15 5/1/15 6/1/15 7/31/15 8/31/15 9/30/15 10/31/15 11/30/15 12/31/15
Wages and Salaries
Name 1 NYC Support DESIGN $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746 $ 5,746
Name 2 NYC Support DESIGN $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500 $ 12,500
Name 3 NYC Support DESIGN $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417
Name 4 NYC Support DESIGN $ - $ - $ - $ - $ - $ - $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417
Name 5 NYC Support DESIGN $ - $ - $ - $ - $ - $ - $ 2,917 $ 2,917 $ 2,917 $ 2,917 $ 2,917 $ 2,917
Name 6 NYC Support DESIGN $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167 $ 4,167
Name 7 NYC Support DESIGN $ - $ - $ - $ - $ - $ - $ 3,333 $ 3,333 $ 3,333 $ 3,333 $ 3,333 $ 3,333
Name 8 NYC Support DESIGN $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750 $ 5,750
Name 9 NYC Support DESIGN $ - $ - $ - $ - $ - $ - $ - $ 8,333 $ 8,333 $ 8,333 $ 8,333 $ 8,333
Name 10 NYC Support DESIGN $ - $ - $ - $ - $ 3,833 $ 3,833 $ - $ - $ - $ - $ - $ -
Name 11 NYC Support DESIGN $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417 $ 5,417
Total Wages and Salaries $ 38,996 $ 38,996 $ 38,996 $ 38,996 $ 42,829 $ 42,829 $ 50,663 $ 58,996 $ 58,996 $ 58,996 $ 58,996 $ 58,996
Monthly Head Count 6 6 6 6 7 7 9 10 10 10 10 10

if using new formula, result is limited by start/end date but no prorating happens in start/end months
only the forward full month is populated fully and end month is populated as full..
XYCorp
Headcount & Pay Schedule
(Real Dollars)

12/31/15
Pay, Bonus,
Employee Office Role Group 2014 BASE Start Date + Tax
Name 1 NYC Support DESIGN 68,952 7/27/2010 68,952
Name 2 NYC Support DESIGN 150,000 1/1/2011 150,000
Name 3 NYC Support DESIGN 65,000 8/12/2013 65,000
Name 4 NYC Support DESIGN 65,000 7/1/2015 32,500
Name 5 NYC Support DESIGN 35,000 6/29/2015 17,500
Name 6 NYC Support DESIGN 50,000 1/1/2015 50,000
Name 7 NYC Support DESIGN 40,000 6/22/2015 20,000
Name 8 NYC Support DESIGN 69,000 1/1/2015 69,000
Name 9 NYC Support DESIGN 100,000 8/15/2015 41,667
Name 10 NYC Support DESIGN 46,000 4/20/2015 7,667
Name 11 NYC Support DESIGN 65,000 1/1/2015 65,000
11
Totals $ 587,285

FYE
12/31/15
Wages and Salaries
Name 1 NYC Support DESIGN $ 68,952
Name 2 NYC Support DESIGN $ 150,000
Name 3 NYC Support DESIGN $ 65,000
Name 4 NYC Support DESIGN $ 32,500
Name 5 NYC Support DESIGN $ 17,500
Name 6 NYC Support DESIGN $ 50,000
Name 7 NYC Support DESIGN $ 20,000
Name 8 NYC Support DESIGN $ 69,000
Name 9 NYC Support DESIGN $ 41,667
Name 10 NYC Support DESIGN $ 7,667
Name 11 NYC Support DESIGN $ 65,000
Total Wages and Salaries $ 587,285
Monthly Head Count