please read the instructions posted and keep the Case and SLP separated 

Modules/Module4/Mod4Case.html

Module 4 – Case

Electronic Commerce and the Social Enterprise

Assignment Overview

The focus of this Case is on e-business. Here are some background materials on e-business that you should review.

Module 4, Lecture 1: E-Business and E-Commerce Models and Strategies:

Module 4, Lecture 2: B2B E-Commerce and E-Procurement:

Module 4, Lecture 3: E-Commerce Support Services: Payment and Order Fulfillment:

Case 4 Review Quiz: This quiz will not count toward your grade but allows you to assess your knowledge.

Case Assignment

In your teams, use the Internet to plan a trip to some location outside the United States. Have each individual, working independently, use the services of a different online travel site such as orbitz.com, travelocity.com, kayak.com, Concierge.com and expedia.com (search “online travel sites” for additional options). Pull together to share the findings of the group.

Find the lowest airfare.
Examine a few hotels by class.
Get suggestions of what to see.
Find out about local currency, and convert $1,500 to that currency with an online currency converter.
Compile travel tips.

Prepare a report comparing how each site performed in terms of its ease of use, helpfulness, and best overall deal. Each member of the team posts the results of the analysis and a discussion of the team processes. (If a team member cannot for location reasons work in a team, then that person can do the project on his/her own.)

Assignment Expectations

Produce a 3- to 4-page paper analyzing and comparing online travel sites. Use of Excel and tables is highly recommended along with a description of your analysis. The final report should include the report findings combined in one Word doc.

Each member of the team will post the report to your individual drop box – be sure to have the names of all team members on the cover sheet.

Privacy Policy | Contact

Modules/Module4/Mod4SLP.html

Module 4 – SLP

Electronic Commerce and the Social Enterprise

To continue in Excel you will apply analytics to the SLP. Review these lectures and quiz to prepare for this assignment.

SLP 4, Lecture 1: Freeze Rows and Columns:

SLP 4 Review Quiz: This quiz will not count toward your grade but allows you to assess your knowledge.

Module 4 Lecture: Excel Demo: Payroll:

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 (1) a pay-per-use basis or (2) 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 400 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

Research the costs of a pay-per-use plan vs. a per user licensing plan based on the number of seats or participants for Microsoft’s Zoom and Cisco’s WebEx. Or evaluate two other pieces of web-based meeting software. Precise cost comparisons are difficult because there are so many variables, but a general cost analysis between Zoom and WebEx or other software is feasible.

Design a spreadsheet that shows cost comparisons of the vendors’ licensing options and the pay-per-use option using the data estimates.
Identify other criteria that should be taken into account when making such a decision (for example, vendor support or the ability to integrate with Outlook).
Based on your analysis, make a fully documented recommendation to the owners.

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 drop box.

Privacy Policy | Contact