Summary of the budget by icecube

VIEWS: 30 PAGES: 18

									Kabwe Project Budget Plan
Summary of the budget

   PS: All the figures in this page are generated from the figure of budget and formula were set up for all box, except the grey one.

   Set-up cost and ongoing cost allocation

                                                                             Stage 1                     Stage 2

       Set up cost
       - Building and construction                                              654,312.93                        -
       - Personnel                                                                     -                          -
       - Furniture                                                                2,100.00                  24,000.00
       - IT equipment                                                            12,550.00                   5,100.00
       - Medical requirements                                                          -                   300,000.00
       - Transport                                                                     -                    90,000.00
       - Others                                                                   2,500.00                        -

       Total set up cost                                                        671,462.93                 419,100.00

       Ongoing cost
       - Building and construction                                                     -                          -
       - Personnel                                                              215,000.00                 440,000.00
       - Furniture                                                                4,800.00                        -
       - IT equipment                                                             2,500.00                        -
       - Medical requirements                                                          -                   300,000.00
       - Transport                                                                     -                     8,300.00
       - Others                                                                  15,800.00                   6,000.00

       Total ongoing cost                                                       238,100.00                 754,300.00

       Grand total cost                                                         909,562.93               1,173,400.00



   Pro-forma income statement

                                                                             Stage 1                     Stage 2

       Revenue                                                                          -                          -
       Cost of sales                                                                    -                          -

       Gross profit                                                                     -                          -

       Operating expense
       - Ongoing cost newly added at current stage             1                238,100.00                 754,300.00
       - Ongoing cost started from stage 1                     2                       -                   238,100.00
       - Ongoing cost started from stage 2                     2                       -                          -
       - Set up cost (Other than fixed asset)                                     2,500.00                        -
       - Depreciation for current stage                        3                       -                          -
       Total operating expense                                                  240,600.00                 992,400.00

       (Profit)/Loss before tax                                                 240,600.00                 992,400.00

       Taxation                                                                         -                          -

       (Profit)/Loss after tax                                                  240,600.00                 992,400.00



   Pro-forma balance sheet

                                                                             Stage 1                     Stage 2

       Fixed asset - Stage 1                                   4                668,962.93                 668,962.93
    Fixed asset - Stage 2                         4               -        419,100.00
    Total cost of fixed asset                              668,962.93    1,088,062.93

    Accumulated depreciation                                       -               -

    Net book value of fixed asset                          668,962.93    1,088,062.93

    Cash on hand                                                   -               -

    Total asset                                            668,962.93    1,088,062.93

    Current liabilities                           7       (909,562.93)   (2,321,062.93)

    Total liabilities                                     (909,562.93)   (2,321,062.93)

    Net Asset                                             (240,600.00)   (1,233,000.00)

    Retained (earning)/loss brought forward
    from previous stage                           5               -        240,600.00
    (Profit)/loss for current stage               6        240,600.00      992,400.00

    Total equity                                           240,600.00    1,233,000.00

    Control                                                        -               -



Pro-forma Cashflow Statement

                                                         Stage 1         Stage 2

    (Profit)/Loss after tax                      A         240,600.00      992,400.00
    Add: Depreciation                            B                -               -

    Net change in balance sheet items            C        (909,562.93)   (1,411,500.00)

    Total operating cashflow                   D=A+B+C    (668,962.93)    (419,100.00)

    Purchase of fixed asset                      E         668,962.93      419,100.00

    Total investing cashflow                               668,962.93      419,100.00

    Total financing cashflow                      F                -               -

    Net change in cash                         G=D+E+F             -               -

    Beginning balance                                              -               -

    Ending balance                                                 -               -



Total amount of cash required for each stage

                                                         Stage 1         Stage 2

    Cash for set up cost                                   671,462.93      419,100.00
    Cash for ongoing cost - Stage 1                        238,100.00      238,100.00
    Cash for ongoing cost - Stage 2                               -        754,300.00
    Cash for ongoing cost - Stage 3                               -               -

    Total cash required                                    909,562.93    1,411,500.00



Notes to pro-forma financial statement
1. Ongoing cost newly added at current stage
   - The amount should be the same as total ongoing cost of each stage.

2. Ongoing cost started from stage 1 and 2
   - These amount represented some ongoing cost were started to use from stage before and kept on as operating expense in current stage.

