Landscaping Invoice Templates - Excel

Document Sample
Landscaping Invoice Templates - Excel Powered By Docstoc
					Timberline Construction                                                                                                                               Forecast Worksheet                                                                                      7/20/2010
\\Liberty\d\TSData\Sample Data\Construction Sample Data                                                                                                                                                                                                         9:44 AM
                                                                                                                                                                                                                                                             Page 1 of 7




JOB:            03-001                                                Project Manager:     Michael Perkins                      Schedule
                NW Food Warehouse                                          Misc Title 1:   John Erickson                                            Estimated            Revised              Actual
                3428 SW 185th Avenue                                       Misc Title 2:   Chris Anderson                       Start               02/01/2009                                01/13/2009
                                                                           Misc Title 3:   Peter Shell                          Completion          10/30/2009
                Beaverton, OR 97006                                        Misc Title 4:   Smith Lange Associates


Cost Code                                           Original             Approved               Total                                                 Balance To              JTD                *Cost To       *Cost To
& Category                                          Estimate             Changes              Estimate        Committed            Invoiced            Invoice                Cost               Complete       Complete       (Over)/Under       Comments
                Description                             A                   B                 C = A+ B           D                    E                   F                    G                    H           I=G+H                J



             1 GENERAL CONDITIONS

        1-040   COORDINATION
            L   Labor                                     41,739.17                    -         41,739.17                  -                   -                    -         11,148.60                    -     11,148.60        30,590.57
           LB   Labor Burden                              13,500.00                    -         13,500.00                  -                   -                    -          2,398.84                    -      2,398.84        11,101.16
            E   Equipment                                  1,895.41                    -          1,895.41                  -                   -                    -            819.90                    -        819.90         1,075.51
                COST CODE 1-040 TOTALS                    57,134.58                    -         57,134.58                  -                   -                    -         14,367.34                    -     14,367.34        42,767.24

        1-045 INSURANCE
            O Other                                        5,050.00                    -          5,050.00                  -                   -                    -             4,895.00                 -      4,895.00           155.00
              COST CODE 1-045 TOTALS                       5,050.00                    -          5,050.00                  -                   -                    -             4,895.00                 -      4,895.00           155.00

        1-065 PERMITS - GENERAL
            O Other                                       20,239.00                    -         20,239.00                  -                   -                    -         20,239.00                    -     20,239.00                   -
              COST CODE 1-065 TOTALS                      20,239.00                    -         20,239.00                  -                   -                    -         20,239.00                    -     20,239.00                   -

        1-510 TEMPORARY UTILITIES
            M Material                                     2,186.96                    -          2,186.96           2,235.50              600.00          1,635.50                  600.00                 -        600.00         1,586.96
            O Other                                       12,701.47                    -         12,701.47                  -                   -                 -                3,755.80                 -      3,755.80         8,945.67
              COST CODE 1-510 TOTALS                      14,888.43                    -         14,888.43           2,235.50              600.00          1,635.50                4,355.80                 -      4,355.80        10,532.63

        1-580   PROJECT IDENTIFICATION
            L   Labor                                        71.45                     -             71.45                 -                    -                    -              112.00                  -        112.00           (40.55)
           LB   Labor Burden                                 35.00                     -             35.00                 -                    -                    -                   -                  -             -             35.00
            M   Material                                     60.75                     -             60.75             60.75                60.75                    -               60.75                  -         60.75                 -
                COST CODE 1-580 TOTALS                      167.20                     -            167.20             60.75                60.75                    -              172.75                  -        172.75            (5.55)

        1-710   FINAL CLEANING
            L   Labor                                     26,909.33                    -         26,909.33                  -                   -                    -                    -                 -              -       26,909.33
           LB   Labor Burden                              12,500.00                    -         12,500.00                  -                   -                    -                    -                 -              -       12,500.00
            M   Material                                   1,688.82                    -          1,688.82                  -                   -                    -                    -                 -              -        1,688.82
                COST CODE 1-710 TOTALS                    41,098.15                    -         41,098.15                  -                   -                    -                    -                 -              -       41,098.15

                DIVISION 1 TOTALS                     138,577.36                       -        138,577.36           2,296.25              660.75          1,635.50            44,029.89                    -     44,029.89        94,547.47

             2 SITEWORK

        2-075 CONCRETE REMOVAL
            L Labor                                               -             480.00              480.00                  -                   -                    -                    -                 -              -          480.00
           LB Labor Burden                                        -             240.00              240.00                  -                   -                    -                    -                 -              -          240.00
              COST CODE 2-075 TOTALS                              -             720.00              720.00                  -                   -                    -                    -                 -              -          720.00

        2-140   DEWATERING
            L   Labor                                     20,929.33                    -         20,929.33                  -                 -                   -            20,842.64                    -     20,842.64             86.69
           LB   Labor Burden                              10,050.00                    -         10,050.00                  -                 -                   -            10,757.57                    -     10,757.57          (707.57)
            M   Material                                  26,165.60                    -         26,165.60          25,843.47         25,843.47                   -            26,558.47                    -     26,558.47          (392.87)
            E   Equipment                                 13,830.90                    -         13,830.90                  -                 -                   -            12,480.00                    -     12,480.00          1,350.90
           ER   Equipment - Rented                        28,500.00                    -         28,500.00          34,500.00         30,000.00            4,500.00            30,000.00                    -     30,000.00        (1,500.00)
                COST CODE 2-140 TOTALS                    99,475.83                    -         99,475.83          60,343.47         55,843.47            4,500.00           100,638.68                    -    100,638.68        (1,162.85)

        2-220   EXCAVATE & BACKFILL
            L   Labor                                  39,463.44              1,390.00           40,853.44                  -                 -                      -         41,654.86                    -     41,654.86          (801.42)
           LB   Labor Burden                           20,500.00                695.00           21,195.00                  -                 -                      -         21,726.34                    -     21,726.34          (531.34)
          OT    Overtime                                       -                     -                   -                  -                 -                      -          1,144.08                    -      1,144.08        (1,144.08)
            M   Material                                3,560.08                     -            3,560.08           5,938.35          5,938.35                      -          8,301.84                    -      8,301.84        (4,741.76)
            E   Equipment                              23,040.55              1,625.00           24,665.55                  -                 -                      -         27,040.00                    -     27,040.00        (2,374.45)
           ER   Equipment - Rented                     54,375.00                     -           54,375.00          54,375.00         54,300.00                  75.00         54,300.00                    -     54,300.00             75.00
                COST CODE 2-220 TOTALS                140,939.07              3,710.00          144,649.07          60,313.35         60,238.35                  75.00        154,167.12                    -    154,167.12        (9,518.05)




78900768-adeb-42da-93a5-322834a1902a.xls
Timberline Construction                                                                                                                                Forecast Worksheet                                                                                 7/20/2010
\\Liberty\d\TSData\Sample Data\Construction Sample Data                                                                                                                                                                                                     9:44 AM
                                                                                                                                                                                                                                                         Page 2 of 7




JOB:            03-001                                                Project Manager:     Michael Perkins                       Schedule
                NW Food Warehouse                                          Misc Title 1:   John Erickson                                             Estimated          Revised              Actual
                3428 SW 185th Avenue                                       Misc Title 2:   Chris Anderson                        Start               02/01/2009                              01/13/2009
                                                                           Misc Title 3:   Peter Shell                           Completion          10/30/2009
                Beaverton, OR 97006                                        Misc Title 4:   Smith Lange Associates


Cost Code                                           Original             Approved               Total                                                  Balance To            JTD                *Cost To       *Cost To
& Category                                          Estimate             Changes              Estimate        Committed             Invoiced            Invoice              Cost               Complete       Complete      (Over)/Under     Comments
                Description                             A                   B                 C = A+ B           D                     E                   F                  G                    H           I=G+H               J

        2-510   ASPHALT PAVING
            L   Labor                                      5,868.86                    -          5,868.86                   -                 -                   -           6,052.94                    -      6,052.94         (184.08)
           LB   Labor Burden                               3,000.00                    -          3,000.00                   -                 -                   -           3,121.96                    -      3,121.96         (121.96)
          OT    Overtime                                          -                    -                 -                   -                 -                   -             717.36                    -        717.36         (717.36)
            M   Material                                  72,598.46                    -         72,598.46           72,076.53         72,296.00            (219.47)          72,764.90                    -     72,764.90         (166.44)
            E   Equipment                                 17,535.70                    -         17,535.70                   -                 -                   -          16,640.00                    -     16,640.00           895.70
                COST CODE 2-510 TOTALS                    99,003.02                    -         99,003.02           72,076.53         72,296.00            (219.47)          99,297.16                    -     99,297.16         (294.14)

        2-520   CEMENT PAVING
            L   Labor                                      1,935.76                    -          1,935.76                   -                 -                   -              1,209.20                 -      1,209.20           726.56
           LB   Labor Burden                                 600.00                    -            600.00                   -                 -                   -                773.75                 -        773.75         (173.75)
          OT    Overtime                                          -                    -                 -                   -                 -                   -                625.56                 -        625.56         (625.56)
            M   Material                                   4,444.84                    -          4,444.84            4,826.56          5,106.56            (280.00)              5,106.56                 -      5,106.56         (661.72)
                COST CODE 2-520 TOTALS                     6,980.60                    -          6,980.60            4,826.56          5,106.56            (280.00)              7,715.07                 -      7,715.07         (734.47)

        2-900 LANDSCAPING
            S Subcontracts                                 3,250.00                    -          3,250.00            8,850.00          4,500.00            4,350.00              4,500.00                 -      4,500.00       (1,250.00)
              COST CODE 2-900 TOTALS                       3,250.00                    -          3,250.00            8,850.00          4,500.00            4,350.00              4,500.00                 -      4,500.00       (1,250.00)

                DIVISION 2 TOTALS                     349,648.52              4,430.00          354,078.52          206,409.91        197,984.38            8,425.53         366,318.03                    -    366,318.03      (12,239.51)

             3 CONCRETE

        3-110   STRUCTURAL FORMWORK
            L   Labor                                     11,676.18             320.00           11,996.18                   -                 -                    -          8,111.28                    -      8,111.28        3,884.90
           LB   Labor Burden                               4,050.00             160.00            4,210.00                   -                 -                    -          3,897.28                    -      3,897.28          312.72
          OT    Overtime                                          -                  -                   -                   -                 -                    -            726.10                    -        726.10        (726.10)
            M   Material                                   5,259.94                  -            5,259.94            2,259.60          2,259.60                    -          2,819.60                    -      2,819.60        2,440.34
                COST CODE 3-110 TOTALS                    20,986.12             480.00           21,466.12            2,259.60          2,259.60                    -         15,554.26                    -     15,554.26        5,911.86

        3-130   PERMANENT FORMS
            L   Labor                                      1,814.60                    -          1,814.60                  -                    -                  -             1,209.12                 -      1,209.12           605.48
           LB   Labor Burden                                 900.00                    -            900.00                  -                    -                  -               535.72                 -        535.72           364.28
            M   Material                                     296.25                    -            296.25             682.88               682.88                  -               682.88                 -        682.88         (386.63)
                COST CODE 3-130 TOTALS                     3,010.85                    -          3,010.85             682.88               682.88                  -             2,427.72                 -      2,427.72           583.13

        3-210   REINFORCING STEEL
            L   Labor                                      6,130.83             320.00            6,450.83                   -                 -                   -           3,947.68                    -      3,947.68        2,503.15
           LB   Labor Burden                               3,050.00             160.00            3,210.00                   -                 -                   -           2,164.79                    -      2,164.79        1,045.21
            M   Material                                  13,639.36             131.50           13,770.86           13,151.51         13,019.99              131.52          13,019.99                    -     13,019.99          750.87
                COST CODE 3-210 TOTALS                    22,820.19             611.50           23,431.69           13,151.51         13,019.99              131.52          19,132.46                    -     19,132.46        4,299.23

        3-220   WELDED WIRE FABRIC
            L   Labor                                     11,001.86                    -         11,001.86                   -                 -                    -          6,891.52                    -      6,891.52        4,110.34
           LB   Labor Burden                               5,500.00                    -          5,500.00                   -                 -                    -          3,761.90                    -      3,761.90        1,738.10
            M   Material                                   7,297.14                    -          7,297.14            7,456.05          7,456.05                    -          7,456.05                    -      7,456.05        (158.91)
                COST CODE 3-220 TOTALS                    23,799.00                    -         23,799.00            7,456.05          7,456.05                    -         18,109.47                    -     18,109.47        5,689.53

        3-250   CONCRETE ACCESSORIES
            L   Labor                                        728.43                    -            728.43                   -                   -                  -              270.72                  -        270.72          457.71
           LB   Labor Burden                                 360.00                    -            360.00                   -                   -                  -              133.27                  -        133.27          226.73
            M   Material                                     364.49                    -            364.49                   -                   -                  -                   -                  -             -          364.49
                COST CODE 3-250 TOTALS                     1,452.92                    -          1,452.92                   -                   -                  -              403.99                  -        403.99        1,048.93

        3-310   STRUCTURAL CONCRETE
            L   Labor                                  14,159.43                640.00           14,799.43                   -                 -                   -           7,544.76                    -      7,544.76         7,254.67
           LB   Labor Burden                            7,100.00                320.00            7,420.00                   -                 -                   -           4,171.54                    -      4,171.54         3,248.46
          OT    Overtime                                       -                     -                   -                   -                 -                   -           2,743.68                    -      2,743.68       (2,743.68)
            M   Material                              115,631.24              4,872.00          120,503.24          127,568.00        126,168.00            1,400.00         126,168.00                    -    126,168.00       (5,664.76)




