Question

The University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry partners on applied research and continuing education in business analytics. One of the programs offered by the center is a quarterly Business Intelligence Symposium. Each attendee is charged $75 to attend (this is revenue). Each attendee receives breakfast, lunch, and free parking. The following are the costs incurred for putting on this event:

Rental cost for the auditorium: $150 (one-time)

Registration processing: $8.50 per person

Speaker costs: $2400 (one-time)

Continental breakfast: $4.00 per person

Lunch: $7.00 per person

Parking: $5.00 per person

a. Build a spreadsheet model that calculates a profit or loss based on the number of registrants.

b. The symposium organizers want to understand the possible levels of profit based upon different levels of attendance. Use a one-way data table to test profit levels for attendance of 50, 60, 70, 80, 90, 100, 110, and 120.

c. Use Goal Seek to find the number of registrants that will make the event break even.

Answer 1

The University of Cincinnati Center for Business Analytics
Calculation Of BEP of A Quarterly Business Intelligence Symposium
Sr. No.	Particular	Amount In $
a	Fees Per attendee	75.00
	Variable Cost Per attendee
	Registration processing	8.50
	Continental breakfast	4.00
	Lunch	7.00
	Parking	5.00
b	Total Variable Cost Per attendee	24.50
c	Contribution Margin (a-b)	50.50
	Fixed Cost
	Rental cost for the auditorium	150.00
	Speaker costs	2,400.00
d	Total Fixed Cost	2,550.00
e	BEP (d/c) (In No.)	50.50
	Since 0.50 can not be an attendee hence BEP is	51.00
The University of Cincinnati Center for Business Analytics
Calculation Of Profitability At Various Level
No Of Attendee ----->	50	60	70	80	90	100	110	120
Sr. No.	Particular
a	Fees Per attendee @ $75 Each	3,750.00	4,500.00	5,250.00	6,000.00	6,750.00	7,500.00	8,250.00	9,000.00
	Variable Cost Per attendee
	Registration processing @ $8.50 Each	425.00	510.00	595.00	680.00	765.00	850.00	935.00	1,020.00
	Continental breakfast @ $ 4 Each	200.00	240.00	280.00	320.00	360.00	400.00	440.00	480.00
	Lunch @$7 Each	350.00	420.00	490.00	560.00	630.00	700.00	770.00	840.00
	Parking @ $5 Each	250.00	300.00	350.00	400.00	450.00	500.00	550.00	600.00
b	Total Variable Cost Per attendee	1,225.00	1,470.00	1,715.00	1,960.00	2,205.00	2,450.00	2,695.00	2,940.00
c	Contribution Margin (a-b)	2,525.00	3,030.00	3,535.00	4,040.00	4,545.00	5,050.00	5,555.00	6,060.00
	Fixed Cost
	Rental cost for the auditorium (Fixed $150)	150.00	150.00	150.00	150.00	150.00	150.00	150.00	150.00
	Speaker costs (Fixed $ 2400)	2,400.00	2,400.00	2,400.00	2,400.00	2,400.00	2,400.00	2,400.00	2,400.00
d	Total Fixed Cost	2,550.00	2,550.00	2,550.00	2,550.00	2,550.00	2,550.00	2,550.00	2,550.00
		ekkarill92 Next > < Previous Related Solutions The University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry... The University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry partners on applied research and continuing education in business analytics. One of the programs offered by the center is a quarterly Business Intelligence Symposium. Each symposium features three speakers on the real-world use of analytics. Each of the corporate members of the center (there are currently 10) receives seven free seats to each symposium. Nonmembers wishing to attend must pay $75 per person. Each... The University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry... The University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry partners on applied research and continuing education in business analytics. One of the programs offered by the center is a quarterly Business Intelligence Symposium. Each symposium features three speakers on the real-world use of analytics. Each of the corporate members of the center (there are currently 10) receives thirteen free seats to each symposium. Nonmembers wishing to attend must pay $75 per person. Each... The University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry... The University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry partners on applied research and continuing education in business analytics. One of the programs offered by the center is a quarterly Business Intelligence Symposium. Each symposium features three speakers on the real-world use of analytics. Each of the corporate members of the center (there are currently 10) receives nine free seats to each symposium. Nonmembers wishing to attend must pay $75 per person. Each... The University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry... The University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry partners on applied research and continuing education in business analytics. One of the programs offered by the center is a quarterly Business Intelligence Symposium. Each symposium features three speakers on the real-world use of analytics. Each of the corporate members of the center (there are currently 10) receives thirteen free seats to each symposium. Nonmembers wishing to attend must pay $75 per person. Each... The University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry... The University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry partners on applied research and continuing education in business analytics. One of the programs offered by the center is a quarterly Business Intelligence Symposium. Each symposium features three speakers on the real-world use of analytics. Each corporate member of the center (there are currently 10) receives five free seats to each symposium. Nonmembers wishing to attend must pay $75 per person. Each attendee receives... The University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry... The University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry partners on applied research and continuing education in business analytics. One of the programs offered by the center is a quarterly Business Intelligence Symposium. Each symposium features three speakers on the real-world use of analytics. Each of the corporate members of the center (there are currently 10) receives twelve free seats to each symposium. Nonmembers wishing to attend must pay $75 per person. Each... The University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry... The University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry partners on applied research and continuing education in business analytics. One of the programs offered by the center is a quarterly Business Intelligence Symposium. Each symposium features three speakers on the real-world use of analytics. Each corporate member of the center (there are currently 10) receives five free seats to each symposium. Nonmembers wishing to attend must pay $75 per person. Each attendee receives... The University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry... The University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry partners on applied research and continuing education in business analytics. One of the programs offered by the center is a quarterly Business Intelligence Symposium. Each symposium features three speakers on the real-world use of analytics. Each of the corporate members of the center (there are currently 10) receives eight free seats to each symposium. Nonmembers wishing to attend must pay $75 per person. Each... The University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry... The University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry partners on applied research and continuing education in business analytics. One of the programs offered by the center is a quarterly Business Intelligence Symposium. Each symposium features three speakers on the real-world use of analytics. Each of the corporate members of the center (there are currently 10) receives twelve free seats to each symposium. Nonmembers wishing to attend must pay $75 per person. Each... The University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry... The University of Cincinnati Center for Business Analytics is an outreach center that collaborates with industry partners on applied research and continuing education in business analytics. One of the programs offered by the center is a quarterly Business Intelligence Symposium. Each symposium features three speakers on the real-world use of analytics. Each of the corporate members of the center (there are currently 10) receives five free seats to each symposium. Nonmembers wishing to attend must pay $75 per person. Each... ADVERTISEMENT Subjects Accounting Advanced Math Anatomy and Physiology Biology Chemistry Civil Engineering Computer Science Economics Electrical Engineering Finance History Math Mechanical Engineering Operations Management Physics Psychology Statistics and Probability Nursing Other ADVERTISEMENT Latest Questions "Ethical Considerations" Please respond to the following: Reflect upon the responsibilities placed on auditors by the... A Japanese company has a bond outstanding that sells for 93 percent of its ¥100,000 par... What is the difference among the principles of modularization, abstraction, encapsulation, and separation of interface and... An investment project costs $20,100 and has annual cash flows of $4,400 for six years.   ... PUT IN JAVA PROGRAMMING The StockB class: Design a class named StockB that contains the following... Draw a DFA for the following ( ∑ = {0,1}):                                 Set of all strings with. In the article from Forbes notes that the goal of a leader is not to clone... ADVERTISEMENT About @ 2020 WizEdu