18Joe Henderson wants assign one operator to each machine so that the total oper

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,…