Exam 9: Building and Using Decision Models
Exam 1: Data and Business Decisions93 Questions
Exam 2: Descriptive Statistics and Data Analysis99 Questions
Exam 3: Probability Concepts and Distributions111 Questions
Exam 4: Sampling and Estimation123 Questions
Exam 5: Hypothesis Testing and Statistical Inference99 Questions
Exam 6: Regression Analysis93 Questions
Exam 7: Forecasting100 Questions
Exam 8: Introduction to Statistical Quality Control101 Questions
Exam 9: Building and Using Decision Models74 Questions
Exam 10: Decision Models With Uncertainty and Risk90 Questions
Exam 11: Decisions, uncertainty, and Risk100 Questions
Exam 12: Queues and Process Simulation Modeling97 Questions
Exam 13: Linear Optimization98 Questions
Exam 14: Integer, nonlinear, and Advanced Optimization Methods100 Questions
Select questions type
The following spreadsheet shows financial data for Trance Electronics.Use the spreadsheet to answer the question(s)below.
-In which year has Trance Electronics generated the highest profit?

(Multiple Choice)
4.8/5
(36)
Below is a spreadsheet designed to calculate the project completion time.Use the spreadsheet to answer the following question(s).
-What is the early start time for Activity M?

(Multiple Choice)
4.8/5
(40)
The following spreadsheet shows demand and booking data for Toretto Car Rentals.Use the spreadsheet to answer the question(s)below.
-What is the total number of reservations made?

(Multiple Choice)
4.8/5
(38)
The following spreadsheet shows a simple outsourcing decision model of a company that sells shoes.Use the spreadsheet to answer the question(s)below.
-How will the formula to calculate A16 be represented in B16?

(Multiple Choice)
4.9/5
(32)
The following spreadsheet shows financial data for Trance Electronics.Use the spreadsheet to answer the question(s)below.
-What is the quantity of sales generated in the third year?

(Multiple Choice)
4.8/5
(23)
The following spreadsheet illustrates a newsvendor model.Use the spreadsheet to answer the question(s)below.
-What is the surplus quantity of the product available?

(Multiple Choice)
4.7/5
(32)
Below is a spreadsheet designed to calculate the project completion time.Use the spreadsheet to answer the following question(s).
-What is the early finish time for Activity I?

(Multiple Choice)
4.8/5
(30)
The following spreadsheet shows financial data for Trance Electronics.Use the spreadsheet to answer the question(s)below.
-What is the size of the market in the second year?

(Multiple Choice)
4.8/5
(33)
Below is a spreadsheet designed to calculate the project completion time.Use the spreadsheet to answer the following question(s).
-What is the early finish time for Activity O?

(Multiple Choice)
4.8/5
(32)
The following spreadsheet shows the production and sales data for a particular product.Use the data to answer the question(s)below.
-How will the formula to calculate A10 be represented in B10?

(Multiple Choice)
4.7/5
(29)
Which of the following is considered an uncontrollable variable?
(Multiple Choice)
4.9/5
(46)
The following spreadsheet shows financial data for Trance Electronics.Use the spreadsheet to answer the question(s)below.
-What is the annual cost incurred at the end of the third year?

(Multiple Choice)
5.0/5
(33)
The following spreadsheet shows financial data for Trance Electronics.Use the spreadsheet to answer the question(s)below.
-What is the profit generated by the company at the end of the second year?

(Multiple Choice)
5.0/5
(31)
The following spreadsheet shows financial data for Trance Electronics.Use the spreadsheet to answer the question(s)below.
-What is the profit generated by the company at the end of the fourth year?

(Multiple Choice)
4.9/5
(38)
Excel includes an add-in called ________ to find optimal solutions to optimization problems formulated as spreadsheet models.
(Multiple Choice)
4.7/5
(39)
The following spreadsheet shows financial data for Trance Electronics.Use the spreadsheet to answer the question(s)below.
-What is the quantity of sales generated in the fifth year?

(Multiple Choice)
4.7/5
(32)
The following spreadsheet shows demand and booking data for Toretto Car Rentals.Use the spreadsheet to answer the question(s)below.
-How will the formula to calculate A18 be represented in B18?

(Multiple Choice)
4.9/5
(37)
Below is a spreadsheet designed to calculate the project completion time.Use the spreadsheet to answer the following question(s).
-What is the early start time for Activity F?

(Multiple Choice)
4.9/5
(34)
Showing 21 - 40 of 74
Filters
- Essay(0)
- Multiple Choice(0)
- Short Answer(0)
- True False(0)
- Matching(0)