Spreadsheet: darrell_schoolcraft__7561__2002 BLANCO HUB BUDGET
Sheet: 2002 HUB ATTCH#1A

TRANSWESTERN FIELD OPERATIONS
2002 BLANCO HUB BUDGET
 | ATTACHMENT #1A
SALARIES & WAGES:
SR. O&M TECHNICIAN |  |  |  |  | 39080 | (60% of Salary)
SR. O&M TECHNICIAN |  |  |  |  | 9069 | (15% of Salary)
SR. O&M TECHNICIAN |  |  |  |  | 9627 | (15% of Salary
ALBUQUERQUE REGION OFFICE |  |  |  |  | 4600 | (Support)
 |  | TOTAL PAYROLL |  |  |  | PNM (27.62%) |  | 17230
 |  |  |  |  |  | NWPL (36.19%) |  | 22573
 |  |  |  |  |  | TW (36.19%) |  | 22573
TAXES/BENEFITS:
 |  |  |  |  | 16049
 |  | TOTAL TX/BENE. |  |  |  | PNM (27.62%) |  | 4432
 |  |  |  |  |  | NWPL (36.19%) |  | 5808
 |  |  |  |  |  | TW (36.19%) |  | 5809
EMPLOYEE EXPENSES:
San Juan Team proposes to send Sr. O&M [NAME] to formal training in:
 | MTI Chromatograph |  |  |  | 2249
 | [NAME] RTU's |  |  |  | 3442
 |  | TOTAL EMP. EXP. |  |  |  | PNM (27.62%) |  | 1571
 |  |  |  |  |  | NWPL (36.19%) |  | 2060
 |  |  |  |  |  | TW (36.19%) |  | 2060
COMPANY EQUIPMENT USE:
Costs use the same percentage as for payroll and payroll related items.
SR. O&M TECHNICIAN |  |  |  |  | 3213
SR. O&M TECHNICIAN |  |  |  |  | 574
SR. O&M TECHNICIAN |  |  |  |  | 344
ALBUQUERQUE REGION OFFICE |  |  |  |  | 344
STATION |  |  |  |  | 115
 |  | TOTAL CO. EQUIP. USE |  |  |  | PNM (27.62%) |  | 1268
 |  |  |  |  |  | NWPL (36.19%) |  | 1661
 |  |  |  |  |  | TW (36.19%) |  | 1661
SUPPLIES & EXPENSES:
Allocations of expenses such as telephones, cellulars, office supplies, and [NAME].
supplies/expenses. Also direct charges include items such as calibration gas, heat
trace, calibration gas, bearings, regulators, shipping, etc.
 |  | TOTAL SUPP. & EXP. |  |  | 25556 | PNM (27.62%) |  | 7058
 |  |  |  |  |  | NWPL (36.19%) |  | 9249
 |  |  |  |  |  | TW (36.19%) |  | 9249
OUTSIDE SERVICES:
During the year, repairs will be needed on RTU's and analog modules. History shows
that at least one auto-adjust module will fail during year necessitating an overhaul. Also,
outside services will be used for other in-plant work such as relief valve testing, fire ext.
inspections/service, valve testing/servicing, etc.
 |  | TOTAL OUT. SERVICES |  |  | 18670 | PNM (27.62%) |  | 5157
 |  |  |  |  |  | NWPL (36.19%) |  | 6756
 |  |  |  |  |  | TW (36.19%) |  | 6757
RENTS:
Helium bottles are rented for the Bloomfield Hub. Estimated dollar needs for this
category are:
 |  | TOTAL RENTS |  |  | 1147 | PNM (27.62%) |  | 317
 |  |  |  |  |  | NWPL (36.19%) |  | 415
 |  |  |  |  |  | TW (36.19%) |  | 415
ELECTRIC POWER:
There is a considerable amount of quality control equipment, air conditioning and
heating for each of the buildings. The calibration gas and scrubbers are all heat trace.
Additionally, there is security lighting on all night.
 |  | TOTAL ELECTRICITY |  |  | 28688 | PNM (27.62%) |  | 7924
 |  |  |  |  |  | NWPL (36.19%) |  | 10382
 |  |  |  |  |  | TW (36.19%) |  | 10382
PC HARDWARE/SOFTWARE:
The Blanco Hub has 23 microprocessors that will require maintenance and updated
programming throughout the year. Estimated costs in this category are:
 |  | TOTAL PC HDWR/SFWR |  |  | 1147 | PNM (27.62%) |  | 317
 |  |  |  |  |  | NWPL (36.19%) |  | 415
 |  |  |  |  |  | TW (36.19%) |  | 415
TOTAL PROPOSED BUDGET |  |  |  |  |  | PNM (27.62%) |  | 45274
 |  |  |  |  |  | NWPL (36.19%) |  | 59320
 |  |  |  |  |  | TW (36.19%) |  | 59320
NOTE: DOES NOT INCLUDE 15% OPERATOR'S DIRECT EMPLOYEE LABOR COSTS
(OVERHEAD)