Homework Help is Here – Start Your Trial Now!
Business
Operations Management
Lastly, you will need three constraints that show if SC, SR, or SP are 0, then the Available for Capacitor, Resistor, and Processors, is 0 le: Constraint Capacitor 159 160 Notice that the last column of 160 should be the 160 SC. Therefore if we don't use SC and it is zero, then the available will be O instead of 160. Parameter Capacitor Resister Processors Available Televisions 4 6 10 2,300 Computers 10 12 4 4,200 Microwaves 5 6 3 2,200 Available 160 210 50 Profit 2 3 25 -50 -250 Model Capacitor Resister Processors 159 194 50 Profit 1790 SC 1 -60 SR 1 SP 1

Lastly, you will need three constraints that show if SC, SR, or SP are 0, then the Available for Capacitor, Resistor, and Processors, is 0 le: Constraint Capacitor 159 160 Notice that the last column of 160 should be the 160 SC. Therefore if we don't use SC and it is zero, then the available will be O instead of 160. Parameter Capacitor Resister Processors Available Televisions 4 6 10 2,300 Computers 10 12 4 4,200 Microwaves 5 6 3 2,200 Available 160 210 50 Profit 2 3 25 -50 -250 Model Capacitor Resister Processors 159 194 50 Profit 1790 SC 1 -60 SR 1 SP 1

Practical Management Science
Practical Management Science
6th Edition
ISBN:9781337406659
Author:WINSTON, Wayne L.
Publisher:WINSTON, Wayne L.
Chapter2: Introduction To Spreadsheet Modeling
Section: Chapter Questions
Problem 20P: Julie James is opening a lemonade stand. She believes the fixed cost per week of running the stand...
See similar textbooks
icon
Related questions
Question
Your Manufacturing company has been tasked with building Televisions, computers, and microwaves. To make these products, there are three sub components: Capacitors, Resistors, and Processors. Below shows the maximum number of Televisions, computers, and microwaves we can make along with the maximum number of capacitors, resistors, and processors available to make them. Your Revenue function is determined as $2 for every capacitor used, $3 for every resistor, and $25 for each processor. However, there are FIXED costs if you decide to use the these. If you use Capacitors, it will have a fixed cost of $50, Resistors will have a fixed cost of $60, and Processors have a fixed cost of $250. The total profit is Revenue - Cost. Objective: Determine how many Capacitors, resisters, and processors to use in order to maximize profit. You will also need to capture if you choose to use Capacitors (SC), Resistors (SR), and Processors (SP). (NOTE: The profit is made up of 6 numbers: First three for Revenue and last three for cost, thus why they are negative) Also, note SC, SR, SP are 1 or 0, so you will need to add a constraint in the solver for "BIN" instead of > or <just like you did Integer. Lastly, you will need three constraints that show if SC, SR, or SP are 0, then the Available for Capacitor, Resistor, and Processors, is 0 le: Constraint Capacitor 159 160
Transcribed Image Text:Your Manufacturing company has been tasked with building Televisions, computers, and microwaves. To make these products, there are three sub components: Capacitors, Resistors, and Processors. Below shows the maximum number of Televisions, computers, and microwaves we can make along with the maximum number of capacitors, resistors, and processors available to make them. Your Revenue function is determined as $2 for every capacitor used, $3 for every resistor, and $25 for each processor. However, there are FIXED costs if you decide to use the these. If you use Capacitors, it will have a fixed cost of $50, Resistors will have a fixed cost of $60, and Processors have a fixed cost of $250. The total profit is Revenue - Cost. Objective: Determine how many Capacitors, resisters, and processors to use in order to maximize profit. You will also need to capture if you choose to use Capacitors (SC), Resistors (SR), and Processors (SP). (NOTE: The profit is made up of 6 numbers: First three for Revenue and last three for cost, thus why they are negative) Also, note SC, SR, SP are 1 or 0, so you will need to add a constraint in the solver for "BIN" instead of > or <just like you did Integer. Lastly, you will need three constraints that show if SC, SR, or SP are 0, then the Available for Capacitor, Resistor, and Processors, is 0 le: Constraint Capacitor 159 160
Lastly, you will need three constraints that show if SC, SR, or SP are 0, then the Available for Capacitor, Resistor, and Processors, is 0 le: Constraint Capacitor 159 160 Notice that the last column of 160 should be the 160* SC. Therefore if we don't use SC and it is zero, then the available will be 0 instead of 160. Parameter Capacitor Resister Processors Available Televisions 4 6 10 2,300 Computers 10 12 4 4,200 Microwaves 5 6 3 2,200 Available 160 210 Profit 2 -250 3 -50 Model Capacitor Resister 159 194 Profit 1790 50 25 Processors 50 SC 1 -60 SR 1 SP 1
Transcribed Image Text:Lastly, you will need three constraints that show if SC, SR, or SP are 0, then the Available for Capacitor, Resistor, and Processors, is 0 le: Constraint Capacitor 159 160 Notice that the last column of 160 should be the 160* SC. Therefore if we don't use SC and it is zero, then the available will be 0 instead of 160. Parameter Capacitor Resister Processors Available Televisions 4 6 10 2,300 Computers 10 12 4 4,200 Microwaves 5 6 3 2,200 Available 160 210 Profit 2 -250 3 -50 Model Capacitor Resister 159 194 Profit 1790 50 25 Processors 50 SC 1 -60 SR 1 SP 1
Expert Solution
steps

Step by step

Solved in 2 steps with 3 images

SEE SOLUTIONCheck out a sample Q&A here
Blurred answer
Similar questions
Recommended textbooks for you
Practical Management Science
Practical Management Science
Operations Management
ISBN:
9781337406659
Author:
WINSTON, Wayne L.
Publisher:
Cengage,
Operations Management
Operations Management
Operations Management
ISBN:
9781259667473
Author:
William J Stevenson
Publisher:
McGraw-Hill Education
Operations and Supply Chain Management (Mcgraw-hi…
Operations and Supply Chain Management (Mcgraw-hi…
Operations Management
ISBN:
9781259666100
Author:
F. Robert Jacobs, Richard B Chase
Publisher:
McGraw-Hill Education
Business in Action
Business in Action
Operations Management
ISBN:
9780135198100
Author:
BOVEE
Publisher:
PEARSON CO
Purchasing and Supply Chain Management
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…
Production and Operations Analysis, Seventh Editi…
Operations Management
ISBN:
9781478623069
Author:
Steven Nahmias, Tava Lennon Olsen
Publisher:
Waveland Press, Inc.
SEE MORE TEXTBOOKS