Exploring Excel Ch. 06 ­ EOC Project Event Budget

Exploring Excel Ch. 06 ­ EOC Project Event Budget

Author: matthew stock


Event Budget
Project Description:
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.
For the purpose of grading the project you are required to perform the following tasks:


Points Possible


Start Excel. Download, save, and open the Excel workbook named Exploring_e06_Grader_EOC.xlsx.



On the Budget worksheet, perform a goal seek analysis to determine what the ticket price in cell B9 would need to be if you wanted the balance in cell C34 to be $0. Accept the solution.



Beginning in cell E3, complete the series of substitution values ranging from 300 to 500 in increments of 20 students vertically down column E.



In cell F2, enter a reference to the total income formula from column C. In cell G2, enter a reference to the total expenses formula from column C. And in cell H2, enter a reference to the balance formula from column C.



Create a one-variable data table for the range E2:H13 using the number of attendees as the Column input cell. Format the results with Accounting Number Format with two decimal places.



Apply custom number formats to make the formula references in the range F2:H2 appear as Revenue, Expenses, and Balance, respectively.



Create a two-variable data table in the range E17:I28, using the Ticket Price per Person as the Row input cell and the No. of Attendees as the Column input cell. Format the results with Accounting Number Format with two decimal places.



Apply a Red, Accent 2, Lighter 80% fill color to the three cells closest to break-even without creating a deficit.


See More
Try a College Course Free

Sophia’s self-paced online courses are a great way to save time and money as you earn credits eligible for transfer to over 2,000 colleges and universities.*

Begin Free Trial
No credit card required

26 Sophia partners guarantee credit transfer.

226 Institutions have accepted or given pre-approval for credit transfer.

* The American Council on Education's College Credit Recommendation Service (ACE Credit®) has evaluated and recommended college credit for 21 of Sophia’s online courses. More than 2,000 colleges and universities consider ACE CREDIT recommendations in determining the applicability to their course and degree programs.