NEW
Font size
WorksheetsOptimization Techniques Quiz
Total questions: 48
Worksheet time: 24mins
Ananya is planning to optimize her weekly budget for groceries using Linear Programming. She knows that to achieve the best results, her budget must adhere to certain principles. Which of the following principles does she need to consider?
Proportionality
Additivity
Divisibility
All of the above
Tisha is planning to start a new business and needs to decide how to allocate her resources effectively. In her business plan, she identifies an objective function that represents her:
Constraints
Optimization goal
Feasible region
None
Arnav is planning a community garden and wants to ensure that his design is practical. A feasible garden design must satisfy:
All constraints
Only non-negativity
Only objective function
None
In a community garden, Kabir and Siya are planting their vegetables. If their planting rows intersect at the point (2,3), this point is:
A feasible solution
A BFS
Both (a) and (b)
None
Anika is trying to plan a community event, but after reviewing the venue options and the number of attendees, she realizes that there are no suitable locations that can accommodate everyone. If Anika has no feasible venue options, the problem is:
Unbounded
Infeasible
Multiple solution
Degenerate
In a maximization LPP, a company is trying to determine the optimal production levels of two products to maximize its profit. The company uses Solver’s “Simplex LP” method because:
It handles non-linearity
It handles linear constraints
It is faster for binary models
None
In a manufacturing company, Naira is trying to maximize the profit from producing two products. She finds that the profit line is parallel to the feasible region of production limits. What does this indicate about her production options?
No solution
Unique
Multiple optimal
Unbounded
Eshaan is using Excel Solver to optimize his business's production schedule. He needs to determine the best way to allocate resources to maximize profits. Which of the following is NOT required for him to set up in Excel Solver?
Objective cell
Variable cells
Constraints
Pivot Table
In a project management scenario, Arnav is trying to allocate resources to different tasks. However, he encounters a message stating, "Solver could not find feasible solution." What does this mean?
Unbounded
Infeasible
Degenerate
Multiple
Alisha is trying to maximize her profit from selling handmade crafts. She realizes that her profit becomes unbounded when:
No intersection
Feasible region is closed
Objective has no upper limit
Variables are integers
In a factory, Saisha is trying to minimize the cost of production. She adjusts the production levels to find the most cost-effective solution. As she analyzes the cost graph, she notices that the objective line:
Moves upward
Moves downward
Stays fixed
Random
Mira is working on a project that requires optimization using Solver. She needs to add constraints to her model to ensure it meets specific requirements. To add constraints in Solver, she should use:
Add Constraint
Load Model
GRG Nonlinear
Assume Linear
In a project management meeting, the team discusses the outcomes of their recent optimization efforts. They realize that the alternate solver solutions indicate:
Infeasible
Multiple optimal
Unbounded
Unique
Aarush is managing a delivery service where he needs to ensure that the number of packages he has to deliver matches the number of packages requested by customers. This situation is referred to as balanced transportation. What does balanced transportation mean in this context?
Supply = demand
Supply < demand
Supply > demand
Supply = 0
In a logistics company, Naira is tasked with distributing goods to various locations. However, she notices that the supply of goods does not match the demand at some locations, leading to an unbalanced transportation problem. To resolve this issue, how can Naira balance the transportation?
Adding dummy row/column
Deleting row
Changing costs
None
Avani is managing a logistics company and needs to optimize the transportation of goods using Excel. She wonders how to approach this problem effectively.
Simplex directly
Solver with constraints
Pivot tables
Power Query
In a factory, Neha is tasked with assigning workers to different machines to maximize efficiency. This assignment problem is a special case of:
LPP
Balanced transportation
Unbalanced transportation
Simplex method
In a factory, the manager needs to allocate tasks to workers for a project. The tasks can be assigned in different ways based on the requirements:
Fractional
Integer
Binary (0/1)
Continuous
If two assignments give the same cost:
Infeasible
Multiple optimal solutions
Unbounded
Degenerate
In a project management scenario, Tisha is tasked with allocating resources to different tasks while adhering to specific constraints. She needs to determine which type of assignment constraints to use:
Integer
Binary
GRG
Evolutionary
In a factory, there are more machines than jobs available. To ensure that all machines are utilized effectively, the manager decides to balance the assignment of jobs to machines. Unbalanced assignment is balanced by:
Adding dummy job/machine
Subtract rows
Multiply costs
Delete row
In a logistics company, Eshaan is trying to optimize the delivery routes for his fleet of trucks. He notices that the allocations of goods to be delivered are less than the required number of routes available. This situation is referred to as degeneracy in transportation. When does this occur?
Allocations < m+n–1
= m+n–1
> m+n–1
Costs are negative
In a city where all taxi fares are the same regardless of distance:
Any feasible solution is optimal
Infeasible
Incomplete
Unbounded
Aashi is considering investing in a new business venture. She wants to evaluate the potential outcomes of her investment. To do this, she calculates the Expected Monetary Value (EMV) of her investment options. EMV is defined as:
Sum of payoffs
Σ (Payoff × Probability)
Sum of probabilities
Payoff – probability
Aarav is considering investing in a new business venture. He wants to determine the value of perfect information before making his decision. He knows that the expected value of perfect information (EVPI) is calculated as:
Best – worst
EV with perfect information – EMV
EMV – uncertainty
None
Aashi is considering investing in a new startup. She has researched the market and found that there are various outcomes based on different scenarios. She knows the probabilities of success and failure based on past data. In this context, Decision under risk uses:
No probabilities
Known probabilities
Unknown probabilities
Conflict only
In a project management meeting, Aanya presents a decision tree to illustrate the various paths the team can take for their upcoming product launch. The branches of the tree represent:
Decision & chance outcomes
LPP constraints
Regression
Inventory
Maximum EVPI occurs when:
All states equal
Decision irrelevant
No prior information
Perfect info changes choice
In a competitive business environment, Myra and Neha are trying to decide on the best strategy to launch their new product. They realize that their decisions may conflict due to differing opinions on market trends and customer preferences. Conflict in decision making is studied in:
PERT
Game Theory
Simulation
Regression
Aarush, a risk-averse decision maker, prefers:
High variance
Low variance
Zero cost
Max EMV
Ria is analyzing different investment options in Excel to determine the best choice for her savings. She is using decision tree analysis to evaluate the expected monetary value (EMV) of each option. In Excel, decision tree analysis uses:
SUMPRODUCT (mainly for EMV)
If
Solver
Correlation
In a business decision-making scenario, Avani is evaluating different investment options for her startup. She wants to minimize potential losses while maximizing her returns. Which option should she choose to achieve the minimum expected opportunity loss (EOL)?
Highest EMV
Lowest regret
Highest regret
Lowest payoff
Tisha is considering an investment opportunity that has different outcomes based on market conditions. She wants to determine the expected value (EV) of her investment under certainty. What does EV under certainty equal?
Max payoff
Best payoff per state (weighted by perfect info)
Zero
Negative
In a competitive game of poker, the total amount of money won by one player is equal to the total amount lost by the other players. This situation is known as a:
Gains + losses = 0
Both win
Positive payoff
None
Aarush and Dhruv are playing a game where they have to choose strategies to maximize their payoffs. A saddle point exists in their game when:
Minimax = Maximin
Payoffs negative
Only 2×2
None of the above
In a competitive market, two companies, Company A and Company B, are deciding on their pricing strategies. Pure strategy exists when:
No saddle
Saddle point exists
Players mix
Cooperate
Asher is analyzing a game theory matrix to determine the best strategies for his team in a competitive game. He needs to evaluate the matrix using:
MIN & MAX functions in Excel
Solver
Lookup
Countifs
In a business meeting, the team is discussing strategies for a new project. If no clear direction or consensus (saddle) exists among the team members, the strategy used is:
Pure
Mixed
Neither
Both
Shaan is managing a project that involves multiple tasks, and he needs to estimate the time required for each task. He decides to use a method that provides a fixed time estimate for each task based on historical data. What method is Shaan using?
Probabilistic times
Deterministic times
Random
Exponential
In a project management meeting, Akhil is explaining how to estimate project timelines using PERT. He mentions that PERT uses:
Pessimistic, Critical, Float
Optimistic, Most Likely, Pessimistic
Min, Max, Avg
Normal, Crash, Expected
In a construction project, Myra is managing the schedule and needs to identify the critical path to ensure timely completion. She realizes that the critical path is the path with:
Shortest
Maximum float
Zero float
Aarush is managing a project with several tasks that have specific deadlines. He discovers that some tasks can be delayed without affecting the overall project duration. This flexibility is known as slack (float). What does slack (float) mean in this context?
Allowable delay without affecting duration
Extra cost
Waiting time
None
In a project management scenario, Kiara is calculating the expected time to complete a task using the PERT method. She knows the optimistic time (O), the most likely time (M), and the pessimistic time (P) for the task. What formula should she use to find the expected time?
(O + 4M + P) / 6
(O+M+P)/3
(O+2M+P)/4
O×M×P
Krish is working on a project that involves a highly intricate system with numerous variables and interactions. He realizes that the problem is too complex for an analytical model to provide a clear solution. In this situation, he considers using simulation. When is simulation typically used?
Problem too complex for analytical model
Only linear models exist
Costs zero
Probabilities unknown
In a financial analysis meeting, Alisha is explaining how Monte Carlo simulation can be used to predict the potential outcomes of an investment. She emphasizes the importance of using:
Random numbers
Pivot
Solver
Simplex
Aditi is working on a financial report in Excel and needs to generate random numbers for her analysis. She wonders which functions she can use to achieve this.
RAND()
RANDBETWEEN()
Both
None
In a scientific experiment, Krish is conducting a series of trials to test the accuracy of a new simulation model. He wonders how the number of trials affects the accuracy of his simulation. He thinks about the following:
Trials increase
Trials decrease
Random numbers reduce
None
Eshaan is working on a project that involves predicting the outcome of a complex financial investment. He knows that the first step in Monte Carlo Simulation is crucial for the success of his analysis.
Interpret
Define problem and model
Generate numbers
Run Solver
