x1
x2
x3
270
0
0
max Z
Constraints
270.000
<=
540.000
<=
540.000
<=
270.000
<=
0.000
<=
0.000
<=
1930
400.000
600.000
540.000
270.000
0.000
0.000
Yi
y1
y2
y3
1 if we decide to produce produ
0 otherwise
i=1,2,3
1
0
1E-16
we decide to produce product "I"
Mi
Case 6.4 Removing Snow in Montreal
MGMT 1818 (Management Science)
TTH 8:30-9:45am
Team #4
March 28, 2016
Brittany Firestone
Nick Naret
Alex Ecker
1.) Summary
Montreal needs a snow removal schedule for their city. The city is divided up
into several sector
Microsoft Excel 14.5 Answer Report
Worksheet: [Take Home 2 #2.xlsx]Sheet1
Report Created: 3/24/2016 1:16:06 PM
Result: Solver found a solution. All constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.8651
Case 13.2 Call Center Staffing
MGMT 1818 (Management Science)
TTH 8:30-9:45am
Team #4
April 14, 2016
Brittany Firestone
Nick Naret
Alex Ecker
1.) Summary
Vacations Inc. markets timeshares throughout North America. VI offers a
chance to win a free mini vac
Microsoft Excel 14.5 Answer Report
Wor
Worksheet:[Naret.xlsx]Sheet1
Report Created: 3/24/2016 12:12:07 PM
Result: Solver found a solution. All constraints and optimality conditions are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 0.908335 Se
MG1
M/G/1
average
service RATE
Arrival rate
Average service TIME
Standard dev. of service time
Utilization
P(0), probability that the system is empty
Lq, expected queue length
L, expected number in system
Wq, expected time in queue
W, expected total time
Microsoft Excel 15.0 Answer Report
Worksheet: [Case 2.xlsx]original
Report Created: 03/28/2014 9:35:40 AM
Result: Solver found an integer solution within tolerance. All Constraints are satisfied.
Solver Engine
Engine: Simplex LP
Solution Time: 1.279 Secon
15th edition: variances are always reported in dollars and should indicate whether favorable or unfavorable
RATE OR PRICE $
QUANTITY OR EFFICIENCY
VARIANCE
VARIANCE
LABOR & OH
Actual Hours of Input,
at Actual Rate
(AH AR)
MATERIALS
Actual Quantity of
Inpu