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 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