{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["PB budget"],"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":"1904"}

{"sheet":"PB budget","index":0,"n_rows":58,"n_cols":11,"rows_kept":58,"cut":false,"hidden":false,"merged":[[0,0,0,6],[49,2,49,3],[0,9,0,10]]}
["Prakruti Badi 2013-14",{"$nulls":7},"PB 2012-13","Asha share - suggested split"]
["S.No","Particulars","Details","Unit","# Units","Rate","2013-14","Asha share","2012-13","via SAC","otherwise"]
[1,"Programme Expenses"]
[1.1000000000000001,"Nutrition - Residential Children","35 children for 11 Months @ Rs.19,800 / child / month","Per Child",35,19800,693000,0,1108800]
[1.2,"Nutrition - Non-residential Children","15 children for 11 Months @ Rs.5,720 / child / month","Per Child",15,5720,85800,0,308000]
[1.3,"Health Care","Rs.5,000 per month for 11 Months","Per Month",11,5000,55000,0,66000]
[1.4,"Education Materials","Rs.700 / child / year for 50 children","Per Child",50,700,35000,0,125000]
[1.5,"Skill Training","Rs.400 / child / year for 50 children","Per Child",50,400,20000,0,100000]
[1.5999999999999988,"Cultural training","Rs.20,000 per month for 10 months + Rs.15,000 for new instruments","Per Month",10,21500,215000,0,237000]
[1.6999999999999988,"Events & Celebrations","12 Events & Festivals @ Rs.10,000/- each","Per Event",12,10000,120000,0,162000]
[1.7999999999999989,"Children's Travel","Rs.500 per month for 11 months","Per Month",11,500,5500,0,247500]
[1.8999999999999988,"Excursions","4 excursions @ Rs.10,000 each","Per Month",4,10000,40000,0,250000]
[1.1000000000000001,"Teacher Training","4 trainings @ Rs 10,000 per training","Per Training",4,10000,40000,0,50000]
[1.1100000000000001,"Maintenance of Facilities","Rs.5,000 per month","Per Month",12,5000,60000,0,60000]
[1.1200000000000001,"Fellowship","2 Fellowships @ Rs.3,000 each per month","Per Month",12,6000,72000,0,54000]
[1.1299999999999999,"School recognition","Rs.75,000 for the first year to obtain recognition","Per Year",1,75000,75000,30000,"-",null,30000]
[null,"Resource Person Honorarirum",{"$nulls":4},"-","-",50000]
[null,"Exposure Visits - Teachers",{"$nulls":4},"-","-",40000]
[null,"Internet, Batteries, etc",{"$nulls":4},"-","-",24000]
[null,"Sub Total 1",{"$nulls":4},1516300,30000,{"$f":"SUM(I4:I19)","v":2882300}]
[2,"Facilitation and Coordination"]
[2.1,"Salaries and Wages – Coordinator","1 person at Rs.27,600 / month","Per Month",12,27600,331200,331200,318000]
[2.2000000000000002,"Salaries and Wages – School Incharge","1 person at Rs.12,000 / month","Per Month",12,12000,144000,0,144000,112400,{"$f":"G23-J23","v":31600}]
[2.2999999999999998,"Salaries and Wages – Teachers","5 teachers at Rs.8,500 / month / teacher","Per Month",12,42500,510000,510000,960000,{"$f":"G24","v":510000}]
[2.4,"Assistants - Cooking & Cleaning","4 persons at Rs.3,700 / month","Per Month",48,3700,177600,0,192000,177600]
[2.5,"Programme Travel","Rs.7,000 / month","Per Month",11,7000,77000,77000,60000]
[2.6,"Driver","Rs.4,000 / month","Per Month",12,4000,48000,0,"-"]
[null,"Monitoring and Review Meetings","Rs.5,000 every 4 months","3 per yr",3,5000,15000,0,"-"]
[2.7,"Hostel Help",{"$nulls":4},"-","-",60000]
[null,"Sub Total 2",{"$nulls":4},1302800,918200,{"$f":"SUM(I22:I29)","v":1734000}]
[3,"Capital"]
[3.1,"Games & Sports - Material","Rs.30,000 / year","Per Year",1,30000,30000,0,25000]
[3.3,"Gardening Tools","Rs.2,500 / set for 3 gardens","Per Set",3,2500,7500,0,5500]
[3.4,"Cupboards","5 cupboards @ Rs.7,500/item","Per Item",2,7500,15000,0,"-"]
[3.2,"Roofing & construction","Lumpsum","Per Year",1,55000,55000,0,500000]
[null,"Sweaters, pillows, & mats","1 set for each of 35 residential children","per child",35,600,21000,0,"-"]
[3.5,"Solar System",{"$nulls":4},"-","-",200000]
[null,"Sub Total 3",{"$nulls":4},128500,0,{"$f":"SUM(I32:I37)","v":730500}]
[4,"Direct Eligible Cost (1+2+3)",{"$nulls":4},2947600,948200,{"$f":"I38+I30+I20","v":5346800}]
[5,"Administration - 7%",{"$nulls":4},206069,66374,{"$f":"7%*I39","v":374276.00000000006}]
[null,"Grand Total (4+5)",{"$nulls":4},3153669,1014574,{"$f":"I40+I39","v":5721076},{"$f":"SUM(J3:J40)","v":800000},{"$f":"SUM(K3:K40)","v":61600}]
[]
[null,null,"Thushar's notes below","as-is","AY 2012-13","AY 2013-14"]
[null,null,"Total SAC kids for AY 2013-14",32,52,32]
[null,null,"SAC budget proposed",{"$f":"H41","v":1014574},{"$f":"E46*E44","v":910000},{"$f":"F46*F44","v":800000}]
[null,null,"per child amount (annual)",{"$f":"D45/D44","v":31705.4375},17500,25000]
[null,null,"in USD (@ 63)",{"$f":"D46/63","v":503.26091269841271},384,400]
[]
[]
[null,null,"PB budget contributors (estimated by PB coordinator)"]
[null,null,"SAC (Asha Banglaore)",10]
[null,null,"ayan",1.1000000000000001]
[null,null,"spark",5]
[null,null,"Asha london",3.5]
[null,null,"individuals",4]
[null,null,"TDHBMZ",4]
[null,null,"To de determined",{"$f":"D58-SUM(D51:D56)","v":3.8999999999999986}]
[null,null,"Total",31.5]