Question: how would i do this? I dont even know whwre to begin. MIS 352 Excel Assignment 2 (10 points) Chapter 7 (pg. 289) Improving Decision

MIS 352 Excel Assignment 2 (10 points) 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, you'll use the Web to research alternative wireless services and use Excel 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 "MIS 352 Excel Assignment 2_questionfile.xlsx" 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. Calculate the Monthly Usage. (2 pts) 3. Research the information for two mobile companies and enter their names along with a web link to the company's information. (1 pt) 4. Complete the Monthly Cost per Employee for phone, service, data etc. (Hint: you may not be able to complete these depending on the plan). (2 pts) 5. Calculate Annual Cost per Employee. (2 pts) 6. Calculate Annual Cost for All Employees. (1 pt) 7. Enter a short explanation of the mobile company you recommend and why. (1 pt) If you are having difficulties, please review a few Excel tutorials posted in Canvas. Hint: Don't forget about absolute values when copying your calculations to adjacent cells. Submit the Excel file to Canvas. Assumptions Number of Employees Voice Minutes per Day Text Messages per Day per Employee per Employee Phone Model Monthly Usage Per Employes All Employees Average work days per month Voice Minutes used per month Text messages sent per month Data used per month Montly Cost per Employee Name Link Phone Basie Service Data Text Messaging Mobile Company 11 Mobile Company 02 Annual Cost Per Employee First Year Cest Second Year Cost Two Year Total Cost Annual Cont All Employee First Year Cost Second Year Cost Twe Year Total Cost Recommendation
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
