Loading...

Messages

Proposals

Stuck in your homework and missing deadline? Get urgent help in $10/Page with 24 hours deadline

Get Urgent Writing Help In Your Essays, Assignments, Homeworks, Dissertation, Thesis Or Coursework & Achieve A+ Grades.

Privacy Guaranteed - 100% Plagiarism Free Writing - Free Turnitin Report - Professional And Experienced Writers - 24/7 Online Support

Excel solver how many subproblems

06/10/2021 Client: muhammad11 Deadline: 2 Day

(8 points) M&D Chemicals produces two products that are sold as raw materials to companies manufacturing bath soaps and laundry detergents. Let A=number of gallons of product A B=number of gallons of product B M&D’s objective is to satisfy all requirements at a minimum total cost. Production costs are $2 per gallon for product A and $3 per gallon for product B. The objective function together with the constraints is given below:

Objective function:

Min 2A+3B

Subject to (s.t)

1A >= 125 Demand for product A

1A + 1B >= 350 Total production

2A + 1B <= 600 Processing time

A >= 0 and B >= 0

Excel Solver was used to product the outputs below.Using the above outputs,

(a) (2 points) What are the optimal values of the decision variables?

(b) (2 points) What is the value of the optimal solution?

(c)(2 points) Which constraint(s) has a slack variable?

(d) (2 points)Which constraint(s) has a surplus and what is the value(s) of the surplus?

M&D Chemicals Available Operation Demand for A Total production Processing time cost per gallon 1 1 2 0 125 350 Model Decision Variables Number Produced 250 100 minimum total cost 800 Used(LHS) Available(RHS) Contraints Demand for A Total production Processing time 250 350 125 350
Microsoft Excel 15.0 Answer Report Worksheet: [M&D Chemical Example.xlsx]Sheetl Report Created: 8/30/2016 3:48:44 PM Result: Solver found a solution. All Constraints and optimality conditions are satisfied. Solver Engine Engine: Simplex LP Solution Time: 0 Seconds Iterations: 3 Subproblems: 0 Solver Options Max Time Unlimited, Iterations Unlimited, Precision 0.000001, Use Automatic Scaling Max Subproblems Unlimited, Max Integer Sols Unlimited, Integer Tolerance 1%, Assume NonNegative Objective Cell (Min) Cell SB$17 minimum total costA Name Original Value 0 Final Value 800 Variable Cells Cell SB$15 Number Produced A SC$15 Number Produced B Name Original Value Final Value Integer 0 0 250 Contin 100 Contin Constraints Cell ŞB$21 Demand for A Used(LHS) ŞB$22 Total production Used(LHS) ŞB$23 Processing time Used(LHS) Cell Value Status Slack 250 ŚB$21>-SD$21 Not Binding 125 0 0 Name Formula 350 $B$22>-SD$22 Binding 600 $B$23

Homework is Completed By:

Writer Writer Name Amount Client Comments & Rating
Instant Homework Helper

ONLINE

Instant Homework Helper

$36

She helped me in last minute in a very reasonable price. She is a lifesaver, I got A+ grade in my homework, I will surely hire her again for my next assignments, Thumbs Up!

Order & Get This Solution Within 3 Hours in $25/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 3 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 6 Hours in $20/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 6 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

Order & Get This Solution Within 12 Hours in $15/Page

Custom Original Solution And Get A+ Grades

  • 100% Plagiarism Free
  • Proper APA/MLA/Harvard Referencing
  • Delivery in 12 Hours After Placing Order
  • Free Turnitin Report
  • Unlimited Revisions
  • Privacy Guaranteed

6 writers have sent their proposals to do this homework:

ECFX Market
Accounting & Finance Master
Chartered Accountant
Isabella K.
Homework Tutor
Academic Mentor
Writer Writer Name Offer Chat
ECFX Market

ONLINE

ECFX Market

Hello, I an ranked top 10 freelancers in academic and contents writing. I can write and updated your personal statement with great quality and free of plagiarism

$46 Chat With Writer
Accounting & Finance Master

ONLINE

