Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

This exercise was also contributed by dr. rick Wilson of Oklahoma state university . The following simple scenario mimics the the black book described in

This exercise was also contributed by dr. rick Wilson of Oklahoma state university . The following simple scenario mimics the "the black book" described in a Business week article (http://www.businessweek .com/articles/2013-01-31/coke-engineers-its-orange-juice-with-analgorithm , accessed February 2013) about Coca-Colas production of orange juice. Create an appropriate LP model for this scenario. For the next production period, there are five different batches of raw orange juice that can be blended together to make orange juice product, SunnyQ, GlowMorn, and OrethalJames. In creating the optimal blend of the three products from 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 raw juice. The five raw batches of orange juice are described here. Brix is a measure of sweetness, pulp, available stock, and cost-all self explanatory: Batch 1 Pineapple Otange A, brix = 16, pulp 1.2. 250 gallons, $2.01/gallon Batch 2 Pineapple 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 gallon, $2.55/gallon 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 batches available stock must be used in blending the three orange juice products (obviously, more than what us available cannot be used). From a products 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 and 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 sale 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 OrenthalJames Sales = $ 3.77/gallon, Max Brix =17.75, Min Brix = 17.55 , Max Pulp = 1.1

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Millionaire By Thirty The Quickest Path To Early Financial Independence

Authors: Douglas R. Andrew, Emron Andrew, Aaron Andrew

1st Edition

0446501840, 978-0446501842

More Books

Students also viewed these Finance questions