Logo
Home Study Material Contact Search
AI Chat FREE
  1. business
  2. accounting
  3. please solve this by excel solver, please do it yo

Please solve this by excel solver, please do it yourslef and do not paste any...

70.2K

Verified Solution

Question

Accounting

image

Please solve this by excel solver, please do it yourslef and do not paste any other wrong answers

Problem 2 [30 points]: An oil company produces three brands of oils: Regular, Multigrade, and Supreme. Each brand of oil is composed of one or more of four crude stocks, each having a different viscosity index. The relevant data concerning the crude stocks are: Crude Stock 1 Viscosity Index 20 2 40 Cost ($/barrel) 7.10 8.50 7.70 9.00 Supply Per Day (barrels) 1,000 1,100 1,200 1,100 3 30 55 4 Each brand of oil must meet a minimum standard for viscosity index, and each brand sells at a different price. The relevant data concerning the three brands of oil are: Brand Minimum Selling price Daily Maximum Sales Viscosity Index ($/barrel) (barrels) Regular 25 8.50 2,000 Multigrade 30 9.00 1,500 Supreme 50 10.00 800 a) Define the decision variables and write down the detailed mathematical formulation of the oil company's problem to maximize its total profit for a single day. [15 points] b) Solve the optimization problem by Excel Solver. Write down the company's optimal production plan and optimal total profit. [15 points]

Answer & Explanation Solved by verified expert
Get Answers to Unlimited Questions

Join us to gain access to millions of questions and expert answers. Enjoy exclusive benefits tailored just for you!

Membership Benefits:
  • Unlimited Question Access with detailed Answers
  • Zin AI - 3 Million Words
  • 10 Dall-E 3 Images
  • 20 Plot Generations
  • Conversation with Dialogue Memory
  • No Ads, Ever!
  • Access to Our Best AI Platform: Flex AI - Your personal assistant for all your inquiries!
Become a Member

Other questions asked by students

Basic Math
1.2K views

Read the passage provided, and then consider the following scenario. A physician is trying to decide...

Operations Management
1.2K views

Affluence, sustainability, globalization, communications, and brands are the five strategic driving forces of CSR? for each...

Electrical Engineering
1.2K views

11. Write a user oriented MATLAB program that will calculate the capacitance of the capacitor connected...

Biology
1.2K views

Which statement best describes the potential effect of genetic drift in the peripheral isolate model...

Algebra
1.2K views

What is the solution set for the following equation 6 x x O 1 23...

Algebra
1.2K views

alculate the distance between the points H 3 2 and L 2 1 in the...

Accounting
1.2K views

Prepare journal entries to record each of the following transactions of a merchandising company. The...

Accounting
1.2K views

Blossom Co. issued 100000 shares of $10 par common stock for $1220000. A year later...

Accounting
1.2K views

Hi there! Can someone help me answer these questions! It is Due tonight 11/12!! I...

Accounting
1.2K views

Delta Company produces a single product. The cost of producing and selling a single unit...

Accounting
1.2K views

Which of the following is not a disciplinary proceedings under Circular 230 A: Administrative Law...

Accounting
1.2K views

Ayayai Corporation has one temporary difference at the end of 2020 that will reverse and...