The University of Cincinrati 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 $150 $8.50 per person (3 speakers $800 each) $4.00 per person $7.00 per person $5.00 per person Registration processing Speaker costs Continental breakfast Lunch Parking a) Build a spreadsheet model that calculates a profit or loss based on the total number of 100 nonmember registrants. b) Use Goal Seek to find the number of nonmember registrants that will make the event break even.

The University of Cincinrati 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 $150 $8.50 per person (3 speakers $800 each) $4.00 per person $7.00 per person $5.00 per person Registration processing Speaker costs Continental breakfast Lunch Parking a) Build a spreadsheet model that calculates a profit or loss based on the total number of 100 nonmember registrants. b) Use Goal Seek to find the number of nonmember registrants that will make the event break even.

Cornerstones of Cost Management (Cornerstones Series)

4th Edition

ISBN:9781305970663

Author:Don R. Hansen, Maryanne M. Mowen

Publisher:Don R. Hansen, Maryanne M. Mowen

Chapter8: Budgeting For Planning And Control

Section: Chapter Questions

Problem 4CE

See similar textbooks

Similar questions

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 twelve 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…
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 eight 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…
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 seven 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…
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 11) 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) Build a spreadsheet model that calculates a profit or loss for 100 nonmember registrants. If required, round your answer to two…
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…
A professional division at a business school provides several development programs that have been tailored to the specific training needs of both the public and private sectors. The program director is planning to offer a one-full-day course in risk management to be sold at $2,250 plus orientation fee (5%) per participant. The division incurs a cost of $45,000 for promotion, classroom space, staff and instructor’s salary, as well as a cost of $240 per participant for refreshments, lunch, course material, a gift package, and a framed certificate of completion. How many participants need to register in the course for it to be worthwhile to offer it? Round to two decimal places. Group of answer choices 21.20 26.86 36.72
Carmel Company has a frequent buyer program for its customers, where the customers can attain an "elite" level based on the number of orders and the total revenue of the orders. There are twoelite levels: Platinum and Titanium. The benefits of elite membership include discounts and access to special customer service representatives who can resolve problems. The company has one full time customer representative per 200 Titanium customers and one full-time customer representa tive per 2,000 Platinum customers. Customer representatives receive salaries plus bonuses of 2 percent of customer gross margin. Carmel spends 70 percent of its promotion costs on Titanium customers to encourage their loyalty
consumer focus is a marketing research firm that organizes focus groups for consumer – product companies. Each focus group has eight individuals who are paid $50 per session to provide comments om new products. these focus groups meet in hotels and are led by a trained, independent, marketing specialists hired by consumer focus. Each specialist is paid a fixed retainer to conduct a minimum number of sessions and a per sessions fee of $2000. A consumer focus staff member attends each session to ensure that all the logistical aspects run smoothly.Required: - Classify each of the following cost items as:a. Direct or indirect (D or I) costs with respect to each individual focus group.b. Variable or fixed (V or F) costs with respect to how the total costs of consumer focus change as the number of focus groups conducted changes.( if in doubt, select on the basis of whether the total costs will change substantially if there is a large change in the number of groups conducted.)You will have…
The School of Accounting (SOA) at State University is planning its annual fundraising campaign for accounting alumni. This year, the SOA is planning a call-a-thon and will ask Beta Alpha Psi members to volunteer to make phone calls to a list of 6,000 alumni. The Dean's office has agreed to let Beta Alpha Psi use their offices from 6 p.m. to 9 p.m. each weekday so that they will have access to phones. Each volunteer will be provided with a phone and a script with an introduction and suggested responses to various questions that had been asked in the past. Carol Johnson, Beta Alpha Psi faculty advisor, estimates the following: Of the 6,000 phone numbers, roughly 10 percent will be wrong numbers (because alumni change addresses and phone numbers without updating State University). In that case, the student is instructed to apologize to the answering party, hang up, and move on to the next phone number. Each of these calls takes about three minutes. Another 15 percent will be correct…
The School of Accounting (SOA) at State University is planning its annual fundraising campaign for accounting alumni. This year, the SOA is planning a call-a-thon and will ask Beta Alpha Psi members to volunteer to make phone calls to a list of 5,000 alumni. The Dean’s office has agreed to let Beta Alpha Psi use their offices from 6 p.m. to 9 p.m. each weekday so that they will have access to phones. Each volunteer will be provided with a phone and a script with an introduction and suggested responses to various questions that had been asked in the past.Carol Johnson, Beta Alpha Psi faculty advisor, estimates the following:1. Of the 5,000 phone numbers, roughly 10 percent will be wrong numbers (because alumni change addresses and phone numbers without updating State University). In that case, thestudent is instructed to apologize to the answering party, hang up, and move on to the next phone number. Each of these calls takes about three minutes.2. Another 15 percent will be correct…
The School of Accounting (SOA) at State University is planning its annual fundraising campaign for accounting alumni. This year, the SOA is planning a call-a-thon and will ask Beta Alpha Psi members to volunteer to make phone calls to a list of 7,000 alumni. The Dean's office has agreed to let Beta Alpha Psi use their offices from 6 p.m. to 9 p.m. each weekday so that they will have access to phones. Each volunteer will be provided with a phone and a script with an introduction and suggested responses to various questions that had been asked in the past. Carol Johnson, Beta Alpha Psi faculty advisor, estimates the following: Of the 7,000 phone numbers, roughly 10 percent will be wrong numbers (because alumni change addresses and phone numbers without updating State University). In that case, the student is instructed to apologize to the answering party, hang up, and move on to the next phone number. Each of these calls takes about three minutes. Another 20 percent will be correct…
The School of Accounting (SOA) at State University is planning its annual fundraising campaign for accounting alumni. This year, the SOA is planning a call-a-thon and will ask Beta Alpha Psi members to volunteer to make phone calls to a list of 7,000 alumni. The Dean's office has agreed to let Beta Alpha Psi use their offices from 6 p.m. to 9 p.m. each weekday so that they will have access to phones. Each volunteer will be provided with a phone and a script with an introduction and suggested responses to various questions that had been asked in the past. Monique Johnson, Beta Alpha Psi faculty advisor, estimates the following: Of the 7,000 phone numbers, roughly 10 percent will be wrong numbers (because alumni change addresses and phone numbers without updating State University). In that case, the student is instructed to apologize to the answering party, hang up, and move on to the next phone number. Each of these calls takes about three minutes. Another 15 percent will be correct…