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
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)
Randomly pair 4 keys {a, b, c, d} with 3 locks {a, b, c}. What is...
Randomly pair 4 keys {a, b, c, d} with 3 locks {a, b, c}. What is P(at least one match)?
Prove that the set R ={ a+ b√2+c√3+d√6 , a,b,c,d belongs to Q } is a...
Prove that the set R ={ a+ b√2+c√3+d√6 , a,b,c,d belongs to Q } is a field
Part 1: answer (a), (b), (c), and (d). Part 2: answer (a), (b), (c), and (d)....
Part 1: answer (a), (b), (c), and (d). Part 2: answer (a), (b), (c), and (d). Godspeed, and good luck!!! CC11 Cookie Creations Natalie and her friend Curtis Lesperance decide that they can benefit from joining Cookie Creations and Curtis’s coffee shop. In the first part of this problem, they come to you with questions about setting up a corporation for their new business. In the second part of the problem, they want your help in preparing financial information following...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT