Use Excel or the Excel OM Assignment module to calculate the best job assignments based on resources as shown in the chart.

$($i$)$ When using Excel OM

If you are using Excel OM$,$ please make sure you have the Excel Solver Add$-$in enabled for this assignment. It may already be enabled in your Excel, to make sure, follow the steps below:

Go to File $$ Options $$ Add$-$ins dots You should see "Solve Add$-$n$"$ under Active Application Add$-$ins.

If it is not enabled, follow these steps to enable it:

Select "Solve Add$-$in$"$ from the manage menu at the bottom of the window. Click Go$.$

Check "Solve Add$-$in$"$ box and press OK$.$

After you determine the best job assignment, indicate on your spreadsheet the minimum cost that the company will incur based on this assignment.

Save your assignment using a naming convention that includes your first and last name and the activity number $($or description$).$ Do not add punctuation or special characters.

Review the Problems Rubric for detailed grading information.