Edu Expenses - Asha for Education by xiagong0815

VIEWS: 0 PAGES: 12

									          Seva Chakkara:
        Consolidated Budget

                                           Monthly Expense          Yearly Expense
Items                                Indian Rupee    # of Months      Indian Rupee

All Food Items                            Rs 92,828            12       Rs 1,113,931

Education                                 Rs 98,775            11       Rs 1,086,520

Administration & Maintenance              Rs 62,335            12         Rs 748,020

Totals                                   Rs 253,937                     Rs 2,948,471




USD / INR Exchange Rate                      Rs 45.0

Guide: Input cells in Blue; output cells in Black
Yearly Expense
      USD

$      24,754.03

$      24,754.03 (Request for Funding from NYCNJ Chapter)

$      16,622.67

$      65,521.58
           A        B            C         D           E          F                 G                  H                  I        Edu Expenses
                                                                                                                                            J                 K             L            M                   N                       O                     P                  Q
 1                      Seva Chakkara: Educational Expenses 2011-2012                                                                   USD Conversion             45
 2
 3                           Nursery and Primary: Teacher/Staff Salaries
 4
 5                              Item                                                                  Monthly           # of Months              Yearly
 6                       1   4 Teachers + Head Master (H.M.)                                         Rs 15,500                  11           Rs 170,500
 7                       2   Driver & School Van Driver                                               Rs 9,000                  11           Rs 99,000
 8                       3   Watchman                                                                 Rs 4,000                  11           Rs 44,000
 9                       4   Graft Teacher                                                            Rs 2,500                  11           Rs 27,500
10                       5   Dance Master                                                             Rs 2,500                  11           Rs 27,500
11                       4   Sweeper                                                                  Rs 1,500                  11           Rs 16,500
12                       5   Scavenger                                                                Rs 1,000                  11           Rs 11,000
13
14                           Total                                                                   Rs 36,000                   11         Rs 396,000       $8,800.00
15
16
17
18                           Primary and Secondary: Recurring Education Expenses
19
20
21   I                       Recurring Expenses                        Student Names                                 Monthly Fees         # of Months     Yearly Fees    Uniform      TextBooks     Teachers/Staff Salary          Total          Total Annual Per Child
22                       1   Seva Chakkara Nursery & Primary School                                          41                 Rs 0                 11           Rs 0   Rs 34,500     Rs 25,000                Rs 396,000         Rs 4,55,500                   Rs 11,110
23                       2   High School Students                                                            53             Rs 3,975                 11     Rs 43,725    Rs 39,400     Rs 30,700                        NA         Rs 1,17,800                    Rs 2,222
24                       3   Higher Secondary School Students                                                 4             Rs 3,000                 10     Rs 30,000     Rs 6,000      Rs 1,500                        NA           Rs 37,500                    Rs 9,375
25                       4   I.T.I Technical Education                                                        2             Rs 3,000                 10     Rs 30,000    Rs 17,800      Rs 8,000                        NA           Rs 58,800                   Rs 29,400
26                       5   Diffrently abled                                                                 6             Rs 1,200                 10     Rs 12,000     Rs 2,400      Rs 4,000                        NA           Rs 19,600                    Rs 3,266
27                      11   Engineering                                                                      2           Rs 12,000                  10    Rs 120,000           NA     Rs 10,000                        NA         Rs 142,000                    Rs 71,000
28                      12   College                                                                          2             Rs 1,300                 10     Rs 13,000     Rs 1,000      Rs 1,500                        NA           Rs 16,800                    Rs 8,400
29                           Sub Total                                                                      110             Rs 24,475                       Rs 248,725   Rs 101,100     Rs 80,700              Rs 396,000          Rs 8,48,000                  Rs 1,34,773
30
31
32
33
34   II                      Non- Recurring Expenses
35                           Charts                                                                                                                                                                                                   Rs 1,500
36                           4 Block Board                                                                                                                                                                                            Rs 5,000
37                           Amenities                                                                                                                                                                                                Rs 7,500
38                           Sub Total                                                                                                                                                                                                Rs 14,000
39
40   I & II                  Total                                                                                                                                                                                                 Rs 8,62,000                  $19,155.56
41
42   lll                     Misc Educational Related Expenses             Description                            Monthly Expenses       # of Months                                                                           Yearly Total
43                       1   Conveyance                                    Transport from Seva Chakkara to                 Rs 4,500                10                                                                              Rs 45,000
44                       2   Food                                          Lunch food, evening tea & biscuits              Rs 3,500                10                                                                              Rs 35,000
45                       3   Notebook & Stationary                                                                         Rs 2,500                10                                                                              Rs 25,000
46                       4   Private Tuition                                                                               Rs 7,000                10                                                                              Rs 70,000
47                       5   Unit Test Examination                                                                         Rs 1,800                10                                                                              Rs 18,000
48                       6   News paper & Magazine                                                                         Rs 1,800                12                                                                              Rs 21,600
49                       7   Photo copy charges for Programs                                                               Rs 1,235                10                                                                              Rs 12,350
50                       8   College Students books/periodicals                                                              Rs 568                10                                                                                Rs 5,680
51                       9   Training expenses I.T.I. Students                                                               Rs 200                10                                                                                Rs 2,000
52                      10   Additional outside tuition                                                                    Rs 5,500                10                                                                                Rs 5,500
53
54                           Sub Total                                                                                     Rs 28,603                                                                                              Rs 2,40,130                    $5,002.71
55
56
57   I & II & III            Total                                                                                                                                                                                           Rs 11,02,130                       $24,491.78
58                                                                                                                                                                                                                           Rs 11,02,130                       $24,491.78




                                                                                                                    daab9d64-dfff-4470-984f-8963a54b0176.xlsx
                       Section Project



I         Orphanage Staff Salary                 Description         Monthly Expenses
      1   Administrative Officer                                                 Rs 3,000
      2   Cook (2)                                                               Rs 5,000
      3   Asst. Cook 1                                                           Rs 2,000
      4   Store Keeper                                                           Rs 2,000
      5   Medical Asst.                                                          Rs 2,000
      6   Boys & Girls Warden (2)                                                Rs 6,000
      7   Office Asst.                                                           Rs 3,000
          Sub Total                                                             Rs 23,000



II        Administration & Maintenance           Description         Monthly Expenses
          Computer maintenance                                                    Rs 500
          Computer Sheet                                                          Rs 500
          Courier charges                                                         Rs 140
          Photo expenses                                                          Rs 500
          Binding charges                                                         Rs 248
          Sanitation                                                              Rs 700
          Orphanage cleaning charges                                              Rs 300
          Electricity                                                            Rs 7,000
          Telephones                             (2) approximately               Rs 3,000
          Transportation                                                          Rs 985
          Conveyance for own Auto                                                Rs 9,000
          Vehicle repair (1 Auto, 4 Cycles)                                       Rs 450
          Building maintenance                                                    Rs 250
          Furniture & Fitting Maintenance                                         Rs 300
          Primary & Nursery School maintenance                                    Rs 100
          Sundry                                                                 Rs 4,000
          Sub Total                                                             Rs 25,385


III       Children Health, Food & Recreation     Description         Monthly Expenses
          Pooja expenses                                                          Rs 600
          Kids, children, excursion                                               Rs 500
          Dress Materials inner garments                                          Rs 300
          Bed Materials                                                           Rs 150
          Mosquito mats                                                           Rs 400
          Broom ( 2 Buildings)                                                    Rs 150
          Spindle Broom                                                           Rs 100
          Litmus perfume for toilet                                                 Rs 50
          Gas repair                                                              Rs 110
          Napkins expense (??)                                                      Rs 90
          Honorarium                                                             Rs 4,500
               Medical     average expenditure    Rs 8,000
               Sub Total                         Rs 14,950



I & II & III   Total                             Rs 63,335
# of Months        Yearly Expense
              12            Rs 36,000
              12            Rs 60,000
              12            Rs 24,000
              12            Rs 24,000
              12            Rs 24,000
              12            Rs 72,000
              12            Rs 36,000
                          Rs 276,000



