{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["Expenditure Assumptions 2013-14","Expenditure Sheet","Income sheet"],"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":"Expenditure Assumptions 2013-14","index":0,"n_rows":57,"n_cols":4,"rows_kept":57,"cut":false,"hidden":false,"merged":[[0,0,0,4]]}
["Expenditure Assumptions 2013-14"]
[]
[null,null,"2012-13","2013-14"]
[]
[null,"Salaries"]
[null,"Gurveen",null,16500]
[null,"Amit",null,13000]
[null,"Dhanesh",null,12000]
[null,"Jayashree",null,6500]
[null,"Kala (cooking help)",null,3500]
[null,"Number of part time teachers",null,1]
[null,"Salary per head",null,1500]
[]
[null,"General"]
[null,"Number of 14- children",null,10]
[null,"Number of 14+ children",null,3]
[null,"Number of working days",null,200]
[null,"Per month Lunch cost",null,350]
[null,"Per month snacks cost",null,150]
[]
[null,"Trips"]
[null,"Outstation trips"]
[null,"Number of trips in a year",null,2]
[null,"Number of people",null,3]
[null,"Number of days",null,7]
[null,"Per head travel",null,1000]
[null,"Food (per day)",null,100]
[null,"Stay (per day)",null,100]
[null,"Local trips"]
[null,"Number of trips per month",null,1]
[null,"Travel cost (per trip)",null,100]
[null,"Number of children",null,3]
[null,"Stay",null,0]
[]
[null,"Apprenticeships"]
[null,"Outstation apprenticeships"]
[null,"Number of trips in a year",null,0]
[null,"% of children",null,1]
[null,"Number of children",null,{"$f":"D38*D16","v":3}]
[null,"Number of days",null,6]
[null,"Per head travel",null,1000]
[null,"Food (per day)",null,200]
[null,"Stay (per day)",null,100]
[null,"Payment to Mentor (per day)",null,100]
[null,"Within city"]
[null,"Number of children",null,{"$f":"D16-D39","v":0}]
[null,"Travel cost (per day)",null,50]
[null,"Number of days",null,0]
[null,"Food",null,0]
[null,"Payment to Mentor (per day)",null,100]
[null,"Material cost (per month)",null,500]
[]
[null,"Hands on activities"]
[null,"Pottery (per month)",null,0]
[null,"Embroidery (per student per month)",null,100]
[null,"Wood Work (per month)",null,100]
[null,"Gardening (per month)",null,200]

