A company manufactures mechanical heart valves from the heart valves of pigs. Different heart operations require valves of different sizes. The company purchases pig valves from three different suppliers. The cost and size mix of the valves purchased from each supplier are given in the file P03_36.xlsx. This file also contains the maximum number of valves available from each supplier per month. Each month, the company places an order with each supplier. At least 1300 large, 900 medium, and 400 small valves must be purchased each month. a. Use Solver to determine how the company can minimize the cost of acquiring the needed valves. b. Use SolverTable to investigate the effect on total cost of increasing its minimal purchase requirements each month. Specifically, see how the total cost changes as the minimal purchase requirements of large, medium, and small valves all increase from their original values by the same percentage. Revise your model so that SolverTable can be used to investigate these changes when the percentage increase varies from 2% to 40% in increments of 2%.

BuyFind

Practical Management Science

6th Edition
WINSTON + 1 other
Publisher: Cengage,
ISBN: 9781337406659
BuyFind

Practical Management Science

6th Edition
WINSTON + 1 other
Publisher: Cengage,
ISBN: 9781337406659

Solutions

Chapter
Section
Chapter 3, Problem 36P
Textbook Problem

A company manufactures mechanical heart valves from the heart valves of pigs. Different heart operations require valves of different sizes. The company purchases pig valves from three different suppliers. The cost and size mix of the valves purchased from each supplier are given in the file P03_36.xlsx. This file also contains the maximum number of valves available from each supplier per month. Each month, the company places an order with each supplier. At least 1300 large, 900 medium, and 400 small valves must be purchased each month.

  1. a. Use Solver to determine how the company can minimize the cost of acquiring the needed valves.
  2. b. Use SolverTable to investigate the effect on total cost of increasing its minimal purchase requirements each month. Specifically, see how the total cost changes as the minimal purchase requirements of large, medium, and small valves all increase from their original values by the same percentage. Revise your model so that SolverTable can be used to investigate these changes when the percentage increase varies from 2% to 40% in increments of 2%.

Expert Solution

Want to see the full answer?

Check out a sample textbook solution.

Want to see this answer and more?

Experts are waiting 24/7 to provide step-by-step solutions in as fast as 30 minutes!*

*Response times vary by subject and question complexity. Median response time is 34 minutes and may be longer for new subjects.

Chapter 3 Solutions

Practical Management Science
Ch. 3.7 - The PC Tech company assembles and then tests two...Ch. 3.7 - The PC Tech company assembles and then tests two...Ch. 3.7 - The PC Tech company assembles and then tests two...Ch. 3.7 - The PC Tech company assembles and then tests two...Ch. 3.7 - The PC Tech company assembles and then tests two...Ch. 3.7 - The PC Tech company assembles and then tests two...Ch. 3.7 - The PC Tech company assembles and then tests two...Ch. 3.8 - The Pigskin Company produces footballs. Pigskin...Ch. 3.8 - The Pigskin Company produces footballs. Pigskin...Ch. 3.8 - The Pigskin Company produces footballs. Pigskin...Ch. 3.8 - In one modification of the Pigskin problem, the...Ch. 3.8 - Modify the Pigskin spreadsheet model so that...Ch. 3.8 - Modify the Pigskin spreadsheet model so that...Ch. 3.8 - Modify the Pigskin spreadsheet model in the...Ch. 3 - A chemical company manufactures three chemicals:...Ch. 3 - A furniture company manufactures desks and chairs....Ch. 3 - A farmer owns 450 acres of land. He is going to...Ch. 3 - During the next four months, a customer requires,...Ch. 3 - A company faces the following demands during the...Ch. 3 - Maggie Stewart loves desserts, but due to weight...Ch. 3 - For a telephone survey, a marketing research group...Ch. 3 - A furniture company manufactures tables and...Ch. 3 - A manufacturing company makes two products. Each...Ch. 3 - There are three factories on the Momiss River....Ch. 3 - A company manufactures two types of trucks. Each...Ch. 3 - A company manufactures mechanical heart valves...Ch. 3 - A company that builds sailboats wants to determine...Ch. 3 - A company manufactures two products on two...Ch. 3 - A textile company produces shirts and pants. Each...Ch. 3 - Each year, a shoe manufacturing company faces...Ch. 3 - A small appliance manufacturer must meet (on time)...Ch. 3 - A pharmaceutical company manufactures two drugs at...Ch. 3 - In any optimization model such as those in this...Ch. 3 - Suppose you use Solver to find the optimal...Ch. 3 - Consider an optimization model with a number of...Ch. 3 - If you add a constraint to an optimization model,...Ch. 3 - Why is it generally necessary to add nonnegativity...Ch. 3 - Suppose you have a linear optimization model where...Ch. 3 - In a typical product mix model, where a company...Ch. 3 - In a typical product mix model, where a company...Ch. 3 - In a typical production scheduling model like...Ch. 3 - In a production scheduling problem like Pigskins,...Ch. 3 - Shelby Shelving is a small company that...

Additional Business Textbook Solutions

Find more solutions based on key concepts
What are the main purposes of internal controls over cash receipts?

College Accounting, Chapters 1-27 (New in Accounting from Heintz and Parry)

Why do economists make assumptions?

Principles of Microeconomics (MindTap Course List)

Why do firms use event sponsorship?

Foundations of Business (MindTap Course List)

Why isnt a credit card money?

Economics (MindTap Course List)

RESIDUAL DIVIDEND MODEL Welch Company is considering three independent projects, each of which requires a 5 mil...

Fundamentals of Financial Management, Concise Edition (with Thomson ONE - Business School Edition, 1 term (6 months) Printed Access Card) (MindTap Course List)

List and describe four determinants of a countrys productivity.

Principles of Macroeconomics (MindTap Course List)

If the variable cost per unit goes down,

Managerial Accounting: The Cornerstone of Business Decision-Making