Question: Please clearly mention Decision Variables, Constraints and Objective Function. Also attach the excel using solver. Bharat oil manufactures three grades of gasoline (Regular, Premium, Super).

Please clearly mention Decision Variables, Constraints and Objective Function. Also attach the excel using solver. Bharat oil manufactures three grades of gasoline (Regular, Premium, Super). Each grade is produced by blending three types of crude

Please clearly mention Decision Variables, Constraints and Objective Function. Also attach the excel using solver.

Bharat oil manufactures three grades of gasoline (Regular, Premium, Super). Each grade is produced by blending three types of crude oil. Availability of crude oil is limited to 5000 barrels of each type of crude oil per day. The three types of gasoline differ in their octane rating and sulphur content as follows: The octane rating and the sulphur content of the three types of crude oil are as follows: Refining cost is $4 per barrel of gasoline and the refinery can produce up to 14,000 barrels of gasoline daily. Formulate an LP that will enable Bharat Oil to maximize its daily profits Bharat oil manufactures three grades of gasoline (Regular, Premium, Super). Each grade is produced by blending three types of crude oil. Availability of crude oil is limited to 5000 barrels of each type of crude oil per day. The three types of gasoline differ in their octane rating and sulphur content as follows: The octane rating and the sulphur content of the three types of crude oil are as follows: Refining cost is $4 per barrel of gasoline and the refinery can produce up to 14,000 barrels of gasoline daily. Formulate an LP that will enable Bharat Oil to maximize its daily profits

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer

Step: 1 Unlock blur-text-image

Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock

Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!

Note: Use excel solver to compute this using Simplex LP and share the steps and answer. Bharat oil manufactures three grades of gasoline (Regular, Premium, Super). Each grade is produced by blending...

Linear Programming (Statistics) 1. The Outdoor Furniture Corporation manufactures two products, benches and picnic tables, for use in yards and parks. The firm has two main resources: its carpenters...

I am looking for the solution or guidance with the following case study. The case study has been asked about by other students but I cannot find the solution. can you direct me to it or provide some...

MGMT 3115 EXAM 1 Cal State East Bay By completing and submitting the answer to the exam, the student fully understands the university's policy on academic dishonesty and agree to abide by this...

Sunco Oil manufactures three types of unleaded gasoline (super, premium, and regular). Each type pf gasoline is produced by blending together three types of drude oil (Crude 1, Crude 2, and Crude 3)....

Question 1 A CWD Oil produces two grades of gasoline: regular and premium. The profit contributions are $0.30 per gallon for regular gasoline and $0.50 per gallon for premium gasoline. Each gallon of...

Please do the excel solver clearly An Oil Company of Middle East has a refinery in Kuwait. This refinery has access to two types of crude oil that come from Wafra Field: Ratawi Crude and Eocene...

In the rest of this chapter, we lead the reader through the formulation of several more complicated linear programming models. The most important step in formulating an LP model is the proper choice...

please answer from 1 to five much appreciated This is a GROUP work, and every group should submit only one report. Please Submit your work in PDF format to Moodle before 18/NOV @23:59. This...

Linear Programming Applied Practice Solutions Problem 1: Finance- Allocation of Funds Madison Finance has a total of $ and auto loans. On the average, homeowner loans have a 10% yield a 12% annual...

Find the missing properties among (P, T, v, u, h) together with x if applicable and give the phase of the substance. a. R-22 T 10C, u 200 kJ/kg b. H2O T...

Based on current dividend yields and expected growth rates, the expected rates of return on stocks A and B are 11% and 14%, respectively. The beta of stock A is .8, while that of stock B is 1.5. The...

Income Statement Income Gross sales 57500 Sales returns and allowances 240000 Net sales 6660000 Cost of goods sold 2760000 Gross profit 3900000 Dividends received from stock investments in lessthan20...

last two options for the multiple choice are : performance management development A construction equipment manufacturer, Roswell Corporation, is focusing on becoming a leader in sustainability in...

Distinguish between filtering and interpreting. (Objective 2)

Interview four people.Ask each to identify the Top Fivepeople skills that make someone a good employee or a good supervisor. During a class discussion, combine your findings with those of other class...

Teamwork. Technology. Work with one other student in your class. Identify and arrange to attend a regularly scheduled meeting of some group (e.g., student organization, faculty/staff committee,...