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 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.   $      (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%?       (i) Breakeven appears in the interval of 80 to 85 number of registered nonmembers.   (ii) Breakeven appears in the interval of 95 to 100 number of registered nonmembers.   (iii) Breakeven appears in the interval of 85 to 90 number of registered nonmembers.   (iv) Breakeven appears in the interval of 105 to 110 number of registered nonmembers.

Keep-U-Safe Systems (KSS) sells security solutions to large corporations.  KSS offers electronic security systems for buildings (complete with cameras and keypad entry), perimeter security fencing (both physical and electronic) and offers an optional 24-hour security monitoring service.  The solutions can be purchased individually, or as a package.  The security systems and security fencing are sold as completed items (installation included).  The security monitoring consists of two years of monitoring by KSS's call centre, who alert businesses in the event that an alarm is triggered, as well as dispatch emergency personnel if nobody can be reached.  Each sales order is customized to the needs of the customer.  On September 30, 2021, KSS sold a security solution that consisted of a building security system, fencing for a warehouse location, and the 24-hour security monitoring service.  The solution was sold to Charleston Manufacturers for a price of $38,000, with payment due on…

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…