Paget Integrated Solutions

Paget Integrated Solutions
Seminar Budget Projections
Revenue			Room Rental
Number of Attendees	100		Persons	Charge
Registration Fee	$125		0	$400
Total Revenue			50	$600
			100	$750
Variable Costs			150	$900
Training Material Cost (per person)	$35		200	$1,000
Goodie Bag Cost (per person)	$15
Total Variable Costs			Meal Catering
			Persons	Charge (per person)
Fixed Costs			0	$25
Internet Hotspot	$50		50	$20
Speaker Fee	$900		100	$17
Speaker Travel	$500
Speaker Lodging	$140		Support Staff
Miscellaneous	$350		Persons	Charge
Total Fixed Costs			0	$60
			50	$80
Mixed Costs			100	$100
Room Rental			200	$120
Meal Catering
Support Staff
Total Mixed Costs
Balance

Constance Paget is the owner of Paget Integrated Solutions, a Web technology consulting firm based in Seattle, Washington. Paget is planning a seminar on Web applications with a popular guest speaker to take place in Houston Texas, next spring. She wants your help in generating a budget for the seminar that will incorporate the fixed, variable, and mixed costs to determine under what conditions the seminar will be profitable for her company.

1. Use formulas to find total revenue, total fixed cost, variable cost, mixed costs and balance. (Hint: Vlookup function is required to find the mixed costs)
2. Use goal seek to determine what number of attendees will result in a balance of $0.
3. Constance know that the registration fee for the seminar increases, the number of attendees willing to pay decreases. Change the number of attendees from a constant value to the following formula:

Use Solver to determine the registration fee that will maximize the balance value with the constraint that the registration fee should be an integer.

attendees =600e(75registrationfee)