Module 4 – SLPELECTRONIC COMMERCE AND THE SOCIAL ENTERPRISE
To continue in Excel you will apply analytics to the SLP.
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):
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.