Relative Reference

Product Category DepartmentPurchase PriceSale Price Profit/Loss

Dry Tissues Cleaning Supplies Household 120 135
Paper Towels Cleaning Supplies Household 125 135
Wet Wipes Cleaning Supplies Household 120 135
Chicken Dinner Frozen Foods Grocery 80 155
Clear Refresher Soft Drinks Grocery 165 100
Dried Grits Salty Snacks Grocery 180 100
Extra Nougat Candy Grocery 145 115
Athletic Drink Soft Drinks Grocery 75 155
Stew Frozen Foods Grocery 80 155
Jerky Salty Snacks Grocery 160 100
Dry Tissues Cleaning Supplies Household 168 100
Paper Towels Cleaning Supplies Household 90 155
Wet Wipes Cleaning Supplies Household 120 135
Chicken Dinner Frozen Foods Grocery 80 155
Clear Refresher Soft Drinks Grocery 165 100
Dried Grits Salty Snacks Grocery 180 100
Extra Nougat Candy Grocery 145 115
Athletic Drink Soft Drinks Grocery 175 100
Stew Frozen Foods Grocery 80 155
Jerky Salty Snacks Grocery 160 100
Dry Tissues Cleaning Supplies Household 159 115
Paper Towels Cleaning Supplies Household 168 100
Wet Wipes Cleaning Supplies Household 120 135
Chicken Dinner Frozen Foods Grocery 80 155
Clear Refresher Soft Drinks Grocery 165 100
Dried Grits Salty Snacks Grocery 180 100
Extra Nougat Candy Grocery 145 115
Athletic Drink Soft Drinks Grocery 75 155
Stew Frozen Foods Grocery 80 155
Jerky Salty Snacks Grocery 160 100
Dry Tissues Cleaning Supplies Household 125 135
Paper Towels Cleaning Supplies Household 189 100
Wet Wipes Cleaning Supplies Household 120 135
Chicken Dinner Frozen Foods Grocery 80 155
Clear Refresher Soft Drinks Grocery 165 100
Dried Grits Salty Snacks Grocery 180 100
Extra Nougat Candy Grocery 145 115
Athletic Drink Soft Drinks Grocery 159 115
Stew Frozen Foods Grocery 80 155
Jerky Salty Snacks Grocery 160 100
Dry Tissues Cleaning Supplies Household 180 100
Paper Towels Cleaning Supplies Household 190 75
Wet Wipes Cleaning Supplies Household 120 135
Chicken Dinner Frozen Foods Grocery 80 155
Clear Refresher Soft Drinks Grocery 165 100
Dried Grits Salty Snacks Grocery 180 100
Extra Nougat Candy Grocery 145 115
Athletic Drink Soft Drinks Grocery 170 100
Stew Frozen Foods Grocery 80 155
Jerky Salty Snacks Grocery 160 100
Dry Tissues Cleaning Supplies Household 180 100
Paper Towels Cleaning Supplies Household 190 75
Wet Wipes Cleaning Supplies Household 120 135
Chicken Dinner Frozen Foods Grocery 80 155
Clear Refresher Soft Drinks Grocery 165 100
Dried Grits Salty Snacks Grocery 180 100
Extra Nougat Candy Grocery 145 115
Athletic Drink Soft Drinks Grocery 175 100
Stew Frozen Foods Grocery 80 155
Jerky Salty Snacks Grocery 160 100
Dry Tissues Cleaning Supplies Household 160 100
Paper Towels Cleaning Supplies Household 190 75
Wet Wipes Cleaning Supplies Household 120 135
Chicken Dinner Frozen Foods Grocery 80 155
Clear Refresher Soft Drinks Grocery 165 100
Dried Grits Salty Snacks Grocery 180 100
Extra Nougat Candy Grocery 145 115
Athletic Drink Soft Drinks Grocery 175 100
Stew Frozen Foods Grocery 80 155
Jerky Salty Snacks Grocery 160 100
Dry Tissues Cleaning Supplies Household 160 100
Paper Towels Cleaning Supplies Household 190 75
Wet Wipes Cleaning Supplies Household 120 135
Chicken Dinner Frozen Foods Grocery 80 155
Clear Refresher Soft Drinks Grocery 165 100
Dried Grits Salty Snacks Grocery 180 100
Extra Nougat Candy Grocery 145 115
Athletic Drink Soft Drinks Grocery 175 100
Stew Frozen Foods Grocery 80 155
Jerky Salty Snacks Grocery 160 100
Dry Tissues Cleaning Supplies Household 160 100
Paper Towels Cleaning Supplies Household 190 75
Wet Wipes Cleaning Supplies Household 120 135
Chicken Dinner Frozen Foods Grocery 80 155
Clear Refresher Soft Drinks Grocery 165 100
Dried Grits Salty Snacks Grocery 180 100
Extra Nougat Candy Grocery 145 115
Athletic Drink Soft Drinks Grocery 175 100
Stew Frozen Foods Grocery 80 155
Jerky Salty Snacks Grocery 160 100
Dry Tissues Cleaning Supplies Household 160 100
Paper Towels Cleaning Supplies Household 190 75
Wet Wipes Cleaning Supplies Household 120 135
Chicken Dinner Frozen Foods Grocery 80 155
Clear Refresher Soft Drinks Grocery 165 100
Dried Grits Salty Snacks Grocery 180 100
Extra Nougat Candy Grocery 145 115
Athletic Drink Soft Drinks Grocery 175 100
Stew Frozen Foods Grocery 80 155
Jerky Salty Snacks Grocery 160 100
Absolute Reference
5%
Date Order Number Customer QuantityCategoryCode Unit Price GST
12/3/2017 1 Hindol Sinha 5 Suits W1 3200 160.00
12/5/2017 2 Dola Das 3 Coats H2 1250 62.50
12/10/2017 3 Deepak Sharma 4 Coats C4 1250 62.50
12/12/2017 4 Uma Nag 12 Ties T1 150 7.50
12/15/2017 5 Sayak Pal 6 Hats C1 99 4.95
12/20/2017 6 Srijan Das 10 Suits W1 3200 160.00
12/21/2017 7 Srijita Agarwal 5 Shoes H1 590 29.50
12/23/2017 8 Rina Karmakar 2 Hats S2 99 4.95
12/26/2017 9 Lily Roy 10 Ties T5 150 7.50
12/30/2017 10 Sonali Gupta 5 Shoes S2 590 29.50
12/3/2017 11 Deepali Srivastava 3 Suits W1 3200 160.00
12/5/2017 12 Rakhi 3 Coats H2 1250 62.50
12/10/2017 13 Deepak Chandra Fulara 4 Coats C4 1250 62.50
12/12/2017 14 Kavita Rawat 12 Ties T1 150 7.50
12/15/2017 15 Aakash Nagpal 6 Hats C1 99 4.95
12/20/2017 16 Ranit Chowdhury 10 Suits W1 3200 160.00
12/21/2017 17 Priya Shaw 5 Shoes H1 590 29.50
12/23/2017 18 Priya Shaw 2 Hats S2 99 4.95
12/26/2017 19 Nikhita Jain 10 Ties T5 150 7.50
12/30/2017 20 Sreyashi Paul 5 Shoes S2 590 29.50
12/3/2017 21 Ashu Dubey 15 Suits W1 3200 160.00
12/5/2017 22 Prerna Tomar 3 Coats H2 1250 62.50
12/10/2017 23 Ajay Kumar Mishra 4 Coats C4 1250 62.50
12/12/2017 24 Jaishree 12 Ties T1 150 7.50
12/15/2017 25 Jatinder Singh 6 Hats C1 99 4.95
12/20/2017 26 Shashi Kumar 10 Suits W1 3200 160.00
12/21/2017 27 Navdeep 5 Shoes H1 590 29.50
12/23/2017 28 Sadhana Saini 2 Hats S2 99 4.95
12/26/2017 29 Manish Gupta 10 Ties T5 150 7.50
12/30/2017 30 Ritika Prasher 5 Shoes S2 590 29.50
12/3/2017 31 Gurjinder Singh 18 Suits W1 3200 160.00
12/5/2017 32 Sweety Gupta 3 Coats H2 1250 62.50
12/10/2017 33 Radhe Prajapati 4 Coats C4 1250 62.50
12/12/2017 34 Sandipa Sarkar 12 Ties T1 150 7.50
12/15/2017 35 Joydev Halder 6 Hats C1 99 4.95
12/20/2017 36 Sumanta Das 10 Suits W1 3200 160.00
12/21/2017 37 Dipan Paul 5 Shoes H1 590 29.50
12/23/2017 38 Dipan Paul 2 Hats S2 99 4.95
12/26/2017 39 Biswajit Mahata 10 Ties T5 150 7.50
12/30/2017 40 Amit Samanta 5 Shoes S2 590 29.50
12/3/2017 41 Raj Dutta 25 Suits W1 3200 160.00
12/5/2017 42 Anshu Kumari 3 Coats H2 1250 62.50
12/10/2017 43 Pallabi Guha 4 Coats C4 1250 62.50
12/12/2017 44 Arup Kumar Banik 12 Ties T1 150 7.50
12/15/2017 45 Sayan Das Sarkar 6 Hats C1 99 4.95
12/20/2017 46 Chenithung J Kikon 10 Suits W1 3200 160.00
12/21/2017 47 Pritam Singh Saha 5 Shoes H1 590 29.50
12/23/2017 48 Hena Biswas 2 Hats S2 99 4.95
12/26/2017 49 Raeesah Tamboli 10 Ties T5 150 7.50
12/30/2017 50 Rupali Bhise 5 Shoes S2 590 29.50
12/3/2017 51 Deepak Kumar Chaurasiya3 Suits W1 3200 160.00
12/5/2017 52 Pragati Sawant 3 Coats H2 1250 62.50
12/10/2017 53 Savita Ghotane 4 Coats C4 1250 62.50
12/12/2017 54 Sibaram Padhi 12 Ties T1 150 7.50
12/15/2017 55 Aparna Ghosh 6 Hats C1 99 4.95
12/20/2017 56 Akram Hossain 10 Suits W1 3200 160.00
12/21/2017 57 Ramesh Chandra Das 5 Shoes H1 590 29.50
12/23/2017 58 Puja Jana 2 Hats S2 99 4.95
12/26/2017 59 Abhijeet Agarwal 10 Ties T5 150 7.50
12/30/2017 60 Divya Bharti 5 Shoes S2 590 29.50
12/3/2017 61 Amit Butola 5 Suits W1 3200 160.00
12/5/2017 62 Mohit Singh 3 Coats H2 1250 62.50
12/10/2017 63 Pramod Rawat 4 Coats C4 1250 62.50
12/12/2017 64 Neeraj Upadhyay 12 Ties T1 150 7.50
12/15/2017 65 Ram Balak Sharma 6 Hats C1 99 4.95
12/20/2017 66 Amit Chauhan 10 Suits W1 3200 160.00
12/21/2017 67 Pushkal Aggarwal 5 Shoes H1 590 29.50
12/23/2017 68 Pooja 2 Hats S2 99 4.95
12/26/2017 69 Prabhjeet Kaur Sachdeva10 Ties T5 150 7.50
12/30/2017 70 Roshni Gupta 5 Shoes S2 590 29.50
12/3/2017 71 Sahil Husain Naik 8 Suits W1 3200 160.00
12/5/2017 72 Trupti Parab 3 Coats H2 1250 62.50
12/10/2017 73 Avijit Pratihar 4 Coats C4 1250 62.50
12/12/2017 74 Nidhi Yadav 12 Ties T1 150 7.50
12/15/2017 75 Preet Baid 6 Hats C1 99 4.95
12/20/2017 76 Sudipta Pattanayak 10 Suits W1 3200 160.00
12/21/2017 77 Pooja Pandey 5 Shoes H1 590 29.50
12/23/2017 78 Akash Goel 2 Hats S2 99 4.95
12/26/2017 79 Kamini Barmecha 10 Ties T5 150 7.50
12/30/2017 80 Deblina Ghatak 5 Shoes S2 590 29.50
Amount

