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

After our initial deployment for our ML home based security system, the first steps we took to contribute further to the project, we conducted load testing, tested and optimize for low latency, and automated user onboarding. What should be next?

Why investing in skills and technology is a critical factor in the financial management aspect of system projects.

why investing in skills and technology is a critical factor in the financial management aspect of systems projects.

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.