9-22 In a job shop operation, four jobs may be performed on any of four machines. The hours required for each job on each machine are presented in the following table. The plant supervisor would like to assign jobs so that total time is minimized. Write the equations for the problem from the chart (see example in the attached spreadsheet); develop a spreadsheet for a Linear Programming solution to this problem; and use SOLVER to find the solution