11. (***) (Microsoft Excel problem). Re-create the assignment problem spreadsheet for Flynn Boot Company, described in Figures...

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 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.

Fantastic news! We've Found the answer you've been seeking!

Step by Step Answer:

Related Book For  book-img-for-question

Introduction To Operations And Supply Chain Management

ISBN: 9780131791039

2nd Edition

Authors: Cecil C. Bozarth, Robert B. Handfield

Question Posted: