A firm produces six juice blends Blend A1 through A6. The juice blends are the result of blending fve juices Orange, Guava, Mango, Pineapple and Strawberry. The percentage of each juice (by volume) in the five blended juices, along with the sale prices of the blends is given in the table below. In addition, the table also shows the maximum available quantity of the ingredients and their purchase price

Other restrictions are listed below.

1. At least 25,000 gallons of blend A1 must be produced.
2. At least 25,000 gallons of blend A5 must be produced.
3. Blends A3 and A4 together must account for 25% of the total production.
4. Blend A6 must account for a minimum of 45% of the total blends
5. You should not produce more than 400,000 gallons of blend A6

Formulate the above problem as a Linear Program. Solve it using solver.

Answer the questions below.

1. Type in the algebraic below

2. Provide a screen shot of the optimal screen.

3. Fill in the tables below; Show whole gallon and whole dollar accuracy

Blend	Quantity Produced (Gallons)	Revenue (Dollars)	Cost (Dollars)	Profit (Dollars)
Blend A1
Blend A2
Blend A3
Blend A4
Blend A5
Blend A6
TOTAL

Ingredient	Quantity Ordered (Gallons)	Total Cost (Dollars)
Orange Juice
Guava Juice
Mango Juice
Pineapple Juice
Strawberry Juice
Total

Orange Juice Guava Juice Mango Juice Pineapple Juce Strawberry Sale Price of the Blend (in $/gallon) Juice $2.89 $3.79 $4.50 $3.90 $3.80 $2.79 $1.65 $3.20 $3.00 $1.95 $2.20 Purchase Price (in $/gallon) Maximum Available for purchase (in gallons) 500,000 180,000 240,000 420,000 380,000 Orange Juice Guava Juice Mango Juice Pineapple Juce Strawberry Sale Price of the Blend (in $/gallon) Juice $2.89 $3.79 $4.50 $3.90 $3.80 $2.79 $1.65 $3.20 $3.00 $1.95 $2.20 Purchase Price (in $/gallon) Maximum Available for purchase (in gallons) 500,000 180,000 240,000 420,000 380,000