Lighting Reference Guide – Worksheets

16 Worksheets

Lighting Cost and Saving Analysis

a. An Audit Data Worksheet

Project Summary
Project:   Project Manager:                    
Site:   Project Engineer:                    
Report:   Lighting Specialist:                    
Total Area (sq.ft.):   Lighting Designer:                    
Date of Report:   Regional Office:                    
Rev.:      
Project No.:      
Building No.:      
COST AND SAVINGS ANALYSIS
Existing Electrical Use– (Base Year Electrical Data):
Annual Electrical Demand – Peak Average:   (kW)
Annual Electrical Consumption:   (kWh)
Annual Hours of Use (Average):   (hrs.)
Annual Electrical Cost:   ($/sq.ft.)
Electrical Rates Information
        Blended Rates      Summer Winter
Demand Charge (kW) – ($)      
Consumption Charge (kWh) – ($)      
Lighting Energy Savings Summary
  Demand
(kW)		 Electrical Consumption
(kW)		 Cost Cost/sq.ft
Current Usage 0.0 0 $0  
Proposed Retrofit 0.0 0 $0  
Savings  0.0 0 $0  
Lightning Cost and Savings Summary
Item Cost Cost/sq.ft.  
Outside Materials Cost $0   [Calculated + Adjustments]
Outside Labour Cost $0   [Calculated + Adjustments]
Total Outside Cost $0   [Sum Above 2]
Outside Service Markup (17.0%) $0   [Cost Multi. + % Noted – Calc. Cost/sq.ft.]
Rose Technology Labour (15%) $0   [Cost Multi. + % Noted – Calc. Cost/sq.ft.]
Subtotal $0   [Sum Above 3]
Guarantee (0.0%) $0   [Cost Multi. + % Noted – Calc. Cost/sq.ft.]
GRAND TOTAL – COSTS $0   [Sum Above 2]
Lamp & Ballast Savings $0   [User Entry + Calc. Cost/sq.ft.]
Utility Incentive $0   [User Entry + Calc. Cost/sq.ft.]
Annual Savings $0   [From Above + Calc. Cost/sq.ft.]
GRAND TOTAL – SAVINGS $0    
Simple Payback (years)     [Total Cost/Total Savings]
PROJECT NOTES
 
  1. Standard voltage (120 V) and lamps (34 W/40 W) existing. [User entry]
  2. Demand charge and consumption rate see chart below .[User entry]
  3. Handling of P.C.B. ballasts not included in project cost. [User entry]
  4. Asbestos content taken into account. [User entry]
  5. Highlighted areas represent altered design due to asbestos conditions. [User entry]
  6. [User entry]
  7. [User entry]

b. A Measures/Savings Worksheet

ENERGY BALANCE
  Existing Energy Balance  
  Demand
(kW)		 Electrical
Consumption (kWh)		 Cost Cost/sq.ft  
Lighting 0.0 0 $0   [As Above]
Plugload 0.0 0 $0   [User Entry]
Mech. Measures 0.0 0 $0   [User Entry]
TOTAL 0.0 0 $0    
PROJECT ADJUSTMENTS
Material
Adj.:		 (1) Lift/Scaffold: [Material Adj. Table] $0.00  
  (2) Trailer Storage: [Material Adj. Table] $0.00  
  (3) Disposal Bin: [Material Adj. Table] $0.00  
  (4) Travel: [Material Adj. Table] $0.00  
  (5) Electrical Inspection Cert.: [Material Adj. Table] $0.00  
  (6) Handling of PCB ballasts: [Material Adj. Table] $0.00  
  (7) Lamp Disposal: [Material Adj. Table] $0.00  
  (8)     $0.00  
    Material Adjustment Total: $0.00 [Sum Material Adj.]
Labour
Adj.:		 (1) Patching & Painting [Labour Adj. Table] $0.00  
  (2)     $0.00  
  (3)     $0.00  
    Labour Adjustment Total:   [Sum Material Adj.]

Previous Page | Table of Contents | Next Page