Discover Exel Solver

A familly uses 6 food products as a source of vitamin A and C. The following table indicates the number of units of vitamin per kilogram of product, the demand in vitamins and the price of the products. The objective is to minimize the total cost. 

  product (unit/kg) demand
  1 2 3 4 5 6 (units)
Vitamin A 1 0 2 2 1 2 9
Vitamin C 0 1 3 1 3 2 19
price per kg 35 30 60 50 27 22  

Formulate this problem as a linear program.

Enter the data and the formulas.

Description de la formule à saisir sur Excel

Set the solver parameters.

Les paramètres du solver

Open the solver options and understand the elements it contains.

The solver creates three reports. Open the reports and understand the informations it contains.

Last modified: Monday, 9 October 2017, 9:23 PM