Please extract this tabular form using the least cost method Part 4-Network Problems(10)The U.S. government is auctioning off oil leases at two sites: 1 and 2. At each site, 100 000 acres of land are to be auctioned. Cliff Ewing, BlakeBarnes, and Alexis Pickens are bidding for the oil. Governmentrules state that no bidder can receive more than 40% of the land being auctioned. Cliff has bid $1,000/acre for site 1 land and $2,000/acre for site 2 land. Blake has bid $900/acre for site 1 land and $2,200/acre for site2 land. Alexis has bid $1,100/acrefor site 1 land and$1,900/acre for site 2 land. Formulate a balanced transportation model to maximize the government’s revenue.

Database System Concepts
7th Edition
ISBN:9780078022159
Author:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Chapter1: Introduction
Section: Chapter Questions
Problem 1PE
icon
Related questions
Question

Please extract this tabular form using the least cost method

Part 4-Network Problems(10)The U.S. government is auctioning off oil leases at two sites: 1 and 2. At each site, 100 000 acres of land are to be auctioned. Cliff Ewing, BlakeBarnes, and Alexis Pickens are bidding for the oil. Governmentrules state that no bidder can receive more than 40% of the land being auctioned. Cliff has bid $1,000/acre for site 1 land and $2,000/acre for site 2 land. Blake has bid $900/acre for site 1 land and $2,200/acre for site2 land. Alexis has bid $1,100/acrefor site 1 land and$1,900/acre for site 2 land.

Formulate a balanced transportation model to maximize the government’s revenue.

 

The tabular formulation of the Balanced TP is shown:
Cliff (1)
Blake (2)
Alexis (3)
Supply(s,)
Site 1
1000
900
1100
100000
Site 2
2000
2200
1900
100000
Dummy Supply Point
40000
Demand(d ,)
80000
80000
80000
Total=240000
Transcribed Image Text:The tabular formulation of the Balanced TP is shown: Cliff (1) Blake (2) Alexis (3) Supply(s,) Site 1 1000 900 1100 100000 Site 2 2000 2200 1900 100000 Dummy Supply Point 40000 Demand(d ,) 80000 80000 80000 Total=240000
Expert Solution
steps

Step by step

Solved in 2 steps with 1 images

Blurred answer
Knowledge Booster
Payback period
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, computer-science and related others by exploring similar questions and additional content below.
Similar questions
Recommended textbooks for you
Database System Concepts
Database System Concepts
Computer Science
ISBN:
9780078022159
Author:
Abraham Silberschatz Professor, Henry F. Korth, S. Sudarshan
Publisher:
McGraw-Hill Education
Starting Out with Python (4th Edition)
Starting Out with Python (4th Edition)
Computer Science
ISBN:
9780134444321
Author:
Tony Gaddis
Publisher:
PEARSON
Digital Fundamentals (11th Edition)
Digital Fundamentals (11th Edition)
Computer Science
ISBN:
9780132737968
Author:
Thomas L. Floyd
Publisher:
PEARSON
C How to Program (8th Edition)
C How to Program (8th Edition)
Computer Science
ISBN:
9780133976892
Author:
Paul J. Deitel, Harvey Deitel
Publisher:
PEARSON
Database Systems: Design, Implementation, & Manag…
Database Systems: Design, Implementation, & Manag…
Computer Science
ISBN:
9781337627900
Author:
Carlos Coronel, Steven Morris
Publisher:
Cengage Learning
Programmable Logic Controllers
Programmable Logic Controllers
Computer Science
ISBN:
9780073373843
Author:
Frank D. Petruzella
Publisher:
McGraw-Hill Education