Microsoft Excel 14.1 Answer ReportWorksheet: [Ejercicio_vasos.xlsx]Sheet1Report Created: 8/20/2015 4:54:27 PMResult: Solver found an integer solution within tolerance. All constraints are satisfied.Solver EngineSolver Options

Objective Cell (Min)Cell Name Original Value

$K$6 Costos totales 186826

Variable CellsCell Name Original Value

$K$14:$V$25

ConstraintsCell Name Cell Value

$AE$14:$AE$25 <= $AF$14:$AF$25

$AH$14:$AH$25 <= $AI$14:$AI$25

$AK$14:$AK$25 <= $AL$14:$AL$25

$X$14:$AC$25 = 0

$Q$25:$V$25 >= $C$6:$H$6

$K$14:$V$25=Integer

Result: Solver found an integer solution within tolerance. All constraints are satisfied.

Final Value186826

Final Value Integer

Formula Status Slack

v1 v2 v3

Costo Prod 100 80 110

Costo_alm 25 28 28Inv Inic 50 20 0

Inv Final 10 10 10Tiempo Manual 3 3 3Tiem_Horneado 2 1 4

Tamaño 4 5 5

DemandaPeriodo v1 v2 v3

0 - - -1 20 17 182 22 19 353 18 23 174 35 20 105 17 11 96 19 10 217 23 12 238 20 34 159 29 21 10

10 30 23 011 28 30 1312 32 12 17

v4 v5 v6 Función Objetivo

90 200 140

27 10 2015 0 1010 10 10 Costos totales2 4 48 11 96 4 9

Demandav4 v5 v6 Periodo- - - 0

31 23 22 145 20 18 224 23 20 338 15 19 441 10 18 520 22 35 619 18 0 737 30 28 828 28 12 912 7 30 1030 15 21 1137 10 23 12

Costos Totales Producir

Costos Totales Almacenar

Función Objetivo

0 0 0 0 0 0

0 0 0 0 0 0

0

Variables de decisiónX (Cantidad que se produce)

- - - - - -0 0 0 0 0 00 0 0 0 0 00 0 0 0 0 00 0 0 0 0 00 0 0 0 0 00 0 0 0 0 00 0 0 0 0 00 0 0 0 0 00 0 0 0 0 00 0 0 0 0 00 0 0 0 0 00 0 0 0 0 0

0

0

Variables de decisiónI (inventarios)

50 20 0 15 0 100 0 0 0 0 00 0 0 0 0 00 0 0 0 0 00 0 0 0 0 00 0 0 0 0 00 0 0 0 0 00 0 0 0 0 00 0 0 0 0 00 0 0 0 0 00 0 0 0 0 00 0 0 0 0 00 0 0 0 0 0

Totales Producir/almacenar

RestriccionesBalance v1 Balance v2 Balance v3 Balance v4

Restricciones RestricciónBalance v5 Balance v6

Horas manuales

Restricción Restricción

Horas horno Inventarios