Question: Please help me fill out this excel chart. This is the question: The Amorco Oil Company controls two oil fields. Field 1 can produce up

Please help me fill out this excel chart. This is the question:

The Amorco Oil Company controls two oil fields. Field 1 can produce up to 40 million barrels of oil per day, and field 2 can produce up to 50 million barrels of oil per day. At field 1 it costs $3 to extract and refine a barrel of oil; at field 2 the cost is $2. Amorco sells oil to two countries: United Kindom and Japan. The shipping costs per barrel are shown below. Each day the United Kingdom is willing to buy up to 40 million barrels at $6 per barrel, and Japan is willing to buy up to 30 million barrels at $6.50 per barrel. Determine how to maximize Amorco's profit. Please help me fill out this excel chart. This is the question: Please help me fill in this chart and determine profit. Include steps you took in excel and show the solver table.

1 Amorco Oil Company 3 4 5 Extracting, refining costs per barrel Field 1 Field 2 SE UNIT COST 7 Cost per barrel of shipping 9 Field 1 10 Field 2 $2 11 12 Selling price per barrel 13 14 15 Shipments (in millions of barrels) UK $3 Japan $8.50 UNIT SELLING PRICES PER REGION 16 UK Japan 17 Field 1 18 Field 2 19 Sum 21 Max demand D 4030 23 Summary of monetary values (in millions) 24 Extracting, refining cost 25 Shipping cost 28 Revenue Profit 1 Amorco Oil Company 3 4 5 Extracting, refining costs per barrel Field 1 Field 2 SE UNIT COST 7 Cost per barrel of shipping 9 Field 1 10 Field 2 $2 11 12 Selling price per barrel 13 14 15 Shipments (in millions of barrels) UK $3 Japan $8.50 UNIT SELLING PRICES PER REGION 16 UK Japan 17 Field 1 18 Field 2 19 Sum 21 Max demand D 4030 23 Summary of monetary values (in millions) 24 Extracting, refining cost 25 Shipping cost 28 Revenue Profit

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!

The Amorco Oil Company controls two oil fields. Field 1 can produce up to 22 million barrels of oil per day, and field 2 can produce up to 19 million barrels of oil per day. At field 1, it costs...

The Amorco Oil Company controls two oil fields. Field 1 can produce up to 20 million barrels of oil per day, and field 2 can produce up to 15 million barrels of oil per day. At field 1, it costs...

Please show all procedure Problem 2: The Ayatola Oil Company controls two oil fields. Field 1 can produce up to 40 million barrels of oil per day, and field 2 can produce up to 50 million barrels of...

PART A: Question 2 (10 marks) The Burak Oil Company controls two oil fields. Field 1 can produce up to 40 million barrels of oil per day, and field 2 can produce up to 50 million barrels of oil per...

The Burak Oil Company controls two oil fields. Field 1 can produce up to 40 million barrels of oil per day, and field 2 can produce up to 50 million barrels of oil per day. At field 1, it costs $3 to...

8 The Ayatola Oil Company controls two oil fields. Field 1 can produce up to 40 million barrels of oil per day, and field 2 can produce up to 50 million barrels of oil per day. At field 1, it costs...

The Amorco Oil Company controls two oil fields. Field 1 can produce up to 40 million barrels of oil per day, and field 2 can produce up to 50 million barrels of oil per day. At field 1, it costs...

Think of yourself as a consultant working for Midland Energy. This is the summary you send to the Board of Directors. Within the brief introductory paragraph answer the question in the introduction...

in order to answer the explain the questions refer to the article below (5 pt.) Explain why the market for WTI crude oil can be viewed as a "perfectly competitive market." How is the price of crude...

Remnant Carpet Company sells and installs commercial carpeting for office buildings. Remnant Carpet Company uses a job order cost system. When a prospective customer asks for a price quote on a job,...

Collins was trustee for Indolent under the will of Indolents father. Indolent, a middle-age doctor, gave little concern to the management of the trust fund, contenting himself with receiving the...

You are a trainee accountant in the final year of your SAICA training contract. You are the audit senior on the Travel - Wise Ltd audit. The company was incorporated and started trading on 1 June 2 0...

On 1 March 2007 DB Limited issued R560 000 15% debentures at R98. The debentures were to be redeemed at par in four equal annual payments starting 28 February 2010. Required: Journalise the above...