{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["April 2012 - March 2013","Salary Break-up"],"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":"April 2012 - March 2013","index":0,"n_rows":49,"n_cols":9,"rows_kept":49,"cut":false,"hidden":false,"merged":[[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],[30,2,30,5],[48,3,48,7],[31,2,31,5],[32,2,32,6],[43,3,43,7],[44,3,44,7],[38,1,38,3],[34,2,34,5],[35,2,35,5],[33,2,33,5],[47,3,47,7],[46,3,46,7],[36,2,36,5],[45,3,45,7],[39,1,39,3]]}
[]
[]
[null,"Door Step School & Asha Silicon Valley"]
[null," Educational Activity Center"]
[null," Estimated Budget (10 Centers) April 2012-March 2013"]
[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 ",6325,12,null,{"$f":"D8*E8","v":75900},null,{"$f":"H8*10%+H8","v":0}]
[null,null,"Total of I",null,null,null,{"$f":"G8","v":75900}]
[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 Events",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"]
[null,null,"April to May ",{"$f":"'Salary Break-up'!E14","v":4340},2,24,{"$f":"D19*E19*F19","v":208320},"Basic  + PF (12%) + Travel Allowance (12%) - Details in next sheet"]
[null,null,"June to March",{"$f":"'Salary Break-up'!E18","v":4712},10,24,{"$f":"D20*E20*F20","v":1130880},"Rs. 300 Annual Salary Increase effective June 2012"]
[null,2,"Coordinator Salaries"]
[null,null,"April to May",{"$f":"'Salary Break-up'!C14","v":10376.94},2,1,{"$f":"D22*E22*F22","v":20753.88},"Basic  + PF (Rs. 780) + Travel Allowance (18%) - Details in next sheet"]
[null,null,"June to March",{"$f":"'Salary Break-up'!C18","v":11816.481000000002},10,1,{"$f":"D23*E23*F23","v":118164.81000000001},"Salary Increase effective June 2012"]
[null,3,"Supervisors Salaries"]
[null,null,"April to May",{"$f":"'Salary Break-up'!D14","v":6981},2,2,{"$f":"D25*E25*F25","v":27924},"Basic  + PF (12%) + Travel Allowance (18%) - Details in next sheet"]
[null,null,"June to March",{"$f":"'Salary Break-up'!D18","v":8028.15},10,2,{"$f":"D26*E26*F26","v":160563},"Salary Increase effective June 2012"]
[null,4,"Teaching & Educational Material",16,12,440,{"$f":"D27*E27*F27","v":84480}]
[null,5,"Picnic/Events",50,null,440,{"$f":"D28*F28","v":22000}]
[null,6,"Miscellaneous",20,null,440,{"$f":"D29*F29","v":8800}]
[null,7,"Transport ",250,10,100,{"$f":"D30*E30*F30","v":250000}]
[null,null,"Total - III",null,null,null,{"$f":"SUM(G19:G30)","v":2031885.69}]
[null,null,"Total of I+ II+III",null,null,null,{"$f":"G9+G16+G31","v":2133735.69}]
[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":"G32*10%","v":213373.56900000002}]
[null,null,"Grand Total I+ II+III+IV( Rounded)",null,null,null,{"$f":"CEILING(G32+G34,1000)","v":2348000}]
[null,null,"Funding by Builders (20% of total cost)",null,null,null,{"$f":"G35*20%","v":469600}]
[null,null,"Funding Requested ( 80% of total cost)",null,null,null,{"$f":"CEILING(G35-G36,1000)","v":1879000}]
[]
[null,"Funding Per Site / Month ( rounded)",null,null,null,"Rs.",{"$f":"G35/10/12","v":19566.666666666668}]
[null,"Funding Per Child Per Month",null,null,null,"Rs.",{"$f":"G39/44","v":444.69696969696975}]
[]
[]
[]
[null,"Notes:"]
[null,"a.","Staff Events:","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,"b.","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,"c.","Picnic and Events:","We organize picnic at once in year, We also organise events like Diwali, Makarsankrat, Republic Day, Independence Day etc."]
[null,"d.","No. of children:","Assumption - Per site 44 children"]
[null,"e.","Teaching & Educational Material:","Teaching and Educational Materials cost is lower than last year because we have been able to generate funds for this from individual donors. Hence the reduction. "]

{"sheet":"Salary Break-up","index":1,"n_rows":18,"n_cols":5,"rows_kept":18,"cut":false,"hidden":false,"merged":[[10,0,13,0],[14,0,17,0]]}
{"$rows_empty":9}
[null,null,"Co-ordinator","Supervisor","Teacher"]
["April - May 2011","Basic Salary  Per Month",8133,5370,3500]
[null,"PF @12%  of Basic Salary or Rs. 780 which ever is less",780,{"$f":"D11*12%","v":644.4},{"$f":"E11*12%","v":420}]
[null,"Travelling ",{"$f":"C11*18%","v":1463.94},{"$f":"D11*18%","v":966.59999999999991},{"$f":"E11*12%","v":420}]
[null,"Total (Salary + Allowances) Per Month",{"$f":"SUM(C11:C13)","v":10376.94},{"$f":"SUM(D11:D13)","v":6981},{"$f":"SUM(E11:E13)","v":4340}]
["June 2011 -  March 2012","Basic Salary  Per Month",{"$f":"C11*15%+C11","v":9352.9500000000007},{"$f":"D11*15%+D11","v":6175.5},{"$f":"E11+300","v":3800}]
[null,"PF @12%  of Basic Salary or Rs. 780 which ever is less",780,{"$f":"D15*12%","v":741.06},{"$f":"E15*12%","v":456}]
[null,"Travelling ",{"$f":"C15*18%","v":1683.5310000000002},{"$f":"D15*18%","v":1111.5899999999999},{"$f":"E15*12%","v":456}]
[null,"Total (Salary + Allowances) Per Month",{"$f":"SUM(C15:C17)","v":11816.481000000002},{"$f":"SUM(D15:D17)","v":8028.15},{"$f":"SUM(E15:E17)","v":4712}]