{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Final Budget 14-15"],"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":"Final Budget 14-15","index":0,"n_rows":47,"n_cols":7,"rows_kept":47,"cut":false,"hidden":false,"merged":[[46,3,46,7],[27,2,27,5],[28,2,28,5],[29,2,29,5],[30,2,30,5],[32,1,32,3],[33,1,33,3],[41,3,41,7],[42,3,42,7],[43,3,43,7],[44,3,44,7],[45,3,45,7],[26,2,26,6],[2,1,2,6],[3,1,3,6],[4,1,4,6],[6,2,6,6],[8,2,8,5],[9,2,9,6],[10,2,10,5],[15,2,15,5],[16,2,16,6],[24,2,24,5],[25,2,25,5]]}
[]
[]
[null,"Door Step School & Asha Silicon Valley"]
[null," Educational Activity Center"]
[null," Estimated Budget (10 Centers) April 2014-March 2015"]
[null,"Sr. No.","Particulars","Rate/ Cost per Month","No. of Months","No. of Persons","Total in Rs."]
[null,"I","MANAGEMENT COST"]
[null,1,"Management Salary ",8001,12,null,{"$f":"D8*E8","v":96012}]
[null,null,"Total of I",null,null,null,{"$f":"G8","v":96012}]
[null,"II","STAFF WELFARE"]
[null,1,"Mediclaim of staff (Part Payment)"]
[null,null,"Coordinators ",{"$f":"900*50%","v":450},null,1,{"$f":"D12*F12","v":450}]
[null,null,"Supervisor",{"$f":"900*50%","v":450},null,2,{"$f":"D13*F13","v":900}]
[null,null,"Teachers",{"$f":"900*75%","v":675},null,24,{"$f":"D14*F14","v":16200}]
[null,2,"Staff Event",300,null,28,{"$f":"D15*F15","v":8400}]
[null,null,"Total of IV",null,null,null,{"$f":"G12+G13+G14+G15","v":25950}]
[null,"III","PROGRAM EXPENSES"]
[null,1,"Teachers Salaries",5849,12,24,{"$f":"D18*E18*F18","v":1684512}]
[null,2,"Supervisors Salaries",10064,12,2,{"$f":"D19*E19*F19","v":241536}]
[null,3,"Coordinator Salaries",14859,12,1,{"$f":"D20*E20*F20","v":178308}]
[null,4,"Teaching & Educational Material",20,12,500,{"$f":"D21*E21*F21","v":120000}]
[null,5,"Picnic/Events",60,null,500,{"$f":"D22*F22","v":30000}]
[null,6,"Support Activities/ Miscellaneous",20,null,500,{"$f":"D23*F23","v":10000}]
[null,7,"Transport ",275,10,100,{"$f":"D24*E24*F24","v":275000}]
[null,null,"Total - III",null,null,null,{"$f":"SUM(G18:G24)","v":2539356}]
[null,null,"Total of I+ II+III",null,null,null,{"$f":"G9+G16+G25","v":2661318}]
[null,"IV","ADMINISTRATIVE EXPENSES"]
[null,1,"Telephone, stationary, postage, admin staff and other organizational costs @ approx 10% of Total of I+ II+III",null,null,null,{"$f":"G26*10%","v":266131.8}]
[null,null,"Grand Total I+ II+III+IV( Rounded)",null,null,null,{"$f":"CEILING(G26+G28,100)","v":2927500}]
[null,null,"Funding by Builders (40% of total cost)",null,null,null,{"$f":"G29*40%","v":1171000}]
[null,null,"Funding Requested ( 60% of total cost)",null,null,null,{"$f":"CEILING(G29-G30,1000)","v":1757000}]
[]
[null,"Cost Per Site / Month ( rounded)",null,null,null,"Rs.",{"$f":"G29/10/12","v":24395.833333333332}]
[null,"Cost Per Child Per Month",null,null,null,"Rs.",{"$f":"G33/50","v":487.91666666666663}]
[]
[null,null,"Approved  Budget  for Last Year",2036000]
[null,null,"Requested Budget this year",{"$f":"G31","v":1757000}]
[null,null,"Difference ",{"$f":"D37-D36","v":-279000}]
[null,null,"Budget decreased by (in %)",{"$f":"100*D38/D37","v":-15.879339783722253}]
[]
[]
[null,"Notes:"]
[null,"a.","Transport Cost:","School transport remains to be pivotal activity for school going children of the construction sites. All our efforts of convincing parents and enrolling children into schools sometimes seem futile if we can not provide them transport. Without a safe and regular school transport facility, the children of the construction sites find it difficult to get to the schools and then they eventually drop out."]
[null,"b.","Staff Event:","We organize Annual Day program for staff once a year. In addition to this we also organize cluster level review meetings for our entire project to access the progress of each project. Staff event budget head cost include the cost involved for this activity."]
[null,"c.","Support Activities/ Miscellaneous:","When we run classes we provide some material which is necessary to the children of that class e.g.  a toilet is not provided by the builder, we need to provide a mobile toilet for the children and teachers on the construction sites, Housekeeping material etc."]
[null,"d.","Picnic and Events:","We organize picnic at once in year, We also organise events like Diwali, Makarsankrat, Republic Day, Independence Day etc."]
[null,"e.","No. of children:","Assumption - Per site 50 children"]