Assignment in total cost of ownership for IT solutions using excel

profilelauren II
cost-benefit_analysis_template_v2.255.xlsm
Home>Business & Finance homework help>Economics homework help>Assignment in total cost of ownership for IT solutions using excel

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: Gray cells are column and row headers and are locked
Prepared by: Black cells indicate they are not applicable; or duplicate headers
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 colum header to see its definition
VARIABLE NAMES FOR FORMULAS ☛ Name UnitOfMeasure Quantity UnitCost ExtendedCost OtherCost Timing_1 Timing_2 LoadingRate Funded FundingSource Sunk Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Recurs? subsidised 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 Year 1 = Lifetime Stage >
ESTIMATED INFRASTRUCTURE COSTS SOURCE OF INFORMATION UNIT OF MEASURE QUANTITY NEEDED COST PER UNIT EXTENDED COST OTHER ONE-TIME COSTS PURCHASE YEAR RECURRING MAINTENANCE START YEAR RECURRING MAINTENANCE ANNUAL RATE FUNDING REQUIRED? FUNDING SOURCE SUNK COST (already spent) YEAR 6 RECURS?
SERVERS Source of Information Unit of Measurre Quantity Needed Cost per Unit Extended Cost Other 1-Time Cost Purchase Year Maint. Start Year Annual Maint. Rate Funding Needed? Funding Source Amt. Already Spent
NEW PRODUCTION SERVERS (may be virtualized) Source of Information Unit of Measurre Quantity Needed Cost per Unit Extended Cost Other 1-Time Cost Purchase Year Maint. Start Year Annual Maint. Rate Funding Needed? Funding Source Amt. Already Spent ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 computer
Web Servers per computer
Database Servers per computer
Message Servers per computer
(select row to insert additional trows here as needed) per computer ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 NON-PRODUCTION SERVERS (may be virtualized) Source of Information Unit of Measurre Quantity Needed Cost per Unit Extended Cost Other 1-Time Cost Purchase Year Maint. Start Year Annual Maint. Rate Funding Needed? Funding Source Amt. Already Spent
Sandbox or Seed Servers (application, web, database, and other) per computer
Development Servers (application, web, database, and other) per computer
Test/Quality Assurance (application, web, database, and other) per computer
Training Servers (application, web, database, and other) per computer
{specifiy server} per computer
{specifiy server} per computer
{specifiy server} per computer
{specifiy server} per computer
(select row to insert additional trows here as needed) per computer
UPGRADES TO EXISTING SERVERS Source of Information Unit of Measurre Quantity Needed Cost per Unit Extended Cost Other 1-Time Cost Purchase Year Maint. Start Year Annual Maint. Rate Funding Needed? Funding Source Amt. Already Spent
{specify type of upgrade) per component
{specify type of upgrade) per component
{specify type of upgrade) per component
(select row to insert additional trows here as needed) per component
CLIENTS Source of Information Unit of Measurre Quantity Needed Cost per Unit Extended Cost Other 1-Time Cost Purchase Year Maint. Start Year Annual Maint. Rate Funding Needed? Funding Source Amt. Already Spent
END USER COMPUTERS OR DEVICES Source of Information Unit of Measurre Quantity Needed Cost per Unit Extended Cost Other 1-Time Cost Purchase Year Maint. Start Year Annual Maint. Rate Funding Needed? Funding Source Amt. Already Spent ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 trows here as needed) per computer ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 Source of Information Unit of Measurre Quantity Needed Cost per Unit Extended Cost Other 1-Time Cost Purchase Year Maint. Start Year Annual Maint. Rate Funding Needed? Funding Source Amt. Already Spent
{specify type of upgrade) per component
{specify type of upgrade) per component
(select row and insert additional trows here as needed) per component
PROJECT TEAM COMPUTERS AND DEVICES Source of Information Unit of Measurre Quantity Needed Cost per Unit Extended Cost Other 1-Time Cost Purchase Year Maint. Start Year Annual Maint. Rate Funding Needed? Funding Source Amt. Already Spent ERROR:#REF! ERROR:#REF! ERROR:#REF! 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
{item} per computer
(select row and insert additional trows here as needed) per computer
UPGRADES TO PROJECT TEAM COMPUTERS Source of Information Unit of Measurre Quantity Needed Cost per Unit Extended Cost Other 1-Time Cost Purchase Year Maint. Start Year Annual Maint. Rate Funding Needed? Funding Source Amt. Already Spent
{specify type of upgrade) per component
{specify type of upgrade) per component
(select row and insert additional trows here as needed) per component
PERIPHERALS Source of Information Unit of Measurre Quantity Needed Cost per Unit Extended Cost Other 1-Time Cost Purchase Year Maint. Start Year Annual Maint. Rate Funding Needed? Funding Source Amt. Already Spent
{item} per device ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 trows here as needed) per device ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 Source of Information Unit of Measurre Quantity Needed Cost per Unit Extended Cost Other 1-Time Cost Purchase Year Maint. Start Year Annual Maint. Rate Funding Needed? Funding Source Amt. Already Spent
{item} per component ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 trows here as needed) per component ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 (e.g., embedded devices) Source of Information Unit of Measurre Quantity Needed Cost per Unit Extended Cost Other 1-Time Cost Purchase Year Maint. Start Year Annual Maint. Rate Funding Needed? Funding Source Amt. Already Spent
{item} ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 trows here as needed) ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 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 FUNDING REQUIRED? FUNDING SOURCE SUNK COST (already spent) YEAR 6 RECURS?
SYSTEM SOFTWARE Source of Information Unit of Measurre Quantity Needed Cost per Unit Extended Cost Other 1-Time Cost Purchase Year Maint. Start Year Annual Maint. Rate Funding Needed? Funding Source Amt. Already Spent
Upgrade Windows Server license ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 trows here as needed) license ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 Source of Information Unit of Measurre Quantity Needed Cost per Unit Extended Cost Other 1-Time Cost Purchase Year Maint. Start Year Annual Maint. Rate Funding Needed? Funding Source Amt. Already Spent
{software item #1} license ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 trows here as needed) license ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 Source of Information Unit of Measurre Quantity Needed Cost per Unit Extended Cost Other 1-Time Cost Purchase Year Maint. Start Year Annual Maint. Rate Funding Needed? Funding Source Amt. Already Spent
{software item #n} license ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 trows here as needed) license ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 Source of Information Unit of Measurre Quantity Needed Cost per Unit Extended Cost Other 1-Time Cost Purchase Year Maint. Start Year Annual Maint. Rate Funding Needed? Funding Source Amt. Already Spent
{software item #1} license ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 trows here as needed) license ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 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 FUNDING REQUIRED? FUNDING SOURCE SUNK COST (already spent) YEAR 6 RECURS?
IMPLEMENTATION CONSULTANTS Source of Information Unit of Measurre Quantity Needed Cost per Unit Extended Cost Other 1-Time Cost Purchase Year Maint. Start Year Expenses Rate Funding Needed? Funding Source Not applicavble
(external service #1} hours ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 #1} hours
(external service #1} hours
(external service #1} hours ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 #1} hours ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 Source of Information Unit of Measurre Quantity Needed Cost per Unit Extended Cost Other 1-Time Cost Purchase Year Maint. Start Year Annual Maint. Rate Funding Needed? Funding Source Amt. Already Spent
(external service #1} hours ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 trows here as needed) hours ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
CONTRACT TRAINERS FOR IMPLEMENTATION Source of Information Unit of Measurre Quantity Needed Cost per Unit Extended Cost Other 1-Time Cost Purchase Year Maint. Start Year Annual Maint. Rate Funding Needed? Funding Source Amt. Already Spent
(external service #1} ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 trows here as needed) ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 Source of Information Unit of Measurre Quantity Needed Cost per Unit Extended Cost Other 1-Time Cost Purchase Year Maint. Start Year Annual Maint. Rate Funding Needed? Funding Source Amt. Already Spent
(external service #1} per year ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 year ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 trows here as needed) per year ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 CHARGE-BACK? ABSORBED OR RECHARGED? SUNK COST (already spent) YEAR 6 RECURS?
PROJECT MANAGEMENT Source of Information Unit of Measurre Quantity Needed Cost per Unit Extended Cost Other 1-Time Cost Purchase Year Maint. Start Year Not Appliacable Recharged? Funding Source Amt. Already Spent
(internal service #1} ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 trows here as needed) ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 Source of Information Unit of Measurre Quantity Needed Cost per Unit Extended Cost Other 1-Time Cost Purchase Year Maint. Start Year Not Appliacable Recharged? Funding Source Amt. Already Spent
(internal service #1} ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 trows here as needed) ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 Source of Information Unit of Measurre Quantity Needed Cost per Unit Extended Cost Other 1-Time Cost Purchase Year Maint. Start Year Not Appliacable Recharged? Funding Source Amt. Already Spent
(internal service #1} ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 trows here as needed) ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 Source of Information Unit of Measurre Quantity Needed Cost per Unit Extended Cost Other 1-Time Cost Purchase Year Maint. Start Year Not Appliacable Recharged? Funding Source Amt. Already Spent
(internal service #1} ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 trows here as needed) ERROR:#REF! ERROR:#REF! ERROR:#REF! 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) Source of Information Unit of Measurre Quantity Needed Cost per Unit Extended Cost Other 1-Time Cost Purchase Year Maint. Start Year Not Appliacable Recharged? Funding Source Amt. Already Spent
Corseware Development/Maintenance ERROR:#REF! ERROR:#REF! ERROR:#REF! 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) ERROR:#REF! ERROR:#REF! ERROR:#REF! 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)
Logistical Costs (be specific)
Miscellaneous Expenses (be specific)
(select row and insert additional trows here as needed) ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 Source of Information Unit of Measurre Quantity Needed Cost per Unit Extended Cost Other 1-Time Cost Purchase Year Maint. Start Year Not Appliacable Recharged? Funding Source Amt. Already Spent
(internal service #1} ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 trows here as needed) ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 IT SERVICES Source of Information Unit of Measurre Quantity Needed Cost per Unit Extended Cost Other 1-Time Cost Purchase Year Maint. Start Year Not Appliacable Recharged? Funding Source Amt. Already Spent
(other cost #1} ERROR:#REF! ERROR:#REF! ERROR:#REF! 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}
(other cost #1}
(select row and insert additional trows here as needed)
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 		ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 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 FUNDING REQUIRED? FUNDING SOURCE NOT APPLICABLE YEAR 6 RECURS?
NEW HIRES Source of Information Unit of Measurre Quantity Needed Salary Extended Cost Hiring & Onboarding Hire Year NOT APPLICABLE Benfefits. Rate For Dept Name Funding Source Amt. Already Spent
New Hires, Technical Source of Information Unit of Measurre Quantity Needed Salary Extended Cost Hiring & Onboarding Hire Year NOT APPLICABLE Benfefits. Rate For Dept Name Funding Source Amt. Already Spent
Programmmer Budgeted FTE Not applicable ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Budgeted FTE Not applicable ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Budgeted FTE Not applicable ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Budgeted FTE Not applicable ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Budgeted FTE Not applicable ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Budgeted FTE Not applicable ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 trows here as needed) Budgeted FTE Not applicable ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 Source of Information Unit of Measurre Quantity Needed Salary Extended Cost Hiring & Onboarding Hire Year NOT APPLICABLE Benfefits. Rate For Dept Name Funding Source Amt. Already Spent
{role #1} Budgeted FTE Not applicable ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Budgeted FTE Not applicable ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Budgeted FTE Not applicable ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Budgeted FTE Not applicable ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Budgeted FTE Not applicable ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Budgeted FTE Not applicable ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 trows here as needed) Budgeted FTE Not applicable ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 Source of Information Unit of Measurre Quantity Needed Salary Extended Cost Hiring & Onboarding Hire Year NOT APPLICABLE Benfefits. Rate For Dept Name Funding Source Amt. Already Spent
{role #1} Budgeted FTE ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 		Budgeted FTE ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 trows here as needed) Budgeted FTE ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 Source of Information Unit of Measurre Quantity Needed Salary Extended Cost Hiring & Onboarding Hire Year NOT APPLICABLE Benfefits. Rate For Dept Name Funding Source Amt. Already Spent
{role #1} Budgeted FTE ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Budgeted FTE ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Budgeted FTE ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Budgeted FTE ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Budgeted FTE ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Budgeted FTE ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 trows here as needed) Budgeted FTE ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 (a.k.a. IN KIND LABOR) Source of Information Unit of Measurre Quantity Needed Salary Extended Cost Not Applicable Start Year Last Year Needed Beefits Rate Funded? Funding Source Amt. Already Spent
Ind Kind, Technical Source of Information Unit of Measurre Quantity Needed Salary Committment Cost Not Applicable Start Year Last Year Needed Beefits Rate Funded? Funding Source Amt. Already Spent
{role #1} Time Committed FTE ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Time Committed FTE ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Time Committed FTE ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Time Committed FTE ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Time Committed FTE ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Time Committed FTE ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 trows here as needed) Time Committed FTE ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 Source of Information Unit of Measurre Quantity Needed Salary Committment Cost Not Applicable Start Year Last Year Needed Beefits Rate Funded? Funding Source Amt. Already Spent
{role #1} Time Committed FTE ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Time Committed FTE ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Time Committed FTE ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Time Committed FTE ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Time Committed FTE ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Time Committed FTE ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Time Committed FTE ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Time Committed FTE ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 trows here as needed) Time Committed FTE ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!
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 FUNDING REQUIRED? FUNDING SOURCE SUNK COST (already spent) YEAR 6 RECURS?
Space rental ERROR:#REF! ERROR:#REF! ERROR:#REF! 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
Utilities ERROR:#REF! ERROR:#REF! ERROR:#REF! 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
Grounds maintenance services
Repairs or rehabilitation
Office equipment (not IT) ERROR:#REF! ERROR:#REF! ERROR:#REF! 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
Telecommunications (phone) ERROR:#REF! ERROR:#REF! ERROR:#REF! 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)
Travel (if not included in LABOR) ERROR:#REF! ERROR:#REF! ERROR:#REF! 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) ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 ERROR:#REF! ERROR:#REF! ERROR:#REF! 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) ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 trows here as needed) ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF! ERROR:#REF!

&G Information Technology at Purdue_x000D_

How to INSERT a row

How to DELETE a row

FUNDING

FUNDING

BENEFITS

Total Benefits of Ownership 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

ANALYSIS

Cost/Benefit Analyses Worksheet
THIS WORKSHEET WILL BE COMPLETED BY STUDENTS IN A FUTURE 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