This preview shows pages 1–3. Sign up to view the full content.
ADM 2302 A, B, C, and D
Solution Assignment #3
Assignment # 3
SOLUTION
Data Analysis
1.
Demand
100~150 patients per year
RNs
SRPNs
JPRNs
Costs (salary per year)
$45,000
$28,000
$23,000
Minimum/Maximum
working hours requirement
(per week)
138/360
88/222
134/134
Salary per hour
LP model
X
R
= number of registered nurses (RNs)
X
S
= number of senior registered practical nurses (SRPNs)
X
J
= number of junior registered practical nurses (JPRNs)
Minimize
s.t.
The model above was formulated using hourly cost. However it can be formulated using weekly
1 
P a g e
This preview has intentionally blurred sections. Sign up to view the full version.
View Full Document ADM 2302 A, B, C, and D
Solution Assignment #3
or yearly cost.
The optimal decision would be the same for all three models. However the value of the objective
function would change form hourly to weekly to yearly cost.
Thus it is sufficient to formulate and solve ONE linear formulation using hourly, weekly or
yearly objective function coefficient. Provide the Excel solution and report for ONE model.
Then calculate the value of the objective function (i.e. cost) for the other two options without
having to provide the reports and the excel spreadsheet formulation.
Also note in the Spreadsheet formulation the hours where translated into number of personal (i.e. dividing
This is the end of the preview. Sign up
to
access the rest of the document.
This note was uploaded on 02/13/2011 for the course ADM 2302 taught by Professor El during the Fall '05 term at University of Ottawa.
 Fall '05
 EL

Click to edit the document details