4. ADM 2302 STUDENT Solution Assignment #3

# 4 ADM 2302 STUDENT - ADM 2302 A B C and D Solution Assignment#3 Assignment 3 SOLUTION Data Analysis 1 Demand Costs(salary per year Minimum/Maximum

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.

### Page1 / 4

4 ADM 2302 STUDENT - ADM 2302 A B C and D Solution Assignment#3 Assignment 3 SOLUTION Data Analysis 1 Demand Costs(salary per year Minimum/Maximum

This preview shows document pages 1 - 3. Sign up to view the full document.

View Full Document
Ask a homework question - tutors are online