Attachment D: Spreadsheet Format for Operating Costs of 2937 Acts Units

---

Overview

Enter FY Costs
Enter Monthly Utility Costs

---

Sheet 1: Enter FY Costs

Indian Housing Operating Cost Study
Attachment D: Spreadsheet Format for Operating Costs of 1937 Act Units
FISCAL YEAR:
TRIBE:			# of units	________LR	_______MH
Note: Indicate the number of LR and MH that were operated at the beginning of the fiscal year.
Insert lines in this spreadsheet if that makes entering expenses easier. For example, you could insert a line for each trip that occurred and enter costs from travel vouchers, or you could take the total for Administrative Travel from existing records an
			Enter the Fiscal Year 2002				Estimated
			total annual cost
			all units	LR	MH				Comments
Administration
	Administrative Employee Costs
	Administrative Salaries
	Administrative Benefits
	Legal Expenses
	Training
	Travel
	Accounting/Auditing Fees
	Office Rent
	Sundry
	Telephone/Pagers
	Computers
	Shipping
	Materials and Supplies
	All Other Administrative
	Outside Management Fees
	Capital Expenditure
TOTAL Administrative Expenses
Tenant Services/ Housing Services
	Employee Costs
	Salaries
	Benefits
	Training
	Travel
	Supplies and Materials
	Other
	Telephone/Pagers
	Shipping
	All Other Tenant Services
	Capital Expenditure
TOTAL Tenant Services/ Housing Services
Utilities
	Water (& Sewer)
	Office
	Resident
	Electricity
	Office
	Resident
	Gas
	Office
	Resident
	Fuel
	Office
	Resident
	Labor
	Other Utilities Expenses
	Office
	Resident
TOTAL Utilities
TRIBE:			# of units	________LR	_______MH
Note: Indicate the number of LR and MH that were operated at the beginning of the fiscal year.
Insert lines in this spreadsheet if that makes entering expenses easier. For example, you could insert a line for each trip that occurred and enter costs from travel vouchers, or you could take the total for Administrative Travel from existing records an
			Enter the Fiscal Year 2002				Estimated
			total annual cost
			all units	LR	MH				Comments
Ordinary Maintenance and Operation
	Employee Costs
	Salaries
	Benefits
	Training
	Travel
	Materials
	Contract Costs
	Garbage & Trash Removal
	Yard Maintenance
	Snow removal
	Mowing and Others
	Capital expenditure
	Rent
	Other
	Telephone/Pagers
	Shipping
	All Other Maintenance and Operation
TOTAL Maintenance and Operation
General Expenses
	Insurance
	Payments
	PILOT
	Other, including payments to Tribes
	Protective Services
TOTAL General Expenses
TOTAL ROUTINE OPERATING EXPENSES
Modernization
	Employee Costs
	Salaries
	Benefits
	Training
	Travel
	Materials
	Contract Costs
	Capital expenditure
	Other
TOTAL Modernization
TOTAL EXPENDITURES INCLUDING MODERNIZATION

---

Sheet 2: Enter Monthly Utility Costs

Indian Housing Operating Cost Study
Attachment D: Spreadsheet Format for Operating Costs of 1937 Act Units
Note: Enter energy use and cost for 1937 Act residential units seperately from all Tribe/TDHE spaces or public outdoor spaces. Insert lines in this spreadsheet if that makes entering expenses easier. For example, if you have two electrical companies, you might insert rows for each company.
Fiscal Year:				Enter the Usage and Cost
Energy Costs for 1937 Units			of All Energy by Month
			Amount	Cost	Rate				Comments
Electricity
	Office, Street Lights, other TDHE		Kilowatt Hours	$ Cost	Rate
	January
	February
	March
	April
	May
	June
	July
	August
	September
	October
	November
	December
	1937 Act Residential Unit		Kilowatt Hours	$ Cost	Rate
	January
	February
	March
	April
	May
	June
	July
	August
	September
	October
	November
	December
Natural Gas
	Office & other TDHE buildings		Therms-MCF	$ Cost	Rate
	January
	February
	March
	April
	May
	June
	July
	August
	September
	October
	November
	December
	1937 Act Residential Units		Therms-MCF	$ Cost	Rate
	January
	February
	March
	April
	May
	June
	July
	August
	September
	October
	November
	December
Propane
	Office & other TDHE buildings		Therms-MCF	$ Cost	Rate
	January
	February
	March
	April
	May
	June
	July
	August
	September
	October
	November
	December
	1937 Act Residential Units		Therms-MCF	$ Cost	Rate
	January
	February
	March
	April
	May
	June
	July
	August
	September
	October
	November
	December
Fuel Oil
	Office & other TDHE buildings		Gallons	$ Cost	Rate
	January
	February
	March
	April
	May
	June
	July
	August
	September
	October
	November
	December
	1937 Act Residential Units		Therms-MCF	$ Cost	Rate
	January
	February
	March
	April
	May
	June
	July
	August
	September
	October
	November
	December