Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out

DKT International - DKT VIETNAM

VIEWS: 0 PAGES: 18

									DKT International

                                     KFW/VAAC funded project: Preventing HIV/AIDS in Vietnam
                                               For the period from January 1st to March 31st 2007

                                                        Social Marketing Activities


                                                                          Previous Period
   Item No                   Description                 Project year 1     (Jul-Dec 06)        Actual YTD         Up to date         Variance

      1        Expense for Condom Social Marketing       $      426,186   $       135,298   $         61,312   $        196,610   $        229,577

      2        Revenue from condom sold                  $      248,264   $       196,719   $         84,840   $        281,559   $         (33,295)
               DKT Headquarter's contribution (office
      3        operation and office staff cost)

Notes
*) DKT will use its own money and being reimbursed by collection cash from condom sold
*) Cost of the director is not charged to this project, it is coverred by DKT headquarter

Date:
Prepared by:                                                              Checked by :                                            Approval by :




Nguyen Phuong Hang                                                        Ha Thi Luc                                              Gopi Gopalakrishnan
Financial officer                                                         General Manager                                         Country Manager
DKT International

KFW/VAAC funded project: Preventing HIV/AIDS in Vietnam
For the period from January 1st to March 31st 2007

Social Marketing Activities

 Expenditure

                  BUDGET CATEGORY                                   Plan 2007                         Actual this period                       Expenses YTD                Expense in previous periods            Expenses Up to date                     Variance

         I        Distribution

I.1               Pharmacies                          $   113,619                              $   37,397                             $37,397                          $      71,075                         $108,472                           $76,223

I.2               NTOs                                $    61,728                              $     922                              $   922                          $          16                         $    938                           $60,806

                  Total Distribution                                             $   175,347                          $     38,318                         $ 38,318                             $ 71,091                         $ 109,409                           $ 137,029

         II        Advertising, promotion, IEC

II.1              General population

II.1.1            Mass media                          $    43,625                              $    3,249                             $ 3,249                          $       1,664                         $   4,913                          $40,376

II.1.2            Merchandized & PoP materials        $    19,625                              $    1,003                             $ 1,003                          $      27,785                         $ 28,788                           $18,622

                  Sub-total                                         $   63,250                              $ 4,252                              $ 4,252                                       $ 29,449                          $ 33,701                 $58,998

II.2              Targeted groups

II.2.1            Activities in 21 provinces          $    85,201                              $    2,881                             $ 2,881                          $           -                         $   2,881                          $82,320

II.2.2            Monitoring & Evaluation             $        -                               $       -                              $    -                           $           -                         $      -                           $    -

                  Sub-total                                         $   85,201                              $ 2,881                              $ 2,881                                        $        -                       $      2,881             $82,320

                  Total Advertising, promotion, IEC                              $   148,451                          $      7,133                         $   7,133                           $ 29,449                          $ 36,582                            $ 141,318

         III      Project related expense

III.1             Staff cost                          $    51,842                              $    7,436                             $ 7,436                          $      13,710                         $ 21,146                           $44,406

III.2             Office operating cost               $    36,080                              $    7,979                             $ 7,979                          $      20,090                         $ 28,069                           $28,101

III.3             Travel                              $    14,467                              $     445                              $   445                          $         958                         $   1,403                          $14,022

                  Total III                                                      $   102,389                          $     15,860                         $ 15,860                             $ 34,758                         $ 50,618                            $ 86,529


                  TOTAL DKT COST                                                 $   426,186                          $     61,312                         $ 61,312                            $ 135,298                         $ 196,610                           $ 364,876

                                                                                     477,329                                   -                                                                                                 $ 196,610                           $ 364,875
Prepared by                                                                                                               61,311.53




Nguyen Phuong Hang
Financial officer
DKT International

KFW/VAAC funded project: Preventing HIV/AIDS in Vietnam                                                                                                             I.
For the period from January 1st to March 31st 2007

Social Marketing Activities
Distribution Expense

                                                                                                                            Expense in previous   Expenses up
   ID                         Description of activities       Plan 2007          Actual this period        Expenses YTD          periods            to date     Variance


   I. 1   Pharmacy based distribution cost                $        113,619   $                37,397   $           37,397   $            71,075   $   108,472   $   76,223

   I. 2   Non-pharmacy based distribution cost (NTOs)     $         61,728   $                   922   $             922    $               16    $       938   $   60,806


                              Total Distribution Cost     $        175,347   $                38,318   $           38,318   $           71,091    $   109,409   $ 137,029