78900768-adeb-42da-93a5-322834a1902a.xls
Timberline Construction                                                                                                                                Forecast Worksheet                                                                             7/20/2010
\\Liberty\d\TSData\Sample Data\Construction Sample Data                                                                                                                                                                                                 9:44 AM
                                                                                                                                                                                                                                                     Page 3 of 7




JOB:            03-001                                                Project Manager:     Michael Perkins                       Schedule
                NW Food Warehouse                                          Misc Title 1:   John Erickson                                             Estimated         Revised              Actual
                3428 SW 185th Avenue                                       Misc Title 2:   Chris Anderson                        Start               02/01/2009                             01/13/2009
                                                                           Misc Title 3:   Peter Shell                           Completion          10/30/2009
                Beaverton, OR 97006                                        Misc Title 4:   Smith Lange Associates


Cost Code                                           Original             Approved               Total                                                  Balance To            JTD               *Cost To       *Cost To
& Category                                          Estimate             Changes              Estimate        Committed             Invoiced            Invoice             Cost               Complete       Complete       (Over)/Under Comments
                Description                             A                   B                 C = A+ B            D                     E                  F                  G                   H           I=G+H                J
                COST CODE 3-310 TOTALS               136,890.67              5,832.00           142,722.67      127,568.00            126,168.00            1,400.00        140,627.98                    -     140,627.98         2,094.69

        3-345   CONCRETE FINISHING
            L   Labor                                     28,416.41             240.00           28,656.41                  -                    -                 -         17,556.45                    -      17,556.45      11,099.96
           LB   Labor Burden                              14,200.00             120.00           14,320.00                  -                    -                 -         10,999.67                    -      10,999.67        3,320.33
          OT    Overtime                                          -                  -                   -                  -                    -                 -          4,727.32                    -       4,727.32      (4,727.32)
            M   Material                                   2,506.02                  -            2,506.02             625.00               625.00                 -            625.00                    -         625.00        1,881.02
                COST CODE 3-345 TOTALS                    45,122.43             360.00           45,482.43             625.00               625.00                 -         33,908.44                    -      33,908.44      11,573.99

        3-470   TILT-UP PRECAST
            L   Labor                                     20,633.11                    -         20,633.11                   -                 -                   -         11,266.13                    -      11,266.13        9,366.98
           LB   Labor Burden                              10,300.00                    -         10,300.00                   -                 -                   -          5,472.72                    -       5,472.72        4,827.28
          OT    Overtime                                          -                    -                 -                   -                 -                   -            195.98                    -         195.98        (195.98)
            M   Material                                  30,420.49                    -         30,420.49           32,694.69          3,626.34           29,068.35          3,626.34                    -       3,626.34       26,794.15
            E   Equipment                                  3,120.00                    -          3,120.00                   -                 -                   -          3,900.00                    -       3,900.00        (780.00)
                COST CODE 3-470 TOTALS                    64,473.60                    -         64,473.60           32,694.69          3,626.34           29,068.35         24,461.17                    -      24,461.17       40,012.43

                DIVISION 3 TOTALS                     318,555.78              7,283.50          325,839.28          184,437.73        153,837.86           30,599.87        254,625.49                    -     254,625.49       71,213.79

             5 METALS

        5-210   STEEL JOISTS
            L   Labor                                  22,480.13                       -         22,480.13                   -                   -                 -         13,842.82                    -      13,842.82        8,637.31
           LB   Labor Burden                           11,250.00                       -         11,250.00                   -                   -                 -          6,523.53                    -       6,523.53        4,726.47
            M   Material                               88,571.83                       -         88,571.83           86,497.50                   -         86,497.50            277.65                    -         277.65       88,294.18
            E   Equipment                              10,400.00                       -         10,400.00                   -                   -                 -          7,800.00                    -       7,800.00        2,600.00
                COST CODE 5-210 TOTALS                132,701.96                       -        132,701.96           86,497.50                   -         86,497.50         28,444.00                    -      28,444.00      104,257.96

        5-310   STEEL DECKING
            L   Labor                                     11,430.51                    -         11,430.51                   -                   -                 -                    -                 -              -       11,430.51
           LB   Labor Burden                              11,215.00                    -         11,215.00                   -                   -                 -                    -                 -              -       11,215.00
            M   Material                                  53,458.99                    -         53,458.99           54,400.00                   -         54,400.00                    -                 -              -       53,458.99
                COST CODE 5-310 TOTALS                    76,104.50                    -         76,104.50           54,400.00                   -         54,400.00                    -                 -              -       76,104.50

        5-540   CASTINGS
            L   Labor                                        925.87                    -            925.87                   -                   -                 -                    -                 -              -          925.87
           LB   Labor Burden                                 460.00                    -            460.00                   -                   -                 -                    -                 -              -          460.00
            M   Material                                   1,574.60                    -          1,574.60            1,651.00                   -          1,651.00                    -                 -              -        1,574.60
                COST CODE 5-540 TOTALS                     2,960.47                    -          2,960.47            1,651.00                   -          1,651.00                    -                 -              -        2,960.47

                DIVISION 5 TOTALS                     211,766.93                       -        211,766.93          142,548.50                   -        142,548.50         28,444.00                    -      28,444.00      183,322.93

             6 WOOD & PLASTICS

        6-050 FASTENERS
            M Material                                      569.51                     -            569.51             578.10                    -            578.10                    -                 -              -         569.51
              COST CODE 6-050 TOTALS                        569.51                     -            569.51             578.10                    -            578.10                    -                 -              -         569.51

        6-110   WOOD FRAMING
            L   Labor                                     29,044.73             300.00           29,344.73                   -                   -                 -             5,835.68                 -       5,835.68       23,509.05
           LB   Labor Burden                              14,500.00             150.00           14,650.00                   -                   -                 -             2,759.28                 -       2,759.28       11,890.72
          OT    Overtime                                          -                  -                   -                   -                   -                 -               237.54                 -         237.54        (237.54)
            M   Material                                   8,793.42             370.50            9,163.92            9,569.26                   -          9,569.26                    -                 -              -        9,163.92
                COST CODE 6-110 TOTALS                    52,338.15             820.50           53,158.65            9,569.26                   -          9,569.26             8,832.50                 -       8,832.50       44,326.15

        6-120   STRUCTURAL PANELS
            L   Labor                                     44,143.45                    -         44,143.45                   -                   -                 -              785.00                  -        785.00        43,358.45
           LB   Labor Burden                              22,050.00                    -         22,050.00                   -                   -                 -              483.59                  -        483.59        21,566.41
          OT    Overtime                                          -                    -                 -                   -                   -                 -              353.25                  -        353.25         (353.25)
            M   Material                                  28,923.11                    -         28,923.11           27,200.00                   -         27,200.00                   -                  -             -        28,923.11