{"sheet":"Expenditure Sheet","index":1,"n_rows":71,"n_cols":5,"rows_kept":71,"cut":false,"hidden":false,"merged":[[70,1,70,3],[24,4,25,4],[27,4,31,4],[43,4,46,4],[39,4,41,4]]}
[]
[null,"Expenditure Head","Expenses for 2012-13","Estimated amount 2013-14","Details of calculation"]
[null,"Teacher Salaries"]
[null,"Principal",167700,{"$f":"'Expenditure Assumptions 2013-14'!D6*12","v":198000},"Based on decision by board, in order to take into account the inflation teacher's have been given a 15% hike in salary"]
[null,"Full time Teachers",396300,{"$f":"SUM('Expenditure Assumptions 2013-14'!D7:D9)*12","v":378000},"Based on decision by board, in order to take into account the inflation teacher's have been given a 15% hike in salary"]
[null,"Part time teachers",0,{"$f":"'Expenditure Assumptions 2013-14'!D11*'Expenditure Assumptions 2013-14'!D12*12","v":18000},"Part time teacher coming to the centre once for teaching Kuchipudi"]
[null,"Total teacher's salary",{"$f":"SUM(C4:C6)","v":564000},{"$f":"SUM(D4:D6)","v":594000}]
[]
[null,"Educational expenses"]
[null,"Academics related"]
[null,"Teaching-learning material",1660,2500]
[null,"Books/Library",600,6000,"We have to increase the number of books and resources needed by older students"]
[null,"Notebooks & Stationary",650,1000]
[null,"Sports Material",195,500]
[null,"Hands on activities (See down B70)"]
[null,"Pottery",0,{"$f":"'Expenditure Assumptions 2013-14'!D54*12","v":0},"The cost of this has been included in the projects (down B21)"]
[null,"Embroidery",0,{"$f":"'Expenditure Assumptions 2013-14'!D55*6*8","v":4800},"Assuming average of 6 students working for 8 months on the products"]
[null,"Wood Work",0,{"$f":"'Expenditure Assumptions 2013-14'!D56*12","v":1200}]
[null,"Musicals",0,1000,"Repair of tabla and buying some wind instruments"]
[null,"Gardening",1712,{"$f":"'Expenditure Assumptions 2013-14'!D57*12","v":2400},"Includes cost of seed, maintaining the square foot garden and buying new pots for terrace shed"]
[null,"Projects",0,12000,"This year we have undertaken a few educational projects with children, and community members. As part of the projects we have build a shed, made a few educational games, handmade paper noteboks."]
[null,"Events"]
[null,"Exhibitions",3641,3000]
[null,"Trips"]
[null,"Outstation trips",0,{"$f":"'Expenditure Assumptions 2013-14'!$D$23*'Expenditure Assumptions 2013-14'!$D$24*('Expenditure Assumptions 2013-14'!$D$26+('Expenditure Assumptions 2013-14'!$D$27+'Expenditure Assumptions 2013-14'!$D$28)*'Expenditure Assumptions 2013-14'!$D$25)","v":14400},"Children are required to additionally pay for their trips. However, the given cost is for the few children who will not be able to pay for the trips"]
[null,"Local trips",0,{"$f":"'Expenditure Assumptions 2013-14'!D30*'Expenditure Assumptions 2013-14'!D31*'Expenditure Assumptions 2013-14'!D32*6","v":1800}]
[null,"Apprenticeship Expenses"]
[null,"Outstation apprenticeships",0,{"$f":"'Expenditure Assumptions 2013-14'!D37*'Expenditure Assumptions 2013-14'!D39*'Expenditure Assumptions 2013-14'!D41+'Expenditure Assumptions 2013-14'!D37*'Expenditure Assumptions 2013-14'!D39*'Expenditure Assumptions 2013-14'!D40*('Expenditure Assumptions 2013-14'!D42+'Expenditure Assumptions 2013-14'!D43)","v":0},"We had calculated the apprenticeship cost which comes to nearly the cost of outstation trip. The cost also includes the payment to the mentor (if the mentor so desires). However, as we might not be carrying out any outstation apprenticeship trips this year we have removed the cost from this years budget"]
[null,"Mentor payment",0,{"$f":"'Expenditure Assumptions 2013-14'!D37*'Expenditure Assumptions 2013-14'!D39*'Expenditure Assumptions 2013-14'!D40*'Expenditure Assumptions 2013-14'!D44","v":0}]
[null,"Within city",0,{"$f":"'Expenditure Assumptions 2013-14'!D46*'Expenditure Assumptions 2013-14'!D48*'Expenditure Assumptions 2013-14'!D47","v":0}]
[null,"Mentor payment",0,{"$f":"'Expenditure Assumptions 2013-14'!D48*'Expenditure Assumptions 2013-14'!D50","v":0}]
[null,"Material cost",0,{"$f":"12*'Expenditure Assumptions 2013-14'!D51*'Expenditure Assumptions 2013-14'!D46","v":0}]
[null,"Total Educational expenses",{"$f":"SUM(C11:C32)","v":8458},{"$f":"SUM(D11:D32)","v":50600}]
[]
[null,"Educare expenses"]
[null,"Printing cost",0,{"$f":"5000*2","v":10000},"Cost of 5,000 per issue. This year we wish to roll out two issues"]
[null,"Postage cost",0,{"$f":"10*120*2","v":2400},"Cost INR 10 for postage per copy. We send 120 copies by mail per issue. Rest are sent as soft copies."]
[null,"Total Educare cost",null,{"$f":"D36+D37","v":12400}]
[]
[null,"Karvaan expenses",null,null,"We have started Saturday community café called Karvaan. This is to help more people from the community around engage with the centre. The total annual cost for running it amounts to INR 25,000. However we have not added this cost to the budget as we try to recover this cost through donations from participants and are basing it on gift economy."]
[null,"Monthly food expense",null,{"$f":"1000*12","v":12000}]
[null,"Monthly workshop expenses",null,{"$f":"1300*10","v":13000}]
[]
[null,"Food cost",null,null,"For 2 months initially we had served only snacks and later in September resumed with lunch. Snacks cost us around INR 150 per person per month and lunch a little more than INR 350 per person per month. Cooking staff salary is INR 3,500 pm. The salary has been increased keeping in account the inflation and to bridge the gap between salaries all of us take."]
[null,"Lunch expense",44996,{"$f":"('Expenditure Assumptions 2013-14'!D15+'Expenditure Assumptions 2013-14'!D16+5)*(('Expenditure Assumptions 2013-14'!D18*8)+('Expenditure Assumptions 2013-14'!D19*2))","v":55800}]
[null,"Cooking staff cost",25500,{"$f":"'Expenditure Assumptions 2013-14'!D10*12","v":42000}]
[null,"Total lunch cost",{"$f":"SUM(C45:C46)","v":70496},{"$f":"SUM(D45:D46)","v":97800}]
[]
[null,"Administration"]
[null,"Audit",0,{"$f":"5000+7000","v":12000},"Audit fees for the year 2012-13 (INR 5000) was also paid in 2013-14 and so does not reflect in the Audit report. The total Admin cost this year inludes INR 5000 from last year and INR 7000 (increment of INR 2000) this year. "]
[null,"Insurance",3204,3500]
[null,"Building Tax",3318,3500]
[null,"Electricity and water",7579,7600]
[null,"Postage and telephone",1951,{"$f":"200*12","v":2400},"Average of INR 200 pm"]
[null,"Conveyance",390,1500]
[null,"Travel",0,0]
[null,"Building Maintenance & Repair",250,2000,"Window frame lining"]
[null,"Computer Maintenance",5000,0]
[null,"Furniture and Fixtures maintenance",0,1000,"Some old tables needs repair"]
[null,"Stationery, Xerox, Printing",417,1000]
[null,"Advertising",0,2000,"Advertising for the new programs - 14+ program, Karvaan, community engagement initiatives."]
[null,"Hospitality",3485,3500]
[null,"Sanitation & Cleanliness",1674,1700]
[null,"Board Meetings",0,500]
[null,"Miscellaneous",271,1000]
[null,"Total Administration cost",{"$f":"SUM(C50:C65)","v":27539},{"$f":"SUM(D50:D65)","v":43200}]
[]
[null,"Total Expenses",{"$f":"C66+C47+C38+C33+C7","v":670493},{"$f":"D66+D47+D38+D33+D7","v":798000}]
[]
[null,"Hands on activities (*)"]
[null,"We have started community learning programs where in especially on Saturdays we invite people from the community around to come and participate in learning different things."]

