Using MIS (10th Edition)
10th Edition
ISBN: 9780134606996
Author: David M. Kroenke, Randall J. Boyle
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter AE, Problem AE1.1
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?
Expert Solution
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.
Expert Solution
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.
Expert Solution
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.
Expert Solution
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.
Expert Solution
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$”.
Expert Solution
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.
Expert Solution
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?
Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Students have asked these similar questions
solve this questions for me .
a) first player is the minimizing player. What move should be chosen?b) What nodes would not need to be examined using the alpha-beta pruning procedure?
Consider the problem of finding a path in the grid shown below from the position S to theposition G. The agent can move on the grid horizontally and vertically, one square at atime (each step has a cost of one). No step may be made into a forbidden crossed area. Inthe case of ties, break it using up, left, right, and down.(a) Draw the search tree in a greedy search. Manhattan distance should be used as theheuristic function. That is, h(n) for any node n is the Manhattan distance from nto G. The Manhattan distance between two points is the distance in the x-directionplus the distance in the y-direction. It corresponds to the distance traveled along citystreets arranged in a grid. For example, the Manhattan distance between G and S is4. What is the path that is found by the greedy search?(b) Draw the search tree in an A∗search. Manhattan distance should be used as the
Chapter AE Solutions
Using MIS (10th Edition)
Ch. AE - The spreadsheet in Microsoft Excel file...Ch. AE - Prob. AE1.2Ch. AE - Prob. AE2.1Ch. AE - Prob. AE2.2Ch. AE - Prob. AE3.1Ch. AE - In this exercise, you will learn how to create a...Ch. AE - Prob. AE4.1Ch. AE - Prob. AE4.2Ch. AE - In some cases, users want to use Access and Excel...Ch. AE - Prob. AE5.2
Additional Engineering Textbook Solutions
Find more solutions based on key concepts
Practice Program 2 used two arrays to implement a simple phone book. A more scalable solution is to make an arr...
Java: An Introduction to Problem Solving and Programming (8th Edition)
This optional Google account security feature sends you a message with a code that you must enter, in addition ...
SURVEY OF OPERATING SYSTEMS
What will the following program display? def main (): x = 1 y = 3.4 print(x, y) change_us(x, y) print(x, y) def...
Starting Out with Python (4th Edition)
Characters for the ASCII Codes Write a program that uses a loop to display the characters for the ASCII codes 0...
Starting Out with C++ from Control Structures to Objects (9th Edition)
Define the term process as it is used in the context of operating systems.
Computer Science: An Overview (13th Edition) (What's New in Computer Science)
(True or False) If is the length of str, then is the string consisting of the last character of str.
Introduction To Programming Using Visual Basic (11th Edition)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.Similar questions
- whats for dinner? pleasearrow_forwardConsider the follow program that prints a page number on the left or right side of a page. Define and use a new function, isEven, that returns a Boolean to make the condition in the if statement easier to understand. ef main() : page = int(input("Enter page number: ")) if page % 2 == 0 : print(page) else : print("%60d" % page) main()arrow_forwardWhat is the correct python code for the function def countWords(string) that will return a count of all the words in the string string of workds that are separated by spaces.arrow_forward
- Consider the following program that counts the number of spaces in a user-supplied string. Modify the program to define and use a function, countSpaces, instead. def main() : userInput = input("Enter a string: ") spaces = 0 for char in userInput : if char == " " : spaces = spaces + 1 print(spaces) main()arrow_forwardWhat is the python code for the function def readFloat(prompt) that displays the prompt string, followed by a space, reads a floating-point number in, and returns it. Here is a typical usage: salary = readFloat("Please enter your salary:") percentageRaise = readFloat("What percentage raise would you like?")arrow_forwardassume python does not define count method that can be applied to a string to determine the number of occurances of a character within a string. Implement the function numChars that takes a string and a character as arguments and determined and returns how many occurances of the given character occur withing the given stringarrow_forward
- Consider the ER diagram of online sales system above. Based on the diagram answer the questions below, a) Based on the ER Diagram, determine the Foreign Key in the Product Table. Just mention the name of the attribute that could be the Foreign Key. b) Mention the relationship between the Order and Customer Entities. You can use the following: 1:1, 1:M, M:1, 0:1, 1:0, M:0, 0:M c) Is there a direct relationship that exists between Store and Customer entities? Answer Yes/No? d) Which of the 4 Entities mention in the diagram can have a recursive relationship? e) If a new entity Order_Details is introduced, will it be a strong entity or weak entity? If it is a weak entity, then mention its type?arrow_forwardNo aiarrow_forwardGiven the dependency diagram of attributes {C1,C2,C3,C4,C5) in a table shown in the following figure, (the primary key attributes are underlined)arrow_forward
- What are 3 design techniques that enable data representations to be effective and engaging? What are some usability considerations when designing data representations? Provide examples or use cases from your professional experience.arrow_forward2D array, Passing Arrays to Methods, Returning an Array from a Method (Ch8) 2. Read-And-Analyze: Given the code below, answer the following questions. 2 1 import java.util.Scanner; 3 public class Array2DPractice { 4 5 6 7 8 9 10 11 12 13 14 15 16 public static void main(String args[]) { 17 } 18 // Get an array from the user int[][] m = getArray(); // Display array elements System.out.println("You provided the following array "+ java.util.Arrays.deepToString(m)); // Display array characteristics int[] r = findCharacteristics(m); System.out.println("The minimum value is: " + r[0]); System.out.println("The maximum value is: " + r[1]); System.out.println("The average is: " + r[2] * 1.0/(m.length * m[0].length)); 19 // Create an array from user input public static int[][] getArray() { 20 21 PASSTR2222322222222222 222323 F F F F 44 // Create a Scanner to read user input Scanner input = new Scanner(System.in); // Ask user to input a number, and grab that number with the Scanner…arrow_forwardGiven the dependency diagram of attributes C1,C2,C3,C4,C5 in a table shown in the following figure, the primary key attributes are underlined Make a database with multiple tables from attributes as shown above that are in 3NF, showing PK, non-key attributes, and FK for each table? Assume the tables are already in 1NF. Hint: 3 tables will result after deducing 1NF -> 2NF -> 3NFarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Database Systems: Design, Implementation, & Manag...Computer ScienceISBN:9781305627482Author:Carlos Coronel, Steven MorrisPublisher:Cengage Learning
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
A Guide to SQLComputer ScienceISBN:9781111527273Author:Philip J. PrattPublisher:Course Technology Ptr
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781305627482
Author:Carlos Coronel, Steven Morris
Publisher:Cengage Learning
Database Systems: Design, Implementation, & Manag...
Computer Science
ISBN:9781285196145
Author:Steven, Steven Morris, Carlos Coronel, Carlos, Coronel, Carlos; Morris, Carlos Coronel and Steven Morris, Carlos Coronel; Steven Morris, Steven Morris; Carlos Coronel
Publisher:Cengage Learning
A Guide to SQL
Computer Science
ISBN:9781111527273
Author:Philip J. Pratt
Publisher:Course Technology Ptr
How to Design DB Tables for any Application? (The Basics); Author: Studytonight;https://www.youtube.com/watch?v=XUdNVaSikqY;License: Standard YouTube License, CC-BY
Create a Table (Introduction to Oracle SQL); Author: Database Star;https://www.youtube.com/watch?v=BiV1IrzB1sY;License: Standard Youtube License