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

Offered Price $40.00

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
Corrina Sirleaf
Posted By:
Questions:
1
Tutorials:
0
Feedback Score:

Purchase it
Report this Question as Inappropriate
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.  

 

Attachments

Tutorials for this Question

Available for
$40.00

Analyze Cost, Pricing, Elasticity, and the Production Function

Tutorial # 00606557
Posted On: 01/18/2020 07:56 AM
Feedback Score: 100% (by 1 users)
Puchased By: 3
mac123
Posted By:
Questions:
216
Tutorials:
485
Feedback Score:
Report this Tutorial as Inappropriate
Tutorial Preview …Prxdxctxxn xxxxxxxx xnxlyzx…
* - Additional Paypal / Transaction Handling Fee (5% of Tutorial price + $0.30) applicable
Loading...