I just receive this homework assignment to creat a budgeting report. But I am really confused on how to do it.

Happy Valley University (HVU) needs to establish a budget for t heaving the Universityd current Budget Director has submi y. You and your team have been hired to establish a budget for the co itted her retirement and will be leaving the University complete a presentation to the President and the Board of Trustees. They are present a balanced budget (meaning zero profit tuition rate for students to pay by the credit hour since Happy Valley is a non-profit institution) and a FACTS: Revenues: HVU has three semesters during the year, there are 10,000 spring semesters and 3,000 students during summer semester Clasfessors are employed ing the year, there are 10,000 students during fall and students take on average 12 credits per semester. This means that Class size averages 30 per class and 334 professors are during the regular school year and 100 are employed during the summer $80.00 per credit hour Sports generate a total of $500,000 through gate receipts and concessions throughout the academie school year (you decide how to allocate it). HVUl receives from the state appropriations: $5,00,000 per calendar year (divide equall over 3 semesters) HVU receives from their endowment annually: S 500,000 per calendar year (split between fall and spring semesters) Expenses: Faculty teach 12 credits (4 classes at three credits each) per semester and the average salary is $60,000 per academic school year, plus benefits that run at 30% of salaries. Faculty receive an additional 30% of their salary fo teaching summer classes if they choose to do so no itional There are four colleges within HVU, College of Business, College of Technology, College of Arts and Sciences and the College of Health Sciences. Each college has a Dean, an Associate Dean and each of these two people has a secretary. Each college is allowed to spend $100,000 per calendar year to cover supplies, travel, telephones, and other miscellaneous expenses The Executive branch has a president and two (2) vice presidents and each of these people has a secretary. The president and vice presidents each spend $100,000 for supplies, travel, telephones and other miscellaneous expenses per calendar year where salaries are not given, establish a salary for each position, plus benefits at 30% of salaries HVU also has the following extra curricula activities that need to be funded: Football Hockey W. Basketball $100,000 during spring semester M Basketball $100,000 during spring semester W. Volleyball $175,000 during spring semester W. Softball $450,000 during fall semester $400,000% during fall semester and during spring semester $175,000 during spring semester Maintenance will cost 2% of tuition Utilities will cost 3% of tuition Business office expenses are $250,000 per year (divide equally between 3 semesters Financial aid office expenses: $175,000 per year (divide equally between 3 semesters) Happy Valley University (HVU) needs to establish a budget for t heaving the Universityd current Budget Director has submi y. You and your team have been hired to establish a budget for the co itted her retirement and will be leaving the University complete a presentation to the President and the Board of Trustees. They are present a balanced budget (meaning zero profit tuition rate for students to pay by the credit hour since Happy Valley is a non-profit institution) and a FACTS: Revenues: HVU has three semesters during the year, there are 10,000 spring semesters and 3,000 students during summer semester Clasfessors are employed ing the year, there are 10,000 students during fall and students take on average 12 credits per semester. This means that Class size averages 30 per class and 334 professors are during the regular school year and 100 are employed during the summer $80.00 per credit hour Sports generate a total of $500,000 through gate receipts and concessions throughout the academie school year (you decide how to allocate it). HVUl receives from the state appropriations: $5,00,000 per calendar year (divide equall over 3 semesters) HVU receives from their endowment annually: S 500,000 per calendar year (split between fall and spring semesters) Expenses: Faculty teach 12 credits (4 classes at three credits each) per semester and the average salary is $60,000 per academic school year, plus benefits that run at 30% of salaries. Faculty receive an additional 30% of their salary fo teaching summer classes if they choose to do so no itional There are four colleges within HVU, College of Business, College of Technology, College of Arts and Sciences and the College of Health Sciences. Each college has a Dean, an Associate Dean and each of these two people has a secretary. Each college is allowed to spend $100,000 per calendar year to cover supplies, travel, telephones, and other miscellaneous expenses The Executive branch has a president and two (2) vice presidents and each of these people has a secretary. The president and vice presidents each spend $100,000 for supplies, travel, telephones and other miscellaneous expenses per calendar year where salaries are not given, establish a salary for each position, plus benefits at 30% of salaries HVU also has the following extra curricula activities that need to be funded: Football Hockey W. Basketball $100,000 during spring semester M Basketball $100,000 during spring semester W. Volleyball $175,000 during spring semester W. Softball $450,000 during fall semester $400,000% during fall semester and during spring semester $175,000 during spring semester Maintenance will cost 2% of tuition Utilities will cost 3% of tuition Business office expenses are $250,000 per year (divide equally between 3 semesters Financial aid office expenses: $175,000 per year (divide equally between 3 semesters)