Module 4 – SLPELECTRONIC COMMERCE AND THE SOCIAL ENTERPRISE To continue in Excel you will apply analytics to the SLP. SLP Assignment Cost Comparison of Web Conferencing The two owners of Spinner Media

Module 4 – SLPELECTRONIC COMMERCE AND THE SOCIAL ENTERPRISE

To continue in Excel you will apply analytics to the SLP.

SLP Assignment

Cost Comparison of Web Conferencing

The two owners of Spinner Media Services Inc. wanted to cut travel costs and productivity losses (wasted time) and maintain the benefits of person-to-person collaboration. They decided to use Web conferencing internally for collaboration and externally for sales demonstrations to customers. Their two options were a) a pay-per-use basis or b) a per-user licensing plan based on the number of seats or participants. The decision would depend on cost comparisons based on these data estimates:

• Approximately 100 meetings per year
• An average of 12 participants per meeting
• Each meeting lasting about one hour, which takes into consideration the need to get the meeting set up at least 15 minutes in advance and meeting for 45 minutes
• 250 unique participants, consisting of 50 employees and 200 customers.

Here are two sites with pricing information for Zoom and WebEx. (Note these addresses can change so Google “zoom” or “webex” if necessary):

• https://zoom.us/pricing
• https://www.webex.com/pricing/index-rbd.html

SLP Assignment Expectations

Prepare an Excel spreadsheet that fulfills the criteria for this SLP assignment. Be sure to use formulas and graphs within Excel so they can be reviewed. In a Word document, interpret the meaning of your analytical findings from the spreadsheet. The Word document should present the results to the owners of Spinner Media Services. Use analytics and graphs in your report and then describe the results. Remember you can copy spreadsheets and graphs into Word but you need to upload both the Word document and the Excel document to the SLP dropbox.