{"text_format":"2","workbook":"xlsx","n_sheets":2,"sheets":["Instructions","10 Students"],"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":"Instructions","index":0,"n_rows":10,"n_cols":2,"rows_kept":10,"cut":false,"hidden":false,"merged":[]}
[]
[null,"BMCC Faculty Led Study Abroad Program"]
[null,"Budget Template"]
[]
[null,"INSTRUCTIONS:"]
[null,"Faculty coordinators must complete a budget proposal for ten students. "]
[null,"Faculty coordinators should enter their group costs in the PINK CELLS ONLY.  Do not enter the \"per person\" amounts. "]
[null,"If a vendor has provided an estimate using \"per person\" figures, then multiply the estimate by the number of students at that attendance level and enter that amount in the pink cell. "]
[null,"The spreadsheet will compute the breakdown of costs and will calculate the student program fee (40% of the per-student costs) and the amount to be requested from the BMCC Association (60% of total student costs plus all faculty coordinator expenses).  "]
[null,"All items included in this budget MUST match the costs reflected in the documentation, statements and/or estimates from vendors (hoteliers, restaurants, transportation providers, excursion providers, etc.)."]

{"sheet":"10 Students","index":1,"n_rows":35,"n_cols":8,"rows_kept":35,"cut":false,"hidden":false,"merged":[[31,2,34,4],[0,1,0,4],[14,2,15,4],[17,1,17,4],[30,1,30,4],[24,2,29,4]]}
["Budget Items","Program Costs with 10 Students"]
["Student Costs","Itemized Costs with 10 Students-- Group TOTAL","Cost per Student","60% Total Cost -- Covered by Association","40% Total Cost -- Covered by Student Payments ","Please indicate the vendor/s for this item",null,"Notes"]
["Airfare (see notes)",null,{"$f":"B3/10","v":0},{"$f":"B3*0.6","v":0},{"$f":"B3*0.4","v":0},"Direct Travel ",null,"Email travel dates to jlevin@bmcc.cuny.edu by August 15 to obtain a flight estimate. "]
["Local In-Country Transportation ",null,{"$f":"B4/10","v":0},0,0]
["Housing ",null,0,0,0]
["Food",null,0,0,0]
["Guest Lecturer",null,0,0,0]
["Educational Course/ Cultural Excursion",null,0,0,0]
["Weekend Excursion/ Side Trip -- Housing",null,0,0,0]
["Weekend Excursion/ Side Trip -- Food",null,0,0,0]
["Weekend Excursion/ Side Trip -- Transportation",null,0,0,0]
["Travel/Medical Insurance ",null,0,0,0,"Cultural Insurance Services International ",null,"Email jlevin@bmcc.cuny.edu by August 15 to obtain an estimate. "]
["Other Expenses (Please Specify)",null,0,0,0]
["TOTAL STUDENT EXPENSES",{"$f":"SUM(B3:B13)","v":0},{"$f":"SUM(C3:C13)","v":0},{"$f":"SUM(D3:D13)","v":0},{"$f":"SUM(E3:E13)","v":0}]
["Amount of scholarship for each BMCC student (60%):  ",{"$f":"C14*0.6","v":0},"Do Not Write In This Space"]
["Amount to be paid by each student (40%): (Program FEE for Student)     ",{"$f":"C14*0.4","v":0}]
[]
["Coordinator's Expenses","Coordinator's Expenses for Program with 10 Students"]
["Airfare",null,"Do Not Write In This Space"]
["Local Transportation"]
["Housing"]
["Food"]
["Cultural Excusion #1"]
["Cutural Excursion #2"]
["Weekend Excursion/ Side Trip -- Housing",null,"Do Not Write In This Space"]
["Weekend Excursion/ Side Trip -- Food"]
["Weekend Excursion/ Side Trip -- Transportation"]
["Travel/Medical Insurance "]
["Other Expenses (Please Specify)"]
["Total Coordinator Expenses ",{"$f":"SUM(B19:B29)","v":0}]
["Total Allocation Requested From Association","Total Allocation Requested From Association with 10 Students"]
["60% Program Costs:",{"$f":"D14","v":0},"Do Not Write In This Space"]
["Coordinator's Expenses:",{"$f":"B30","v":0}]
["Emergency Expenses (per group)",750]
["Grand Total Requested from Association",{"$f":"SUM(B32:B34)","v":750}]