Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

MIS 352 Excel Spreadsheet Hands-On Assignment Chapter 7 (pg. 289) Improving Decision Making: Using Spreadsheet Software to Evaluate Wireless Services Software skills: Spreadsheet formulas, formatting

MIS 352 Excel Spreadsheet Hands-On Assignment Chapter 7 (pg. 289) Improving Decision Making: Using Spreadsheet Software to Evaluate Wireless Services Software skills: Spreadsheet formulas, formatting Business skills: Analyzing telecommunications services and costs. In this project, youll 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. Assume 22 workdays per month. Using the MIS16ch07_questionfile provided to you for documenting your findings. 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. You will need to update the spreadsheet to include the following: 1. Complete the Assumptions information. (1 pt) 2. Add the numbers for the Per and All Employees. These numbers must be based on calculations. (2 pts) 3. Research the information for two mobile companies and enter their names along with a web link to the companys information. (1 pt) 4. Complete the Monthly fees for Service, Text Messaging, Photos, Phone, Data. (Hint: you may not be able to complete these depending on the plan). (2 pts) 5. Complete the Per Employee First Year, 2nd Year, and 2-Year Cost. The First Year and 2- Year Costs must include a calculation. (2 pts) 6. Complete the All Employees First Year, 2nd Year, and 2-Year Cost. Again, there must be calculations entered to get your answers. (1 pt) 7. Enter a short explanation of the mobile company you recommend and why. (1 pt) Upload the completed assignment in the Excel assignment area in Canvas. Also: These need to be mobile phone companies. Im also confused on how to get the data for these mobile phone companies and create these numbers.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Business Of Sport Management

Authors: John Beech, Simon Chadwick

2nd Edition

027372133X, 9780273721338

More Books

Students also viewed these Accounting questions

Question

1. Try oral, open-book, or group tests.

Answered: 1 week ago