InstructionsKey Instructions1. The excel file has two sheets for each Product. The First sheet has details of current years sales of all existing Distributors. You have to enter the expected sales for Feb & Mar15 to arrive at the FY expected Sales. Against this give the target for the Next Year for each Distributor.2. Please do not change the format or wrap text or Merge & centre, this will disturb the alignment and give incorrect totals. Kindly fill in details of Columns highlighted in yellow only.3. In Sheet 2 of a product you will have to give the month wise spilt of the Annual Target of each Distributor. There are some checks in this sheet. Each months target should not be less than 7% of Annual Target. Also, quarterly target limits in %age have been fixed. This is in order to ensure a fair split across months. Target should be minimum Q1 21%; Q2 23%; Q3 25%; Q4 26% 4. In Sheet 1 & 2 of each Product, in the top rows, you will see names of existing Distributors with all details. In the rows at the bottom, we have kept them vacant so that you can fill in the details of New Distributors you are planning to appoint in Uncovered District HQ Towns and major towns. in Sheet1, you will give targets of new distributors plan to be appoited in Feb & Mar'15. These distributors as well as the other distributors you are planning to apppoint in Apr or May has to be mentioned and targets given to them.5. In case of any existing Distributor who has been appointed in the middle of this year, the targets should be worked out on basis of average monthly sales for the months that the Distributor worked and apportioned for the Full Year.6. In case of any existing Distributor doing less than Rs 3 lakhs average monthly sales, you are supposed to tag such a Distributor to a nearby Distributor. In such a case the Target given to the latter should be on the Total of both. For eg, If Party A is doing Rs 5 lakhs per month and party B is doing Rs 1.5 lakhs per month and you have decided to tag party B to party A as you feel the party B does not have the capacity to increase the sales to Rs 3 lakhs per month, then party As target should be Rs 5 + Rs 1.5 lakhs = Rs 6.5 lakhs + 30% i.e. Rs 8.45 lakhs per month. This should be mentioned in the Remarks Column.7. If you want to change the mapping of any Distributor to any BDE/M, you may do so, please highlight such changes in green. At CSO we will make necessary changes.8. In case of a new territory/BDE HQ which is vacant at the moment, instead of the BDE/M name, please mention Vacant.9. Mr Atul Dixit will be shortly sending each one of you the State wise, district wise towns and population details. Please refer to that for mentioning required details in the format.10. The last column in sheet2 of each product is the difference between annual target and total of the monthly target. If the difference is negative numbers, it indicates total of all months is more than the annual target. If it is a positive numbers, it indicates the total of all months is less than the annual target. In both cases, you should make corrections to monthly figures. It should be ZERO.

CPVC1CPVC TARGET FOR 2015-162014-15Rs.in LacsSalesperson NameHead QuarterDivisionDistrictCity/ TownCity PopulationCustomer NameCustomer CodeApr-Jan ActualFeb ExpectedMar ExpectedTotal2015-16 TargetGLYALLWYN D'SOUZAGOAGOAPANAJIS.N TRADERS-PANAJI22025820.695.008.0033.6975.00123%ALLWYN D'SOUZAGOAGOAPANJIMSHANTA DURGA ENTERPRISES - PANJIM25950428.883.005.0036.8855.0049%ALLWYN D'SOUZAGOANORTH GOAMAPUSALAXMI ENTERPRISES - MAPUSA25008225.635.007.0037.6365.0073%ALLWYN D'SOUZAGOASOUTH GOAMARGAOAUDHUT . P . KARE - MARGOA2595010.0ALLWYN D'SOUZAGOASOUTH GOAPONDAS.B.S. ENTERPRISES - SOUTH GOA2202662.503.005.5035.00536%New Distributors0.00.00.00.00.00.00.00.00.00.00.00.0

CPVC2CPVC TARGET FOR 2015-16Every month value should not be < 7% of total targetTarget should be minimum Q1>21%; Q2>23%; Q3>25%; Q4>26% Rs.in LacsSalesperson NameHead QuarterDivisionDistrictCity/ TownCity PopulationCustomer NameCustomerCode15-16 TargetApr'15May'15Jun'15Q1Jul'15Aug'15Sep'15Q2Oct'15Nov'15Dec'15Q3Jan'16Feb'16Mar'16Q4TotalDifferenceALLWYN D'SOUZA0GOAGOAPANAJI0S.N TRADERS-PANAJI22025875.000000075.00ALLWYN D'SOUZA0GOAGOAPANJIM0SHANTA DURGA ENTERPRISES - PANJIM25950455.000000055.00ALLWYN D'SOUZA0GOANORTH GOAMAPUSA0LAXMI ENTERPRISES - MAPUSA25008265.000000065.00ALLWYN D'SOUZA0GOASOUTH GOAMARGAO0AUDHUT . P . KARE - MARGOA2595010.0000000.0ALLWYN D'SOUZA0GOASOUTH GOAPONDA0S.B.S. ENTERPRISES - SOUTH GOA22026635.000000035.00New Distributors000000000.0000000.0000000000.0000000.0000000000.0000000.0000000000.0000000.0000000000.0000000.0000000000.0000000.0000000000.0000000.0000000000.0000000.0000000000.0000000.0000000000.0000000.0000000000.0000000.0000000000.0000000.0

AQUA1AQUA TARGET FOR 2015-162014-15Rs.in LacsSalesperson NameHead QuarterDivisionDistrictCity/ TownCity PopulationCustomer NameCustomer CodeApr-Jan ActualFeb ExpectedMar ExpectedTotal2015-16 TargetGLYALLWYN D'SOUZAGOAGOAPANAJIS.N TRADERS-PANAJI2202588.796.006.0020.7950.00141%ALLWYN D'SOUZAGOAGOAPANJIMSHANTA DURGA ENTERPRISES - PANJIM2595042.330.501.003.8310.00161%ALLWYN D'SOUZAGOANORTH GOAMAPUSALAXMI ENTERPRISES - MAPUSA2500824.370.100.504.9710.00101%ALLWYN D'SOUZAGOASOUTH GOAMARGAOAUDHUT . P . KARE - MARGOA2595010.0ALLWYN D'SOUZAGOASOUTH GOAPONDAS.B.S. ENTERPRISES - SOUTH GOA2202661.002.003.0025.00733%New Distributors0.00.00.00.00.00.00.00.00.00.00.00.0

AQUA2AQUA TARGET FOR 2015-16Every month value should not be < 7% of total targetTarget should be minimum Q1>21%; Q2>23%; Q3>25%; Q4>26% Rs.in LacsSalesperson NameHead QuarterDivisionDistrictCity/ TownCity PopulationCustomer NameCustomerCode15-16 TargetApr'15May'15Jun'15Q1Jul'15Aug'15Sep'15Q2Oct'15Nov'15Dec'15Q3Jan'16Feb'16Mar'16Q4TotalDifferenceALLWYN D'SOUZA0GOAGOAPANAJI0S.N TRADERS-PANAJI22025850.003.53.53.510.53.93.93.911.74.54.54.513.54.74.74.914.3500.0ALLWYN D'SOUZA0GOAGOAPANJIM0SHANTA DURGA ENTERPRISES - PANJIM25950410.000.70.70.72.10.80.80.82.40.90.90.92.70.90.950.952.8100.0ALLWYN D'SOUZA0GOANORTH GOAMAPUSA0LAXMI ENTERPRISES - MAPUSA25008210.000.70.70.72.10.80.80.82.40.90.90.92.70.90.950.952.8100.0ALLWYN D'SOUZA0GOASOUTH GOAMARGAO0AUDHUT . P . KARE - MARGOA2595010.0000000.0ALLWYN D'SOUZA0GOASOUTH GOAPONDA0S.B.S. ENTERPRISES - SOUTH GOA22026625.001.81.81.85.422262.22.22.36.72.32.32.36.9250.0New Distributors000000000.0000000.0000000000.0000000.0000000000.0000000.0000000000.0000000.0000000000.0000000.0000000000.0000000.0000000000.0000000.0000000000.0000000.0000000000.0000000.0000000000.0000000.0000000000.0000000.0000000000.0000000.0

