Groovy Juice, Inc. manufactures two different beverages, Tropical Breeze and Guava Jive. Each product is made from a mixture of grape, guava, and papaya juices. On a given production day, Groovy Juice has 1000 gallons of grape juice, 400 gallons of guava juice, and 300 gallons of papaya juice available in stock. Each gallon of Tropical Breeze sells for $1.30, and each gallon of Guava Jive sells for $1.50. Research by the company’s marketing department has determined the range of percentages of each type of juice that customers want in each beverage, as follows:
Tropical Breeze should be 20-25% guava juice and 20-25% papaya juice.
Guava Jive should be 40-50% guava juice and no more than 5% papaya juice.
{\color{Green} {\color{Red} }}Create a spreadsheet in Excel and use the Solver to find the optimal solution.
Groovy Juice wants to determine the amounts and compositions of each beverage that will maximize its daily revenue.
Let xij = amount of juice i used to produce beverage j, for i = {1, 2, 3} and j = {1, 2}. For example, x21 = amount of guava juice used to produce Tropical Breeze.