cost/benefit analysis

profilelauren II
tbo_test_sample.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 colum header to see its definition It is assumed that loading rates increase at a constant rate (compound) and 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? 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 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 Gartner per server 10 $10,000 $100,000 $2,000 1 1 10% $5,000 YES $3,000 $105,500 $105,050
Jeffrey Whitten: Jeffrey Whitten: Years 2-4 of maintenance were built into purchase price 		$105,005
Jeffrey Whitten: Jeffrey Whitten: Years 2-4 of maintenance were built into purchase price 		$105,001
Jeffrey Whitten: Jeffrey Whitten: Years 2-4 of maintenance were built into purchase price 		$105,000
Jeffrey Whitten: Jeffrey Whitten: Years 2-4 of maintenance were built into purchase price 		$105,000
Jeffrey Whitten: Jeffrey Whitten: Years 2-4 of maintenance were built into purchase price 		Yes
Web Servers Gartner per server 12 $12,000 $144,000 $1,000 1 1 12% $5,500 YES $5,000 $150,660 $150,079 $150,010 $150,001 $150,000 $150,000 Yes
Database Servers Gartner per server 15 $14,000 $210,000 $3,000 1 1 15% $500 No REQUEST FUNDING $2,000 $215,075 $215,011 $215,002 $215,000 $215,000 $215,000 Yes
Message Servers Gartner per server 20 $15,000 $300,000 $5,000 1 1 13% $400 YES $1,000 $306,052 $306,007 $306,001 $306,000 $306,000 $306,000 Yes
File Servers Gartner per server 10 $20,000 $200,000 $1,000 1 1 12% $600 No REQUEST FUNDING $500 $201,572 $201,509 $201,501 $201,500 $201,500 $201,500 Yes
Print Servers Gartner per server 2 $2,000 $4,000 $400 1 1 20% $100 YES $400 $4,820 $4,804 $4,801 $4,800 $4,800 $4,800 Yes
(select row to insert additional trows 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 Web per server 10 $5,000 $50,000 $4,000 1 1 15% $500 YES $3,000 $57,075 $57,011 $57,002 $57,000 $57,000 $57,000 No
Web Servers Gartner per server 15 $8,000 $120,000 $1,000 1 1 12% $400 YES $5,000 $126,048 $126,006 $126,001 $126,000 $126,000 $126,000 Yes
Database Servers Gartner per server 10 $10,000 $100,000 $1,000 1 1 10% $600 No REQUEST FUNDING $2,000 $103,060 $103,006 $103,001 $103,000 $103,000 $103,000 Yes
Message Servers Gartner per server 13 $15,000 $195,000 $5,000 1 1 17% $500 YES $1,000 $201,085 $201,014 $201,002 $201,000 $201,000 $201,000 No
File Servers Gartner per server 5 $1,000 $5,000 $1,000 1 1 15% $1,000 No REQUEST FUNDING $500 $6,650 $6,523 $6,503 $6,501 $6,500 $6,500 Yes
Print Servers Gartner per server 2 $1,000 $2,000 $6,000 1 1 15% $500 YES $400 $8,475 $8,411 $8,402 $8,400 $8,400 $8,400 Yes
(select row to insert additional trows here as needed) per server $0 $0 $0 $0 $0 $0 $0
UPGRADES TO EXISTING SERVERS
{specify type of upgrade) Gartner per component 2 $5,000 $10,000 $8,000 1 1 15% $500 YES $1,000 $19,075 $19,011 $19,002 $19,000 $19,000 $19,000 Yes
{specify type of upgrade) Gartner per component 4 $5,000 $20,000 $1,000 1 1 15% $1,000 No REQUEST FUNDING $500 $21,650 $21,523 $21,503 $21,501 $21,500 $21,500 No
{specify type of upgrade) Gartner per component 5 $4,000 $20,000 $1,000 1 1 15% $500 YES $400 $21,475 $21,411 $21,402 $21,400 $21,400 $21,400 Yes
(select row to insert additional trows 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} Gartner per computer 5 $500 $2,500 $500 1 No REQUEST FUNDING $500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per computer 6 $5,000 $30,000 $500 1 YES $400 $30,900 $30,900 $30,900 $30,900 $30,900 $30,900 No ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 $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} Gartner per component 4 $2,000 $8,000 $5,000 1 YES $3,000 $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 Yes
{item} Gartner per component 8 $1,000 $8,000 $5,500 1 No REQUEST FUNDING $400 $13,900 $13,900 $13,900 $13,900 $13,900 $13,900 Yes
(select row and insert additional trows 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} Gartner per computer 8 $500 $4,000 $7,000 1 YES $5,000 $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 Yes
{item} Gartner per computer 7 $1,000 $7,000 $1,000 1 YES $900 $8,900 $8,900 $8,900 $8,900 $8,900 $8,900 Yes
(select row and insert additional trows here as needed) per computer $0 $0 $0 $0 $0 $0 $0
UPGRADES TO PROJECT TEAM COMPUTERS
{item} Gartner per component 7 $5,000 $35,000 $1,500 1 YES $3,000 $39,500 $39,500 $39,500 $39,500 $39,500 $39,500 Yes
{item} Gartner per component 5 $1,000 $5,000 $500 1 YES $5,000 $10,500 $10,500 $10,500 $10,500 $10,500 $10,500 Yes
(select row and insert additional trows 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} Gartner per device 5 $1,000 $5,000 $500 1 1 15% $500 YES $3,000 $8,575 $8,511 $8,502 $8,500 $8,500 $8,500 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per device 2 $1,000 $2,000 $500 1 1 13% $500 No REQUEST FUNDING $400 $2,965 $2,908 $2,901 $2,900 $2,900 $2,900 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 $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} Gartner per component 5 $6,000 $30,000 $3,000 1 1 14% $400 YES $3,000 $36,056 $36,008 $36,001 $36,000 $36,000 $36,000 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per component 5 $5,000 $25,000 $6,000 1 1 15% $600 No REQUEST FUNDING $400 $31,490 $31,414 $31,402 $31,400 $31,400 $31,400 No ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 $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} Gartner per device 5 $5,000 $25,000 $500 1 1 10% $500 YES $3,000 $28,550 $28,505 $28,501 $28,500 $28,500 $28,500 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per device 5 $4,000 $20,000 $500 1 1 12% $1,000 No REQUEST FUNDING $400 $21,020 $20,914 $20,902 $20,900 $20,900 $20,900 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 $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} Gartner per item 5 $6,000 $30,000 $3,000 1 1 15% $400 YES $3,000 $36,060 $36,009 $36,001 $36,000 $36,000 $36,000 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per item 5 $5,000 $25,000 $6,000 1 1 12% $100 No REQUEST FUNDING $400 $31,412 $31,401 $31,400 $31,400 $31,400 $31,400 No ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 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 $1,883,600 $1,881,247 $1,880,946 $1,880,906 $1,880,901 $1,880,900
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 Gartner license 1 $8,000 $20,000 1 1 10% $8,000.00 YES $3,000 $31,800 $31,080 $31,008 $31,001 $31,000 $28,000 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner license 1 $5,500 $15,000 1 1 12% $5,500.00 No REQUEST FUNDING $400 $21,560 $20,979 $20,510 $20,901 $20,900 $20,500 No ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 $0.00 $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} Gartner license 1 $8,000 $35,000 1 1 25% $8,000.00 YES $3,000 $48,000 $46,500 $46,125 $46,031 $46,008 $46,002 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner license 1 $10,000 $10,000 1 1 20% $10,000.00 No REQUEST FUNDING $400 $22,400 $20,800 $20,080 $20,416 $20,403 $20,401 No ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 $0.00 $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} Gartner license 1 $12,000 $5,000 1 1 10% $12,000.00 YES $3,000 $21,200 $20,120 $20,012 $20,001 $20,000 $20,000 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner license 1 $15,000 $2,000 1 1 12% $15,000.00 No REQUEST FUNDING $400 $19,200 $17,616 $17,026 $17,403 $17,400 $17,400 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 $0.00 $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} Gartner license 1 $5,000 $18,000 1 1 13% $5,000.00 YES $3,000 $26,650 $26,085 $26,011 $26,001 $26,000 $26,000 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner license 1 $3,000 $25,000 1 1 22% $3,000.00 No REQUEST FUNDING $400 $29,060 $28,545 $28,032 $28,407 $28,402 $28,400 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 $0.00 $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 $219,870 $211,725 $208,803 $210,162 $210,113 $206,703
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} Gartner hours 2 $40 $80 $20,000 1 6 20% No REQUEST FUNDING $2,000 $22,096 $22,096 $22,096 $22,096 $22,096 $22,096 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner hours 1 $10 $10 $15,000 1 5 25% YES $1,000 $16,013 $16,013 $16,013 $16,013 $16,013 $16,013 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 $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} Gartner hours 1 $20 $20 $20,000 1 5 22% No REQUEST FUNDING $2,000 $22,024 $22,024 $22,024 $22,024 $22,024 $22,024 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner hours 1 $10 $10 $15,000 1 4 26% YES $1,000 $16,013 $16,013 $16,013 $16,013 $16,013 $16,013 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 $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} Gartner hours 1 $5 $5 $20,000 1 4 24% No REQUEST FUNDING $2,000 $22,006 $22,006 $22,006 $22,006 $22,006 $22,006 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner hours 1 $10 $10 $15,000 1 5 21% YES $1,000 $16,012 $16,012 $16,012 $16,012 $16,012 $16,012 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 $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} Gartner per service 1 $10 $10 $20,000 1 3 20% No REQUEST FUNDING $2,000 $22,012 $22,012 $22,012 $22,012 $22,012 $22,012 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per service 1 $20 $20 $15,000 1 2 20% YES $1,000 $16,024 $16,024 $16,024 $16,024 $16,024 $16,024 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 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} Gartner per service 1 $200 $200 $20,000 1 2 No REQUEST FUNDING $2,000 $22,200 $22,200 $22,200 $22,200 $22,200 $22,200 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per service 1 $400 $400 $15,000 1 4 YES $1,000 $16,400 $16,400 $16,400 $16,400 $16,400 $16,400 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 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} Gartner per service 1 $600 $600 $20,000 1 6 No REQUEST FUNDING $2,000 $22,600 $22,600 $22,600 $22,600 $22,600 $22,600 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per service 1 $100 $100 $15,000 1 1 YES $1,000 $16,100 $16,100 $16,100 $16,100 $16,100 $16,100 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 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} Gartner per service 1 $500 $500 $20,000 1 2 No REQUEST FUNDING $2,000 $22,500 $22,500 $22,500 $22,500 $22,500 $22,500 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per service 1 $500 $500 $15,000 1 3 YES $1,000 $16,500 $16,500 $16,500 $16,500 $16,500 $16,500 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 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} Gartner per service 1 $600 $600 $20,000 1 6 No REQUEST FUNDING $2,000 $22,600 $22,600 $22,600 $22,600 $22,600 $22,600 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per service 1 $100 $100 $15,000 1 5 YES $1,000 $16,100 $16,100 $16,100 $16,100 $16,100 $16,100 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 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)
Corseware Development/Maintenance Gartner per trainee 2 $500 $1,000 $20,000 1 4 No REQUEST FUNDING $2,000 $23,000 $23,000 $23,000 $23,000 $23,000 $23,000 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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) Gartner per trainee 5 $100 $500 $15,000 1 5 YES $1,000 $16,500 $16,500 $16,500 $16,500 $16,500 $16,500 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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) Gartner per trainee 5 $5,000 $25,000 $500 1 3 No REQUEST FUNDING $2,000 $27,500 $27,500 $27,500 $27,500 $27,500 $27,500
Logistical Costs (be specific) Gartner per trainee 2 $6,000 $12,000 $200 1 6 YES $1,000 $13,200 $13,200 $13,200 $13,200 $13,200 $13,200 Yes
Miscellaneous Expenses (be specific) Gartner per trainee 3 $4,000 $12,000 $1,000 1 2 No REQUEST FUNDING $2,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 Yes
(select row and insert additional trows 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} Gartner per service 6 $200 $1,200 $200 1 6 No REQUEST FUNDING $2,000 $3,400 $3,400 $3,400 $3,400 $3,400 $3,400 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per service 5 $400 $2,000 $1,000 1 6 YES $1,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 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} Gartner per service 8 $500 $4,000 $200 1 5 No REQUEST FUNDING $2,000 $6,200 $6,200 $6,200 $6,200 $6,200 $6,200 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per service 5 $600 $3,000 $1,000 1 5 YES $1,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 Yes
(other cost #1} Gartner per service 4 $100 $400 $500 1 5 No REQUEST FUNDING $2,000 $2,900 $2,900 $2,900 $2,900 $2,900 $2,900
(select row and insert additional trows 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 $22,096 $423,900 $423,900 $423,900 $423,900 $423,900
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 labour
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
Programmmer Gartner per hour 1 $50 $50 $20,000 1 5 5% YES $20,053 $20,053 $20,053 $20,053 $20,053 $20,053 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per hour 1 $10 $10 $15,000 1 4 4% No Chief Operating Officer $15,010 $15,010 $15,010 $15,010 $15,010 $15,010 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per hour 1 $12 $12 $500 1 6 3% No REQUEST FUNDING $512 $512 $512 $512 $512 $512 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per hour 1 $15 $15 $200 1 6 1% YES $215 $215 $215 $215 $215 $215 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per hour 1 $20 $20 $1,000 1 6 5% No Chief Operating Officer $1,021 $1,021 $1,021 $1,021 $1,021 $1,021 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per hour 1 $40 $40 $200 1 5 5% YES $242 $242 $242 $242 $242 $242 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 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} Gartner per hour 1 $60 $60 $20,000 1 2 2% YES $20,061 $20,061 $20,061 $20,061 $20,061 $20,061 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per hour 1 $40 $40 $15,000 1 6 5% No Chief Operating Officer $15,042 $15,042 $15,042 $15,042 $15,042 $15,042 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per hour 1 $10 $10 $500 1 4 5% No REQUEST FUNDING $511 $511 $511 $511 $511 $511 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per hour 1 $10 $10 $200 1 5 7% YES $211 $211 $211 $211 $211 $211 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per hour 1 $10 $10 $1,000 1 5 10% No Chief Operating Officer $1,011 $1,011 $1,011 $1,011 $1,011 $1,011 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per hour 1 $10 $10 $200 1 5 12% YES $211 $211 $211 $211 $211 $211 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 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} Gartner per hour 1 $15 $15 $1,000 1 3 15% YES $1,017 $1,017 $1,017 $1,017 $1,017 $1,017 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 		Gartner per hour 1 $5 $5 $200 1 6 1% No Chief Operating Officer $205 $205 $205 $205 $205 $205 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 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} Gartner per hour 1 $10 $10 $20,000 1 1 5% YES $20,011 $20,011 $20,011 $20,011 $20,011 $20,011 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per hour 1 $5 $5 $15,000 1 5 2% No Chief Operating Officer $15,005 $15,005 $15,005 $15,005 $15,005 $15,005 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per hour 1 $12 $12 $500 1 6 4% No REQUEST FUNDING $512 $512 $512 $512 $512 $512 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per hour 1 $18 $18 $200 1 4 5% YES $219 $219 $219 $219 $219 $219 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per hour 1 $20 $20 $1,000 1 5 1% No Chief Operating Officer $1,020 $1,020 $1,020 $1,020 $1,020 $1,020 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per hour 1 $15 $15 $200 1 5 7% YES $216 $216 $216 $216 $216 $216 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 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
Ind Kind, Technical
{role #1} Gartner per hour 1 $30 $30 $20,000 1 6 9% No $20,033 $20,033 $20,033 $20,033 $20,033 $20,033 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per hour 1 $20 $20 $15,000 1 2 4% No $15,021 $15,021 $15,021 $15,021 $15,021 $15,021 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per hour 1 $40 $40 $500 1 5 3% No $541 $541 $541 $541 $541 $541 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per hour 1 $4 $4 $200 1 3 1% No $204 $204 $204 $204 $204 $204 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per hour 1 $4 $4 $1,000 1 2 4% No $1,004 $1,004 $1,004 $1,004 $1,004 $1,004 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per hour 1 $6 $6 $200 1 2 8% No $206 $206 $206 $206 $206 $206 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 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} Gartner per hour 1 $60 $60 $20,000 1 5 2% YES $20,061 $20,061 $20,061 $20,061 $20,061 $20,061 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per hour 1 $50 $50 $15,000 1 2 1% No Chief Operating Officer $15,051 $15,051 $15,051 $15,051 $15,051 $15,051 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per hour 1 $10 $10 $500 1 3 5% No REQUEST FUNDING $511 $511 $511 $511 $511 $511 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per hour 1 $10 $10 $200 1 5 3% YES $210 $210 $210 $210 $210 $210 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per hour 1 $70 $70 $1,000 1 2 4% No Chief Operating Officer $1,073 $1,073 $1,073 $1,073 $1,073 $1,073 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per hour 1 $13 $13 $200 1 3 6% YES $214 $214 $214 $214 $214 $214 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per hour 1 $20 $20 $5,000 1 2 2% No Chief Operating Officer $5,020 $5,020 $5,020 $5,020 $5,020 $5,020 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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} Gartner per hour 1 $15 $15 $20 1 3 1% YES $35 $35 $35 $35 $35 $35 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 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 $20,053 $20,053 $191,490 $191,490 $191,490 $191,490
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 Gartner per room 5 $2,000 $10,000 $20,000 1 6 $400 YES $5,000 $35,400 $35,400 $35,400 $35,400 $35,400 $35,400 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 Gartner per service 1 $400 $400 $15,000 1 6 $500 YES $1,000 $16,900 $16,900 $16,900 $16,900 $16,900 $16,900 Yes
Utilities Gartner per item 10 $50 $500 $500 1 5 $200 YES $2,000 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 Gartner per service 5 $600 $3,000 $200 1 5 $100 No Central IT Organization $1,000 $4,300 $4,300 $4,300 $4,300 $4,300 $4,300 Yes
Grounds maintenance services Gartner per service 4 $50 $200 $1,000 1 2 $100 YES $600 $1,900 $1,900 $1,900 $1,900 $1,900 $1,900 Yes
Repairs or rehabilitation Gartner per service 6 $100 $600 $200 1 5 $10 YES $700 $1,510 $1,510 $1,510 $1,510 $1,510 $1,510 Yes
Office equipment (not IT) Gartner per item 20 $2,000 $40,000 $5,000 1 4 $20 No Chief Information Officer $100 $45,120 $45,120 $45,120 $45,120 $45,120 $45,120 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 Gartner per item 15 $1,000 $15,000 $20 1 3 $15 YES $300 $15,335 $15,335 $15,335 $15,335 $15,335 $15,335 Yes
Telecommunications (phone) Gartner per item 10 $2,000 $20,000 $20,000 1 3 $190 YES $100 $40,290 $40,290 $40,290 $40,290 $40,290 $40,290 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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) Gartner per item 10 $8,000 $80,000 $15,000 1 2 $300 No Chief Financial Officer $500 $95,800 $95,800 $95,800 $95,800 $95,800 $95,800 Yes
Travel (if not included in LABOR) Gartner per service 5 $9,000 $45,000 $500 1 2 $100 No Chief Financial Officer $700 $46,300 $46,300 $46,300 $46,300 $46,300 $46,300 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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) Gartner per service 5 $12,000 $60,000 $200 1 2 $600 YES $900 $61,700 $61,700 $61,700 $61,700 $61,700 $61,700 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 Gartner per service 4 $8,000 $32,000 $1,000 1 5 $400 No REQUEST FUNDING $400 $33,800 $33,800 $33,800 $33,800 $33,800 $33,800 No ERROR:#REF! ERROR:#REF! ERROR:#REF! 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) Gartner per service 6 $1,500 $9,000 $200 1 4 $800 YES $300 $10,300 $10,300 $10,300 $10,300 $10,300 $10,300 Yes ERROR:#REF! ERROR:#REF! ERROR:#REF! 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 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 $35,400 $411,855 $411,855 $411,855 $411,855 $411,855
TOTAL COST OF OWNERSHIP $5,276,333 $5,657,140 $5,822,132 $5,824,770 $5,824,662 $5,817,840

