18Joe Henderson wants assign one operator to each machine so that the total operating times for all three operators is minimized.a. formulate a linear programming model for this problemb. solve the model using the computerc. Joes’ brother , Fred has asked him to hire his wife, Kelly, who is a machine operator. Kelly can perform each of the three required machine operations in 20 minutes. Should Joe hire his sister-in-law. PLEASE use Excel Solver
Joe Henderson runs a small metal parts shop. The shop contains 3 machines- a drill press, lathe,and a grinder. Joe has three operators, each are certified to work on all three machines. However,…