{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Budget June 2015 - May 2016"],"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 June 2015 - May 2016","index":0,"n_rows":38,"n_cols":8,"rows_kept":38,"cut":false,"hidden":false,"merged":[[0,0,0,6],[1,0,1,6]]}
["Mobile Science Lab - ASHA for Education, Boston Chapter"]
["Project Period - 1st June 2015 to 31st May 2016"]
["S.No","Activities","Unit","Unit Rate","No. of Units","Budget","Comments"]
["A","Personnel Cost",null,null,null,{"$f":"SUM(F5:F10)","v":603480}]
["A.1","Program Manager (1)","Per month",5000,12,{"$f":"D5*E5","v":60000},"Part time - Rs. 5,000 per month"]
["A.2","Facilitator - PCM (1)","Per month",10000,12,{"$f":"D6*E6","v":120000},"New recruitment - higher salaries are needed to get quality staff members"]
["A.3","Facilitator - CBZ (1)","Per month",10000,12,120000,"New recruitment - higher salaries are needed to get quality staff members"]
["A.4","Documentation Officer (1)","Per month",15000,12,180000,"New recruitment -  additional personnel required for the documentation of the question boxes"]
["A.5","Driver (1)","Per month",7000,12,84000]
["A.6","Staff Benefit","Per month",{"$f":"SUM(D5:D9)*7%","v":3290.0000000000005},12,39480.000000000007,"7% of personnel cost"]
["B","Recurring Cost",null,null,null,{"$f":"F12+F18+F25+F26+F29","v":630000}]
["B.1","Technical & Resource Support",null,null,null,{"$f":"SUM(F13:F17)","v":145000}]
["B.1.1","Equipment & Chemicals","Per year",40000,1,{"$f":"D13*E13","v":40000},"All the equipment and chemicals to be purchased during the vacation - major costs include replacement of damaged equipment or addition of multiple sets where required"]
["B.1.2","Books, CDs & DVDs","Per year",20000,1,20000,"Addition of new materials for the resource centre for wider usage"]
["B.1.3","Other Materials","Per year",15000,1,15000,"Consumables for the school based activity sessions to be conducted"]
["B.1.4"," Newsletter & Other Publications","Per month",5000,6,30000,"Jaana Bandi to be published on a bimonthly basis (Rs. 5000 per issue) and other resource centre publication including catalogue and handbook"]
["B.1.5","Question Boxes","Per quarter",10000,4,40000,"A minimum expense of Rs. 40,000 is expected for the printing of the questions and answers books for the teachers and schools"]
["B.2","Events & Capacity Building",null,null,null,{"$f":"SUM(F19:F24)","v":224000}]
["B.2.1","Teacher Training Programs","Per program",10000,4,{"$f":"D19*E19","v":40000},"The training programs are envisioned to be hands-on experiences for the teachers - the expenses might be lesser if the KSTA grant comes through"," "]
["B.2.2","School Based Programs","Per program",10000,4,40000,"School based programs will include observations like pi day, ozone protection day, engineers day, mathematics day, etc. conducted at the school level"]
["B.2.3","Vijnana Mela & National Science Day","Per year",80000,1,80000,"Vijnana Mela and the National Science Day are being conducted as 2 separate programs from last year - the budget is based on the expenses incurred last year"]
["B.2.4","Career Guidance Programs","Per year",40000,1,40000,"Career guidance program for the SSLC students in the Government High Schools"]
["B.2.5","Vijnana Vedike and Teacher Meetings","Per month",1000,12,12000,"The expenses might be lower as the Vedike is ready to bear the expenses of the meetings"]
["B.2.6","Staff Meetings & Capacity Building","Per month",3000,4,12000,"This includes the review meetings, exposure visits and training programs for the staff"]
["B.3","Community Radio Programms","Per program",6000,15,{"$f":"D25*E25","v":90000},"Costing is based on the DAVP rates"]
["B.4","Travel & Maintenance",null,null,null,{"$f":"SUM(F27:F28)","v":120000}]
["B.4.1","Staff Travel &Conveyance","Per month",2500,12,{"$f":"D27*E27","v":30000},"Based on the last years' usage"]
["B.4.2","Vehicle Travel & Maintenance","Per km",7500,12,90000,"Based on the last years' usage"]
["B.5","Operational Expenses",null,null,null,{"$f":"SUM(F30:F33)","v":51000}]
["B.5.1","Office Rent","Per month",1500,12,{"$f":"D30*E30","v":18000}]
["B.5.2","Stationery & Other expenses","Per month",500,12,6000]
["B.5.3","Phone calls & Internet","Per month",750,12,9000]
["B.5.4","Mentoring, Monitoring & Documentation","Per month",1500,12,18000]
["C","Capital expeses",null,null,null,{"$f":"F35","v":16500}]
["C.1","UPS","Per year",16500,1,{"$f":"D35*E35","v":16500},"The present UPS is over 4 years old and needs replacement"]
[null,"Budget",null,null,null,{"$f":"F11+F4+F34","v":1249980}]
[null,"Overheads (4%)",null,null,null,{"$f":"F36*0.04","v":49999.200000000004}]
[null,"Total Budget",null,null,null,{"$f":"F36+F37","v":1299979.2}]