• Wrong document? Swap it for free
  • Written by students who passed
  • Immediately available after payment
  • Read online or as PDF
Sell
Where do you study
Your language
Document preview thumbnail
Preview 4 out of 68 pages
Exam (elaborations)

Quantitative Methods & Decision Analysis - Comprehensive Exam

Document preview thumbnail
Preview 4 out of 68 pages

QUANTITATIVE METHODS & DECISION ANALYSIS - COMPREHENSIVE EXAM

Content preview

1


QUANTITATIVE METHODS & DECISION ANALYSIS -
COMPREHENSIVE EXAM WITH 2026-27 LATEST
VERSION STUDY GUIDE


INTRODUCTION

The Quantitative Methods & Decision Analysis Exam is a comprehensive assessment
designed to evaluate students' mastery of fundamental quantitative modeling, simulation,
and data analysis techniques used in business and managerial decision-making. This exam
covers essential topics including model classification, spreadsheet modeling, probability
distributions, simulation methods, and data analysis tools such as VLOOKUP and Goal Seek
in Microsoft Excel. The exam is crucial for business, finance, and management students as it
tests core competencies required for effective data-driven decision-making in real-world
business environments. This question bank contains comprehensive, exam-style questions
that mirror the content, difficulty, and format of actual quantitative methods examinations.
Each question includes a detailed rationale explaining the correct answer and why other
options are incorrect. With this resource, you will identify knowledge gaps, build confidence,
and develop the test-taking strategies needed to pass the exam on your first attempt.



CORE DOMAINS TESTED

1. Model Classification and Types – Symbolic models, analog models, probabilistic
models, deterministic models, physical models, and abstract models .

2. Spreadsheet Modeling and Analysis – Excel functions, VLOOKUP, Goal Seek,
forecasting, data tables, and sensitivity analysis.

3. Probability and Random Variables – Probability distributions, RAND() function,
expected values, and simulation.

4. Cost-Volume-Profit Analysis – Fixed costs, variable costs, revenue, profit calculation,
break-even analysis, and lost sales cost.

5. Decision Analysis and Simulation – Monte Carlo simulation, risk analysis, decision
trees, and scenario planning.

6. Data Analysis Techniques – VLOOKUP, HLOOKUP, INDEX/MATCH, data validation, and
What-If Analysis.

,2




QUESTIONS
Q1: Which of the following is characteristic of a symbolic model?
A) Physical
B) Abstract
C) Not an approximation
D) None of the above
Rationale: The correct answer is B. A symbolic model uses
mathematical symbols, equations, and formulas to represent the
relationships between variables. It is abstract in nature (not physical),
uses approximations, and is a type of model used in quantitative
analysis .
Q2: Which of the following statements is correct?
A) The sum of revenue and profit will give total costs
B) The sum of revenue and total costs will give Profit
C) The difference between profit and total costs will give revenue
D) None of the above
Rationale: The correct answer is B. Profit = Revenue - Total Costs,
therefore Revenue - Total Costs = Profit. Option A is incorrect because
revenue is not part of total costs. Option C is incorrect because
revenue is the sum of profit and total costs. Option B correctly states
the relationship .
Q3: Element of randomness exists in which type of models?
A) Symbolic Model
B) Analog Model

,3


C) Probabilistic Model
D) Deterministic Model
Rationale: The correct answer is C. Probabilistic models incorporate
random variables and probability distributions to account for
uncertainty. Deterministic models have no randomness and produce
the same output for a given set of inputs. Symbolic and analog
models are not defined by randomness .
Q4: Where can Goal Seek feature be found in the Data tab in Excel?
A) Under Forecast sheet
B) Under What-If Analysis
C) Under Data Analysis
D) None of the above
Rationale: The correct answer is B. Goal Seek is located in the Data
tab under the "What-If Analysis" dropdown menu in Excel. It is used
to find the input value needed to achieve a specific target result.
Forecast sheet (A) is for forecasting, and Data Analysis (C) is for
statistical analysis .
Q5: What's the chance will a RAND() function generate a number
less than 0.60?
A) 50%
B) 40%
C) 20%
D) 60%
Rationale: The correct answer is D. The RAND() function generates a
random number uniformly distributed between 0 and 1. The
probability of generating a number less than 0.60 is equal to 0.60 or
60%, because the distribution is uniform and the probability is
proportional to the interval length .

, 4


Q6: What is the main function of VLOOKUP?
A) Searches for a number equal to or greater than the value of
another number in different sheet
B) Searches for values in the entire sheet randomly
C) Searches for values in a column of a spreadsheet list or table
D) Searches for values based upon index numbers
Rationale: The correct answer is C. VLOOKUP (Vertical Lookup)
searches for a value in the first column of a table or range and
returns a value in the same row from a specified column. It is used to
find information in a spreadsheet by looking up a value in a column.
Option D describes INDEX/MATCH, not VLOOKUP .
Q7: The price of product A is $110, and variable costs for the
product is $60. The fixed costs (including staff salaries,
maintenance) amount to $4,000 per month and the company
operates 25 days a month. Assume the company produces 100 units
per day, and during one weekday demand rose to 120 units. Given
the lost sales cost of $10 per unit, what would be the profit
calculation in this scenario?
A) Profit = (110*100)-60*100-4000 – (20*10)
B) **Profit = (110*100)-60*100-4000**
C) Profit = (110*100) - (60*100) - 160- (20*10)
D) Profit = (110*100)-60*100-160
Rationale: The correct answer is B. The company produces 100 units
per day and sells all produced units. Revenue = 110 × 100 = $11,000.
Variable costs = 60 × 100 = $6,000. Fixed costs = $4,000 per month (or
$4,000/25 = $160 per day). Profit = Revenue - Variable Costs - Fixed
Costs = (110×100) - (60×100) - 4,000. Since 120 units were demanded
but only 100 were produced, there is no lost sales cost because

Document information

Uploaded on
September 9, 2026
Number of pages
68
Written in
2026/2027
Type
Exam (elaborations)
Contains
Questions & answers
$34.99

Wrong document? Swap it for free Within 14 days of purchase and before downloading, you can choose a different document. You can simply spend the amount again.
Written by students who passed
Immediately available after payment
Read online or as PDF

Seller avatar
Reputation scores are based on the amount of documents a seller has sold for a fee and the reviews they have received for those documents. There are three levels: Bronze, Silver and Gold. The better the reputation, the more your can rely on the quality of the sellers work.
Sold
68
Followers
13
Items
2940
Last sold
1 month ago



Why students choose Stuvia

Created by fellow students, verified by reviews

Quality you can trust: written by students who passed their tests and reviewed by others who've used these notes.

Didn't get what you expected? Choose another document

No worries! You can instantly pick a different document that better fits what you're looking for.

Pay as you like, start learning right away

No subscription, no commitments. Pay the way you're used to via credit card and download your PDF document instantly.

Student with book image

“Bought, downloaded, and aced it. It really can be that simple.”

Alisha Student

Working on your references?

Create accurate citations in APA, MLA and Harvard with our free citation generator.

Working on your references?

Frequently asked questions