Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics
7th Edition
ISBN: 9781285418681
Author: Cliff Ragsdale
Publisher: Cengage Learning
bartleby

Concept explainers

Question
Book Icon
Chapter 4, Problem 21QP
Summary Introduction

To determine: The sensitivity report using solver.

a)

Summary Introduction

To determine: Whether the optimal solution is unique.

b)

Summary Introduction

To determine: The location that receives the fewest cars.

c)

Summary Introduction

To determine: The increase in the cost for the company for the given information.

d)

Summary Introduction

To determine: The impact the given information would have on the optimal objective function value.

Blurred answer
Students have asked these similar questions
Using the grid technique to determine the least-cost location (warehouse) for this problem:    Tons Rate X - Coordinates Y – Coordinates S1 200 0.5 2 14 S2 300 0.6 6 10 M1 100 1 2 2 M2 100 2 10 14 M3 100 1 14 18 M4 100 2 14 6 The Grid center coordination is ____ and _____ (round the results to 1 decimal place)  Group of answer choices (9.9; 7.8) (5.5; 6.9) (8.7; 10.5) (10.5; 6.4) (9.9; 8.9)
Please answer:  b) Using a computer software for solving​ LP, the objective value at the optimal solution                                     Minimum number of total miles traveled​ (objective ​value)equals= ​(round your response to a whole​ number).
A fertilizer manufacturer has to fulfill supply contracts to its two main customers (650 tons to Customer A and 800 tons to Customer B). It can meet this demand by shipping existing inventory from any of its three warehouses. Warehouse 1 has 400 tons of inventory onhand, Warehouse 2 (W2) has 500 tons, and Warehouse 3 (W3) has 600 tons. The company would like to arrange the shipping for the lowest cost possible, where the per-ton transit costs are as follows: W 1 W 2 W 3 $7.50 $6.75 $6.25 $7.00 $6.50 $8.00 Customer A Customer B Write the objective function and the constraint in equations. Let V;= tons shipped to customer i from warehouse j, and so on. For example, VA1 = tons shipped to customer A from warehouse W1. This exercise contains only parts b, c, d, e, and f. b) The objective function for the LP model = Minimize Z = $7.50 + $6.25 + $6.50 (shipping cost to customer A) V + $6.75 + $7.00 + $8.00 (shipping cost to customer B) c) Subject to: Customer A's demand Customer B's demand…

Chapter 4 Solutions

Spreadsheet Modeling and Decision Analysis: A Practical Introduction to Business Analytics

Knowledge Booster
Background pattern image
Management
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, management and related others by exploring similar questions and additional content below.
Similar questions
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,