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 $80 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 30$800 - $2,400 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 for 100 nonmember registrants. If required, round your answer to two decimal places. (b) Use Goal Seek to find the number of nonmember registrants that will make the event break even. Do not round your intermediate calculations. If required, round your answer to the nearest whole number. nonmember registrants

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 $80 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 30$800 - $2,400 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 for 100 nonmember registrants. If required, round your answer to two decimal places. (b) Use Goal Seek to find the number of nonmember registrants that will make the event break even. Do not round your intermediate calculations. If required, round your answer to the nearest whole number. nonmember registrants

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

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 % %
Camp Rainbow offers overnight summer camp programs for children ages 10 to 14 every summer during June and July. Each camp session is one week and can accommodate up to 200 children. The camp is not coed, so boys attend during the odd-numbered weeks and girls attend during the even-numbered weeks. While at the camp, participants make crafts, participate in various sports, help care for the camp's resident animals, have cookouts and hayrides, and help assemble toys for local underprivileged children. The camp provides all food as well as materials for all craft classes and the toys to be assembled. One cabin can accommodate up to 10 children, and one camp counselor is assigned to each cabin. Three camp managers are on-site regardless of the number of campers enrolled. Following is the cost information for Camp Rainbow's operations last summer: Week Campers 116 138 154 98 102 134 122 108 12345678 Number of Cost to Run Camp $9,330 11,300 12,200 8,000 8,530 10,390 9,830 8,950 E5-14 (Algo)…
Becky Shelton, a teacher at Kemp Middle School, is in charge of ordering the T-shirts to be sold for the school's annual fund-raising project. The T-shirts are printed with a special Kemp School logo. In some years, the supply of T-shirts has been insufficient to satisfy the number of sales orders. In other years, T-shirts have been left over. Excess T-shirts are normally donated to some charitable organization. T-shirts cost the school $7 each and are normally sold for $14 each. Ms. Shelton has decided to order 900 shirts. Required a. If the school receives actual sales orders for 825 shirts, whalomount of profit will the school earn? What is the cost of waste due to excess inventory? b. If the school receives actual sales orders for 935 shirts, what amount of profit will the school earn? What amount of opportunity cost will the school incur? Profit a. Waste due to excess inventory Profit b. Opportunity cost
Music teachers, Inc., is an educational association for music teachers that has 20000 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 report and also sponsors professional courses that quality for continuing professional education credit. The association’s statement of revenues and expenses for the current year is presented below. The board of Directors of Music Teachers, Inc., has requested that a segmented income statement be prepares showing the contribution of each other segment to the association. The association has four segments: Membership Division, Magazine Subscriptions Division, Books and Reports Division, and Continuing Education…
Galbraight is the CEO and founding partner of JPA, a sizable asset management company with locations all over the world. The company serves a wide range of international institutional clients, including state-owned businesses operated by government officials. Galbraight launches a "Client Internship Program" that enables clients to recommend applicants for internships at JPA in an effort to strengthen client ties. Referrals from this program are taken into consideration for positions outside of the company's standard demanding and competitive hiring procedure. The bigger the JPA client, the more probable it is that a reference from that client will be hired into a rewarding internship position that will advance their career. More than 200 family members and friends of important executives from several of JPA's clients are hired by the company, including family members and friends from numerous government organizations with which JPA has links in investment banking or asset management.…
Cornwall Mobile Detailing (CMD) is a service that washes and details a customer's vehicle at their home or office. It operates on a membership basis. Members pay $800 dues per month, which entitle them to a complete wash and detail service monthly. Members may also order additional car washes during the month at a fee of $105. Additional washes are common in both summer and winter months. The number of members also varies with the season. The number of members and the average number of additional washes by members for the months of interest follow: Additional Washes (Average per Member) Members January February 420 1.4 480 1.7 March 1,040 1.3 April May 1,180 1.2 1,210 1,360 1.5 2.0 June Cornwall allows members to pay for dues on credit. Cornwall's experience is that 40 percent of its members pay cash for the dues, 50 percent of the members pay the dues for a month in the next month, 5 percent in the second month after. The remainder is uncollectible. Additional washes are payable in…
Each fall and spring, the youth group puts together a yard clean-up day to help community members with leaf raking, tree mulching. and miscellaneous other outside chores. The group works hard to fundraise so that it can cover the transportation cost to and from each location; transportation costs of gas and mileage for the group's large-capacity van average about $8 per trip. This year, the group anticipates serving 55 locations on its fall clean-up day. Besides transportation costs, the only other costs are for depreciation on yard equipment like leaf blowers, which amounts to $390 for this fall season. (a) In order to just cover the costs to service these locations, how much does the group need to fundraise? The youth group will need to raise $
The executive education (EE) unit at the Business School of Central State University offers both open-enrollment (anyone can sign up) and custom (designed for a specific client) executive education programs. CSU has just received an inquiry from a prospective client about its prices for leadership seminars. The prospective client wants bids for three alternative activity levels: (1) one seminar with 20 participants, (2) four seminars with 20 participants each (80 participants total), or (3) eight seminars with 140 participants in total. EE’s cost analyst has provided the following differential cost estimates. Setup costs for the entire job $ 900 Materials costs per participant (brochures, handouts, coffee, lunch, etc.) 150 Differential direct labor costs: One seminar $ 1,800 Four seminars 7,800 Eight seminars 13,200 In addition to the preceding differential costs, EE allocates fixed costs to jobs on a direct-labor-cost basis, at a rate of 75…
Members of the local Nash club benefit from two key support services provided by Nash's global headquarters: (1) social media assistance and (2) member services. The social media department provides 8% of its time to member services, 12% to North/South America groups, 26% to Asia groups, 25% to Africa/Australia groups, and 29% to European groups. The member services department provides 15% of its time to the social media department, 16% to North/South America groups, 19% to Asia, 15% to Africa/Australia, and 35% 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 % %
The orthopods & the radiologistSuppose that there are ten orthopaedic surgeons that have their private consultation rooms in a shared facility. Currently each earns $20,000 per month and pays $10,000 per month towards the operating expenses of the joint facility.A world renowned radiologist has just moved to town and is deliberating over where to set-up his practice. If he goes it alone he will earn $300,000 per month and will have to incur a monthly operating cost of $100,000. On the other hand, the orthopods have calculated that if they were to accommodate him in their existing facility, their total operating costs would increase from $100,000 to $120,000 per month, but each individual practice will increase its revenues from $20,000 to $50,000 per month. Moreover, they have convinced the radiologist, that his practice will also increase revenues from patients by $20,000 per month.Assuming that the 10 orthopods have chosen a representative to negotiate with the radiologist (so…
Please be as detailed as possible in answering all requirements. Thank you in advance.