Responses

Buck1985
JonathanBudgetChart.xlsx
Home>Education homework help>Responses

Sheet1

FY Operating Budget Jonathan Wells 7-Oct-20 HEA-620 Dr. Hamluk
Career Services Department
Student College
July August September October November December January February March April May June Totals:
Expense Line Item Budget Actual Budget Actual Budget Actual Budget Actual Budget Actual Budget Actual Budget Actual Budget Actual Budget Actual Budget Actual Budget Actual Budget Actual Budget Actual
Revenues $ - 0 $ - 0
Initial Estimated Budget $ 1,628,000.00 $ 1,628,000.00 $ - 0
Expenses $ - 0 $ - 0
Staff Salaries and Benefits $ (92,783.37) $ (92,783.33) $ (92,783.33) $ (92,783.33) $ (92,783.33) $ (92,783.33) $ (92,783.33) $ (92,783.33) $ (92,783.33) $ (92,783.33) $ (92,783.33) $ (92,783.33) $ (1,113,400.00) $ - 0
Office Supplies $ (247.32) $ - 0 $ (247.32) $ - 0 $ (247.32) $ - 0 $ (247.32) $ - 0 $ (247.32) $ - 0 $ (247.32) $ - 0 $ (1,483.92) $ - 0
Student Staff Training $ - 0 $ (1,500.00) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ (1,500.00) $ - 0
Staff Professional Development $ - 0 $ - 0 $ - 0 $ (399.90) $ - 0 $ - 0 $ - 0 $ - 0 $ (185.00) $ - 0 $ - 0 $ - 0 $ (584.90) $ - 0
New Student Orientation $ - 0 $ (200,000.00) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ (200,000.00) $ - 0
Marketing Materials $ (5,426.00) $ (5,426.00) $ (5,426.00) $ (5,426.00) $ (5,426.00) $ (5,426.00) $ (5,426.00) $ (5,426.00) $ (5,426.00) $ (5,426.00) $ (5,426.00) $ (5,426.00) $ (65,112.00) $ - 0
Institutional Memberships $ (4,107.00) $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ (4,107.00) $ - 0
Social Justice Training Institute $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ - 0 $ (1,500.00) $ - 0 $ (1,500.00) $ - 0
Travel $ (200.00) $ (200.00) $ (200.00) $ (1,000.00) $ (200.00) $ (200.00) $ (200.00) $ (200.00) $ (700.00) $ (200.00) $ (1,000.00) $ (200.00) $ (4,500.00) $ - 0
Meals and Entertainment $ (150.00) $ (150.00) $ (150.00) $ (150.00) $ (150.00) $ (150.00) $ (150.00) $ (150.00) $ (150.00) $ (150.00) $ (150.00) $ (1,500.00) $ (3,150.00) $ - 0
$ - 0 $ - 0
$ - 0 $ - 0
Totals: $ 1,525,086.31 $ - 0 $ (300,059.33) $ - 0 $ (98,806.65) $ - 0 $ (99,759.23) $ - 0 $ (98,806.65) $ - 0 $ (98,559.33) $ - 0 $ (98,806.65) $ - 0 $ (98,559.33) $ - 0 $ (99,491.65) $ - 0 $ (98,559.33) $ - 0 $ (101,106.65) $ - 0 $ (99,909.33) $ - 0 $ 232,662.18 0.00
Line Item Reasoning
Revenues
Line Item 7 - Initial Budget Initial Budget based on 16,280 FTE's and $100 per FTE
Expenses
Line Item 9 - Staff Salaries and Benefits Listed as given : $1,113,400 - Broken down into Monthly payments
Line Item 10 - Office Supplies Bi-Monthly Purchases of 36 Note Pads ($110.97), 90 Stick Note Pads ($89.95), 60 Pens ($5.99), 8 Whiteboard Markers and Erasers ($27.29) (OfficeDepot, 2020)
Line Item 11 - Student Staff Training Yearly Training to go over Department regulations and Guidelines for all returning and new employees.
Line Item 12 - Staff Professional Development Two Staff Members at NACA Seminar in October ($199.95 per person) (National Association for Campus Activities, 2020) and One Staff Member at ACPA in March ($185 per person) (American College Personnel Association, 2020)
Line Item 13 - New Student Orientation Based on $50 per incoming student (Kerr & Powell, 2020). Since FTE's are projected at 16,280, I estimated the incoming class at 4,000.
Line Item 14 - Marketing Materials Based on 4% on estimated annual budget (Katzman, 2016), broken down into monthly segments.
Line Item 15 - Institutional Memberships $1,385 ACPA, $1,160 NACA, $1,562 NASPA. Paid in full at the beginning of the fiscal year. Based on reported institutional dues provided by each Association.
Line Item 16 - Social Justice Training Institute Two students to attend Social Justice Training Institute. $750 per student if paid by check (SJTI, Registration, 2020)
Line Item 17 - Travel Monthly budget of $200 to cover gas, extraordinary travel. Trips in October and March covered by $300 for each roundtrip plane ticket, and $200 for a car rental.
Line Item 18 - Meals and Entertainment Monthly Dinner Party of $150 for department moral. $1,500 for end-of-year celebration.
References:
American College Personnel Association. (2020). Institutional Membership Categories. https://www.myacpa.org/join/institutional.
Katzman, J. (2016). The Spending War on Student Recruitment. https://www.insidehighered.com/views/2016/04/18/too-much-being-spent-higher-education-marketing-assault-essay.
Kerr, E., Powell, F. (2020). 11 Suprising College Fees You May Have To Pay. https://www.usnews.com/education/best-colleges/paying-for-college/slideshows/10-surprising-college-fees-you-may-have-to-pay.
OfficeDepot. (2020). Office Supplies. https://www.officedepot.com/a/browse/office-supplies/N=5+1676/.
National Association for Campus Activities. (2020). School Membership. https://www.naca.org/JOIN/Pages/SchoolMembership.aspx#SchoolDues.
SJTI. (2020). Registration. https://sjti.org/professional-sjti#:~:text=Cost%20of%20registration%20is%20%24750.00,requesting%20a%20reimbursement%20from%20them.
Student Affairs Administrators in Higher Education. (2020). Institutions. naspa.org/about/membership/institutions.

Sheet2

Sheet3