Spreadsheet: 820431d1678107504-excel-formula-for-inflation-adjusted-amounts-inflation-adjusted
Sheet: Sheet2

 |  |  | Kindly asking for excel formula for Inflation adjusted amounts  using inflation rate and conversion factor as shown in the desired solution - inflation adjusted columns
 |  |  |  |  |  |  | Desired Solution
 | Monrh | Indices | Inflation rate | Conversion factors |  |  | Historical | Inflation Adjusted | Historical | Inflation Adjusted | Historical | Inflation Adjusted | Historical | Inflation Adjusted | Historical | Inflation Adjusted | Historical | Inflation Adjusted | Historical | Inflation Adjusted | Historical | Inflation Adjusted | Historical | Inflation Adjusted | Historical | Inflation Adjusted | Historical | Inflation Adjusted | Historical | Inflation Adjusted
 | 2021-12-01 00:00:00 | 2474.51 | 4.22 | 1.61 |  |  | 2022-01-01 00:00:00 |  | 2022-02-01 00:00:00 |  | 2022-03-01 00:00:00 |  | 2022-04-01 00:00:00 |  | 2022-05-01 00:00:00 |  | 2022-06-01 00:00:00 |  | 2022-07-01 00:00:00 |  | 2022-08-01 00:00:00 |  | 2022-09-01 00:00:00 |  | 2022-10-01 00:00:00 |  | 2022-11-01 00:00:00 |  | 2022-12-01 00:00:00
 | 2022-01-01 00:00:00 | 2608.79 | 5.43 | 1.52 |  | Retained Income / (Accumulated Loss) | 2618350
 | 2022-02-01 00:00:00 | 2698.89 | 3.45 | 1.47 |  | Revaluation Reserve | -6608757
 | 2022-03-01 00:00:00 | 2759.83 | 2.26 | 1.44 |  | Agri bank Loan (USD) |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -64000000
 | 2022-04-01 00:00:00 | 2803.57 | 1.58 | 1.42 |  | AGRIBANK LOAN | -5223589 |  | 914999.61 |  | 416666.67 |  | 416666.67 |  | 416666.67 |  | 422167.37 |  | 333018.45 |  | 363199.18 |  | 661426.78 |  | 1031397.73 |  | 1909328.65 |  | 2889777.26
 | 2022-05-01 00:00:00 | 2874.85 | 2.54 | 1.38 |  | BICC SCHOOLS OFFICE |  |  |  |  | -860000 |  | 120000 |  |  |  | 175000 |  |  |  | -2450000 |  | 700000 |  | -14000000 |  | 7975000 |  | 2040000
 | 2022-06-01 00:00:00 | 2986.44 | 3.88 | 1.33 |  | Accumulated depreciation | 0
 | 2022-07-01 00:00:00 | 3062.93 | 2.56 | 1.3 |  | Motor Vehicles - @ Valuation | 2170000
 | 2022-08-01 00:00:00 | 3191.19 | 4.19 | 1.25 |  | Depreciation | 0
 | 2022-09-01 00:00:00 | 3342.02 | 4.73 | 1.19 |  | Computer Equipment - Valuation | 2972958 |  | 34000 |  | 144423.88 |  | 26400 |  |  |  | 133000 |  | 52000 |  | 105000 |  | 224000 |  | 351000
 | 2022-10-01 00:00:00 | 3555.9 | 6.4 | 1.12 |  | Depreciation | 0
 | 2022-11-01 00:00:00 | 3760.86 | 5.76 | 1.06 |  | Office Equipment - @  Valuation | 1267770 |  |  |  |  |  |  |  | 7000 |  |  |  |  |  | 139400
 | 2022-12-01 00:00:00 | 3977.46 | 5.76 | 1 |  | Depreciation | 0
 |  |  |  |  |  | Furniture & Fittings - @ Valuation | 1636609 |  |  |  | 67080 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 796000
 |  |  |  |  |  | Depreciation | 0
 |  |  |  |  |  | Other Fixed Assets - @ Valuation | 18800
 |  |  |  |  |  | Depreciation | 0
 |  |  |  |  |  | Listed Shares - @ Valuation | 3845
 |  |  |  |  |  | Inventory Control Account | 4441631 |  |  |  |  |  |  |  |  |  |  |  |  |  | 12373631.83 |  | 944359.7474 |  | 1978600.885 |  | 15513755.666 |  | 41831997.93
 |  |  |  |  |  | Customer Control Account |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 7107180.02 |  | 11177307.91 |  | 14033992.86 |  | 29892448.14 |  | -58118907.43
 |  |  |  |  |  | Staff Loans |  |  | 60000 |  |  |  | -30000 |  | 315000 |  | 240000 |  | -240000 |  | -210000 |  | 44800 |  | -240000 |  | 80000 |  | 565200
 |  |  |  |  |  | ALL POS FOREX |  |  |  |  |  |  |  |  |  |  |  |  | 1002.03 |  | -18770.56 |  | -16698452.89 |  | 2549824.42 |  | 1931265.61 |  | 14378251.59
 |  |  |  |  |  | Z B BANK 405 | 13894.6 |  | 98926 |  | 945322.5502 |  | 1913327.4 |  | 8321776.7311 |  | 2877998.3038 |  | 4429008.1716 |  | 774110.2 |  | 23419639.2663 |  | 12578138.7454 |  | -537731.51 |  | -54715610.46
 |  |  |  |  |  | Z B BANK 200 | 241231.94 |  | 1232244.6 |  | -1038781.31 |  | -80740.54 |  | -321319.92 |  | 166232.1062 |  | -131784.81 |  | -28749.17 |  | 32977.3041 |  | 673857.1246 |  | -483471.21 |  | -203386.66
 |  |  |  |  |  | Z B BANK 406 |  |  |  |  |  |  |  |  | 365495.37 |  | 907996.5 |  | 875871.52 |  | 1103477.85 |  | 2654987.46 |  | 953582.07 |  | 1629960.11 |  | -8140433.38
 |  |  |  |  |  | AGRIBANK 569 | 81787.61 |  | 133141.57 |  | -44566.29 |  | 371039.93 |  | 67817.17 |  | 138434.3 |  | -774361.52 |  | 776382.21 |  | 18395856.63 |  | 1945204.51 |  | 491817.49 |  | -20852461.34
 |  |  |  |  |  | AGRIBANK 828 | 1681.12 |  | -3244.1 |  | 3265.24 |  | 6747.24 |  | 4217.24 |  | 67763.48 |  | 85320.67 |  | -163416.76 |  | -1282.76 |  | 27835.0088 |  | 42598.4876 |  | 37287.3473
 |  |  |  |  |  | CASH USD | 7159.93 |  | 58848 |  | -1833404 |  | -2346738 |  | -7009250 |  | -2727273 |  | -6370818 |  | 1710521 |  | -24756848 |  | -6077700 |  | -22779335.2 |  | 73489300.2989
 |  |  |  |  |  | CASH RAND | -35740.63 |  | 21780 |  | 13540 |  | -20437.5 |  | -290958.26 |  | -970434 |  | -716544 |  | -408092.25 |  | -1871564.06 |  | -617998.19 |  | -2193574.65 |  | 7457471.9109
 |  |  |  |  |  | CASH ZWL | 9403.97 |  | -2962.15 |  | 42274.33 |  | -9798.59 |  | -914.24 |  | -12630.74 |  | -11638.14 |  | 38276.34 |  | 203859.46 |  | 214640.6 |  | 107482.2 |  | -392805.92
 |  |  |  |  |  | AGRIBANK  USD 087 |  |  |  |  |  |  |  |  |  |  |  |  | -3500 |  | -3500 |  | -3500 |  | 1751578.0912 |  | 15492217.7524 |  | -15129590.85
 |  |  |  |  |  | Bank Transfer | 40000 |  |  |  |  |  | 31900 |  |  |  |  |  |  |  |  |  | -0.0239 |  | -0.01 |  |  |  | -0.01
 |  |  |  |  |  | Supplier Control Account | 219109.81 |  |  |  |  |  |  |  |  |  |  |  |  |  | -9876064.79 |  | -14533714.26 |  | -7135053.77 |  | 2056344.56 |  | -10435085.89
 |  |  |  |  |  | GRN Accrual Account |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -111650 |  | -161103 |  | -22082.97 |  | 258422
 |  |  |  |  |  | Acruals  - Staff allowances | -207500 |  | 191000 |  | -30000 |  | 67200 |  |  |  | -33200 |  | -913600 |  | -351758 |  | -161000 |  | 124500 |  | 62550 |  | 1251808
 |  |  |  |  |  | PAYE Control Account | 183028.96 |  | 33391.08 |  | -66729.18 |  | -45239.12 |  | -129678.66 |  | -147705.11 |  | 78128.35 |  | 29314.16 |  | 241233.95 |  | -330087.63 |  | -421319.47 |  | -456180.74
 |  |  |  |  |  | NSSA Control Account | -40978.4 |  | 196782.13 |  | -9803.78 |  | -14093.85 |  | -24739.71 |  | -108460.89 |  | -9187.61 |  | -142572.19 |  | -148701.6 |  | 108736.66 |  | -254416.27 |  | -192577.57
 |  |  |  |  |  | loan interest accrual | -1444166.67 |  | 236805.56 |  | 194444.44 |  | 193750 |  | 166666.67 |  | 162847.22 |  | 137500 |  | 118402.78 |  | 94722.22 |  | 68750 |  | 47361.11 |  | 22916.67
 |  |  |  |  |  | ZIMDEF | -6142.22 |  | 11657.09 |  | 3967.43 |  | -9838.02 |  | -14504.01 |  | 3581.48 |  | -16482.23 |  | -25394.71 |  | 24773.55 |  | -42308.95 |  | -42119.29 |  | -44342.33
 |  |  |  |  |  | NEC Control | -23275.76 |  | -13696.66 |  | -17844 |  | -16402.94 |  | -21686 |  | -21683.49 |  | -21682.68 |  | -28194.36 |  | -28180.28 |  | -44562.68 |  | -42526.54 |  | -33988.6
 |  |  |  |  |  | BONVIE MEDICAL AID | -55321 |  | -80206 |  | -80206 |  | -80207.08 |  | -127725.63 |  | -127725.85 |  | -127720.34 |  | -589959.11 |  | -589964.62 |  | -589961.03 |  | -589961.03 |  | 3038957.69
 |  |  |  |  |  | STANDARD DEV FUND | -2824.02 |  | -2824.02 |  | -3694 |  | -4350.18 |  | -6391 |  | -7291.89 |  | -7364.49 |  | -9441.54 |  | -10373.37 |  | -17636.62 |  | -17567.09 |  | -18766.92
 |  |  |  |  |  | Leave days accrual |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -2428772.21
 |  |  |  |  |  | Salary & Wages Control | -270704.24 |  | 421908.39 |  | 5000 |  | 24804.15 |  | -68038.54 |  | -380307.82 |  | -60388.57 |  | -1149081.55 |  | 108890.26 |  | -1532401.98 |  | 2568726.1 |  | 331593.8
 |  |  |  |  |  | Taxation Payable | -440377
 |  |  |  |  |  | Dividends Payable |  |  |  |  | 365312.94 |  | 196496.86 |  | 245310 |  |  |  |  |  |  |  |  |  | 579895
 |  |  |  |  |  | Vat / Tax Control Account | 464720.09 |  | 374738.94 |  | 231358.5 |  | 680270 |  | 867345.5 |  | 1064578.5 |  |  |  | 831633.05 |  | -1382413.33 |  | 337504.93 |  | 3123437.79 |  | 1193690.28
 |  |  |  |  |  | Intercompany -Bulawayo | -480524 |  | 2323160.25 |  | 3715868.27 |  | 1492781.69 |  | 1647006.94 |  | -1277049 |  | 6746075.91 |  | -3896223.21 |  | 7669950.44 |  | -5207466.38 |  | -244449.47 |  | -1876442.31
 |  |  |  |  |  | Intercompany - Beitbridge | 104370.32 |  | -502889.26 |  | -522927.4 |  | -181615.73 |  | -1433686.5 |  | -172685.5 |  | -820352 |  | -833053.52 |  | -706345.68 |  | -1545890.44 |  | 973363.78 |  | -855117.77
 |  |  |  |  |  | Intercompany - Gwanda | -174513 |  | -644855.38 |  | -933199.4 |  | -504228.62 |  | -731920.58 |  | -1057545.44 |  | -1523247 |  | -834885 |  | -2695106.76 |  | -3121189.55 |  | -1749781 |  | 9230575.46
 |  |  |  |  |  | Intercompany - Gweru | -136504.9 |  | -587122.01 |  | -393527.19 |  | -274098 |  | -964568 |  | -281773.01 |  | -405364.01 |  | -971525.01 |  | -126910.05 |  | -1048187.98 |  | -335440.01 |  | 3095354.82
 |  |  |  |  |  | Intercompany filabusi |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 153540.57 |  | 174775 |  | -926560 |  | -1683588.4 |  | 3925830.37
 |  |  |  |  |  | Opening Balance / Suspense Account | -1406724 |  | 487126.01 |  | 1277245.96 |  | 334629.61 |  | 243816.69 |  | 740000 |  |  |  |  |  |  |  |  |  |  |  | -1676094.09
 |  |  |  |  |  | Fuels & Oils-Motor Vehicles | 154600 |  | 125000 |  | 145200 |  | 124272 |  | 182000 |  | 265500 |  | 211000 |  | 255500 |  | 310100 |  | 147000 |  | 320000 |  | 329000
 |  |  |  |  |  | Licence fees 2023 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 942801.28
 |  |  |  |  |  | Generator |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1800
 |  |  |  |  |  | Finance & working capital charges
 |  |  |  |  |  | Accounts management fees | 151787.99 |  | 285056.52 |  | 313441.52 |  | 228232.23 |  | 647845.47 |  | 499924.27 |  | 651126.93 |  | 326002.87 |  | 866392.21 |  | 833031.29 |  | 2581021.7 |  | 485486.99
 |  |  |  |  |  | Working capital costs |  |  |  |  |  |  |  |  |  |  |  |  | 184722.22 |  | 251157.4 |  | 200925.93 |  | 145833.33 |  | 2020462.96 |  | 48611.1
 |  |  |  |  |  | Water & rates | 8284 |  | 18571 |  | 39270 |  | 25280 |  |  |  | 4880 |  |  |  |  |  |  |  | 400000
 |  |  |  |  |  | Electricity | 4900 |  | 6000 |  |  |  |  |  | 5000 |  | 6050 |  | 5000 |  | 5000 |  | 13500 |  | 40125 |  | 43000 |  | 28595
 |  |  |  |  |  | Telephone bills | 23750 |  | 36200 |  | 24000 |  | 25200 |  | 21500 |  | 29126.86 |  | 23000 |  | 60996 |  | 91200 |  | 105500 |  | 121050 |  | 106200
 |  |  |  |  |  | Internet | 10492 |  | 7499 |  | 17500 |  | 21899 |  | 21000 |  | 22149 |  | 24949 |  | 25470 |  | 27945 |  | 73310 |  | 41660 |  | 55000
 |  |  |  |  |  | Rentals |  |  |  |  | 266000 |  | 288000 |  | 227500 |  |  |  | 390000 |  | 840000 |  | 815500 |  | 801500 |  | 2080000 |  | 1648000
 |  |  |  |  |  | Employees compensation
 |  |  |  |  |  | Employees basic salaries | 564811.3 |  | 564811.3 |  | 847968 |  | 872175.43 |  | 1278723.28 |  | 1485241.28 |  | 1472533.94 |  | 1886564.74 |  | 2072750.67 |  | 3527312.27 |  | 3647479.08 |  | 3757058.62
 |  |  |  |  |  | Casual lablour |  |  | 0 |  |  |  |  |  |  |  |  |  |  |  |  |  | 78097.63 |  |  |  |  |  | 900
 |  |  |  |  |  | Canteen provision | 102154.28 |  | 85144.94 |  | 97104.98 |  | 129465.35 |  | 165617.15 |  | 204549.99 |  | 271994.81 |  | 281735.26 |  | 410193.29 |  | 483119.91 |  | 568791.7 |  | 514467.33
 |  |  |  |  |  | Casual labour |  |  | 4600 |  | 13982 |  | 13229.66 |  | 28750 |  | 27713.08 |  | 20500 |  | 57145.73 |  | 60703 |  | 75100 |  | 110670.3 |  | 243331.7
 |  |  |  |  |  | Employees bonus
 |  |  |  |  |  | Employees welfare | 88419.25 |  | 151670 |  | 48000 |  | 394774.17 |  | 323000 |  | 80000 |  | 170700 |  | 172060 |  | 992877.07 |  | 162000 |  | 212750 |  | 212800
 |  |  |  |  |  | Employees medical aid | 127660.5 |  | 259461 |  | 160412 |  | 192491.08 |  | 264267.63 |  | 127725.85 |  | 294866.34 |  | 589959.11 |  | 589964.62 |  | 589961.03 |  | 589961.03 |  | -3038957.69
 |  |  |  |  |  | Employees transport expenses | 135020 |  | 140000 |  | 195500 |  | 228300 |  | 305450 |  | 458925 |  | 752350 |  | 709750 |  | 616125 |  | 638005 |  | 699250 |  | 809375
 |  |  |  |  |  | Employees training |  |  |  |  |  |  |  |  | 40358.5 |  | 40000 |  | 26800 |  | 28000 |  | 121881.8
 |  |  |  |  |  | EmployeesOvertime |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 4900
 |  |  |  |  |  | Employees residency allowances | 68000 |  | 188000 |  | 81600 |  | 102000 |  | 259000 |  | 256000 |  | 352000 |  | 413000 |  | 308000 |  | 518000 |  | 308000 |  | 396000
 |  |  |  |  |  | Employees leave days |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2428772.21
 |  |  |  |  |  | Statutory deductions
 |  |  |  |  |  | Standard development fund | 1670.43 |  | 2824.02 |  | 3694 |  | 4350.18 |  | 6391 |  | 7291.89 |  | 7364.49 |  | 9441.54 |  | 10373.37 |  | 17636.62 |  | 17567.09 |  | 21942.86
 |  |  |  |  |  | ZimDEF | 7295.88 |  | 6273.21 |  | 8448 |  | 9838.02 |  | 14504.01 |  | 16335.13 |  | 16482.23 |  | 25394.71 |  | 27272.83 |  | 42308.95 |  | 42119.29 |  | 44342.33
 |  |  |  |  |  | Employees NEC | 6848.33 |  | 6848.27 |  | 8922 |  | 8201.47 |  | 10843 |  | 10841.74 |  | 10841.34 |  | 14097.18 |  | 14090.14 |  | 22279.84 |  | 19763.27 |  | 13818.36
 |  |  |  |  |  | Employees NSSA | 28808.8 |  | 29466.16 |  | 35450 |  | 42553.71 |  | 56381.54 |  | 61562.22 |  | 61537.33 |  | 79979.52 |  | 83422.07 |  | 142210.63 |  | 143267.58 |  | 108035.74
 |  |  |  |  |  | Repairs & Maintanance
 |  |  |  |  |  | Buildings | 51660 |  | 16650 |  | 18270 |  | 49428 |  |  |  | 269200 |  | 12300 |  | 98720 |  | 28000 |  | 140000 |  | 198190 |  | 80000
 |  |  |  |  |  | Electricals | 360 |  |  |  |  |  |  |  |  |  | 15400 |  |  |  | 24675 |  |  |  |  |  | 126380
 |  |  |  |  |  | Motor vehicles | 29507 |  | 129600 |  | 70800 |  | 16500 |  | 112000 |  | 52788.92 |  | 173100 |  | 187720 |  |  |  | 67449.58 |  | 328000 |  | 762400
 |  |  |  |  |  | Compuer equipment | 4500 |  | 12000 |  |  |  | 3000 |  | 490 |  |  |  |  |  | 204400 |  | 96500 |  | 7000 |  | 16000 |  | -139490
 |  |  |  |  |  | Furniture & fittings | 3180 |  |  |  |  |  |  |  |  |  | 38800 |  |  |  | 70000 |  |  |  |  |  | 264000 |  | 220548
 |  |  |  |  |  | Administration costs
 |  |  |  |  |  | Accounting & Audit fees |  |  |  |  |  |  |  |  | 2315360 |  | 779250 |  | 454000 |  | 59500 |  | 160747 |  | 148000 |  | 54400
 |  |  |  |  |  | Advertising & promotion |  |  |  |  |  |  |  |  |  |  |  |  | 40000 |  | 115500 |  | 14000 |  | 131000
 |  |  |  |  |  | Donations |  |  |  |  |  |  |  |  |  |  | 16850 |  |  |  |  |  |  |  | 70000 |  |  |  | 88113
 |  |  |  |  |  | Insurance & Licenses | 74702.63 |  | 182339 |  | 45275 |  |  |  | 64122 |  | 53550 |  | 20000 |  | 154000 |  | 72090 |  | 29000 |  | 412136 |  | 1681616.32
 |  |  |  |  |  | Postage & Corrier |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 27300 |  | 60700 |  | 29400 |  | 32800 |  | 34000
 |  |  |  |  |  | Stationary & Printing | 7710 |  | 14363.64 |  | 13580 |  | 30963.62 |  | 24349.95 |  | 50385.34 |  | 38244.19 |  | 107865.01 |  | 100160 |  | 111480 |  | 200709.72 |  | 187317.6
 |  |  |  |  |  | Security expenses
 |  |  |  |  |  | Traveling & Subsistance | 38900 |  | 12760 |  | 24120 |  | 83500 |  | 33635 |  | 42440 |  | 89460 |  | 812059.98 |  | 293894.16 |  | 586530 |  | 849928 |  | 1120400
 |  |  |  |  |  | Capacity development-Seniour management |  |  | 117534 |  |  |  |  |  |  |  |  |  |  |  |  |  | 4800
 |  |  |  |  |  | Board members compensation | 51848.51 |  |  |  | 73795.17 |  | 71184.44 |  | 33250 |  | 94100 |  | 323449.92 |  | 56000 |  | 7000 |  | 569208 |  | 32000 |  | 1185784.96
 |  |  |  |  |  | Cleaning expenses | 225 |  | 5000 |  | 4000 |  | 6295 |  |  |  | 9200 |  |  |  | 28297 |  | 42000 |  | 51740 |  | 72900 |  | 114400
 |  |  |  |  |  | Carriage outwards | 22000 |  | 25000 |  | 4400 |  | 40800 |  | 34300 |  | 37750 |  | 36000 |  | 4900 |  | 97200 |  | 15400 |  | 14600 |  | 26500
 |  |  |  |  |  | Parking fees | 360 |  |  |  | 3400 |  | 1200 |  | 2070 |  | 1760 |  | 4550 |  | 8400 |  | 19070 |  | 9800 |  | 9900 |  | 5850
 |  |  |  |  |  | Computer expenses | 10800 |  | 10810.9 |  | 10986.43 |  | 12000 |  | 10500 |  | 130000 |  | 12000 |  | 107100 |  | 87500 |  | 80500 |  | 128000 |  | 463170
 |  |  |  |  |  | profit/loss foreign exchange |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2438137.75
 |  |  |  |  |  | Sales
 |  |  |  |  |  | Bookshop | -3680924 |  | -19777672 |  | -13634353 |  | -14179168 |  | -23914167 |  | -11941091 |  | -11021935 |  | 7904667.71 |  | 9293428.17 |  | 4609568.87 |  | 19199169.03 |  | 42397106.01
 |  |  |  |  |  | Groceries |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -23012532.9 |  | -48560348.21 |  | -20767944.6 |  | -32188653.61 |  | -76304539.71
 |  |  |  |  |  | Bookshop |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -2388349.79 |  | -1884557.79 |  | -1536553.02 |  | -2132510.18 |  | -1204771.3
 |  |  |  |  |  | Groceries |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -3056.77 |  | -178115.72 |  | -23812.23 |  | -188646.28 |  | -4290453.13
 |  |  |  |  |  | Bookshop |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -70000 |  | -39245.41
 |  |  |  |  |  | Cost of Sales / Purchases
 |  |  |  |  |  | Bookshop | 2187188 |  | 12471414 |  | 9704607 |  | 9272968 |  | 16248287 |  | 7455309 |  | 6889532 |  | -322874.88 |  | -3096798.79 |  | -1895511.895 |  | -16599782.156 |  | -28300892.36
 |  |  |  |  |  | Groceries |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 8715260.56 |  | 31127137.38 |  | 10729560.37 |  | 25389891.52 |  | 48744525.02
 |  |  |  |  |  | Hardware |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 2129161.64 |  | 1580843.82 |  | 1283101.55 |  | 1742994.33 |  | 876462.95
 |  |  |  |  |  | Uniforms |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 62286 |  | 4893 |  |  |  | 2562500
 |  |  |  |  |  | ITC |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 70000
 |  |  |  |  |  | Inventory Adjustment |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -471149.79 |  | 15000 |  |  |  |  |  | -818960
 |  |  |  |  |  | Inventory Count Variance |  |  |  |  |  |  |  |  |  |  |  |  |  |  | -3693712.67 |  | 521484.3306 |  | 67650.69 |  |  |  | 3693712.67
 |  |  |  |  |  | Purchase Variance |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 1680 |  | -1680 |  | 533733.75 |  | -543936.44 |  | 10204.44
 |  |  |  |  |  | Carriage inwards | 31360 |  | 133084 |  | 76481 |  | 37750 |  | 101075 |  | 50000 |  | 113250 |  | 293350 |  | 218100 |  | 269535 |  | 438650 |  | 111200
 |  |  |  |  |  | Packaging Costs | 2430 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | 14160
 |  |  |  |  |  | Pft/Loss on Foreign Currency Exchange |  |  |  |  |  |  |  |  |  |  |  |  | -1800000 |  | 17680 |  |  |  |  |  | 320 |  | 1800000
 |  |  |  |  |  | Discount Received for Cash
 |  |  |  |  |  | Interest Received | -19.41 |  | -268.61 |  | -1391.76 |  | -158.74 |  | -391.46 |  | -342.09 |  | -109.44 |  | -52.07 |  | -354.27 |  | -313.39 |  | -106.83 |  | -115
 |  |  |  |  |  | Rent Income | -259000 |  | -262750 |  | -311550 |  | -414750 |  | -445750 |  | -533000 |  | -915500 |  | -789500 |  | -789500 |  | -899500 |  | -963500 |  | -1038000