The spreadsheet in Microsoft Excel file Ch01Ex01_U10e.xlsx contains records of employee activity on special projects. Open this workbook and examine the data that you find in the three spreadsheets it contains. Assess the accuracy, relevancy, and sufficiency of this data to the following people and problems.
- a. You manage the Denver plant, and you want to know how much time your employees are spending on special projects.
- b. You manage the Reno plant, and you want to know how much time your employees are spending on special projects.
- c. You manage the Quota Computation project in Chicago, and you want to know how much time your employees have spent on that project.
- d. You manage the Quota Computation project for all three plants, and you want to know the total time employees have spent on your project.
- e. You manage the Quota Computation project for all three plants, and you want to know the total labor cost for all employees on your project.
- f. You manage the Quota Computation project for all three plants, and you want to know how the labor-hour total for your project compares to the labor-hour totals for the other special projects.
- g. What conclusions can you make from this exercise?
Explanation of Solution
a.
Time taken by employees for completing the special project in Denver plant:
Special project at Denver involves Market Analysis, Quota computation, Sourcing review and Production planning.
- Time taken by employees for Quota computation is “22+30+17+31=100” hours.
- Time taken by employees for Market analysis is “17+21=38” hours.
- Time taken by employees for sourcing review is “9+22+10+21+5=67” hours.
- Time taken by employees for production planning is “12+15+21+35+20+19=122 hours”
Therefore, time taken by employees for completing the special project in Denver plant is “327”hours.
Explanation of Solution
b.
Time taken by employees for completing the special projects in Reno plant:
Special project at Reno plant involves Quota computation, Sourcing review and Production planning.
- Time taken by employees for Quota computation is “27+42=69” hours.
- Time taken by employees for Sourcing review is “17+23+21+27=88” hours.
- Time taken by employees for Production planning is “19+20+11=50” hours.
Therefore, the time taken by employees for completing the special project in Reno plant is “207” hours.
c.
Explanation of Solution
Time taken by employees for Quota Computation in Chicago plant:
Time taken by employees for special project at Chicago plant for Quota computation is: “27+12+22+29+11+29 = 130” hours.
Therefore, the time taken by employees for computation in Chicago plant is “130” hours.
Explanation of Solution
d.
Total time taken by employees for Quota Computation for all plants:
Time taken by employees for special project at Chicago plant, Denver plant and Reno plant for Quota computation is:
- Time taken by employees for Quota computation in Denver plant is “22+30+17+31=100” hours.
- Time taken by employees for Quota computation in Reno plant is “27+42=69” hours.
- Time taken by employees for special project at Chicago plant for Quota computation is: “27+12+22+29+11+29 = 130”hours.
Therefore, the total time taken by employees is: “100+69+130=299” hours.
Explanation of Solution
e.
Total labor cost for all employees in the Quota computation project:
- Suppose the hourly pay of an employee is “$30”.
- The number of hours worked by the employees on Quota computation project is “299” hours.
Labor cost= hourly wage × number of hours = 30 × 299 = $8970
Therefore, the total labor cost for all employees in the quota computation project is “8970$”.
Explanation of Solution
f.
Comparison of labor hour total for Quota computation with other projects:
- The total time taken by employees for Quota computation is: “100+69+130=299” hours.
- The total time taken by employees for market analysis is “38” hours.
- The total time taken by employees for sourcing review is “67+88+52=207” hours.
- The total time taken by employees for production planning is “122+75+50 =247” hours.
Thus, the ratio of Quota computation with Market analysis = 299/38=7.86 hours, the ratio of Quota computation with sourcing review = 299/207=1.44 hours, and the ratio of Quota computation with production planning = 299/247= 1.21 hours.
Explanation of Solution
g.
Conclusion:
From the above questions, it can be observed that Quota computation almost takes “37%” of the total time taken to complete all projects as compared to the projects – market analysis, sourcing review and production planning.
Therefore, it can be said that the labor employed in Quota computation project is less efficient as compared to the other three projects.
Want to see more full solutions like this?
Chapter AE Solutions
EBK USING MIS
Additional Engineering Textbook Solutions
Concepts of Programming Languages (11th Edition)
Starting Out With Visual Basic (7th Edition)
Starting Out with Programming Logic and Design (4th Edition)
Starting out with Visual C# (4th Edition)
Starting Out with Programming Logic and Design (5th Edition) (What's New in Computer Science)
- Based on the information in the table, answer the following questions (a – d) and ensureto show your work.a) By using appropriate cell formatting techniques outlined in this module,reproduce the above spreadsheet in Excel. Take a clear screenshot andinsert it into your portfolio as your answer to this question. Ensure you include row and column identifiers in your screenshot, so it is clear thatyou have used Excel to reproduce the table.b) Use Excel or otherwise to find the mean average monthly cost of a SIMonly contract. Please round your answer to the nearest integer.c)i) Use Excel to find the median number of Gigabytes (GB) of data onoffer by the ten mobile networks. Please include the formula youuse.ii) Use Excel to find the mean average of Gigabytes (GB) of data onoffer by the ten mobile networks. Please include the formula you use. iii) Based on your two answers in part i) and ii), which answer wouldgive a better indication of the average number of Gigabytes (GB)of data on offer…arrow_forwardUsing the DBMS 130 Course Project ERD and Table Details spreadsheet, develop an APEX script to CREATE the 6 tables and all the constraints (PK, FK, NOT NULL, etc.).Add these two constraints to the FLIX_MOVIES table1. Movie Rating can only have these values: a. Gb. PGc. PG13 or PG-13d. R2. Movie Category can only have these valuesa. DRAMAb. COMEDYc. ACTIONd. SCIFIe. DOCUMENTARYarrow_forwardHello, can you please assist with the following problem? Q1.Using the DBMS 130 Course Project ERD and Table Details spreadsheet, develop andrun an APEX script to CREATE the 6 tables and all the constraints (PK, FK, NOT NULL,etc.).Q2.Add these two constraints to the FLIX_MOVIES table1. Movie Rating can only have these values:a. Gb. PGc. PG13d. PG-13e. R2. Movie Category can only have these valuesa. DRAMAb. COMEDYc. ACTIONd. SCIFIe. CHILDf. DOCUMENTARYQ3.Add a UNIQUE constraint to the Email column of FLIX_CUSTOMERS.Place comments in your script including course number, date, your name, and otherrelevant comments.In APEX, name your script:Course_Project_Part_1_yourInitials.sqlNOTE: Each script name must be unique in APEX. That is why you mustuse your initials in the name of your script. Otherwise, you will receive anAPEX error.arrow_forward
- Do at least three departments in your healthcare organization regularly utilize Microsoft Excel for data gathering and tabulation? When making a claim, it is preferable to have proof to support that assertion.arrow_forwardYou have seen this link before, if you already input this data into a spreadsheet you can go back to it and now run some new tests. Go to this link: http://www.shortlist.com/entertainment/books/actor-heights-versus-character-heights (Links to an external site.)Links to an external site.. In SPSS, excel or PsPP (or by hand if you wish) compare the heights between these two groups. Be sure to sure to use the correct t-test (are these independant samples or paired samples?). Report the t statistic and the p value for you calculation and interpret (are these two groups significantly different from each other?arrow_forwardYou handle administrative support for CyberToys, a small chain that sells computer hardware and software and specializes in personal service. The company has four stores located at malls and is planning more. Each store has a manager, a technician, and between one and four sales reps. The owners want to create a personnel records database, and they asked you to review a table that they had designed. They suggested fields for store number, location, store telephone, manager name, and manager home telephone. They also want fields for technician name and technician home telephone and fields for up to four sales rep names and sales rep home telephones. Draw their suggested design and analyze it using the normalization concepts you learned in the chapter. What do you think of their design and why? What would you propose?arrow_forward
- Does your healthcare institution routinely use Microsoft Excel in at least three of its departments for the purposes of data collection and tabulation? If one is going to make an assertion, wouldn't it be better to have evidence to back up that claim?arrow_forwardJanet has been asked by the CEO to provide a single data source that aggregates data from four different business units. Each business unit collects data in the same format. Specifically, each data source contains the same number of columns, in the same order, with each column having data that means the same thing. Which strategy does Janet need to take in order to create a single data source from the four data sources? options: Append Fuse Merge extract transferarrow_forwardAs a member of the campaign team for a mayoral candidate in Raleigh, your job is to gather data on the public perception of your candidate for the purpose of making informed decisions related to the campaign. More specifically, you plan to send out a survey (collecting information on race, religion, gender identity, age bracket, income level, education level, party affiliation, intention to vote for your candidate, etc.) to 4,000 Raleigh citizens in hopes of receiving at least 1,000 responses. In order to keep the responses anonymous, you plan to assign a 5-character code to each individual who receives a survey. In doing so, survey responses will be tied to codes rather than names, ensuring that the data collected is done akin to a blind study. Suppose that, for reasons tied to the software your team uses to process incoming data, you only have access to 6 unique digits: 2-7. Are you able to assign a unique code to each individual receiving the survey?arrow_forward
- Explain why Microsoft Access is much better in managing data compared to Microsoft Excel?arrow_forwardhepo has put a lot of thought into the data that he wants to store in the carbon accountingdatabase. He has also spoken to the CEOs of a number of companies in the group to get theirinputs. Between them, they have come up with a set of business rules to be used as the basis forthe data model design.Project ACME Green – Business Rules1. A single database will be created that will track the carbon footprints2 of all the companieswithin the ACME Technologies™ group.2. All tables in the database must have surrogate primary keys.3. Each company has a name and consists of one or more departments.4. Each company has one employee that is the CEO of the company. That employee may onlybe the CEO of one company, and not all employees are CEOs.5. Each department must have exactly one employee who is the Green Champion – theperson responsible for any initiatives related to the carbon footprint of the department.That employee may only be the Green Champion for a single department, and not…arrow_forwardPlease create 3 fully dressed case narratives for any of the 3 user stories below. This is for a scheduling office at a conference center. All of their records were paper records. They need a systems solution. User Stories As an employee in the scheduling office, I would like to be able to see the availability of any room on any day so I can help a customer find a room or date that will accommodate their needs. As an employee in the scheduling office, I would like to be able to access both customer’s personal information (like address and contact information) and their past and present booking information so I can help customers alter existing reservations or look up previous bookings. As an employee in the scheduling office, I would like to be able to have access to partnered vendor contact and business information so I can match them with customers who may be interested in their services. As an employee in the scheduling office, I would like to be able to handle creating and…arrow_forward
- Fundamentals of Information SystemsComputer ScienceISBN:9781337097536Author:Ralph Stair, George ReynoldsPublisher:Cengage LearningNp Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage