| HCM3002 Economics of Healthcare |
| Choose a Health Plan (Part 2) |
| Example of using the MAU model for choosing an office site |
| Criteria | Weights | | Sites |
| | Raw | Sum to 100 | Site A | Site B | Site C | Site D |
| Cost per square foot | 40 | 28 | 0 | 70 | 100 | 50 |
| Located where service is needed | 30 | 21 | 50 | 30 | 0 | 100 |
| Accessible by public transportation | 30 | 21 | 100 | 80 | 80 | 0 |
| Handicap accessibility | 20 | 14 | 100 | 70 | 60 | 0 |
| Room for expansion | 10 | 7 | 30 | 100 | 0 | 30 |
| Close to medical center | 15 | 10 | 100 | 0 | 80 | 80 |
| Totals | 145 | 100 | 57.24 | 195.00 | 176.00 | 114.00 |
| This is an example of using the MAU model for choosing among several sites for a medical office, considering such factors or criteria as rent, location, and space. Both raw weights and normalized weights are given. Normalized weights sum to 100. All the calculations are done by formula. When you place the curser in a cell, you will see the formula in the Formula Bar. |
mo1234h
SU_HCM3002_W4_MAUexample.xls