&G Information Technology at Purdue_x000D_

Total Cost Of Ownership

5276332.8500000034 5657140.3300000029 5822132.034400004 5824770.036728004 5824662.3360024039 5817840.0231467718

Year

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 Gartner per server 5 $10,000 $50,000 $1,200 20% $5,000 $49,800 $1,000 $1,000 $1,000 $1,000 $1,000
Web Servers Gartner per server 2 $12,000 $24,000 $1,000 15% $2,000 $23,300 $300 $300 $300 $300 $300
Database Servers Gartner per server 3 $5,000 $15,000 $500 13% $7,000 $15,410 $910 $910 $910 $910 $910
Message Servers Gartner per server 2 $8,000 $16,000 $400 14% $1,000 $15,740 $140 $140 $140 $140 $140
File Servers Gartner per server 1 $4,000 $4,000 $300 15% $3,000 $4,150 $450 $450 $450 $450 $450
Print Servers Gartner per server 2 $12,000 $24,000 $1,000 15% $4,000 $23,600 $600 $600 $600 $600 $600
(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 Gartner per server 4 $8,000 $32,000 $1,000 15% $5,500 $31,825 $825 $825 $825 $825 $825
Web Servers Gartner per server 6 $15,000 $90,000 $1,000 14% $2,000 $89,280 $280 $280 $280 $280 $280
Database Servers Gartner per server 2 $4,000 $8,000 $500 16% $8,000 $8,780 $1,280 $1,280 $1,280 $1,280 $1,280
Message Servers Gartner per server 3 $5,000 $15,000 $200 17% $1,000 $14,970 $170 $170 $170 $170 $170
File Servers Gartner per server 2 $7,000 $14,000 $3,000 20% $10,000 $13,000 $2,000 $2,000 $2,000 $2,000 $2,000
Print Servers Gartner per server 1 $9,000 $9,000 $700 10% $1,500 $8,450 $150 $150 $150 $150 $150
(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} Gartner per computer 3 $400 $1,200 $200 $1,000 $0 $0 $0 $0 $0
{item} Gartner per computer 2 $300 $600 $500 $100 $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} Gartner per computer 4 $700 $2,800 $400 $2,400 $0 $0 $0 $0 $0
{item} Gartner per computer 2 $1,200 $2,400 $600 $1,800 $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} Gartner per device 4 $1,000 $4,000 $100 15% $1,000 $4,050 $150 $150 $150 $150 $150
{item} Gartner per device 2 $800 $1,600 $200 14% $2,000 $1,680 $280 $280 $280 $280 $280
(select row and insert additional rows here as needed) per device $0 $0 $0 $0 $0 $0 $0
NETWORK HARDWARE
{item} Gartner per component 10 $1,200 $12,000 $120 15% $500 $11,955 $75 $75 $75 $75 $75
{item} Gartner per component 6 $1,500 $9,000 $200 15% $700 $8,905 $105 $105 $105 $105 $105
(select row and insert additional rows here as needed) per component $0 $0 $0 $0 $0 $0 $0
EMBEDDED DEVICES
{item} Gartner per device 5 $400 $2,000 $400 15% $1,000 $1,750 $150 $150 $150 $150 $150
{item} Gartner per device 10 $500 $5,000 $2,000 15% $2,000 $3,300 $300 $300 $300 $300 $300
(select row and insert additional rows here as needed) per device $0 $0 $0 $0 $0 $0 $0
OTHER
{item} Gartner per item 4 $700 $2,800 $500 15% $800 $2,420 $120 $120 $120 $120 $120
{item} Gartner per item 12 $300 $3,600 $50 15% $1,000 $3,700 $150 $150 $150 $150 $150
(select row and insert additional rows here as needed) per item $0 $0 $0 $0 $0 $0 $0
TOTAL RETIRED INFRASTRUCTURE BENEFIT $341,365 $9,435 $9,435 $9,435 $9,435 $9,435
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 Gartner license 10 $5,000 $1,000 10% $50,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
{software item #n} Gartner license 5 $3,000 $2,000 20% $15,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
(select row and insert additional rows here as needed) Gartner license $0 $0 $0 $0 $0 $0 $0
APPLICATION SOFTWARE
{software item #1} Gartner license 4 $6,000 $500 15% $24,000 $3,600 $3,600 $3,600 $3,600 $3,600 $3,600
{software item #n} Gartner license 6 $4,000 $20,000 25% $24,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000
(select row and insert additional rows here as needed) license $0 $0 $0 $0 $0 $0 $0
IMPLEMENTATION TOOLS
{software item #n} Gartner license 10 $400 $1,200 22% $4,000 $880 $880 $880 $880 $880 $880
{software item #n} Gartner license 6 $500 $1,500 14% $3,000 $420 $420 $420 $420 $420 $420
(select row and insert additional rows here as needed) license $0 $0 $0 $0 $0 $0 $0
NETWORK SOFTWARE
{software item #1} Gartner license 8 $400 $1,000 15% $3,200 $480 $480 $480 $480 $480 $480
{software item #n} Gartner license 12 $600 $600 10% $7,200 $720 $720 $720 $720 $720 $720
(select row and insert additional rows here as needed) license $0 $0 $0 $0 $0 $0 $0
TOTAL RETIRED SOFTWARE BENEFIT $20,100 $20,100 $20,100 $20,100 $20,100 $20,100
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} Gartner per service 8 $500 $4,000 $3,000 12% $1,480 $480 $480 $480 $480 $480
(external service #n} Gartner per service 15 $100 $1,500 $1,200 20% $600 $300 $300 $300 $300 $300
(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} Gartner per service 20 $100 $2,000 $500 $1,500 $0 $0 $0 $0 $0
(internal service #n} Gartner per service 15 $700 $10,500 $1,200 $9,300 $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 $1,480 $480 $480 $480 $480 $480
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} Gartner per hour 15 $200 $3,000 $500 20% $0 $2,503 $2,503 $2,503 $2,503 $2,503
{role #2} Gartner per hour 20 $100 $2,000 $140 25% $0 $1,865 $1,865 $1,865 $1,865 $1,865
{role #3} Gartner per hour 25 $300 $7,500 $200 15% $0 $7,304 $7,304 $7,304 $7,304 $7,304
{role #4} Gartner per hour 10 $400 $4,000 $300 10% $0 $3,701 $3,701 $3,701 $3,701 $3,701
{role #5} Gartner per hour 5 $700 $3,500 $70 12% $0 $3,431 $3,431 $3,431 $3,431 $3,431
{role #6} Gartner per hour 7 $900 $6,300 $600 14% $0 $5,701 $5,701 $5,701 $5,701 $5,701
(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} Gartner per unit 8 $400 $3,200 $0 $3,200 $3,200 $3,200 $3,200 $3,200
{process #2} Gartner per unit 10 $500 $5,000 $0 $5,000 $5,000 $5,000 $5,000 $5,000
{process #3} Gartner per unit 5 $900 $4,500 $0 $4,500 $4,500 $4,500 $4,500 $4,500
{process #4} Gartner per unit 15 $700 $10,500 $0 $10,500 $10,500 $10,500 $10,500 $10,500
{process #5} Gartner per unit 8 $1,000 $8,000 $0 $8,000 $8,000 $8,000 $8,000 $8,000
{process #6} Gartner per unit 2 $2,000 $4,000 $0 $4,000 $4,000 $4,000 $4,000 $4,000
(select row and insert additional rows here as needed) per unit $0 $0 $0 $0 $0 $0 $0
SCRAP PRODUCED
{type #1} Gartner per unit 10 $700 $7,000 $0 $7,000 $7,000 $7,000 $7,000 $7,000
{type #2} Gartner per unit 12 $600 $7,200 $0 $7,200 $7,200 $7,200 $7,200 $7,200
{type #3} Gartner per unit 7 $100 $700 $0 $700 $700 $700 $700 $700
(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} Gartner per unit 8 $1,000 $8,000 $0 $8,000 $8,000 $8,000 $8,000 $8,000
{product #2} Gartner per unit 10 $2,500 $25,000 $0 $25,000 $25,000 $25,000 $25,000 $25,000
{product #3} Gartner per unit 15 $1,000 $15,000 $0 $15,000 $15,000 $15,000 $15,000 $15,000
(select row and insert additional rows here as needed) per unit $0 $0 $0 $0 $0 $0 $0
DAMAGED GOODS
{product #1} Gartner per unit 12 $300 $3,600 $0 $3,600 $3,600 $3,600 $3,600 $3,600
{product #2} Gartner per unit 10 $100 $1,000 $0 $1,000 $1,000 $1,000 $1,000 $1,000
{product #3} Gartner per unit 5 $200 $1,000 $0 $1,000 $1,000 $1,000 $1,000 $1,000
(select row and insert additional rows here as needed) per unit $0 $0 $0 $0 $0 $0 $0
STORAGE COSTS
{product #1} Gartner per unit 20 $600 $12,000 $0 $12,000 $12,000 $12,000 $12,000 $12,000
{product #2} Gartner per unit 15 $500 $7,500 $0 $7,500 $7,500 $7,500 $7,500 $7,500
{product #3} Gartner per unit 10 $1,000 $10,000 $0 $10,000 $10,000 $10,000 $10,000 $10,000
(select row and insert additional rows here as needed) per unit $0 $0 $0 $0 $0 $0 $0
OTHER
{product #1} Gartner per unit 13 $200 $2,600 $0 $2,600 $2,600 $2,600 $2,600 $2,600
{product #2} Gartner per unit 12 $150 $1,800 $0 $1,800 $1,800 $1,800 $1,800 $1,800
(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} Gartner per unit 7 $1,000 $7,000 12% $0 $6,160 $6,160 $6,160 $6,160 $6,160
{product #2} Gartner per unit 8 $2,500 $20,000 10% $0 $18,000 $18,000 $18,000 $18,000 $18,000
{product #3} Gartner per unit 15 $500 $7,500 15% $0 $6,375 $6,375 $6,375 $6,375 $6,375
(select row and insert additional rows here as needed) per unit $0 $0 $0 $0 $0 $0 $0
DEBT COLLECTION COSTS
{product #1} Gartner per unit 14 $1,000 $14,000 20% $0 $11,200 $11,200 $11,200 $11,200 $11,200
{product #2} Gartner per unit 12 $1,200 $14,400 22% $0 $11,232 $11,232 $11,232 $11,232 $11,232
{product #3} Gartner per unit 17 $1,500 $25,500 18% $0 $20,910 $20,910 $20,910 $20,910 $20,910
(select row and insert additional rows here as needed) per unit $0 $0 $0 $0 $0 $0 $0
OTHER
{product #1} Gartner per unit 20 $230 $4,600 16% $0 $3,864 $3,864 $3,864 $3,864 $3,864
{product #2} Gartner per unit 9 $140 $1,260 14% $0 $1,084 $1,084 $1,084 $1,084 $1,084
(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} Gartner per unit 1 $500,000 $500,000 $0 $500,000 $500,000 $500,000 $500,000 $500,000
{product #2} Gartner per unit 1 $300,000 $300,000 $0 $300,000 $300,000 $300,000 $300,000 $300,000
(select row and insert additional rows here as needed) per unit $0 $0 $0 $0 $0 $0 $0
LOAN INTEREST
{product #1} Gartner per unit 1 $50,000 $50,000 10% $0 $50,000 $50,000 $50,000 $50,000 $50,000
{product #2} Gartner per unit 1 $30,000 $30,000 10% $0 $30,000 $30,000 $30,000 $30,000 $30,000
(select row and insert additional rows here as needed) per unit $0 10% $0 $0 $0 $0 $0 $0
PENALTIES
{product #1} Gartner per unit 1 $200,000 $200,000 $0 $200,000 $200,000 $200,000 $200,000 $200,000
{product #2} Gartner per unit 1 $100,000 $100,000 $0 $100,000 $100,000 $100,000 $100,000 $100,000
(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} Gartner per unit 50 $500 $25,000 $0 $25,000 $25,000 $25,000 $25,000 $25,000
{product #2} Gartner per unit 20 $400 $8,000 $0 $8,000 $8,000 $8,000 $8,000 $8,000
(select row and insert additional rows here as needed) per unit $0 $0 $0 $0 $0 $0 $0
OTHER
{product #1} Gartner per unit 30 $70 $2,100 $0 $2,100 $2,100 $2,100 $2,100 $2,100
{product #2} Gartner per unit 45 $30 $1,350 $0 $1,350 $1,350 $1,350 $1,350 $1,350
(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} Gartner per unit 1500 $400 $600,000 $0 $600,000 $600,000 $600,000 $600,000 $600,000
{product #2} Gartner per unit 2000 $8,000 $16,000,000 $0 $16,000,000 $16,000,000 $16,000,000 $16,000,000 $16,000,000
{product #3} Gartner per unit 1000 $1,000 $1,000,000 $0 $1,000,000 $1,000,000 $1,000,000 $1,000,000 $1,000,000
(select row and insert additional rows here as needed) per unit $0 $0 $0 $0 $0 $0 $0
TOTAL DIRECT BENEFITS $0 $19,057,379 $19,057,379 $19,057,379 $19,057,379 $19,057,379
TOTAL BENEFIT OF OWNERSHIP $737,290 $19,117,709 $19,117,709 $19,117,709 $19,117,709 $19,117,709

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