Attachment # 00011104 - profit_maximization_sheet__xlx.xlsx

profit_maximization_sheet__xlx.xlsx (44.64 KB)
Raw Preview of Attachment:
(refer to the detailed question and attachment below)
Price per barrelAdded cost to Cal:Additives PriceDaily quantity of barrels demanded (in millions)Daily quantity of barrels supplied (in millions)Profit MaximizationFederal gasoline taxTotal additionsTotal cost per gallonAnswer question 1 below.Answer question 2 below.Answer question 3 below.Gallons sold per dayFixed cost per dayRevenue (price x gallons)Answer question 5 below.Marginal revenue Marginal RevenueMarginal CostCost per gallonFixed CostTotal CostQuestion 1:Maryland state gasoline tax (Effective July 1, 2018)Distribution & DeliveryAdvertising and Marketing to ExxonMobilCost per GallonVariable Cost (cost per unit x volume)Variable CostQuantityAverage% changeElasticity of DemandElasticity:Total Cost (Fixed + Variable)By how much did revenues increase or decrease as a result of the change in price?By how much did profits increase or decline?Question 2:Q4.Demand for Crude OilDaily US demand for crude oil (in millions of barrels)Supply of Crude OilDaily US supply of crude oil (in millions of barrels)Daily Profit (revenue - all costs)Question 3:Price ElasticPrice InelasticUnit Price ElasticSelect OneBase price of unleaded regular delivered in New York harbor (October 21, 2019)The price per barrel and daily quantity intersects at point 107. therefore, the price and quantity at which equilibrium exists are: $80 and 107 million barrels.Based on the intersection points, the price equilibrium is $90 and the quantity equilibrium is 108 million barrels. YES

Question

Analyze Cost, Pricing, Elasticity, and the Production Function

Question # 00607849
Subject: Economics
Due on: 01/20/2020
Posted On: 01/18/2020 06:04 AM
Tutorials: 1
Rating:
4.9/5
Question Dot Image

I have done my best on the question. I only really need help with the profit maximation tab. and an executive summary based on the analysis base on the charts. I believe Q6 is where I'm getting confuse.  

 

Dot Image
Corrina Sirleaf Posted By :
Questions: 1 Tutorials: 0
Attachments

Tutorials for this Question

Analyze Cost, Pricing, Elasticity, and the Production Function

Tutorial # 00606557
Posted On: 01/18/2020 07:56 AM
Feedback Score: 100% (by 1 users)
Purchased By: 3
mac123
Posted By:
Questions:
426
Tutorials:
850
Report this Tutorial as Inappropriate
Tutorial Preview
The solution of Analyze Cost, Pricing, Elasticity, and the Production Function...