Accounting & Finance Master

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$37 Chat With Writer
Chartered Accountant

ONLINE

Chartered Accountant

I will cover all the points which you have mentioned in your project details.

$42 Chat With Writer
Isabella K.

ONLINE

Isabella K.

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$29 Chat With Writer
Homework Tutor

ONLINE

Homework Tutor

I will cover all the points which you have mentioned in your project details.

$40 Chat With Writer
Academic Mentor

ONLINE

Academic Mentor

I am known as Unrivaled Quality, Written to Standard, providing Plagiarism-free woork, and Always on Time

$39 Chat With Writer

Let our expert academic writers to help you in achieving a+ grades in your homework, assignment, quiz or exam.

Similar Homework Questions

Catching fire how cooking made us human sparknotes - Operations management chapter 5 answers - Hips feel good dove case study analysis - Workplace Environment Assessment - C06I Assignment 4 - ECO/535: ECO/535: - Camping in bunyip state park - Belfast to comber bus - What is a caption in a nonfiction book - A rose for emily summary shmoop - The general's favorite fishing hole answers - Merlin gerin multi 9 c60h - Pharmacotherapy for Cardiovascular Disorders - Aviation risk assessment form - Criminological theory context and consequences 7th edition - Chan v zacharia 1984 154 clr 178 - Use the following data to calculate the current ratio - My phoenix edu forward apply - Are banks obliged to follow the rba cash rate - Asci 490 capstone project - Linear algebra problems and solutions pdf - A primer on communication studies v 1.0 - Aqua dragons fully grown - Fama's llamas has a weighted average - Is muhammad ali dead yahoo answers - What account normally has a credit balance - Dq tomorrow - What are the four causes of the great depression - When did charlemagne die - List three approaches to message authentication - After dinner speeches have the primary general purpose to - 3 8 13 18 - Power Point Presentation - Does kroger sell ping pong balls - Macbeth observation interpretation and critique - Suosituimmat soittoäänet juuri nyt - Skip hire ealing council - Hydrochloric acid and phenolphthalein - Aztec science achievements - Risk management of coca cola company - Albrecht's research on stress in the workplace - Blue bay model child protection policy - Mushrooms sylvia plath analysis - ASAP - Jackson jackson what you pawn i will redeem character analysis - Common fallacies in advertising - Penetration test proposal deliverable 1 rules of engagement - Busiest network adapter is less than 15 - Context of the longest memory - Igcse biology reproduction past papers - Why is my mousetrap car not moving - Aquarium industries pty ltd - History Assignment - Empirical formula of sodium carbonate - Humanistic psychology emphasizes the importance of - Relationships between web analytics text mining and sentiment analysis - Bill of materials in construction - Ucas tv personal statement - Display design in hci - Determine the height d of cable ab - University of rhode island change assessment urica - Assignment 2 – Develop Research Problem Statement and Design - Is forcible touching a registerable offense - 10 strategic points grand canyon university - Paraphrasing exercises for kids - Julilly underground to canada - Zooper dooper ice blocks nz - Multi causal model of addiction - Bmo financial group diversity scholarships - Warm up parsing strings java - Gender schema theory ppt - 197 lacey street whyalla - Output voltage of cfl bulb - Self assessment paper for psychology - Family crucible summary - How to write like the 1920s - The proverbs tell us how to live life successfully - Advantages and disadvantages of break even analysis - Kenworth motors case study answers - Maternal newborn nursing case studies - SOLER - 3711 san gabriel mission tx 78572 - Derivative of 4e x 2 - Mailbox magazine companion preschool april may 2010 learning centers - Common language runtime support - Final Exam - Progressive paper - Valuing people now summary - Communication in Organizations - A kg trampoline artist jumps upward - Briefly describe fasb iasb convergence process - Evaluation of ncf 2005 - Saint anselm ontological argument - Taco bell case study harvard - 3D Due by the Time you agree on if not I don’t want the work - Retail Marketing - How to calculate total factor productivity in excel - On january boston enterprises issues bonds - 'Received $400,000 in cash from Tom Maudi and issued common stock to him. - Polytec ofv 5000 manual