Costs Machine 1 Machine 2 Machine 3 Machine 4 Widget 1 $9.00 $7.00 $3.00 $5.00 Widget 2 $7.00 $8.00 $12.00 $11.

$10.00

Use the Excel OM module to calculate the best job assignments based on resources as shown in the chart. After you determine the best job assignment, indicate on your spreadsheet the minimum cost that the company will incur