The model constraints are contained in cells G7, G8, and G9. The objective function is shown on the formula bar at the top of the spreadsheet. ![]() The decision variables for the facilities are in cells C12:C15, and the objective function ( Z ) is embedded in cell C16. Z = total expected usage (people) per dayĮxhibit 5.2 shows this example model set up in Excel spreadsheet format. ![]() Recall our recreational facilities example, formulated on page 182: ![]() In this section we demonstrate both of these computer solution approaches, using the examples for 01, total, and mixed integer programming problems developed in the previous sections. Integer programming problems can be solved using Excel spreadsheets and QM for Windows.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |