Qualis Investments is a private limited business that manages personal financial
portfolios. The company manages six mutual funds and has a client that has acquired
$750,000 from an inheritance. Characteristics of the funds are given in the table below.
The company recommends that no more than $300,000 be invested in any individual
fund, and that at least $80,000 be invested in each of the mid-cap stock and mortgage
fund. The total amount invested in the low-priced and multinational funds are at least
35% of the total investment. The client would like an average return of at least 6%.
Assume that X1- X6 represent the dollar amounts invested in funds 1 through 6,
respectively.
Which of the following describes the constraint on the mid-cap fund?
A) X3 ≥ 0.35(750,000)
B) X3 ≥ 80,000
C) X3 ≥ 0.35(80,000)
D) X3 ≤ 670,000
Below is the spreadsheet for demand prediction of a company that sells chocolates.
If, in the spreadsheet, cells B9 and B10 were empty, which of the following formulas
should be entered in B8 so that the formula can be dragged to B9 and B10 to obtain
their correct values?
A) B4-B5*A8
B) B4-B5*$A8
C) $B4-B5*$A8
D) $B$4-$B$5*$A8
Consider the spreadsheet for a Newsvendor Model.
What is the value of mode?
A) $228
B) $245
C) $255
D) $264
Which of the following is true about constructing PivotTables?
A) It is not possible to construct the PivotTable in the same worksheet.
B) Dragging a field into the Report Filter area allows addition of a third dimension to
the analysis.
C) Placing a field each in the row and column labels will automatically sum the variable
values in the table.
D) PivotTables cannot be duplicated by copying and pasting an existing table.
Time-series models may exhibit seasonal effects or cyclical effects. A seasonal effect
differs from a cyclical effect in that a seasonal effect:
A) has no trend, is relatively constant, and only exhibits random behavior.
B) describes ups and downs over a time frame such as several years.
C) is one that repeats at fixed intervals of time, typically a year, month, week, or day.
D) is based on analysis of historical time-series data and are predicated on the
assumption that the future is an extrapolation of the past.
Which of the following is true about the Random Number Generation tool?
A) The Random Number Generation dialog presents only three distributions to choose
from: beta, lognormal, and triangular.
B) The default distribution in this tool is the continuous distribution.
C) Repeating the process generates a new set of sample values.
D) Pressing the recalculation (F9) key is an easy way to change the values generated.
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.
Use the spreadsheet below for Stone Age Surfboards to answer the following
question(s) using integer constraints on variables in the optimization models using the
standard Solver.
What is the total number of hours used for the finishing operation?
A) 39.6
B) 34.4
C) 29.2
D) 24.8
Belowisaspreadsheetofpurchaseordersfor acomputerhardwareretailer.
If purchase quantities of 25 units or higher are found to be large orders, and orders less
than
25 are considered to be small, what IF function should be entered in H4 to be copied to
H5:H10 to calculate each order’s size?
A) =IF(D4=AND=OR=25,”Large”,”Small”)
B) =IF(D4<>25,”Small”)=AND(D4=25,”Large”)
C) =IF(D4=25,”Large”)=OR(“Small”)
D) =IF(D4>=25,”Large”,”Small”)
Below is a room overbooking model spreadsheet for the Metza, a hotel chain. The hotel
has 425 rooms priced at $180 per day each, and is usually fully booked. Reservations
can be cancelled any time before 5:00 p.m. with no penalty. The hotel estimates an
average overbooking cost of $150. Customer demand is set at 400 with an average
cancellation of 20.
Calculate the customer arrivals at the Metza.
A) 425
B) 405
C) 400
D) 380
Which of the following 2010 Excel functions computes the p-value for the chi-square
test?
A) CHISQ.INV.RT
B) CHIDIST
C) CHI.SQ
D) CHISQ.TEST
Bolton Computer’s
Laptop
Pricing Decision
Inputs
Price
Model
Sales -3.85 price + 1150.9
Outputs
Total revenue sales price
According to the nonlinear model, which of the following is the expected sales figure
based on the computed price?
A) 149.47
B) 719.7
C) 575.45
D) 500
What is the slope of the sales function D = a -bP?
A) 4
B) 9
C) 12
D) 17
Which of the following types of data-mining methods provides probabilistic if-then
statements?
A) association rule
B) logistic regression
C) reduction
D) cause-and effect modeling
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 forecasted value for the 7th week?
A) 53 phones
B) 82 phones
C) 71 phones
D) 49 phones
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 total profit generated?
A) $ 675.68
B) $ 920.57
C) $ 521.74
D) $ 788.32
Following is an extract from the Employee Payroll Database of HFR Informatics Inc.
What is the relative frequency of Grade 3 employees?
A) 4
B) 0.55
C) 0.20
D) 5
Sheila joined Simsin Tradings at the age of 36 with a starting salary of $ 75,000. She
expects a salary increase of 5 percent every year. Her retirement plan requires her to
pay 9 percent of her salary, while the company matches it at 32 percent. She expects an
annual return of 7 percent on her retirement portfolio. Using a predictive model for
Sheila’s first five years, calculate the following, assuming that the salary increases at the
same rate every year, and the return of interest does not change.
What’s the total retirement balance when Sheila has reached the age of 40 while
working with Simsin?
A) $108,374.54
B) $56,253.36
C) $53,627.87
D) $91,163
Fiberia Accessories, a clothing retailer, is planning to introduce a new line of sweaters
as part of the winter collection for $65 with an inventory of 1500. The main selling
season is 60 days between November and December. The store then sells the remaining
units in a clearance sale at 65 percent discount. Out of the 60 main retail days, Fiberia
sells the sweaters at full retail price for only 45 days, while giving a discount of 25
percent for the remaining 15 days. The demand functions a, and b are given as 79.5 and
1.1 respectively.
Calculate the total revenue for the new line of sweaters.
A) $59,426.25
B) $48,871.88
C) $23,400
D) $43,231.09