3. Depreciation for current stage
   - This amount represented the depreciation charge for each stage.

4. Fixed asset of stage 1 and 2
   - This balance represented the cost of fixed asset, such as building, furniture, vehicles, and its related expense. This should be equal to total set up cos

5. Retained earning/(loss) brought forward from previous stage
   - This balance should be equal to the total equity of previous stage.

6. Profit/(loss) for current stage
   - This balance should be equal to the profit after tax and represented the total profit/(loss) of current stage.

7. Current liabilities
   - This balance represented the shortage of cash. In order to eliminate the liabilities, amount should be obtained in different stage and the amount is sho
p for all box, except the grey one.




                                  Stage 3            Total



                                               -      654,312.93
                                               -             -
                                               -       26,100.00
                                               -       17,650.00
                                               -      300,000.00
                                               -       90,000.00
                                               -        2,500.00

                                               -     1,090,562.93



                                              -              -
                                        55,000.00     710,000.00
                                              -         4,800.00
                                              -         2,500.00
                                              -       300,000.00
                                              -         8,300.00
                                              -        21,800.00

                                        55,000.00    1,047,400.00

                                        55,000.00    2,137,962.93




                                  Stage 3            Total

                                               -              -
                                               -              -

                                               -              -



                                         55,000.00   1,047,400.00
                                        238,100.00     476,200.00
                                        754,300.00     754,300.00
                                               -         2,500.00
                                               -
                                      1,047,400.00   2,280,400.00

                                      1,047,400.00   2,280,400.00

                                               -

                                      1,047,400.00   2,280,400.00




                                  Stage 3

                                       668,962.93
  419,100.00
1,088,062.93

          -

1,088,062.93

          -

1,088,062.93

(3,368,462.93)   Please change this row once budget being updated

(3,368,462.93)

(2,280,400.00)



1,233,000.00
1,047,400.00

2,280,400.00

          -




Stage 3

1,047,400.00
         -

(1,047,400.00)

          -

          -

          -

          -

          -

          -

          -




Stage 3                 Total

         -             1,090,562.93
  238,100.00             714,300.00
  754,300.00           1,508,600.00
   55,000.00              55,000.00

1,047,400.00           3,368,462.93
pt on as operating expense in current stage.




related expense. This should be equal to total set up cost with excluding the cost of "others".




ould be obtained in different stage and the amount is shown as above in "Total amount of cash required for each stage".
Kabwe Project Budget Plan
Assumption for the budget

  Transport

      - The cost of the bus was based on the estimated price for a van with capacity is 16 people
      - The cost of vehicle maintainence cost was based on the estimated cost of USD125 per month

  Personnel

      - The personnel was based on the construction plan (posted by Lynley) and the finished task, list of staff needed for the CTC centre

  Building and construction

      - The cost of construction was based on the construction budget attached

  Furniture

      - The estimation number of office chairs was 60 and each chair is USD11.
      - The number of table was based on the estimation of number of chairs, 3 chairs for 1 table. And 10 tables were used for other use. The cost of table is US
      - The number of other furniture is just a lump-sum estimation.

  IT Equipment

      - Estimation of 10 PCs was used for internet connection
staff needed for the CTC centre




