Question

Happy Valley University (HVU) needs to establish a budget for the upcoming calendar year.  The current Budget Director has retired so you and your Team have been brought in establish a budget for the coming year.  You are being tasked to develop a balanced budget (meaning No Profit, since HVU is a non-profit) and a tuition rate per credit hour for students to pay in the coming year.  FACTS:  REVENUES:  HVU has three semesters during a calendar year. There are 10,000 students during the Fall and Winter semesters and 3,000 students during the Summer semester. Class size averages 30 students per class and students take an average of 12 credit hours per semester. As such, 334 professors are employed during the Fall and Winter semesters and 100 professors are employed during the Summer semester. Tuition is currently set at $80.00 per credit hour.  Sports generate a total of $500,000 through gate receipts and concessions during the calendar year.  HVU receives from State appropriations, $5,000,000 per calendar year (divide equally to 3 semesters)  HVU receives from annual Endowments, $500,000 per calendar year (divide between Fall and Winter semesters)  EXPENSES:  Faculty teach 12 credits (4 classes at 3 credits each) per semester.  The average Faculty salary is $60,000 academic year, plus benefits that run at 30% of salaries. Faculty receive as additional 30% of their salary for teaching Summer classes, if they choose to do so (no additional benefits)  There are four colleges within HVU: College of Business, College of Technology, College of Arts and Science, and College of Health Science. Each college has a Dean, and Associate Dean and each has their own Admin Assistant. Each college is allowed to spend $100,000 per calendar year on supplies, travel, telephone, and miscellaneous expenses. (You will need to establish your own salaries for the Dean, Assoc. Dean, plus benefits at 30%)  The Executive Office has a President and two Vice Presidents and each has their own Admin Assistant. The President and Vice Presidents each spend $100,000 per calendar year for supplies, travel, telephone, and miscellaneous expenses. (You will need to establish your own salaries for the President, VPs, and Admins plus benefits at 30%)  HVU also has the following extra curricula activities that need to be funded:              Football           $450,000 during the Fall semester              Hockey             $400,000 during ½ Fall semester, ½ Winter semester              W. Basketball $100,000 during the Winter semester              M. Basketball $100,000 during the Winter semester              W. Volleyball $175,000 during the Winter semester              W. Softball      $175,000 during the Winter semester  Maintenance will cost 2% of tuition  Utilities will cost 3% of tuition  Business office expenses are $250,000 per year (divide equally to 3 semesters)  Financial Aid office expenses are $175,000 per year (divide equally to 3 semesters)  ADDITIONAL COMENTS:  Because HVU is a non-profit organization, the goal is to budget for net income that is as close to zero as possible. An acceptable range for your final results will be plus/minus $10,000.  Wherever specific information is not given regarding the amount of an expense, you will need to decide how much it should be. You may not change any given numbers, except for the rate of tuition per hour.  Spreadsheets need to be Excel based worksheets.