Question

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, 15 cents ppm for audio conferencing, and $175 for online registration support. Although Marie wl 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 fee is $159, how many attendees are required for Marie to makea profit of $10,0002

Answer 1