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 Define “culture.” Software is defined by the Merriam-Webster Dictionary as "the programs that run on a... In humans, hypotrichosis (sparse body hair) is a rare autosomal recessive condition. Let h = hypotrichosis... Increase all of the listing prices by 5% for all listings under $500,000 and 10% for... Samsung Industry that requires you to act as a change agent to form an organizational change... Use fork() Create a program that reads characters from an input file. Use fork to create... A pension fund manager is considering three mutual funds. The first is a stock fund, the... Compute the cost of not taking the following cash discounts. (Use a 360-day year. Do not... ADVERTISEMENT About @ 2020 WizEdu