Budget Spreadsheet

Liberty University: FY 2009-2010 Budget Planning Spreadsheet Fund Orgn Prog Activity C1 C2 C3 C4 C5 C6 C7 C8 Account Number Account Description FY 2005-2006 FY 2006-2007 FY 2007-2008 FY 2008-2009 Actual Expenses Actual Expenses Actual Expenses Adjusted Budget as of 12/15/08 FY 2008-2009 Total YTD as of 12/15/08 FY 2009-2010 Base Budget Labor: 6100 Salaries & Wages 61000 Benefited Payroll 610001 Overload 610006 Benefited Overtime 61100 Non - Benefited Payroll 611002 Non - Benefited Overtime 611004 Employee Professional Fees Total Salaries & Wages 6200 Benefits 62300 Other Benefits 623002 Relocation Expenses 623003 Athl. Coaching-Relocation Expenses Total Benefits Total Labor Direct Expenditures 7100 Professional Fees/Services 71000 Professional Fees/Services 710000 Audit Fees 710001 Catering Services 710002 Commissions 710003 Consulting Fees 710004 Event Security 710005 Honorariums 710006 Individual Professional Fees 710007 Legal Fees 710008 Printing 710009 Purchased Services 710010 Royalties Total Professional Fees/Services 7160 Insurance 71600 Insurance 716000 Insurance - Athletics 716001 Insurance - Aviation 716002 Insurance - Deductible Cost 716003 Insurance - Fire/Flood 716004 Insurance - Liability/Property 716005 Insurance - Life 716006 Insurance - Vehicle 716007 Insurance - Workmen's Comp. Total Insurance 7200 Utilities 72000 Utilities 720000 Electric 720001 Gas & Heat 720002 Refuse Pick Up 720003 Water & Sewage 72200 Communications 722000 Cellular 722001 Internet Service 722002 Pagers 722003 Radio Communication 722004 Satellite/TV 722005 Telephone Service Total Utilities 7300 Postage & Shipping 73000 Postage & Shipping 730000 Freight/Shipping 730001 Postage Total Postage & Shipping 7400 Advertising and Promotions 74000 Advertising 740000 General Advertising 740001 Other Promotions Total Advertising and Promotions - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - D:\Docstoc\Working\pdf\05c5c0f3-3993-422f-82b9-b8d1b9ca2a92.xls Budget Spreadsheet Page 1 of 3 10/31/2009 9:45 PM C1 C2 C3 C4 C5 C6 C7 C8 Account Number Account Description FY 2005-2006 FY 2006-2007 FY 2007-2008 FY 2008-2009 Actual Expenses Actual Expenses Actual Expenses Adjusted Budget FY 2008-2009 Total YTD FY 2009-2010 Base Budget 7500 Non-Capital Assets 75000 Non-Capital Purchases 750000 Computers 750001 Equipment 750002 Furnishings 750003 Software 750004 Software Subscriptions/Maint 750005 Vehicles 75100 Rental & Lease Expense 751000 Building Rental 751001 Equipment Rental 751002 Leased Building 751003 Leased Equipment 751004 Other Rental Total Non-Capital Assets 7560 Plant Maintenance 75600 Plant Maintenance 756000 Construction 756001 Hazardous Materials Disposal 756002 Maintenance 756003 Repairs Total Plant Maintenance 7600 Supplies 76000 General Supplies 760000 Audio/Visual Supplies 760001 Award Supplies 760002 Diploma Supplies 760003 Food 760004 General Supplies 760005 Instructional Supplies 760006 Music Supplies 760007 Office Supplies 760008 Photo/Film Supplies 760009 Police/Field Supplies 760010 Printing Supplies 760011 Research Supplies 760012 Set Pieces and Props Supplies 76100 Athletic Supplies 761000 Clothing/Uniform Supplies 761001 Laundry Supplies 761002 Recreation/Athletic Supplies 76200 Medical Supplies 762000 Medical/Hospital Supplies 762001 Pharmacy/Medication 76300 Technical Supplies 763000 Data Processing Supplies 763001 Network/Cable Supplies 76400 Maintenance & Repair Supplies 764000 Maintenance Supplies 764001 Custodial Supplies 764002 Landscaping Supplies 764003 Vehicle Maintenance Supplies 76500 Inventoriable Supplies 765000 Inventoriable Supplies Total Supplies 7700 Professional Development 77000 Professional Development Travel 770000 Prof. Dev. Travel Airfare 770001 Prof. Dev. Travel Ground 770002 Prof. Dev. Travel Incidentals 770003 Prof. Dev. Travel Lodging 770004 Prof. Dev. Travel Per Diem 77100 Professional Development Other 771000 Prof. Dev. Courses 771001 Prof. Dev. Memberships 771002 Prof. Dev. Resource Materials 771003 Prof. Dev. Subscriptions Total Professional Development 7740 Travel 77400 Team Travel 774000 Team Travel Airfare 774001 Team Travel Ground 774002 Team Travel Incidentals 774003 Team Travel Lodging 774004 Team Travel Per Diem - - - - - - - - - - - - - - - - - - - - - - - - D:\Docstoc\Working\pdf\05c5c0f3-3993-422f-82b9-b8d1b9ca2a92.xls Budget Spreadsheet Page 2 of 3 10/31/2009 9:45 PM C1 C2 C3 C4 C5 C6 C7 C8 Account Number 77410 774100 774101 774102 774103 774104 77420 774200 774201 774202 774203 774204 Account Description Travel Travel Airfare Travel Ground Travel Incidentals Travel Lodging Travel Per Diem Student Athlete Recruiting Travel Student Athlete Recruit Airfare Student Athlete Recruit Ground Student Athlete Recruit Incidentals Student Athlete Recruit Lodging Student Athlete Recruit Per Diem Total Travel FY 2005-2006 FY 2006-2007 FY 2007-2008 FY 2008-2009 Actual Expenses Actual Expenses Actual Expenses Adjusted Budget FY 2008-2009 Total YTD FY 2009-2010 Base Budget - - - - - - 7800 Other Expenditures 78000 Fees 780000 Bank Service Charges 780001 Canadian Exchange 780002 Collection Agency Fees 780003 Late Charges 780004 Penalty Charges 78100 Interest Expense 781000 Interest Expense-Capital Lease 781001 Interest Expense-Debt 781002 Interest Expense-Other 78200 Bad Debt Expense 782000 Bad Debt Expense-W/O 782001 Bad Debt Expense-ADA 78300 Taxes 783000 Property Taxes 783001 Other Taxes 78400 General Expenditures 784000 Awards 784001 Benevolence 784002 Club Expenses 784003 Donations 784004 Electronic Subscriptions 784005 Guarantees 784006 Hospitality & Entertainment 784007 Institutional Memberships 784008 Interview Expenses 784009 Subscriptions 784010 Refund Expense 784011 Athletic Textbooks Total Other Expenditures Total Direct Expenditures Capital Assets and Depreciation 7900 Capital Assets 79000 Capital Purchases 790000 Capital Computers 790001 Capital Equipment 790002 Capital Furnishings 790003 Capital Software 790004 Capital Vehicles 790005 Library Books 790006 Library Microfilm/Microfiche 79100 Capital Plant 791000 Capital-Building 791001 Capital-Building Improvements 791002 Capital-Land 791003 Capital-Land Improvements 791004 Capital-Leasehold Improvements 791005 Capital-Roads/Bridges Total Capital Assets Scholarships 5200 Contra Scholarships 52000 Contra Scholarships 520000 Contra Scholarships Total Contra Scholarships - - - - - - - - - - - - - - - - - - Grand Total - - - 265,503 0 - D:\Docstoc\Working\pdf\05c5c0f3-3993-422f-82b9-b8d1b9ca2a92.xls Budget Spreadsheet Page 3 of 3 10/31/2009 9:45 PM