Prepared by




Nguyen Phuong Hang
Financial officer




                                                                                                                                                                             Page 3 of 18
DKT International

KFW/VAAC funded project: Preventing HIV/AIDS in Vietnam                                                                                                                                                      I.1
For the period from January 1st to March 31st 2007

Social Marketing Activities
Distribution Expense - TO


                                                                                                                                                   Expense in previous
    ID                        Description of activities                   Plan 2007                Actual this period           Expenses YTD            periods              Expenses up to date           Variance           code


    1     Salary of the sales force

          Sales people - pharmacy based                               $               12,092   $                        -   $                  -   $                 -   $                         -   $           12,092            7301   7301

          Sales supervisor                                            $                6,600   $                        -   $                  -   $                 -   $                         -   $            6,600            7302   7302

    2     Commission                                                                                                                                                     $                     -       $              -

          SP/S.Sp Commission                                          $           12,032       $                  6,067     $             6,067    $            10,317   $                  16,383     $            5,965            7311   7311

          Distributor's com                                           $           13,235       $                  2,969     $             2,969    $             8,999   $                  11,968     $           10,266            7312   7312
          Sub-distributor's commission, discount                      $           18,530       $                  5,031     $             5,031    $             7,313   $                  12,344     $           13,499            7313   7313
    3     Training                                                                                                                                                       $                     -       $              -
          Sales people                                                                         $                        -   $                  -   $                 -   $                     -       $              -              7321   7321
          Sales supervisors                                                                    $                        -   $                  -   $              (692) $                     (692) $                 -              7322   7322

    4     Meetings (quarterly & bi-annual, annual ) for sales force                            $                        -   $                  -   $                 -   $                     -       $              -              7331   7331

    5     Bonus for sales force                                       $               7,941    $                  1,598     $             1,598    $             7,692   $                   9,290     $            6,343            7341   7341

    6     Transportation of products (0.0008$/ condom/years)          $           22,178       $                  5,457     $             5,457    $             7,132   $                  12,589     $           16,721            7351   7351

    7     Warehouse                                                   $               8,400    $                  7,634     $             7,634    $            13,991   $                  21,625     $              766            7361   7361

    8     Travel expense                                                                                                                                                 $                     -       $              -

          Sales people ($15/month/person)                             $               1,800    $                    725     $              725     $             6,811   $                   7,537     $            1,075            7371   7371

          Sales supervisors (18 days per month x $25/ day x 2 ss)     $               5,400    $                  4,324     $             4,324    $                 -   $                   4,324     $            1,076            7372   7372

    9     Contingency (5%)                                            $               5,411    $                  3,591     $             3,591    $                 -   $                   3,591     $            1,820            7399   7399

   10     Trade promotion                                                                      $                        -   $                  -   $             9,512   $                   9,512     $                  -          7314   7314


                              Total Distribution Cost                 $          113,619       $                37,397      $            37,397    $            71,075   $                 98,959      $           76,223


Prepared by




Nguyen Phuong Hang
Financial officer
DKT International

KFW/VAAC funded project: Preventing HIV/AIDS in Vietnam                                                                                                                     I.2
For the period from January 1st to March 31st 2007

Social Marketing Activities

Distribution Expense - NTO


                                                                                                                           Expense in previous       Expenses up to
    ID                        Description of activities       Plan 2007           Actual this period       Expenses YTD         periods                  date             Variance            code


    1     Salary of the sales force

          PPMUs sales supervisors (VND 800,000/ month)    $               9,000   $              -     $             -     $              -      $               -    $               9,000          7402   7402

          Motivators' allowance                           $           20,250      $             156    $             156   $              -      $              156   $              20,094          7403   7403

    2     Commission

          Motivators (VND 1000/gross of OK)               $               1,749   $             192    $             192   $               16    $              208   $               1,557          7411   7411
    3     Training                                                                                                                               $               -    $                 -
          Sales Motivators                                $               2,000   $             112    $             112   $              -      $              112   $               1,888          7422   7422

    4     Meetings                                                                                                                               $               -    $                 -
          Sales motivators                                $               2,700   $             237    $             237   $              -      $              237   $               2,463          7432   7432

    5     Bonus                                                                                                                                  $               -    $                 -
          Sales motivators                                $           23,089      $             225    $             225   $              -      $              225   $              22,864          7442   7442
          Contingency (5%)                                $               2,940                                                                  $               -    $               2,940


                        Total NTOs Distribution Cost      $           61,728      $             922    $             922   $               16    $              938   $              60,806

