Domaine Paul Autard, to illustrate the use of constrained optimization to maximize outcomes. In this example, specific constraints were identified.

The vineyard delivers three types of grapes:

1. 1,700 cases of Grenache
2. 1,200 cases of Syrah
3. 500 cases of Counoise

Domaine Paul Autard produces two varieties of red wine:

1. La Cote Ronde:

• Comprises 50% Grenache and 50% Syrah
• Generates a contribution of 400 per case

1. Domaine Paul Autard

• Comprises 60% Grenache, 20% Syrah, and 20% Counoise
• Generates a contribution of 600 per case

Given these constraints, how many cases of wine should Paul Autard make?

• Maximize Total Contributions
• Total Used

Use the Excel template to find the optimal solution for Paul Autards business decision:

How many cases of La Cote Ronde and Domaine Paul Autard should this company produce to deliver an optimal return?

Note : Please help to answer with the above template

Domaine Paul Autard Modeling Managerial Decisions Product 1,000 s contribution per 100 cases 100 's of cases to produce Resource Grenache Syrah Counoise