{"text_format":"2","workbook":"xlsx","n_sheets":5,"sheets":["Fall Budget","Spring Budget","Winter Budget (Quarter School)","Formulas","Lists"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":1,"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":"Fall Budget","index":0,"n_rows":87,"n_cols":19,"rows_kept":87,"cut":false,"hidden":false,"merged":[[15,10,15,15],[16,10,16,15],[19,10,19,15],[27,1,27,2],[32,1,32,2],[39,1,39,2],[37,1,37,9],[39,4,39,6],[40,4,54,6],[53,1,53,2],[57,4,57,5],[1,1,1,7],[2,1,2,7],[3,1,3,9],[5,1,5,2],[5,4,5,9],[6,4,32,9],[16,1,16,2]]}
[]
[null,"The Delta Chi Fraternity - CHAPTER NAME "]
[null,"Schedule of Chapter Fees - Semester Schools"]
[null,"INCOME"]
[]
[null,"Fall Active Members Dues Breakdown",null,null,"Instructions"]
[null,"Billing Setup","Amount",null,"1. Enter any remaining fixed costs into yellow boxes. \n2. Enter your expenses for the semester in the expenses section. Think of all your chapter operations and events for the semester and allocate funds to each.\n3. Based on your expenses and fixed cost for the semester determine how much you need to charge active members. Remember that it is always a good idea to have a rainy day fund built in.To calculate how much to allocate towards \"Chapter Dues\" take the total number of \nfixed costs (light grey box) and subtract from the total you want to charge for the semester.\nEX: Light Grey box total is $324. You charge $750 total for the semester. \nSubtract $324 from $750 ($750 - $324 = $426) \n3. Enter this number in the green box. \n4. The total in the light blue box should equal what you charge for the semester. \n5.Enter the number of fall active members in the purple box.\n6.  Enter an estimate of how many new members you will have in the fall (it is better \nto budget for less new members) in the light pink box\n7. Once everything is entered, the total income projected will be calculated in \nthe \"Income Projections\" box.  \n* If you delete any of the pre-entered formulas, you can select the formulas tab to find \nthe formulas you need and which cells to enter them in*\n8. Review your total income and total expenses for the semester. If your expenses are greater than your income, you will need to revise your budget."]
[null,"FALL National Dues ",90.0]
[null,"FALL Housing Initiative Fund",15.0]
[null,"FALL RMA: 60% billed in Fall"]
[null,"IFC Dues"]
[null,"Billing System Fees"]
[null,"Total Fixed Costs",{"$f":"SUM(C8:C12)","v":105}]
[null,"FALL Initiated Member Chapter Dues "]
[null,"Total Fall Billing",{"$f":"(C13+C14)","v":105}]
[]
[null,"Fall Associate Member Dues Breakdown"]
[null,"Billing Setup","Amount",{"$nulls":15}," "]
[null,"National Associate Member Fee ",125.0]
[null,"National Initiation Fee ",250.0]
[null,"Pin/Badge /Cornerstone Fee",59.0]
[null,"IFC Dues"]
[null,"Billing System Fees"]
[null,"Total Fixed Costs",{"$f":"SUM(C19:C23)","v":434}]
[null,"FALL Associate Member Chapter Dues "]
[null,"Total Fall Billing",{"$f":"SUM(C24+C25)","v":434}]
[]
[null,"Fall Membership Projections"]
[null,"Active Members"]
[null,"New Members "]
[null,"Total Projected Members",{"$f":"sum(C29:C30)","v":0}]
[]
[null,"Total Income Projections"]
[null,"Total Income Projected",{"$f":"(C15*C29)+(C26*C30)","v":0}]
[null,"Income for Fixed Costs",{"$f":"(C13*C29)+(C24*C30)","v":0}]
[null,"Amount Remaining",{"$f":"Sum(C34-C35)","v":0}]
[]
[null,"EXPENSES"]
[]
[null,"Fixed Costs",null,null,"Instructions"]
[null,"Initiated Member National Dues ",{"$f":"C8*C29","v":0},null,"1. Make sure cells C52 and C35 match. \n2. Begin entering in your budget for each category. \n3. Check the Net Income cell (F60) to ensure you are not going over budget. Adjust \ncategories as needed. \n4. If you need to add any additional categories, add them in the \"Other\" section. \nIf you need more than 6 additional categories follow these steps: \nSelect row 81 --> Right Click --> Insert 1 row above. \nThis will ensure the additional row is included in the total expenses formula in Cell C87"]
[null,"National Housing Initiative Fee",{"$f":"C9*C29","v":0}]
[null,"National Associate Member Fees ",{"$f":"C19*C30","v":0}]
[null,"National Initiation Fees ",{"$f":"C20*C30","v":0}]
[null,"Fall RMA Expense",{"$f":"C10*C29","v":0}]
[null,"Initiated Member IFC Dues",{"$f":"C11*C29","v":0}]
[null,"Associate Member IFC Dues",{"$f":"C22*C30","v":0}]
[null,"Billing System Fees",{"$f":"(C12*C29)+(C23*C30)","v":0}]
[null,"Pin/Badge/Cornerstone Fees",{"$f":"C21*C30","v":0}]
[null,"Convention Assessment"]
[null,"RLA Assessment"]
[null,"Total Fixed Costs",{"$f":"SUM(C41:C51)","v":0}]
[]
[null,"Other Expenses"]
[null,"Administration Fees ",0.0]
[null,"Alumni Relations",0.0]
[null,"Associate Member",0.0]
[null,"Brotherhood",0.0,null,"Total Expenses Projected"]
[null,"Chartering",0.0,null,"Expenses ",{"$f":"C52+C87","v":0}]
[null,"Community Service",0.0,null,"Net Income",{"$f":"C34-F59","v":0}]
[null,"Conferences/Travel ",0.0]
[null,"Composite ",0.0]
[null,"Diversity, Equity, & Inclusion ",0.0]
[null,"Family Weekend(s) ",0.0]
[null,"Formal ",0.0]
[null,"Greek Relations",0.0]
[null,"Health and Wellness",0.0]
[null,"Homecoming",0.0]
[null,"Member Development",0.0]
[null,"Officer Budgets",0.0]
[null,"Other Events",0.0]
[null,"Payments to House Corps",0.0]
[null,"Philanthropy",0.0]
[null,"Recruitment",0.0]
[null,"Reserve (Rainy day Fund)",0.0]
[null,"Retreat ",0.0]
[null,"Ritual ",0.0]
[null,"Semi-Formal ",0.0]
[null,"Scholarship",0.0]
[null,"Social",0.0]
[null,"Other",0.0]
[null,"Other ",0.0]
[null,"Other",0.0]
[null,"Other",0.0]
[null,"Other",0.0]
[null,"Other",0.0]
[null,"Total Chapter Expenses",{"$f":"SUM(C55:C86)","v":0}]

{"sheet":"Spring Budget","index":1,"n_rows":87,"n_cols":19,"rows_kept":87,"cut":false,"hidden":false,"merged":[[15,10,15,15],[16,10,16,15],[19,10,19,15],[27,1,27,2],[32,1,32,2],[39,1,39,2],[37,1,37,9],[39,4,39,6],[40,4,54,6],[53,1,53,2],[57,4,57,5],[1,1,1,7],[2,1,2,7],[3,1,3,9],[5,1,5,2],[5,4,5,9],[7,4,33,9],[16,1,16,2]]}
[]
[null,"The Delta Chi Fraternity - CHAPTER NAME "]
[null,"Schedule of Chapter Fees - Semester Schools"]
[null,"INCOME"]
[]
[null,"Spring Active Members Dues Breakdown",null,null,"Instructions"]
[null,"Billing Setup","Amount"]
[null,"SPRING National Dues ",95.0,null,"1. Enter any remaining fixed costs into yellow boxes. \n2. Enter your expenses for the semester in the expenses section. Think of all your chapter operations and events for the semester and allocate funds to each.\n3. Based on your expenses and fixed cost for the semester determine how much you need to charge active members. Remember that it is always a good idea to have a rainy day fund built in.To calculate how much to allocate towards \"Chapter Dues\" take the total number of \nfixed costs (light grey box) and subtract from the total you want to charge for the semester.\nEX: Light Grey box total is $324. You charge $750 total for the semester. \nSubtract $324 from $750 ($750 - $324 = $426) \n3. Enter this number in the green box. \n4. The total in the light blue box should equal what you charge for the semester. \n5.Enter the number of spring active members in the purple box.\n6.  Enter an estimate of how many new members you will have in the spring (it is better \nto budget for less new members) in the light pink box\n7. Once everything is entered, the total income projected will be calculated in \nthe \"Income Projections\" box.  \n* If you delete any of the pre-entered formulas, you can select the formulas tab to find \nthe formulas you need and which cells to enter them in*\n8. Review your total income and total expenses for the semester. If your expenses are greater than your income, you will need to revise your budget."]
[null,"SPRING Housing Initiative Fund",15.0]
[null,"SPRING RMA: 40% billed in Spring",0.0]
[null,"IFC Dues",0.0]
[null,"Billing System Fees"]
[null,"Total Fixed Costs",{"$f":"SUM(C8:C12)","v":110}]
[null,"SPRING Initiated Member Chapter Dues ",0.0]
[null,"Total Spring Billing",{"$f":"(C13+C14)","v":110}]
[]
[null,"Spring Associate Member Dues Breakdown"]
[null,"Billing Setup","Amount",{"$nulls":15}," "]
[null,"National Associate Member Fee ",125.0]
[null,"National Initiation Fee ",250.0]
[null,"Pin/Badge /Cornerstone Fee",59.0]
[null,"IFC Dues",0.0]
[null,"Billing System Fees"]
[null,"Total Fixed Costs",{"$f":"SUM(C19:C23)","v":434}]
[null,"SPRING Associate Member Chapter Dues ",0.0]
[null,"Total Spring Billing",{"$f":"SUM(C24+C25)","v":434}]
[]
[null,"Spring Membership Projections"]
[null,"Active Members",0.0]
[null,"New Members ",0.0]
[null,"Total Projected Members",{"$f":"sum(C29:C30)","v":0}]
[]
[null,"Total Income Projections"]
[null,"Total Income Projected",{"$f":"(C15*C29)+(C26*C30)","v":0}]
[null,"Income for Fixed Costs",{"$f":"(C13*C29)+(C24*C30)","v":0}]
[null,"Amount Remaining",{"$f":"Sum(C34-C35)","v":0}]
[]
[null,"EXPENSES"]
[]
[null,"Fixed Costs",null,null,"Instructions"]
[null,"Initiated Member National Dues ",{"$f":"C8*C29","v":0},null,"1. Make sure cells C52 and C35 match. \n2. Begin entering in your budget for each category. \n3. Check the Net Income (F60) to ensure you are not going over budget. Adjust \ncategories as needed. \n4. If you need to add any additional categories, add them in the \"Other\" section. \nIf you need more than 6 additional categories follow these steps: \nSelect row 81 --> Right Click --> Insert 1 row above. \nThis will ensure the additional row is included in the total expenses formula in Cell C87"]
[null,"National Housing Initiative Fee",{"$f":"C9*C29","v":0}]
[null,"National Associate Member Fees ",{"$f":"C19*C30","v":0}]
[null,"National Initiation Fees ",{"$f":"C20*C30","v":0}]
[null,"Spring RMA Expense",{"$f":"C10*C29","v":0}]
[null,"Initiated Member IFC Dues",{"$f":"C11*C29","v":0}]
[null,"Associate Member IFC Dues",{"$f":"C22*C30","v":0}]
[null,"Billing System Fees",{"$f":"(C12*C29)+(C23*C30)","v":0}]
[null,"Pin/Badge/Cornerstone Fees",{"$f":"C21*C30","v":0}]
[null,"Convention Assessment",1200.0]
[null,"RLA Assessment",1200.0,"RLA Assessment is subject to change"]
[null,"Total Fixed Costs",{"$f":"SUM(C41:C51)","v":2400}]
[]
[null,"Other Expenses"]
[null,"Administration Fees ",0.0]
[null,"Alumni Relations",0.0]
[null,"Associate Member",0.0]
[null,"Brotherhood",0.0,null,"Total Expenses Projected"]
[null,"Chartering",0.0,null,"Expenses ",{"$f":"C52+C87","v":2400}]
[null,"Community Service",0.0,null,"Net Income",{"$f":"C34-F59","v":-2400}]
[null,"Conferences/Travel ",0.0]
[null,"Composite ",0.0]
[null,"Diversity, Equity, & Inclusion ",0.0]
[null,"Family Weekend(s) ",0.0]
[null,"Formal ",0.0]
[null,"Greek Relations",0.0]
[null,"Health and Wellness",0.0]
[null,"Homecoming",0.0]
[null,"Member Development",0.0]
[null,"Officer Budgets",0.0]
[null,"Other Events",0.0]
[null,"Payments to House Corps",0.0]
[null,"Philanthropy",0.0]
[null,"Recruitment",0.0]
[null,"Reserve (Rainy day Fund)",0.0]
[null,"Retreat ",0.0]
[null,"Ritual ",0.0]
[null,"Semi-Formal ",0.0]
[null,"Scholarship",0.0]
[null,"Social",0.0]
[null,"Other",0.0]
[null,"Other ",0.0]
[null,"Other",0.0]
[null,"Other",0.0]
[null,"Other",0.0]
[null,"Other",0.0]
[null,"Total Chapter Expenses",{"$f":"SUM(C55:C86)","v":0}]

{"sheet":"Winter Budget (Quarter School)","index":2,"n_rows":87,"n_cols":19,"rows_kept":87,"cut":false,"hidden":false,"merged":[[15,10,15,15],[16,10,16,15],[19,10,19,15],[27,1,27,2],[32,1,32,2],[39,1,39,2],[37,1,37,9],[39,4,39,6],[40,4,54,6],[53,1,53,2],[57,4,57,5],[1,1,1,7],[2,1,2,7],[3,1,3,9],[5,1,5,2],[5,4,5,9],[7,4,33,9],[16,1,16,2]]}
[]
[null,"The Delta Chi Fraternity - CHAPTER NAME "]
[null,"Schedule of Chapter Fees -Quarter Schools"]
[null,"INCOME"]
[]
[null,"Winter Active Members Dues Breakdown",null,null,"Instructions"]
[null,"Billing Setup","Amount"]
[null,"WINTER National Dues ",null,null,"1. Enter any remaining fixed costs into yellow boxes. \n2. Enter your expenses for the semester in the expenses section. Think of all your chapter operations and events for the semester and allocate funds to each.\n3. Based on your expenses and fixed cost for the semester determine how much you need to charge active members. Remember that it is always a good idea to have a rainy day fund built in.To calculate how much to allocate towards \"Chapter Dues\" take the total number of \nfixed costs (light grey box) and subtract from the total you want to charge for the semester.\nEX: Light Grey box total is $324. You charge $750 total for the semester. \nSubtract $324 from $750 ($750 - $324 = $426) \n3. Enter this number in the green box. \n4. The total in the light blue box should equal what you charge for the semester. \n5.Enter the number of winter active members in the purple box.\n6.  Enter an estimate of how many new members you will have in the winter (it is better \nto budget for less new members) in the light pink box\n7. Once everything is entered, the total income projected will be calculated in \nthe \"Income Projections\" box.  \n* If you delete any of the pre-entered formulas, you can select the formulas tab to find \nthe formulas you need and which cells to enter them in*\n8. Review your total income and total expenses for the semester. If your expenses are greater than your income, you will need to revise your budget."]
[null,"WINTER Housing Initiative Fund"]
[null,"WINTER RMA: 40% billed in Winter",0.0]
[null,"IFC Dues",0.0]
[null,"Billing System Fees"]
[null,"Total Fixed Costs",{"$f":"SUM(C8:C12)","v":0}]
[null,"Winter Initiated Member Chapter Dues ",0.0]
[null,"Total Winter Billing",{"$f":"(C13+C14)","v":0}]
[]
[null,"Winter Associate Member Dues Breakdown"]
[null,"Billing Setup","Amount",{"$nulls":15}," "]
[null,"National Associate Member Fee ",125.0]
[null,"National Initiation Fee ",250.0]
[null,"Pin/Badge /Cornerstone Fee",59.0]
[null,"IFC Dues",0.0]
[null,"Billing System Fees"]
[null,"Total Fixed Costs",{"$f":"SUM(C19:C23)","v":434}]
[null,"Winter Associate Member Chapter Dues ",0.0]
[null,"Total Winter Billing",{"$f":"SUM(C24+C25)","v":434}]
[]
[null,"Winter Membership Projections"]
[null,"Active Members",0.0]
[null,"New Members ",0.0]
[null,"Total Projected Members",{"$f":"sum(C29:C30)","v":0}]
[]
[null,"Total Income Projections"]
[null,"Total Income Projected",{"$f":"(C15*C29)+(C26*C30)","v":0}]
[null,"Income for Fixed Costs",{"$f":"(C13*C29)+(C24*C30)","v":0}]
[null,"Amount Remaining",{"$f":"Sum(C34-C35)","v":0}]
[]
[null,"EXPENSES"]
[]
[null,"Fixed Costs",null,null,"Instructions"]
[null,"Initiated Member National Dues ",{"$f":"C8*C29","v":0},null,"1. Make sure cells C52 and C35 match. \n2. Begin entering in your budget for each category. \n3. Check the Net Income cell (F60) to ensure you are not going over budget. Adjust \ncategories as needed. \n4. If you need to add any additional categories, add them in the \"Other\" section. \nIf you need more than 6 additional categories follow these steps: \nSelect row 81 --> Right Click --> Insert 1 row above. \nThis will ensure the additional row is included in the total expenses formula in Cell C87"]
[null,"National Housing Initiative Fee",{"$f":"C9*C29","v":0}]
[null,"National Associate Member Fees ",{"$f":"C19*C30","v":0}]
[null,"National Initiation Fees ",{"$f":"C20*C30","v":0}]
[null,"Winter RMA Expense",{"$f":"C10*C29","v":0}]
[null,"Initiated Member IFC Dues",{"$f":"C11*C29","v":0}]
[null,"Associate Member IFC Dues",{"$f":"C22*C30","v":0}]
[null,"Billing System Fees",{"$f":"(C12*C29)+(C23*C30)","v":0}]
[null,"Pin/Badge/Cornerstone Fees",{"$f":"C21*C30","v":0}]
[null,"Convention Assessment"]
[null,"RLA Assessment"]
[null,"Total Fixed Costs",{"$f":"SUM(C41:C51)","v":0}]
[]
[null,"Other Expenses"]
[null,"Administration Fees ",0.0]
[null,"Alumni Relations",0.0]
[null,"Associate Member",0.0]
[null,"Brotherhood",0.0,null,"Total Expenses Projected"]
[null,"Chartering",0.0,null,"Expenses ",{"$f":"C52+C87","v":0}]
[null,"Community Service",0.0,null,"Net Income",{"$f":"C34-F59","v":0}]
[null,"Conferences/Travel ",0.0]
[null,"Composite ",0.0]
[null,"Diversity, Equity, & Inclusion ",0.0]
[null,"Family Weekend(s) ",0.0]
[null,"Formal ",0.0]
[null,"Greek Relations",0.0]
[null,"Health and Wellness",0.0]
[null,"Homecoming",0.0]
[null,"Member Development",0.0]
[null,"Officer Budgets",0.0]
[null,"Other Events",0.0]
[null,"Payments to House Corps",0.0]
[null,"Philanthropy",0.0]
[null,"Recruitment",0.0]
[null,"Reserve (Rainy day Fund)",0.0]
[null,"Retreat ",0.0]
[null,"Ritual ",0.0]
[null,"Semi-Formal ",0.0]
[null,"Scholarship",0.0]
[null,"Social",0.0]
[null,"Other",0.0]
[null,"Other ",0.0]
[null,"Other",0.0]
[null,"Other",0.0]
[null,"Other",0.0]
[null,"Other",0.0]
[null,"Total Chapter Expenses",{"$f":"SUM(C55:C86)","v":0}]

{"sheet":"Formulas","index":3,"n_rows":16,"n_cols":6,"rows_kept":16,"cut":false,"hidden":false,"merged":[[1,0,1,1],[1,3,1,4],[2,3,8,4],[11,0,11,1],[17,0,17,1]]}
[]
["Income Formulas",null,null,"Tips",null,"Questions?"]
["C13","SUM(C8:C12)",null,"- Make sure to enter the = sign \nbefore re-entering your formula.\n\n",null,"Email: membership@deltachi.org "]
["C15","(C13+C14)"]
["C24","(C19:C23)"]
["C26","(C24+C25)"]
["C31","(C29:C30)"]
["C34","(C15*C29)+(C26*C30)"]
["C35","(C13*C29)+(C24*C30)"]
["C36","SUM(C34-C35)"]
[]
["Expenses Formulas"]
["C52","SUM(C41:C51)"]
["C87","SUM(C55:C86)"]
["F59","C52+C87"]
["F60","C34-F59"]

{"sheet":"Lists","index":4,"n_rows":31,"n_cols":12,"rows_kept":31,"cut":false,"hidden":true,"merged":[]}
[650.0,null,"Other (Input this income in \"Budget\" tab)","COA"]
[1025.0,null,"Other Local Philanthropy/Community Service",4540.0]
[1500.0,null,"General Social Income",4280.0]
[null,null,"Gifts Income",4320.0]
[null,null,"Recruitment Income",4310.0]
[null,null,"Founders Day Income",4260.0]
[null,null,"Parent's Weekend Income",4270.0]
[null,null,"Shamrock Donation",4520.0]
[]
[]
["Event expenses are taken out of funds raised to reimburse the chapter"]
["Event expenses are covered by chapter dues so all funds raised can be donated"]
["Expenses up to 20% of funds raised are reimbursed and the rest is covered by dues"]
[]
[{"$nulls":11},"NCDP"]
["Fall Semester",{"$nulls":10},"Payments to NKD"]
["Spring Semester",{"$nulls":10},"Membership"]
["We have events both semesters",{"$nulls":10},"Elections and Transitions"]
[{"$nulls":11},"Campus Involvement and Leadership"]
[{"$nulls":11},"Executive Operations"]
[{"$nulls":11},"Council/CAB/LHV/NKD Relationships"]
[{"$nulls":11},"Chapter Housing"]
[{"$nulls":11},"Budget Management"]
[{"$nulls":11},"Financial Delinquencies"]
[{"$nulls":11},"Member and New Member Education"]
[{"$nulls":11},"Recruitment"]
[{"$nulls":11},"Sisterhood and Inclusion"]
[{"$nulls":11},"Public Relations/Marketing and Alumnae Outreach"]
[{"$nulls":11},"Panhellenic"]
[{"$nulls":11},"Girl Scouts"]
[{"$nulls":11},"Social Responsibility, Accountability and Member Safety"]