30 Jun Question Description I failed this assignment and my professor is givin
Question Description
I failed this assignment and my professor is giving me another chance to resubmit. I will provide the paper i submitted which has the grading rubric for a passing grade of what needs to be met. Please just re do the assignment and please use the excel sheet i will provide. I will also provide my professors comments which may help with the assignment. If you are not skilled in economics please don’t agree to submit this work. I need quality work for a passing grade.
Competencies
Understand economic terminology and economic definitions pertaining to decisions made by managers.
Explain and demonstrate knowledge of concepts including the supply/demand relationship, price ceilings and floors, and market surpluses and shortages.
Elasticity, consumer choice, utility, productivity, and nature of costs.
Demonstrate how economic theory contributes to strategic managerial decision-making.
Understand various market structures and impacts upon firms, consumers, and government policies.
Calculate profits and profit maximization in order to determine the optimal price and output at which firms should produce.
Course Scenario
Oil Company X is a large oil refinery which has been expanding and taking on new investment projects. Recently, they have considered building a pipeline that stretches across the United States, from Canada to New Orleans.
As a cost analyst at Oil Company X, submit a proposal to the board of the company critiquing the costs and benefits of building a new oil pipeline that stands to generate copious amounts of revenue. Include in your report the following: expected changes to supply and demand, a cost analysis of the project, the cross-price elasticity of an alternative energy source, cost curves, the new expected profit-maximizing quantity and price of oil after completion, a risk assessment evaluating liabilities from potential environmental damage, and a final recommendation.
Instructions
Use the Excel document below to complete the assignment
As an economic analyst at your firm, you are being asked to evaluate this investment opportunity and submit a 5-page proposal as a Word document.
You must include an explanation of expected changes to supply and/or demand from economic shocks such as natural disasters and recessions, as well as the anticipated effect of substitute goods (alternative energy sources) flooding the oil market. Be sure to include the expected impact on equilibrium quantity and price in your regional market from these potential changes.
Another team member in the Cost Analysis Department has compiled the necessary data in the attached spreadsheet below. The total upfront cost of this project is $10 million, with $1.72 million in fixed costs. Be sure to include in your proposal any relevant curves graphed from the data in the spreadsheet. Your Excel spreadsheet needs to include the following columns in addition to what has been given to you:
TFC
TVC
ATC
AVC
MC
Assume that your firm will hold market power as a supplier of oil in your region, due to extensive trade restrictions the government has agreed to put in place after completion of the pipeline. Define the new market structure, and give new pricing strategies the firm can use to maximize profits for this particular market structure.
You will also include graphs to show new expected profit-maximizing quantity and price of oil after completion. After determining the profit-maximizing price and quantity, as well as the corresponding average variable cost, determine the expected total profit for the 15-year duration the pipeline will be in operation.
Be sure to also include a calculation of the cross-price elasticity of the alternative energy source and oil. Assume the current price of oil is $50/gallon of crude oil. If the price increases to the profit-maximizing price, the quantity demanded of the alternative energy source increases by 20%. Explain if these goods are complementary goods, substitute goods, or non-related goods. If there is a relationship, indicate whether the relationship is weak or strong. Justify your answer with an explanation based on the elasticity figure.
Assume there is a 10% probability of the pipeline leaking, with an expected liability of $3.2 billion which will be deducted from total profit. There is a 90% probability the pipeline will not leak. Determine the expected return on this investment, as well as the variance.
The firm also has an alternative investment which will yield $1.6 billion over the course of the same 15-year period, with a probability of 80%, or $1.15 billion with a probability of 20%. Calculate the expected return, as well as the variance. The risk should be expressed as the standard deviation.
Perform a marginal analysis to determine if the firm should build the pipeline, considering currently available investments and opportunity costs.
Format your proposal to include a title page, introduction, conclusion, and references. Include all relevant graphs, equations, and calculations. Show your work on calculations to ensure you receive partial credit for incorrect answers. No credit will be given if your work is not shown. Remember to cite your sources using correct APA format, and also use correct grammar, spelling, and formatting.
Tags: supply chain
deliverble_7_spreadsheet__include_within_deliverable_for_students__2.xlsx
tasharacooperd7p2.docx
Unformatted Attachment Preview
PRICE 89 82.7 76.4 70.1 63.8 57.5 51.2 44.9 38.6 32.3 26 QUANTITY (in millions) 0 1 2 3 4 5 6 7 8 9 10 TOTAL REVENUE $0.00 $82.70 $152.80 $210.30 $255.20 $287.50 $307.20 $314.30 $308.80 $290.70 $260.00 MARGINAL REVENUE $0.00 $82.70 $70.10 $57.50 $44.90 $32.30 $19.70 $7.10 -$5.50 -$18.10 -$30.70 TOTAL COST (in millions) $1.72 $29.19 $59.11 $89.76 $121.15 $153.28 $186.13 $219.72 $254.05 $289.11 $324.90 TOTAL FIXED COST (in millions) TOTAL VARIABLE COST (in million) AVERAGE TOTAL COST AVERAGE VARIABLE COST MARGINAL COST MANAGEMENT OF COMPANY X Management of Company X Tashara Cooper Deliverable #7 2 MANAGEMENT OF COMPANY X Proponents for the Oil Company X, argue that it will allow the countries involved to increase their energy
Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.
About Writedemy
We are a professional paper writing website. If you have searched a question and bumped into our website just know you are in the right place to get help in your coursework. We offer HIGH QUALITY & PLAGIARISM FREE Papers.
How It Works
To make an Order you only need to click on “Order Now” and we will direct you to our Order Page. Fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.
Are there Discounts?
All new clients are eligible for 20% off in their first Order. Our payment method is safe and secure.