Prepared by




Nguyen Phuong Hang
Financial officer
DKT International

KFW/VAAC funded project: Preventing HIV/AIDS in Vietnam                                                                                                                  II
For the period from January 1st to March 31st 2007

Social Marketing Activities

Promotion expense

                                                                                                                           Expense in previous   Expenses up to
   ID                         Description of activities       Plan 2007         Actual this period        Expenses YTD          periods              date             Variance


   II.1   General population                              $        63,250   $                 4,252   $            4,252   $            29,449   $      33,701    $           58,998


   II.2   Targeted intervention                           $        85,201   $                 2,881   $           2,881    $               -     $       2,881    $           82,320


                                       Total              $       148,451   $                 7,133   $           7,133    $           29,449    $      36,582    $      141,318


Prepared by




Nguyen Phuong Hang
Financial officer
DKT International

KFW/VAAC funded project: Preventing HIV/AIDS in Vietnam                                                                                                               II.1
For the period from January 1st to March 31st 2007

Social Marketing Activities


Promotion: General population

                                                                                                                              Expense in previous Expenses up
    ID                   Description of activities        Plan 2007                Actual this period        Expenses YTD          periods          to date         Variance


  II.1.1   Mass media                                $                43,625   $                 3,249   $            3,249   $           1,664   $     4,913   $            40,376


  II.1.2   Merchandised & PoP (NTOs, Pharmacies)     $                19,625   $                 1,003   $            1,003   $          27,785   $    28,788   $            18,622


                                  Total              $                63,250 $                   4,252 $              4,252 $            29,449 $      33,701 $              58,998
                                                                            0                         0                    0                   0             0                     0

Prepared by




Nguyen Phuong Hang
Financial officer
DKT International

KFW/VAAC funded project: Preventing HIV/AIDS in Vietnam                                                                                                                                            II.1.1
For the period from January 1st to March 31st 2007

Social Marketing Activities


Mass media

                                                                                                                                      Expense in previous
   ID                   Description of activities        Plan 2007                Actual this period           Expenses YTD                periods                  Expenses up to date           Variance            Code


 II.1.1.1   TV                                       $               43,625   $                  3,249     $              3,249   $                  1,664      $                   4,913     $              40,376


 II.1.1.2   Billboard in 8 provinces                 $                    -   $                        -   $                  -   $                         -   $                         -   $                   -


                                 Total               $               43,625   $                  3,249     $              3,249   $                  1,664      $                   4,913     $              40,376


Prepared by




Nguyen Phuong Hang
Financial officer
DKT International

KFW/VAAC funded project: Preventing HIV/AIDS in Vietnam
For the period from January 1st to March 31st 2007                                                                               II.1.1.1a
Social Marketing Activities


Mass Media


                                                                 Actual this                       Expense in      Expenses up
 #    station                   Desciption           Plan 2007    period           Expenses YTD previous periods     to date     Variance code         code
 1 TV
                     Airing at VTV                     20,000           1,200             1,200            1,664        2,864      18,800       7501      7501
                     Airing at local                   10,000               -                -                -             -      10,000       7502      7502

 2 Radio Ad.
                     Sex & Gender Forum at
                     Radio/Q & A session                4,000                  -             -                -            -        4,000       7503      7503

 3 Magazine
                     Ad.placement                       5,625                  -             -                -            -        5,625       7504      7504

 4 Event
                     Bicycle/Motorbike parade
                     around Hanoi city                  4,000           2,049             2,049               -         2,049       1,951       7505      7505




                     Total                             43,625           3,249             3,249            1,664        4,913      40,376



Prepared by




Nguyen Phuong Hang
Financial officer




                                                                                                                                        Page 9 of 18
DKT International

KFW/VAAC funded project: Preventing HIV/AIDS in Vietnam                                                                  II . 1.1.2
For the period from January 1st to March 31st 2007

Social Marketing Activities


