
Practical Management Science
6th Edition
ISBN: 9781337406659
Author: WINSTON, Wayne L.
Publisher: Cengage,
expand_more
expand_more
format_list_bulleted
Question
thumb_up100%
To graduate from Pace University with a major in operations research (OR), a student must complete at least two math courses, at least two OR courses, and at least two computer courses.
Some courses can be used to fulfill more than one requirement:
- Calculus can fulfill the math requirement
- Operations Research can fulfill the math and OR requirements
- Data Structures can fulfill the computer and math requirements
- Business Statistics can fulfill the math and OR requirements
- Computer Simulation can fulfill the OR and computer requirements
- Introduction to Computer Programming can fulfill the computer requirement
Forecasting can fulfill the OR and math requirements.
Complete this template (show all formulas) and use Solver to minimize the number of courses needed to satisfy the major requirements (there could be multiple optimal solutions). Please also paste any Solver window used as well - thanks!
I will also attach a screenshot of the excel template for convinience and to help replicate.
Inputs (requirements) | Calculus | OR | Data Structure | Bus Stats | Simulation | Intro Comp Prog | Forecasting |
OR | 0 | 1 | 0 | 1 | 1 | 0 | 1 |
Math | 1 | 1 | 1 | 1 | 0 | 0 | 1 |
Computer | 0 | 0 | 1 | 0 | 1 | 1 | 0 |
Constraints: number of courses | ||
Needs to be filled in | ≥ | Needs to be filled in |
Needs to be filled in | ≥ | Needs to be filled in |
Needs to be filled in | ≥ | Needs to be filled in |
Decision Variables (binary) | ||||||
Courses Taken | Needs to be filled in | Needs to be filled in | Needs to be filled in | Needs to be filled in | Needs to be filled in | Needs to be filled in |
Objective = Minimize Output | |
# courses taken (Solution) |
Needs to be filled in |

Transcribed Image Text:A
1 Pace University
2
B
C
Calculus
0
1
0
D
OR
1
1
0
E
Data Structure
0
1
1
F
Bus Stats
1
1
0
G
Simulation
1
0
1
3 Inputs (requirements)
4 OR
5 Math
6 Computer
7
8 Decision Variables (binary)
9 Courses taken
10
11 Objective = Minimize Output
12 # courses taken
13
14
15
16
17
18 Some courses can be used to fulfill more than one requirement: Calculus can fulfill the math requirement; Operations Research can fulfill the math and OR requirements;
19 Data Structures can fulfill the computer and math requirements; Business Statistics can fulfill the math and OR requirements; Computer Simulation can fulfill the OR and
20 computer requirements; Introduction to Computer Programming can fulfill the computer requirement; and Forecasting can fulfill the OR and math requirements. Note that
21 this information has already been entered in the Template's inputs (green cells).
22
H
Intro Comp Prog
0
0
1
I
Forecasting
1
1
0
J
K
L
Constraints: number of courses
≤
<
<
To graduate from Pace University with a major in operations research (OR), a student must complete at least two math courses, at least two OR courses, and at least two
computer courses.
23
24 Complete this template and use Solver to minimize the number of courses needed to satisfy the major requirements (there could be multiple optimal solutions).
25
Expert Solution

arrow_forward
Step 1
Given requirement-
Step by stepSolved in 2 steps with 3 images