{"sheet":"Income sheet","index":2,"n_rows":30,"n_cols":5,"rows_kept":30,"cut":false,"hidden":false,"merged":[[15,4,16,4]]}
[]
[null,"Income Head","Receipts for 2012-13","Estimated Amount 2013-14","Details of calculation"]
[null,"Fees",287350,{"$f":"C30","v":241000},"Details are given below C30"]
[null,"ASHA. Seattle + Donor specific",326025,320000,"Includes individual donation from Vamshi. The amount depends on the current INR value."]
[null,"Donation towards food",37125,{"$f":"350*10*8+150*10*2","v":31000},"350 collected from 7 children and 3 adults for 8 months + 150 collected from 7 children and 3 adults for 2 months"]
[null,"Donation towards education centre",204594,30000,"The donations in 2012-13 includes specific donations (1,40,000) made in the year from friends abroad"]
[null,"Miscellenous (educare subscription, sales of cards)",0,0]
[null,"Funds given for Volunteer expenses",70100,0,"We dont have a volunteer coming this year"]
[null,"Total Earnings",{"$f":"SUM(C3:C8)","v":925194},{"$f":"SUM(D3:D8)","v":622000}]
[]
[null,"Interest earned from Fixed Deposits",493317,"Same","We plough this back to the Corpus fund for long term sustainbility and DO NOT spend from that, hence donot consider it as usable income."]
[null,"Savings bank interest",10441,"Same"]
[]
[null,"Fees collected in 2013-14"]
[]
[null,"Students","Yearly fees",null,"The fees varies depending on what the parents have wished to pay based on their financial capacity"]
[null,"Student 1",30000]
[null,"Student 2",30000]
[null,"Student 3",30000]
[null,"Student 4",30000]
[null,"Student 5",30000]
[null,"Student 6",30000]
[null,"Student 7",20000]
[null,"Student 8",20000]
[null,"Student 9",6000]
[null,"Student 10",6000]
[null,"Student 11",3000]
[null,"Student 12",3000]
[null,"Student 13",3000]
[null,"Total fees",{"$f":"SUM(C17:C29)","v":241000}]