78900768-adeb-42da-93a5-322834a1902a.xls
Timberline Construction                                                                                                                             Forecast Worksheet                                                                            7/20/2010
\\Liberty\d\TSData\Sample Data\Construction Sample Data                                                                                                                                                                                             9:44 AM
                                                                                                                                                                                                                                                 Page 4 of 7




JOB:            03-001                                                Project Manager:     Michael Perkins                      Schedule
                NW Food Warehouse                                          Misc Title 1:   John Erickson                                          Estimated            Revised           Actual
                3428 SW 185th Avenue                                       Misc Title 2:   Chris Anderson                       Start             02/01/2009                             01/13/2009
                                                                           Misc Title 3:   Peter Shell                          Completion        10/30/2009
                Beaverton, OR 97006                                        Misc Title 4:   Smith Lange Associates


Cost Code                                           Original             Approved               Total                                               Balance To              JTD             *Cost To       *Cost To
& Category                                          Estimate             Changes              Estimate        Committed            Invoiced          Invoice                Cost            Complete       Complete      (Over)/Under Comments
                Description                             A                   B                 C = A+ B            D                   E                  F                   G                 H           I=G+H               J
                COST CODE 6-120 TOTALS                 95,116.56                       -         95,116.56       27,200.00                    -         27,200.00            1,621.84                  -      1,621.84       93,494.72

                DIVISION 6 TOTALS                     148,024.22                820.50          148,844.72          37,347.36                 -         37,347.36            10,454.34                 -     10,454.34      138,390.38

             7 THERMAL & MOISTURE PROTECTION

        7-190   VAPOR RETARDERS
            L   Labor                                      8,001.38                    -          8,001.38                 -                  -                    -                 -                 -             -        8,001.38
           LB   Labor Burden                               4,000.00                    -          4,000.00                 -                  -                    -                 -                 -             -        4,000.00
            M   Material                                   3,061.73                    -          3,061.73             53.00                  -                53.00                 -                 -             -        3,061.73
                COST CODE 7-190 TOTALS                    15,063.11                    -         15,063.11             53.00                  -                53.00                 -                 -             -       15,063.11

        7-210 BUILDING INSULATION
            M Material                                     1,063.11                    -          1,063.11           1,125.00                 -          1,125.00                    -                 -             -        1,063.11
              COST CODE 7-210 TOTALS                       1,063.11                    -          1,063.11           1,125.00                 -          1,125.00                    -                 -             -        1,063.11

        7-510   BUILT-UP BITUMINOUS ROOF
            L   Labor                                  56,263.39                       -         56,263.39                  -                 -                 -                    -                 -             -       56,263.39
           LB   Labor Burden                           28,150.00                       -         28,150.00                  -                 -                 -                    -                 -             -       28,150.00
            M   Material                               23,738.98                       -         23,738.98          23,500.00                 -         23,500.00                    -                 -             -       23,738.98
                COST CODE 7-510 TOTALS                108,152.37                       -        108,152.37          23,500.00                 -         23,500.00                    -                 -             -      108,152.37

        7-720 ROOF ACCESSORIES
            M Material                                            -             552.50              552.50            552.50                  -            552.50                    -                 -             -         552.50
              COST CODE 7-720 TOTALS                              -             552.50              552.50            552.50                  -            552.50                    -                 -             -         552.50

                DIVISION 7 TOTALS                     124,278.59                552.50          124,831.09          25,230.50                 -         25,230.50                    -                 -             -      124,831.09

             8 DOORS & WINDOWS

        8-210 WOOD DOORS
            M Material                                     1,120.00                    -          1,120.00           1,120.00                 -          1,120.00                    -                 -             -        1,120.00
              COST CODE 8-210 TOTALS                       1,120.00                    -          1,120.00           1,120.00                 -          1,120.00                    -                 -             -        1,120.00

        8-320 SECURITY DOORS
            M Material                                            -             450.00              450.00            450.00                  -            450.00                    -                 -             -         450.00
              COST CODE 8-320 TOTALS                              -             450.00              450.00            450.00                  -            450.00                    -                 -             -         450.00

        8-360   ROLLUP DOORS
            L   Labor                                        320.17             240.00              560.17                  -                 -                 -                    -                 -             -          560.17
           LB   Labor Burden                                 160.00             120.00              280.00                  -                 -                 -                    -                 -             -          280.00
            M   Material                                   9,000.00           2,300.00           11,300.00          11,500.00                 -         11,500.00                    -                 -             -       11,300.00
                COST CODE 8-360 TOTALS                     9,480.17           2,660.00           12,140.17          11,500.00                 -         11,500.00                    -                 -             -       12,140.17

        8-520   ALUMINUM WINDOWS
            L   Labor                                        475.38             180.00              655.38                  -                 -                 -                    -                 -             -          655.38
           LB   Labor Burden                                 235.00              90.00              325.00                  -                 -                 -                    -                 -             -          325.00
            M   Material                                   3,923.13           1,161.00            5,084.13           5,031.00                 -          5,031.00                    -                 -             -        5,084.13
                COST CODE 8-520 TOTALS                     4,633.51           1,431.00            6,064.51           5,031.00                 -          5,031.00                    -                 -             -        6,064.51

                DIVISION 8 TOTALS                         15,233.68           4,541.00           19,774.68          18,101.00                 -         18,101.00                    -                 -             -       19,774.68

             9 FINISHES

        9-250   DRYWALL
            L   Labor                                      1,640.22           1,000.00            2,640.22                  -                 -                 -                    -                 -             -        2,640.22
           LB   Labor Burden                               1,320.00             500.00            1,820.00                  -                 -                 -                    -                 -             -        1,820.00
            M   Material                                   1,016.93             775.00            1,791.93           1,810.50                 -          1,810.50                    -                 -             -        1,791.93
                COST CODE 9-250 TOTALS                     3,977.15           2,275.00            6,252.15           1,810.50                 -          1,810.50                    -                 -             -        6,252.15




