; Website Budget Template
Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out
Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

Website Budget Template

VIEWS: 771 PAGES: 12

This Website Budget Template can help a company plan for all of the costs associated with developing a website. This form consists of the following worksheets: budget summary, selection process, commercial off the shelf software, hardware and networking, hosting and data cost, implementation cost, project team and office, training cost, and miscellaneous cost. This form comes with instructions on how to populate each worksheet. In addition to its budgeting function, by making a list of all costs and expenditures required to develop a website, this budget form can help project managers create a task lists for all necessary steps needed to complete the website.

More Info
  • pg 1
									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 2013 Docstoc Inc.
Project Name: <XYZ> 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 - Miscellaneous Cost               $11,600.00
       Total Cost                               $222,660.00
   9   Contingency on Total Cost - 10 %          $22,266.00

       Total Project Cost                       $244,926.00




© Copyright 2013 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.
cstoc Inc.
								
To top