Question

In this project, you'll use the web to research alternative wireless services and use spreadsheet software to calculate wireless service costs for a sales force.

You would like to equip your sales force of 35, based in St. Louis, Missouri, with mobile phones that have capabilites for voice transmission, text messagingm internet access, and talking and sending photos. Use the web to select two wireless providers that offer nationwide voice and data service as well as good service in your home area. Examine the features of the mobile handset and wireless plans offered by each of these vendors. Assume that each of the 35 salepeople will need to spend 3 hours per day between 8am and 6pm. on moble voice communication, send 30 text messages per weekday, use 1 gigabyte of data per month, and send five photos per week. Use your spreadsheet software to determine the wireless service and handset that will offer the best pricing per user over a two-year period. For the purposes of this exercise, you do not need to consider corporate discounts.

Answer 1

Check the explanation

Step-by-step explanation:

In answering this question, we’ll be making use of an Excel Spreadsheet which has successfully been used to advance conceptual change in engineering system analysis and designs. With the use of a Spreadsheet Students can better perform alternative analysis and designs. Student can also better identify, understand and interpret the solution with the use of fundamental theoretical and numerical concepts.

The spreadsheet presentation in calculating the wireless service costs for a sales force can be seen in the attached image below: