i have provided the data and method i want this on excel spreadsheet with formulas..

Exhibit 10: Remote Clinics Infant HIV Sample Data Clinic Number ( Results Collected by Mother Intants Put on ARV Therapy Samples Positive 12 17 6) Results Collected by Mother 32 39 59 7 10 2 3 4 5 6 10 10 8 8 Number of Infants Seen in 2010 85 110 100 112 97 101 95 SO 209 91 256 257 90 96 297 8 9 10 15 16 15 13 22 13 41 37 14 50 55 50 24 117 37 115 21 3 17 5 17 16 6 19 8 50 47 161 85 253 115 105 110 114 ==bntnum 54 # 4 5 # 3 4 $ 6 * 6 & 5 6 8 & # # ; # # # # # # # # 3 # 7 17 16 17 17 45 16 15 41 13 69 41 21 274 107 10 97 255 90 116 62 56 106 50 17 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 . 18 278 227 541 128 94 258 39 80 17 45 13 124 115 01 84 113 91 243 517 575 111 257 100 93 261 54 39 79 15 4 24 244 54 18 15 14 41 8 7 47 41 19 38 3 39 8 23 6 5 13 20 19 7 5 18 17 100 24 23 9 45 46 47 48 49 50 91 30 256 233 98 75 14 14 41 38 16 129 122 50 38 116 110 51 20 10 5. In order to decide where to conduct the Potests, it is necessary to develop animation model The number of infants put on ARV theory is considered as the figure to because the initial paths to provide le putetea with the situation, the number of patients put on All therapy is the best and easiest way to me the performance. To formulate the model is necessary to make some motion 2. The number of infants taking the tests in the clinic will not change due to the POS proces b. General waiting time in during Pos will be 30 min. Al mothers will stay in the clinic to the collect results, so the collected sange number will be one to 100 t. Positively infants will be the same chance therapy process and POS d. There is no capacity limit of my clinic during the POS procent Therefore, by conducting the POS process is 20 out of so-clinic the structures will be the decentralizing and centralizing structure. As for clinics conducting the Pos tests decentraline structure, mothers can go directly to the diniset their interes tested and get the results, without sending samples to the central tab. Where other cinice will come previous proces collect samples and the other central and mothers to pick up the results Thus, in the objective formula, there will be parts DBS process. The romber of infants keeps the same in the al data POS process. The number of infants quals to the product of the rumbers of taste test sensitivity (95%) and probability of intents with positive results to receive Re Here, since the sensitivity of the Posters is not as good of positive diagnosed negative ones. Therefore it is necessary to comider the lo here. Alebo the assumption that the loss in the collection process will not be considered since there supposed to get results 30 min after tests.sono mothers will be without recieving the First, the total number of clinics which apply the POS process will be 20. Secondly, the cost of the www structure will not exceed the previousco Since the transportation som NGO in propose considered in the cost. In the cute con is divided to 2 parts. As for the POS process, the variable cose to the produce number of infants taking the test and werage cost per tests. Whereas the fed congue to the price of the recently acquired machines in case of the Des process, the costs here the same. in all, the optimization problem is While choosing the 20dinics De Gatos focus on several po Y-Either or to stands for a contro stands for conduct PC X-Infant put on the Z-Number of instants Seen P-Samolotive S-Sensitivity R-Infant put on therapy/samples positive collected "Cost per test of DBS 45 Laverage between 25-70 Transportation costs are ignored Cost per test of POC 11 average between 7-15 MaxXY SR St. Sum 20 C.*2*1*36*2*x+550202 According to the results solved by over, it can be concluded that the POS should be polied in Clinic 11.12.85.16.21.2426.27.21:29:35.36.37.23.40.43S 48.48. There Intants taking the therapy has been improved by over ons in our model and the cost is much lower than the previo model Although the result seem very good, the model is based on see sumptions which is much simple For sample the POS process may drive mother's motivation to better do the test since now mothers will not work for a very long time to put the result. The training process to conduct the new process as hobored and the machina tonsidered. Therefore, the model is not perfect and needs to consider montadion Exhibit 10: Remote Clinics Infant HIV Sample Data Clinic Number ( Results Collected by Mother Intants Put on ARV Therapy Samples Positive 12 17 6) Results Collected by Mother 32 39 59 7 10 2 3 4 5 6 10 10 8 8 Number of Infants Seen in 2010 85 110 100 112 97 101 95 SO 209 91 256 257 90 96 297 8 9 10 15 16 15 13 22 13 41 37 14 50 55 50 24 117 37 115 21 3 17 5 17 16 6 19 8 50 47 161 85 253 115 105 110 114 ==bntnum 54 # 4 5 # 3 4 $ 6 * 6 & 5 6 8 & # # ; # # # # # # # # 3 # 7 17 16 17 17 45 16 15 41 13 69 41 21 274 107 10 97 255 90 116 62 56 106 50 17 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 41 42 43 . 18 278 227 541 128 94 258 39 80 17 45 13 124 115 01 84 113 91 243 517 575 111 257 100 93 261 54 39 79 15 4 24 244 54 18 15 14 41 8 7 47 41 19 38 3 39 8 23 6 5 13 20 19 7 5 18 17 100 24 23 9 45 46 47 48 49 50 91 30 256 233 98 75 14 14 41 38 16 129 122 50 38 116 110 51 20 10 5. In order to decide where to conduct the Potests, it is necessary to develop animation model The number of infants put on ARV theory is considered as the figure to because the initial paths to provide le putetea with the situation, the number of patients put on All therapy is the best and easiest way to me the performance. To formulate the model is necessary to make some motion 2. The number of infants taking the tests in the clinic will not change due to the POS proces b. General waiting time in during Pos will be 30 min. Al mothers will stay in the clinic to the collect results, so the collected sange number will be one to 100 t. Positively infants will be the same chance therapy process and POS d. There is no capacity limit of my clinic during the POS procent Therefore, by conducting the POS process is 20 out of so-clinic the structures will be the decentralizing and centralizing structure. As for clinics conducting the Pos tests decentraline structure, mothers can go directly to the diniset their interes tested and get the results, without sending samples to the central tab. Where other cinice will come previous proces collect samples and the other central and mothers to pick up the results Thus, in the objective formula, there will be parts DBS process. The romber of infants keeps the same in the al data POS process. The number of infants quals to the product of the rumbers of taste test sensitivity (95%) and probability of intents with positive results to receive Re Here, since the sensitivity of the Posters is not as good of positive diagnosed negative ones. Therefore it is necessary to comider the lo here. Alebo the assumption that the loss in the collection process will not be considered since there supposed to get results 30 min after tests.sono mothers will be without recieving the First, the total number of clinics which apply the POS process will be 20. Secondly, the cost of the www structure will not exceed the previousco Since the transportation som NGO in propose considered in the cost. In the cute con is divided to 2 parts. As for the POS process, the variable cose to the produce number of infants taking the test and werage cost per tests. Whereas the fed congue to the price of the recently acquired machines in case of the Des process, the costs here the same. in all, the optimization problem is While choosing the 20dinics De Gatos focus on several po Y-Either or to stands for a contro stands for conduct PC X-Infant put on the Z-Number of instants Seen P-Samolotive S-Sensitivity R-Infant put on therapy/samples positive collected "Cost per test of DBS 45 Laverage between 25-70 Transportation costs are ignored Cost per test of POC 11 average between 7-15 MaxXY SR St. Sum 20 C.*2*1*36*2*x+550202 According to the results solved by over, it can be concluded that the POS should be polied in Clinic 11.12.85.16.21.2426.27.21:29:35.36.37.23.40.43S 48.48. There Intants taking the therapy has been improved by over ons in our model and the cost is much lower than the previo model Although the result seem very good, the model is based on see sumptions which is much simple For sample the POS process may drive mother's motivation to better do the test since now mothers will not work for a very long time to put the result. The training process to conduct the new process as hobored and the machina tonsidered. Therefore, the model is not perfect and needs to consider montadion