tables were used for other use. The cost of table is USD55.
                                                                            Kabwe Budget Plan

        Kabwe Project Budget Plan
                                                                                         Set Up / Ongoing           Estimated             Estimated               Estimated
        Category                                                   Stage
                                                                                         Cost                        Quantity            Cost per Unit             Subtotal

        A.Building & Construction
          Salary for construction team                              1                      Set up                      1                      499,459.00             $499,459.00
          Purchase of land                                          1                      Set up                      1                       20,000.00              $20,000.00
          Other construction fee                                    1                      Set up                      1                      134,853.93             $134,853.93
          Building Costs Total                                                                                                                                      $654,312.93
          Stage cost - set up                                       $       654,312.93                                                                              $654,312.93
          Percentage                                                             100%

        B.Personnel
          Driver                                                    3                     Ongoing                      1                       $15,000.00             $15,000.00
          ART Physician                                             2                     Ongoing                      1                       $50,000.00             $50,000.00
          Director                                                  1                     Ongoing                      1                       $50,000.00             $50,000.00
          Administrator                                             1                     Ongoing                      5                       $25,000.00            $125,000.00
          Receptionist/ clerk                                       1                     Ongoing                      1                       $20,000.00             $20,000.00
          Lab.Technician                                            2                     Ongoing                      1                       $35,000.00             $35,000.00
          Doctor                                                    2                     Ongoing                      2                       $50,000.00            $100,000.00
          Counsellors                                               2                     Ongoing                      4                       $30,000.00            $120,000.00
          Nurses                                                    2                     Ongoing                      4                       $25,000.00            $100,000.00
          General cleaners                                          1                     Ongoing                      2                       $10,000.00             $20,000.00
          Out reach Workers                                         3                     Ongoing                      2                       $20,000.00             $40,000.00
          Researcher                                                2                     Ongoing                      1                       $35,000.00             $35,000.00
          Personnel Costs Total                                                                                                                                     $710,000.00
          Stage cost - ongoing                                      $       215,000.00 $        440,000.00 $           55,000.00                                    $710,000.00
          Percentage                                                              30%                 62%                    8%

        C.Furniture
          Office Chairs                                             1                     Set Up                       60                           $7.50                 $450.00
          Office Tables                                             1                     Set Up                       30                          $55.00               $1,650.00
          Plastic chairs                                            2                     Set Up                      1,000                        $11.00              $11,000.00
          Other Office Furniture (to include: medical furniture,
                                                                    2                     Set Up                       1                       $13,000.00              $13,000.00
          tables, desks, tables, cabinets, shelving etc)
          Water supply                                              1                     Ongoing                      1                        $1,800.00               $1,800.00
          Electricity supply                                        1                     Ongoing                      1                        $3,000.00               $3,000.00

          Furniture Costs Total                                                                                                                                      $30,900.00
          Stage cost - set up                                      $          2,100.00 $            24,000.00   $                -   $                    -   $        26,100.00
          Stage cost - ongoing                                     $          4,800.00 $                    -   $                -   $                    -   $         4,800.00
          Percentage                                                              22%                    78%                    0%                       0%   $        30,900.00

        D.IT

          IT Equipment
             Penitum 4 Pc's                                             1                   Set Up                     10                         $700.00               $7,000.00
             Laptop                                                     2                   Set Up                      1                       $1,800.00               $1,800.00
             Laptop for Director                                        1                   Set Up                      1                       $1,800.00               $1,800.00
Confidential Proprietary                                                                                                                                               Page 9
                                                             Kabwe Budget Plan
                                                                        Set Up / Ongoing              Estimated             Estimated           Estimated
        Category                                    Stage
                                                                        Cost                           Quantity            Cost per Unit         Subtotal
            HP Laserjet printer                          1                  Set   Up                     2                          $150.00             $300.00
            Scanner                                      2                  Set   Up                     2                          $150.00             $300.00
            Photocopier                                  1                  Set   Up                     1                          $850.00             $850.00
            29" TV and video recorder                    2                  Set   Up                     1                        $1,000.00           $1,000.00
            Projector Unit                               2                  Set   Up                     1                        $2,000.00           $2,000.00
              IT Equipment Costs Subtotal                                                                                                            $15,050.00

          Telephone
           Installation                                  1                  Set Up                       2                          $500.00           $1,000.00
           Telephones                                    1                  Set Up                       2                          $800.00           $1,600.00
           Annual cost - phones and internet             1                  Ongoing                      1                        $2,500.00           $2,500.00

              Telephone Costs Subtotal                                                                                                                $5,100.00

        IT Costs Total                                                                                                                             $20,150.00
          Stage cost - Set up                       $         12,550.00 $              5,100.00   $                -   $                    -       $17,650.00
          Stage cost - Ongoing                      $          2,500.00 $                     -   $                -   $                    -        $2,500.00
          Percentage                                               75%                     25%                    0%                       0%       $20,150.00
        E.Medical Requirements
          Drugs and Medicinial Supplies
          Drugs and Medicinial Supplies              2                    Ongoing                         1                    $300,000.00          $300,000.00
             Drugs and Medicine Cost Subtotal                                                                                                       $300,000.00

          Medical & Laundry Requirements
          Medical & Laundry Requirements             2                    Set Up                          1                    $300,000.00          $300,000.00
             Medical Equipment Cost Subtotal                                                                                                        $300,000.00

          Medical Requirements Costs Total                                                                                                        $600,000.00
          Stage cost - set up                        $               - $          300,000.00      $                -   $                    -      $300,000.00
          Stage cost - ongoing                       $               - $          300,000.00      $                -   $                    -      $300,000.00
          Percentage                                                0%                 100%                       0%                       0%      $600,000.00
        F.Transport
          Outreach bus                               2                    Set Up                          1                      $40,000.00         $40,000.00
          Fuel                                       2                    Ongoing                         1                       $4,500.00          $4,500.00
          Vehicle Insurance                          2                    Ongoing                         1                       $1,100.00          $1,100.00
          Tyres                                      2                    Ongoing                         3                         $400.00          $1,200.00
          Medical facilities on the bus              2                    Set Up                          1                      $50,000.00         $50,000.00
          Maintenance Costs                          2                    Ongoing                         1                       $1,500.00          $1,500.00
          Transport Costs Total                                                                                                                    $98,300.00
          Stage cost - set up                        $               - $           90,000.00      $                -   $                    -       $90,000.00
          Stage cost - ongoing                       $               - $            8,300.00      $                -   $                    -        $8,300.00
          Percentage                                                0%                 100%                       0%                       0%       $98,300.00

        G.Other
          Communication - air time                   1                    Ongoing                         1                         $800.00             $800.00
          Marketing and promotion                    1                    Set up                          1                       $2,500.00           $2,500.00
          Part-time Outreach Officers - allowance    2                    Ongoing                         3                       $2,000.00           $6,000.00
Confidential Proprietary                                                                                                                             Page 10
                                                      Kabwe Budget Plan
                                                                 Set Up / Ongoing           Estimated             Estimated            Estimated
        Category                              Stage
                                                                 Cost                        Quantity            Cost per Unit          Subtotal
         Independent auditor (annual audit)    1                   Ongoing                      1                      $15,000.00          $15,000.00
        Other Costs Total                                                                                                                 $24,300.00
         Stage cost - Set up                  $         2,500.00 $                  -   $                -   $                    -         $2,500.00
         Stage cost - Ongoing                 $        15,800.00 $           6,000.00   $                -   $                    -        $21,800.00
         Percentage                                         75%                  25%                    0%                       0%        $24,300.00


                                                              Estimated Kabwe Project Total                                           $2,137,962.93




Confidential Proprietary                                                                                                                    Page 11
                           Kabwe Budget Plan



         Estimated %



                   76%
                    3%
                   21%
                  31%




                    2%
                    7%
                    7%
                   18%
                    3%
                    5%
                   14%
                   17%
                   14%
                    3%
                    6%
                    5%
                  33%




                    1%
                    5%
                   36%
                   42%
                    6%
                   10%

                   1%




                    35%
                      9%
                      9%
Confidential Proprietary                       Page 12
                           Kabwe Budget Plan

          Estimated %

                     1%
                     1%
                     4%
                     5%
                    10%



                     5%
                     8%
                    12%



                    1%




                   28%




                    41%
                     5%
                     1%
                     1%
                    51%
                     2%
                    5%




                     3%
                    10%
                    25%
Confidential Proprietary                       Page 13
                           Kabwe Budget Plan

          Estimated %

                    62%
                    1%




                100%




Confidential Proprietary                       Page 14
Kabwe Project Budget Plan
Marketing budget plan



                                                           Marketing Budget Plan




                                           F.Transport
                                               5%        G.Other
                                                           1%



                  E.Medical Requirements
                           28%
                                                                                     A.Building & Construction
                                                                                                31%




                                                                                                                 A.Building & Construction
                        D.IT                                                                                     B.Personnel
                        1%
                                                                                                                 C.Furniture
                                                                                                                 D.IT
                                                                                                                 E.Medical Requirements
                                                                                                                 F.Transport
                                                                                                                 G.Other
                                      C.Furniture                      B.Personnel
                                         1%                               33%
COUNSELLING, TESTING and CARE CENTER BUILDING
YMCA Kabwe, Zambia


BUDGETARY COST ESTIMATE
                                                                                                  in US $
