Question 4 - Which Microsoft Excel tool can be used to develop linear programming solutions?
Select XML expansion pack as your answer |
XML expansion pack |
Select Security macro as your answer |
Security macro |
Select Solver module as your answer |
Solver module |
Select Data analysis as your answer |
Data analysis |
Select The lookup wizard as your answer |
The lookup wizard |
Question 6 - Which term describes the additional amount a company will make if one more unit of a constrained resource is added?
Select Sensitivity value as your answer |
Sensitivity value |
Select Binding as your answer |
Binding |
Select Slack as your answer |
Slack |
Select Shadow price as your answer |
Shadow price |
Select Final value as your answer |
Final value |
Question 7 - In addition to decision-making games and model validation, discrete-event simulation can be used for what other purpose?
Select Cost evaluation as your answer |
Cost evaluation |
Select Model selection as your answer |
Model selection |
Select Company comparisons as your answer |
Company comparisons |
Select Process design as your answer |
Process design |
Select All of these options as your answer |
All of these options |
Question 8 - Which of the following is not a common application of a simulation?
Select Processing time for a banking facility. as your answer |
Processing time for a banking facility. |
Select Determining effective deployment of expensive resources. as your answer |
Determining effective deployment of expensive resources. |
Select Determining the flow of raw materials in a factory. as your answer |
Determining the flow of raw materials in a factory. |
Select Determining economic order quantity for inventory. as your answer |
Determining economic order quantity for inventory. |
Select Customer arrivals at a service location. as your answer |
Customer arrivals at a service location. |
Question 10 - What is the advantage of using spreadsheet-based simulation models?
Select The extensive amount of programming required as your answer |
The extensive amount of programming required |
Select The cost of the spreadsheet software as your answer |
The cost of the spreadsheet software |
Select The long length of time to run the simulation as your answer |
The long length of time to run the simulation |
Select The long length of time to develop the models as your answer |
The long length of time to develop the models |
Select All are advantages of using spreadsheet-based models as your answer |
All are advantages of using spreadsheet-based models |
Question 4 : Which Microsoft Excel tool can be used to develop linear programming solutions?
Answer: Solver module
In Microsoft excel, the solver module has the features which help to solve a formulated linear programming problem by entering necessary inputs of objective fuction and constraints
______________________________________________________________________________
Other questions have to be posted separately since they are not sub-parts
Question 4 - Which Microsoft Excel tool can be used to develop linear programming solutions? Select...