Contacting for Trash

Sheet1

Residential Sanitation Automation Worksheet
	YEAR 1	YEAR 2	YEAR 3	YEAR 4	YEAR 5
MANUAL SYSTEM
Labor Costs:
Inflation factor	1.00	1.05	1.10	1.16	1.22
# Routes	16	16	17	17	18
# Drivers	22	22	23	23	24
# Superviors	2.50	2.50	2.50	2.50	2.50
Labor Costs:	1,708,720	1,794,156	1,960,113	2,058,118	2,245,089
Workers' Comp.	32,400	34,020	37,345	39,212	42,963
Equipment Costs:
# Trucks Purchased	2	1	2	1	2
Cost (x inflator)	320,000	168,000	352,800	185,220	388,962
Vehicle O&M	434,000	455,700	508,390	533,810	593,471
Total Manual System
AUTOMATED SYSTEM
Labor Costs:
# Routes	13	13	14	14	14
# Drivers	18	18	19	19	19
# Superviors	3	3	3	3	3
Labor Costs:	1,432,080	1,503,684	1,655,117	1,737,873	1,824,767
Workers' Comp.	6,627	6,959	7,712	8,098	8,503
Total Automated System before Equipment
Equipment Costs:
# Trucks Purchased	16
Cost, new trucks	2,560,000
Salvage, manual trucks	-1000000
New Containers	2,468,571
Net equipment cost	4,028,571
lease/purchase cost	547,354	547,354	547,354	547,354	547,354
Total Automated System with new equipment
Annual Savings, automated system, before new equipment investment
Annual Savings
Cummulative Savings
Simple Payback Period
Net annual savings, including lease/purchase cost of new equipment	IGNORE This Pink Section of the Spreadsheet
Net annual savings
Discount factor
Discounted Savings
Net present value of savings
PV of manual system
PV of automated System
NPV of savings