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

please solve using solver in excel and show steps in solver. please solve using solver in excel and show steps in solver. 1.

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

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!