SWR1SWR TARGET FOR 2015-162014-15Rs.in LacsSalesperson NameHead QuarterDivisionDistrictCity/ TownCity PopulationCustomer NameCustomer CodeApr-Jan ActualFeb ExpectedMar ExpectedTotal2015-16 TargetGLYALLWYN D'SOUZAGOAGOAPANAJIS.N TRADERS-PANAJI2202587.705.005.0017.7040.00126%ALLWYN D'SOUZAGOAGOAPANJIMSHANTA DURGA ENTERPRISES - PANJIM2595041.130.100.501.734.00131%ALLWYN D'SOUZAGOANORTH GOAMAPUSALAXMI ENTERPRISES - MAPUSA2500820.070.00.500.572.00251%ALLWYN D'SOUZAGOASOUTH GOAMARGAOAUDHUT . P . KARE - MARGOA2595010.0ALLWYN D'SOUZAGOASOUTH GOAPONDAS.B.S. ENTERPRISES - SOUTH GOA2202660.04.00New Distributors0.00.00.00.00.00.00.00.00.00.00.00.0

SWR2SWR TARGET FOR 2015-16Every month value should not be < 7% of total target Target should be minimum Q1>21%; Q2>23%; Q3>25%; Q4>26% Rs.in LacsSalesperson NameHead QuarterDivisionDistrictCity/ TownCity PopulationCustomer NameCustomerCode15-16 TargetApr'15May'15Jun'15Q1Jul'15Aug'15Sep'15Q2Oct'15Nov'15Dec'15Q3Jan'16Feb'16Mar'16Q4TotalDifferenceALLWYN D'SOUZA0GOAGOAPANAJI0S.N TRADERS-PANAJI22025840.0033393.253.253.259.753.53.53.510.53.53.53.7510.75400.0ALLWYN D'SOUZA0GOAGOAPANJIM0SHANTA DURGA ENTERPRISES - PANJIM2595044.000.30.30.30.90.330.330.3410.350.350.351.050.350.350.351.0540.0ALLWYN D'SOUZA0GOANORTH GOAMAPUSA0LAXMI ENTERPRISES - MAPUSA2500822.000.150.150.150.450.160.160.160.480.170.170.170.510.180.180.20.5620.0ALLWYN D'SOUZA0GOASOUTH GOAMARGAO0AUDHUT . P . KARE - MARGOA2595010.0000000.0ALLWYN D'SOUZA0GOASOUTH GOAPONDA0S.B.S. ENTERPRISES - SOUTH GOA2202664.000.30.30.30.90.330.330.330.990.350.350.351.050.350.350.361.0640.0New Distributors000000000.0000000.0000000000.0000000.0000000000.0000000.0000000000.0000000.0000000000.0000000.0000000000.0000000.0000000000.0000000.0000000000.0000000.0000000000.0000000.0000000000.0000000.0000000000.0000000.0000000000.0000000.0

TOTALTOTAL TARGET FOR 2015-162014-15Salesperson NameHead QuarterDistrictCity/ TownCustomer CodeCustomer NameApr-Jan ActualFeb ExpectedMar ExpectedTotal2015-16 TargetGLYGANJIHAL B SBangaloreBANGALOREBANGALORE210001A.S.TRADING CO-BANGALORE37.1716.0019.0072.17165.00128.62%GANJIHAL B SBangaloreBANGALOREBIJAPUR210002ARIHANT MARKETING- BIJAPUR32.343.606.5042.4469.0062.60%PANDAPPA LAKAPPA B PATILBangaloreBIJAPURBIJAPUR210003ASSOCIATED TRADERS - BIJAPURERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!JOSEPHBangaloreTNBANGALORE210006M.P.CERAMICS- BANGALORE25.635.007.0037.6365.0072.73%JOSEPHBangaloreTNBANGALORE210007MAHADURGA PIPE CENTRE-BANGALORE0.01.002.003.0029.00866.67%JOGAPPA KBangaloreBANGALORE URBANBANGALORE210010SAXENA & CO-BANGALOREERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!ERROR:#REF!

TOTAL1TOTAL TARGET FOR 2015-16Every month value should not be