Docstoc

Accounting for Construction Contract - Excel

Document Sample
Accounting for Construction Contract - Excel Powered By Docstoc
					Event 1 Office Connector                                                                                                                                                                                                             Page 1 of 1
6738442a-6729-4d20-9d05-640a587d3681.xls
                                                                                           Schedule Of Work In Process                                                                                                           Date: 7/15/2010
                                                                                                                                                                                                                                  Time: 7:26 PM


May of Year Ending 12/31/2001
Timberline Construction
C:\PROGRAM FILES\TIMBERLINE OFFICE\ACCOUNTING\CONSTRUCTION SAMPLE DATA


Jobs In-Progress
                                                  (A)                   (B)                (C)                  (D)                  (E)              (F)           (G)                 (H)                 (I)                  (J)
                                                                                                                                                  Percent Of    Percent Of
                                                                                       Percent Of                                                  Estimate      Contract                            Billings in excess   Cost in excess of
         Job             Description        Contract Amount        Billed To Date    Contract Billed       Total Estimate        Cost To Date        Spent        Earned          Earned Contract          of cost            billings
                                                                                        (B/A)                                                       (E/D)       ( Entered )           (GxA)                (B-H)              (H-B)


03-001         NW Food Warehouse            $   2,640,695.00   $        885,800.00           33.54% $         2,341,200.38   $       734,123.25        31.36%          31.36 $          828,034.89   $       57,765.11    $               -
03-002         Clackamas Office Park #4     $     884,410.20   $        122,000.00           14.21% $           827,931.61   $       134,025.24        16.19%          16.19 $          138,986.78   $              -     $       16,986.78
03-003         Fort Wayne Officer's Club    $     479,300.00   $         41,425.00               8.64% $        442,347.39   $        39,138.19         8.85%           8.85 $           42,407.70   $              -     $            982.70
03-004         Metro Bus Stop 47            $      18,000.00   $               -                 0.00% $         14,315.00   $              -           0.00%           0.00 $                 -     $              -     $               -
03-005         Metro Bus Stop 39            $      18,000.00   $               -                 0.00% $         14,315.00   $              -           0.00%           0.00 $                 -     $              -     $               -
03-006         PGE Line WO#345              $            -     $               -                 0.00% $               -     $        12,089.11         0.00%           0.00 $                 -     $              -     $               -
03-007         Low Income Housing           $            -     $               -                 0.00% $               -     $              -           0.00%           0.00 $                 -     $              -     $               -
03-008         Rose Garden Arena Rewiring   $            -     $               -                 0.00% $               -     $              -           0.00%           0.00 $                 -     $              -     $               -
03-009         OHSU Lighting Renovation     $     160,495.00   $               -                 0.00% $         53,600.00   $              -           0.00%           0.00 $                 -     $              -     $               -
03-010         Tri-Tech Fab Lab             $            -     $               -                 0.00% $               -     $              -           0.00%           0.00 $                 -     $              -     $               -
03-011         Cordova Middle School        $            -     $               -                 0.00% $               -     $              -           0.00%           0.00 $                 -     $              -     $               -
03-012         Tri Tech Lab                 $            -     $               -                 0.00% $               -     $              -           0.00%           0.00 $                 -     $              -     $               -
03-014         Downtown Supermarket         $            -     $               -                 0.00% $               -     $              -           0.00%           0.00 $                 -     $              -     $               -
03-015         Beaverton Office Park        $            -     $               -                 0.00% $        777,484.61   $              -           0.00%           0.00 $                 -     $              -     $               -

                           TOTALS           $   4,200,900.20   $      1,049,225.00       25.19%        $      4,471,193.99   $       919,375.79    20.56%        24.24%       $       1,009,429.37   $       57,765.11    $       17,969.48

				
DOCUMENT INFO
Description: Accounting for Construction Contract document sample