Please help me answer the below question Using Excel Spreadsheet Only!! Please show all calculations and formula's. Screenshots of your work will be very helpful so I can double check the work. To ensure answers are accurate and correct. Shipping data in the question is shown below. Please let me know if you have any questions.

48. The Amorco Oil Company controls two oil fields.ht 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 $42.50 to extract and refine a barrel of oil; at field 2 the cost is $38.20. Amorco sells oil to two countries: United Kingdom and Japan. The shipping costs per barrel are shown in the file P05_48.xlsx. Each day, the United Kingdom is willing to buy up to 14 million barrels at $65.80 per barrel, and Japan is willing to buy up to 23 million bar- rels at $68.40 per barrel. Determine how to maximize Amorco's profit. work up on A Amorco data (P05_48.xlsx) Cost per barrel of shipping Field 1 Field 2 B U.K. Japan $4.80 $5.30 $5.70 $6.90