Module 4 – SLPELECTRONIC COMMERCE AND THE SOCIAL ENTERPRISETo continue in Excel you will apply analytics to the SLP.SLP AssignmentCost Comparison of Web ConferencingThe 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 yearAn average of 12 participants per meetingEach 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 minutes250 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.htmlSLP Assignment ExpectationsPrepare 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. Show more
0 comments