I need help with this question. Please assist. thank you!!

The University of Cncintat Center for Businiess Analytics is an outreach center that collaborates with industry partners on agplied restearch and continumg educaton in business aralytics: One of the programs offeled by the center is a quartetly Busaness Intelligence Symposium. Each symposium features three speakers on the reatiworld ine of analytios, Each of the corporate members of the center (there are eurrently 10) recemes ten free seats to each symposiume. Normembers wishing to artand niest gay sF per person. Cach attendee receives breaklast, larich, and free parking. The following are the costs inourred for putting on this event: (a) The Cented for Businens. Analytics a considering a refund policy for no-shews. Wo refund weild be taven far members who do not attend, but for menmemelters who do not attenal, sow of the price will be relundod. Buald a spreadsliest model in Excel thwt calculates a profic or loss based on the number of nonmenker icgitrants Extrnd registered nonmembers do not attend. The center pays the cateier for breabfost and lunch bssed oo the number of regatrimts (nes the number uf attendeas). Hwwever. the center only poys for parking for those who dittend. What is the profit if each moporste member rogisters theie full allotment of bckets and tz? nohmemiders registri? If iequired, round your answers to two deamal places. (b) Use a two-way dato table to show how phofit dianges as a function of number of regtitered nonmenters and the co -show percentage af nonesernbers. Very number of nonmember registrants from 80 to 160 an ancrements of 5 and the percentage of nonmenber no-shows from 10% to 39% in increvints of 29 . In which interval nt nonmember registrants docs breakeyen occur if the percentage of nonmenter no-hiom is 22e4? Breakeven appears in the interval of (3) number of registered nonmemben