Operations and Supply Chain Management (Mcgraw-hill Education)
Operations and Supply Chain Management (Mcgraw-hill Education)
15th Edition
ISBN: 9781259666100
Author: F. Robert Jacobs, Richard B Chase
Publisher: McGraw-Hill Education
bartleby

Concept explainers

Question
Book Icon
Chapter A, Problem 1OQ
Summary Introduction

To solve: The given problem using Excel Solver.

Expert Solution & Answer
Check Mark

Explanation of Solution

Given information:

Maximize Z=3X+YSubject to:12X+14Y853X+2Y18Y4

Solving using excel solver:

The solver add-in is selected under the data tab in Excel. The input is given shown below:

Excel input:

Operations and Supply Chain Management (Mcgraw-hill Education), Chapter A, Problem 1OQ , additional homework tip  1

Solver input:

The solver input is given as shown below:

Operations and Supply Chain Management (Mcgraw-hill Education), Chapter A, Problem 1OQ , additional homework tip  2

Formulas:

The formulas for the respective cells are given as shown below:

Operations and Supply Chain Management (Mcgraw-hill Education), Chapter A, Problem 1OQ , additional homework tip  3

Solver output:

After providing the necessary excel inputs, solver inputs, and necessary formulas, the solver is run to give the below output:

Operations and Supply Chain Management (Mcgraw-hill Education), Chapter A, Problem 1OQ , additional homework tip  4

Excel results:

X             = 6

Y             = 0

Maximum value     = 18

Want to see more full solutions like this?

Subscribe now to access step-by-step solutions to millions of textbook problems written by subject matter experts!
Knowledge Booster
Background pattern image
Operations Management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, operations-management and related others by exploring similar questions and additional content below.
Recommended textbooks for you
Text book image
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,
Text book image
Operations Management
Operations Management
ISBN:9781259667473
Author:William J Stevenson
Publisher:McGraw-Hill Education
Text book image
Operations and Supply Chain Management (Mcgraw-hi...
Operations Management
ISBN:9781259666100
Author:F. Robert Jacobs, Richard B Chase
Publisher:McGraw-Hill Education
Text book image
Business in Action
Operations Management
ISBN:9780135198100
Author:BOVEE
Publisher:PEARSON CO
Text book image
Purchasing and Supply Chain Management
Operations Management
ISBN:9781285869681
Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. Patterson
Publisher:Cengage Learning
Text book image
Production and Operations Analysis, Seventh Editi...
Operations Management
ISBN:9781478623069
Author:Steven Nahmias, Tava Lennon Olsen
Publisher:Waveland Press, Inc.