Using the initial budget provided, prepare a flexible budget when the projected number of tickets sold is increased 1500 to 1750.

	No. of ppl	$ per person	$	No. of ppl	$ per person	$
Ticket Sales Revenue	1500	$80.00	$120,000.00	1750	$80.00
Expenses
Variable:
Food	1500	$45.00	$67,500.00		$45.00
Party gifts	1500	$12.00	$18,000.00		$12.00
Floral Centrepieces	150	$23.00	$3,450.00		$23.00
Chair covers	1500	$5.00	$7,500.00		$5.00
Total Variable Expenses			$96,450.00
Contribution Margin			$23,550.00
Fixed:
Event planning fee			$3,500.00			$3,500.00
Room rental fee			$5,500.00			$5,500.00
Security			$750.00			$750.00
Sound system rental fee			$5,250.00			$5,250.00
Room dcor			$7,000.00			$7,000.00
Door prizes			$1,000.00			$1,000.00
Total Fixed Expenses			$23,000.00			$23,000.00
Net Income for the charity			$550.00