78900768-adeb-42da-93a5-322834a1902a.xls
Timberline Construction                                                                                                                              Forecast Worksheet                                                                            7/20/2010
\\Liberty\d\TSData\Sample Data\Construction Sample Data                                                                                                                                                                                              9:44 AM
                                                                                                                                                                                                                                                  Page 5 of 7




JOB:            03-001                                                Project Manager:     Michael Perkins                       Schedule
                NW Food Warehouse                                          Misc Title 1:   John Erickson                                           Estimated          Revised         Actual
                3428 SW 185th Avenue                                       Misc Title 2:   Chris Anderson                        Start             02/01/2009                         01/13/2009
                                                                           Misc Title 3:   Peter Shell                           Completion        10/30/2009
                Beaverton, OR 97006                                        Misc Title 4:   Smith Lange Associates


Cost Code                                           Original             Approved               Total                                                Balance To            JTD           *Cost To       *Cost To
& Category                                          Estimate             Changes              Estimate        Committed             Invoiced          Invoice              Cost          Complete       Complete       (Over)/Under    Comments
                Description                             A                   B                 C = A+ B           D                     E                 F                  G               H           I=G+H                J
        9-510   ACOUSTICAL CEILINGS
            L   Labor                                        670.99                    -            670.99                   -                 -                 -                -                 -              -          670.99
           LB   Labor Burden                                 335.00                    -            335.00                   -                 -                 -                -                 -              -          335.00
            M   Material                                   2,849.66                    -          2,849.66            2,950.00                 -          2,950.00                -                 -              -        2,849.66
                COST CODE 9-510 TOTALS                     3,855.65                    -          3,855.65            2,950.00                 -          2,950.00                -                 -              -        3,855.65

        9-660 RESILIENT TILE FLOOR
            S Subcontracts                            134,507.51                       -        134,507.51          134,400.00                 -        134,400.00                -                 -              -      134,507.51
              COST CODE 9-660 TOTALS                  134,507.51                       -        134,507.51          134,400.00                 -        134,400.00                -                 -              -      134,507.51

        9-910 PAINTING - EXTERIOR
            S Subcontracts                                 4,500.00                    -          4,500.00            4,320.00                 -          4,320.00                -                 -              -        4,500.00
              COST CODE 9-910 TOTALS                       4,500.00                    -          4,500.00            4,320.00                 -          4,320.00                -                 -              -        4,500.00

        9-920 PAINTING - INTERIOR
            S Subcontracts                                  750.00              215.00              965.00             600.00                  -            600.00                -                 -              -          965.00
              COST CODE 9-920 TOTALS                        750.00              215.00              965.00             600.00                  -            600.00                -                 -              -          965.00

                DIVISION 9 TOTALS                     147,590.31              2,490.00          150,080.31          144,080.50                 -        144,080.50                -                 -              -      150,080.31

            10 SPECIALTIES

      10-160    TOILET PART. METAL
           L    Labor                                        244.27                    -            244.27                   -                 -                 -                -                 -              -          244.27
          LB    Labor Burden                                 120.00                    -            120.00                   -                 -                 -                -                 -              -          120.00
           M    Material                                   2,401.92                    -          2,401.92            2,400.00                 -          2,400.00                -                 -              -        2,401.92
                COST CODE 10-160 TOTALS                    2,766.19                    -          2,766.19            2,400.00                 -          2,400.00                -                 -              -        2,766.19

      10-430    EXTERIOR SIGNS
           L    Labor                                          7.51                    -              7.51                   -                 -                 -                -                 -              -            7.51
           M    Material                                     162.13                    -            162.13                   -                 -                 -                -                 -              -          162.13
           S    Subcontracts                              30,023.99                    -         30,023.99           30,000.00                 -         30,000.00                -                 -              -       30,023.99
                COST CODE 10-430 TOTALS                   30,193.63                    -         30,193.63           30,000.00                 -         30,000.00                -                 -              -       30,193.63

      10-500    LOCKERS
           L    Labor                                        50.92                     -             50.92                  -                  -                 -                -                 -              -           50.92
          LB    Labor Burden                                 25.00                     -             25.00                  -                  -                 -                -                 -              -           25.00
           M    Material                                    433.63                     -            433.63             433.40                  -            433.40                -                 -              -          433.63
                COST CODE 10-500 TOTALS                     509.55                     -            509.55             433.40                  -            433.40                -                 -              -          509.55

      10-522    FIRE EXT. PORTABLE
           L    Labor                                        150.12                    -            150.12                   -                 -                  -               -                 -              -          150.12
          LB    Labor Burden                                  75.00                    -             75.00                   -                 -                  -               -                 -              -           75.00
           M    Material                                   1,281.02                    -          1,281.02                   -                 -                  -               -                 -              -        1,281.02
                COST CODE 10-522 TOTALS                    1,506.14                    -          1,506.14                   -                 -                  -               -                 -              -        1,506.14

      10-551    MAIL CHUTES
           L    Labor                                        120.10                    -            120.10                   -                 -                  -               -                 -              -          120.10
          LB    Labor Burden                                  60.00                    -             60.00                   -                 -                  -               -                 -              -           60.00
           M    Material                                   1,025.82                    -          1,025.82                   -                 -                  -               -                 -              -        1,025.82
                COST CODE 10-551 TOTALS                    1,205.92                    -          1,205.92                   -                 -                  -               -                 -              -        1,205.92

      10-605    WIRE MESH PARTITIONS
           L    Labor                                       120.10                     -            120.10                   -                 -                  -               -                 -              -          120.10
          LB    Labor Burden                                 60.00                     -             60.00                   -                 -                  -               -                 -              -           60.00
           M    Material                                    400.32                     -            400.32                   -                 -                  -               -                 -              -          400.32
                COST CODE 10-605 TOTALS                     580.42                     -            580.42                   -                 -                  -               -                 -              -          580.42

      10-670 STORAGE SHELVING
           L Labor                                         7,619.82             120.00            7,739.82                   -                 -                  -               -                 -              -        7,739.82




