![FINANCIAL ACCOUNTING](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
FINANCIAL ACCOUNTING
10th Edition
ISBN: 9781259964947
Author: Libby
Publisher: MCG
expand_more
expand_more
format_list_bulleted
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 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 breakfast, lunch, and free parking. The following are the costs incurred for putting on this event:
Rental cost for the auditorium
Registration processing
Speaker costs
Continental breakfast
Lunch
Parking
$150
$8.50 per person
3@$800 = $2,400
$4.00 per person
$7.00 per person
$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.
$
5606.44
(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.
76
nonmember registrants](https://content.bartleby.com/qna-images/question/b156829c-c37a-4ef7-8229-00e1647acb03/27fbea8b-ab8b-4f37-9a32-d9d95687e7c0/wgof7q_thumbnail.png)
Transcribed Image Text: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 breakfast, lunch, and free parking. The following are the costs incurred for putting on this event:
Rental cost for the auditorium
Registration processing
Speaker costs
Continental breakfast
Lunch
Parking
$150
$8.50 per person
3@$800 = $2,400
$4.00 per person
$7.00 per person
$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.
$
5606.44
(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.
76
nonmember registrants
Expert Solution
![Check Mark](/static/check-mark.png)
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution
Trending nowThis is a popular solution!
Step by stepSolved in 2 steps
![Blurred answer](/static/blurred-answer.jpg)
Knowledge Booster
Similar questions
- A nonprofit decides to provide free food for the homeless in Thanksgiving holidays. The manager wants to write a proposal to raise money from their donors. Assume that the project requires a fixed cost of $5,000 for staff and equipment. The variable cost such as utensils and food is $5 per person served. Based on the manager's experience, the manager estimates there will be 200 homeless people to serve. What is the price per person that the manager should put into his/her proposal? a.$5 b.$30 c.$25 d.$5,000arrow_forwardData Recovery Services (DRS) specializes in data recovery from crashed hard drives. The price charged varies based on the extent of damage and the amount of data being recovered. DRS offers a 15% discount to students and faculty at educational institutions. Consider the following transactions during the month of June. June 10 Rashid’s hard drive crashes and he sends it to DRS. June 12 After initial evaluation, DRS e-mails Rashid to let him know that full data recovery will cost $2,200. June 13 Rashid informs DRS that he would like them to recover the data and that he is a student at UCLA, qualifying him for a 15% educational discount and reducing the cost by $330 ( = $2,200 × 15%). June 16 DRS performs the work and claims to be successful in recovering all data. DRS asks Rashid to pay within 30 days of today’s date, offering a 4% discount for payment within 10 days. June 19 When Rashid receives the hard drive, he notices that DRS did not successfully recover all data.…arrow_forwardCornwall 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…arrow_forward
- Ivanhoe Magazine Ltd. is a small company run by two enterprising university students. They publish an issue of the magazine once a month from September through April. The magazine reports on various university activities and provides information such as how to get the best concert tickets, where to get the best pizza for the best price, where the good study spots are, and how to get library staff to help with research. The magazine is sold either on a prepaid subscription basis for $12 for all eight issues, or for $2 per issue. During September, 1,650 subscriptions were sold. Up to the end of December, a total of 10,725 single copies were sold. The company also pre-sells advertising space in the magazine to local businesses that focus on the student market. During July and August, the company signed up several businesses and collected $16,500 in advertising revenues. The advertisements are to be included in all eight issues of the magazine. The cost of printing and distributing the…arrow_forwardMembers 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 % %arrow_forwardThe 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…arrow_forward
- 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.arrow_forwardA country club wants to exam the effects of a new marketing campaign that attempts to get more people within the community to become members. In many communities, when people buy a house in the area, they receive a “Welcome Wagon” gift basket containing coupons to local restaurants. The idea of the marketing campaign is to include a free two month membership to the country club in the gift basket with the hope that once “new” residents try the country club then at least a certain proportion will want to become real members. One member of the Club’s Executive Council believes that at least 81% of the people who receive the coupons for the free membership will use the coupon. In a sample of 192 new residents who received the coupon for the two month free membership, there were 138 people who actually took advantage of the free two month membership. When testing the hypothesis that at least 81% of the people that receive the coupon actually use it, what is the test statistic?arrow_forwardI need d) pleasearrow_forward
- 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 methodarrow_forwardMusic 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…arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education
![Text book image](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781259964947/9781259964947_smallCoverImage.jpg)
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337272094/9781337272094_smallCoverImage.gif)
Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,
![Text book image](https://www.bartleby.com/isbn_cover_images/9781337619202/9781337619202_smallCoverImage.gif)
Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,
![Text book image](https://www.bartleby.com/isbn_cover_images/9780134475585/9780134475585_smallCoverImage.gif)
Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON
![Text book image](https://www.bartleby.com/isbn_cover_images/9781259722660/9781259722660_smallCoverImage.gif)
Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education
![Text book image](https://www.bartleby.com/isbn_cover_images/9781259726705/9781259726705_smallCoverImage.gif)
Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education