Embry Riddle Aeronautical University Scheduling Resources Excel Worksheet
Question Description
Scenario
As part of the short-term scheduling process, a manager must assign tasks and resources (usually machines and people) to accomplish the job with the objective of minimizing total cost. In this activity, you will use the assignment method to do that.
You work in a production facility that produces widgets. You have four different machines that can produce the same part; however, since each machine is different, the production cost is different. You are responsible for assigning jobs to machines, and you need to make sure to minimize the total cost to produce the widgets.
Calculate the best job assignments based on resources as shown in the following chart.
| Costs | Machine 1 | Machine 2 | Machine 3 | Machine 4 |
|---|---|---|---|---|
| Widget 1 | $7.00 | $8.00 | $4.00 | $6.00 |
| Widget 2 | $8.00 | $7.00 | $11.00 | $10.00 |
| Widget 3 | $5.00 | $5.00 | $7.00 | $8.00 |
| Widget 4 | $10.00 | $11.00 | $12.00 | $10.00 |
Assignment
Use Excel or the Excel OM Assignment module to calculate the best job assignments based on resources as shown in the chart.
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 –> You should see “Solve Add-in” 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.
Have a similar assignment? "Place an order for your assignment and have exceptional work written by our team of experts, guaranteeing you A results."
Complete the 
Complete the order payment after filling in the order form. We’ll receive your order and assign it to a writer.
The assigned writer will complete your paper and forward it to our Editing Team for review and approval.
Once approved by the editor, the completed paper will be uploaded to your account for you to download, review and approve.