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 below.

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 Minutes/batch Apple Cherry Pomegranate Orange Pineapple Available Blend 23 22 18 19 19 5000 Strain 22 40 20 34 22 3000 Bottle 10 10 10 10 10 5000