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.

this is all the information i have

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