Five employees are available to perform four jobs. The time it takes each person to perform each job is given in Table 50. Determine the assignment of employees to jobs that minimizes the total time required to perform the four jobs. Please use excel solver and show steps in solution
Minimization
In mathematics, traditional optimization problems are typically expressed in terms of minimization. When we talk about minimizing or maximizing a function, we refer to the maximum and minimum possible values of that function. This can be expressed in terms of global or local range. The definition of minimization in the thesaurus is the process of reducing something to a small amount, value, or position. Minimization (noun) is an instance of belittling or disparagement.
Maxima and Minima
The extreme points of a function are the maximum and the minimum points of the function. A maximum is attained when the function takes the maximum value and a minimum is attained when the function takes the minimum value.
Derivatives
A derivative means a change. Geometrically it can be represented as a line with some steepness. Imagine climbing a mountain which is very steep and 500 meters high. Is it easier to climb? Definitely not! Suppose walking on the road for 500 meters. Which one would be easier? Walking on the road would be much easier than climbing a mountain.
Concavity
In calculus, concavity is a descriptor of mathematics that tells about the shape of the graph. It is the parameter that helps to estimate the maximum and minimum value of any of the functions and the concave nature using the graphical method. We use the first derivative test and second derivative test to understand the concave behavior of the function.
Five employees are available to perform four jobs. The time it takes each person to perform each job is given in Table 50. Determine the assignment of employees to jobs that minimizes the total time required to perform the four jobs. Please use excel solver and show steps in solution
Trending now
This is a popular solution!
Step by step
Solved in 6 steps with 7 images
