EBK ESSENTIALS OF MIS,
EBK ESSENTIALS OF MIS,
13th Edition
ISBN: 8220106778494
Author: LAUDON
Publisher: PEARSON
Expert Solution & Answer
Book Icon
Chapter 7, Problem 10HMP

Explanation of Solution

Analyzing telecommunications service and costs:

Given:

Number of employees = 35

Hours per day = 3

Text messages per day = 30

Photos per week = 5

The average working days per month = number of weeks per year × number of                    working days per weeknumber of months52× 512= 22

Therefore the average working days per month for an employee is 22. So the total number of employees is 22 × 35 = 770

Minutes used per day = Hours per day × minutes per hour= 3 × 60= 180

Therefore the minutes used per day for an employee is 180. So the total number of employees is 180 × 35 = 6300

Minutes used per month = Minutes used per day × Average working days per month= 180 ×22= 3960

Therefore the minutes used per day for an employee is 3960. So the total number of employees is 3960 × 35 = 138600

Text messages per month = Text messages per day × Average working days per month= 30 × 22= 660

Therefore the minutes used per day for an employee is 660. So the total number of employees is 660 × 35 = 23100

Photos per month = Photos per week × Average working days per month5× 225= 22

Therefore the minutes used per day for an employee is 22. So the total number of employees is 22 × 35 = 770

The features of the mobile handsets and wireless plans offered by the vendors are given below:

  • AT&T Mobile Shared Value Plan – offer monthly service as 35 no monthly text messaging, no monthly photos and data as 300.
  • Verizon More Everything Plan for Business – offer monthly service as 35 no monthly text messaging, no monthly photos and data as 410.
  • T-Mobile Simple Choice 1 GB – offer monthly service as 15, no monthly text messaging, no monthly photos and no data.

First year cost per employee:

According to the AT&T Mobile Shared Value Plan, the first year cost per employee is given below:

First year cost per employee = (Number of months × (Monthly service + Monthly text messaging + Monthly photos + Phone ) + Phone + Data )= 12 × (35 + 0 + 0 + 0)+ 0 + 300

    (12 × 35) + 0 + 300420 + 0 + 300= 720

Therefore first year cost per employee is 720.

According to the Verizon More Everything Plan for Business, the first year cost per employee is given below:

First year cost per employee = (Number of months × (Monthly service + Monthly text messaging + Monthly photos + Phone ) + Phone + Data )= 12 × (35 + 0 + 0 + 0)+ 0 + 410

    (12 × 35) + 0 + 410420 + 0 + 410= 830

Therefore first year cost per employee is 830.

According to the T-Mobile Simple Choice 1 GB, the first year cost per employee is given below:

First year cost per employee = (Number of months × (Monthly service + Monthly text messaging + Monthly photos + Phone ) + Phone + Data )= 12 × (15 + 0 + 0 + 0)+ 0 + 0

    (12 × 15) + 0 + 0180

Therefore first year cost per employee is 180.

Second year cost per employee:

According to the AT&T Mobile Shared Value Plan, the second year cost per employee is given below:

Second year cost per employee = First year cost per employee(Phone + Data)= 720  0 + 300= 420

Therefore second year cost per employee is 420.

According to the Verizon More Everything Plan for Business, the second year cost per employee is given below:

Second year cost per employee = First year cost per employee(Phone + Data)= 830  0 + 410= 420

Therefore second year cost per employee is 420

Blurred answer
Students have asked these similar questions
Hands-On Assignments Part II Assignment 1-5: Querying the DoGood Donor Database Review the DoGood Donor data by writing and running SQL statements to perform the following tasks: 1. List each donor who has made a pledge and indicated a single lump sum payment. Include first name, last name, pledge date, and pledge amount. 2. List each donor who has made a pledge and indicated monthly payments over one year. Include first name, last name, pledge date, and pledge amount. Also, display the monthly payment amount. (Equal monthly payments are made for all pledges paid in monthly payments.) 3. Display an unduplicated list of projects (ID and name) that have pledges committed. Don't display all projects defined; list only those that have pledges assigned. 4. Display the number of pledges made by each donor. Include the donor ID, first name, last name, and number of pledges. 5. Display all pledges made before March 8, 2012. Include all column data from the DD PLEDGE table.
Write a FancyCar class to support basic operations such as drive, add gas, honk horn, and start engine. FancyCar.java is provided with method stubs. Follow each step to gradually complete all methods. Note: This program is designed for incremental development. Complete each step and submit for grading before starting the next step. Only a portion of tests pass after each step but confirm progress. The main() method includes basic method calls. Add statements in main() as methods are completed to support development mode testing. Step 0. Declare private fields for miles driven as shown on the odometer (int), gallons of gas in tank (double), miles per gallon or MPG (double), driving capacity (double), and car model (String). Note the provided final variable indicates the gas tank capacity of 14.0 gallons. Step 1 (2 pts). 1) Complete the default constructor by initializing the odometer to five miles, tank is full of gas, miles per gallon is 24.0, and the model is "Old Clunker". 2)…
Find the error: daily_sales = [0.0, 0.0, 0.0, 0.0, 0.0, 0.0, 0.0] days_of_week = ['Sunday', 'Monday', 'Tuesday',                     'Wednesday', 'Thursday', 'Friday',                     'Saturday'] for i in range(7):         daily_sales[i] = float(input('Enter the sales for ' \                                      + day_of_week[i] + ': ')
Knowledge Booster
Background pattern image
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Enhanced Discovering Computers 2017 (Shelly Cashm...
Computer Science
ISBN:9781305657458
Author:Misty E. Vermaat, Susan L. Sebok, Steven M. Freund, Mark Frydenberg, Jennifer T. Campbell
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781305971776
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Principles of Information Systems (MindTap Course...
Computer Science
ISBN:9781285867168
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Text book image
Information Technology Project Management
Computer Science
ISBN:9781337101356
Author:Kathy Schwalbe
Publisher:Cengage Learning
Text book image
Microsoft Windows 10 Comprehensive 2019
Computer Science
ISBN:9780357392607
Author:FREUND
Publisher:Cengage
Text book image
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning