File AutoSave off BANA II Spring 2022 Final Exam Home Insert Draw Page Layout Formulas Data...

Transcribed Image Text:

File AutoSave off BANA II Spring 2022 Final Exam Home Insert Draw Page Layout Formulas Data Review View Calibri (Body) Paste BIU. Urco Clipboard TextBox 1 B 1 2 3 fx 11 v v A A A Search (All+Q) Shape Format Help Wrap lev Merge & Center F Alignment F trinityrosclubers@gmail.com Comments Share Insert General ' $ v % 508 8 Conditional Formal as Cell Delete Formatting Table Styles Format Sort & Find & Elter Select Analyze Data Sensitivity Solver Number Cells Editing Analysis Sensitivity Solver M N P Q R S U V C E H 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 7 free seats to each symposium. Nonmembers wishing to attend must pay $100 per person. Each attendee receives breakfast, lunch, and free parking. The following are the costs incurred for putting on this event (15 Points): 6 7 8 1. Build a spreadsheet model that calculates a profit (Revenues-Costs) or loss based on the number of nonmember registrants. 9 2. Use Goal Seek to find the number of nonmember registrants that will make the event break even (meaning profit equals $0). 10 11 12 13 14 15 16 17 Registration processing 18 Rental cost for the auditorium Speaker costs 14 per person 19 Breakfast 20 21 Lunch Parking $ 250 $ $ 3,300 3 speakers at $1100 $ 7 per person $ 9 per person $ 10 per person 22 23 24 25 26 27 Ready No Cheating Understanding Accability: wigat Type here to search Q16. Visualization Q17. Regression Q18. Spreadsheet Models 19. Transpo Optimization hala 51F ^ A 100% 9:17 PM 4/26/21322 File AutoSave off BANA II Spring 2022 Final Exam Home Insert Draw Page Layout Formulas Data Review View Calibri (Body) Paste BIU. Urco Clipboard TextBox 1 B 1 2 3 fx 11 v v A A A Search (All+Q) Shape Format Help Wrap lev Merge & Center F Alignment F trinityrosclubers@gmail.com Comments Share Insert General ' $ v % 508 8 Conditional Formal as Cell Delete Formatting Table Styles Format Sort & Find & Elter Select Analyze Data Sensitivity Solver Number Cells Editing Analysis Sensitivity Solver M N P Q R S U V C E H 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 7 free seats to each symposium. Nonmembers wishing to attend must pay $100 per person. Each attendee receives breakfast, lunch, and free parking. The following are the costs incurred for putting on this event (15 Points): 6 7 8 1. Build a spreadsheet model that calculates a profit (Revenues-Costs) or loss based on the number of nonmember registrants. 9 2. Use Goal Seek to find the number of nonmember registrants that will make the event break even (meaning profit equals $0). 10 11 12 13 14 15 16 17 Registration processing 18 Rental cost for the auditorium Speaker costs 14 per person 19 Breakfast 20 21 Lunch Parking $ 250 $ $ 3,300 3 speakers at $1100 $ 7 per person $ 9 per person $ 10 per person 22 23 24 25 26 27 Ready No Cheating Understanding Accability: wigat Type here to search Q16. Visualization Q17. Regression Q18. Spreadsheet Models 19. Transpo Optimization hala 51F ^ A 100% 9:17 PM 4/26/21322