{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Budget for ASV 2013-14","Salary Break-up 13-14"],"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":"Budget for ASV 2013-14","index":0,"n_rows":43,"n_cols":8,"rows_kept":43,"cut":false,"hidden":false,"merged":[[42,3,42,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],[37,3,37,7],[38,3,38,7],[39,3,39,7],[40,3,40,7],[41,3,41,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 2013-March 2014"]
[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 ",6958,12,null,{"$f":"D8*E8","v":83496}]
[null,null,"Total of I",null,null,null,{"$f":"G8","v":83496}]
[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},"Associate Director (1) + Coordinator (1) + Supervisor (2) + Teachers (24) = 28 Persons"]
[null,null,"Total of IV",null,null,null,{"$f":"G12+G13+G14+G15","v":25950}]
[null,"III","PROGRAM EXPENSES"]
[null,1,"Teachers Salaries",5056,12,24,{"$f":"D18*E18*F18","v":1456128},"Basic  + PF (12%) + Travel Allowance (13%) - Details in next sheet"]
[null,2,"Supervisors Salaries",9032,12,2,{"$f":"D19*E19*F19","v":216768},"Basic  + PF Rs. 780 + Travel Allowance (18%) - Details in next sheet"]
[null,3,"Coordinator Salaries",{"$f":"'Salary Break-up 13-14'!D14","v":13293.999999999987},12,1,{"$f":"D20*E20*F20","v":159527.99999999985},"Basic  +PF Rs. 780 + Travel Allowance (18%) - Details in next sheet"]
[null,4,"Teaching & Educational Material",20,12,500,{"$f":"D21*E21*F21","v":120000}]
[null,5,"Picnic/Events",50,null,500,{"$f":"D22*F22","v":25000}]
[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":2262424}]
[null,null,"Total of I+ II+III",null,null,null,{"$f":"G9+G16+G25","v":2371870}]
[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":237187}]
[null,null,"Grand Total I+ II+III+IV( Rounded)",null,null,null,{"$f":"CEILING(G26+G28,100)","v":2609100}]
[null,null,"Funding by Builders (22% of total cost)",null,null,null,{"$f":"G29*22%","v":574002}]
[null,null,"Funding Requested ( 78% of total cost)",null,null,null,{"$f":"CEILING(G29-G30,1000)","v":2036000}]
[]
[null,"Funding Per Site / Month ( rounded)",null,null,null,"Rs.",{"$f":"G29/10/12","v":21742.5}]
[null,"Funding Per Child Per Month",null,null,null,"Rs.",{"$f":"G33/50","v":434.85}]
[]
[]
[]
[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"]

{"sheet":"Salary Break-up 13-14","index":1,"n_rows":14,"n_cols":6,"rows_kept":14,"cut":false,"hidden":false,"merged":[[10,1,13,1]]}
{"$rows_empty":9}
[null,"Year","Particular","Co-ordinator","Supervisor","Teacher"]
[null,"April 13- May 2014","Basic Salary  Per Month",10605.084745762701,6993,4045]
[null,null,"PF @12%  of Basic Salary or Rs. 780 which ever is less",780,780,{"$f":"F11*12%","v":485.4}]
[null,null,"Travelling ",{"$f":"D11*18%","v":1908.915254237286},{"$f":"E11*18%","v":1258.74},{"$f":"F11*13%","v":525.85}]
[null,null,"Total (Salary + Allowances) Per Month",{"$f":"SUM(D11:D13)","v":13293.999999999987},{"$f":"SUM(E11:E13)","v":9031.74},{"$f":"SUM(F11:F13)","v":5056.25}]