ITEM NO.                        SCOPE OF WORK                       QUANTITY     UNIT      UNIT COST    AMOUNT
I.               Direct Cost
A.               Pre-Construction
     A.1           Preparatory Work
      A.1.1          Project Management Team
         a.            Project Manager (Expat)                         9       man-month     4,500.00   40,500.00
         b.            Construction Superintendent                     9       man-month     3,000.00   27,000.00
         c.            Cost/Planning Engineer                          9       man-month     2,500.00   22,500.00
         d.            Document Controller/Coordinator                 9       man-month     2,500.00   22,500.00
         e.            Field/Material Engineer                         9       man-month     2,500.00   22,500.00
          f.           Design & Construction Consultants               4       man-month     3,800.00   15,200.00
     A.2             Engineering Calculation & Specification           1          lot        2,500.00    2,500.00
     A.3             Detailed Drawings                                 1          lot        3,000.00    3,000.00
     A.4             Building Permit                                   1          lot        1,500.00    2,000.00
     A.5             Occupancy Permit                                  1          lot        1,000.00    1,200.00
     A.6             Others Permits (please specify)                   1          lot          500.00    1,000.00
B.               Construction Phase
     B.1           General Requirment
      B.1.1          Mobilization                                      1          lot        5,000.00    5,000.00
      B.1.2          Temporary Facilities
         a.            Field Office                                   60          m2           220.00   13,200.00
         b.            Staff House/Bunkhouse                          150         m2           220.00   33,000.00
         c.            Warehouse                                      200         m2           220.00   44,000.00
     B.2             Safety, Health & Environment Program              1          lot        5,000.00    5,000.00
     B.3             Removal and Disposal of excess materials          1          lot        8,000.00    8,000.00
     B.4             Demobilization                                    1          lot        5,000.00    5,000.00
     B.5           Site Development
           a.         Area Drainage System                            200          lm           25.00    5,000.00
           b.         Septic Vault (Three chamber)                    60          m3            80.00    4,800.00
           c.         Road/Walkway Network (Macadam type)             675         m2            15.00   10,125.00
           d.         Water Supply System (incldg deep well/pump)      1           lot       3,000.00    3,000.00
           e.         Power and Lighting Distribution System           1           lot       5,000.00    5,000.00
            f.        Low-cost Incinerator                             1          unit       2,000.00    2,000.00
     B.6           Building (total area = 747.012 m2)
           a.        Waiting Room                                      54         m2           243.00   13,122.00
                                                                                    2
           b.        Chapel                                            45         m            243.00   10,935.00
           c.        Meeting Room                                      33         m2           243.00    8,019.00
           d.        Library                                           54         m2           243.00   13,122.00
           e.        Councelor                                         36         m2           243.00    8,748.00
            f.       Dispensary                                        30         m2           243.00    7,290.00
           g.        Doctor                                            30         m2           243.00    7,290.00
           h.        Program                                           18         m2           243.00    4,374.00
            i.       Staff                                             36         m2           243.00    8,748.00
            j.       Atrium                                            90         m2           243.00   21,870.00
           k.        Director                                          36         m2           243.00    8,748.00
            l.       Nurse                                             18         m2           243.00    4,374.00
           m.        Admin                                             18         m2           243.00    4,374.00
           n.        Clinical part                                     36         m2           243.00    8,748.00
           o.        Storage                                           27         m2           243.00    6,561.00




                                                                                                              nabuur.com
                                                                                       3
      p.        Toilet                                                     57        m               300.00      17,100.00
                                                                                       4
      q.        Reception & Corridor                                       177       m               243.00      43,011.00
                                                                                           Total Direct Cost   499,459.00
II.        Indirect Cost
      A.     Overhead, Miscellaneous & Contingencies                                 5%                         24,972.95
      B.     Management Reserve for change orders                                   10%                         49,945.90
      C.     Taxes
      D.     Escalation Allowance                                           12      month                       59,935.08

                                                                                      Total Indirect Cost      134,853.93

                                                                                      Total Budget Cost        634,312.93

*NOTES :
           1. Cost per unit of general requirement, site development and building
           includes all necessary manpower, material,supervision, equipment and
           contractor's indirect cost.


           2. Estimates is based on Kasman's drawing scheme.


           3. Conversion rate: USD1 = ZMK 4,000




                                                                                                                       nabuur.com
nabuur.com

								
To top