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)…
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…
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…
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.
Members of the local Sheffield club benefit from two key support services provided by Sheffield's global headquarters: (1) social media assistance and (2) member services. The social media department provides 9% of its time to member services, 15% to North/South America groups, 22% to Asia groups, 21% to Africa/Australia groups, and 33% to European groups. The member services department provides 13% of its time to the social media department, 24% to North/South America groups, 18% to Asia, 15% to Africa/Australia, and 30% 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%.) Support Departments Social Media Member Services Social Media % Member Services % % North/South America %
Service Industry AccountingThe Spectrum Fitness Club charges a nonrefundable annual membership fee of $1,200 for its services. For this fee, each member received a fitness evaluation (value $200), a monthly magazine (annual value $25), and two hours’ use of the equipment each week (annual value $1,100). Each of the three elements of the annual membership can be purchased separately. The initial direct costs to obtain the membership are $180. The direct cost of the fitness evaluation is $100, and the monthly direct costs to provide the other services are estimated to be $25 per person. Give the journal entries to record the transactions in 2019 relative to a membership sold on May 1, 2019.
the book I use for study: Horngren's Cost Accounting: A Managerial Emphasis, 16th edition, Global Edition. Questions in image Request Compute: direct method and step method
Music Teachers, Incorporated, is an educational association for music teachers that has 20,300 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. Revenues Expenses: Salaries Music Teachers, Incorporated Statement of Revenues and Expenses For the Year Ended November 30 $ 3,354,300 Personnel costs Occupancy costs Reimbursement of member costs to local chapters Other membership services Printing and paper Postage and shipping Instructors' fees General…