Question

In: Operations Management

4. Devos inc has 4 teams (A, B, C, D) and 4 (1, 2, 3, 4)...

4. Devos inc has 4 teams (A, B, C, D) and 4 (1, 2, 3, 4) potential tasks. The total amount of days each employee would need to allocate to each job is as follows:

Potential Tasks

Team

1

2

3

4

A

28

33

21

35

B

41

43

23

37

C

48

28

33

42

D

49

27

43

46

Use Excel solver

Match the team the most efficient task. What is the total number of days that these projects will take to get worked on?

Solutions

Expert Solution

Below is the screenshot of the LP table -

Below is the screenshot of the formula applied -

Below is the screenshot of the solver -

Below is the screenshot of the result -


Related Solutions

Atomicity of phosphorus is (a) 1 (b) 2 (c) 3 (d) 4
Atomicity of phosphorus is ________.(a) 1(b) 2(c) 3(d) 4
1. Evaluate: (a+b)/(c-d) + 9/(a+d) when a=5, b=3, c=8, d=4 a. 6 b. 3 c. 15/2...
1. Evaluate: (a+b)/(c-d) + 9/(a+d) when a=5, b=3, c=8, d=4 a. 6 b. 3 c. 15/2 d. 17/13 2. Solve for x: 5(x+3) = 35 a. 2 b. 7 c. 4 d. -4 3. Acid rain occurs primarily as a result of a. operating a nuclear power plant b. burning coal or oil containing sulfur c. by-products created by operating an oil refinery d. the use of Freon and other refrigerants 4. The "ozone holes" at the polar region arise...
Find the value of a : b : c : d, if a : b = 2 : 3, b : c = 4 : 5 and c : d = 6 : 7.
Find the value of a : b : c : d, if a : b = 2 : 3, b : c = 4 : 5 and c : d = 6 : 7.
A, B, C, D are all matricies A = 2x3 1 2 −3 −1 4 5...
A, B, C, D are all matricies A = 2x3 1 2 −3 −1 4 5 , B = 2x3 3 0 −1 1 2 1 , C = 2x2 2 5 1 2 , D = 3x3 1 −1 1 2 −1 2 4 −3 4 Find each of the following or explain why it does not exist. 1) A + B, 2) 2A − 3B, 3) A + C, 4) A − C, 5) AC, 6) CA, 7)...
3. Let A = D + 1, B = D − 3, C = D +...
3. Let A = D + 1, B = D − 3, C = D + x, where D = dx. Calculate the differential operators AB, BC, CA and their effect on y(x) = e^3x
2. Devos Inc. makes desks that are made up of 1 top, 2 sides, and 4...
2. Devos Inc. makes desks that are made up of 1 top, 2 sides, and 4 legs. We need to make at least 15,000 desks to fulfill the demand of our customers. The costs are as follow: Make the top - $7, Buy the top - $10, Make the side - $3, Buy the side - $5, Make a leg - $2, Buy a leg - $3 1) One top requires 4 feet of wood, one side requires 2 feet...
2. Devos Inc. makes desks that are made up of 1 top, 2 sides, and 4...
2. Devos Inc. makes desks that are made up of 1 top, 2 sides, and 4 legs. We need to make at least 15,000 desks to fulfill the demand of our customers. The costs are as follow: Make the top - $7 Buy the top - $10 Make the side - $3 Buy the side - $5 Make a leg - $2 Buy a leg - $3 1) One top requires 4 feet of wood, one side requires 2 feet...
a = [4, −9, 4] b = [7, 2, 3] c = [5, −8, 9] d...
a = [4, −9, 4] b = [7, 2, 3] c = [5, −8, 9] d = [1, −3, 2] e = [6, −2, −5, 9] f = [4, −3, 7, 5] g = [1, 3, −1, 5] h = [7, −5, 5] i = [5, 13, −7, 11] Express the hyperplane implicitly or explicitly given the following a) a and h b) f and i c) e, f, and g d) The hyperplane containing b, c and d can...
Male Female child A 4 3 9 B 3 541 2 C 5 1 f541 D...
Male Female child A 4 3 9 B 3 541 2 C 5 1 f541 D 9 6 4 E 7 9 10 IAQ  6   USING THE TABLE IN IAQ 5,  THE NAMES OF ALL OF THESE PEOPLE ARE PLACED IN A BOX, THEY ARE THORUGHLY MIXED;  THEN ONE NAME IS PULLED FROM THE BOX AT RANDOM;  ; FIND THE PROBABILITY THAT  THE PERSON WAS FEMALE GIVEN  THAT THEY WERE IN GROUP B 3 PLACE DECIMAL     
Direction ratio of line joining (2, 3, 4) and (−1, −2, 1), are: A. (−3, −5, −3) B. (−3, 1, −3) C. (−1, −5, −3) D. (−3, −5, 5)
Direction ratio of line joining (2, 3, 4) and (−1, −2, 1), are:A. (−3, −5, −3)B. (−3, 1, −3)C. (−1, −5, −3)D. (−3, −5, 5)
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT