{"text_format":"2","workbook":"xlsx","n_sheets":1,"sheets":["Budget June 2015 - March 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 - March 2016","index":0,"n_rows":33,"n_cols":7,"rows_kept":33,"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 March 2016"]
["S.No","Activities","Unit","Unit Rate","No. of Units","Budget","Comments"]
["A","Personnel Cost",null,null,null,{"$f":"SUM(F5:F9)","v":353000}]
["A.1","Program Manager (1)","Per month",8000,10,{"$f":"D5*E5","v":80000},"Part time - Rs. 5,000 per month"]
["A.2","Facilitator - PCM / Documentation Officer","Per month",15000,5,{"$f":"D6*E6","v":75000},"New recruitment - higher salaries are needed to get quality staff members"]
["A.3","Facilitator - CBZ (1)","Per month",10000,10,100000,"New recruitment - higher salaries are needed to get quality staff members"]
["A.4","Driver (1)","Per month",7000,10,70000]
["A.5","Staff Benefit","Per month",{"$f":"SUM(D5:D8)*7%","v":2800.0000000000005},10,28000.000000000004,"7% of personnel cost"]
["B","Recurring Cost",null,null,null,{"$f":"F11+F16+F20+F21+F24","v":574500}]
["B.1","Technical & Resource Support",null,null,null,{"$f":"SUM(F12:F15)","v":230000}]
["B.1.1","Equipment & Chemicals","Per year",75000,1,{"$f":"D12*E12","v":75000},"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",50000,1,50000,"Addition of new materials for the resource centre for wider usage"]
["B.1.3","Other Materials","Per year",25000,1,25000,"Consumables for the school based activity sessions to be conducted"]
["B.1.4"," Newsletter & Other Publications","Per year",20000,4,80000,"Jaana Bandi to be published on a bimonthly basis (Rs. 5000 per issue) and other resource centre publications including catalogue and handbook"]
["B.2","Events & Capacity Building",null,null,null,{"$f":"SUM(F17:F19)","v":87000}]
["B.2.1","Vijnana Mela & National Science Day","Per year",70000,1,{"$f":"D17*E17","v":70000},"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.2","Vijnana Vedike and Teacher Meetings","Per month",1000,5,5000,"The expenses might be lower as the Vedike is ready to bear the expenses of the meetings"]
["B.2.3","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":"D20*E20","v":90000},"Costing is based on the DAVP rates"]
["B.4","Travel & Maintenance",null,null,null,{"$f":"SUM(F22:F23)","v":120000}]
["B.4.1","Staff Travel & Conveyance","Per month",3000,10,{"$f":"D22*E22","v":30000},"Based on the last years' usage"]
["B.4.2","Vehicle Travel & Maintenance","Per km",9000,10,90000,"Based on the last years' usage"]
["B.5","Operational Expenses",null,null,null,{"$f":"SUM(F25:F28)","v":47500}]
["B.5.1","Office Rent","Per month",2000,10,{"$f":"D25*E25","v":20000}]
["B.5.2","Stationery & Other expenses","Per month",500,10,5000]
["B.5.3","Phone calls & Internet","Per month",750,10,7500]
["B.5.4","Mentoring, Monitoring & Documentation","Per month",1500,10,15000]
["C","Capital expeses",null,null,null,{"$f":"F30","v":16500}]
["C.1","UPS","Per year",16500,1,{"$f":"D30*E30","v":16500},"The present UPS is over 4 years old and needs replacement"]
[null,"Budget",null,null,null,{"$f":"F10+F4+F29","v":944000}]
[null,"Overheads (4%)",null,null,null,{"$f":"F31*0.04","v":37760}]
[null,"Total Budget",null,null,null,{"$f":"F31+F32","v":981760}]