Thefunctionreturnsavalueor referenceof thecellattheintersectionof a particular row and column in a
given range.
A) VLOOKUP(lookup_value, table_array, col_index_num)
B) INDEX(array, row_num, col_num)
C) MATCH(lookup_value, lookup_array, match_type)
D) HLOOKUP(lookup_value, table_array, row_index_num)
Dresden Pharmaceuticals has decided to go ahead and start clinical trials on a potential
new drug. The total R&D costs are estimated to reach around $875,000,000 with
clinical trials mounting to $145,000,000. The current market size is estimated to be
around 3,000,000 and is expected to grow at 4 percent every year. The market share
Dresden hopes to capture in the first year is 7 percent, and is projected to grow by 25
percent each year for the next 4 years. A monthly prescription is anticipated to generate
revenue of $420 while incurring variable costs of $150. A discount rate of 8 percent is
assumed.
Calculate the annual revenue for the fourth year.
A) $ 2,325,304,800
B) $830,466,000
C) $1,494,838,800
D) $1,149,876,000
The Atlas Movies Theater is planning to reprice their ticket rates to maximize revenues.
They have three classes of tickets: Classic, Silver, and Gold. The table below provides
information on the average ticket sales, revenue and price elasticity on demand. They
have a total seating capacity of 300. The table also provides the price range within
which they plan to reduce their ticket rates.
According to the nonlinear model, which of the following is the projected revenue
figure for Gold tickets based on its new price?
A) $432.93
B) $1,316.92
C) $1,116.03
D) $523.29
Which of the following is a differentiation between calculating using the functions
COUNT
and COUNTIF?
A) COUNT does not require a range of cells; COUNTIF requires a range of cells.
B) COUNT only requires a range of cell and can be obtained without a special criteria,
COUNTIF requires range and special criteria to be calculated.
C) COUNT requires a range of cells; COUNTIF does not require a range of cells, only
special criteria.
D) COUNT calculates the sum of values for a range of cells; COUNTIF finds the
largest value in a range of cells.
Below is the spreadsheet for an economic order quantity model.
Assume that the distribution of demand is normal with a mean of 20,000 and standard
deviation of 2,000.
What is the coefficient of variation obtained from the simulation results?
A) 0.28
B) 0.10
C) 0.45
D) 0.60
Dresden Pharmaceuticals has decided to go ahead and start clinical trials on a potential
new drug. The total R&D costs are estimated to reach around $875,000,000 with
clinical trials mounting to $145,000,000. The current market size is estimated to be
around 3,000,000 and is expected to grow at 4 percent every year. The market share
Dresden hopes to capture in the first year is 7 percent, and is projected to grow by 25
percent each year for the next 4 years. A monthly prescription is anticipated to generate
revenue of $420 while incurring variable costs of $150. A discount rate of 8 percent is
assumed.
Calculate the projected profit for the third year.
A) $31,315,200
B) $2,373,996,000
C) $1,149,876,000
D) $1,494,838,800
Dresden Pharmaceuticals has decided to go ahead and start clinical trials on a potential
new drug. The total R&D costs are estimated to reach around $875,000,000 with
clinical trials mounting to $145,000,000. The current market size is estimated to be
around 3,000,000 and is expected to grow at 4 percent every year. The market share
Dresden hopes to capture in the first year is 7 percent, and is projected to grow by 25
percent each year for the next 4 years. A monthly prescription is anticipated to generate
revenue of $420 while incurring variable costs of $150. A discount rate of 8 percent is
assumed.
Calculate the projected sales for the first year.
A) 273,000
B) 210,000
C) 378,000,000
D) 268,230
Which of the following typically describes the support for the association rule?
A) the number of transactions that include all items that are in the antecedent parts of
the rule
B) the number of transactions that include all items in the antecedent and consequent
parts of the rule
C) the number of transactions that include half from the antecedent and half from the
consequent
D) the number of transactions that include all items that are in the consequent parts of
the rule
________ is a collection of techniques that seek to group or segment a collection of
objects or observations into subsets, such that those within each subset are more closely
related to one another than objects assigned to different subsets.
A) Association rule mining
B) Discriminant analysis
C) Cluster analysis
D) Logistic regression
Spam filtering for e-mails can be seen as an example of which of the following types of
approaches of data mining?
A) reduction
B) association
C) cause-and-effect modeling
D) classification
The details of the clock sales at a supermarket for the past 6 weeks are shown in the
table below. The time series appears to be relatively stable, without trend, seasonal, or
cyclical effects. The simple moving average value of k is set at 2.
Using the data, determine the value of the simple moving average root mean square
error.
A) 0.21
B) 14.39
C) 20.12
D) 207.13
Which of the following is the root cause for the newsvendor problem?
A) uncertainty in supply
B) uncertainty in demand
C) high cost per unit sale
D) high total production cost
Pickson Luthiers Corporation is studying where to locate a phone charging point on the
factory floor. The locations of five production cells are expressed as X– and
Y-coordinates on a rectangular grid of the factory layout. The daily demand for the
charging point (measured as the number of trips to the charging point) at each
production cell is also known. Because of the nature of the equipment layout in the
factory and for safety reasons, workers must travel along marked horizontal and vertical
aisles to access the charger. Thus, the distance from a cell to the charger is measured as
rectilinear distance.
The table below provides the relevant information.
The optimal location should minimize the total weighted distance between the charging
point and all production cells, where the weights are the daily number of trips to the
phone charging point.
According to the model, what is the total weighted distance between the 5 production
cells and the phone charger?
A) 253.50
B) 113.00
C) 172.50
D) 165.50
Stone Age Surfboards is a small manufacturer of two types of popular low-tide
surfboards, the Graystone and the Lava models. The manufacturing process consists of
two departments: fabrication and finishing. The fabrication department has 8 skilled
workers, each of whom works 9.25 hours per day. The finishing department has 5
workers, each of whom works a 6 -hour shift per day. Each pair of Graystone
surfboards requires 2.5 labor hours in the fabrication department and 2 labor hours in
finishing. The Lava model requires 4.2 labor-hours in fabrication and 3.6 labor-hours in
finishing. The company operates 6 days a week. It makes a per unit profit of $40 on the
Graystone model and $60 on the Lava model. The company anticipates selling at least
twice as many Lava models as Graystone models.
What is the Allowable Increase in the finishing hours used?
A) 32.46
B) 8.33
C) 26.84
D) 16.67
Which of the following describes dispersion in statistics?
A) the degree of variation in the data
B) the central value in the data
C) the frequency of values in the data
D) the measure of outliers in the data
Below is the spreadsheet for a project selection model:
What is the total return obtained from all five projects?
A) $ 860,000
B) $ 550,000
C) $ 700,000
D) $ 395,000
The table provided below gives the sales details of the number of android smart phones
at an electronic retail store for the past 6 weeks. The time series appears to be relatively
stable, without trend, seasonal, or cyclical effects. (Hint: Optimize α value in 0.1
increments)
What is the difference between the forecasted and the actual value for the 3rd week?
A) 1 phones
B) 6 phones
C) 4 phones
D) 3 phones
Below is the spreadsheet for a project selection model:
What is the amount of cash used for Project 5?
A) $ 65,000
B) $ 117,000
C) $ 13,000
D) $ 110,000
Following is an extract from the Cost per Order Database of Grogtes LLC.
Which of the following observations is closest to the third quartile?
A) 35 N102 nuts for $190.40
B) 59 S103 screws for $556.96
C) 13 N103 nuts for $22.62
D) 2 NG102 nailgun packs for $550.90
The ________ indicates how much the value of the objective function will change as
the right-hand side of a constraint is increased by 1.
A) objective coefficient
B) shadow price
C) binding constraint
D) reduced cost
Below is the spreadsheet for Memphis Designs fixed cost model:
What is the net production at the end of the first quarter?
A) 75
B) 200
C) 450
D) 600
Howard has screened some employee details out of the employee database for tax
computation purposes. In order to restore the original data file, Howard must:
A) click Sort Newest to Oldest.
B) click Clear filter from Item Description.
C) click Unmerge cells.
D) click Clear outline from Ungroup.
______are mathematical functions used in predictive analytical models which define
phenomena that increase at a specific rate, and is represented by the formula y = axb
A) Exponential functions
B) Power functions
C) Polynomial functions
D) Logarithmic functions
Which of the following is the root cause for the newsvendor problem?
A) uncertainty in supply
B) uncertainty in demand
C) high cost per unit sale
D) high total production cost
How is a frequency distribution calculated for categorical and numerical data?
Why do predictive decision models incorporate uncertainty?
Describe the method of calculating the net present value (NPV) in Excel.
Compare between a prediction interval and a confidence interval.
Below is the data collected from a manufacturing process for a part whose dimensions
are specified as 4.00 0.1 centimeters. Calculate the process capability index within three
standard deviations of the mean.
Manufacturing Measurements
4.78 3.99 5.02
4.23 4.57 4.44
5.18
P(Q|P) = P(Q) – P(P)
Describe the method of calculating the net present value (NPV) in Excel.
How are probability, experiment, outcome, and sample space related to each other?