JPK ANALYSIS

JPK ANALYSIS KYLE PAY Total Overbilled Home Billing Total Hours Kyle @ $40 Jay@ $15 LSJE Travel @ 1.25 Saturday Hours JEE Kyle JPK Billed per hour per hour Check per day $unday Overbilled Qat Extra Pay Profit 8/5/18 54 2,160 810 2,970 7.5 0 7.5 413 300 113 8/12/18 56 2,240 840 3,080 6.25 4 10.25 564 410 154 8/19/18 56 2,240 840 3,080 6.25 3 9.25 509 370 139 8/26/18 60 2,400 900 3,300 7.5 0 7.5 413 300 113 9/2/18 48 1,920 720 2,640 6.25 0 6.25 344 250 94 9/9/18 46 1,840 690 2,530 5 3 8 440 320 120 9/16/18 46 1,840 690 2,530 6.25 2 8.25 454 330 124 9/23/18 54 2,160 810 2,970 6.25 2 8.25 454 330 124 9/30/18 54 2,160 810 2,970 6.25 2 8.25 454 330 124 10/7/18 55 2,200 825 3,025 7.5 0 7.5 413 300 113 10/14/18 52 2,080 780 2,860 6.25 2 8.25 454 330 124 10/21/18 60 2,400 900 3,300 8.75 0 8.75 481 350 131 10/28/18 61 2,440 915 3,355 7.5 2 9.5 523 380 143 11/4/18 51 2,040 765 2,805 6.25 0 6.25 344 250 94 11/11/18 57 2,280 855 3,135 8.75 0 8.75 481 350 131 11/18/18 61 2,440 915 3,355 7.5 2 9.5 523 380 143 11/25/18 38 1,520 570 2,090 3.75 2 5.75 316 230 86 12/2/18 - - - 0 - - - 12/9/18 - - - 0 - - - 12/16/18 - - - 0 - - - 12/23/18 - - - 0 - - - 12/30/18 - - - 0 - - - TOTALS 36,360 13,635 49,995 114 24 138 7,576 5,510 2,066 GSJ COTTAGE 10/3/18 Inv ft 1 Deposit -40% 66,660.74 11/2/18 Inv ft 2 24,636.87 Paid to date 91,297.61 Balance to finish 88,919.26 Total Job cost per invoice 166,651.87 Add: Impact windows and doors 13,565.00 Revised Total Cost 180,216.87 ROOFS - LIBRARY & MASTER 5/30/18 Deposit 150,000 Original bid for metal roofs 250,000.00 Revised bid for tile roofs 293,378.00 Per Jay all materials are on LSJ to begin job Estimated time to complete both 6.8 weeks FLAGPOLE POOL 10/15/18 Bid to demo and level floor 4,720.00 paid CHILLAX 11/30/18 Plaster and finish 2 openings 960.00 open GYM 12/3-12/7 Install 2 windows and 3 sliders 3,040.00 open EFTA00804250 CABANAS 1 & 2 10/3/18 Inv #1 Deposit -40% 22,081.89 11/2/18 Inv it 2 11,040.94 Paid to date 33,122.83 Balance to finish 48,149.64 Total Job cost per invoice 55,204.72 (note original scope of work was only Cabanas 1&2) Add: Change order for Cabanas 1-4 26,067.75 open Revised Total Cost 81,272.47 MAIN COMPOUND TILE WORK 10/1-10/7 76 Hours Jackie and Brian @ 55 per hour 4,180.00 paid 10/8-10/14 103 HoursJackieand Brian @ 55 per hour 6,789.47 paid (includes 1,124 of materials) 10/15 -10/21 & 10/22 -10/28 Invoice 110941 Amount 18,099.98 Less: billing or Erik @ 65 never on site (520.00) Less:Self Leveling Material only used on flagpole job (505.34) Less: Materials markup I (89.08) Less: Project Management fee (1,547.00) Revised amount 15,438.56 open 10/29-11/4 Invoice110945 Amount 10,083.65 Less: Materials markup (23.95) Less: Project Management fee (900.00) Revised amount 9,159.70 open Total Billed 39,153.10 Less: revisions (3,585.37) Revised Billed 35,567.73 Paid to datel (10,969.47) Balance owed 24,598.26 12/3-12/14 4 men @ 175 per hour to completework with labor not to exceed 14,000 and materials not to exceed 2,500 EIFS 12/3-12/14 Kitchen 12,125.00 Cabanas 1-4 8,400.00 Total EIFS 20,525.00 EFTA00804251