=
Relative, Absolute & Mixed R

3. Mixed Refe
Table
2
4
6
8
10
12
e & Mixed Reference

=$C8*D$7
2 5
4 10
8 20
12 30
16 40
20 50
24 60
10 15
20 30
40 60
60 90
80 120
100 150
120 180
20
40
80
120
160
200
240
 Year 2019
Sales Person wise Monthly Target

Mixed Cell reference 2% 3% 4% 5% 6%

Sales Person Target JanuaryFebruary March April May
Jinia Ghosh 164506 3290.12 4935.18 6580.24 8225.3 9870.36
Alok Kundu 186343 3726.86 5590.29 7453.72 9317.15 11180.58
Soham Das 155543 3110.86 4666.29 6221.72 7777.15 9332.58
Sandip Jana 101719 2034.38 3051.57 4068.76 5085.95 6103.14
Nilay Guha 192612 3852.24 5778.36 7704.48 9630.6 11556.72
Mrinal Kayal 198205 3964.1 5946.15 7928.2 9910.25 11892.3
Keya Barman 160259 3205.18 4807.77 6410.36 8012.95 9615.54
Joy Saha 102034 2040.68 3061.02 4081.36 5101.7 6122.04
Mithun Chaudhury 167168 3343.36 5015.04 6686.72 8358.4 10030.08
Manas Das 136425 2728.5 4092.75 5457 6821.25 8185.5
Jinia Ghosh 105123 2102.46 3153.69 4204.92 5256.15 6307.38
Alok Kundu 103627 2072.54 3108.81 4145.08 5181.35 6217.62
Soham Das 135386 2707.72 4061.58 5415.44 6769.3 8123.16
Sandip Jana 114934 2298.68 3448.02 4597.36 5746.7 6896.04
Nilay Guha 142060 2841.2 4261.8 5682.4 7103 8523.6
Mrinal Kayal 160959 3219.18 4828.77 6438.36 8047.95 9657.54
Keya Barman 184337 3686.74 5530.11 7373.48 9216.85 11060.22
Joy Saha 183237 3664.74 5497.11 7329.48 9161.85 10994.22
Mithun Chaudhury 194040 3880.8 5821.2 7761.6 9702 11642.4
Manas Das 111377 2227.54 3341.31 4455.08 5568.85 6682.62
Jinia Ghosh 139512 2790.24 4185.36 5580.48 6975.6 8370.72
Alok Kundu 126653 2533.06 3799.59 5066.12 6332.65 7599.18
Soham Das 138233 2764.66 4146.99 5529.32 6911.65 8293.98
Sandip Jana 118987 2379.74 3569.61 4759.48 5949.35 7139.22
Nilay Guha 107527 2150.54 3225.81 4301.08 5376.35 6451.62
Mrinal Kayal 154351 3087.02 4630.53 6174.04 7717.55 9261.06
Keya Barman 149181 2983.62 4475.43 5967.24 7459.05 8950.86
Joy Saha 178276 3565.52 5348.28 7131.04 8913.8 10696.56
Mithun Chaudhury 118363 2367.26 3550.89 4734.52 5918.15 7101.78
Manas Das 131477 2629.54 3944.31 5259.08 6573.85 7888.62
Jinia Ghosh 142257 2845.14 4267.71 5690.28 7112.85 8535.42
Alok Kundu 134646 2692.92 4039.38 5385.84 6732.3 8078.76
Soham Das 131222 2624.44 3936.66 5248.88 6561.1 7873.32
Sandip Jana 141003 2820.06 4230.09 5640.12 7050.15 8460.18
Nilay Guha 157889 3157.78 4736.67 6315.56 7894.45 9473.34
Mrinal Kayal 148490 2969.8 4454.7 5939.6 7424.5 8909.4
Keya Barman 138410 2768.2 4152.3 5536.4 6920.5 8304.6
Joy Saha 140050 2801 4201.5 5602 7002.5 8403
Mithun Chaudhury 141354 2827.08 4240.62 5654.16 7067.7 8481.24
Manas Das 143333 2866.66 4299.99 5733.32 7166.65 8599.98
Jinia Ghosh 113682 2273.64 3410.46 4547.28 5684.1 6820.92
Alok Kundu 134037 2680.74 4021.11 5361.48 6701.85 8042.22
Soham Das 174818 3496.36 5244.54 6992.72 8740.9 10489.08
Sandip Jana 149283 2985.66 4478.49 5971.32 7464.15 8956.98
Nilay Guha 151359 3027.18 4540.77 6054.36 7567.95 9081.54
Mrinal Kayal 190571 3811.42 5717.13 7622.84 9528.55 11434.26
Keya Barman 102805 2056.1 3084.15 4112.2 5140.25 6168.3
Joy Saha 105418 2108.36 3162.54 4216.72 5270.9 6325.08
Mithun Chaudhury 199939 3998.78 5998.17 7997.56 9996.95 11996.34
Manas Das 107013 2140.26 3210.39 4280.52 5350.65 6420.78
Jinia Ghosh 118506 2370.12 3555.18 4740.24 5925.3 7110.36
Alok Kundu 185199 3703.98 5555.97 7407.96 9259.95 11111.94
Soham Das 114961 2299.22 3448.83 4598.44 5748.05 6897.66
Sandip Jana 131029 2620.58 3930.87 5241.16 6551.45 7861.74
Nilay Guha 146620 2932.4 4398.6 5864.8 7331 8797.2
Mrinal Kayal 185327 3706.54 5559.81 7413.08 9266.35 11119.62
Keya Barman 182312 3646.24 5469.36 7292.48 9115.6 10938.72
Joy Saha 106916 2138.32 3207.48 4276.64 5345.8 6414.96
Mithun Chaudhury 196375 3927.5 5891.25 7855 9818.75 11782.5
Manas Das 114909 2298.18 3447.27 4596.36 5745.45 6894.54
Jinia Ghosh 176011 3520.22 5280.33 7040.44 8800.55 10560.66
Alok Kundu 106949 2138.98 3208.47 4277.96 5347.45 6416.94
Soham Das 129636 2592.72 3889.08 5185.44 6481.8 7778.16
Sandip Jana 195668 3913.36 5870.04 7826.72 9783.4 11740.08
Nilay Guha 168664 3373.28 5059.92 6746.56 8433.2 10119.84
Mrinal Kayal 197422 3948.44 5922.66 7896.88 9871.1 11845.32
Keya Barman 107315 2146.3 3219.45 4292.6 5365.75 6438.9
Joy Saha 157633 3152.66 4728.99 6305.32 7881.65 9457.98
Mithun Chaudhury 195513 3910.26 5865.39 7820.52 9775.65 11730.78
Manas Das 103593 2071.86 3107.79 4143.72 5179.65 6215.58
Jinia Ghosh 176518 3530.36 5295.54 7060.72 8825.9 10591.08
Alok Kundu 135041 2700.82 4051.23 5401.64 6752.05 8102.46
Soham Das 131005 2620.1 3930.15 5240.2 6550.25 7860.3
Sandip Jana 145782 2915.64 4373.46 5831.28 7289.1 8746.92
Nilay Guha 138861 2777.22 4165.83 5554.44 6943.05 8331.66
Mrinal Kayal 180015 3600.3 5400.45 7200.6 9000.75 10800.9
Keya Barman 112589 2251.78 3377.67 4503.56 5629.45 6755.34
Joy Saha 199809 3996.18 5994.27 7992.36 9990.45 11988.54
Mithun Chaudhury 182903 3658.06 5487.09 7316.12 9145.15 10974.18
Manas Das 132305 2646.1 3969.15 5292.2 6615.25 7938.3
Jinia Ghosh 198607 3972.14 5958.21 7944.28 9930.35 11916.42
Alok Kundu 105812 2116.24 3174.36 4232.48 5290.6 6348.72
Soham Das 112136 2242.72 3364.08 4485.44 5606.8 6728.16
Sandip Jana 179230 3584.6 5376.9 7169.2 8961.5 10753.8
Nilay Guha 163382 3267.64 4901.46 6535.28 8169.1 9802.92
Mrinal Kayal 118303 2366.06 3549.09 4732.12 5915.15 7098.18
Keya Barman 199881 3997.62 5996.43 7995.24 9994.05 11992.86
Joy Saha 106006 2120.12 3180.18 4240.24 5300.3 6360.36
Mithun Chaudhury 125024 2500.48 3750.72 5000.96 6251.2 7501.44
Manas Das 177905 3558.1 5337.15 7116.2 8895.25 10674.3
Jinia Ghosh 179837 3596.74 5395.11 7193.48 8991.85 10790.22
Alok Kundu 180766 3615.32 5422.98 7230.64 9038.3 10845.96
Soham Das 116796 2335.92 3503.88 4671.84 5839.8 7007.76
Sandip Jana 146233 2924.66 4386.99 5849.32 7311.65 8773.98
 7% 8% 9%
