Videos
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
Using MIS (10th Edition)
Additional Engineering Textbook Solutions
Java: An Introduction to Problem Solving and Programming (8th Edition)
SURVEY OF OPERATING SYSTEMS
Starting Out with Python (4th Edition)
Starting Out with C++ from Control Structures to Objects (9th Edition)
Computer Science: An Overview (13th Edition) (What's New in Computer Science)
Introduction To Programming Using Visual Basic (11th Edition)
- what is a feature in the Windows Server Security Compliance Toolkit, thank you.arrow_forwardYou will write a program that allows the user to keep track of college locations and details about each location. To begin you will create a College python class that keeps track of the csollege's unique id number, name, address, phone number, maximum students, and average tuition cost. Once you have built the College class, you will write a program that stores College objects in a dictionary while using the College's unique id number as the key. The program should display a menu in this order that lets the user: 1) Add a new College 2) Look up a College 4) Delete an existing College 5) Change an existing College's name, address, phone number, maximum guests, and average tuition cost. 6) Exit the programarrow_forwardShow all the workarrow_forward
- Show all the workarrow_forward[5 marks] Give a recursive definition for the language anb2n where n = 1, 2, 3, ... over the alphabet Ó={a, b}. 2) [12 marks] Consider the following languages over the alphabet ={a ,b}, (i) The language of all words that begin and end an a (ii) The language where every a in a word is immediately followed by at least one b. (a) Express each as a Regular Expression (b) Draw an FA for each language (c) For Language (i), draw a TG using at most 3 states (d) For Language (ii), construct a CFG.arrow_forwardQuestion 1 Generate a random sample of standard lognormal data (rlnorm()) for sample size n = 100. Construct histogram estimates of density for this sample using Sturges’ Rule, Scott’s Normal Reference Rule, and the FD Rule. Question 2 Construct a frequency polygon density estimate for the sample in Question 1, using bin width determined by Sturges’ Rule.arrow_forward
- Generate a random sample of standard lognormal data (rlnorm()) for sample size n = 100. Construct histogram estimates of density for this sample using Sturges’ Rule, Scott’s Normal Reference Rule, and the FD Rule.arrow_forwardCan I get help with this case please, thank youarrow_forwardI need help to solve the following, thank youarrow_forward
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781285196145Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos CoronelPublisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr