{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["hostel budget","Sheet3"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"hostel budget","index":0,"n_rows":55,"n_cols":6,"rows_kept":55,"cut":false,"hidden":false,"merged":[[10,5,11,5],[13,5,14,5],[28,5,29,5]]}
[]
[null,"Hostel Budget (September 2012 to August 2013)"]
[]
[null,"average number of children p.m. during the year",30]
[null,"estimated number of residential facility will be fully functional ",280,"25 days for festivals and 30 days off in summer break and 30 days off during 12 weekends"]
[]
[null,null,"Total","Amount requested","Will raise from Tata Trust,","Notes"]
[null,null,"Amount","from Asha Stanford","Local Donations in cash / kind"]
[]
[null,"Food Costs"]
[null,"@ Rs. 80 per child per day",{"$f":"80*280*30","v":672000},{"$f":"C11-E11","v":497000},175000,"will go to ration shops and people to provide materials for a day/week"]
[]
[null,"Venue Costs"]
[null,"@ Rs. 12,000 per month",{"$f":"12000*12","v":144000},{"$f":"C14-E14","v":44000},100000,"will start from career college campus and shift to our rudimentary land"]
[]
[null,"Salary Costs of Warden cum Teachers"]
[null,"@ Rs. 10000 p.m. for one person",{"$f":"10000*12","v":120000},{"$f":"C17-E17","v":88000},32000]
[null,"@ Rs. 10000 p.m. for second teacher",{"$f":"10000*12","v":120000},{"$f":"C18-E18","v":72000},{"$f":"4000*12","v":48000},"will draw part-salary from other budget"]
[null,"@Rs.6500 p.m. for warden",{"$f":"6500*12","v":78000}]
[]
[null,"Residential arrangements"]
[null,"Mattresses and Blankets",5000,{"$f":"C22-E22","v":0},5000,"additional ones are needed as old mattresses are being run down now"]
[null,"Cupboards",10000,10000,null,"we have"]
[null,"Mats (Chataes)",2500,{"$f":"C24-E24","v":0},2500]
[null,"Kitchen Utensils",3000,{"$f":"C25-E25","v":500},2500,"partly have; therefore budgeted less"]
[null,"water purifier",20000,8000,12000]
[]
[null,"Study and Other Arrangements"]
[null,"Study Materials (books, bag, stationery) - Rs. 1000 per child",30000,{"$f":"C29-E29","v":22000},8000,"will go to schools for old bags and stationery donations"]
[null,"Uniforms for school-goers (Rs. 1000 for 5 children)",5000,5000,0]
[null,"Library Books",10000,5000,2000]
[null,"Game Equipments (basketball, football, etc.)",3000,1000,2000,"ask people for in-kind donations for this"]
[null,"Musical Instruments",2000,0,2000]
[null,"Film Watching - Projector Charges-once in a month",{"$f":"1000*12","v":12000},5000,7000,"will ask friendly groups for sharing of projector"]
[null,"Printing of Newsletters/diaries",4000,1000,3000]
[null,"Workshops - 0ne workshop in two month/ exposure",50000,30000,25000,"take out partly from other budgets"]
[null," yoga and Meditation Workshops - ",15000,0,{"$f":"C37","v":15000}]
[null,"Clothes (winters particularly @ Rs. 500 per child)",15000,8000,7000,"ask people for in-kind donations for this"]
[null,"develop kitchen garden and wormi compost th kitchen wast ",15000]
[null,"medical and other expenditure",15000]
[]
[null,"Part-time staff"]
[null,"Counsellor - Rs. 800 per day per week for 32 weeks",{"$f":"32*800","v":25600},{"$f":"C43-E43","v":17600},8000]
[null,"Music Teacher - Rs. 500 per day per week - 32 weeks",{"$f":"500*32","v":16000},7000,9000]
[null,"Volunteers for specific subject and school support(conveyence)",10000,0,null,"not budgeted"]
[]
[null,"Management and Guidance Costs @ Rs. 5000 p.m.",60000,{"$f":"C47-E47","v":36000},24000,"take out partly from other projects"]
[null,null,{"$f":"SUM(C11:C47)","v":1462100},{"$f":"SUM(D11:D47)","v":857100},{"$f":"SUM(E11:E47)","v":489000}]
[null,"Administrative Costs"]
[null,"Communications @ Rs. 1500 p.m.",{"$f":"1200*12","v":14400},{"$f":"C50-E50","v":10800},{"$f":"300*12","v":3600},"already being drawn in excess from other projects"]
[null,"Travel for camp and other volunteers @ Rs. 3000 p.m.",{"$f":"3000*12","v":36000},26400]
[null,"Accountant - 1 day/week salary @ Rs. 900 per day",{"$f":"900*365/7","v":46928.571428571428},36500]
[null,"Office Rent and other costs @ Rs. 1000 p.m.",{"$f":"1000*12","v":12000},12000]
[]
[null,"Total",{"$f":"C48+C50+C51+C52+C53","v":1571428.5714285714},{"$f":"D48+D50+D51+D52+D53","v":942800},{"$f":"E48+E50","v":492600}]

{"sheet":"Sheet3","index":1,"n_rows":54,"n_cols":2,"rows_kept":54,"cut":false,"hidden":false,"merged":[]}
["Hostel Budget (September 2012 to August 2013)"]
[]
["average number of children p.m. during the year",30]
["estimated number of residential facility will be fully functional ",280]
[]
[null,"Total"]
[null,"Amount"]
[]
["Food Costs"]
["@ Rs. 70 per child per day",{"$f":"70*280*30","v":588000}]
[]
["Venue Costs"]
["@ Rs. 10,000 per month",{"$f":"10000*12","v":120000}]
[]
["Salary Costs of Warden cum Teachers"]
["@ Rs. 10000 p.m. for one person",{"$f":"10000*12","v":120000}]
["@ Rs. 10000 p.m. for second teacher",{"$f":"10000*12","v":120000}]
["@Rs.6500 p.m. for warden",{"$f":"6500*12","v":78000}]
[]
["Residential arrangements"]
["Mattresses and Blankets",5000]
[]
["Mats (Chataes)",2500]
["Kitchen Utensils",3000]
["water tank/ pipe",5000]
[]
["Study and Other Arrangements"]
["Study Materials (books, bag, stationery) - Rs. 900 per child",27000]
["Uniforms for school-goers (Rs. 1000 for 5 children)",5000]
["Library Books",10000]
["Game Equipments (basketball, football, etc.)",3000]
["Musical Instruments",2000]
["Film Watching - Projector Charges-once in a month",5000]
["Printing of Newsletters/diaries",4000]
["Workshops - 0ne workshop in two month/ exposure",30000]
[" yoga and Meditation Workshops - ",8000]
["Clothes (winters particularly @ Rs. 400 per child)",12000]
["develop kitchen garden and wormi compost th kitchen wast ",5000]
["medical and other expenditure",10000]
[]
["Part-time staff"]
["Counsellor - Rs. 800 per day twice in a month for ",{"$f":"20*800","v":16000}]
["Music Teacher - Rs. 500 per day per week - 32 weeks",{"$f":"500*32","v":16000}]
["Volunteers for specific subject and school support(conveyence)"]
[]
["Management and Guidance Costs @ Rs. 4500 p.m.",{"$f":"4500*12","v":54000}]
[null,{"$f":"SUM(B10:B46)","v":1248500}]
["Administrative Costs"]
["Communications @ Rs. 1000 p.m.",12000]
["Travel for camp and other volunteers @ Rs. 2500 p.m.",{"$f":"2500*12","v":30000}]
["Accountant - 1 day/week salary @ Rs. 700 per day",{"$f":"700*365/7","v":36500}]
["Office Rent and other costs @ Rs. 1000 p.m.",{"$f":"1000*12","v":12000}]
[]
["Total",{"$f":"B47+B49+B50+B51+B52","v":1339000}]