# of Months        Yearly Expense
              12             Rs 6,000
              12             Rs 6,000
              12             Rs 1,680
              12             Rs 6,000
              12             Rs 2,976
              12             Rs 8,400
              12             Rs 3,600
              12            Rs 84,000
              12            Rs 36,000
              12            Rs 11,820
              12           Rs 108,000
              12             Rs 5,400
              12             Rs 3,000
              12             Rs 3,600
              12             Rs 1,200
              12            Rs 48,000
                           Rs 256,620


# of Months        Yearly Expense
              12             Rs 7,200
              12             Rs 6,000
              12             Rs 3,600
              12             Rs 1,800
              12             Rs 4,800
              12             Rs 1,800
              12             Rs 1,200
              12               Rs 600
              12             Rs 1,320
              12             Rs 1,080
              12            Rs 54,000
12    Rs 96,000
     Rs 179,400



     Rs 7,12,020
                         Seva Chakkara:
                           Food Items

                       Daily Essential Items

         Food Item                                            Qty Per Child
                                                 Morning          Evening

         Milk                                      150              170
         Rice Govt.                                100              400
         Out side Rice                             NA               NA
         Sugar                                      20               20
         Wheat                                      10               10
         Gas Cylinder                              NA               NA
         Total Daily Essential Items


         Monthly Food Expenses

Sl.No.   List of Provision & Groceries         Qty Required   Unit price
   1     Essential Food Items (from above)
   2     Toor Dhal                                120Kg              79
   3     Ured Dhal                                 45Kg              71
   4     Moon Dhal                                 60Kg              78
   5     Garam Dhal                                40Kg              38
   6     Mustard                                    6Kg              47
   7     Pepper                                     6Kg             305
   8     Jeera                                      6Kg             195
   9     Methi                                      2Kg             46.5
  10     L.G. Asafoetida                         25 Boxes           64.5
  11     Turmeric Powder                            3Kg             120
  12     Tamarind                                  20Kg             108
  13     Gundu Chillies                            15Kg             127
  14     Dhaniya Local                             25Kg              76
  15     Cooking Oil                              130Kg              75
  16     Coconut Oil                                6Kg             224
  17     Gingely Oil                               20Kg             139
  18     Bengal gram                               15Kg              40
  19     Salt                                      60Kg              13
  20     Jaggery                                   30Kg              41
  21     Tea Powder                                10Kg             255
  22     Vermicelli                                35Kg              42
  23     Sooji                                     35Kg              12
  24     Chashew                                   1.5Kg            590
  25     Cardamon                                 0.3gm             820
  26     Drygrapes                                  2Kg             180
  27     Spices                                     2Kg             250
  28     Applam                                    15kg             250
  29     Match Box                              6 Bandals             5
  30     Soap (Washing)                          272 Nos             15
  31     Soap(Bathing)                           272 Nos             13
  32     Sabena                                 25 Packets           12
  33     Vim Dish was bar                         20 Nos             17
  34     Phenyle                                 25 Prattle          30
  35     Blecing Poder                          20 Packets           30
 36      Water Tax & Charges                                0
 37      Vegetables ( from Below)                          869          515
         Total


                     Monthly Vegetables Expenses Average

Sl.No.            List of Provision & Groceries        Qty Required   Unit price
   1     Tomato                                   150kg                             6
   2     Carrot                                   20kg                             64
   3     Beetroot                                 20kg                             30
   4     Raddish                                  15kg                             20
   5     Brinjal                                  20kg                             25
   6     Turnip                                   14kg                             20
   7     Lady'sfinger                             25kg                             19
   8     Cabbage                                  15kg                             20
   9     Beans                                    20kg                             35
  10     Potato                                   25kg                             15
  11     Greens                                   60kg                             15
  12     Bottle guard                             10kg                             14
  13     Rawplantain                              15kg                             50
  14     Corn                                     15kg                             30
  15     Bittergourd                              10kg                             25
  16     Peas                                     8kg                              40
  17     Cauliflower                              15kg                             25
  18     Onion                                    150kg                            30
  19     Drumstick                                15kg                             35
  20     Pumpkin                                  10kg                             20
  21     Capsicum                                 10kg                             30
  22     Cucumber                                 15kg                             25
  23     Ginger                                   20kg                             16
  24     Mushroom                                 10kg                             35
  25     spinach                                  12kg                             70
  26     garlic                                   100kg                            40
  27     Sweet Potatoes                           20kg                             17
  28     Pudina                                   25kg                             15
  29     Curry leaves                             25kg                             15

         Total                                                                 801
                      # of Children    Total Qty          Total Qty   Cost per Item
       Total                            Per Day          Per Month

      320ml               112           35,840           1075.2 L           Rs 22.00
      500g                112           56,000           840.0kg             Rs 1.00
       NA                 112             NA              300kg             Rs 30.00
       40g                112            4,480           134.4kg            Rs 18.00
       20g                112            2,240            67.2kg             Rs 7.50
       NA                 112             NA              20Nos            Rs 370.00




