SOFTWARE TO EVALUATE WIRELESS SERVICES
Software skills: Spreadsheet formulas, formatting
Business skills: Analyzing telecommunications services and costs
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 Cincinnati, Ohio, with mobile phones that have capabilities for voice transmission, text messaging, and taking and sending photos.
1. Use the Web to evaluate wireless service providers that provide nationwide service as well as good service in your home area. You must evaluate at least three providers.
2. Examine the features of the mobile handsets offered by each of these vendors.
3. Assume that each of the 35 sales people 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, and send five photos per week.
4. Using the template in Blackboard, create a workbook in Excel to record your findings.
5. Determine the wireless service and handset that will offer the best pricing per user over a two-year period. Be sure to include the websites you used for your research. You should clearly identify the wireless service provider you choose. For the purposes of this exercise, you do not need to consider corporate discounts.
6. Your worksheet should include appropriate formulas or functions to determine values and totals. Hint: Use absolute cell references where appropriate.
7. Save the Excel file as you did earlier.
8. Submit your workbook in Blackboard by 10/22/2012, Monday 11:59 PM for evaluation.