78900768-adeb-42da-93a5-322834a1902a.xls
Timberline Construction                                                                                                                              Forecast Worksheet                                                                             7/20/2010
\\Liberty\d\TSData\Sample Data\Construction Sample Data                                                                                                                                                                                               9:44 AM
                                                                                                                                                                                                                                                   Page 6 of 7




JOB:            03-001                                                Project Manager:     Michael Perkins                       Schedule
                NW Food Warehouse                                          Misc Title 1:   John Erickson                                           Estimated         Revised              Actual
                3428 SW 185th Avenue                                       Misc Title 2:   Chris Anderson                        Start             02/01/2009                             01/13/2009
                                                                           Misc Title 3:   Peter Shell                           Completion        10/30/2009
                Beaverton, OR 97006                                        Misc Title 4:   Smith Lange Associates


Cost Code                                           Original             Approved               Total                                                Balance To           JTD                *Cost To       *Cost To
& Category                                          Estimate             Changes              Estimate        Committed             Invoiced          Invoice             Cost               Complete       Complete       (Over)/Under Comments
              Description                               A                   B                 C = A+ B           D                     E                 F                 G                    H           I=G+H                J
           LB Labor Burden                              3,800.00               60.00              3,860.00                  -                  -                 -                    -                 -              -         3,860.00
            M Material                                  9,807.83              680.00             10,487.83             687.50                  -            687.50                    -                 -              -       10,487.83
              COST CODE 10-670 TOTALS                  21,227.65              860.00             22,087.65             687.50                  -            687.50                    -                 -              -       22,087.65

      10-800    TOILET & BATH ACCESS.
           L    Labor                                        99.45                     -             99.45                  -                  -                 -                    -                 -              -          99.45
          LB    Labor Burden                                 50.00                     -             50.00                  -                  -                 -                    -                 -              -          50.00
           M    Material                                    840.57                     -            840.57             840.00                  -            840.00                    -                 -              -         840.57
                COST CODE 10-800 TOTALS                     990.02                     -            990.02             840.00                  -            840.00                    -                 -              -         990.02

                DIVISION 10 TOTALS                        58,979.52             860.00           59,839.52           34,360.90                 -         34,360.90                    -                 -              -       59,839.52

            11 EQUIPMENT

      11-405    FOOD STORAGE EQUIP
           L    Labor                                  41,520.06              1,800.00           43,320.06                   -                 -                 -                    -                 -              -       43,320.06
          LB    Labor Burden                           20,750.00                900.00           21,650.00                   -                 -                 -                    -                 -              -       21,650.00
           M    Material                              208,525.41             52,450.00          260,975.41          260,703.00                 -        260,703.00                    -                 -              -      260,975.41
                COST CODE 11-405 TOTALS               270,795.47             55,150.00          325,945.47          260,703.00                 -        260,703.00                    -                 -              -      325,945.47

                DIVISION 11 TOTALS                    270,795.47             55,150.00          325,945.47          260,703.00                 -        260,703.00                    -                 -              -      325,945.47

            15 MECHANICAL

      15-300 FIRE PROTECTION
           S Subcontracts                                 54,673.97             750.00           55,423.97           55,350.00                 -         55,350.00                    -                 -              -       55,423.97
             COST CODE 15-300 TOTALS                      54,673.97             750.00           55,423.97           55,350.00                 -         55,350.00                    -                 -              -       55,423.97

      15-400 PLUMBING
           S Subcontracts                                 88,085.84                    -         88,085.84           85,515.44         22,001.50         63,513.94         22,001.50                    -     22,001.50        66,084.34
             COST CODE 15-400 TOTALS                      88,085.84                    -         88,085.84           85,515.44         22,001.50         63,513.94         22,001.50                    -     22,001.50        66,084.34

      15-500 HVAC
           S Subcontracts                             177,204.42                800.00          178,004.42          177,865.00                 -        177,865.00                    -                 -              -      178,004.42
             COST CODE 15-500 TOTALS                  177,204.42                800.00          178,004.42          177,865.00                 -        177,865.00                    -                 -              -      178,004.42

      15-650 REFRIGERATION
           S Subcontracts                                 76,422.07                    -         76,422.07           76,360.00                 -         76,360.00                    -                 -              -       76,422.07
             COST CODE 15-650 TOTALS                      76,422.07                    -         76,422.07           76,360.00                 -         76,360.00                    -                 -              -       76,422.07

                DIVISION 15 TOTALS                    396,386.30              1,550.00          397,936.30          395,090.44         22,001.50        373,088.94         22,001.50                    -     22,001.50       375,934.80

            16 ELECTRICAL

      16-100 ELECTRICAL SUB
           S Subcontracts                                 82,436.20           1,250.00           83,686.20           82,250.00          8,250.00         74,000.00             8,250.00                 -      8,250.00        75,436.20
             COST CODE 16-100 TOTALS                      82,436.20           1,250.00           83,686.20           82,250.00          8,250.00         74,000.00             8,250.00                 -      8,250.00        75,436.20

                DIVISION 16 TOTALS                        82,436.20           1,250.00           83,686.20           82,250.00          8,250.00         74,000.00             8,250.00                 -      8,250.00        75,436.20

                JOB 03-001 TOTALS                   2,262,272.88             78,927.50        2,341,200.38     1,532,856.09           382,734.49      1,150,121.60        734,123.25                    -    734,123.25     1,607,077.13

                Labor Totals                          681,066.76             10,545.00          691,611.76                   -                 -                 -        249,434.02                    -    249,434.02       442,177.74
                Material Totals                       738,664.09             63,742.50          802,406.59          788,470.65        263,682.99        524,787.66        268,068.03                    -    268,068.03       534,338.56
                Subcontract Totals                    651,854.00              3,015.00          654,869.00          655,510.44         34,751.50        620,758.94         34,751.50                    -     34,751.50       620,117.50
                Equipment Totals                      152,697.56              1,625.00          154,322.56           88,875.00         84,300.00          4,575.00        152,979.90                    -    152,979.90         1,342.66
                Other Totals                           37,990.47                     -           37,990.47                   -                 -                 -         28,889.80                    -     28,889.80         9,100.67

                JOB 03-001 TOTALS                   2,262,272.88             78,927.50        2,341,200.38     1,532,856.09           382,734.49      1,150,121.60        734,123.25                    -    734,123.25     1,607,077.13




