Using MIS (10th Edition)
10th Edition
ISBN: 9780134658926
Author: KROENKE
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
fx 1/1/2028 A 1 Monthly Close Date 1/1/2028 A2 23 4 5 6 868 9 10 11 12 B C A manager would like to repeat a series of dates for the year in Excel to support an automated Process that happens once a month on the first day of the month. Given the spreadsheet shown, what are the next steps to complete this task? While in cell A2, hold the shift key and press the down arrow. O Enter '2/1/2028' in cell A3. Select both A2 and A3 and drag the fill handle down. Enter '2/1/2028' in cell A3. Select A3 and drag the fill handle down. Click on the fill handle in cell A2 and drag down.
Excel Data Analysis Problem1. Create a spreadsheet in Excel with the following labels and data:2. Apply currency format with 0 decimal places to cells B3:D6.3. Apply bold formating to labels in Row 2 and Column A.4. In cell E2 type Total.5. In cell F2 type Goal.6. In cell G2 type Bonus.7. Merge and Center the contents of cell A1 in A1:G1. Bold the text and increase the fontsize to 16.8. Select cells B2:G2 and center (bold any headings if necessary).9. In cell E3 enter a formula that adds up the sales for the three months. Increase thewidth of column E if necessary. Point to the fill handle of E3 and drag down to E6 tocopy the formula down for each store.10. In cells F3:F6 type 250000, 150000, 200000, & 250000. Apply currency style with 0decimal places and increase the column width if necessary.11. In cell G3 enter an IF function that compares the first quarter total sales for Store 1 to itsgoal and displays 10% of the total sales if the store made or surpassed their goal and 0 ifit…
Using data as shown in Figure 4.0 you need to :
1)Make your own monthly budget consist of 3 different sheets of Summary, Monthly Income and Monthly Expenses.
2)Protect worksheet Monthly Expenses and assign a password to open the workbook.
3)Please share excel data to Microsoft Word and name it as Monthly Budget.
4)Please print screen all the step you have been made in exercise 4.
5)Insert (name, matric number, section) on top (left side) of every worksheet.
6)Please rename and save your work as (matric number_LabSheet4).
Note : Use Monthlybudget for all your default password.
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
Which category of C++ reference variables always produces aliases?
Concepts of Programming Languages (11th Edition)
T F: Changing an objects Text property also changes the objects name.
Starting Out With Visual Basic (7th Edition)
If the str variable contains the string "Redmond", which pseudocode statement changes its contents to "Red"? a....
Starting Out with Programming Logic and Design (4th Edition)
Software Sales A software company sells a package that retails for 99. Quantity discounts are given according t...
Starting out with Visual C# (4th Edition)
What are classes responsibilities?
Starting Out with Programming Logic and Design (5th Edition) (What's New in Computer Science)
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
- 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
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Fundamentals of Information SystemsComputer ScienceISBN:9781337097536Author:Ralph Stair, George ReynoldsPublisher:Cengage Learning
Np Ms Office 365/Excel 2016 I NtermedComputer ScienceISBN:9781337508841Author:CareyPublisher:Cengage
Fundamentals of Information Systems
Computer Science
ISBN:9781337097536
Author:Ralph Stair, George Reynolds
Publisher:Cengage Learning
Np Ms Office 365/Excel 2016 I Ntermed
Computer Science
ISBN:9781337508841
Author:Carey
Publisher:Cengage
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