Monthly Expenses       # of Months    Yearly Expense
          Rs 43,818             12        Rs 5,25,816
           Rs 9,480             12         Rs 1,13,760
           Rs 3,195             12           Rs 38,340
           Rs 4,710             12           Rs 56,520
           Rs 1,520             12           Rs 18,240
             Rs 282             12            Rs 3,384
           Rs 1,830             12           Rs 21,960
           Rs 1,170             12           Rs 14,040
              Rs 93             12            Rs 1,116
           Rs 1,612             12           Rs 19,344
             Rs 720             12            Rs 8,640
           Rs 2,160             12           Rs 25,920
           Rs 1,905             12           Rs 22,860
           Rs 1,900             12           Rs 22,800
           Rs 9,750             12         Rs 1,17,000
           Rs 1,344             12           Rs 16,128
           Rs 2,795             12           Rs 33,540
             Rs 600             12            Rs 7,200
             Rs 810             12            Rs 9,720
           Rs 1,230             12           Rs 14,760
           Rs 2,550             12           Rs 30,600
           Rs 1,470             12           Rs 17,640
             Rs 437             12            Rs 5,244
             Rs 885             12           Rs 10,620
             Rs 820             12            Rs 9,840
             Rs 360             12            Rs 4,320
             Rs 500             12            Rs 6,000
           Rs 3,750             12           Rs 45,000
              Rs 30             12              Rs 360
           Rs 4,080             12           Rs 48,960
           Rs 3,536             12           Rs 42,432
             Rs 300             12            Rs 3,600
             Rs 340             12            Rs 4,080
             Rs 750             12            Rs 9,000
             Rs 750             12            Rs 9,000
             700              12               Rs 8,400
       Rs 16,691              12            Rs 2,00,280
      Rs 128,873                          Rs15,46,464




Monthly Expenses     # of Months    Yearly Expense
           Rs 900              12            Rs 10,800
          Rs 1,280             12            Rs 15,360
            Rs 600             12             Rs 7,200
            Rs 300             12             Rs 3,600
            Rs 500             12             Rs 6,000
            Rs 280             12             Rs 3,360
            Rs 475             12             Rs 5,700
            Rs 300             12             Rs 3,600
           Rs 700              12             Rs 8,400
            Rs 375             12             Rs 4,500
            Rs 900             12            Rs 10,800
            Rs 140             12             Rs 1,680
            Rs 750             12             Rs 9,000
            Rs 450             12             Rs 5,400
            Rs 250             12             Rs 3,000
            Rs 320             12             Rs 3,840
            Rs 375             12             Rs 4,500
          Rs 4,500             12            Rs 54,000
            Rs 525             12             Rs 6,300
            Rs 200             12             Rs 2,400
            Rs 300             12             Rs 3,600
            Rs 375             12             Rs 4,500
            Rs 320             12             Rs 3,840
            Rs 350             12             Rs 4,200
            Rs 840             12            Rs 10,800
          Rs 4,000             12            Rs 48,000
            Rs 340             12             Rs 4,080
            Rs 375             12             Rs 4,500
            Rs 375             12             Rs 4,500

        Rs 17,815                          Rs 2,57,460
Total Monthly
   Expense

       Rs 23,654
          Rs 840
         Rs 9000
         Rs 2420
          Rs 504
       Rs 7400
      Rs 43,818

								
To top