Use lingo or Excel solver please

1. A machine shop has six jobs waiting to be done. There are six machines available to do these jobs, and the shop will assign each job to a specific machine. The machines differ in their capabilities, so the times to do each job are different. The following table gives the number of minutes required to do cach job, depending on the machine to which it is assigned. Machine Job 12 3 4 5 6 135 32 38 31 37 41 2 43 39 44 40 41 45 351 56 60 54 55 57 441 42 39 40 48 43 5 32 28 29 39 36 37 6 42 38 49 43 39 45 (a) (15 marks) The shop wishes to minimize the total number of minutes used to do these jobs. Use LINGO or the Excel Solver to determine the optimal solution. (b) (10 marks) State this solution so that anyone working in the shop would be able to understand it