Nonprofit
Ticket sales are low because the restricted government grants are to subsidize ticket prices just to children 12 and under.
It is expected that total children and adult traffic will increase 25% as the result of increased marketing expenses.
20% of marketing expenses are fixed; the rest are variable; all other expenses are fixed
The adult:child ratio of visitors will remain the same as this year.
The fundraising effort will help pay for gift shop inventory such that COGS for the gift shop will drop from 50% to 40%.
Gift shop sales will continue to vary directly with ticket sales.
Next year they plan to double their fixed marketing expenses, and as a result will increase ticket sales by 25%.
To be able to subsidize the increase ticket sales they will have to double fundraising to $200,000. This will require an additional fundraising expense of $50,000 beyond this year's level, plus an additional $20,000 of salaries for additional headcount.
Due to the lower tax revenue of the city government from the recession, the museum's grant will be cut by half.

• Given the assumptions and data in this Excel file:
  • complete next year's budgeted figures for each entity within the same Excel worksheet (yellow cells)
  • include your reasoning for most of the budgeted figures (green cells)

Because of a bad recession, government grants were not cut by 50% but are eliminated completely for next year's budget and fundraising effortsdespite an increase in expensesdid not improve at all.

Nonprofit Dinosaur Museum
Statement of Activities
	This Yr	Next Yr Budget	Reason
Operating revenues
Ticket sales	$100,000
Gift shop sales	200,000
Total Operating Revenue	300,000
Operating Expenses
Salaries & benefits	200,000
Gift shop COGS	100,000
Marketing	100,000
Maintenance	80,000
Skeleton depreciation	10,000
Building lease	120,000
Utilities	50,000
Interest on debt	40,000
Total operating expenses	700,000
Operating income	(400,000)
Non-operating Revenue
Fundraising	100,000	200,000
Govt. Grants	200,000	100,000
[Fundraising expenses]	(40,000)	(90,000)
Net non-operating revenue	260,000	210,000
Increase in net assets	(140,000)	(175,000)
Net assets at beg. of yr.	490,000	350,000
Net assets at end of yr.	350,000	175,000