General Roofing Disclaimer for a Business - Download as Excel by vmy19736

VIEWS: 23 PAGES: 3

More Info
									Event 1 Liberty Reports                                                                                           11/14/2010
for Sage Master Builder
                                              Job Cost Variance                                                     6:36 PM
                                                     Instructions

      Example Name                  Job Cost Variance by Cost Code.xlt

      Purpose                       This report provides a list of all cost codes used to-date for the selected job. For
                                    each cost code, the original budget, changes, total budget, actual cost, and
                                    variance amounts are shown as of the date specified.
                                    NOTE - This workbook has been converted to static values and contains no links to
                                    live data that can be refreshed.

      More Like This                For information about more templates like this one, contact us at:
                                    support@event1software.com

      Before You Start              Macros are presently enabled
                                    Some of the functionality of this workbook is provided by Excel macros. To learn
                                    more about macro security, click th following link.
                                    http://kb.event1software.com/questions/45

      Requirements                   Event 1 Liberty Reports for Sage Master Builder
                                     Sage Master Builder

      Using This Example            1.   Click the Reports worksheet
                                    2.   Type the desired job number in the Job Number cell
                                    3.   Type the desired date in the As Of Date cell
                                    4.   Click Refresh on the Liberty Reports toolbar.

                                    Not sure where to start? Use the "Sample Company" data folder provided with
                                    your Sage Master Builder software and use the "Sample Values" worksheet for
                                    guidance.

      Disclaimer                    This template is provided as an example. Use of it results in a live connection to
                                    your Sage Master Builder database. We suggest testing this template with your
                                    data before determining its suitability for your business needs. Your review
                                    process may need to involve your Sage Master Builder consultant and your
                                    representative for services pertaining to Event 1 Software products.


      About the Design              This report uses a single query to provide a list of the cost codes for the specified
                                    job. The query utilizes an SQL UNION statement with the DISTINCT keyword to
                                    assemble this list from three different tables. Columns adjacent to the query use
                                    Liberty Reports functions to retrieve the dollar amounts from the tables containing
                                    those values.


      Revision Number               Revision 1
                                    Tuesday, November 24, 2009 at 10:57 AM




C:\Docstoc\Working\pdf\d1a53481-b97d-4e06-8597-7971dfe6b904.xls                                                  Page 1 of 3
Event 1 Liberty Reports                                                                                            11/14/2010
for Sage Master Builder
                                              Job Cost Variance                                                      6:36 PM
                                                     by Cost Code

 Job Cost Variance
 Managed Rite Construction
 C:\MB7\Sample Company


 Job Number:    186                                       Williams Post Office                      999 555-2328
 As Of Date:    6/30/2007                                 19420 Williams Rd.

                                                          Monte Rio, CA 95462


                                             Original      Approved                                                Variance
  Cost Code                Description       Budget        Changes     Total Budget Cost To Date     Variance         %
         1000   GENERAL REQUIREMENTS         69,942.00            -       69,942.00   39,076.80       30,865.20         44%
         1020   Contingency                   3,500.00            -        3,500.00          -         3,500.00       100%
         1310   Permits                      10,311.00            -       10,311.00          -        10,311.00       100%
         1510   Temp. Utilities                 796.00            -          796.00       778.32          17.68          2%
         1520   Field Office & Sheds                -             -             -         215.00        (215.00)         0%
         1540   Mobilize & Demobilize         1,446.00            -        1,446.00       878.90         567.10         39%
         2000   SITE WORK                    56,985.00            -       56,985.00   56,985.00             -            0%
         2300   Excavation/Export/Fill        8,151.00            -        8,151.00    1,510.31        6,640.69         81%
         2450   Bike Path                           -             -             -            -              -            0%
         3000   CONCRETE                      3,381.00            -        3,381.00       680.00       2,701.00         80%
         3100   Foundation Formwork           7,695.00            -        7,695.00    6,214.46        1,480.54         19%
         3200   Foundation Reinforcement        417.00            -          417.00       455.72         (38.72)        -9%
         3300   Foundation Cast-in-Place      5,066.00            -        5,066.00    5,226.44         (160.44)        -3%
         3340   Slab Prep                    14,495.00            -       14,495.00    5,480.71        9,014.29         62%
         3350   Slab Cast-in-Place            7,644.00            -        7,644.00    8,697.82       (1,053.82)       -14%
         4000   MASONRY                      37,125.00            -       37,125.00   37,125.00             -            0%
         5100   Structural Steel             10,180.00            -       10,180.00   10,943.50         (763.50)        -8%
         6100   Rough Framing                39,339.00            -       39,339.00    8,669.14       30,669.86         78%
         6120   Wall Framing                  2,095.00            -        2,095.00    1,953.73          141.27          7%
         6130   Roof Framing                 11,088.00            -       11,088.00   12,019.71         (931.71)        -8%
         6190   Truss (Prefab)               15,070.00            -       15,070.00   16,200.27       (1,130.27)        -8%
         6200   Finish Carpentry              8,778.00            -        8,778.00    5,514.42        3,263.58         37%
         6400   Custom Casework                     -             -             -         732.54        (732.54)         0%
         6700   Rough Hardware                  655.00            -          655.00       713.01         (58.01)        -9%
         7000   THERMAL & MOISTURE               24.00            -           24.00        25.20          (1.20)        -5%
         7200   Insulation                    4,180.00            -        4,180.00          -         4,180.00       100%
         7300   Roofing                       9,850.00            -        9,850.00    9,850.00             -            0%
         8100   Metal Doors & Frames          7,507.00            -        7,507.00    5,090.14        2,416.86         32%
         8500   Windows                      19,821.00            -       19,821.00   19,821.00             -            0%
         9000   FINISHES                            -             -             -      9,309.00       (9,309.00)         0%
         9100   Stucco                       13,761.00        790.00      14,551.00   14,551.00             -            0%
         9250   Gypsum Board                  9,309.00            -        9,309.00          -         9,309.00       100%
         9300   Ceramic Tile                  1,745.00          50.00      1,795.00    1,795.00             -            0%
         9500   Acoustical Treatment          2,450.00            -        2,450.00    2,450.00             -            0%
         9900   Painting                      9,255.00            -        9,255.00    9,255.00             -            0%
        10300   Fireplaces & Stoves                 -             -             -      4,180.00       (4,180.00)         0%
        10800   Bath Accessories                733.00            -          733.00       187.68         545.32         74%
        15100   Plumbing                      5,063.00         (50.00)     5,013.00    5,013.00             -            0%
        15700   HVAC                         19,369.00            -       19,369.00   19,369.00             -            0%
        16000   ELECTRICAL                          -             -             -     37,928.00      (37,928.00)         0%
        16100   Electrical Wiring            50,416.00            -       50,416.00   13,368.35       37,047.65         73%

                Report Totals                467,642.00        790.00     468,432.00   372,263.17     96,168.83         21%




                                                       CONFIDENTIAL
C:\Docstoc\Working\pdf\d1a53481-b97d-4e06-8597-7971dfe6b904.xls                                                    Page 2 of 3
Event 1 Liberty Reports                                                       11/14/2010
for Sage Master Builder
                                       Job Cost Variance                         6:36 PM
                                             Sample Values

     Try this template using the "Sample Company" and the following values:


     Parameter Values

     Report
     Job Number           186
     As Of Date           6/30/2007




C:\Docstoc\Working\pdf\d1a53481-b97d-4e06-8597-7971dfe6b904.xls               Page 3 of 3

								
To top