Question: 11. (***) (Microsoft Excel problem). Re-create the assignment problem spreadsheet for Flynn Boot Company, described in Figures 12.9. While your formatting does not have to

11. (***) (Microsoft Excel problem). Re-create the assignment problem spreadsheet for Flynn Boot Company, described in Figures 12.9. While your formatting does not have to be exactly the same, your spreadsheet should work the same. Specifically, the user should be able to change the weekly capacity (Ci), weekly demand (Dj), or shipping cost (Tij) values and generate a new solution using Excel’s Solver function. Test your spreadsheet by seeing whether you get a new solution when Atlanta’s warehouse capacity changes from 20,000 to 15,000. Make sure your answers match those in Example 12.7.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Supply Chain Management Questions!

Q:

a