Parvathy Vijeesh

Team Member Client Status Project Start Date Marcus AirSpree Active 1/15/2020 Luisa Mior Photography Dropped 2/20/2020 Dakota Dot's Donuts Active 03/04/2020 Brianna Sparkle J Active 4/10/2020 Sylvia Giden Dropped 5/8/2020 Marina Seattle Mark Dropped 5/1/2020 Jaques Gamificatiun Active 1/15/2020 Tiago Kyllzone Active 2/15/2020 Priyanka Battletec Active 3/22/2020 table A Client Name Client ID Start of contract date Initial contract amount AirSpree - 1/15/2020 $2,250.00 Mior Photography - 2/20/2020 $4,500.00 Dot's Donuts - 03/04/2020 $5,670.00 Sparkle J - 4/10/2020 $6,321.00 Giden - 5/8/2020 $1,780.00 Seattle Mark - 5/1/2020 $1,500.00 Gamificatiun - 1/15/2020 $8,000.00 Kyllzone - 2/15/2020 $7,300.00 Battletec - 3/22/2020 $4,000.00 table B Client Name Sparkle J table C Client ID Account Balance- $5,792 Sales Sales Amount Category Commission % $0.00 Needs Immediate Improvement $0.00 to $1,000 0.00% $1,000 to $2,500 $1,000.00 Needs Improvement $2,500 to $7,000 $2,500.00 Good 10.00% $7,000.00 Great 15.00% $7,000 to $10,000 $10,000.00 Outstanding $10,000 and over Sales Associate 5.00% Sales Amount 20.00% Commission Marcelle $1,457.00 5.00% Amelie $5,588.00 15.00% table A Client ID Invoice Client Hours AirSpree - 5840 70 Mior Photography - 5770 21 Dot's Donuts - 5803 33 Gamificatiun - 5920 150 Kyllzone - 6025 255 Battletec - 5881 111 table B Monthly client hours PM for case level 20-95 Marcelle 96-127 Ben 128-159 Carol 160-260 George Project Completion Date Days to complete project Targeted days to completion 2/25/2020 41 45 5/10/2020 80 75 6/5/2020 93 100 6/25/2020 76 75 5/30/2020 22 25 5/13/2020 12 15 5/20/2020 126 130 6/1/2020 107 120 5/15/2020 54 60 Payment 1 Payment2 Payment 3 $450.00 $450.00 $450.00 $1,000.00 $900.00 $900.00 $1,500.00 $1,134.00 $1,134.00 $2,000.00 $1,264.00 $1,264.00 $800.00 $250.00 $250.00 $300.00 $150.00 $150.00 $3,000.00 $1,500.00 $1,500.00 $2,500.00 $1,350.00 $1,350.00 $1,000.00 $850.00 $850.00 Due Date Pay Date Account Status 7/14/2020 7/20/2020 Past Due 8/25/2020 8/20/2020 On-time payment 6/28/2020 6/30/2020 Past Due 9/3/2020 9/3/2020 On-time payment 9/1/2020 8/13/2020 On-time payment 7/25/2020 7/18/2020 On-time payment Difference in Days Performance Rating -4 4 5 0 -7 4 1 3 -3 2 -3 2 -4 4 -13 5 -6 4 Payment 4 Account Balance $450.00 $450.00 $900.00 $800.00 $1,134.00 $768.00 $1,264.00 $529.00 $300.00 $180.00 $300.00 $600.00 $1,500.00 $500.00 $1,350.00 $750.00 $900.00 $400.00 Assign Project Manager (PM) Marcelle Marcelle Marcelle Carol George Carol