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.

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?

Transcribed Image Text:

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