際際滷

際際滷Share a Scribd company logo

Msci 332 presentation - Minimizing Elderly Care Wait list Time

Download as PPTX, PDF
Merisa Lee
Merisa Lee

For our MSCI 332 presentation/final project we decided to tackle minimizing elderly care wait list time using mixed integer programming. Fun project!

1 of 14
Using optimization to minimize NURSING CARE w a i t l i s t t i m e By Nor Hameed, Merisa Lee, Masa Shaban & Yahya Wahbeh
PROBLEM Between 2005 and 2012, the median wait time for people trying to get into an Ontario nursing home almost tripled from 36 to 98 days. 15% of people on nursing home wait lists die before they can be placed.
Projected number of Canadians over 65 in percentage Life expectancy is steadily increasing due to improved health services and the retirement of baby boomers.
DEMAND IS GOING UP FAST Whereas supply is going up a mere 3%
HOW DO WE FIX THIS?
Basic Deluxe Private Licensed Beds # on Waitlist Average days waiting # on Waitlist Average days waiting # on Waitlist Average days waiting Cambridge Country Manor 79 6 55 0 34 0 26 Chateau Gardens Elmira 48 14 151 14 102 28 199 Columbia Forest Centre 156 79 672 0 0 79 580 Derbeckers Heritage House 72 21 536 13 138 26 0 Fairview Mennonite Home 84 121 1352 0 0 70 1079
22 elderly homes in four different cities within KW region
Elmira (3) Cambridge (8) Waterloo (3) Kitchener (8) Split into 4 different clusters based on location
Basic Deluxe Private Cluster Total # available beds # waiting Average waiting time # waiting Average waiting time # waiting Average waiting time Cambridge 336 486 917 29 190 180 591 Kitchener 468 1178 917 85 331 912 679 Waterloo 108 268 677 2 168 311 1305 Elmira 60 36 357 12 127 12 171
Objective function: Minimize waiting time subject to: 0<xT<0.4*total capacity xB*cB + xD*cD + xP*cP <xT cB + cD + cP = 1 2 =0 =0 訣
XT 1 AB0 M1 M2 W0 DW0 D0 0 AB1 W1 DW1 D1 M0 ABi = average of available beds at year i Wi = average number of waiting days at year i DWi = average days waiting per patient at year i Di = demand at year i Mi = mortality at year i 2
What percentage for new capacity added should we allocate each bed type? ? ? ? Demand Capacity xB xD xP xB xD xP
Demand Mortality
Thank you!

More Related Content

Msci 332 presentation - Minimizing Elderly Care Wait list Time

  • 1. Using optimization to minimize NURSING CARE w a i t l i s t t i m e By Nor Hameed, Merisa Lee, Masa Shaban & Yahya Wahbeh
  • 2. PROBLEM Between 2005 and 2012, the median wait time for people trying to get into an Ontario nursing home almost tripled from 36 to 98 days. 15% of people on nursing home wait lists die before they can be placed.
  • 3. Projected number of Canadians over 65 in percentage Life expectancy is steadily increasing due to improved health services and the retirement of baby boomers.
  • 4. DEMAND IS GOING UP FAST Whereas supply is going up a mere 3%
  • 5. HOW DO WE FIX THIS?
  • 6. Basic Deluxe Private Licensed Beds # on Waitlist Average days waiting # on Waitlist Average days waiting # on Waitlist Average days waiting Cambridge Country Manor 79 6 55 0 34 0 26 Chateau Gardens Elmira 48 14 151 14 102 28 199 Columbia Forest Centre 156 79 672 0 0 79 580 Derbeckers Heritage House 72 21 536 13 138 26 0 Fairview Mennonite Home 84 121 1352 0 0 70 1079
  • 7. 22 elderly homes in four different cities within KW region
  • 8. Elmira (3) Cambridge (8) Waterloo (3) Kitchener (8) Split into 4 different clusters based on location
  • 9. Basic Deluxe Private Cluster Total # available beds # waiting Average waiting time # waiting Average waiting time # waiting Average waiting time Cambridge 336 486 917 29 190 180 591 Kitchener 468 1178 917 85 331 912 679 Waterloo 108 268 677 2 168 311 1305 Elmira 60 36 357 12 127 12 171
  • 10. Objective function: Minimize waiting time subject to: 0<xT<0.4*total capacity xB*cB + xD*cD + xP*cP <xT cB + cD + cP = 1 2 =0 =0 訣
  • 11. XT 1 AB0 M1 M2 W0 DW0 D0 0 AB1 W1 DW1 D1 M0 ABi = average of available beds at year i Wi = average number of waiting days at year i DWi = average days waiting per patient at year i Di = demand at year i Mi = mortality at year i 2
  • 12. What percentage for new capacity added should we allocate each bed type? ? ? ? Demand Capacity xB xD xP xB xD xP