Your goal as a budget committee member for the formal Valentine's Day Ball at the university is to balance the income and expenses, decide on the most appropriate ticket price per student, and ensure that your budget falls within the limitations you must work with. In this project, you will create one- and two-variable data tables to examine car loan options, use Goal Seek to determine how much money you would have to save each month for a down payment on a new home, and create scenarios to evaluate potential expense increases for a budget worksheet. Finally, you will use Solver to determine how many credits you can afford for a semester of graduate school.
Attachment:- ASSIGNMENT.rar