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

Medical Sciences
1.2K views

Goblet cells

Mechanical Engineering
1.2K views

In a heat treatment of a specific excavator bucket tooth of 15kg mass, the tooth is...

Biology
1.2K views

1 What continents were left untouched by European explorers 2 Which country was most interested...

Basic Math
1.2K views

The sides of a nuclear power plant cooling tower form a hyperbola. The diameter of...

Basic Math
1.2K views

Business plan is another term for strategic plan True False

Statistics
1.2K views

The number of observations greater than 16 52567 is closest to 0384 0128 0896 01152

Statistics
1.2K views

To help assess student learning in her developmental science courses a science professor at a...

Algebra
1.2K views

termine the number of solutions to the augmented trix 201 1 1 ct one a...

Accounting
1.2K views

Blossom Corporation incurred the following transactions. 1. Purchased raw materials on account $53,600. Raw materials...

Accounting
1.2K views

Assume that you are working in a chosen business as a Financial Accountant and start...

Accounting
1.2K views

Exercise 2-6 Pritano Company acquired all the net assets of Succo Company on December 31,...

Accounting
1.2K views

Gwynnie Pie Company makes dessert pies for national fast food chains. Gwynnie Pie Company is...