Question 1

What is the maximum number of variables that the Excel Scenario Manager can handle?

Accepted Answer

A) 32 
B) 24 
C) 48 
D) 40 
A) 32 
B) 24 
C) 48 
D) 40 A

Question 2

The following spreadsheet shows financial data for Trance Electronics.Use the spreadsheet to answer the question(s)below.  
-In which year has the company generated the lowest profit?

Accepted Answer

A) fifth year 
B) second year 
C) third year 
D) first year 
A) fifth year 
B) second year 
C) third year 
D) first year D

Question 3

Below is a spreadsheet designed to calculate the project completion time.Use the spreadsheet to answer the following question(s).  
-What is the latest finish time for Activity M?

Accepted Answer

A) 115 
B) 110 
C) 105 
D) 113 
A) 115 
B) 110 
C) 105 
D) 113 D

Question 4

Below is a spreadsheet designed to calculate the project completion time.Use the spreadsheet to answer the following question(s).  
-Which of the following formulas is used to compute the slack for an activity?

Accepted Answer

A) latest start - activity time 
B) latest finish - early finish 
C) latest finish - activity time 
D) latest start - early start 
A) latest start - activity time 
B) latest finish - early finish 
C) latest finish - activity time 
D) latest start - early start

Question 5

What is the employee contribution at the age of 33?

Accepted Answer

A) $6,375 
B) $4,764 
C) $8,049 
D) $5,353 
A) $6,375 
B) $4,764 
C) $8,049 
D) $5,353

Question 6

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 A17 be represented in B17?

Accepted Answer

A) B10 ∗ B14 
B) B6 + B10 ∗ B14 
C) B7 ∗ B14 
D) B6 + B7 ∗ B14 
A) B10 ∗ B14 
B) B6 + B10 ∗ B14 
C) B7 ∗ B14 
D) B6 + B7 ∗ B14

Question 7

Below is a spreadsheet designed to calculate the project completion time.Use the spreadsheet to answer the following question(s).  
-What is the project completion time?

Accepted Answer

A) 135 
B) 142 
C) 131 
D) 110 
A) 135 
B) 142 
C) 131 
D) 110

Question 8

Below is a spreadsheet designed to calculate the project completion time.Use the spreadsheet to answer the following question(s).  
-What is the latest finish time for Activity I?

Accepted Answer

A) 76 
B) 110 
C) 84 
D) 105 
A) 76 
B) 110 
C) 84 
D) 105

Question 9

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 first year?

Accepted Answer

A) $463,454,784 
B) $324,000,000 
C) $554,291,922 
D) $387,504,000 
A) $463,454,784 
B) $324,000,000 
C) $554,291,922 
D) $387,504,000

Question 10

The following spreadsheet shows financial data for Trance Electronics.Use the spreadsheet to answer the question(s)below.  
-What is Trance Electronics' market share in the third year?

Accepted Answer

A) 15.74% 
B) 11.90% 
C) 10.35% 
D) 13.69% 
A) 15.74% 
B) 11.90% 
C) 10.35% 
D) 13.69%

Question 11

Which of the following functions defines phenomena that increase at a specific rate?

Accepted Answer

A) linear function 
B) polynomial function 
C) power function 
D) logarithmic function 
A) linear function 
B) polynomial function 
C) power function 
D) logarithmic function

Question 12

The following spreadsheet shows a simple outsourcing decision model of a company that sells shoes.Use the spreadsheet to answer the question(s)below.  
-What is the total outsourcing cost incurred by the company?

Accepted Answer

A) $525,000 
B) $675,000 
C) $600,000 
D) $450,000 
A) $525,000 
B) $675,000 
C) $600,000 
D) $450,000

Question 13

The following spreadsheet shows financial data for Trance Electronics.Use the spreadsheet to answer the question(s)below.  
-What is the total revenue generated at the end of the second year?

Accepted Answer

A) $1,330,300,612 
B) $1,112,291,482 
C) $930,009,600 
D) $777,600,000 
A) $1,330,300,612 
B) $1,112,291,482 
C) $930,009,600 
D) $777,600,000

Question 14

What is the employer contribution at the age of 27?

Accepted Answer

A) $1,438 
B) $1,925 
C) $2,292 
D) $1,280 
A) $1,438 
B) $1,925 
C) $2,292 
D) $1,280

Question 15

The following spreadsheet shows the production and sales data for a particular product.Use the data to answer the question(s)below.  
-What is the total cost of the product?

Accepted Answer

A) $7,320,000 
B) $4,580,000 
C) $3,600,000 
D) $12,030,000 
A) $7,320,000 
B) $4,580,000 
C) $3,600,000 
D) $12,030,000

Question 16

In an outsourcing decision model,the total purchased cost is the product of the unit cost of outsourcing and demand volume.

Accepted Answer

A) True 
 B)False

Question 17

Which of the following best defines heuristics?

Accepted Answer

A) They are data charts that evaluate an output variable over a range of values for two different input variables. 
B) They are sets of values that are saved and substituted automatically on the worksheet. 
C) They are limitations,requirements,or other restrictions that are imposed on any solution. 
D) They are solution procedures that generally find good solutions without guarantees of finding an optimal solution. 
A) They are data charts that evaluate an output variable over a range of values for two different input variables. 
B) They are sets of values that are saved and substituted automatically on the worksheet. 
C) They are limitations,requirements,or other restrictions that are imposed on any solution. 
D) They are solution procedures that generally find good solutions without guarantees of finding an optimal solution.

Question 18

The following spreadsheet shows the production and sales data for a particular product.Use the data to answer the question(s)below.  
-What is the total revenue generated by the product?

Accepted Answer

A) $7,320,000 
B) $4,860,000 
C) $12,000,000 
D) $3,600,000 
A) $7,320,000 
B) $4,860,000 
C) $12,000,000 
D) $3,600,000

Question 19

The following spreadsheet shows financial data for Trance Electronics.Use the spreadsheet to answer the question(s)below.  
-What is the cumulative net profit generated at the end of the third year?

Accepted Answer

A) $(696,400,000) 
B) $(494,942,298) 
C) $1,270,950,988 
D) $153,894,400 
A) $(696,400,000) 
B) $(494,942,298) 
C) $1,270,950,988 
D) $153,894,400

Question 20

The following spreadsheet shows financial data for Trance Electronics.Use the spreadsheet to answer the question(s)below.  
-What is the net present value of the company?

Accepted Answer

A) $975,567,800 
B) $3,867,334,190 
C) $1,700,178,021 
D) $2,246,145,678 
A) $975,567,800 
B) $3,867,334,190 
C) $1,700,178,021 
D) $2,246,145,678

What is the maximum number of variables that the Excel Scenario Manager can handle?

The following spreadsheet shows financial data for Trance Electronics.Use the spreadsheet to answer the question(s)below. -In which year has the company generated the lowest profit?

Below is a spreadsheet designed to calculate the project completion time.Use the spreadsheet to answer the following question(s). -What is the latest finish time for Activity M?

Below is a spreadsheet designed to calculate the project completion time.Use the spreadsheet to answer the following question(s). -Which of the following formulas is used to compute the slack for an activity?

What is the employee contribution at the age of 33?

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 A17 be represented in B17?

Below is a spreadsheet designed to calculate the project completion time.Use the spreadsheet to answer the following question(s). -What is the project completion time?

Below is a spreadsheet designed to calculate the project completion time.Use the spreadsheet to answer the following question(s). -What is the latest finish time for Activity I?

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 first year?

The following spreadsheet shows financial data for Trance Electronics.Use the spreadsheet to answer the question(s)below. -What is Trance Electronics' market share in the third year?

Which of the following functions defines phenomena that increase at a specific rate?

The following spreadsheet shows a simple outsourcing decision model of a company that sells shoes.Use the spreadsheet to answer the question(s)below. -What is the total outsourcing cost incurred by the company?

The following spreadsheet shows financial data for Trance Electronics.Use the spreadsheet to answer the question(s)below. -What is the total revenue generated at the end of the second year?

What is the employer contribution at the age of 27?

The following spreadsheet shows the production and sales data for a particular product.Use the data to answer the question(s)below. -What is the total cost of the product?

In an outsourcing decision model,the total purchased cost is the product of the unit cost of outsourcing and demand volume.

Which of the following best defines heuristics?

The following spreadsheet shows the production and sales data for a particular product.Use the data to answer the question(s)below. -What is the total revenue generated by the product?

The following spreadsheet shows financial data for Trance Electronics.Use the spreadsheet to answer the question(s)below. -What is the cumulative net profit generated at the end of the third year?

The following spreadsheet shows financial data for Trance Electronics.Use the spreadsheet to answer the question(s)below. -What is the net present value of the company?

Data and Business Decisions

Descriptive Statistics and Data Analysis

Probability Concepts and Distributions

Sampling and Estimation

Hypothesis Testing and Statistical Inference

Regression Analysis

Forecasting

Introduction to Statistical Quality Control

Decision Models With Uncertainty and Risk

Decisions, uncertainty, and Risk

Queues and Process Simulation Modeling

Linear Optimization

Integer, nonlinear, and Advanced Optimization Methods

Filters

Exam 9: Building and Using Decision Models

What is the maximum number of variables that the Excel Scenario Manager can handle?

The following spreadsheet shows financial data for Trance Electronics.Use the spreadsheet to answer the question(s)below. -In which year has the company generated the lowest profit?

Below is a spreadsheet designed to calculate the project completion time.Use the spreadsheet to answer the following question(s). -What is the latest finish time for Activity M?

Below is a spreadsheet designed to calculate the project completion time.Use the spreadsheet to answer the following question(s). -Which of the following formulas is used to compute the slack for an activity?

What is the employee contribution at the age of 33?

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 A17 be represented in B17?

Below is a spreadsheet designed to calculate the project completion time.Use the spreadsheet to answer the following question(s). -What is the project completion time?

Below is a spreadsheet designed to calculate the project completion time.Use the spreadsheet to answer the following question(s). -What is the latest finish time for Activity I?

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 first year?

The following spreadsheet shows financial data for Trance Electronics.Use the spreadsheet to answer the question(s)below. -What is Trance Electronics' market share in the third year?

Which of the following functions defines phenomena that increase at a specific rate?

The following spreadsheet shows a simple outsourcing decision model of a company that sells shoes.Use the spreadsheet to answer the question(s)below. -What is the total outsourcing cost incurred by the company?

The following spreadsheet shows financial data for Trance Electronics.Use the spreadsheet to answer the question(s)below. -What is the total revenue generated at the end of the second year?

What is the employer contribution at the age of 27?

The following spreadsheet shows the production and sales data for a particular product.Use the data to answer the question(s)below. -What is the total cost of the product?

In an outsourcing decision model,the total purchased cost is the product of the unit cost of outsourcing and demand volume.

Which of the following best defines heuristics?

The following spreadsheet shows the production and sales data for a particular product.Use the data to answer the question(s)below. -What is the total revenue generated by the product?

The following spreadsheet shows financial data for Trance Electronics.Use the spreadsheet to answer the question(s)below. -What is the cumulative net profit generated at the end of the third year?

The following spreadsheet shows financial data for Trance Electronics.Use the spreadsheet to answer the question(s)below. -What is the net present value of the company?

Data and Business Decisions

Descriptive Statistics and Data Analysis

Probability Concepts and Distributions

Sampling and Estimation

Hypothesis Testing and Statistical Inference

Regression Analysis

Forecasting

Introduction to Statistical Quality Control

Decision Models With Uncertainty and Risk

Decisions, uncertainty, and Risk

Queues and Process Simulation Modeling

Linear Optimization

Integer, nonlinear, and Advanced Optimization Methods

Filters