Can Matlab Optimization Solutions be different than Lingo or Excel?

Question

john canry 2018-2-25

0
链接

此问题的直接链接

https://ww2.mathworks.cn/matlabcentral/answers/384709-can-matlab-optimization-solutions-be-different-than-lingo-or-excel

评论： Matt J 2018-2-25

Hello

For the problem below I received different answers for the Variables in Lindo and Excel but the Objective values remained the same. Is this possible? Thank you kindly

“Oxbridge University maintains a powerful mainframe computer for research use
by its faculty, Ph.D. students, and research associates. During all working hours, an
operator must be able to operate and maintain the computer, as well as to perform
some programming services. Beryl Ingram, the director of the computer facility,
oversees the operation.
It is now the beginning of the fall semester, and Beryl is confronted with the
problem of assigning different working hours to her operators. Because all the
operators are currently enrolled in the university, they are available to work only a
limited number of hours each day, as shown in the following table.
Maximum # hours available
Name Wage $/hr Mon Tues Wed Thur Fri
K.C. 10.00 6 0 6 0 6
D.H. 10.10 0 6 0 6 0
H.B. 9.90 4 8 4 0 4
S.C. 9.80 5 5 5 0 5
K.S. 10.80 3 0 3 8 0
N.K. 11.30 0 0 0 6 2
There are six operators (four undergraduate students and two graduate students).
They all have different wage rates because of differences in their experience with
computers and in their programming ability. The above table shows their wage rates,
along with the maximum number of hours that each can work each day.
Each operator is guaranteed a certain minimum number of hours per week that will
maintain an adequate knowledge of the operation. This level is set arbitrarily at 8
hours per week for the undergraduate students (K.C,, D.H, H.B, and S.C.) and 7 hours
per week for the graduate students (K.S. and N.K.).
The computer facility is to be open for operation from 8 a.m. to 10 p.m. Monday
through Friday with exactly one operator on duty during these hours. On Saturdays
and Sundays, the computer is to be operated by other staff.
Because of a tight budget, Beryl has to minimize cost. She wishes to determine the
number of hours she should assign to each operator on each day.”