Wine Blend

Home

About

Who Are We

Contact

Wine Blend is used to compute a desired quantities of varieties , years, and areas. Any combination can be used.
o You enter the storage to select form or let the computer find the tanks and barrels.
o You tell the system what quantities of varieties, years, and areas you want.
o The system tells you how to mix the tanks.

This is a linear program using Least Squares Fit.

Entering Data.

When entering data, your probability of success reduces when using combinations of Variety, Years, and Areas. Therefore if you enter Varieties alone, Years alone, or Areas alone, you have a better chance of success.

Desired Quantity

This is for your information only and is not used by the system.

Find Tanks
Find Barrels

This check box will cause the program to find all tanks or barrels that contain the items you ask for in the variety, area or year.

Storage

Enter the storage tanks you want to use in the blend.
The system will try to use wine from the storage in the order you enter them. It will use quantities from the first storage alone if it is possible.

Variety

Enter the desired varieties and the quantity you want. You can request Lt-Less than , Eq-Equal to, or Gt-Greater than. In the example we elected to find 50 + 40 + 10 or a total quantity of 100.

Year

Enter years and the quantity you want along with their comparison

Area

Enter the areas and the quantities along with their comparison
  Desired Quantity Find Tanks
Find Barrels

 Help

Storage

Variety

Year

Area

 

Storage

1
2
3
4
5
6

Variety

Lt

Eq

Gt

Quantity

Year

Lt

Eq

Gt

Qyantity

Area

Lt

Eq

Gt

Quantity

   

If you select the [Compute] option the system will show you a table with the wine percents of each item you selected. In this case it shows the following:
Barrel B07 is 100% percent Variety 15
Tank T08 contains none of the varieties you requested
Tank T09 is 8% variety 60, and 42% variety 20
Tank T11 is 100% variety 60
Tank T12 is 80% variety 60, and 20% variety 20
Tank T15 is 15.12% variety 60, and 84.88% variety 20

# Item Typ Comp Need

B07

T08

T09

T11

T12

T15

           

2

15

v

=

10

1

0

0

0

0

0

1

60

v

=

40

0

0

0.08

1

0.8

0.1512

0

20

v

=

50

0

0

0.42

0

0.2

0.8488

The solution to the problem is to mix 10 gallons from Barrel B07, 31 gallons from Tank T11, and 58.9 gallons from Tank T15.

Optimum Solution

Item

Value

1 B07

10

4 T11

31.093308199811

6 T15

58.906691800189
Value of objective function 487.81338360038

The closer the Value of objective is to 500 the better the mixing results.