Question: please solve using solver in excel and show steps in solver. 1. Integer programming problem (25 points) The Indy Glass Blowing Company make hand crafted
1. Integer programming problem (25 points) The Indy Glass Blowing Company make hand crafted glass products. They are preparing for the holiday season to make to make larges vases, wine decanters, and glasses. Each large vase requires 12.6 ounces of raw glass and 34 hours of labor, each wine decanter requires 7.8 ounces of glass and 20 hours of labor, and each glass requires 6.2 ounces of glass and 14 hours. Indy Glass Blowing Company has 250 ounces of raw glass in inventory and 640 hours of labor. Each vase costs $33.00, each decanter costs $17.00, and each glass costs $15.80. The Indy Glass Blowing Company wants to know how many items to produce in order to maximize revenue. Solve this model using Excel
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
