Jesca Kipkenda

FINAL OUTPUT BONUSES SPREADSHEET [TRAINING, MEETINGS ANY &Work ALL Hours OTHER WORK - includes Senior Manager Shift Work (not shift hours) MUST Include All work hours] ALL Overall Expected / Proposed / Up To Budget/Loc Name RICO Jay 100% 30.0 Dynamic Lucy 67% 20.0 61°W- Week 1 - Wed, Nov 7, 2018 - Wed, Nov 14, 2018 S Date - (1-7)) %Time Hours Pay/wk Pay(FT) Monthly $200.00 $200.00 $62.50 $93.80 Hours Worked % Time (FT) $800.00 /h BP $15.00 hourly $6.67 Steve O. Who did work 0 0% $250.00 $3.13 $3.13 Steve O. 16.75 56% % T (H) Pay for Work 0% $0.00 84% $52.37 Back Pay E W Who Verified 61°W Week-2 - Wed, Nov 14 - Wed, Nov 21, 2018, SD (8-14) Hours Worked $0 Steve O. % Time (FT) % T (H) 61°W -Week 3 -Wed, Nov 21 - Thur, Nov 29 2018 SD-(15-21) Pay for Work Back Pay IOU (C Equity) Paid (Y/N?) 0 0% 0% $0.00 $0 Steve O. 78% 118% Hours Worked % Time (FT) 0 0.00% 18.5 61.67% % T (H) Pay for Work 61°W-Week 4 - Thur, Nov 29 - Thur, Dec 6, 2018 ( SD 22-28) Back Pay E Who Verified Hours Worked % Time (FT) % T (H) Pay for Work DOOT - 29 MONTHLY TOTALS BackDOOT Pay E- 29 (Thu, Who Dec Verified 6, 2018, 6:48 AM UTC - Fri, DecTotal 7, 2018, Hours 7:20 AM $ based UTC) on Hours Actual Paid Budget Difference Owed 25% (actual Backpay) 0.00% $0.00 $0 Steve O. 0 0.00% 0.00% $0.00 $0 Steve O. 0.0 $0.00 $0.00 $800 92.55% $57.84 $0 Steve O. 10.5 35.00% 52.53% $32.83 $0 Steve O. 69.3 $216.51 $216.51 $250 $43.01 $10 Steve O. 13 43.33% 89.66% $38.56 $0 Steve O. 54.0 $160.16 $160.16 $172 $0.00 $0 $52.50 $7 Steve O. 16.5 55.00% 94.29% $49.50 $0 Steve O. 76.0 $228.00 $210.00 $210 $18.00 $23 $0 Steve O. 0 0.00% 0.00% $0.00 $0 Steve O. 2.0 $6.42 $6.42 $128 $0.00 $0.00 $0 $0 $0 Steve O. 23.5 $62.50 $21 Steve O. Fulcrum Zillu 48% 14.5 $43.01 $88.98 $172.02 $2.97 $2.97 Steve O. 7 23% 48% $20.76 $0 Steve O. 16.75 56% 116% $43.01 $13 Steve O. 17.25 57.50% 118.97% Zuri Albina 58% 17.5 $52.50 $90.00 $210.00 $3.00 $3.00 Steve O. 22.25 74% 127% $52.50 $18 Steve O. 18 60% 103% $52.50 $3 Steve O. 19.25 64.17% 110.00% Dynamic Joseph 33% 10.0 $32.11 $96.33 $128.44 $3.21 $3.21 Steve O. 2 7% 20% $6.42 $0 Steve O. 0 0% 0% $0.00 $0 Steve O. 0 0.00% 0.00% $0.00 $0.00 Zuri Steve O Jessica 34% 10.3 $30.07 $87.33 $120.28 $2.91 $2.91 Steve O. 5 17% 48% $14.55 $0 Albina 2.5 8% 24% $7.28 $0 Albina 0 0.00% 0.00% $0.00 $0 Albina 0 0.00% 0.00% $0.00 $0 Albina 7.5 $21.83 $21.83 $120 $0.00 $0 Cobalt 43% 13 $34.40 $79.39 $137.61 $2.65 $2.65 Steve O. 1.5 5% 12% $3.97 $0 Steve O. 3.5 12% 27% $9.26 $0 Steve O. 4.5 15.00% 34.62% $11.91 $0 Steve O. 3 10.00% 23.08% $7.94 $0 Steve O. 12.5 $33.08 $33.08 $138 $0.00 $0 $0 Jelo Abdul 55% 16.6 $43.01 $77.72 $172.02 $2.59 $2.59 Steve O. 0 0% 0% $0.00 $0 Steve O. 0 0% 0% $0.00 $0 Steve O. 0 0.00% 0.00% $0.00 $0 Steve O. 0 0.00% 0.00% $0.00 $0 Steve O. 0.0 $0.00 $0.00 $172 $0.00 $0 Jelo Zonaed Rejoan 33% 9.9 $17.20 $52.13 $68.81 $1.74 $1.74 Steve O. 0 0% 0% $0.00 $0 Steve O. 0 0% 0% $0.00 $0 Steve O. 0 0.00% 0.00% $0.00 $0 Steve O. 0 0.00% 0.00% $0.00 $0 Steve O. 0.0 $0.00 $0.00 $69 $0.00 $0 Jelo Teresa 34% 10.2 $24.08 $70.76 $96.33 $2.36 $2.36 Steve O. 0 0% 0% $0.00 $0 Steve O. 0 0% 0% $0.00 $0 Steve O. 0 0.00% 0.00% $0.00 $0 Steve O. 0 0.00% 0.00% $0.00 $0 Steve O. 0.0 $0.00 $0.00 $96 $0.00 $0 Jelo Mamun 47% 14 $36.13 $77.41 $144.50 $2.58 $2.58 Steve O. 0 0% 0% $0.00 $0 Steve O. 0 0% 0% $0.00 $0 Steve O. 0 0.00% 0.00% $0.00 $0 Steve O. 0 0.00% 0.00% $0.00 $0 Steve O. 0.0 $0.00 $0.00 $145 $0.00 $0 Assigned Work Hours Client Hours 12.5 5.75 $2,300 $18 $1,500.01 $750.01 TARGETED WORK HOURS Budget/Loc Name RICO Jay Total ClientTotal Asign RICO Steve Sonic Abdul MonthsPayment per month Dynamic Lucy 18º W - Sat 17th March to Mon 16th April 2018 $300.00 Global/Sonic/RICO Zillu 136º W -$300.00 Thu 15th Feb to Wed 15th March 2018 Zuri Albina 151ºE - Mon 16th April to Mon 14th May 2018 $247.00 Sonic Asif/Razu 3ºE - Tue$220.00 May 15th to Wed June 13th 2018 Sonic Ailene 116ºW -$300.00 Wed 13 June to Fri 13th July , 2018 3.5 8.75 Jocelyn 138ºE - Fri 13 July to Fri 10th Aug , 2018 $300.00 Steve O 31ºE - Sat 11 Aug to Sun 9th Sept , 2018 $190.91 1.75 Dynamic Joseph 90ºW - Sun 9th Sep to Tue 9th Oct , 2018 $250.00 1.75 JELO Teresa 123ºE -Tue 9th Oct , 2018 to Wed 7th Nov, 2018 $230.00 cobalt Jessica Rachel Farah Maricel 61ºW -Tue Wed 7th Nov, 2018 to Fri 7th Dec 2018 $230.00 Cobalt Cobalt Includes Jay Deliverables Value / Other/ Senior Manger Bonuses Bonus / Paid Time Assigned Work Hours 2h - co -chair Client Hours Output 18.5 6.5 12 .5.75 12.25 4 1.75 17.75 Sonic Zuri cobalt Output Deliverables Other/ Senior Manger Value/Paid Time Assigned Work Hours Client Hours Output Deliverables Other/ Senior MangerValue/Paid Time Assigned Work Hours -h - co -chair Client Hours Output/Production Deliverables Other/ Senior Manger Value/Paid Time Total output hours Co-chair Hours 6 4.5 4h- selene calendar 10.5 15.75 1.5h - co -chair 10.75 0.25 2h - co -chair 2.25 -$3,- 91.75 153% 42% $151 $18 107 1264% 59% Ave Full Team - Excluding Jay - FQN/Unity$2,942.91 91.75 177% Andromida Team 16.75 55.83% 34% First Global Team #REF! #REF! 66% $174.54 $36 105.5 648% 46% Ave $73.13 107 203% 39% #REF! 23.5 #REF! #REF! 105.5 183.33% 35.61% #REF! 134% 117% $17 $70.25 168% 26% 18.5 #REF! #REF! $70.25 133.33% 25.95% #REF! 119.17% 105.76% $0 $128.82 $221.25 64800% $221.25 $614.93 $1,500 0 0 0 0 0 0 0 0 $0 $0 0 0 0 0 0 0 $0 $0 0 0 0 0 0 0 $10.50 #REF! #REF! #REF! $69.25 #REF! #REF! #REF! 78.33% 71.09% $71.39 #REF! $376.67 $422 $200 #REF! JELO Misbah 67% $50.00 $75.00 ($ 200.00) $2.50 $2.50 $0.00 $0.00 $0.00 $0.00 $0.00 No 2 7% 10% $5.00 $0 No 1.5 5.00% 7.50% $3.75 $0 No 0 0.00% 0.00% $0 $0 No 3.5 $8.75 $8.75 $0 $0 Fulcrum Abu Hasan Shohag 50% 15 $37.50 $75.00 $150.00 $2.50 $2.50 0 0% 0% $0.00 $0 No 0 0% 0% $0.00 $0 No 0 0.00% 0.00% $0.00 $0 No 0 0.00% 0.00% $0.00 $0 No 0.0 $0.00 $0.00 $150 $0.00 $0 Zuri James 50% 15 $50.00 $100.00 $200.00 $3.33 $3.33 0% 0% $0.00 $0 No 0% 0% $0.00 $0 No 0.00% 0.00% $0.00 $0 No 0.00% 0.00% $0.00 $0 No 0.0 $0.00 $0.00 $200 $0.00 $0 Sonic/Cobalt Adam 70% 20.9375 $87.50 $125.37 $350.00 $4.18 $4.18 0% 0% $0.00 $0 No 0% 0% $0.00 $0 No 0.00% 0.00% $0.00 $0 No 0.00% 0.00% $0 $0 No 0.0 $0.00 $0.00 $0 $0 JELO Dhara 67% $300.00 $3.75 $3.75 0% 0% $0.00 $0 No 0% 0% $0.00 $0 No 0.00% 0.00% $0.00 $0 No 0.00% 0.00% $0 $0 No 0.0 $0.00 $0.00 $0 $0 $0 $0 $0 $0 $0.00 $0 JELO Lopa 33% $1.00 $1.00 0% 0% $0.00 $0 No 0% 0% $0.00 $0 No 0.00% 0.00% $0.00 $0 No 0.00% 0.00% $0 $0 No 0.0 $0.00 $0.00 JELO Salahuddin 33% 10 $62.50 $187.50 ($ 250.00) $6.25 $6.25 0% 0% $0.00 $0 No 0% 0% $0.00 $0 No 0.00% 0.00% $0.00 $0 No 0.00% 0.00% $0 $0 No 0.0 $0.00 $0.00 $350 $300 $40 $250 Andromeda Steve K. 42% 12.5 $78.13 $187.50 $6.25 $6.25 0% 0% $0.00 $0 No 0% 0% $0.00 $0 No 0.00% 0.00% $0.00 $0 No 0.00% 0.00% $0.00 $0 No 0.0 $0.00 $0.00 $313 20 10 $75.00 $112.50 $10.00 $30.00 $40.00 $312.50 0 0 0 Sonic Asif-Iqbal 50% 15 $47.09 $94.18 $188.35 $3.14 $3.14 0 0% 0% $0.00 $0 No 0 0% 0% $0.00 $0 No 0 0.00% 0.00% $0.00 $0 No Phoenix Ailene 50% 15 $45.00 $90.00 $180.00 $3.00 $3.00 0 0% 0% $0.00 $0 No 0 0% 0% $0.00 $0 No 0 0.00% 0.00% $0.00 $0 No Phoenix Jocelyn 50% 15 $67.50 $135.00 $270.00 $5.00 $4.50 0 0% 0% $0.00 $0 No 0 0% 0% $0.00 $0 No 0 0.00% 0.00% $0.00 $0 No Phoenix Shigemi 50% 15 $60.00 $120.00 $240.00 $4.00 $4.00 0 0% 0% $0.00 $0 No 0 0% 0% $0.00 $0 No 0 0.00% 0.00% $0.00 $0 No Sonic/Cobalt Maazi $0.00 6.75 #REF! #REF! #REF! $0.00 $0.00 $188 $0.00 $0 $0 $0.00 $0 $0 $0 $0.00 $0.00 $180 $0.00 $0 $0 $0.00 $0 $0 $0 0.0 $0.00 $0.00 $270 $0.00 $0 $0 $0.00 $0 $0 $0 $0 No 0.0 $0.00 $0.00 $240 $0.00 $0 $0 $0.00 $0 $0 $0 $2.35 $2.35 0 0% 0% $0.00 $0 No 0 0% 0% $0.00 $0 No 0 0.00% 0.00% $0.00 $0 No $0.00 0.00% 0.00% $0.00 $0 No 0.0 $0.00 $0.00 $188 $0.00 $0 $18.54 0 0% 0% $0.00 $0 No 0 0% 0% $0.00 $0 No 0 0.00% 0.00% $0.00 $0 No $0.00 0.00% 0.00% $0.00 $0 No 0.0 $0.00 $0.00 $0 $0 JELO 50% 15 $60.00 $120.00 $240.00 $4.00 $4.00 0 0% 0% $0.00 $0 No 0 0% 0% $0.00 $0 No 0 0.00% 0.00% $0.00 $0 No $0.00 0.00% 0.00% $0.00 $0 No 0.0 $0.00 $0.00 $0 $0 67% 20 $12.50 $12.50 0 0% 0% $0.00 $0 No 0 0% 0% $0.00 $0 No 0 0.00% 0.00% $0.00 $0 No $0.00 0.00% 0.00% $0.00 $0 No 0.0 $0.00 $0.00 $0 $0 $4.63 $4.63 0 0% 0% $0.00 $0 No 0 0% 0% $0.00 $0 No 0 0.00% 0.00% $0.00 0.00% 0.00% $0.00 $0 No 0.0 $0.00 $0 $0 $0.00 $556 $240 $1,000 $185 $175 $175 $0.00 $150 $0 10 $46.30 $138.91 ($ 185.22) $0 No $0.00 JELO Mehedi - $43.80 46% $96.27 $175.22 $3.21 $3.21 0 0% 0% $0.00 $0 No 0 0% 0% $0.00 $0 No 0 0.00% 0.00% $0.00 $0 No $0.00 0.00% 0.00% $0.00 $0 No 0.0 $0.00 JELO 92% 27.5 $43.75 $47.73 $175.00 $1.59 $1.59 0 0% 0% $0.00 $0 No 0 0% 0% $0.00 $0 No 0 0.00% 0.00% $0.00 $0 No $0.00 0.00% 0.00% $0.00 $0 No 0.0 $0.00 $37.50 $75.00 0 0% 0% $0.00 $0 No 0 0% 0% $0.00 $0 No 0 0.00% 0.00% $0.00 $0 No 0 0.00% 0.00% $0.00 $0 No 0.0 $0.00 $45.00 $90.00 $180.00 $3.00 $3.00 0 0% 0% $0.00 $0 No 0 0% 0% $0.00 $0 No 0 0.00% 0.00% $0.00 $0 No 0 0.00% 0.00% $0.00 $0 No 0.0 $0.00 $0.00 $180 $0 $60.00 $396.48 $240.00 $13.22 $13.22 0 0% 0% $0.00 $0 No 0 0% 0% $0.00 $0 No 0 0.00% 0.00% $0.00 $0 No 0 0.00% 0.00% $0.00 $0 No 0.0 $0.00 $240.00 $240 $0 Volunteer Kainat Farah Rachel Maricel Peter 0 0.00% #DIV/0! $0.00 #DIV/0! No 0.0 #DIV/0! $0 Jelo Jocelyn 0 0.00% #DIV/0! #DIV/0! $0 No 0.0 #DIV/0! $0 Jelo Teresa 0 0.00% #DIV/0! #DIV/0! #DIV/0! No 0.0 #DIV/0! $0 15.0 $150.00 $2.50 $2.50 50% 15.0 15% 4.5 0% 0.0 $0.00 $0.00 $0.00 #DIV/0! #DIV/0! 0 0% #DIV/0! $0.00 #DIV/0! No 0 0% #DIV/0! $0.00 #DIV/0! No 0 0.00% #DIV/0! $0.00 #DIV/0! No 0% 0.0 $0.00 #DIV/0! $0.00 $5.00 #DIV/0! 0 0% #DIV/0! #DIV/0! $0 No 0 0% #DIV/0! #DIV/0! $0 No 0 0.00% #DIV/0! #DIV/0! $0 No 0% 0.0 $0.00 #DIV/0! $0.00 #DIV/0! #DIV/0! 0 0% #DIV/0! #DIV/0! #DIV/0! No 0 0% #DIV/0! #DIV/0! #DIV/0! No 0 0.00% #DIV/0! #DIV/0! #DIV/0! No 6.75 $0 0.0 0.0 $0 No $0.00 $18.54 50% $0 $0 No $0 No $0.00 0.00% $188.35 33% $0 $0.00 $0.00 0.00% 0.00% $556.26 Mamun $0.00 0.00% 0.00% 0.00% $70.63 Cobalt $0 0.00% $139.07 $556.26 Cobalt $0 0.00% 20 Cobalt $0 $0.00 7.5 JELO $0 $0.00 67% $250.00 $375.00 $1,000.00 $0.00 $0.00 25% SF BAY LOCAL Mel $0 $0.00 SF BAY LOCAL Melinda Teresa $47.09 0 0 Ave $100.85 Not working 20 0 Ave #REF! Ave $105.51 $129 Ave $165.25 Ave #REF! Ave $73.13 $165 Ave $174.54 Ave #REF! #DIV/0! #DIV/0! #DIV/0! $0.00 $0.00 $0 $0 #DIV/0! #DIV/0! #DIV/0! $0 $0 $0 $0 $0 $0.00 $0.00 $0 $0 $0 $0.00 $0 $0 $0 #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! #DIV/0! $0 $0 #DIV/0! $0 $0 $0 #DIV/0! $0 $0 #DIV/0! $0 #REF! #REF! #REF! #REF! #REF!