GUIDELINES
GENERAL
Definition: A budget spreadsheet is used by organizations to calculate the cost or budget associated with the development of a
website or other project along with all of the associated components.
Objective: The Purpose of this template is to account for all the components and the associated costs for developing a website.
The Spreadsheet:
The spreadsheet has a number of different fields that must be completed to arrive at the total cost of the website's development. The
fields of this excel sheet are prepopulated with dummy data and the user is requested to add the item description and the associated
cost as per their requirements. The worksheets in this excel file have been grouped under the following categories:
1. Summary Sheet
2. Table A - Selection Process
3. Table B - COTS
4. Table C - Hardware & Networking
5. Table D - Hosting & Data Cost
6. Table E - Implementation Cost
7. Table F - Project Team & Office
8. Table G - Training Cost
9. Table H - Miscellaneous Cost
Procedure to complete the spreadsheet:
1. Before entering anything into the spreadsheet, make a list of the components/item description that will be part of your project. All
website development projects may not need hardware or networking components. `
2. Populate the fields in tables A through H.
3. Based on the values filled under tables A through H, the Summary Sheet tab will automatically update.
4. Cell B13 in the Summary Sheet tab includes a contingency of 10%, but users should adjust it to match their requirements.
5. Please note that any tax calculations are not included while calculating the cost, so users should add tax as per their requirements.
© Copyright 2011 Docstoc Inc.
Project Name: Project
Summary Sheet
S.# Item Description Total Cost
1 Table A - Selection Process $68,950.00
2 Table B - COTS $6,050.00
3 Table C - Hardware & Networking $68,950.00
4 Table D - Hosting & Data Cost $5,210.00
5 Table E - Implementation Cost $55,500.00
6 Table F - Project Team & Office $11,000.00
7 Table G - Training Cost $7,000.00
8 Table H - Miscellenous Cost $11,600.00
Total Cost $222,660.00
9 Continegency on Total Cost - 10 % $22,266.00
Total Project Cost $244,926.00
© Copyright 2011 Docstoc Inc.
Table A - Selection Process
S.# Project Expenditure Heads Rate ( $/Hrs) Total Total Rate
Number of
Hrs
1 Internal Staff Costs/ Resources
1.1 Information System (IS) Department $60.00 20 $1,200.00
1.2 Procurement Department $60.00 50 $3,000.00
1.3 User Departments $50.00 100 $5,000.00
1.4 Other Departments $35.00 100 $3,500.00
2 Consultancy Services $150.00 200 $30,000.00
3 Legal Services $150.00 100 $15,000.00
4 Any Other Services $25.00 10 $250.00
5 Preparation of RFP $100.00 50 $5,000.00
6 Bid Process Management $120.00 50 $6,000.00
Total Cost for Selection Process $68,950.00
© Copyright 2011 Docstoc Inc.
Table B - Commercial off the Shelf Software (COTS)
S.# Item Description Licensing Policy Base Rate Per
Unit
1 Operating System Insert Licensing Policy $350.00
2 Portal Framework Insert Licensing Policy $1,000.00
3 Database Insert Licensing Policy $1,000.00
4 Additional Software/Applications Insert Licensing Policy $100.00
5 Security Applications Insert Licensing Policy $250.00
6 Integration with Accounting Package Insert Licensing Policy $1,000.00
Total Cost for COTS
© Copyright 2011 Docstoc Inc.
No of Total Cost
Units
2 $700.00
1 $1,000.00
2 $2,000.00
1 $100.00
5 $1,250.00
1 1000
$6,050.00
© Copyright 2011 Docstoc Inc.
Table C - Hardware & Networking
S.# Item Description Make Model Base Rate Per
Unit
1 Web Servers OEM Name Model No $2,000.00
2 Application Server OEM Name Model No $1,500.00
3 Database Server OEM Name Model No $1,000.00
4 Back Up Server OEM Name Model No $100.00
5 EMS Server OEM Name Model No $250.00
6 Storage OEM Name Model No $15,000.00
7 Routers OEM Name Model No $5,000.00
8 Switches OEM Name Model No $1,000.00
9 Antivirus Server OEM Name Model No $2,000.00
10 Authentication Server OEM Name Model No $2,000.00
11 Audit Log Server OEM Name Model No $2,000.00
12 Load Balancer OEM Name Model No $4,000.00
13 IPS/IDS OEM Name Model No $2,000.00
14 Application Proxy Firewall OEM Name Model No $1,400.00
15 Cabling, LAN, WAN or other network OEM Name Model No $25.00
16 Racks OEM Name Model No $800.00
17 Leased or Dedicate Lines OEM Name Model No $200.00
18 UPS OEM Name Model No $400.00
19 Additional Components OEM Name Model No $1,000.00
Total Cost for COTS
© Copyright 2011 Docstoc Inc.
No of Total Cost
Units
2 $4,000.00
1 $1,500.00
2 $2,000.00
1 $100.00
5 $1,250.00
1 $15,000.00
2 $10,000.00
6 $6,000.00
1 $2,000.00
1 $2,000.00
1 $2,000.00
1 $4,000.00
1 $2,000.00
1 $1,400.00
100 $2,500.00
1 $800.00
10 $2,000.00
1 $400.00
10 $10,000.00
$68,950.00
© Copyright 2011 Docstoc Inc.
Table D - Hosting & Data Cost
S.# Item Description Base Rate Per No of Total Cost
Unit Units
1 Domain Name Registration $10.00 1 $10.00
2 Hosting $250.00 1 $250.00
3 Email Hosting $20.00 100 $2,000.00
4 SSL Certificate $500.00 1 $500.00
5 Payment Gateway Set Up Charges $100.00 1 $100.00
6 Social Media Management Packages $350.00 1 $350.00
7 Data Clean Up/De Duplication $1,000.00 1 $1,000.00
8 Data Archiving $1,000.00 1 $1,000.00
Total Hosting & Data Cost $5,210.00
© Copyright 2011 Docstoc Inc.
Table E - Implementation Cost
S.# Project Team Rate No of Total Cost
Hours
1 Project Manager $200.00 50 $10,000.00
2 Project Leader $150.00 120 $18,000.00
3 Systems Analysts $80.00 50 $4,000.00
4 Programmers $80.00 200 $16,000.00
5 Systems Testers $80.00 50 $4,000.00
6 Vendor Consultants $250.00 10 $2,500.00
7 Additional Team Resources (e.g., $1,000.00 1 $1,000.00
contractors, temporary staff, etc.)
Total Implementation Cost $55,500.00
© Copyright 2011 Docstoc Inc.
Table F - Project Team and Office Cost
S.# Project Team Rate No of Total Cost
Units
1 Temporary office accommodation $1,000.00 1 $1,000.00
2 Furniture, stationery and supplies $1,000.00 1 $1,000.00
3 Additional telephones and lines $1,000.00 1 $1,000.00
4 Project tools (e.g., project management software, testing $1,000.00 1 $1,000.00
programs, etc.)
6 Administrative support $2,000.00 1 $2,000.00
7 Communications costs $1,000.00 1 $1,000.00
8 Video teleconferencing $1,000.00 1 $1,000.00
9 Printing (e.g., user manuals) $1,000.00 1 $1,000.00
10 Project information / education / marketing materials $1,000.00 1 $1,000.00
11 Project team or user recognition / awards $1,000.00 1 $1,000.00
Total Project Team & Office Cost $11,000.00
© Copyright 2011 Docstoc Inc.
Table G - Training Cost
S.# Item Description Rate No of Total Cost
Units
1 Technical training for implementation team (by vendor) $1,000.00 1 $1,000.00
2 Training key users (by vendor) $1,000.00 1 $1,000.00
3 Temporary internal training facilities $1,000.00 1 $1,000.00
4 Training remainder of users (internally or by vendor) $1,000.00 1 $1,000.00
6 Training materials $2,000.00 1 $2,000.00
7 Travel and expenses to attend training $1,000.00 1 $1,000.00
Total Cost of Training $7,000.00
© Copyright 2011 Docstoc Inc.
Table H - Miscellaneous Cost
S.# Item Description Rate No of Total Cost
Units
1 Quality assurance $1,000.00 1 $1,000.00
2 Internal audit review(s) of new system(s) $1,000.00 1 $1,000.00
3 Project steering group $1,000.00 1 $1,000.00
4 Decommissioning of legacy systems $100.00 1 $100.00
5 $500.00 1 $500.00
Networking with other organizations, who are using /
implementing the same system(s) - travel and expenses costs
6 Attending conferences, software vendor user groups, $2,500.00 2 $5,000.00
networking, meetings - fees, travel and expenses costs
7 Additional heat, air conditioning, light, power for project $1,000.00 1 $1,000.00
implementation and ongoing live running
8 Other allocated business costs $2,000.00 1 $2,000.00
Total Miscellaneous Cost $11,600.00
© Copyright 2011 Docstoc Inc.