78900768-adeb-42da-93a5-322834a1902a.xls
Timberline Construction                                                                                                                       Forecast Worksheet                                                              7/20/2010
\\Liberty\d\TSData\Sample Data\Construction Sample Data                                                                                                                                                                         9:44 AM
                                                                                                                                                                                                                             Page 7 of 7




JOB:            03-001                                                    Project Manager:     Michael Perkins                Schedule
                NW Food Warehouse                                              Misc Title 1:   John Erickson                                Estimated      Revised        Actual
                3428 SW 185th Avenue                                           Misc Title 2:   Chris Anderson                 Start         02/01/2009                    01/13/2009
                                                                               Misc Title 3:   Peter Shell                    Completion    10/30/2009
                Beaverton, OR 97006                                            Misc Title 4:   Smith Lange Associates


Cost Code                                                  Original          Approved               Total                                     Balance To           JTD       *Cost To   *Cost To
& Category                                                 Estimate          Changes              Estimate        Committed      Invoiced      Invoice             Cost      Complete   Complete   (Over)/Under   Comments
                Description                                    A                B                 C = A+ B           D              E             F                 G           H       I=G+H            J

                CONTRACT SUMMARY                               Contract           Estimate               Profit               Notes
                                                Original   2,489,500.00       2,262,272.88          227,227.12
                                       Pending Changes        23,680.00          16,110.00            7,570.00
                                      Approved Changes       151,195.00          78,927.50           72,267.50
                                                Revised    2,640,695.00       2,341,200.38          299,494.62

                COST SUMMARY
                                               JTD Cost     734,123.25
                                       Cost To Complete              -
                                          Projected Cost    734,123.25

                Projected Profit                           1,906,571.75               As of August 27, 2009




78900768-adeb-42da-93a5-322834a1902a.xls

				
DOCUMENT INFO
Description: Landscaping Invoice Templates document sample