Please refer to the attached document to the changes that need to be made for this assignment. below are the requirements
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 an alternate investment, they are considering
increasing production at existing facilities.
In order to compare these investment opportunities, the head of the
Cost Analysis Department has tasked you with finding the profit
maximizing quantity and price if production continues at existing
facilities. You will then present this to the head of the department in a
meeting, along with supporting documentation such as cost curves, data
tables, and equations.
As a Cost Analyst at your firm, you are being asked to evaluate the
profit maximizing quantity and price for your product to submit to your
manager. Assume that your firm is a monopoly supplier of oil in your
region, due to extensive trade restrictions.
Another team member in the Cost Analysis Department has compiled the necessary data in the linked spreadsheet.
You will have to complete the missing columns for ATC, AVC, and MC. If
the company is incurring a profit, include the amount of the profit
earned when quantity and price are maximized. If your company is
incurring a loss, prove whether it should shut down or continue
operating at a loss. Use graphs and equations to support your argument.
You will create a short screen recording with narration arguing your
case to your manager. Create a PowerPoint presentation to support your
recommendation which can serve as the visuals for your recorded screen
There are many free screen recording software/Webware options
available (such as Screencast-O-Matic) to use in presenting your
PowerPoint. Make sure that both your voiced narration and the PowerPoint
slides are captured during your screen recording.
Be sure to include a cohesive introduction and conclusion of your
findings. Your body slides should include any relevant curves created in
Excel from the data spreadsheet.