MachineCo runs a custom machine shop, Four jobs have to be done today. There are five machines, each of which can do at most one job per day. The costs of doing each job on each machine are as follows:
TABLE 2:

Based on the question and the spreadsheet above, write the necessary value/formula etc. to the following cells. Make sure your answers will yield correct results when copied to other cells.
€¢ What value should be in cell 1)6?
€¢ What formula should be in cell 14 to write the total cost?
€¢ What formula should be in cell F12? €¢ What sign should be in cell C14?
€¢ What value should be in cell 1116?
Etc. to the following cells. Make sure your answers will yield correct results when copied to other cells.
€¢ What value should be in cell D6?
€¢ What formula should be in cell 14 to write the total cast?
€¢ What formula should be in cell F12?
€¢ What sign should be in cell C14?
€¢ What value should be in cell H16?
€¢ What formula should be in cell BIT?
€¢ What sign should be in cell C18?
€¢ What value should be in cell E19?
€¢ What will be in the "Target Cell" part in Solver? Should it be maximized or minimized?
€¢ What will be in the "Changing Celli' part. in Solver?
€¢ What will be in the "Constraints" part in Solver?

Transcribed Image Text:

Jobl Job 2 Job 3 Job 4 Machine 1 14 8. Machine 2 2 12 Machine 3 9. Machine 4 6. 10 Machine 5 8. 4 2. MACHINCO Job 1 Job 2 Job 3 Job 4 Total Cost Machine 1 14 Machine 2 12 Machine 3 Machine 4 10 Machine 5 Job 1 Job 2 Job 3 Job 4 LHS Sign RHS Machine 1 Machine 2 Machine 3 Machine 4 Machine 5 LHS Sign RHS