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 cannot program smart home automation rules from my device using a computer or phone, and I would like to know how to properly connect devices such as switches and sensors together ? Cisco Packet Tracer 1. Smart Home Automation:o Connect a temperature sensor and a fan to a home gateway.o Configure the home gateway so that the fan is activated when the temperature exceedsa set threshold (e.g., 30°C).2. WiFi Network Configuration:o Set up a wireless LAN with a unique SSID.o Enable WPA2 encryption to secure the WiFi network.o Implement MAC address filtering to allow only specific clients to connect.3. WLC Configuration:o Deploy at least two wireless access points connected to a Wireless LAN Controller(WLC).o Configure the WLC to manage the APs, broadcast the configured SSID, and applyconsistent security settings across all APs.

using r language for integration theta = integral 0 to infinity (x^4)*e^(-x^2)/2 dx (1) use the density function of standard normal distribution N(0,1) f(x) = 1/sqrt(2pi) * e^(-x^2)/2 -infinity <x<infinity as importance function and obtain an estimate theta 1 for theta set m=100 for the estimate whatt is the estimate theta 1? (2)use the density function of gamma (r=5 λ=1/2)distribution f(x)=λ^r/Γ(r) x^(r-1)e^(-λx) x>=0 as importance function and obtain an estimate theta 2 for theta set m=1000 fir the estimate what is the estimate theta2? (3) use simulation (repeat 1000 times) to estimate the variance of the estimates theta1 and theta 2 which one has smaller variance?

using r language A continuous random variable X has density function f(x)=1/56(3x^2+4x^3+5x^4).0<=x<=2 (1) secify the density g of the random variable Y you find for the acceptance rejection method. (2) what is the value of c you choose to use for the acceptance rejection method (3) use the acceptance rejection method to generate a random sample of size 1000 from the distribution of X .graph the density histogram of the sample and compare it with the density function f(x)

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.