Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Please follow the instructions and show your work! QUESTION 3 Frosty Queen Creamery is looking for fresh milk suppliers for its four different plants. The

Please follow the instructions and show your work!

image text in transcribed

QUESTION 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: bids ($ per gallon) Plant 1 2 3 4 Farm 1 3.50 4.60 3.65 2.75 Farm 2 2.50 2.50 3.20 4.70 Farm 3 2.55 3.20 2.70 4.50 Farm 4 5.00 4.70 3.60 2.90 Farm 5 2.35 3.95 2.95 3.00 Milk req. (gallons) 100 150 70 120 max supply (gallons) 120 180 150 100 80 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-> 3 Farm 1 Farm 2 Farm 3 Farm 4 Farm 5 Optimal daily cost: $ QUESTION 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: bids ($ per gallon) Plant 1 2 3 4 Farm 1 3.50 4.60 3.65 2.75 Farm 2 2.50 2.50 3.20 4.70 Farm 3 2.55 3.20 2.70 4.50 Farm 4 5.00 4.70 3.60 2.90 Farm 5 2.35 3.95 2.95 3.00 Milk req. (gallons) 100 150 70 120 max supply (gallons) 120 180 150 100 80 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-> 3 Farm 1 Farm 2 Farm 3 Farm 4 Farm 5 Optimal daily cost: $

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

Step: 3

blur-text-image

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

Financial And Managerial Accounting The Basis For Business Decisions

Authors: Jan Williams, Sue Haka, Mark S Bettner

13th Edition

0072942827, 978-0072942828

More Books

Students also viewed these Accounting questions