The.University of Cincinnati Genter for Business Analytics is an outreach center that collaboratos with industry parthers on applied rasesrch and continuing edveation in buainess analytics. One of the programs offered by the center is a quarterly Business tntelligence Symposium. Each: symposium features thirae speakers an the realworld use of analytics. Each corporate member of the center (therd are currently 10 ) receives six free seats to each symposium. Nonmembers wishiog to attend must pay $75 per person. Each attendeo receives breakfast, lunch, and free parking. The following are the costs incurred for putting on this event: (a) The Center for Buniness Analytics is considering a refund policy for no-shows. No refund would be glven for members whe do not attend, but nonmembers whe do not attend will be refunded 50% of the price. Build a spresdsheot model that caiculates a profit or loss based an the number of nonmember registrants. Account For the fact that, histerically, 25% of members who reglstered do not show and 10% of registered nonmembers do not attend, The center pays the caterer for breakfast and lunch based on the number of repistrants (not the number of attendees). However, the center only pays for parking for those who attend. What is the profit if each corporate member registers their full allatment of tickets and 127 nonmembers register? If required, round your answers to two decimal places. (b) Use a two-way data table to show how protit changes as a function of number of registered nonmembers and the no-show percentage af nonmembers, vary namber of nonmember registrants from 80 to 160 in increments of 5 and the percentage of nonmember no-shows from 107 i to 30% in increments of 2%. In which interval of nonmember registrants does breakeven occur if the percentage of nonmember no-ahowe is 2246 ? Breakeven appears in the interval of (8) registered nonmembers. (c) Consider three scenariost Al other inputs are the same as in part (a). Use Scenario Manager to generate a summary report that gives the profit for aoch of these three scenarlos. What is the highest profit? What is the lowest profit? If required, round your answers to two decimal piaces. for subtractive or negative numbers use a minus sigf The hiahest profit is 1 The.University of Cincinnati Genter for Business Analytics is an outreach center that collaboratos with industry parthers on applied rasesrch and continuing edveation in buainess analytics. One of the programs offered by the center is a quarterly Business tntelligence Symposium. Each: symposium features thirae speakers an the realworld use of analytics. Each corporate member of the center (therd are currently 10 ) receives six free seats to each symposium. Nonmembers wishiog to attend must pay $75 per person. Each attendeo receives breakfast, lunch, and free parking. The following are the costs incurred for putting on this event: (a) The Center for Buniness Analytics is considering a refund policy for no-shows. No refund would be glven for members whe do not attend, but nonmembers whe do not attend will be refunded 50% of the price. Build a spresdsheot model that caiculates a profit or loss based an the number of nonmember registrants. Account For the fact that, histerically, 25% of members who reglstered do not show and 10% of registered nonmembers do not attend, The center pays the caterer for breakfast and lunch based on the number of repistrants (not the number of attendees). However, the center only pays for parking for those who attend. What is the profit if each corporate member registers their full allatment of tickets and 127 nonmembers register? If required, round your answers to two decimal places. (b) Use a two-way data table to show how protit changes as a function of number of registered nonmembers and the no-show percentage af nonmembers, vary namber of nonmember registrants from 80 to 160 in increments of 5 and the percentage of nonmember no-shows from 107 i to 30% in increments of 2%. In which interval of nonmember registrants does breakeven occur if the percentage of nonmember no-ahowe is 2246 ? Breakeven appears in the interval of (8) registered nonmembers. (c) Consider three scenariost Al other inputs are the same as in part (a). Use Scenario Manager to generate a summary report that gives the profit for aoch of these three scenarlos. What is the highest profit? What is the lowest profit? If required, round your answers to two decimal piaces. for subtractive or negative numbers use a minus sigf The hiahest profit is 1