Question: Please use in excel file and SUM or SUMFUNCTION. Thank you! Scenario: In this project, you will use the Web to research alternative wireless services

Please use in excel file and SUM or SUMFUNCTION.Please use in excel file and SUM or SUMFUNCTION. Thank you!

Scenario: In this project, you will 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 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, and send five photos per week. 4. 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 with the name Chapter 7 Lab 7-10. 8. Upload the excel file only to the Assignment folder

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related General Management Questions!