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 f the center (there are currently 10) receives nine free seats to each symposium. Nonmembers wishing to attend must pay $75 per person. 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 Registration Processing: $8.50 per person Speaker Costs: 3@$800 $2,400 Continental Breakfast: $4.00 per person Lunch: $7.00 per person Parking: $5.00 per person (a) The Center for Business Analytics is considering a refund policy for no-shows. No refund would be given for members who do not attend, but for nonmembers who do not attend, 50% of the price will be refunded. Build a spreadsheet model in Excel that calculates a profit or loss based on the number of nonmember registrants. Extend the model you developed for the Business Intelligence Symposium to account for the fact that historically, 25% of members who registered do not show and 10% of registered nonmembers do not attend. The center pays the caterer for breakfast and lunch based on the number of registrants (not the number of attendees). However, the center only pays for parking for those who attend. What is the profit if each corporate member registers their full allotment of tickets and 127 nonmembers register? If required, round your answers to two decimal places. 2288.25 (b) Use a two-way data table to show how profit changes as a function of number of registered nonmembers and the no-show percentage of nonmembers. Vary number of nonmember registrants from 80 to 160 in increments of 5 and the percentage of nonmember no-shows from 10% to 30% in increments of 2%. In which interval of nonmember registrants does breakeven occur if the percentage of nonmember no-shows is 22%? Breakeven appears in the interval of 130 to 135 number of registered nonmembers.

ework i [The following information applies to the questions displayed below.] Franklin Training Services (FTS) provides instruction on the use of computer software for the employees of its corporate clients. It offers courses in the clients' offices on the clients' equipment. The only major expense FTS incurs is instructor salaries; it pays instructors $5,300 per course taught. FTS recently agreed to offer a course of instruction to the employees of Novak Incorporated at a price of $470 per student. Novak estimated that 20 students would attend the course. Base your answers on the preceding information. Problem 11-25A (Algo) Part 3 FTS sells a custom wood plaque to students who complete the training course. Due to the custom nature of these plaques, FTS has to produce them in advance based on the estimated number of students to be enrolled in the course. Any plaques made for students who do not end up completing the course will be discarded. Prior to the first class, FTS pre-ordered 20…

Music Teachers, Incorporated, is an educational association for music teachers that has 20,500 members. The association operates from a central headquarters but has local membership chapters throughout the United States. Monthly meetings are held by the local chapters to discuss recent developments on topics of interest to music teachers. The association’s magazine, Teachers’ Forum, is issued monthly with features about recent developments in the field. The association publishes books and reports and also sponsors professional courses that qualify for continuing professional education credit. The association’s statement of revenues and expenses for the current year is presented below. Music Teachers, IncorporatedStatement of Revenues and ExpensesFor the Year Ended November 30Revenues$ 3,397,100Expenses: Salaries982,000Personnel costs245,500Occupancy costs222,000Reimbursement of member costs to local chapters530,000Other membership services520,000Printing and paper345,000Postage and…

Members of the local Oriole club benefit from two key support services provided by Oriole's global headquarters: (1) social media assistance and (2) member services. The social media department provides 12% of its time to member services, 16% to North/South America groups, 29% to Asia groups, 21% to Africa/Australia groups, and 22% to European groups. The member services department provides 14% of its time to the social media department, 17% to North/South America groups, 17% to Asia, 13% to Africa/Australia, and 39% to Europe. If the step method is used to assign costs from the support departments to the operating units, and if social media is ranked first between the two support departments, what percentage of each support department's cost will be allocated to each operating/geographic group? (Round answers for member services to 2 decimal places, e.g. 15.25%.) Social Media Member Services Support Departments Social Media % % Member Services % % North/South America % %