{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Budget Sheet (2)"],"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 Sheet (2)","index":0,"n_rows":49,"n_cols":13,"rows_kept":49,"cut":false,"hidden":false,"merged":[[9,6,9,7],[6,0,7,0],[0,0,0,5],[1,0,1,5],[48,0,48,5],[27,5,29,5]]}
["Budget (FY 2012-13)"]
["Name of Project: AANGAN - DAY CARE CENTRE"]
[]
["All figures are in Indian rupees"]
["The centre has children numbering between 30-50 children everyday. Costs are calculated considering an avergae of 40 children everyday."]
[]
["Budget Amount","In USD","In INR"]
[null,10000,{"$f":"10000*48","v":480000}]
[]
["Budget Head","Unit","Calculation","Yearly Amount (INR)","Yearly Amount (USD)","Remarks","Proposed budget for Asha - Sta. Louise",null,"Remarks","Funds from iPartner","Funds from Royal Bak of Scotland (through CAF) - Rs. 184000","Funds from Max India Foundation - Rs. 24500 p.m.","Funds from Delhi West Round table 50 - Rs. 15000 p.m."]
["PROGRAMS COST (ACTIVITIES)",{"$nulls":5},"INR","USD"]
[]
["Teaching & Learning material","40 children","40X12@Rs.100",{"$f":"40*12*100","v":48000},{"$f":"D13/48","v":1000},"This is the informal education provided by Jamghat's Educators to 30-50 children in the centre.",{"$f":"40*8*100","v":32000},{"$f":"G13/48","v":666.66666666666663},"for 8 months"]
["Rent for space for conducting classes, providing bathing & Toilet facilities to street children","1 centre @ Rs. 17000","1X12@Rs.17000",{"$f":"1*12*17000","v":204000},{"$f":"D14/48","v":4250},null,{"$f":"7500*8","v":60000},{"$f":"G14/48","v":1250},"for 8 months",null,null,{"$f":"9500*12","v":114000}]
["Formal Education (Regular schools & admission in National School of Open Learning)","10 children @ Rs. 1200 per child","10X12 @ Rs.1200",{"$f":"10*12*1200","v":144000},3000,null,0,0,"-",null,{"$f":"10*12*1200","v":144000}]
["Educational outings & picnics","40 children, 4 in a year @ Rs.300 per child","40X4@Rs.300",{"$f":"40*4*300","v":48000},1000,null,8000,166.66666666666666,"for one quarter",null,{"$f":"40000","v":40000}]
["Food","40 children @ Rs. 20 per day/child","40X312 days @ Rs.20",{"$f":"40*312*20","v":249600},5200,"Includes breakfast, luch & evening snacks provided to all children in centre",0,0,"-",null,null,{"$f":"12*5800","v":69600},{"$f":"12*15000","v":180000}]
["Installation/maintenance of study furniture, mats, individual lockers for children etc.","1 centre @ Rs. 5000 per year","1@Rs.5000",{"$f":"1*1*5000","v":5000},104.16666666666667,null,0,0,"-"]
["Medical expenses","40 @ Rs. 50 per month/child","40X12 @Rs.50",{"$f":"40*12*50","v":24000},500,null,{"$f":"40*8*50","v":16000},333.33333333333331,"for 8 months"]
["Major Medical Emergency","50 children @ Rs. 2000 per month","12months @Rs.2000",{"$f":"12*2000","v":24000},500,null,{"$f":"2000*8","v":16000},333.33333333333331,"for 8 months",null,null,{"$f":"3*2000","v":6000}]
["Counseling",1,"12 @ Rs. 7000",{"$f":"12*7000","v":84000},1750,null,0,0,"-"]
["Clothes","Twice a year @ Rs.500 per child","2X40 @ Rs.500",{"$f":"2*40*500","v":40000},833.33333333333337,"Purchased every six months - 2 sets of summer/ winter clothes with shoes/slippers etc.",{"$f":"1*40*500","v":20000},416.66666666666669,"for 8 months"]
["Toiletry","40 @ Rs.70 per child","40X12 @ Rs.70",{"$f":"40*12*60","v":28800},600,null,{"$f":"40*8*70","v":22400},466.66666666666669,"for 8 months"]
["Sub Total A",null,null,{"$f":"SUM(D13:D23)","v":899400},{"$f":"SUM(E13:E23)","v":18737.499999999996},null,{"$f":"SUM(G13:G23)","v":174400},3633.333333333333,null,null,184000,189600,180000]
[]
["HUMAN RESOURCES (SALARIES)"]
[]
["Director",1,"12 months X 3 centres @ Rs. 9167 per centre",{"$f":"12*9167","v":110004},{"$f":"D28/48","v":2291.75},"Divided among all three budgets for Jamghat's three centres",{"$f":"8*9167","v":73336},{"$f":"G28/48","v":1527.8333333333333},"for 8 months"]
["Programme Head - Jamghat",1,"12 months X 3 centres @ Rs. 6234 per centre",{"$f":"12*6234","v":74808},1558.5,null,{"$f":"8*6234","v":49872},1039,"for 8 months"]
["Driver",1,"12 months X 3 centres @ Rs. 2567 per centre",{"$f":"12*2567","v":30804},641.75,null,{"$f":"8*2567","v":20536},427.83333333333331,"for 8 months"]
[]
["Programme Head - Aangan",1,"1 @ Rs. 18700",{"$f":"12*18700","v":224400},4675,null,0,0,"-"]
["Supervisor - Aangan",1,"1 @ Rs. 9350",{"$f":"12*9350","v":112200},2337.5,null,{"$f":"8*9350","v":74800},1558.3333333333333,"for 8 months"]
["Coordinator - Aangan",1,"1 @ Rs. 7700",{"$f":"12*7700","v":92400},1925,null,{"$f":"8*7700","v":61600},1283.3333333333333,"for 8 months"]
["Educator - Aangan",1,"1 @ Rs. 7700",{"$f":"12*7700","v":92400},1925,null,0,0,"-",null,null,{"$f":"12*7700","v":92400}]
["Care taker + Cook - Aangan",1,"1 @ Rs. 7700",{"$f":"12*7700","v":92400},1925,null,0,0,"-",{"$f":"7000*12","v":84000}]
["Sub Total B",null,null,{"$f":"SUM(D28:D36)","v":829416},{"$f":"SUM(E28:E36)","v":17279.5},null,{"$f":"SUM(G28:G36)","v":280144},5836.333333333333,null,null,0,92400,0]
[]
["ADMINISTRATION COST"]
[]
["Maintenance","1 centre","12 months @ Rs. 1000",{"$f":"12*1000","v":12000},{"$f":"D41/48","v":250},null,0,{"$f":"G41/48","v":0},"-",null,null,{"$f":"12*1000","v":12000}]
["Accountant costs","1 centre","12 months @ Rs. 5000",{"$f":"12*5000","v":60000},1250,null,0,0,"-"]
["Communication","1 centre","12 months @ Rs. 1000",{"$f":"12*1000","v":12000},250,null,{"$f":"1000*8","v":8000},166.66666666666666,"for 8 months"]
["Office Travel","1 centre","12 months @ Rs. 1500",{"$f":"12*1500","v":18000},375,null,{"$f":"8*1500","v":12000},250,"for 8 months"]
["Miscellaneous","1 centre","12 months @ Rs. 1500",{"$f":"12*1500","v":18000},375,null,0,0,"-"]
["Sub Total C",null,null,{"$f":"SUM(D41:D45)","v":120000},{"$f":"SUM(E41:E45)","v":2500},null,{"$f":"SUM(G41:G45)","v":20000},416.66666666666663,null,null,0,12000,0]
["Total Budgetary Allocation (A+B+C)",null,null,{"$f":"D24+D37+D46","v":1848816},{"$f":"E24+E37+E46","v":38517},null,{"$f":"G24+G37+G46","v":474544},9886.3333333333321,null,null,184000,294000,180000]
[]
["Note: The centre receives some monthly donations from individuals, not exceeding Rs. 23000 per month."]