sund5 - Questions and Solution Question 1. A Colombian...

This preview shows page 1 - 2 out of 5 pages.

Questions and SolutionQuestion 1.A Colombian athlete, who visits Canada and Europe frequently, is allowed to return with alimited number of consumer items not generally available in Colombia. The items, which arecarried in a due bag, cannot exceed a weight of 5 pounds. Once he is in Colombia, he sells theitems at highly inflated prices. The three most popular items in Colombia are denim jeans, CDplayers, and CDs of rock groups. The weight and profit (in CAD dollars) of each item are asfollows.He wants to determine the combination of items he should pack in his duffel bag that willmaximize his profit.a. Formulate an integer programming formulation for this problem. (3 points)b. Setup the problem in spreadsheet and solve using Excel solver. Provide a printout of theanswer report. (2 points)Solution:

Upload your study docs or become a

Course Hero member to access this document

Upload your study docs or become a

Course Hero member to access this document

End of preview. Want to read all 5 pages?

Upload your study docs or become a

Course Hero member to access this document

Term
Fall
Professor
mr
Tags
Optimization, new policy, Duffel bag, Duffel, Duffle coat

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture

  • Left Quote Icon

    Student Picture