PLEASE SHOW WORK

8-15. EXCEL APPLICATION: Going Green! Everybody talks green. but some really do it. Marie Chong is a green home designer and builder who is producing a webinar to share her knowledge of green building. She learned that web conferencing requires only a PC and an Internet connection; however, audio conferencing capability is required if she wants to chat with attendees by telephone. Marie is working with a webinar hosting company that charges 10 cents per participant/per minute (ppm) for web conferencing, 15 cents ppm for audio conferencing, and $175 for online registration support. Although Marie will present some content herself, she will hire a professional speaker who is an expert on wind turbines for home use, and she will include audio conferencing so that attendees can interact with the speakers. The registration fee for a 60-minute webinar is $159. Create the Excel spreadsheet shown in Figure 8-20 to determine the number of attendees required for Marie to make a profit. How does that number change if Marie reduces the registration fee to $149? Use formulas for all calculations and Goal Seek to set profit to $1 by changing the number of attendees. If the registration fee is $159, how many attendees are required for Marie to make a profit of $10,000?

8-15. EXCEL APPLICATION: Going Green! Everybody talks "green." but some really do it. Marie Chong is a green home designer and builder who is producing a webi- nar to share her knowledge of green building. She learned that web conferencing requires only a PC and an Internet connec tion; however, audio conferencing capability is required if she wants to chat with attendees by telephone. Marie is working with a webinar hosting company that charges 10 cents per participant/per minute (ppm) for web conferencing, I5 cents ppm for audio conferencing, and $175 for online registration support. Although Marie will present some content herself she will hire a professional speaker who is an expert on wind turbines for home use, and she will include audio conferenc- ing so that attendees can interact with the speakers. The regis- tration fee for a 60-minute webinar is $159. Create the Excel spreadsheet shown in Figure 8-20 to determine the number of attendees required for Marie to make a profit. How does that number change if Marie reduces the registration fee to $149? Use formulas for all calculations and Goal Seek to set profit to $1 by changing the number of attendees. If the registration fe is $159, how many attendees are required for Marie to make a profit of $10,000? FIGURE 8-20 Going Green spreadsheet. Going Green! 3 Revenue 4 Number of Attendees 5 Registration Fee Total $159.00 7 Expenses 8 Speaker Fee 9 Audio Conference Service Fee (ppm)0.10 10 Web Conference Service Fee (ppm)* 0.15 11 Online Registration Support Costs 12 Webinar Length (minutes) 13 14 15 Profit 16 17 per participant/per minute $1,500.00 175.00 60