
Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Question
Answer I’m excell please

Transcribed Image Text:Problem 1 The R& D division of the Progressive company has been developing 4 possible
product lines. Management must make a decision on which of the 4 products will be produced and
at what levels to maximize the profit. The start-up cost and marginal revenue for each product is
given in the following table:
Product
1
3
Start-up cost
$50,000 $40,000 $70,000 $60,000
Marginal revenue
$ 70
$ 60
$ 90
$ 80
Let continuous variables x1, x2, X3, X4 be the production levels of product 1,2,3 and 4, respec-
tively, and let binary variables y1, Y2, Y3, Y4 control whether or not each product is produced at all.
Suppose the manager has imposed the following constraints:
• No more than two types of the products can be produced.
• If neither product 1 nor product 2 is produced, then neither product 3 nor product 4 can be
produced.
• Either 5x1 + 3.x2 + 6x3 + 4x4 < 6000 or 4x1 + 6x2 +3x3 +5x4 < 6000.
1. Formulate an integer programming model for the problem.
2. Solve this model in Excel or Python.
Expert Solution

This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
Step by stepSolved in 2 steps with 4 images

Knowledge Booster
Similar questions
- Question 1: _____ help to organize a field of study, identify key concepts, understand patterns and trends, and clarify research assumptions. A Ideas B Philosophies C Theoriesarrow_forwardTRUE/FALSE Questions: Statement True False All the below are forms of competition act: − price fixing − bid rigging − price discrimination − predatory pricing − double ticketing − resale price maintenance − bait and switch selling − pyramid selling ☐ ☐ Business slander means unfair and untrue written (oral) statement about a competitor ☐ ☐arrow_forwardPls answer fast i give up votearrow_forward
- When Amy helps to ensure fair and equitable treatment for her employees regardless of their personal background or circumstances, she is performing a(n) ________. Question 16 options: 1) strategic role. 2) tactical role. 3) administrative role. 4) employee advocate role.arrow_forwardC. Identify the Form of Business Organization being described. (a 1. Form of business organization with unlimited lives and the death or withdrawal of an owner does not affect its existence. 2. The establishment is generally an easy and inexpensive process. _3. The most important characteristic of this form of organization is always limited liability. 4. It involves a contractual agreement between all the partners that set the terms and conditions of their business relationship, including the distribution of ownership, responsibilities, and profits and losses. 5. This form of business organization generally enjoys fewer options to raise capital.arrow_forwardPls help ASAParrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
- Practical Management ScienceOperations ManagementISBN:9781337406659Author:WINSTON, Wayne L.Publisher:Cengage,Operations ManagementOperations ManagementISBN:9781259667473Author:William J StevensonPublisher:McGraw-Hill EducationOperations and Supply Chain Management (Mcgraw-hi...Operations ManagementISBN:9781259666100Author:F. Robert Jacobs, Richard B ChasePublisher:McGraw-Hill Education
- Purchasing and Supply Chain ManagementOperations ManagementISBN:9781285869681Author:Robert M. Monczka, Robert B. Handfield, Larry C. Giunipero, James L. PattersonPublisher:Cengage LearningProduction and Operations Analysis, Seventh Editi...Operations ManagementISBN:9781478623069Author:Steven Nahmias, Tava Lennon OlsenPublisher:Waveland Press, Inc.

Practical Management Science
Operations Management
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:Cengage,

Operations Management
Operations Management
ISBN:9781259667473
Author:William J Stevenson
Publisher:McGraw-Hill Education

Operations and Supply Chain Management (Mcgraw-hi...
Operations Management
ISBN:9781259666100
Author:F. Robert Jacobs, Richard B Chase
Publisher:McGraw-Hill Education


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

Production and Operations Analysis, Seventh Editi...
Operations Management
ISBN:9781478623069
Author:Steven Nahmias, Tava Lennon Olsen
Publisher:Waveland Press, Inc.