Could you please solve this for me. Following the given directions. These need to be 2 mobile phone service providing companies such as verizon and T mobile. If you could solve the entire excel assignment I would appreciate it. The full directions are provided by the first page.

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, 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 Bigabyte 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 company's 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 Cost 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. If you are having difficulties, please review 1-2 Excel tutorials provided. Hint: Don't forget about absolute values when copying your calculations to adjacent cells. Assumptions Hours per Day Zip Code Number of Employees Text Messages per Day Photos per Week Per Employee All Employees Average work days per month Minutes used per day Minutes used per month Text messages per month Photos per month Monthly Monthly Service Monthly Text messaging Monthly Phone Per Employee First Year 2nd Year Cost Cost Monthly Data Photos 2-Year Cost All Employees First Year 2nd Year Cost Cost 2-Year Cost 1 Mobile Company Name & link 42 Mobile Company Name & link Recommendation: 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, 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 Bigabyte 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 company's 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 Cost 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. If you are having difficulties, please review 1-2 Excel tutorials provided. Hint: Don't forget about absolute values when copying your calculations to adjacent cells. Assumptions Hours per Day Zip Code Number of Employees Text Messages per Day Photos per Week Per Employee All Employees Average work days per month Minutes used per day Minutes used per month Text messages per month Photos per month Monthly Monthly Service Monthly Text messaging Monthly Phone Per Employee First Year 2nd Year Cost Cost Monthly Data Photos 2-Year Cost All Employees First Year 2nd Year Cost Cost 2-Year Cost 1 Mobile Company Name & link 42 Mobile Company Name & link Recommendation