cost/benefit analysis

profilelauren II
tbo_template_gebre.xltm
Home>Business & Finance homework help>cost/benefit analysis

INSTRUCTIONS

Instructions for Using the Worksheets in this Spreadsheet
THIS PAGE WILL BE BUILT AND UPDATED BY STUDENTS OVER THE COURSE OF MULTIPLE ASSIGNMENTS
I

COSTS

Total Cost of Ownership Worksheet
___ White cells are for user input
Gold cells are calculated. Do NOT unintentionally overwrite the formulas.
Proposed IT Solution Name: SMART ESTIMATES SOLUTION Gray cells are column and row headers and are locked
Prepared by: Black cells indicate they are not applicable to the row and column
Use the + and - signs in the left margin to expand and contract categories. It is not recommended that categories be deleted. Click on any row or column header to see its definition It is assumed that licensing costs are constant for every year.
VARIABLE NAMES FOR FORMULAS ☛ Name UnitOfMeasure Quantity UnitCost ExtendedCost OtherCost Timing_1 Timing_2 LoadingRate Licensing Funded FundingSource Sunk Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Recurs? subsidized ERROR:#REF! Year 2 Year 5 Year 6 recharged ERROR:#REF! Year 2 Year 5 Year 6 tab/requested ERROR:#REF! Year 2 Year 5 Year 6
(also, v Year 1 = Lifetime Stage >
ESTIMATED INFRASTRUCTURE COSTS SOURCE OF INFORMATION UNIT OF MEASURE QUANTITY NEEDED COST PER UNIT EXTENDED COST ANY OTHER ONE-TIME COSTS PURCHASE YEAR RECURRING MAINTENANCE START YEAR RECURRING MAINTENANCE ANNUAL RATE LICENSE COST FUNDING REQUIRED? FUNDING SOURCE SUNK COST (already spent) YEAR 6 RECURS?
SERVERS
PRODUCTION SERVERS (may be virtualized) ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
Application Servers per server $0 $0 $0
Jeffrey Whitten: Jeffrey Whitten: Years 2-4 of maintenance were built into purchase price 		$0
Jeffrey Whitten: Jeffrey Whitten: Years 2-4 of maintenance were built into purchase price 		$0
Jeffrey Whitten: Jeffrey Whitten: Years 2-4 of maintenance were built into purchase price 		$0
Jeffrey Whitten: Jeffrey Whitten: Years 2-4 of maintenance were built into purchase price 		$0
Jeffrey Whitten: Jeffrey Whitten: Years 2-4 of maintenance were built into purchase price
Web Servers per server $0 $0 $0 $0 $0 $0 $0
Database Servers per server $0 $0 $0 $0 $0 $0 $0
Message Servers per server $0 $0 $0 $0 $0 $0 $0
File Servers per server $0 $0 $0 $0 $0 $0 $0
Print Servers per server $0 $0 $0 $0 $0 $0 $0
(select row to insert additional throws here as needed) per server $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
NON-PRODUCTION SERVERS (may be virtualized)
Application Servers per server $0 $0 $0 $0 $0 $0 $0
Web Servers per server $0 $0 $0 $0 $0 $0 $0
Database Servers per server $0 $0 $0 $0 $0 $0 $0
Message Servers per server $0 $0 $0 $0 $0 $0 $0
File Servers per server $0 $0 $0 $0 $0 $0 $0
Print Servers per server $0 $0 $0 $0 $0 $0 $0
(select row to insert additional throws here as needed) per server $0 $0 $0 $0 $0 $0 $0
UPGRADES TO EXISTING SERVERS
{specify type of upgrade) per component $0 $0 $0 $0 $0 $0 $0
{specify type of upgrade) per component $0 $0 $0 $0 $0 $0 $0
{specify type of upgrade) per component $0 $0 $0 $0 $0 $0 $0
(select row to insert additional throws here as needed) per component $0 $0 $0 $0 $0 $0 $0
CLIENTS
END USER COMPUTERS OR DEVICES ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{item} per computer $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{item} per computer $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(select row and insert additional throws here as needed) per computer $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
UPGRADES TO END USER COMPUTERS
{item} per component $0 $0 $0 $0 $0 $0 $0
{item} per component $0 $0 $0 $0 $0 $0 $0
(select row and insert additional throws here as needed) per component $0 $0 $0 $0 $0 $0 $0
PROJECT TEAM COMPUTERS AND DEVICES ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{item} per computer $0 $0 $0 $0 $0 $0 $0
{item} per computer $0 $0 $0 $0 $0 $0 $0
(select row and insert additional throws here as needed) per computer $0 $0 $0 $0 $0 $0 $0
UPGRADES TO PROJECT TEAM COMPUTERS
{item} per component $0 $0 $0 $0 $0 $0 $0
{item} per component $0 $0 $0 $0 $0 $0 $0
(select row and insert additional throws here as needed) per component $0 $0 $0 $0 $0 $0 $0
PERIPHERALS
John McElduff: Include all such costs and recurring costs for hardware specifically purchased for the project
{item} per device $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{item} per device $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(select row and insert additional throws here as needed) per device $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
NETWORK HARDWARE
{item} per component $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{item} per component $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(select row and insert additional throws here as needed) per component $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
EMBEDDED DEVICES
{item} per device $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{item} per device $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(select row and insert additional throws here as needed) per device $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
OTHER
{item} per item $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{item} per item $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(select row and insert additional throws here as needed) per item $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
TOTAL INFRASTRUCTURE COST $0 $0 $0 $0 $0 $0
ESTIMATED SOFTWARE COSTS SOURCE OF INFORMATION UNIT OF MEASURE QUANTITY NEEDED COST PER UNIT EXTENDED COST ANY OTHER ONE-TIME COSTS PURCHASE OR START YEAR RECURRING MAINTENANCE START YEAR RECURRING MAINTENANCE RATE LICENSE COST FUNDING REQUIRED? FUNDING SOURCE SUNK COST (already spent) YEAR 6 RECURS?
SYSTEM SOFTWARE
Upgrade Windows Server license 0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{software item #n} license 0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(select row and insert additional throws here as needed) license 0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
APPLICATION SOFTWARE
{software item #1} license 0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{software item #n} license 0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(select row and insert additional throws here as needed) license 0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
IMPLEMENTATION TOOLS
{software item #n} license 0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{software item #n} license 0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(select row and insert additional throws here as needed) license 0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
NETWORK SOFTWARE
{software item #1} license 0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{software item #n} license 0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(select row and insert additional throws here as needed) license 0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
TOTAL SOFTWARE COST $0 $0 $0 $0 $0 $0
ESTIMATED EXTERNAL SERVICES COSTS SOURCE OF INFORMATION UNIT OF MEASURE QUANTITY NEEDED COST PER UNIT EXTENDED COST ANY OTHER ONE-TIME COSTS START YEAR FOR ENGAGEMENT END YEAR FOR ENGAGEMENT ESTIMATED EXPENSES RATE LICENSE COST FUNDING REQUIRED? FUNDING SOURCE SUNK COST (already spent) YEAR 6 RECURS?
IMPLEMENTATION CONSULTANTS
(external service #1} hours $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(external service #n} hours $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(select row and insert additional throws here as needed) hours $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
IMPLEMENTATION CONTRACTORS
(external service #1} hours $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(external service #n} hours $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(select row and insert additional throws here as needed) hours $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
TRAINERS FOR IMPLEMENTATION
(external service #1} hours $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(external service #n} hours $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(select row and insert additional throws here as needed) hours $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
POST-IMPLEMENTATION SERVICES
(external service #1} per service $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(external service #n} per service $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(select row and insert additional throws here as needed) per service $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
ESTIMATED INTERNAL IT SERVICES COSTS SOURCE OF INFORMATION UNIT OF MEASURE QUANTITY NEEDED COST PER UNIT EXTENDED COST ANY OTHER ONE-TIME COSTS START YEAR FOR SERVICE END YEAR FOR SERVICE OTHER RECURRING COSTS LICENSE COST FUNDING REQUIRED? ABSORBED OR RECHARGED? SUNK COST (already spent) YEAR 6 RECURS?
PROJECT MANAGEMENT
(internal service #1} per service $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(internal service #n} per service $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(select row and insert additional throws here as needed) per service $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
SOFTWARE DEVELOPMENT
(internal service #1} per service $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(internal service #n} per service $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(select row and insert additional throws here as needed) per service $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
INFRASTRUCTURE SERVICES
(internal service #1} per service $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(internal service #n} per service $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(select row and insert additional throws here as needed) per service $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
SYSTEMS ADMINISTRATION
(internal service #1} per service $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(internal service #n} per service $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(select row and insert additional throws here as needed) per service $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
TRAINING (INTERNALLY PROVIDED)
Courseware Development/Maintenance per trainee $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
Training Software (be specific) per trainee $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
Course Materials (duplication) per trainee $0 $0 $0 $0 $0 $0 $0
Logistical Costs (be specific) per trainee $0 $0 $0 $0 $0 $0 $0
Miscellaneous Expenses (be specific) per trainee $0 $0 $0 $0 $0 $0 $0
(select row and insert additional throws here as needed) per trainee $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
DESKTOP SUPPORT
(internal service #1} per service $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(internal service #n} per service $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(select row and insert additional throws here as needed) per service $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
OTHER INTERNAL SERVICES
(other cost #1} per service $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(other cost #1} per service $0 $0 $0 $0 $0 $0 $0
(other cost #1} per service $0 $0 $0 $0 $0 $0 $0
(select row and insert additional throws here as needed)
John McElduff: Insert additional rows as needed, please see "TCO Instructions" tab for details		 per service $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
TOTAL SERVICES COST $0 $0 $0 $0 $0 $0
ESTIMATED INTERNAL LABOR COSTS SOURCE OF INFORMATION UNIT OF MEASURE QUANTITY NEEDED COST PER UNIT EXTENDED COST ANY OTHER ONE-TIME COSTS FIRST YEAR NEEDED LAST YEAR NEEDED ESTIMATED BENEFITS RATE LICENSE COST FUNDING REQUIRED?
Mugambi: As a rule funding is already provided for indirect labor
John McElduff: Insert additional rows as needed, please see "TCO Instructions" tab for details
Jeffrey Whitten: Jeffrey Whitten: Years 2-4 of maintenance were built into purchase price 		FUNDING SOURCE NOT APPLICABLE YEAR 6 RECURS?
DIRECT LABOR
New Hires, Technical
Programmer per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{role #2} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{role #3} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{role #4} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{role #5} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{role #6} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(select row and insert additional throws here as needed) per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
New Hires, Functional
{role #1} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{role #2} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{role #3} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{role #4} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{role #5} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{role #6} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(select row and insert additional throws here as needed) per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
Temporary Backfill, Technical
{role #1} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{role #2}
John McElduff: Insert additional rows as needed, please see "TCO Instructions" tab for details
Jeffrey Whitten: Jeffrey Whitten: Years 2-4 of maintenance were built into purchase price
Jeffrey Whitten: Jeffrey Whitten: Years 2-4 of maintenance were built into purchase price
Jeffrey Whitten: Jeffrey Whitten: Years 2-4 of maintenance were built into purchase price
Jeffrey Whitten: Jeffrey Whitten: Years 2-4 of maintenance were built into purchase price 		per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(select row and insert additional throws here as needed) per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
Temporary Backfill, Functional
{role #1} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{role #2} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{role #3} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{role #4} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{role #5} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{role #6} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(select row and insert additional throws here as needed) per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
INDIRECT LABOR
In Kind, Technical
{role #1} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{role #2} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{role #3} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{role #4} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{role #5} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{role #6} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(select row and insert additional throws here as needed) per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
In-Kind, Functional
{role #1} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{role #2} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{role #3} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{role #4} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{role #5} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{role #6} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{SME #1} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
{SME #n} per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(select row and insert additional throws here as needed) per hour $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
TOTAL LABOUR COST $0 $0 $0 $0 $0 $0
MISCELLANEOUS ESTIMATED COSTS SOURCE OF INFORMATION UNIT OF MEASURE QUANTITY NEEDED COST PER UNIT EXTENDED COST ANY OTHER ONE-TIME COSTS FIRST YEAR NEEDED LAST YEAR NEEDED OTHER RECURRING COSTS LICENSE COST FUNDING REQUIRED? FUNDING SOURCE SUNK COST (already spent) YEAR 6 RECURS?
Space rental per room $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
Remodeling per service $0 $0 $0 $0 $0 $0 $0
Utilities per item $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
Custodial services per service $0 $0 $0 $0 $0 $0 $0
Grounds maintenance services per service $0 $0 $0 $0 $0 $0 $0
Repairs or rehabilitation per service $0 $0 $0 $0 $0 $0 $0
Office equipment (not IT) per item $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
Furnishings per item $0 $0 $0 $0 $0 $0 $0
Telecommunications (phone) per item $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
Telecommunication (networking) per item $0 $0 $0 $0 $0 $0 $0
Travel (if not included in LABOR) per service $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
Professional development (if not in LABOR) per service $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
Legal services per service $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
Supplies & expenses (if not included in LABOR) per service $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
(select row and insert additional throws here as needed) per item $0 $0 $0 $0 $0 $0 $0 ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
TOTAL MISCELLANEOUS COST $0 $0 $0 $0 $0 $0
TOTAL COST OF OWNERSHIP $0 $0 $0 $0 $0 $0

&G Information Technology at Purdue_x000D_

BENEFITS

Total Benefits of Ownership Worksheet
White cells are for user input
Gold cells are calculated. Do NOT unintentionally overwrite the formulas.
Gray cells are column and row headers and are locked
Black cells indicate they are not applicable to the row and column
Use the + and - signs in the left margin to expand and contract categories. It is not recommended that categories be deleted. Click on any row or column header to see its definition
VARIABLE NAMES FOR FORMULAS ☛ Name UnitOfMeasure Quantity UnitCost ExtendedSaving OtherCost LoadingRate Licensing Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 subsidized ERROR:#REF! Year 2 Year 5 Year 6 recharged ERROR:#REF! Year 2 Year 5 Year 6 tbd/requested ERROR:#REF! Year 2 Year 5 Year 6
(also, v
INDIRECT BENEFITS
ESTIMATED RETIRED INFRASTRUCTURE BENEFITS SOURCE OF INFORMATION UNIT OF MEASURE QUANTITY NEEDED COST PER UNIT EXTENDED SAVINGS ANY OTHER ONE-TIME COSTS RECURRING MAINTENANCE ANNUAL RATE LICENSE COST
SERVERS
PRODUCTION SERVERS (may be virtualized)
Application Servers per server $0 $0 $0 $0 $0 $0 $0
Web Servers per server $0 $0 $0 $0 $0 $0 $0
Database Servers per server $0 $0 $0 $0 $0 $0 $0
Message Servers per server $0 $0 $0 $0 $0 $0 $0
File Servers per server $0 $0 $0 $0 $0 $0 $0
Print Servers per server $0 $0 $0 $0 $0 $0 $0
(select row to insert additional rows here as needed) per server $0 $0 $0 $0 $0 $0 $0
NON-PRODUCTION SERVERS (may be virtualized)
Application Servers per server $0 $0 $0 $0 $0 $0 $0
Web Servers per server $0 $0 $0 $0 $0 $0 $0
Database Servers per server $0 $0 $0 $0 $0 $0 $0
Message Servers per server $0 $0 $0 $0 $0 $0 $0
File Servers per server $0 $0 $0 $0 $0 $0 $0
Print Servers per server $0 $0 $0 $0 $0 $0 $0
(select row to insert additional rows here as needed) per server $0 $0 $0 $0 $0 $0 $0
CLIENTS
END USER COMPUTERS OR DEVICES
{item} per computer $0 $0 $0 $0 $0 $0 $0
{item} per computer $0 $0 $0 $0 $0 $0 $0
(select row and insert additional rows here as needed) per computer $0 $0 $0 $0 $0 $0 $0
PROJECT TEAM COMPUTERS AND DEVICES
{item} per computer $0 $0 $0 $0 $0 $0 $0
{item} per computer $0 $0 $0 $0 $0 $0 $0
(select row and insert additional rows here as needed) per computer $0 $0 $0 $0 $0 $0 $0
PERIPHERALS
John McElduff: Include all such costs and recurring costs for hardware specifically purchased for the project
{item} per device $0 $0 $0 $0 $0 $0 $0
{item} per device $0 $0 $0 $0 $0 $0 $0
(select row and insert additional rows here as needed) per device $0 $0 $0 $0 $0 $0 $0
NETWORK HARDWARE
{item} per component $0 $0 $0 $0 $0 $0 $0
{item} per component $0 $0 $0 $0 $0 $0 $0
(select row and insert additional rows here as needed) per component $0 $0 $0 $0 $0 $0 $0
EMBEDDED DEVICES
{item} per device $0 $0 $0 $0 $0 $0 $0
{item} per device $0 $0 $0 $0 $0 $0 $0
(select row and insert additional rows here as needed) per device $0 $0 $0 $0 $0 $0 $0
OTHER
{item} per item $0 $0 $0 $0 $0 $0 $0
{item} per item $0 $0 $0 $0 $0 $0 $0
(select row and insert additional rows here as needed) per item $0 $0 $0 $0 $0 $0 $0
TOTAL RETIRED INFRASTRUCTURE BENEFIT $0 $0 $0 $0 $0 $0
ESTIMATED RETIRED SOFTWARE BENEFITS SOURCE OF INFORMATION UNIT OF MEASURE QUANTITY NEEDED COST PER UNIT EXTENDED SAVINGS ANY OTHER ONE-TIME COSTS RECURRING MAINTENANCE RATE LICENSE COST
SYSTEM SOFTWARE
Upgrade Windows Server license $0 $0 $0 $0 $0 $0 $0
{software item #n} license $0 $0 $0 $0 $0 $0 $0
(select row and insert additional rows here as needed) license $0 $0 $0 $0 $0 $0 $0
APPLICATION SOFTWARE
{software item #1} license $0 $0 $0 $0 $0 $0 $0
{software item #n} license $0 $0 $0 $0 $0 $0 $0
(select row and insert additional rows here as needed) license $0 $0 $0 $0 $0 $0 $0
IMPLEMENTATION TOOLS
{software item #n} license $0 $0 $0 $0 $0 $0 $0
{software item #n} license $0 $0 $0 $0 $0 $0 $0
(select row and insert additional rows here as needed) license $0 $0 $0 $0 $0 $0 $0
NETWORK SOFTWARE
{software item #1} license $0 $0 $0 $0 $0 $0 $0
{software item #n} license $0 $0 $0 $0 $0 $0 $0
(select row and insert additional rows here as needed) license $0 $0 $0 $0 $0 $0 $0
TOTAL RETIRED SOFTWARE BENEFIT $0 $0 $0 $0 $0 $0
ESTIMATED RETIRED EXTERNAL SERVICES BENEFITS SOURCE OF INFORMATION UNIT OF MEASURE QUANTITY NEEDED COST PER UNIT EXTENDED SAVINGS ANY OTHER ONE-TIME COSTS ESTIMATED EXPENSES RATE LICENSE COST
POST-IMPLEMENTATION SERVICES
(external service #1} per service $0 $0 $0 $0 $0 $0 $0
(external service #n} per service $0 $0 $0 $0 $0 $0 $0
(select row and insert additional rows here as needed) per service $0 $0 $0 $0 $0 $0 $0
ESTIMATED RETIRED INTERNAL IT SERVICES BENEFITS SOURCE OF INFORMATION UNIT OF MEASURE QUANTITY NEEDED COST PER UNIT EXTENDED SAVINGS ANY OTHER ONE-TIME COSTS OTHER RECURRING COSTS LICENSE COST
POST-IMPLEMENTATION SERVICES
(internal service #1} per service $0 $0 $0 $0 $0 $0 $0
(internal service #n} per service $0 $0 $0 $0 $0 $0 $0
(select row and insert additional rows here as needed) per service $0 $0 $0 $0 $0 $0 $0
TOTAL RETIRED SERVICES BENEFIT $0 $0 $0 $0 $0 $0
DIRECT BENEFITS
ESTIMATED REDUCED STAFFING SOURCE OF INFORMATION UNIT OF MEASURE QUANTITY NEEDED COST PER UNIT EXTENDED SAVINGS ANY OTHER ONE-TIME COSTS LOADING RATE LICENSE COST
{role #1} per hour $0 $0 $0 $0 $0 $0 $0
{role #2} per hour $0 $0 $0 $0 $0 $0 $0
{role #3} per hour $0 $0 $0 $0 $0 $0 $0
{role #4} per hour $0 $0 $0 $0 $0 $0 $0
{role #5} per hour $0 $0 $0 $0 $0 $0 $0
{role #6} per hour $0 $0 $0 $0 $0 $0 $0
(select row and insert additional rows here as needed) per hour $0 $0 $0 $0 $0 $0 $0
ESTIMATED REDUCED MANUFACTURING COST SOURCE OF INFORMATION UNIT OF MEASURE QUANTITY NEEDED UNIT COST SAVED EXTENDED SAVINGS ANY OTHER ONE-TIME COSTS OTHER RECURRING COSTS LICENSE COST
MANUFACTURING PROCESSES
{process #1} per unit $0 $0 $0 $0 $0 $0 $0
{process #2} per unit $0 $0 $0 $0 $0 $0 $0
{process #3} per unit $0 $0 $0 $0 $0 $0 $0
{process #4} per unit $0 $0 $0 $0 $0 $0 $0
{process #5} per unit $0 $0 $0 $0 $0 $0 $0
{process #6} per unit $0 $0 $0 $0 $0 $0 $0
(select row and insert additional rows here as needed) per unit $0 $0 $0 $0 $0 $0 $0
SCRAP PRODUCED
{type #1} per unit $0 $0 $0 $0 $0 $0 $0
{type #2} per unit $0 $0 $0 $0 $0 $0 $0
{type #3} per unit $0 $0 $0 $0 $0 $0 $0
(select row and insert additional rows here as needed) per unit $0 $0 $0 $0 $0 $0 $0
ESTIMATED REDUCED INVENTORY COSTS SOURCE OF INFORMATION UNIT OF MEASURE QUANTITY NEEDED UNIT COST SAVED EXTENDED SAVINGS ANY OTHER ONE-TIME COSTS LOADING RATE LICENSE COST
BACK ORDERS
{product #1} per unit $0 $0 $0 $0 $0 $0 $0
{product #2} per unit $0 $0 $0 $0 $0 $0 $0
{product #3} per unit $0 $0 $0 $0 $0 $0 $0
(select row and insert additional rows here as needed) per unit $0 $0 $0 $0 $0 $0 $0
DAMAGED GOODS
{product #1} per unit $0 $0 $0 $0 $0 $0 $0
{product #2} per unit $0 $0 $0 $0 $0 $0 $0
{product #3} per unit $0 $0 $0 $0 $0 $0 $0
(select row and insert additional rows here as needed) per unit $0 $0 $0 $0 $0 $0 $0
STORAGE COSTS
{product #1} per unit $0 $0 $0 $0 $0 $0 $0
{product #2} per unit $0 $0 $0 $0 $0 $0 $0
{product #3} per unit $0 $0 $0 $0 $0 $0 $0
(select row and insert additional rows here as needed) per unit $0 $0 $0 $0 $0 $0 $0
OTHER
{product #1} per unit $0 $0 $0 $0 $0 $0 $0
{product #2} per unit $0 $0 $0 $0 $0 $0 $0
(select row and insert additional rows here as needed) per unit $0 $0 $0 $0 $0 $0 $0
ESTIMATED GENERAL COST REDUCTIONS SOURCE OF INFORMATION UNIT OF MEASURE QUANTITY NEEDED UNIT COST SAVED EXTENDED SAVINGS ANY OTHER ONE-TIME COSTS TAX RATE LICENSE COST
UNCOLLECTIBLE SALES
{product #1} per unit $0 $0 $0 $0 $0 $0 $0
{product #2} per unit $0 $0 $0 $0 $0 $0 $0
{product #3} per unit $0 $0 $0 $0 $0 $0 $0
(select row and insert additional rows here as needed) per unit $0 $0 $0 $0 $0 $0 $0
DEBT COLLECTION COSTS
{product #1} per unit $0 $0 $0 $0 $0 $0 $0
{product #2} per unit $0 $0 $0 $0 $0 $0 $0
{product #3} per unit $0 $0 $0 $0 $0 $0 $0
(select row and insert additional rows here as needed) per unit $0 $0 $0 $0 $0 $0 $0
OTHER
{product #1} per unit $0 $0 $0 $0 $0 $0 $0
{product #2} per unit $0 $0 $0 $0 $0 $0 $0
(select row and insert additional rows here as needed) per unit $0 $0 $0 $0 $0 $0 $0
ESTIMATED COST AVOIDANCES SOURCE OF INFORMATION UNIT OF MEASURE QUANTITY NEEDED UNIT COST SAVED EXTENDED SAVINGS ANY OTHER ONE-TIME COSTS TAX RATE LICENSE COST
LOAN PRINCIPAL
{product #1} per unit $0 $0 $0 $0 $0 $0
{product #2} per unit $0 $0 $0 $0 $0 $0 $0
(select row and insert additional rows here as needed) per unit $0 $0 $0 $0 $0 $0 $0
LOAN INTEREST
{product #1} per unit $0 $0 $0 $0 $0 $0 $0
{product #2} per unit $0 $0 $0 $0 $0 $0 $0
(select row and insert additional rows here as needed) per unit $0 $0 $0 $0 $0 $0 $0
PENALTIES
{product #1} per unit $0 $0 $0 $0 $0 $0 $0
{product #2} per unit $0 $0 $0 $0 $0 $0 $0
(select row and insert additional rows here as needed) per unit $0 $0 $0 $0 $0 $0 $0
ESTIMATED IMPROVED QUALITY SOURCE OF INFORMATION UNIT OF MEASURE QUANTITY NEEDED UNIT COST SAVED EXTENDED SAVINGS ANY OTHER ONE-TIME COSTS OTHER RECURRING COSTS LICENSE COST
REDUCED MISTAKES
{product #1} per unit $0 $0 $0 $0 $0 $0
{product #2} per unit $0 $0 $0 $0 $0 $0 $0
(select row and insert additional rows here as needed) per unit $0 $0 $0 $0 $0 $0 $0
OTHER
{product #1} per unit $0 $0 $0 $0 $0 $0
{product #2} per unit $0 $0 $0 $0 $0 $0 $0
(select row and insert additional rows here as needed) per unit $0 $0 $0 $0 $0 $0 $0
ESTIMATED INCREASE IN SALES SOURCE OF INFORMATION UNIT OF MEASURE QUANTITY NEEDED UNIT COST SAVED EXTENDED SAVINGS ANY OTHER ONE-TIME COSTS OTHER RECURRING COSTS LICENSE COST
SALES INCREASE
{product #1} per unit $0 $0 $0 $0 $0 $0
{product #2} per unit $0 $0 $0 $0 $0 $0 $0
{product #3} per unit $0 $0 $0 $0 $0 $0 $0
(select row and insert additional rows here as needed) per unit $0 $0 $0 $0 $0 $0 $0
TOTAL DIRECT BENEFITS $0 $0 $0 $0 $0 $0
TOTAL BENEFIT OF OWNERSHIP $0 $0 $0 $0 $0 $0

ANALYSIS

Cost/Benefit Analyses Worksheet
THIS WORKSHEET WILL BE COMPLETED BY STUDENTS IN A FUTURE ASSIGNMENT

CALCULATOR

Intangible Benefits Calculator
THIS WORKSHEET MAY BE COMPLETED BY STUDENTS IN A FUTURE EXTRA- CREDIT ASSIGNMENT

SETTINGS

Configuration and Preferences for all Worksheets
)
THIS PAGE WILL BE BUILT AND UPDATED BY STUDENTS OVER THE COURSE OF MULTIPLE ASSIGNMENTS
DROP DOWN LISTS -- these drop list values are customizable for each business or organization that uses this spreadsheet template. Simply change them in the template to your preferences, and they values will be enforced for each instance of the spreadsheet. FundingSource
To be determined
REQUEST FUNDING
SUNK (item already purchased)
Central IT Organization
Chief Executive Officer
Chief Financial Officer
Chief Operating Officer
Chief Information Officer
Financial Management
Human Resources
Marketing
Manufacturing
Logistics
Research & Development
Other (spoecify in settings)
Other (spoecify in settings)
Other (spoecify in settings)
Other (spoecify in settings)
Other (spoecify in settings)
Other (spoecify in settings)
Other (spoecify in settings)
Other (spoecify in settings)
Other (spoecify in settings)
Other (spoecify in settings)
NEW DEBT
VENTURE CAPITAL
VARIOUS (itemize in a comment)
only insert new rows above this row

FUNDING