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?

Question

Want to see more full solutions like this?

Answer 1

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

I would like to get help to resolve the following case

Last Chance Securities The IT director opened the department staff meeting today by saying, "I've got some good news and some bad news. The good news is that management approved the payroll system project this morning. The new system will reduce clerical time and errors, improve morale in the payroll department, and avoid possible fines and penalties for noncompliance. The bad news is that the system must be installed by January 1st in order to meet new federal reporting rules, all expenses from now on must be approved in advance, the system should have a modular design if possible, and the vice president of finance would like to announce the new system in a year-end report if it is ready by mid-December." Tasks 1. Why is it important to define the project scope? How would you define the scope of the payroll project in this case? 2. Review each constraint and identify its characteristics: present versus future, internal versus exter- nal, and mandatory versus desirable. 3. What…

2. Signed Integers Unsigned binary numbers work for natural numbers, but many calculations use negative numbers as well. To deal with this, a number of different methods have been used to represent signed numbers, but we will focus on two's complement, as it is the standard solution for representing signed integers. 2.1 Two's complement • Most significant bit has a negative value, all others are positive. So, the value of an n-digit -2 two's complement number can be written as: Σ2 2¹ di 2n-1 dn • Otherwise exactly the same as unsigned integers. i=0 - • A neat trick for flipping the sign of a two's complement number: flip all the bits (0 becomes 1, or 1 becomes 0) and then add 1 to the least significant bit. • Addition is exactly the same as with an unsigned number. 2.2 Exercises For questions 1-3, answer each one for the case of a two's complement number and an unsigned number, indicating if it cannot be answered with a specific representation. 1. (15 pts) What is the largest integer…

Answer 2

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!

Answer 3

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!

Answer 4

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!

Answer 5

Textbook Question

Answer 6

Textbook Question

Answer 7

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.

Answer 8

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.

Answer 9

Expert Solution

Answer 10

Expert Solution

Answer 11

Expert Solution

Answer 12

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.

Answer 13

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.

Answer 14

Expert Solution

Answer 15

Expert Solution

Answer 16

Expert Solution

Answer 17

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.

Answer 18

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.

Answer 19

c.

Expert Solution

Answer 20

c.

Expert Solution

Answer 21

Expert Solution

Answer 22

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.

Answer 23

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.

Answer 24

Expert Solution

Answer 25

Expert Solution

Answer 26

Expert Solution

Answer 27

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.

Answer 28

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$”.

Answer 29

Expert Solution

Answer 30

Expert Solution

Answer 31

Expert Solution

Answer 32

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$”.

Answer 33

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.

Answer 34

Expert Solution

Answer 35

Expert Solution

Answer 36

Expert Solution

Answer 37

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.

Answer 38

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.

Answer 39

Expert Solution

Answer 40

Expert Solution

Answer 41

Expert Solution

Answer 42

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.