Harry's Car Wash
Input Data
Arrival rate (l)
10
Service rate (m)
12
Number of servers (s)
1
Probabilities
Number of Units
0
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
Computations
n or s
Proba
A
B
1
Solved Problem 9-3
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
Queuing Model
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
C
D
E
F
M/M/s (Exponential Service Times)
1.
1. Both ll and
and mm must
m
A
B
C
D
1
3-12 Campaign Advertising
2
V = maximum additional votes obtainable from ad campaign
3
6
S = number of small road side signs
L = number of large road side signs
B = number of sets of 1000 bu
A
1
Problem Title
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
Queuing Model
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
B
C
D
E
F
M/M/s (Exponential Service Times)
1.
1. Both ll and
and mm must
must b
Department of Commerce
Queuing Model
M/M/s with a finite population
1. Both l and mm must
must be
be RATES,
RATES, and
and use
use the
the same
same time
time unit.
unit.
2. The arrival rate is for ea
A
B
1
Solved Problem 9-2
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
Queuing Model
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
C
D
E
F
M/M/s (Exponential Service Times)
1.
1. Both ll and
and mm must
m
Garcia-Golding Recycling
Queuing Model
M/D/1 (Constant Service Times)
1. Both l and mm must
must be RATES, and use the same time unit. For example, given a service time such
as 10 minutes per customer
Professor Crino's Problem
Queuing Model
M/G/1 (General Service Times)
1.
1. Both
Both ll and
and mm must
must be
be RATES,
RATES, and
and use
use the
the same
same time
time unit.
unit. However,
Howev
COM-315 Decision Support Systems
Module 1 Assignment 1
1-2. What is the difference between deterministic and probabilistic models? Give several examples of each type of
model.
Deterministic models ass
Atari: Model 400 and 800
computers
By: Anayah McKenzie, Christopher Mena, Jacob Montgomery
Background on Atari the Company
Formed in 1972
Allan Alcorn designed Pong
Nolan Bushnell
Nolan Bushnell
Ted
Chapter 5 5-18
A food distribution company ships fresh spinach from its four packing plants to large East-coast cities. The shippi
in the table at the bottom of this page.
a. Formulate a model that wi
Chapter 3 Exercise 3-12
A political candidate is planning his media budget for an upcoming election. He has $90,500 to spend. His politi
the following estimates of additional votes as a result of the
Chapter 2 Exercise 2-30
A warehouse storage building company must determine how many storage sheds of each sizelarge or small
to build in its new 8,000-square-foot facility to maximize rental income.
Full file at http:/testbankassistant.CH/Test-Bank-for-Managerial-DecisionModeling-with-Spreadsheets-3rd-Edition-by-Balakrishnan
Managerial Decision Modeling w/ Spreadsheets, 3e (Balakrishnan/Render/St
Microsoft Excel 15.0 Answer Report
Worksheet: [Book1]Sheet1
Report Created: 7/24/2016 1:00:31 AM
Result: Solver found a solution. All Constraints and optimality conditions are satisfied.
Solver Engine
Chapter 1 Exercise 1-26
A start-up publishing company estimates that the fixed costs of its
first major project will be $190,000, the variable cost will be $18, and the
selling price per book will be
SET FOREIGN_KEY_CHECKS=0;
DROP TABLE IF EXISTS INVENTORY;
DROP TABLE IF EXISTS LINE_ITEM;
DROP TABLE IF EXISTS PRODUCT;
DROP TABLE IF EXISTS ORDERS;
DROP TABLE IF EXISTS STORE;
DROP TABLE IF EXISTS
/*-QUERY 0 (where zero is just an example ) Write a SQL statement to display the Class_ID, Start_Date, FIRST_NAME, LAST_NAME of the instructors whose last names start with "J".
Query Zero example is e
MIS582 PROJECT DATA DICTIONARY
TABLE NAME
STORE
REGION
WAREHOUSE
DEPARTMENT
EMPLOYEE
PRODUCT
ORDER
LINE_ITEM
INVENTORY
TYPE
LENGTH
REQUIRED
PK OR FK
storeID
Name
Address
City
State
Zip
ContactName
Con
Question 1
A discrete random variable has a mean of 400 and a variance of 64. What is the standard deviation?
1) 20
2) 64
3)
8
4) 400
5) None of the above
Random Section 2
Question 2
Data for a partic
Question 1
Strategic behavior and game theory are features of which market structure?
1) Perfect competition
2) Monopoly
3) Monopolistic competition
4) Oligopoly
Question 2
Which one of the following
Question 1
A merchandising company's:
1) expenses include only product costs.
2) income statement doesn't include gross margin.
3) expenses include only period costs.
4) expenses include both period c
Photo Copy Machine Company
Number of units
Profit
PJ
PD
PP
Print Jet
168
$60
Print
Desk
287
$90
Print Pro
683
$73
2.9
1.4
3.7
2.1
3
1.7
Total Productio
Total Units
1139
$85,811.88
Profit
Constraints:
Campaign Advertising
SS
SL
R
BS
Bumper
Small
Radio
Sticker Per
Sign Large Sign Advertising Thousand
Number of units
Votes Gardnered
Constraints:
Max Small Sign
Max Large Sign
Max Radio
Max Bumper Stic
Lettuce Distributor - Manual Process
Lettuce Distributor - Mechanized P
Known Parameters
Known Parameters
Selling price per unit
Fixed cost
Variable cost per unit
$2.50
$43,400.00
$1.80
Selling price
Bismark Manufacturing - Proposal A
Known Parameters
Selling price per unit
Fixed cost
Variable cost per unit
Known Parameters
$18.00
$65,000.00
$10.00
Variables
Number of units, X
Results
Total revenu