June July August
11515.42 13160.48 14805.54
13044.01 14907.44 16770.87
10888.01 12443.44 13998.87
7120.33 8137.52 9154.71
13482.84 15408.96 17335.08
13874.35 15856.4 17838.45
11218.13 12820.72 14423.31
7142.38 8162.72 9183.06
11701.76 13373.44 15045.12
9549.75 10914 12278.25
7358.61 8409.84 9461.07
7253.89 8290.16 9326.43
9477.02 10830.88 12184.74
8045.38 9194.72 10344.06
9944.2 11364.8 12785.4
11267.13 12876.72 14486.31
12903.59 14746.96 16590.33
12826.59 14658.96 16491.33
13582.8 15523.2 17463.6
7796.39 8910.16 10023.93
9765.84 11160.96 12556.08
8865.71 10132.24 11398.77
9676.31 11058.64 12440.97
8329.09 9518.96 10708.83
7526.89 8602.16 9677.43
10804.57 12348.08 13891.59
10442.67 11934.48 13426.29
12479.32 14262.08 16044.84
8285.41 9469.04 10652.67
9203.39 10518.16 11832.93
9957.99 11380.56 12803.13
9425.22 10771.68 12118.14
9185.54 10497.76 11809.98
9870.21 11280.24 12690.27
11052.23 12631.12 14210.01
10394.3 11879.2 13364.1
9688.7 11072.8 12456.9
9803.5 11204 12604.5
9894.78 11308.32 12721.86
10033.31 11466.64 12899.97
7957.74 9094.56 10231.38
9382.59 10722.96 12063.33
12237.26 13985.44 15733.62
10449.81 11942.64 13435.47
10595.13 12108.72 13622.31
13339.97 15245.68 17151.39
7196.35 8224.4 9252.45
7379.26 8433.44 9487.62
13995.73 15995.12 17994.51
7490.91 8561.04 9631.17
8295.42 9480.48 10665.54
12963.93 14815.92 16667.91
8047.27 9196.88 10346.49
9172.03 10482.32 11792.61
10263.4 11729.6 13195.8
12972.89 14826.16 16679.43
12761.84 14584.96 16408.08
7484.12 8553.28 9622.44
13746.25 15710 17673.75
8043.63 9192.72 10341.81
12320.77 14080.88 15840.99
7486.43 8555.92 9625.41
9074.52 10370.88 11667.24
13696.76 15653.44 17610.12
11806.48 13493.12 15179.76
13819.54 15793.76 17767.98
7512.05 8585.2 9658.35
11034.31 12610.64 14186.97
13685.91 15641.04 17596.17
7251.51 8287.44 9323.37
12356.26 14121.44 15886.62
9452.87 10803.28 12153.69
9170.35 10480.4 11790.45
10204.74 11662.56 13120.38
9720.27 11108.88 12497.49
12601.05 14401.2 16201.35
7881.23 9007.12 10133.01
13986.63 15984.72 17982.81
12803.21 14632.24 16461.27
9261.35 10584.4 11907.45
13902.49 15888.56 17874.63
7406.84 8464.96 9523.08
7849.52 8970.88 10092.24
12546.1 14338.4 16130.7
11436.74 13070.56 14704.38
8281.21 9464.24 10647.27
13991.67 15990.48 17989.29
7420.42 8480.48 9540.54
8751.68 10001.92 11252.16
12453.35 14232.4 16011.45
12588.59 14386.96 16185.33
12653.62 14461.28 16268.94
8175.72 9343.68 10511.64
10236.31 11698.64 13160.97