Operations Management

for B please plot a graph if you can using a computer is fine as long as I can see the feasible area. Thank you.

1. The Robinsons are planning a wedding and reception for their daughter, Rachel. Some of the most expensive items served at the reception and dinner are wine and beer. The Robinsons are planning on 400 guests at the reception, and they estimate that they need at least four servings (i.e., a glass of wine or bottle of beer) for each guest in order to be sure they won't run out. A bottle of wine contains five glasses. They also estimate that more than 50% guests will prefer wine to beer. A bottle of wine costs $6, and a bottle of beer costs $1. The Robinsons have budgeted $1,500 for wine and beer. The caterer has advised them that typically 8% of the wine and 15% of the beer will be left over. Finally, the Robinsons want to minimize their waste (i.e., cost from unused wine and beer). How many bottles of wine and beer should the Robinsons order? (Accept both geometric method or excel solver) (a) Formulate a linear programming model for this problem. (b) Graphically illustrate the feasible area and identify all the possible extreme points. (c) Solve the model - find the optimal solution points and the optimal objective function value