Bill board


                                                                                            Expense in      Expenses
   #            Size/Position          Plan 2007     Actual this period   Expenses YTD   previous periods   up to date   Variance         code

        2m * 3m                                                      -              -                  -           -                  -          7541   7541

        5m * 10m

        Total                                    -                   -              -                  -           -                  -




Prepared by




Nguyen Phuong Hang
Financial officer
DKT International

KFW/VAAC funded project: Preventing HIV/AIDS in Vietnam                                                                                                 II.1.2
For the period from January 1st to March 31st 2007

Social Marketing Activities

Merchandized & PoP material



                                                                                                             Expense in
               Item Description               Plan 2007            Actual this period   Expenses YTD      previous periods   Expenses up to date       Variance            code     code

      1    Creative                                        6,500                  -                 -                  -                           -               6,500     7550          7550


           Leaflet


           Poster


      2    Promotion items                                13,125                1,003             1,003             27,785                    28,788              12,122     7551          7551


           Uniform, pen, bags
           Total                                          19,625                1,003             1,003             27,785                    28,788              18,622


Prepared by




Nguyen Phuong Hang
Financial officer
DKT International

KFW/VAAC funded project: Preventing HIV/AIDS in Vietnam                                                                                                          II.2
For the period from January 1st to March 31st 2007

Social Marketing Activities
Promotion : Targeted population


                                                                                                                         Expense in
   ID                   Description of activities      Plan 2007        Actual this period        Expenses YTD        previous periods    Expenses up to date   Variance

           Targeted intervention in provinces (8 new
           provinces, 7 overlap with DFID: only pay
  II.2.1   allowance for motivators and PPMU)                 $85,201                $2,881                 $2,881                   $0                $2,881           $82,320


  II.2.2   Monitoring & Evaluation                                 $0                        $0                  $0                  $0                    $0               $0


                                 Total                        $85,201                $2,881                 $2,881                   $0                $2,881           $82,320




Prepared by




Nguyen Phuong Hang
Financial officer
DKT International

KFW/VAAC funded project: Preventing HIV/AIDS in Vietnam                                                                                       II.2.1
For the period from January 1st to March 31st 2007

Social Marketing Activities


Training & Education
                                                                                                              Expense in
                                                                            Actual this                        previous         Expenses up
          Description                                      Plan 2007         period            Expenses YTD    periods            to date     Variance     code     code

Activities in 15 provinces
           Advocacy meeting (provincial & district
    1      authorities)                                            $5,600            $844              $844                $0          $844       $4,756     7601     7601
           Training for provincial trainers when needed
    2      (new staff)                                             $1,000            $178              $178                $0          $178         $822     7602     7602
           Groups discussion for ward/ commune leaders
    3      and EE owners - in coordination with PPMUs              $1,250            $972              $972                $0          $972         $278     7603     7603
           from output 3
    4      Groups discussion for sex workers                       $2,500                 $0             $0                $0            $0       $2,500     7604     7604

    5     Groups discussion for mobile workers                    $14,500                 $0             $0                $0            $0      $14,500     7605     7605

    6     TV forums                                                $6,000                 $0             $0                $0            $0       $6,000     7606     7606
          Allowance for PPMU staff (accountant,
    7     project officer)                                        $27,000            $887              $887                $0          $887      $26,113     7607     7607

    8     OK containers in NTO outlet                              $5,000                 $0             $0                $0            $0       $5,000     7608     7608

    9     Motorcycles shows in hotspots                            $8,000                 $0             $0                $0            $0       $8,000     7609     7609
          Cross-site visits (eg: police, DOLISA, Culture
   10     & Information, Tourism)                                  $7,200                 $0             $0                $0            $0       $7,200     7610     7610

   11     Consultants                                              $3,360                 $0             $0                $0            $0       $3,360     7611     7611

   12     Contingency (5%)                                         $3,791                 $0             $0                $0            $0       $3,791     7699     7699

                              Total                              $85,201          $2,881             $2,881            $0            $2,881      $82,320
Prepared by




Nguyen Phuong Hang
Financial officer
DKT International

KFW/VAAC funded project: Preventing HIV/AIDS in Vietnam                                                                                       II.2.2
For the period from January 1st to March 31st 2007

Social Marketing Activities
Monitoring and Evaluation
                                                                                                    Expense in previous
    ID      Description                   Plan 2007        Actual this period   Expenses YTD             periods        Expenses up to date   Variance        Code


            Monitor and Evaluation                                         $0                  $0                    $0                  $0              $0          7701   7701

            Total                                     $0                   $0                  $0                    $0                  $0              $0



Prepared by




Nguyen Phuong Hang
Financial officer
DKT International

KFW/VAAC funded project: Preventing HIV/AIDS in Vietnam                                                                                                     III
For the period from January 1st to March 31st 2007

Social Marketing Activities



                                                                                                                 Expense in previous    Expenses up to
    ID              Description of activities        Plan 2007         Actual this period      Expenses YTD           periods               date          Variance


   III.1   Staff cost                                        $51,842                  $7,436            $7,436                $13,710           $21,146           $44,406


   III.2   Office operating cost                             $36,080                  $7,979            $7,979                $20,090           $28,069           $28,101


   III.3   Travel                                            $14,467                    $445             $445                   $958             $1,403           $14,022


                             Total                          $102,389                 $15,860           $15,860                $34,758           $50,618           $86,529
                                                               $0.00                   $0.00             $0.00                  $0.00             $0.00             $0.00

Prepared by




Nguyen Phuong Hang
Financial officer
DKT International

KFW/VAAC funded project: Preventing HIV/AIDS in Vietnam                                                                                                     III.1
For the period from January 1st to March 31st 2007

Social Marketing Activities
Salary
                                                                                                                     Expense in      Expenses up to
                   Description of activities             Plan 2007      Actual this period       Expenses YTD     previous periods       date              Variance       Code
          Total Salary                               $      51,842.00   $        7,435.85    $         7,435.85   $      13,710.37   $     21,146.22   $      44,406.15


Prepared by




Nguyen Phuong Hang
Financial officer
DKT International

KFW/VAAC funded project: Preventing HIV/AIDS in Vietnam                                                                                              III.2
For the period from January 1st to March 31st 2007

Social Marketing Activities
Office expense

                                                                             Actual this                    Expense in
                     Description of activities           Plan 2007             period       Expenses YTD previous periods Expenses up to date       Variance          Code
          Hanoi
      1.1 Office rental                              $           7,200   $          2,236   $      2,236   $        4,424   $          6,660    $             4,964          7201   7201
      1.2 Office utilities                           $           1,440   $           850    $        850   $        1,094   $          1,944    $              590           7202   7202
      1.3 Tel & Fax                                  $           4,320   $          1,924   $      1,924   $        1,219   $          3,142    $             2,396          7203   7203
      1.4 Postage                                    $           1,080   $           389    $        389   $          658   $          1,046    $              691           7204   7204
      1.5 Stationery                                 $           2,880   $           671    $        671   $        4,792   $          5,463    $             2,209          7205   7205
      1.6 Travel cost (car, taxi)                    $           2,880   $           661    $        661   $          894   $          1,555    $             2,219          7206   7206
      1.7 Software                                                       $            -     $        -     $          -     $            -      $               -            7207   7207
      1.8 Equipment & Furniture                      $           5,000   $           696    $        696   $        4,193   $          4,889    $             4,304          7208   7208
      1.9 Auditing for this project                  $           8,000   $            -     $        -     $        1,971   $          1,971    $             8,000          7209   7209
        2 Contingency (10%)                          $           3,280   $           551    $        551   $          846   $          1,398    $             2,729          7249   7249
          Total Office Cost                          $          36,080   $          7,979   $      7,979   $       20,090   $         28,069    $            28,101

Prepared by




Nguyen Phuong Hang
Financial officer
DKT International

KFW/VAAC funded project: Preventing HIV/AIDS in Vietnam                                                                                III.3
For the period from January 1st to March 31st 2007

Social Marketing Activities
Travelling

                                                                                                               Expense in          Expenses up to
   ID         Description of activities       Plan 2007           Actual this period       Expenses YTD     previous periods           date                Variance       Code


    1     Field trips


   1.1    DKT project officers            $           9,000   $                  445   $              445   $            958   $               1,403   $          8,555          7251   7251


   1.2    Expat                           $           3,467   $                   -    $              -     $             -    $                 -     $          3,467          7252   7252


   1.3    Other DKT staff                 $           2,000   $                   -    $              -     $             -    $                 -     $          2,000          7253   7253


                        Total             $          14,467   $                  445   $              445   $            958   $               1,403   $         14,022


Prepared by




Nguyen Phuong Hang
Financial officer

								
To top