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
Get step-by-step solutions from verified subject matter experts
