Fruity Juices, Inc., produces five different flavors of fruit juice: apple, cherry, pomegranate, orange, and pineapple. Each batch of product requires processing in three departments (blending, straining, and bottling).

The relevant data (per 1,000-gallon batches)

are shown next.

Time Required in Minutes/Batch Apple Cherry Pomegranate Orange Pineapple Minutes Avail.
Blend 23 22 18 19 19 5,000 Strain 22 40 20 31 28 3,000 Bottle 10 10 10 10 10 5,000 Profit and Sales Potential Apple Cherry Pomegranate Orange Pineapple Profit ($/1,000 gal) $800 $320 $1,120 $1,440 $800 Max Sales (000) 20 30 50 50 20 Min Sales (000) 10 15 20 40 10

a. Formulate a linear program to find the amount of each product to produce.

b. Implement your model on a spreadsheet and find an optimal solution with Solver.

c. What effect would an increase of capacity in the straining department have on profit?