Knowledge Booster
Similar questions
- Please make a comment on the following statement. There are many business applications with linear functions and non-linear functions. Some people think that linear models are particularly of interest due to simplicity and convenience, but some people believe that nonlinear models can simulate business operations better in practice, enabling business professionals to make more accurate decision.arrow_forwardYou have graduated from Holmes Institute with your Master of Professional Accounting degree. You are working for an accounting firm, and a client has made an appointment to see you about setting up a business. The client tells you that he is thinking about opening his own computer support business and running his business on his own from his house so that the customers can bring their laptop or PC's to his premises and then repair it. He also tells you that he is thinking about buying into a franchise called IT Support, and he asks you for advice about what is a franchise and is it a good idea? Your task is to give the client advice on what types of business structures, including franchises, would be best suitable for him. In your answer, you must provide advantages and disadvantages for each of the business structures you have suggested to him.arrow_forward- Once answered correctly will UPVOTE!!arrow_forward
- Functions are used to map elements from one set to another. For example, barcode and QR scanner systems are developed by programmers to use specific symbologies to map the pattern in the barcode to actual digits. The check digit or the final digit is used to determine whether the function is true (known good) or false (errors in the mapping occurred). RFID system developers also use functions to develop a pairing protocol that securely connects legitimate devices within a specific proximity. RFIDs are using in logistics, retail, warehousing, and more.arrow_forwardThe typical number of elective credit hours that are required to earn a bachelors degree isarrow_forwardYou are supposed to find the gross requirements for all of them.arrow_forward
- Consider the following short case as you respond to the question:Abruzzi's Italian Kitchen is a small family restaurant with an administrative staff of four people. Giuseppi Abruzzi is the chief executive officer; his wife Maria is the chief financial officer. Their son Antonio is responsible for all transactions dealing with kitchen supplies, including the raw materials for menu items; their son Carlo is responsible for all transactions dealing with dining room supplies, such as eating utensils. The restaurant's administrative practices have developed over the ten years of its existence with minimal reliance on information technology and formal procedures and a stronger emphasis on interpersonal relationships with a few reliable vendors. Once a month, Antonio places orders for kitchen supplies with one of four vendors based on price; the supplies are usually received within ten calendar days. On receipt of the supplies, Antonio pays the vendor with a company check. Carlo follows a…arrow_forwardThere are two companies manufacturing drones. Company A manufactures mass market drones, while company B manufactures customised drones according to customers’ requirements. In 2020, company A produces 3,200 drones, 3% of which were found to be defective and cannot pass the quality check. Company A employs 5 workers working an average of 8 hours a day in the drone production, and they worked 200 working days in 2020.In contrast, company B produces 900 drones, 10% of which were found to be defective and cannot pass the quality check. Company B employs 3 workers working an average of 6 hours a day in the drone production, and they worked 170 days in 2020. (a) If the drone manufacturing is seen as a process, what is considered as the output of the production processes of companies A and B and why? (b) Measure the single-factor manpower productivity for the two companies. (c) Is it reasonable to compare the manpower productivity of the two companies and reach a conclusion that one company…arrow_forwardFinancial analysis should be used as an input to decision making, not as the decision-making process. True or Falsearrow_forward
- 1– Please complete all work in excel. Use excel to make the calculations (cells can be clicked on to view any formulas used) and be sure to identify your answer, including units. You must have an excel file with formulas within the cell. 2. Gas & Go is considering offering movie rentals through a self-service company that would locate a machine on the inside of the market store. BlueBox would charge an annual lease fee of $500 for delivery, setup and maintenance, and there is an energy cost of $0.08 for every video rented. GreenFilms would charge an annual lease of only $400, but the energy cost for every video rental is $0.10 due to the larger size of the machine. Customers rent each movie for $1.00, regardless of the company, and the Gas & Go would earn 30% of that revenue for each rental. a. At what volume in number of rental transactions would the two options have the same cost?arrow_forwardRisk management is a fundamental practice within organizations aimed at identifying, assessing, and mitigating potential risks that could impact operations, finances, or reputation. In today's dynamic business environment, organizations face a myriad of risks, including market volatility, regulatory changes, cybersecurity threats, and natural disasters. Effective risk management Involves a systematic approach to evaluating risks, prioritizing them based on their likelihood and potential impact, and implementing strategies to manage or mitigate them. This often includes implementing policies, procedures, and controls to minimize exposure to risks, as well as transferring risk through insurance or other risk-sharing mechanisms. Additionally, organizations Invest in risk monitoring and surveillance systems to detect emerging risks and take proactive measures to address them before they escalate. Moreover, risk management encompasses fostering a risk-aware culture within the organization,…arrow_forwardWhich answer is an example of an experimental study? A researcher asks all the students in a classroom to answer questions about whether they would attempt a difficult math problem if they were promised a candy bar for correctly solving it. The researcher keeps track of students' answers. A researcher attends a math class and watches and records how many students attempt the difficult problems assigned in class. A researcher asks two groups of students to solve a difficult math problem. One of the groups is told that members will receive a candy bar after correctly solving the problem. The other group is not told this. The researcher keeps track of how long people attempt to solve the math problem. A researcher asks a sample of the students in a classroom to answer questions about how long they would attempt to solve a difficult math problem if they were promised a candy bar for correctly solving it. The researcher keeps track of students' answers.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
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.