Our neighbouring country, Indonesia, has opened up its crude oil refinery industry by inviting private investors...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Our neighbouring country, Indonesia, has opened up its crude oil refinery industry by inviting private investors to start a private oil refinery business. Your company, Sing O&G, which has oil refinery operations experience in other countries, has tasked you with the task of analysing the refinery operations in view of the different constraints and profits. Sing O&G received its crude oil in four different grades (Grade 1, 2, 3 and 4, where Grade 1 is the highest and most valuable grade) where each grade differs from each other in terms of its physical characteristics and chemical compositions. Sing O&G purchased its supply of crude oil from the Indonesian government where the maximum allowable monthly supply of Grade 1, Grade 2, Grade 3 and Grade 4 crude oil is 5,000, 7,000, 8,000 and 10,000 barrels, respectively. Crude oil needs to be processed before it can be used. Three major types of operation are performed to refine the crude oil into finished products (i.e., oil products): Separation, Conversion and Treating. Sing O&G can sell the refined oil products at any of the 3 stages, where the profit is dependent on the grade of the raw (or unrefined) crude oil and refining stage at which it is sold. Crude oil of a higher grade would require lesser energy to be refined, hence this translates into a higher net profit which is shown in Table 2-1. Table 2-1: Net Profit ($/barrel) of Refined Oil Products Sold at Each Refining Stage by Grade Refining Stages* Crude Oil Grade Grade 1 Grade 2 Grade 3 Grade 4 Separation 8 7 Conversion 11 10 9. Treating * We shall assume that there is no loss in the refining stage (i.e., 100% conversion from crude oil to refined oil products) 12 11 9 8 Due to contractual commitment, Sing O&G is required to supply at least 4,000 barrels of refined oil per month after the Separation stage. Also, the management has adopted a policy where the amount of refined oil sold (in barrels) after the Separation stage is limited to a quarter of the total amount of crude oil purchased for that month. Determine an LP model to maximise your profit. Discuss any two (2) assumptions, pertaining to the case, to be made prior to analysing the business case. (a) (23 marks) (b) Solve the LP problem by using Microsoft Excel. (16 marks) Due to climate change, countries around the world are increasing its effort in reducing carbon footprint through various measures. Comment on how the possible measures undertaken by the government to reduce consumption of treated refined oil (final refine stage of crude oil after undergoing the three stages) could affect your original solutions based on Excel Sensitivity Report. (c) (8 marks) Our neighbouring country, Indonesia, has opened up its crude oil refinery industry by inviting private investors to start a private oil refinery business. Your company, Sing O&G, which has oil refinery operations experience in other countries, has tasked you with the task of analysing the refinery operations in view of the different constraints and profits. Sing O&G received its crude oil in four different grades (Grade 1, 2, 3 and 4, where Grade 1 is the highest and most valuable grade) where each grade differs from each other in terms of its physical characteristics and chemical compositions. Sing O&G purchased its supply of crude oil from the Indonesian government where the maximum allowable monthly supply of Grade 1, Grade 2, Grade 3 and Grade 4 crude oil is 5,000, 7,000, 8,000 and 10,000 barrels, respectively. Crude oil needs to be processed before it can be used. Three major types of operation are performed to refine the crude oil into finished products (i.e., oil products): Separation, Conversion and Treating. Sing O&G can sell the refined oil products at any of the 3 stages, where the profit is dependent on the grade of the raw (or unrefined) crude oil and refining stage at which it is sold. Crude oil of a higher grade would require lesser energy to be refined, hence this translates into a higher net profit which is shown in Table 2-1. Table 2-1: Net Profit ($/barrel) of Refined Oil Products Sold at Each Refining Stage by Grade Refining Stages* Crude Oil Grade Grade 1 Grade 2 Grade 3 Grade 4 Separation 8 7 Conversion 11 10 9. Treating * We shall assume that there is no loss in the refining stage (i.e., 100% conversion from crude oil to refined oil products) 12 11 9 8 Due to contractual commitment, Sing O&G is required to supply at least 4,000 barrels of refined oil per month after the Separation stage. Also, the management has adopted a policy where the amount of refined oil sold (in barrels) after the Separation stage is limited to a quarter of the total amount of crude oil purchased for that month. Determine an LP model to maximise your profit. Discuss any two (2) assumptions, pertaining to the case, to be made prior to analysing the business case. (a) (23 marks) (b) Solve the LP problem by using Microsoft Excel. (16 marks) Due to climate change, countries around the world are increasing its effort in reducing carbon footprint through various measures. Comment on how the possible measures undertaken by the government to reduce consumption of treated refined oil (final refine stage of crude oil after undergoing the three stages) could affect your original solutions based on Excel Sensitivity Report. (c) (8 marks)
Expert Answer:
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Pretend that you have been charged with the task of redesigning the interface for the ATM at your local bank. Develop two use scenarios for it.
-
Pretend that you have been charged with the task of redesigning the interface for the ATM at your local bank. Develop an interface standard that includes metaphors, objects, actions, icons, and a...
-
Pretend that you have been charged with the task of redesigning the interface for the ATM at your local bank. What type of prototyping and interface evaluation approach would you recommend?
-
A taxpayer has qualified business income of $50,000 from partnership A and a qualified business loss of $30,000 from partnership B. Wages allocable to the taxpayers interest in partnership A were...
-
Financial advisers often contend that elderly people should invest their portfolios more conservatively than younger people. Should a conservative investment policy for an elderly person call for...
-
Using the expression for the expected marginal product of capital, MPK e = 3.6/K t+1 , plot the MPK e curve and determine the desired level of capital for the next period (measured in trillions) if...
-
Soles Ltd sells two types of shoes, sandals and sneakers. During the financial year ended 30 June 2025, fixed costs were \($230\) 400 and sales were in the ratio of three units (pairs) of sandals to...
-
Read the PCAOB enforcement case against Christopher E. Anderson (PCAOB Release No. 105-2008-003, available at www.pcaob.org). Among the PCAOB's findings is that the audit partner, Anderson, changed...
-
Primare Corporation has provided the following data concerning last month's manufacturing operations. Purchases of raw materials Indirect materials used in production Direct labor Manufacturing...
-
2. The Global Tea and Organic Juice companies have merged. The following information has been collected for the "Consolidation Project." Chapter 7 Managing Risk 245 Activity Description Predecessor a...
-
Find, sketch, and label the convolutions r(t)*r(t) and r(t)* (r(2-t)). The signal r(t) is sketched below. z(t) 0 1 2 x(2-t) 0 2 1
-
A 0.240 m radius, the 570-turn coil is rotated one-fourth of a revolution in 3.45 ms, originally having its plane perpendicular to a uniform magnetic field. Find the magnetic field strength needed to...
-
What intricate mechanisms underpin the compliance infrastructure within the healthcare sector, synergizing the imperatives of patient confidentiality, data security, and regulatory adherence to...
-
The Digby's balance sheet has $ 1 0 3 , 7 5 0 , 0 0 0 in equity. Further, the company is expecting $ 3 , 0 0 0 , 0 0 0 in net income next year. Assuming no dividends are paid and no stock is issued,...
-
Required to read minimum of THREE ( 3 ) ( 3 ) journals, articles or research papers and write a review paper about Information security in organisation . . In the review paper, should include:...
-
Whirly Corporation s contribution format income statement for the most recent month is shown below: Total Per Unit Sales ( 8 , 1 0 0 units ) $ 2 5 1 , 1 0 0 $ 3 1 . 0 0 Variable expenses 1 6 2 , 0 0...
-
You work for an environmental agency and residents of a rural area have occasionally seen what they think is a cougar in nearby farmers' fields. You have been asked to investigate the area and see if...
-
The Taylor's series expansion for cosx about x = 0 is given by: where x is in radians. Write a user-defined function that determines cosx using Taylor's series expansion. For function name and...
-
Find the optimal value of the objective function for the following problem by inspecting only its dual. (Do not solve the dual by the simplex method.) Minimize z = 10x1 + 4x2 + 5x3 Subject to 5x1 -...
-
A simplified rule based on the individual changes D1, D2,..., and Dm in the right - hand side of the constraints can be used to test whether or not simultaneous changes will maintain the feasibility...
-
Solve the following problems by B&B. Maximize z = 18x1 + 14x1 + 8x3 + 4x4 subject to 15x1 + 12x2 + 7x3 + 4x4 + x5 37 x1, x2, x3, x4, x5 = (0, 1)
-
What services does an underwriter provide for a company that employs the underwriter to facilitate going public? What factors influence an issuing firms choice of underwriter?
-
Explain why harvesting is an important consideration when the initial decision to invest in a venture is made. How might harvesting be factored into the deal structure and the valuation? Provide...
-
What makes a venture a social venture?
Study smarter with the SolutionInn App