Question

**( Please show steps on excel and formulas used )**

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 capabilities for voice transmission, text messaging, Internet access, and taking 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 handsets and wireless plans offered by each of these vendors. Assume that each of the 35 salespeople will need to spend three hours per weekday between 8 a.m. and 6 p.m. on mobile 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

1). ANSWER :

GIVENTHAT :