Frosty Queen Creamery is looking for fresh milk suppliers for its four different plants. The company...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Frosty Queen Creamery is looking for fresh milk suppliers for its four different plants. The company considers bids from five farms. The bids, maximum daily supplies available from each bidder, and the daily demand for each plant are summarized in the following table Plant- bids (8 per gallon) 1 2 3 3.50 4.60 3.65 2.75 4 Farm 1 Farm 2 2.50 2.50 3.20 4.70 Farm 3 2.55 3.20 2.70 4.50 Farm 45.00 4.70 3.60 2.90 Farm 5 2.35 3.95 2.95 3.00 Milk req. (gallons) 100 150 70 120 The following additional requirements need to be taken into account: 1. Farm 1 will only supply Plant 2 if it orders at least 50 gallons of milk. 2. Farm 2 wants the total amount it supplies to all plants to be a multiple of 60 gallons. 3. Farm 3 is only interested working with Frosty Queen Creamery if it orders all the 150 gallons the farm can supply. 4. Farm 4 requires that if it supplies less than 40 gallons to Plant 4, then it must supply at least 40 gallons to Plant 3. 5. Farm 5 insists that at least one of the following conditions is satisfied • supply to Plant 1 is at least 40 gallons • supply to Plant 2 is exactly 80 gallons; • supply to Plant 3 is at most 50 gallons. Formulate the problem of minimizing the daily cost of milk supplies while satisfying all the requirements as an MIP. Implement and solve your model in AMPL. Report your solution below. Gallons of milk supplied daily from each farm to each plant Plant-> Farm 1 Farm 2 Farm 3 Farm 4 Farm 5 Optimal daily cost: S max supply (gallons) 120 180 150 100 80 1 2 3 Frosty Queen Creamery is looking for fresh milk suppliers for its four different plants. The company considers bids from five farms. The bids, maximum daily supplies available from each bidder, and the daily demand for each plant are summarized in the following table Plant- bids (8 per gallon) 1 2 3 3.50 4.60 3.65 2.75 4 Farm 1 Farm 2 2.50 2.50 3.20 4.70 Farm 3 2.55 3.20 2.70 4.50 Farm 45.00 4.70 3.60 2.90 Farm 5 2.35 3.95 2.95 3.00 Milk req. (gallons) 100 150 70 120 The following additional requirements need to be taken into account: 1. Farm 1 will only supply Plant 2 if it orders at least 50 gallons of milk. 2. Farm 2 wants the total amount it supplies to all plants to be a multiple of 60 gallons. 3. Farm 3 is only interested working with Frosty Queen Creamery if it orders all the 150 gallons the farm can supply. 4. Farm 4 requires that if it supplies less than 40 gallons to Plant 4, then it must supply at least 40 gallons to Plant 3. 5. Farm 5 insists that at least one of the following conditions is satisfied • supply to Plant 1 is at least 40 gallons • supply to Plant 2 is exactly 80 gallons; • supply to Plant 3 is at most 50 gallons. Formulate the problem of minimizing the daily cost of milk supplies while satisfying all the requirements as an MIP. Implement and solve your model in AMPL. Report your solution below. Gallons of milk supplied daily from each farm to each plant Plant-> Farm 1 Farm 2 Farm 3 Farm 4 Farm 5 Optimal daily cost: S max supply (gallons) 120 180 150 100 80 1 2 3
Expert Answer:
Related Book For
Cornerstones of Financial and Managerial Accounting
ISBN: 978-0324787351
1st Edition
Authors: Rich Jones, Mowen, Hansen, Heitger
Posted Date:
Students also viewed these management leadership questions
-
The activities summarized in the following table must be performed by the promoter of a country music concert in Dallas. a. Draw the activity network for this problem. b. According to PERT, what is...
-
In your own words, describe what actions need to be taken in each step of the grid method.
-
What additional factors need to be taken into consideration (beyond the six phases of business venture assessment) when considering an acquisition?
-
Suppose you come from a part of the world that is blessed with abundant water. Demand never comes close to the available amount. Should you be careful about the amount you use or should you simply...
-
You have a $ 7,000 balance on your car loan at 11% interest. Your favorite aunt has just left you $ 10,000 in her will. You can put the money in a money market account at your bank and pay off your...
-
In Fig let C1 = 9.0F, C2 = 4.0F, and Vab = 28V. Suppose the charged capacitors are disconnected from the source and from each other, and then reconnected to each other with plates of opposite sign...
-
Spring A is stiffer than spring B. You stretch the springs such that the energy stored in each is the same. (a) Which spring has the greater change in length from its relaxed position? (b) Which...
-
Accounting for R&D Costs Martinez Company incurred the following costs during 2010 in connection with its research and development activities. Cost of equipment acquired that will have alternative...
-
10.Carp Co has announced that it will pay an annual dividend equal to 55% of earnings. Its earnings per share is $0.80, and it has ten million shares in issue. The return on equity of Carp Co is 20%...
-
Harper Morgan owns White Mountain Assessments in Laconia, New Hampshire. The standard workweek is 40 hours. For the weekly payroll ending September 9, 2022, checks dated September 14, 2022, complete...
-
Which of the following is true for virtual server clusters ? on-demand scalability no overhead of virtualization run on top of physical servers VM placement decisions can impact its performance
-
A single nuclear reactor produces 2.6GW of electrical power, and has a generator voltage of 22kV.What percentage of power would be lost from our nuclear reactor in three-line transmission that goes...
-
16. Brenda's Balloon Shop is a price taker, and the table below shows its costs of production. Use it to answer the following questions: Output (balloons Total Cost (dollar per hour) per hour) 0 4 1...
-
A panel of doctors announces that lookiThe price of steel used to make Stanley tumblers rises sharply. How will this affect the market for water bottles?ng at a screen for too long can affect your...
-
What kind of volatility is mentioned in the following: 2023, volatility, due to increased competition in the electric vehicle market and the impact of inflation and interest rates, Tesla...
-
6. A carver begins work on a block of granite that measures 20 cm by 10 cm by 5 cm. Granite has a density of 2.7 g/cm. What is the mass of the piece of granite? a. What do you need to calculate...
-
12. You have $10,000 in savings. Assume you earn 2.5% compounded quarterly on it for three years, then you earn 5% annually for the next two years, then you withdraw $1,000 to buy a new phone, then...
-
Give the structural formulas of the alkenes that, on ozonolysis, give: a. (CH3)2C=O and CH2=O b. Only (CH3CH2)2C=O c. CH3CH=O and CH3CH2CH=O d. O=CHCH2CH2CH2CH=O
-
Steven's Restorations was organized in January 2008. During 2008, Steven's engaged in the following stockholders' equity activities: a. Secured approval for a corporate charter that authorizes...
-
Use Aeropostale's 10-K for the year ended February 3, 2007 (filed April 2, 2007), to answer the following questions. You should look up the 10-K online (which allows you to search and reference the...
-
Use the Gregs Graphics financial statements in Problem 12-79B to respond to the following requirements. Required: 1. Compute asset efficiency ratios for Gregs Graphics for 2009 and 2008 and determine...
-
Draw a block diagram for the feedback control of a liquid-level system, which consists of a valve with a control knob (0\%-100\%) and a liquid-level sensor. Clearly label essential components and...
-
Consider the control system in Example 10.2. Build a Simulink block diagram to simulate reference tracking control, in which the signal \(R(s)\) is a sine wave with a magnitude of \(0.1 \mathrm{~m}\)...
-
Roughly sketch the root locus with respect to \(K\) for the equation of \(1+K L(s)=0\) and the following choices for \(L(s)\). Make sure to give the asymptotes, arrival or departure angles, and...
Study smarter with the SolutionInn App