Transcription
Sage 100Job Cost Report SamplesMarch 2018
2017 The Sage Group plc or its licensors. All rights reserved. Sage, Sage logos, andSage product and service names mentioned herein are the trademarks of The SageGroup plc or its licensors. All other trademarks are the property of their respectiveowners.
Job Cost Report SamplesThis section contains representative samples of the reports available in yourJob Cost module. Samples of the following reports are included. Job Field Report RegisterJob Posting Register - Direct CostsJob Posting Register - Billing PostingsDaily Job Transaction RegisterDaily Transaction RegisterJob Billing Selection RegisterInvoiceJob Billing RegisterJob Billing Register RecapTax Journal SummaryJob Estimate - Item DetailJob Estimate - Item Price SummaryJob Estimate Materials ReportJob Estimate by Cost Code ReportJob ListingJob MemoJob Field Report WorksheetJob Analysis ReportWork in Process ReportJob Cost Code Detail ReportSubcontractor Analysis ReportJob Billing History ReportJob Billing Recap ReportJob Profitability ReportJob Close-Out ReportJob Transaction Detail ReportGeneral Ledger Posting RecapJob Transaction Detail ReportJob Daily Production ReportTime Track RegisterTime Track Burden Allocation Register
Job Field Report RegisterJournal Posting Date: 5/31/2020Edwardson Electric Company (EEC)Job NoCost CodeCostTypeVendorU/MEEC2140 Saddleback-Hospital TD CostEstimated UnitsJTD teAdd 0.00% 5/15/20200.00% C30.0073.00% 8/24/20170.000.000.000.000.00% C18.0090.00% 8/24/20172,000.002,100.550.000.00105.03% C0.00100.00% 5/12/2020FEET0.00162.000.00300.000.00% N845.0067.00% 8/24/2017FEET0.00111.000.0060.000.00% N0.000.00% 8/24/2017O0.000.000.000.000.00% C0.000.00% 8/24/2017100-099-001O0.00350.000.000.000.00% C0.000.00% 0025.00% C0.0025.00% ,000.0080.00% U0.0095.00% 5/15/2020200-090-000B0.000.000.000.000.00% C0.000.00% 8/24/2017200-099-000O1,000.00650.000.000.0065.00% C0.000.00% 0064.00% C0.0065.00% .0027.27% U0.0030.00% 5/15/2020300-090-000B250.0050.000.0040.0020.00% C0.000.00% 8/24/2017300-099-000O400.00365.000.000.0091.25% C0.000.00% 0.00% C4.0070.00% 00% U2.0050.00% 090.00% C0.0080.00% 0015.00% U0.0045.00% 0.00% C0.0035.00% 0.00% U0.0020.00% 0050.73% C0.0045.00% 5/1/2020400-090-000B200.00110.000.0088.0055.00% C0.000.00% % C0.000.00% 8/24/2017500-010-000LHOUR500.000.0020.000.000.00% C0.000.00% .00% U0.000.00% % C25.0075.00% .000.00% C0.000.00% 8/24/2017500-099-000O0.0055.000.000.000.00% C0.000.00% 8/24/2017500-099-001O0.0020.000.000.000.00% C0.000.00% 8/24/2017600-099-000O0.000.000.000.000.00% C0.000.00% 8/24/2017Run Date: 8/24/2017 12:48:56PMJ/C Date: 5/31/2020Page: 1
Job Posting RegisterJournal Posting Date: 5/31/2020Direct Cost Postings - Register No: JC-000001Edwardson Electric Company (EEC)Job No.Cost CodeCostTypeVendorReferencePostingDateDebit G/LAccountU/M Unit CostUnitsExtensionEntry No: 0002025Credit G/L Account: 201-00-00EEC2140 Saddleback-Hospital 2.7532.00408.00EEC2140 Saddleback-Hospital .15792.00118.80EEC2140 Saddleback-Hospital ,295.002.002,590.00EEC2140 Saddleback-Hospital .00526.001,578.00Entry No 0002025 Total:4,694.80Report Total:4,694.80Run Date: 8/24/2017 1:13:28PMJ/C Date: 5/31/2020Page: 1
Job Posting RegisterJournal Posting Date: 5/31/2020Billing Postings - Register No: JC-000002Edwardson Electric Company (EEC)Job No.DescriptionReferencePostingDateCreditG/L AccountRet % Bill AmountRetentionEntry No: 0003002Debit G/L Account: 105-00-00EEC2140 Saddleback-Hospital 05-00-0020.002,500.00500.00Entry No 0003002 Total:4,795.00700.00Report Total:4,795.00700.00SRV6430 Taylor/Dunn - T&M ContractSRV5880 Simmons Title-RelocationEEC4575 Coldwell-Tenant ImprovementRun Date: 8/24/2017 1:17:24PMJ/C Date: 5/31/2020Page: 1
Job Daily Transaction RegisterEdwardson Electric Company (EEC)Postings For: 8/24/2017JobSource NumberJCCost CodeCost VendorType NumberEEC2140 Saddleback-Hospital -000MEEC4220 Simmons Title - Remodel200-000-000ESRV5000 Far West Savings-Lobby -001LRun Date: 8/24/2017 3:08:11PMJ/C Date: 5/31/2020Reference / Posting 0.00408.00Job EEC2140 Total :4,694.8050.0085.004,250.00Job EEC4220 Total 0075.00Job SRV5000 Total :Source JC Total :812.009,756.808/24/2017 Total :9,756.80Report Total :9,756.80Page: 1
Daily Transaction RegisterEdwardson Electric Company (EEC)Postings For:5/31/2020Source Journal Account NumberAccount Description/Posting CommentJB-000001Accounts ReceivableJ/C Job Billing Entry - 5/31/2020Retention ReceivablesJ/C Job Billing Entry - 5/31/2020Work in Process - LaborJ/C Job Billing Entry - 5/31/2020Work in Process - MaterialJ/C Job Billing Entry - 5/31/2020Work in Process - SubcontractsJ/C Job Billing Entry - 5/31/2020Work in Process - OverheadJ/C Job Billing Entry - 5/31/2020Sales Tax PayableJ/C Job Billing Entry - 5/31/2020Deferred IncomeJ/C Job Billing Entry - 5/31/2020Revenue - Time & MaterialsJ/C Job Billing Entry - 5/31/2020Field LaborJ/C Job Billing Entry - 5/31/2020MaterialsJ/C Job Billing Entry - 5/31/2020SubcontractsJ/C Job Billing Entry - 5/31/2020OverheadJ/C Job Billing Entry - 53-00-00454-00-00456-00-00Run Date: 8/24/2017 4:26:56PMG/L Date: 29,982.264,970.553,440.31Journal 000001 Totals:80,552.0980,552.09Source JB Totals:80,552.0980,552.095/31/2020 Totals:80,552.0980,552.09Report Totals:80,552.0980,552.09Page: 1
Job Billing Selection ListingEdwardson Electric Company (EEC)Job NoDescriptionEEC2140Saddleback-Hospital RemodelManager: ELLIOTTBill Method: FIXEDCustomer: 01-SADDLERet Rate:20.00%Saddleback Community HospType: 001Terms: 01SP: 0200Bill Date:Rev Cont:36,450.00ACT %Cmplt:60.00%Billable:Rev Est:33,515.00CALC %Cmplt:55.13%Sales Tax:0.00JTD Cost:18,477.55Billed To Date: 19,570.00Retention:460.00EEC3550Koll-Savi Ranch ProjectManager: ELLIOTTBill Method: FIXEDCustomer: 01-KOLL2,300.00Koll Development Company Type: 001Ret Rate:20.00%325,000.00ACT %Cmplt:12.50%Billable:Rev Est:262,600.00CALC %Cmplt:14.46%Sales Tax:0.0037,982.50Billed To Date:9,750.00Retention:6,175.00EEC4220Simmons Title - RemodelManager: STEVENS Bill Method: FIXEDCustomer: 01-SIMMONSRet Rate:0.00%ACT %Cmplt:100.00%SP: 0100SP: 01000002541BatchNo:00001INV Total:1,840.005/31/2020Comm Rate: 2.00 INV Date: 5/31/202030,875.00SIMMONS TITLE COMPANYType: 001Terms: 01INV No:Bill Date:Rev Cont:JTD Cost:Terms: 015/31/2020Comm Rate: 2.50 INV Date: 5/31/2020INV No:0002542BatchNo:00001INV Total:Bill Date:24,700.005/31/2020Comm Rate: 2.00 INV Date: 5/31/2020Rev Cont:3,000.00INV No:0002540Rev Est:2,332.50CALC %Cmplt: 100.32%Sales Tax:0.00BatchNo:00001JTD Cost:2,340.00Billed To Date:Retention:0.00INV Total:SRV50000.00Far West Savings-Lobby Remodel Customer: 02-FARWESTManager: STEVENS Bill Method: TIMEBillable:Ret Rate:0.00%3,000.00Far West Savings & LoanType: 002Terms: 02Comm Rate: 2.50 INV Date: 5/31/2020SP: 0100Bill Date:3,000.005/31/2020Rev Cont:12,000.00ACT %Cmplt:70.00%Billable:INV No:0002543Rev Est:11,500.00CALC %Cmplt:72.13%Sales Tax:13.70BatchNo:000018,294.86Billed To Date:6,814.19Retention:0.00INV Total:JTD Cost:Cost Code600-020-000600-020-000Type Billed Vendor NoMMYY189.02DescriptionBill Method U/M Unbilled Units Unbilled Cost Bill Rate Unit Price Bill AmountREF: JJ2696REF: 00%94.5194.51Net Invoice:SRV6250Precision Tool-WarehouseManager: BAKERBill Method: TIME202.72Customer: 02-PRECISNType: 002Terms: 01Comm Rate: 2.50 INV Date: 5/31/20205/31/2020Ret Rate:0.00%Rev Cont:15,000.00ACT %Cmplt:25.00%Billable:INV No:0002544Rev Est:10,500.00CALC %Cmplt:39.24%Sales Tax:0.00BatchNo:000014,120.00Billed To Date:1,020.00Retention:0.00INV Total:JTD Cost:Cost pe Billed Vendor NoLLLLYYYYSP: 0100Bill Date:189.02Precision Tool Company1,450.00DescriptionBill Method U/M Unbilled Units Unbilled Cost Bill Rate Unit Price Bill AmountREF: 0002016REF: 0002016REF: 0002016REF: Net Invoice:Report Total:Run Date: 8/24/2017 3:16:31PMJ/C Date: 1,192.72Page: 1
Page: 1INVOICEINVOICE NUMBER: 0002543-INEdwardson Electric CompanyINVOICE DATE: 5/31/2020SALESPERSON: 0100Far West Savings & Loan3458 Jubilee RoadIrvine, CACUSTOMER NO: 02-FARWESTJOB NUMBER: SRV5000TERMS: 2% 10 Days, Net 30CONTACT: Hal SimmonsBILL METHOD: TIME & MATERIALJOB DESC: Far West Savings-Lobby RemodelCOMMENT:ORIGINAL CONTRACT AMOUNT:12,000.00TAXABLE AMOUNT:NON-TAXABLE AMOUNT:189.020.00AMOUNT BILLED THIS INVOICE:189.02PLUS SALES TAX:13.70INVOICE TOTAL:202.72
Job Billing RegisterJournal Posting Date : 5/31/2020JB-000001Register Number:Edwardson Electric Company (EEC)Job Number/ Description Batch RevisedInvoice No Invoice DateNoContractBilledTo 2140Saddleback-Hospital RemodTerms: 01SLSPRSN: 0200Ret Rate: 20.00%0002541-IN 5/31/202000001 36,450.00 19,570.00 60.00% 60.00%2,300.00460.0001-SADDLECAEEC3550Koll-Savi Ranch ProjectTerms: 01SLSPRSN: 0100Ret Rate: 20.00%0002542-IN 5/31/202000001 325,000.00 9,750.00 12.50% 12.50%30,875.006,175.0001-KOLLCAEEC4220Simmons Title - Remodel Terms: 010002540-IN 5/31/2020000013,000.0001-SIMMONSSLSPRSN: 0100Ret Rate: 0.00%0.00 100.00% 100.00%3,000.000.00CASRV6250Precision Tool-Warehouse Terms: 01SLSPRSN: 0100Ret Rate: 0.00%0002544-IN 5/31/202000001 15,000.00 1,020.00 25.00% 16.47%1,450.0002-PRECISNCAReport Total: 416,450.00 42,154.19Run Date: 8/24/2017 4:25:38PMJ/C Date: t ImprovemeTerms: 01SLSPRSN: 0100Ret Rate: 20.00%0002545-IN 5/31/202000001 25,000.00 5,000.000.00% 20.00%0.0001-COLDWELSRV5000Far West Savings-Lobby ReTerms: 02SLSPRSN: 0100Ret Rate: 0.00%0002543-IN 5/31/202000001 12,000.00 6,814.19 70.00% 192.72Page: 1
Job Billing Register - G/L WIP RecapRegister Number:JB-000001Edwardson Electric Company (EEC)Job NoEEC2140DescriptionCost TypeSaddleback-Hospital EEC4575SRV5000SRV6250350.55115.00100.00748.00G/L PostingWork In -00453-00-00Simmons Title - RemodelSSubcontractLLaborMMaterial120.00 144-00-001,318.75 141-00-00901.25 143-00-00454-00-00451-00-00453-00-00Job EEC4220 Total:2,340.00Coldwell-Tenant 00.00100.31850.002,514.25Job EEC4575 Total:4,464.56Job EEC2140 Total:EEC3550PostingAmount1,313.55Koll-Savi Ranch 02,832.501,700.0023,350.00Job EEC3550 0454-00-00456-00-00451-00-00453-00-00Far West Savings-Lobby RemodelMMaterial78.76 143-00-00453-00-00Job SRV5000 Total:78.76Precision Tool-WarehouseOOverheadLLaborMMaterial392.50 146-00-00362.50 141-00-002,390.00 143-00-00Job SRV6250 Total:3,145.00Report Total:Run Date: 8/24/2017 4:25:55PMJ/C Date: 5/31/2020456-00-00451-00-00453-00-0042,724.37Page: 1
Job Billing Register - Tax Journal SummaryRegister Number: JB-000001Edwardson Electric Company (EEC)Tax eTax0.00ExemptAmount0.00Sales TaxAmount13.7013.70Run Date: 8/24/2017 4:26:11PMJ/C Date: 5/31/2020Page: 1
Job Estimate PrintingItem DetailEdwardson Electric Company (EEC)Customer: 01-A&H Adams & HanksEstimate No: EST1097 Adams & Hanks-Office RemodelEstimator:POWERSJob Type:001 Contract BillingEst Status:N NewStatus Date: 5/1/2020Job Address:444 Centerpoint DriveSQUARE FTFloor 12, Costa Mesa, CAStart Date:7/15/20209/15/2020Comment:Partners OfficeCompl Date:Contact:Jill ThompsonPhone: (714) 540-1414 Ext:LineItem CodesCostTake OffDescription/Assembly Items Type U/MQuantity1ASS-2X4-LTINSTALL 2X4 FLUORESCENTEACH8.00FLEX-3/4INSTALL 2X4 FLUORESCENT MEACH80.001.55124.002X4 FLORINSTALL 2X4 FLUORESCENT MEACH8.0088.00704.00LAMP-F-3INSTALL 2X4 FLUORESCENT MEACH16.000.8814.08J-BOXINSTALL 2X4 FLUORESCENT MEACH8.000.584.64COUPL-P-3/4INSTALL 2X4 FLUORESCENT MEACH8.000.090.72CONN-P-3/4"INSTALL 2X4 FLUORESCENT MEACH8.000.09ELECTRICIANINSTALL 2X4 FLUORESCENT LHOUR2.0032.00#12 INDOORINSTALL 2X4 FLUORESCENT MEACH120.000.2024.00PUnit CostAssembly ASS-2X4-LT Total:2DUPLEX-44 PLUG DUPLEX OUTLET3/CAll work to be done per building4/MWire pull from basement panel5*SUBMaterial 80.001.1264.0015.00%27.601,730.001,144.41Estimate EST1097 Direct Total:J/C Date: 20-05-31ExtendedCost936.16Total for all ItemsRun Date: 8/24/2017 4.413,374.252,424.413,374.25Page: 1
Job Estimate PrintingItem Price SummaryEdwardson Electric Company (EEC)Customer: 01-PENSKE Penske LeasingEstimate No: EST3299 Penske Leasing-RemodelItem CodeDescription1ASS-2X4-LTINSTALL 2 x 4 FLUORESCENEACH13.002,811.252DUPLEX-CV-44 PLUG DUPLEX COVEREACH24.0018.003COUPL-P-3/43/4 INCH PIPE COUPLINGEACH38.005.324DUPLEX-44 PLUG DUPLEX OUTLETEACH24.00114.005*SUBMaterial Subtotal6ELECTRICIANWire Pull 00768.008*SUBInstallation Labor9ASS-DETECINSTALL SMOKE-DETEC (WILineTake Off Unit Of MeasurJ/C Date: 20-05-31Extended Price2,948.571,152.00EACHEstimate EST3299 Direct Total:Run Date: 8/24/2017 4:32:32PMTake Off Quantity32.002,080.006,180.57Page: 4
Job Estimate Materials ReportEdwardson Electric Company (EEC)Estimate No: EST1123Clothestime #317-BuildoutEstimator: ELLIOTTJob Type: 001 Contract BillingEst. Status: N NewStatus Date: 05/01/20Customer No: Job Address: 5641 Bristol StreetSanta Ana, CACompl Date: 11/15/20Contact: Mr. John StutzItem CodeDescriptionCost TypeU/M12 GAUGE INDOOR WIRE2 X 4 DROP-IN FLUORESCENT3/4 INCH PIPE CONNECTOR3/4 INCH PIPE COUPLING4 PLUG DUPLEX OUTLET3/4 INCH FLEX CONDUITJ-TYPE CEILING BOXFLUORESCENT LAMP 3'WIRED IN SMOKE EACHEACHEACHEACH3,500Start Date: 09/01/20Comment: Franchisee#12 INDOOR2X4 P-F-3SMOKE-DET-BIRun Date: 8/24/2017 5:02:40PMJ/C Date: 5/31/2020SQUARE FT:Phone: (714) 876-1234Ext:QuantityUnit CostExtended CostMarkup AmtExtended ,278.482,897.522,897.526,176.006,176.00Page: 1
Job Estimate By Cost Code ReportEdwardson Electric Company (EEC)Estimate No: EST1123Clothestime #317-BuildoutEstimator: ELLIOTTJob Type: 001Est. Status: NContract BillingJob Address: 5641 Bristol StreetSanta Ana, CANewItem Code300-000-000L LaborWire PullELECTRICIANCompl Date: 11/15/20Contact: Mr. John StutzPhone: (714) 876-1234DescriptionU/MWire Pull LaborHOUREquip. Install-TransformerELECTRICIAN400-030-000E EquipmentL LaborEquip. Install - FixturesCATERPILLAR#12 Unit CostExtended CostExtended 2.00COST CODE 400-010-000 TOTAL:*Not on file*12 GAUGE EXTERIOR WIREELECTRICIANSITE FOREMANJOURNEYMAN ELECTRICIANM Material#12 INDOOR2X4 -4FLEX-3/4J-BOXLAMP-F-3PANEL-20PVC-3TRANS-AA112 GAUGE INDOOR WIRE2 X 4 DROP-IN FLUORESCENT3 INCH CONNECTOR3/4 INCH PIPE CONNECTOR3 INCH COUPLING3/4 INCH PIPE COUPLING4 PLUG DUPLEX OUTLET3/4 INCH FLEX CONDUITJ-TYPE CEILING BOXFLUORESCENT LAMP 3'20 STATION PANEL3 INCH UNDERGROUND PVCTRANSFORMER TYPE A1OPERMIT*Not on .0030.00Labor TYPE 40.0024.0048.002.00200.002.00Material TYPE .0050.00COST CODE 400-030-000 TOTAL:Run Date: 8/24/2017 5:05:20PMJ/C Date: 5/31/2020Ext:QuantityCOST CODE 300-000-000 TOTAL:400-010-000L Labor3,500Start Date: 09/01/20Comment: FranchiseeStatus Date: 05/01/20Cost Code /Cost TypeSQUARE FT:100.000.009,438.487,689.00Page: 1
Job ListingSorted by Job NumberEdwardson Electric Company (EEC)Job Number: EEC2140 Description: Saddleback-Hospital RemodelCustomer No:Job Address:Saddleback Community Hospital01-SADDLE1234 Olive Heights Rd.Orange, CAContact:Mike ShapiroPhone No:(714) 633-2571Ext: 545Comment:Job Status:OpenEstimator:JACOBSStatus Date:5/31/2020Manager:ELLIOTTEstimated Start Date:5/1/2020Contract No:Contract Date:2250-RTJ4/25/2020Estimated Comp. Date:Actual Start Date:8/31/20205/1/2020Job Type:001Contract BillingCompleted ContractSort Field:CLIENTAccounting Method:Retain Transaction Detail:YesBill Method:FixedUnit/Measure:SQ FEETRetention %:Calculate Sales Tax:20.00%Total SQ Feet:10,000.00NoContract Amount And Job Status:Original Estimate:33,075.00Revised Estimate:33,515.00Actual % Complete:Date Reported:60.00%Original Contract:30,000.005/15/2020Revised Contract:36,450.00Current Period:Last DatePeriod To Date:Year To Date:Job To Date:Actual Cost to Date:5/31/202012,339.5518,477.5518,477.55Invoice Billed:5/31/202014,120.0021,870.0021,870.00Payment Received:5/31/20209,400.009,400.009,400.00Calc % Complete:55.13%Retention Balance:3,884.00Deferred Revenue:19,710.001,313.55Current Cost/Unit:1.85Unbilled Cost(WIP):Current Cost Variance:1,631.45% of Contract Billed:Projected Variance:2,719.08Over/Under Billed:8.11%Projected Proft %:Proj Variance %:Proj Cost To Comp:12,318.3660.00%0.0015.51%Projected Profit(Loss):5,654.08Contract Change Order:Date:Comment:Contract Amount:Original Contract:5/31/2020Additional upgrades at customer request5/15/2020Upgrade of standard fixtures to class 25/20/2020Smoke detector installation5,000.00450.001,000.00Revised Contract:Run Date: 8/24/2017 5:06:38PMJ/C Date: 20-05-3130,000.0036,450.00Page: 1
Job Memo PrintingEdwardson Electric Company (EEC)Job Number/Description: EEC2140 Saddleback-Hospital RemodelMemo Code: APPROVALSDescription:Upgrade Request ApprovalsMemo Date:5/31/2020Reminder Start Date:3/13/2020Expiration Date:Reminder End Date:Auto Display: NeverAttachment:Saddleback has made numerous upgrade requests. Each request should be sent to Sam Elliot, the job manager, for approval routing.All requests must have the approval signature of the hospital administrator, John Shelley, in addition to Sam Elliot.Run Date: 8/24/2017 5:13:14PMJ/C Date: 5/31/2020Page:1
Job Field Report WorksheetSorted by Job NumberEdwardson Electric Company (EEC)Job Number: EEC3350 Nexus-17th Floor BuildoutActl % Complete: 85.00%200-000-000EstimatedCostM Material 20,000.00 SQUARE FT: 15,000.00Reported Date: 05/31/20Rev. Estimate: 15,750.00Project Profit %UnitsRev EstJTDUnitsCalculate% CmplActual %Completed Method Completed .00500.0043.50% COST45.00% HOUR46.67%65.00% FEETUNIT28.00% COST0.00%428.0085.60% 00.002,400.0086.38% COST80.00% HOUR80.00%70.00% FEETUNITWire Pull - BurdenB Burden200.00300-099-000Wire Pull - OverheadO Overhead650.00400-020-000Equip. Install - Panels66.3833.19% COST0.00%445.5068.54% COST0.00%L Labor150.00200.006.008.00100.00% COSTM .00100.00% EACH0.00% COST0.00% HOUREquip. Install - FixturesL LaborM Material400-040-00085.00% HOURUNITPanel - TestingL Labor400-030-000Reported %CompleteWire PullM Material400-020-001Add UnitsCompleted33.65%Interior Piping - OverheadL Labor300-090-000Rev. Contract:4,000.00150.00O Overhead300-000-000JTDCostCompl Date: 07/30/20Contract Date: 03/31/20Interior Piping - BurdenB Burden200-099-000Manager: ELLIOTTStart Date: 04/20/20Interior PipingL Labor200-090-000Estimator: MILLERStatus Date: 05/31/20Job Status: O OpenContract No: 4557-DTMCost Code /Cost TypeCustomer No: 01-NEXUS Nexus Construction Co.Bill Method: F FixedJob Type: 001 Contract 169.0066.67% COST100.00%UNIT65.00% HOUR75.00% EACHEquip. Install - TrimL Labor400.00300.0016.0012.00M ation - OverheadO Overhead900.00865.00600-099-000Maintenance - OverheadO Overhead0.00Run Date: 8/24/2017 5:14:45PMJ/C Date: 20-05-310.0075.00% COST25.00% HOUR42.00%10.00% EACHUNIT96.11% COST0.00%96.11% COST0.00%Page: 3
Job Analysis ReportCost Type Sorted by Job NumberEdwardson Electric Company (EEC)Job Number: EEC2140 Saddleback-Hospital RemodelJob Type: 001 Contract BillingJob Status: O OpenEstimator: JACOBSStart Date: 05/01/20Manager: ELLIOTTCompl Date: 08/31/20SQ FEET: 10,000.0036,450.00Rev. Contract:Reported Date: 05/15/20 Actl % Complete: 60.00%Est Profit:2,935.00Proj Profit:5,654.08% ofEstPrj Prft %:PeriodTo DateJobTo led To DateBill Method: F FixedStatus Date: 05/31/20Contract Date: 04/25/20Contract No: 2250-RTJCostTypeCustomer No: 01-SADDLE Saddleback Community HospitalCurrentVarianceProj Cost toComplete15.51%Proj %of EstL 00M 9.50S 297.552,132.77 109.90%O .00876.00 112.50%160.00160.00450.00450.0035.56%0.00290.00 5099.75%B BurdenCost Total for EEC2140:Cost per SQ FEET: :Job Number: EEC3350 Nexus-17th Floor BuildoutContract No: 4557-DTMActl % Complete: 85.00%CostTypeStart Date: 04/20/20Estimator: MILLERCompl Date: 07/30/20Manager: ELLIOTTStatus Date: 05/31/20Job Status: O Open88.82%Customer No: 01-NEXUS Nexus Construction Co.Bill Method: F FixedJob Type: 001 Contract Billing6,797.24 102.44%4,857.30Contract Date: 03/31/20Rev. Contract:20,000.00Reported Date: 05/31/20 Est Profit:4,250.00SQUARE FT: 15,000.006,730.14Proj 000.0015,750.0015,750.00 107.94%L 3,809.20 112.78%M .503,355.72 138.04%O 1.49 100.00%B Burden108.38108.38350.00350.0030.97%0.00241.62 ,252.507,718.03 120.62%0.380.751.051.0571.62%-0.080.51 120.62%Billed To DateCost Total for EEC3350:Cost per SQUARE FT: :Job Number: EEC3550 Koll-Savi Ranch ProjectStatus Date: 05/31/20Contract Date: 01/15/20Contract No: 1945-DTMReported Date: 05/31/20 Actl % Complete: 12.50%CostTypeDescriptionBilled To DateL LaborM MaterialS SubcontractRun Date: 8/24/2017 5:21:53PMJ/C Date: 20-05-31Proj Cost toCompleteProj %of Est-3,612.50Customer No: 01-KOLL Koll Development CompanyBill Method: F FixedJob Type: 001 Contract BillingJob Status: O OpenCurrentVariance33.65%JobTo DateDescription% ofEstPrj Prft %:PeriodTo DateStart Date: 02/13/20Estimator: MILLERCompl Date: 06/15/21Manager: ELLIOTT325,000.00Rev. Contract:Est Profit:62,400.00Proj Profit:21,140.00% ofEstSQUARE FT: 0.00CurrentVariancePrj Prft %:Proj Cost toComplete6.50%PeriodTo DateJobTo DateOriginalEstimateRevisedEstimateProj %of 084.62%500.00500.0092.31%149,940.00 100.00%Page: 1
Work In Process ReportDetail Sorted by Job NumberEdwardson Electric Company (EEC)Job Number: SRV5880 Simmons Title-RelocationBill Method: T Time & MaterialJob Type: 002 Service BillingContract Date: 01/01/20Contract No: 5880-DMTActl % Complete: 75.00%U/M200-099-000UnitsRev EstReported Date: 05/20/20 UnitsDollarsDollarsJTDRev EstJTDStart Date:Estimator:Manager: POWELLStatus Date: 05/31/20Job Status: O OpenCost Code /Cost TypeCustomer No: 02-SIMMONS Simmons Title CompanyCompl Date:Rev. Contract: 4,000.00Billed To Date: 1,784.00 Last Bill Date: 05/31/20% ofEstAct %CompSQUARE FT: 0.00Proj Cost toCompleteProj % Outstandingof EstWIPInterior Piping - OverheadO 0010.00%10.00% COST11.001,550.001,250.0080.65%55.00% UNIT0.000.000.00%0.00% COST0.000.00%0.000.00270.000.00%0.00% COST0.000.00%200.00Phase 600 Total:2,550.001,620.0063.53%1,922.72 138.93%1,200.00Job Total:2,550.001,620.0063.53%1,922.72 138.93%1,200.00Report Total:2,550.001,620.00Phase 200 Total:600-010-000L Labor0.000.00%0.000.000.00%0.00900.00 90.00%0.001,022.72 65.98%1,000.00Maintenance - LaborHOUR600-020-000M Material0.00% COST40.00Maintenance - MaterialEACH600-090-00020.00Maintenance - BurdenB Burden600-099-000Maintenance - OverheadO OverheadRun Date: 8/24/2017 5:25:00PMJ/C Date: 20-05-3175.00%05/201,200.00Page: 1
Job Cost Code Detail ReportDetail Sorted by Job NumberEdwardson Electric Company (EEC)Job Number: EEC4220 Simmons Title - RemodelCustomer No: 01-SIMMONS SIMMONS TITLE COMPANYStatus Date: 05/31/20Contract No: EEC-42J75Contract Date: 04/15/20Actl % Complete: 100.00%Cost Code /Cost Type200-000-000LMMM 3,000.00SQUARE FT: 1,000.00Cost JTD:2,340.00Prj % Est: 100.32%RevisedEstimate% ofEstAct %CompDateRptdCurrentVarianceProj Cost toCompleteProj %of EstInterior PipingCOST:368.75368.75400.00400.0092.19% 100.00% 0245.00250.00250.0098.00% 100.00% 05/31COST TOTAL:613.75613.75650.00650.0094.42%36.250.00PHASE 200 TOTAL:613.75613.75650.00650.0094.42%36.250.00 100.00%COST:450.00450.00400.00400.00 112.50% 100.00% 05/31-50.000.00 112.50%COST:237.50237.50250.00250.00COST TOTAL:687.50687.50650.00650.00 105.77%-37.500.00 105.77%PHASE 300 TOTAL:687.50687.50650.00650.00 105.77%-37.500.00 100.00%COST:500.00500.00600.00600.0083.33% 100.00% 05/31100.000.00COST:350.00350.00250.00250.00 140.00% 100.00% 05/31-100.000.00 140.00%850.00850.00850.00850.00 100.00%0.000.00 100.00%COST:68.7568.7562.5062.50 110.00% 100.00% 05/31-6.250.00 110.00%COST:120.00120.00120.00120.00 100.00% 100.00% 05/310.000.00 100.00%-6.250.00 100.00%-7.500.00 100.32%Wire PullLaborMaterial95.00% 100.00% 05/3112.500.0095.00%Equip. Install - FixturesLabor83.33%MaterialCOST TOTAL:400-040-000MReported 05/31/20D tJobOriginalTo DateEstimateRev. Contract:Material400-030-000LCompl Date: 05/15/20Manager: STEVENSLabor300-000-000LPeriodTo DateStart Date: 04/20/20Estimator: JACOBSBill Method: F FixedJob Type: 001 Contract BillingJob Status: C CompleteEquip. Install - FixturesMaterial400-050-000Equip. Install - FixturesS01-COCHRANSubcontractPHASE 400 TOTAL:1,038.751,038.751,032.501,032.50 100.61%Job Total:2,340.002,340.002,332.502,332.50 100.32% 100.00%Run Date: 8/24/2017 5:34:56PMJ/C Date: 20-05-3105/31Page: 1
Job Subcontractor Analysis ReportSorted by Job NumberEdwardson Electric Company (EEC)Cost CodeTrans DateRevisedEstimateSrc Reference/Posting RemarksKoll-Savi Ranch ProjectJob No: EEC3550Job Type: 001AmountBilledManager: ELLIOTTVendor No: 01-COCHRAN Cochrane's Concrete Coring100-010-001Underground Work - Backhoe DigLien Amount: 0.00REVISED ESTIMATEVendor No: 01-DENNICK100-020-000J/C Date: 5/31/2020Job Status: OpenStatus Date: 05/31/2020Contact: Jack CochranePhone: (714) 996-8534Release Date:500.00500.000.000.000.00500.00Vendor 01-COCHRAN Total:500.000.000.000.00500.00Dennick ConcreteContact: Scott SimmonsLien Amount: 0.00Phone: (714) 998-3764Release Date:6,000.006,000.0001DENNICK01157 Phase 1 completion01DEN
Job Posting Register Journal Posting Date: 5/31/2020 Direct Cost Postings - Register No: JC-000001 Edwardson Electric Company (EEC) Job No. Cost Code Units Extension
