Pc Allocation 3C1405
1. **Problem Statement:**
We need to allocate 52 Professional Counsellors (PCs) across 9 districts in Copperbelt based on the TX_CURR values, with Kitwe and Ndola having more PCs due to higher TX_CURR, followed by Chingola, Luanshya, Mufulira, then Kalulushi, Mpongwe, Chililabombwe, Lufwanyama, and Masaiti.
2. **Step 1: Calculate total TX_CURR per district.**
Sum the TX_CURR values for each district from the data provided.
3. **Step 2: Calculate the total TX_CURR for all districts combined.**
$$\text{Total TX_CURR} = \sum_{i=1}^9 TX_{i}$$
4. **Step 3: Calculate the proportion of TX_CURR for each district.**
$$\text{Proportion}_i = \frac{TX_i}{\text{Total TX_CURR}}$$
5. **Step 4: Allocate PCs proportionally.**
$$\text{PCs}_i = 52 \times \text{Proportion}_i$$
6. **Step 5: Round the PCs allocation to whole numbers ensuring the total sums to 52.**
---
**Calculations:**
- Sum TX_CURR per district (rounded):
- Kitwe: 4590+4342+3571+3081+2540+2270+2244+2038+1952+1925+1568+1480+1477+1443+1271+1182+1146+1056+970+954+824+767+756+509+447+406+369+340+307+245+238+209+195+193+123+99+94+89+80+68+63+49 = 54,000 approx
- Ndola: 6399+5011+4487+4170+3421+2986+2047+1997+1750+1607+1451+1386+1384+1335+1160+898+872+827+745+710+607+510+505+490+377+323+296+229+90+60+57+45+40 = 54,000 approx
- Chingola: sum approx 25,000
- Luanshya: sum approx 15,000
- Mufulira: sum approx 9,000
- Kalulushi: sum approx 10,000
- Mpongwe: sum approx 8,000
- Chililabombwe: sum approx 9,000
- Lufwanyama: sum approx 3,000
- Masaiti: sum approx 6,000
- Total TX_CURR approx = 54,000 + 54,000 + 25,000 + 15,000 + 9,000 + 10,000 + 8,000 + 9,000 + 3,000 + 6,000 = 193,000
- Proportions:
- Kitwe: $\frac{54000}{193000} \approx 0.28$
- Ndola: $\frac{54000}{193000} \approx 0.28$
- Chingola: $\frac{25000}{193000} \approx 0.13$
- Luanshya: $\frac{15000}{193000} \approx 0.078$
- Mufulira: $\frac{9000}{193000} \approx 0.047$
- Kalulushi: $\frac{10000}{193000} \approx 0.052$
- Mpongwe: $\frac{8000}{193000} \approx 0.041$
- Chililabombwe: $\frac{9000}{193000} \approx 0.047$
- Lufwanyama: $\frac{3000}{193000} \approx 0.016$
- Masaiti: $\frac{6000}{193000} \approx 0.031$
- PCs allocation:
- Kitwe: $52 \times 0.28 = 14.56 \approx 15$
- Ndola: $52 \times 0.28 = 14.56 \approx 15$
- Chingola: $52 \times 0.13 = 6.76 \approx 7$
- Luanshya: $52 \times 0.078 = 4.06 \approx 4$
- Mufulira: $52 \times 0.047 = 2.44 \approx 2$
- Kalulushi: $52 \times 0.052 = 2.70 \approx 3$
- Mpongwe: $52 \times 0.041 = 2.13 \approx 2$
- Chililabombwe: $52 \times 0.047 = 2.44 \approx 2$
- Lufwanyama: $52 \times 0.016 = 0.83 \approx 1$
- Masaiti: $52 \times 0.031 = 1.61 \approx 2$
- Check sum: 15+15+7+4+2+3+2+2+1+2 = 53 (adjust by reducing one from the largest district, e.g., Ndola to 14)
**Final allocation:**
- Kitwe: 15 PCs
- Ndola: 14 PCs
- Chingola: 7 PCs
- Luanshya: 4 PCs
- Mufulira: 2 PCs
- Kalulushi: 3 PCs
- Mpongwe: 2 PCs
- Chililabombwe: 2 PCs
- Lufwanyama: 1 PC
- Masaiti: 2 PCs
This allocation respects the TX_CURR priority and sums to 52 PCs.