Complete the Coke Engineers its Orange Juice exercise You will need to use Excel Solver to complete the exercise. Submit your excel file with an executive summary of your results.

1. This exercise was also contributed by Dr. Rick Wilson of Oklahoma State University. The following simple scenario mimics the Black Book described in a Business Week article (http://www.businessweek.com/articles/2013-01-31/coke-engineers-its-orange-juice-with-an-algorithm, accessed February 2013) about Coca-Colas production of orange juice. Create an appropriate LP model for this scenario.

   • Batch 1Pineapple Orange A, brix = 16, pulp = 1.2, 250 gallons, $2.01/gallon

   • Batch 2Pineapple Orange B, brix = 17, pulp = 0.9, 200 gallons, $2.32/gallon

   • Batch 3Mid Sweet, brix = 20, pulp = 0.8, 175 gallons, $3.14/gallon

   • Batch 4Valencia, brix = 18, pulp = 2.1, 300 gallons, $2.41/gallon

   • Batch 5Temple Orange, brix = 14, pulp = 1.6, 265 gallons, $2.55/gallon

2. For the next production period, there are five different batches of raw orange juice that can be blended together to make orange juice products, SunnyQ, GlowMorn, and OrenthalJames. In creating the optimal blend of the three products from the five different batches, an LP model should seek to maximize the net of the sales price per gallon of the products less the assessed per-gallon cost of the raw juice.

   The five raw batches of orange juice are described here. Brix is a measure of sweetness, pulp, available stock, and costall self-explanatory:

Note that to make sure that the raw juice doesnt get too old over time, one production requirement is that at least 50% of each batchs available stock must be used in blending the three orange juice products (obviously, more than what is available cannot be used).

From a product perspective, there must be at least 100 gallons of SunnyQ blended and at least 125 gallons each of GlowMorn and OrenthalJames. Likewise, the projected future demand for the products indicates that in this period, there should be a maximum of 400 gallons of SunnyQ, a maximum of 375 gallons of GlowMorn, and a maximum of 300 gallons of OrenthalJames produced. Also, when blending the products from the five batches, an individual batch can provide no more than 40% of the total amount of a given product. This is to be enforced individually on each product.

Attributes of the three products include sales price, the maximum average Brix of the final mixed product, the minimum average Brix of the final mixed product, and the maximum average pulp content. In the three average requirements, this implies the weighted average of all juice mixed together for that product must meet that specification.

• SunnyQSales = $3.92/gallon, Max Brix = 19, Min Brix = 18.5, Max Pulp = 1.6

• GlowMornSales = $4.13/gallon, Max Brix = 17, Min Brix = 16.75, Max Pulp = 1.8

• OrenthalJamesSales = $3.77/gallon, Max Brix = 17.75, Min Brix = 17.55, Max Pulp = 1.1