Data Analytics and KPIs in BIJ’s Marketing Strategy

4 December 18, 2024

FORMATIVE Coursework

Assessment

Student Name:

Student ID:

Table of Contents

Introduction and project plan 3

Overall project plan 3

Present Bij’s own business Key Performance Indicators (KPIs) and how improved analytics enables improvements against these KPIs 4

Data quality issues and remedies 4

Data analysis and commentary 5

Conclusion 15

References 15

Introduction and project plan

A perfect marketing strategy is one of the most important business tools in today’s vast and globally competitive market. Bangles International Jewellery (BIJ) is a popular global jewellery brand. BIJ’s major marketing investment in the United Kingdom market during May 2020 became a significant topic for business analysts while the company, along with its major competitors like Signet, LVMH, and Cartier, were struggling in pandemic hit markets globally (Frampton, 2017). After a couple of years, this project aims to prepare a success report of the company’s marketing as mentioned earlier. This report contains an overall project plan, BIJ’s Key Performance Indicators (KPIs), data quality issues and their remedies, data analysis, and discussion. Wood From The Trees (WFTT), being the most trusted consultancy firm for BIJ, has commissioned this data-driven research under the Director of Product & Marketing.

Overall project plan

Bangles International Jewellery is a popular global jewellery brand in the UK with a great investment that follows a market strategy to retain in the competitive market. Considering all the business requirements, the data analytics framework will be considered for the following project because it highlights the organisation of any activity within the management (Osman, 2019). a project plan framework will be followed for this marketing project is the waterfall model of project management. The entire project of BIj will follow the path of requirement, design, implementation, verification and maintenance format. Mainly, the following project is a data-focused project involving a team to manage everything (Banks, 2022). There are found major components that are included while involving a data analytics framework. These are descriptive, diagnostic, predictive, and prescriptive analytics. This will further impact the sales positively because it will give the company an idea to operate competitively in the market. The data analytics framework allows the company to move through data analysis in an organised way with no issues related to business operation (Sklyar et al. 2019). The covid-19 pandemic has been a challenging situation for all the industries in the UK (Jallow, Renukappa, and Suresh, 2020). However, implementing a data analytics framework might help the project succeed, making the business sustainable.

Present own business Key Performance Indicators (KPIs) of Bij’s

Key performance indicators of a business is a quantifiable measure of a business performance based on a specific time and towards a well defined objective. it provides with target, milestone, and insight for an organisation to make a better decision. Major Key Performance Indicators (KPIs) for a global jewellery company like BIJ are- i) Customer base- BIJ has a constant customer base in Asia, North America, and Europe while they are steadily expanding their business in the rest of the three continents (Barbu and Militaru, 2019). ii) Customer satisfaction- From the comments on the company’s social media handles, their customer satisfaction positive report is quite evident, and they are dedicated to reaching the zenith of customer satisfaction, iii) Quantitative measurement- BIJ believes in the formula of “What Gets Measured, Gets Done”. Following this, they outline their business metrics at ease. Other than these, staff satisfaction and staff owner satisfaction are the other two KPIs of BIJ. Better data analysis of these KPIs can improve BIJ performance. spatio-temporal data over the customers and their choice and economic ability will help the company to limit their target customers precisely. simultaneously, quantitative measurement of the products of the company and the customer satisfaction rate will help them to undertake policies of business accordingly.

Data quality issues and remedies

Considering the BIJ, there has been a threat of data quality issues because of being a competitive company in the market. Although BIJ’s major marketing investment in the United Kingdom market during May 2020 came forward as a significant topic for business analysts, the company and its major competitors like Signet, LVMH, and Cartier were struggling in pandemic hit markets globally. Therefore, there are some general issues that the company faces. Some data quality issues are duplicate, incomplete, or different data formats (Duvier, Anand and Oltean-Dumbrava, 2018). All these are the common data quality issues that many companies face. Therefore, it is the responsibility of the company to identify the quality issues, and through relevant measures, these issues can be identified as in terms of Accuracy, Relevancy, Completeness, and Timeliness

All these four are the measure by which data quality issues can be identified. Along with that, all the data quality issues can be fixed by fixing data in the source system, by fixing the source system to correct data issues, and by applying entity solutions.

For instance, some of the data issues can be addressed by observing the BIJ data set, in which it has been observed that there were some of the elements that had different sales values, such as bracelets, rings, and necklaces, have different sales value in the consecutive months. Considering this, the data quality issues can be resolved by undertaking the above steps.

Data analysis and commentary

Table A

The following Pivot table shows the data and trends in sales volume and value by month, by year, and across whole analysis period. Additionally, the sum of sales value has been also calculated which is different in consecutive four years.

Year	Sales Volume	MARKET	SUM of Sales Value
2018	-1	USA	-£2,129
	-1 Total		-£2,129
	1	United Kingdom	£2,990
		USA	£9,017
	1 Total		£12,007
	2	Japan	£2,038
		USA	£3,444
	2 Total		£5,482
	4	Japan	£4,519
	4 Total		£4,519
	6	Japan	£5,712
		USA	£5,860
	6 Total		£11,572
	7	Japan	£12,601
	7 Total		£12,601
	8	Japan	£10,182
	8 Total		£10,182
	9	Japan	£28,733
	9 Total		£28,733
	10	Japan	£20,370
		United Kingdom	£7,523
		USA	£2,500
	10 Total		£30,393
	12	Japan	£12,725
		United Kingdom	£9,182
	12 Total		£21,907
	13	Japan	£15,764
	13 Total		£15,764
	14	Japan	£16,182
	14 Total		£16,182
	15	Japan	£16,636
	15 Total		£16,636
	17	Japan	£49,382
		United Kingdom	£47,878
	17 Total		£97,260
	18	Japan	£68,619
		United Kingdom	£33,539
	18 Total		£102,158
	19	Japan	£48,292
		United Kingdom	£42,462
	19 Total		£90,754
	20	Japan	£64,743
	20 Total		£64,743
	21	United Kingdom	£13,730
		USA	£22,385
	21 Total		£36,115
	22	Japan	£73,206
		United Kingdom	£30,504
		USA	£21,342
	22 Total		£125,052
	23	Japan	£60,019
	23 Total		£60,019
	24	Japan	£41,030
		United Kingdom	£27,255
	24 Total		£68,285
	25	Japan	£71,427
		United Kingdom	£18,445
	25 Total		£89,872
	26	Japan	£30,546
	26 Total		£30,546
	27	United Kingdom	£50,654
		USA	£54,312
	27 Total		£104,966
	28	United Kingdom	£66,960
	28 Total		£66,960
	30	United Kingdom	£60,405
		USA	£26,707
	30 Total		£87,112
	31	Japan	£86,296
	31 Total		£86,296
	32	Japan	£37,469
	32 Total		£37,469
	33	United Kingdom	£26,916
	33 Total		£26,916
	34	USA	£33,693
	34 Total		£33,693
	35	Japan	£39,457
	35 Total		£39,457
	36	United Kingdom	£36,727
	36 Total		£36,727
	37	USA	£40,787
	37 Total		£40,787
	38	United Kingdom	£39,468
	38 Total		£39,468
	40	USA	£91,419
	40 Total		£91,419
	42	USA	£40,361
	42 Total		£40,361
	43	United Kingdom	£34,783
	43 Total		£34,783
	44	United Kingdom	£42,258
	44 Total		£42,258
	45	Japan	£76,845
		United Kingdom	£46,230
		USA	£45,185
	45 Total		£168,260
	46	United Kingdom	£45,335
	46 Total		£45,335
	47	United Kingdom	£38,960
	47 Total		£38,960
	48	United Kingdom	£44,617
		USA	£58,384
	48 Total		£103,001
	50	USA	£68,285
	50 Total		£68,285
	52	United Kingdom	£64,892
	52 Total		£64,892
	53	United Kingdom	£50,285
	53 Total		£50,285
	57	United Kingdom	£39,123
	57 Total		£39,123
	58	USA	£185,676
	58 Total		£185,676
	60	United Kingdom	£67,015
	60 Total		£67,015
	64	USA	£79,271
	64 Total		£79,271
	68	USA	£94,462
	68 Total		£94,462
	71	USA	£93,038
	71 Total		£93,038
	72	USA	£93,861
	72 Total		£93,861
	74	United Kingdom	£91,094
	74 Total		£91,094
	75	USA	£162,889
	75 Total		£162,889
	77	United Kingdom	£56,305
	77 Total		£56,305
	81	USA	£74,595
	81 Total		£74,595
	83	USA	0
	83 Total		0
	84	USA	£88,268
	84 Total		£88,268
	86	USA	£96,036
	86 Total		£96,036
	88	USA	0
	88 Total		0
	90	United Kingdom	£66,827
	90 Total		£66,827
	94	United Kingdom	£76,245
		USA	0
	94 Total		£76,245
	99	USA	86028
	99 Total		86028
	100	United Kingdom	£73,234
		USA	0
	100 Total		£73,234
	101	United Kingdom	£164,950
	101 Total		£164,950
	102	United Kingdom	£83,083
	102 Total		£83,083
	104	United Kingdom	£81,612
		USA	0
	104 Total		£81,612
	107	USA	0
	107 Total		0
	111	USA	0
	111 Total		0
	112	United Kingdom	£68,567
		USA	0
	112 Total		£68,567
	115	United Kingdom	£87,373
	115 Total		£87,373
	121	United Kingdom	£95,581
	121 Total		£95,581
	126	USA	0
	126 Total		0
	127	USA	0
	127 Total		0
	128	USA	0
	128 Total		0
	131	USA	0
	131 Total		0
	137	USA	0
	137 Total		0
	175	USA	0
	175 Total		0
	199	Japan	0
	199 Total		0
	202	Japan	0
	202 Total		0
	215	Japan	0
	215 Total		0
	221	Japan	0
	221 Total		0
	230	Japan	0
	230 Total		0
	284	Japan	0
	284 Total		0
	322	Japan	0
	322 Total		0
	324	Japan	0
	324 Total		0
	346	Japan	0
	346 Total		0
	348	Japan	0
	348 Total		0
	357	Japan	0
	357 Total		0
	462	Japan	0
	462 Total		0
	–	Japan	£0
	– Total		£0
2018 Total			£4,401,476
2019	-1	USA	-£1,660
	-1 Total		-£1,660
	1	United Kingdom	£2,959
		USA	£4,148
	1 Total		£7,107
	2	Japan	£9,429
		USA	£5,463
	2 Total		£14,892
	3	Japan	£4,208
		United Kingdom	£3,754
	3 Total		£7,962
	4	United Kingdom	£3,415
	4 Total		£3,415
	5	Japan	£9,203
		United Kingdom	£10,596
		USA	£11,302
	5 Total		£31,101
	6	United Kingdom	£21,763
	6 Total		£21,763
	7	USA	£11,083
	7 Total		£11,083
	8	United Kingdom	£12,955
		USA	£15,170
	8 Total		£28,125
	9	Japan	£13,148
	9 Total		£13,148
	10	Japan	£11,206
		United Kingdom	£9,127
		USA	£19,918
	10 Total		£40,251
	11	United Kingdom	£9,794
		USA	£9,075
	11 Total		£18,869
	12	Japan	£26,624
		United Kingdom	£28,447
	12 Total		£55,071
	13	Japan	£41,162
		USA	£10,584
	13 Total		£51,746
	14	Japan	£34,948
		United Kingdom	£22,894
	14 Total		£57,842
	15	Japan	£13,604
	15 Total		£13,604
	16	Japan	£16,035
		United Kingdom	£30,826
	16 Total		£46,861
	17	Japan	£22,870
		United Kingdom	£45,504
		USA	£15,715
	17 Total		£84,089
	18	Japan	£17,734
		United Kingdom	£27,283
		USA	£20,559
	18 Total		£65,576
	19	USA	£36,142
	19 Total		£36,142
	20	Japan	£75,232
	20 Total		£75,232
	21	United Kingdom	£44,553
	21 Total		£44,553
	22	Japan	£66,357
	22 Total		£66,357
	23	Japan	£66,752
		United Kingdom	£23,585
		USA	£23,538
	23 Total		£113,875
	24	Japan	£29,053
		United Kingdom	£54,289
		USA	£48,183
	24 Total		£131,525
	25	Japan	£50,420
		United Kingdom	£43,980
		USA	£27,010
	25 Total		£121,410
	27	Japan	£91,418
		United Kingdom	£39,450
		USA	£30,380
	27 Total		£161,248
	28	Japan	£69,929
		United Kingdom	£45,631
	28 Total		£115,560
	29	Japan	£44,173
	29 Total		£44,173
	31	Japan	£40,744
		United Kingdom	£27,861
		USA	£26,190
	31 Total		£94,795
	32	Japan	£32,875
	32 Total		£32,875
	33	Japan	£33,444
	33 Total		£33,444
	34	Japan	£41,062
		USA	£35,885
	34 Total		£76,947
	35	USA	£71,614
	35 Total		£71,614
	36	Japan	£36,126
	36 Total		£36,126
	38	USA	£45,654
	38 Total		£45,654
	39	Japan	£120,267
		United Kingdom	£23,018
		USA	£104,458
	39 Total		£247,743
	42	Japan	£52,012
		USA	£46,657
	42 Total		£98,669
	43	USA	£143,202
	43 Total		£143,202
	44	Japan	£84,613
	44 Total		£84,613
	46	Japan	£79,273
	46 Total		£79,273
	49	Japan	£47,400
	49 Total		£47,400
	51	USA	£51,213
	51 Total		£51,213
	52	USA	£51,371
	52 Total		£51,371
	54	USA	£62,559
	54 Total		£62,559
	57	USA	£147,364
	57 Total		£147,364
	61	USA	£153,970
	61 Total		£153,970
	62	United Kingdom	£39,091
	62 Total		£39,091
	64	USA	£89,338
	64 Total		£89,338
	67	United Kingdom	£51,704
		USA	£74,840
	67 Total		£126,544
	69	USA	£80,652
	69 Total		£80,652
	73	USA	£167,692
	73 Total		£167,692
	84	USA	£87,336
	84 Total		£87,336
	89	USA	£95,601
	89 Total		£95,601
	99	United Kingdom	£68,784
	99 Total		£68,784
	108	USA	0
	108 Total		0
	112	USA	0
	112 Total		0
	113	USA	0
	113 Total		0
	114	United Kingdom	£94,621
	114 Total		£94,621
	117	USA	0
	117 Total		0
	118	United Kingdom	£88,439
	118 Total		£88,439
	122	United Kingdom	£91,996
		USA	0
	122 Total		£91,996
	123	United Kingdom	0
		USA	0
	123 Total		0
	131	USA	0
	131 Total		0
	136	United Kingdom	£99,306
	136 Total		£99,306
	137	USA	0
	137 Total		0
	138	Japan	0
	138 Total		0
	140	USA	0
	140 Total		0
	141	USA	0
	141 Total		0
	143	United Kingdom	99268
	143 Total		99268
	151	United Kingdom	0
	151 Total		0
	153	USA	0
	153 Total		0
	160	USA	0
	160 Total		0
	165	USA	0
	165 Total		0
	175	Japan	0
	175 Total		0
	177	Japan	0
	177 Total		0
	178	USA	0
	178 Total		0
	182	United Kingdom	0
	182 Total		0
	186	United Kingdom	0
		USA	0
	186 Total		0
	195	Japan	0
	195 Total		0
	212	Japan	0
	212 Total		0
	221	Japan	0
	221 Total		0
	226	Japan	0
	226 Total		0
	237	Japan	0
	237 Total		0
	246	Japan	0
	246 Total		0
	262	Japan	0
	262 Total		0
	396	Japan	0
	396 Total		0
	610	Japan	0
	610 Total		0
2019 Total			£4,268,420
2020	1	Japan	£5,041
		United Kingdom	£1,795
	1 Total		£6,836
	2	United Kingdom	£2,939
		US	£4,105
	2 Total		£7,044
	3	United Kingdom	£17,344
		USA	0
	3 Total		£17,344
	4	Japan	£6,543
		United Kingdom	£16,646
		USA	£7,168
	4 Total		£30,357
	5	Japan	£32,716
		United Kingdom	£18,167
	5 Total		£50,883
	6	Japan	£24,172
		United Kingdom	£11,485
	6 Total		£35,657
	7	Japan	£23,604
	7 Total		£23,604
	8	Japan	£23,923
		United Kingdom	£14,366
	8 Total		£38,289
	9	Japan	£51,416
		United Kingdom	£25,728
		USA	£10,763
	9 Total		£87,907
	10	United Kingdom	£56,528
		USA	£9,577
	10 Total		£66,105
	11	Japan	£34,999
		United Kingdom	£15,074
		USA	£19,253
	11 Total		£69,326
	12	Japan	£38,646
		US	0
		USA	£27,778
	12 Total		£66,424
	13	Japan	£22,741
		United Kingdom	£22,201
		USA	£14,615
	13 Total		£59,557
	14	Japan	£29,299
		United Kingdom	£11,775
		USA	£40,745
	14 Total		£81,819
	15	Japan	£15,453
		United Kingdom	£36,550
		USA	£43,937
	15 Total		£95,940
	16	Japan	£49,003
		United Kingdom	£26,665
		USA	£27,493
	16 Total		£103,161
	17	United Kingdom	£14,287
	17 Total		£14,287
	18	Japan	£22,387
		United Kingdom	£13,382
		USA	£101,572
	18 Total		£137,341
	19	Japan	£18,710
		United Kingdom	£55,476
		USA	£23,273
	19 Total		£97,459
	20	United Kingdom	£33,090
		USA	£34,997
	20 Total		£68,087
	21	Japan	£44,262
	21 Total		£44,262
	22	Japan	£43,838
		United Kingdom	£29,407
	22 Total		£73,245
	23	United Kingdom	£24,983
	23 Total		£24,983
	24	United Kingdom	£15,798
		USA	£25,631
	24 Total		£41,429
	25	Japan	£31,276
	25 Total		£31,276
	26	USA	£95,063
	26 Total		£95,063
	27	Japan	£52,708
		USA	£28,761
	27 Total		£81,469
	28	Japan	£82,634
	28 Total		£82,634
	29	Japan	£51,404
		US	0
		USA	£54,480
	29 Total		£105,884
	30	USA	£28,859
	30 Total		£28,859
	31	Japan	£32,568
		USA	£31,935
	31 Total		£64,503
	33	USA	£116,046
	33 Total		£116,046
	34	USA	£46,126
	34 Total		£46,126
	36	USA	£70,119
	36 Total		£70,119
	37	Japan	£39,615
	37 Total		£39,615
	38	Japan	£64,951
	38 Total		£64,951
	40	Japan	£73,558
	40 Total		£73,558
	42	US	£49,621
	42 Total		£49,621
	43	Japan	£83,387
	43 Total		£83,387
	45	Japan	£129,704
	45 Total		£129,704
	46	Japan	£87,938
	46 Total		£87,938
	48	USA	£64,103
	48 Total		£64,103
	51	United Kingdom	£32,193
	51 Total		£32,193
	52	USA	£53,762
	52 Total		£53,762
	53	US	0
	53 Total		0
	56	USA	£58,265
	56 Total		£58,265
	57	US	£81,705
	57 Total		£81,705
	59	USA	£81,210
	59 Total		£81,210
	60	USA	£149,694
	60 Total		£149,694
	61	Japan	£63,408
	61 Total		£63,408
	63	Japan	£63,808
	63 Total		£63,808
	66	USA	£96,497
	66 Total		£96,497
	69	Japan	0
	69 Total		0
	71	US	0
	71 Total		0
	78	USA	£73,150
	78 Total		£73,150
	92	Japan	0
		USA	0
	92 Total		0
	97	United Kingdom	£86,543
	97 Total		£86,543
	101	Japan	0
	101 Total		0
	103	Japan	0
	103 Total		0
	104	USA	£99,853
	104 Total		£99,853
	117	United Kingdom	£88,598
	117 Total		£88,598
	120	United Kingdom	0
	120 Total		0
	124	United Kingdom	£92,995
	124 Total		£92,995
	126	Japan	0
	126 Total		0
	129	Japan	0
	129 Total		0
	131	USA	0
	131 Total		0
	132	United Kingdom	0
	132 Total		0
	149	United Kingdom	0
	149 Total		0
	152	Japan	0
	152 Total		0
	153	USA	0
	153 Total		0
	159	Japan	0
	159 Total		0
	160	United Kingdom	0
	160 Total		0
	172	USA	0
	172 Total		0
	173	Japan	0
	173 Total		0
	174	United Kingdom	0
	174 Total		0
	176	Japan	0
	176 Total		0
	178	Japan	0
	178 Total		0
	180	USA	0
	180 Total		0
	182	Japan	0
	182 Total		0
	188	USA	0
	188 Total		0
	190	United Kingdom	0
	190 Total		0
	192	USA	0
	192 Total		0
	212	US	0
	212 Total		0
	221	United Kingdom	0
	221 Total		0
	227	Japan	0
	227 Total		0
	264	USA	0
	264 Total		0
	277	USA	0
	277 Total		0
	278	United Kingdom	0
	278 Total		0
	299	USA	0
	299 Total		0
	316	United Kingdom	0
	316 Total		0
	–	United Kingdom	£0
	– Total		£0
2020 Total			£3,777,883
2030	26	USA	£36,247
	26 Total		£36,247
2030 Total			£36,247
Grand Total			£12,484,026

The above data depicts your numeric data analysis in tables and shows how BIJ operates in the market. From the BIJ performance, it has been analysed how the sales volume and value have significantly changed in the consecutive three years 2018, 2019, and 2020. Many subtypes have different sales volumes and sales values in three different years. Hence, the different period has stated the company’s performance in the UK. From the summation of the table, it has been analysed in which year, the company faced a large number of sales and in which year, the company faced a decline in the sales. Thus, the table shows the UK market’s overall business operations.

Table B

From the second Pivot table, the company’s benchmark comparisons of category performance has been identified in which the sales volume by quarter, by year, and across the whole analysis period has been calculated. With the Pivot table, it was accessible to do the comparison of sale volume and sales volume as per quarterly.

Year	SUM of Year	COUNTA of MARKET	SUM of Sales Volume
2018	314808	156	10325
2019	331116	164	10035
2020	357540	177	9173
2030	2030	1	26
Grand Total	1005494	498	29559

Table C

Table C shows the company’s benchmark comparisons of sales volume and value between markets by quarter, by year, and across the whole analysis period. With the Pivot table, it was accessible to do the comparison of sale volume and sales volume as per the four years undertaken.

*Year*	*Sales Volume*	SUM of Sales Value
2018	-1	-£2,129
	1	£12,007
	2	£5,482
	4	£4,519
	6	£11,572
	7	£12,601
	8	£10,182
	9	£28,733
	10	£30,393
	12	£21,907
	13	£15,764
	14	£16,182
	15	£16,636
	17	£97,260
	18	£102,158
	19	£90,754
	20	£64,743
	21	£36,115
	22	£125,052
	23	£60,019
	24	£68,285
	25	£89,872
	26	£30,546
	27	£104,966
	28	£66,960
	30	£87,112
	31	£86,296
	32	£37,469
	33	£26,916
	34	£33,693
	35	£39,457
	36	£36,727
	37	£40,787
	38	£39,468
	40	£91,419
	42	£40,361
	43	£34,783
	44	£42,258
	45	£168,260
	46	£45,335
	47	£38,960
	48	£103,001
	50	£68,285
	52	£64,892
	53	£50,285
	57	£39,123
	58	£185,676
	60	£67,015
	64	£79,271
	68	£94,462
	71	£93,038
	72	£93,861
	74	£91,094
	75	£162,889
	77	£56,305
	81	£74,595
	83	0
	84	£88,268
	86	£96,036
	88	0
	90	£66,827
	94	£76,245
	99	86028
	100	£73,234
	101	£164,950
	102	£83,083
	104	£81,612
	107	0
	111	0
	112	£68,567
	115	£87,373
	121	£95,581
	126	0
	127	0
	128	0
	131	0
	137	0
	175	0
	199	0
	202	0
	215	0
	221	0
	230	0
	284	0
	322	0
	324	0
	346	0
	348	0
	357	0
	462	0
	–	£0
2018 Total		£4,401,476
2019	-1	-£1,660
	1	£7,107
	2	£14,892
	3	£7,962
	4	£3,415
	5	£31,101
	6	£21,763
	7	£11,083
	8	£28,125
	9	£13,148
	10	£40,251
	11	£18,869
	12	£55,071
	13	£51,746
	14	£57,842
	15	£13,604
	16	£46,861
	17	£84,089
	18	£65,576
	19	£36,142
	20	£75,232
	21	£44,553
	22	£66,357
	23	£113,875
	24	£131,525
	25	£121,410
	27	£161,248
	28	£115,560
	29	£44,173
	31	£94,795
	32	£32,875
	33	£33,444
	34	£76,947
	35	£71,614
	36	£36,126
	38	£45,654
	39	£247,743
	42	£98,669
	43	£143,202
	44	£84,613
	46	£79,273
	49	£47,400
	51	£51,213
	52	£51,371
	54	£62,559
	57	£147,364
	61	£153,970
	62	£39,091
	64	£89,338
	67	£126,544
	69	£80,652
	73	£167,692
	84	£87,336
	89	£95,601
	99	£68,784
	108	0
	112	0
	113	0
	114	£94,621
	117	0
	118	£88,439
	122	£91,996
	123	0
	131	0
	136	£99,306
	137	0
	138	0
	140	0
	141	0
	143	99268
	151	0
	153	0
	160	0
	165	0
	175	0
	177	0
	178	0
	182	0
	186	0
	195	0
	212	0
	221	0
	226	0
	237	0
	246	0
	262	0
	396	0
	610	0
2019 Total		£4,268,420
2020	1	£6,836
	2	£7,044
	3	£17,344
	4	£30,357
	5	£50,883
	6	£35,657
	7	£23,604
	8	£38,289
	9	£87,907
	10	£66,105
	11	£69,326
	12	£66,424
	13	£59,557
	14	£81,819
	15	£95,940
	16	£103,161
	17	£14,287
	18	£137,341
	19	£97,459
	20	£68,087
	21	£44,262
	22	£73,245
	23	£24,983
	24	£41,429
	25	£31,276
	26	£95,063
	27	£81,469
	28	£82,634
	29	£105,884
	30	£28,859
	31	£64,503
	33	£116,046
	34	£46,126
	36	£70,119
	37	£39,615
	38	£64,951
	40	£73,558
	42	£49,621
	43	£83,387
	45	£129,704
	46	£87,938
	48	£64,103
	51	£32,193
	52	£53,762
	53	0
	56	£58,265
	57	£81,705
	59	£81,210
	60	£149,694
	61	£63,408
	63	£63,808
	66	£96,497
	69	0
	71	0
	78	£73,150
	92	0
	97	£86,543
	101	0
	103	0
	104	£99,853
	117	£88,598
	120	0
	124	£92,995
	126	0
	129	0
	131	0
	132	0
	149	0
	152	0
	153	0
	159	0
	160	0
	172	0
	173	0
	174	0
	176	0
	178	0
	180	0
	182	0
	188	0
	190	0
	192	0
	212	0
	221	0
	227	0
	264	0
	277	0
	278	0
	299	0
	316	0
	–	£0
2020 Total		£3,777,883
2030	26	£36,247
2030 Total		£36,247
Grand Total		£12,484,026

Analysis on sales volume and sales value by quarter

From the above analysis, it can be stated that BIJ’s business operation has been benchmarking for three consecutive years. The above data has shown the company’s performance, covering the sales volume and value by quarter. In three consecutive years, there have been major differences in their business operations. Although, three different countries were considered: Japan, the UK, and the US. All three countries have different sales volumes and values in these three consecutive years 2018, 2019, and 2020. The BIJ’s sales volume and value have been analysed accordingly in which it has been found that different products are sold at different values.

From the overall analysis, it has been found that all these three countries have different sales values and volumes, by which it can be said that BIJ’s business performance is good compared to other UK markets. Due to better quality measures and operations, the company’s sales are better than other companies in the market. On the other hand, it can be said that the table analysis has evaluated all the requirements to gain better business operations in the UK market.

Conclusion

In summation of this topic, it can be concluded that one of the companies has been taken into consideration: the UK-based named BIJ. The company deals with producing varieties of jewelry and had many competitors in the market. On the other hand, a project plan has been focused on involving many challenges during the covid-19 pandemic. Whereas there has been discussion on the data quality issues and corrective measures have mitigated all the issues faced by BIJ. This, with the help of numeric data analysis, the business operation of BIJ has been analysed.

References

Banks, A., 2022. A data-focused approach to personalising central support programmes and complementing personal tutoring. The Higher Education Personal Tutor’s and Advisor’s Companion: Translating Theory into Practice to Improve Student Success, 105, p.3. Available at: https://books.google.com/books?hl=en&lr=&id=JP9kEAAAQBAJ&oi=fnd&pg=PT39&dq=data-focused+project+UK&ots=Yo12AIx2_i&sig=gk7kr2c6jmis2zDx5YEFss_JdJ4 [Accessed 7 July 2022]

Barbu, A. and Militaru, G., 2019. Value co-creation between manufacturing companies and customers. The role of information technology competency. Procedia Manufacturing, 32, pp.1069-1076. https://www.sciencedirect.com/science/article/pii/S2351978919303622

Duvier, C., Anand, P.B. and Oltean-Dumbrava, C., 2018. Data quality and governance in a UK social housing initiative: Implications for smart sustainable cities. Sustainable cities and society, 39, pp.358-365. Available at: https://www.sciencedirect.com/science/article/pii/S2210670717312520 [Accessed 7 July 2022]

Frampton, A., 2017. Cred Jewellery, UK:”Committed to raising standards”. In Sustainable Luxury and Social Entrepreneurship (pp. 33-54). Routledge. https://www.taylorfrancis.com/chapters/edit/10.4324/9781351284967-3/cred-jewellery-uk-alan-frampton

Jallow, H., Renukappa, S. and Suresh, S., 2020. The impact of COVID-19 outbreak on United Kingdom infrastructure sector. Smart and Sustainable Built Environment. Available at: https://www.emerald.com/insight/content/doi/10.1108/SASBE-05-2020-0068/full/html [Accessed 7 July 2022]

Osman, A.M.S., 2019. A novel big data analytics framework for smart cities. Future Generation Computer Systems, 91, pp.620-633. Available at: https://www.sciencedirect.com/science/article/pii/S0167739X17307446 [Accessed 7 July 2022]

Sklyar, A., Kowalkowski, C., Tronvoll, B. and Sörhammar, D., 2019. Organising for digital servitisation: A service ecosystem perspective. Journal of Business Research, 104, pp.450-460. Available at: https://www.sciencedirect.com/science/article/pii/S014829631930102X [Accessed 7 July 2022]

Appendix

Table A

*Year*	*Sales Volume*	*MARKET*	SUM of Sales Value
2018	-1	USA	-£2,129
	-1 Total		-£2,129
	1	United Kingdom	£2,990
		USA	£9,017
	1 Total		£12,007
	2	Japan	£2,038
		USA	£3,444
	2 Total		£5,482
	4	Japan	£4,519
	4 Total		£4,519
	6	Japan	£5,712
		USA	£5,860
	6 Total		£11,572
	7	Japan	£12,601
	7 Total		£12,601
	8	Japan	£10,182
	8 Total		£10,182
	9	Japan	£28,733
	9 Total		£28,733
	10	Japan	£20,370
		United Kingdom	£7,523
		USA	£2,500
	10 Total		£30,393
	12	Japan	£12,725
		United Kingdom	£9,182
	12 Total		£21,907
	13	Japan	£15,764
	13 Total		£15,764
	14	Japan	£16,182
	14 Total		£16,182
	15	Japan	£16,636
	15 Total		£16,636
	17	Japan	£49,382
		United Kingdom	£47,878
	17 Total		£97,260
	18	Japan	£68,619
		United Kingdom	£33,539
	18 Total		£102,158
	19	Japan	£48,292
		United Kingdom	£42,462
	19 Total		£90,754
	20	Japan	£64,743
	20 Total		£64,743
	21	United Kingdom	£13,730
		USA	£22,385
	21 Total		£36,115
	22	Japan	£73,206
		United Kingdom	£30,504
		USA	£21,342
	22 Total		£125,052
	23	Japan	£60,019
	23 Total		£60,019
	24	Japan	£41,030
		United Kingdom	£27,255
	24 Total		£68,285
	25	Japan	£71,427
		United Kingdom	£18,445
	25 Total		£89,872
	26	Japan	£30,546
	26 Total		£30,546
	27	United Kingdom	£50,654
		USA	£54,312
	27 Total		£104,966
	28	United Kingdom	£66,960
	28 Total		£66,960
	30	United Kingdom	£60,405
		USA	£26,707
	30 Total		£87,112
	31	Japan	£86,296
	31 Total		£86,296
	32	Japan	£37,469
	32 Total		£37,469
	33	United Kingdom	£26,916
	33 Total		£26,916
	34	USA	£33,693
	34 Total		£33,693
	35	Japan	£39,457
	35 Total		£39,457
	36	United Kingdom	£36,727
	36 Total		£36,727
	37	USA	£40,787
	37 Total		£40,787
	38	United Kingdom	£39,468
	38 Total		£39,468
	40	USA	£91,419
	40 Total		£91,419
	42	USA	£40,361
	42 Total		£40,361
	43	United Kingdom	£34,783
	43 Total		£34,783
	44	United Kingdom	£42,258
	44 Total		£42,258
	45	Japan	£76,845
		United Kingdom	£46,230
		USA	£45,185
	45 Total		£168,260
	46	United Kingdom	£45,335
	46 Total		£45,335
	47	United Kingdom	£38,960
	47 Total		£38,960
	48	United Kingdom	£44,617
		USA	£58,384
	48 Total		£103,001
	50	USA	£68,285
	50 Total		£68,285
	52	United Kingdom	£64,892
	52 Total		£64,892
	53	United Kingdom	£50,285
	53 Total		£50,285
	57	United Kingdom	£39,123
	57 Total		£39,123
	58	USA	£185,676
	58 Total		£185,676
	60	United Kingdom	£67,015
	60 Total		£67,015
	64	USA	£79,271
	64 Total		£79,271
	68	USA	£94,462
	68 Total		£94,462
	71	USA	£93,038
	71 Total		£93,038
	72	USA	£93,861
	72 Total		£93,861
	74	United Kingdom	£91,094
	74 Total		£91,094
	75	USA	£162,889
	75 Total		£162,889
	77	United Kingdom	£56,305
	77 Total		£56,305
	81	USA	£74,595
	81 Total		£74,595
	83	USA	0
	83 Total		0
	84	USA	£88,268
	84 Total		£88,268
	86	USA	£96,036
	86 Total		£96,036
	88	USA	0
	88 Total		0
	90	United Kingdom	£66,827
	90 Total		£66,827
	94	United Kingdom	£76,245
		USA	0
	94 Total		£76,245
	99	USA	86028
	99 Total		86028
	100	United Kingdom	£73,234
		USA	0
	100 Total		£73,234
	101	United Kingdom	£164,950
	101 Total		£164,950
	102	United Kingdom	£83,083
	102 Total		£83,083
	104	United Kingdom	£81,612
		USA	0
	104 Total		£81,612
	107	USA	0
	107 Total		0
	111	USA	0
	111 Total		0
	112	United Kingdom	£68,567
		USA	0
	112 Total		£68,567
	115	United Kingdom	£87,373
	115 Total		£87,373
	121	United Kingdom	£95,581
	121 Total		£95,581
	126	USA	0
	126 Total		0
	127	USA	0
	127 Total		0
	128	USA	0
	128 Total		0
	131	USA	0
	131 Total		0
	137	USA	0
	137 Total		0
	175	USA	0
	175 Total		0
	199	Japan	0
	199 Total		0
	202	Japan	0
	202 Total		0
	215	Japan	0
	215 Total		0
	221	Japan	0
	221 Total		0
	230	Japan	0
	230 Total		0
	284	Japan	0
	284 Total		0
	322	Japan	0
	322 Total		0
	324	Japan	0
	324 Total		0
	346	Japan	0
	346 Total		0
	348	Japan	0
	348 Total		0
	357	Japan	0
	357 Total		0
	462	Japan	0
	462 Total		0
	–	Japan	£0
	– Total		£0
2018 Total			£4,401,476
2019	-1	USA	-£1,660
	-1 Total		-£1,660
	1	United Kingdom	£2,959
		USA	£4,148
	1 Total		£7,107
	2	Japan	£9,429
		USA	£5,463
	2 Total		£14,892
	3	Japan	£4,208
		United Kingdom	£3,754
	3 Total		£7,962
	4	United Kingdom	£3,415
	4 Total		£3,415
	5	Japan	£9,203
		United Kingdom	£10,596
		USA	£11,302
	5 Total		£31,101
	6	United Kingdom	£21,763
	6 Total		£21,763
	7	USA	£11,083
	7 Total		£11,083
	8	United Kingdom	£12,955
		USA	£15,170
	8 Total		£28,125
	9	Japan	£13,148
	9 Total		£13,148
	10	Japan	£11,206
		United Kingdom	£9,127
		USA	£19,918
	10 Total		£40,251
	11	United Kingdom	£9,794
		USA	£9,075
	11 Total		£18,869
	12	Japan	£26,624
		United Kingdom	£28,447
	12 Total		£55,071
	13	Japan	£41,162
		USA	£10,584
	13 Total		£51,746
	14	Japan	£34,948
		United Kingdom	£22,894
	14 Total		£57,842
	15	Japan	£13,604
	15 Total		£13,604
	16	Japan	£16,035
		United Kingdom	£30,826
	16 Total		£46,861
	17	Japan	£22,870
		United Kingdom	£45,504
		USA	£15,715
	17 Total		£84,089
	18	Japan	£17,734
		United Kingdom	£27,283
		USA	£20,559
	18 Total		£65,576
	19	USA	£36,142
	19 Total		£36,142
	20	Japan	£75,232
	20 Total		£75,232
	21	United Kingdom	£44,553
	21 Total		£44,553
	22	Japan	£66,357
	22 Total		£66,357
	23	Japan	£66,752
		United Kingdom	£23,585
		USA	£23,538
	23 Total		£113,875
	24	Japan	£29,053
		United Kingdom	£54,289
		USA	£48,183
	24 Total		£131,525
	25	Japan	£50,420
		United Kingdom	£43,980
		USA	£27,010
	25 Total		£121,410
	27	Japan	£91,418
		United Kingdom	£39,450
		USA	£30,380
	27 Total		£161,248
	28	Japan	£69,929
		United Kingdom	£45,631
	28 Total		£115,560
	29	Japan	£44,173
	29 Total		£44,173
	31	Japan	£40,744
		United Kingdom	£27,861
		USA	£26,190
	31 Total		£94,795
	32	Japan	£32,875
	32 Total		£32,875
	33	Japan	£33,444
	33 Total		£33,444
	34	Japan	£41,062
		USA	£35,885
	34 Total		£76,947
	35	USA	£71,614
	35 Total		£71,614
	36	Japan	£36,126
	36 Total		£36,126
	38	USA	£45,654
	38 Total		£45,654
	39	Japan	£120,267
		United Kingdom	£23,018
		USA	£104,458
	39 Total		£247,743
	42	Japan	£52,012
		USA	£46,657
	42 Total		£98,669
	43	USA	£143,202
	43 Total		£143,202
	44	Japan	£84,613
	44 Total		£84,613
	46	Japan	£79,273
	46 Total		£79,273
	49	Japan	£47,400
	49 Total		£47,400
	51	USA	£51,213
	51 Total		£51,213
	52	USA	£51,371
	52 Total		£51,371
	54	USA	£62,559
	54 Total		£62,559
	57	USA	£147,364
	57 Total		£147,364
	61	USA	£153,970
	61 Total		£153,970
	62	United Kingdom	£39,091
	62 Total		£39,091
	64	USA	£89,338
	64 Total		£89,338
	67	United Kingdom	£51,704
		USA	£74,840
	67 Total		£126,544
	69	USA	£80,652
	69 Total		£80,652
	73	USA	£167,692
	73 Total		£167,692
	84	USA	£87,336
	84 Total		£87,336
	89	USA	£95,601
	89 Total		£95,601
	99	United Kingdom	£68,784
	99 Total		£68,784
	108	USA	0
	108 Total		0
	112	USA	0
	112 Total		0
	113	USA	0
	113 Total		0
	114	United Kingdom	£94,621
	114 Total		£94,621
	117	USA	0
	117 Total		0
	118	United Kingdom	£88,439
	118 Total		£88,439
	122	United Kingdom	£91,996
		USA	0
	122 Total		£91,996
	123	United Kingdom	0
		USA	0
	123 Total		0
	131	USA	0
	131 Total		0
	136	United Kingdom	£99,306
	136 Total		£99,306
	137	USA	0
	137 Total		0
	138	Japan	0
	138 Total		0
	140	USA	0
	140 Total		0
	141	USA	0
	141 Total		0
	143	United Kingdom	99268
	143 Total		99268
	151	United Kingdom	0
	151 Total		0
	153	USA	0
	153 Total		0
	160	USA	0
	160 Total		0
	165	USA	0
	165 Total		0
	175	Japan	0
	175 Total		0
	177	Japan	0
	177 Total		0
	178	USA	0
	178 Total		0
	182	United Kingdom	0
	182 Total		0
	186	United Kingdom	0
		USA	0
	186 Total		0
	195	Japan	0
	195 Total		0
	212	Japan	0
	212 Total		0
	221	Japan	0
	221 Total		0
	226	Japan	0
	226 Total		0
	237	Japan	0
	237 Total		0
	246	Japan	0
	246 Total		0
	262	Japan	0
	262 Total		0
	396	Japan	0
	396 Total		0
	610	Japan	0
	610 Total		0
2019 Total			£4,268,420
2020	1	Japan	£5,041
		United Kingdom	£1,795
	1 Total		£6,836
	2	United Kingdom	£2,939
		US	£4,105
	2 Total		£7,044
	3	United Kingdom	£17,344
		USA	0
	3 Total		£17,344
	4	Japan	£6,543
		United Kingdom	£16,646
		USA	£7,168
	4 Total		£30,357
	5	Japan	£32,716
		United Kingdom	£18,167
	5 Total		£50,883
	6	Japan	£24,172
		United Kingdom	£11,485
	6 Total		£35,657
	7	Japan	£23,604
	7 Total		£23,604
	8	Japan	£23,923
		United Kingdom	£14,366
	8 Total		£38,289
	9	Japan	£51,416
		United Kingdom	£25,728
		USA	£10,763
	9 Total		£87,907
	10	United Kingdom	£56,528
		USA	£9,577
	10 Total		£66,105
	11	Japan	£34,999
		United Kingdom	£15,074
		USA	£19,253
	11 Total		£69,326
	12	Japan	£38,646
		US	0
		USA	£27,778
	12 Total		£66,424
	13	Japan	£22,741
		United Kingdom	£22,201
		USA	£14,615
	13 Total		£59,557
	14	Japan	£29,299
		United Kingdom	£11,775
		USA	£40,745
	14 Total		£81,819
	15	Japan	£15,453
		United Kingdom	£36,550
		USA	£43,937
	15 Total		£95,940
	16	Japan	£49,003
		United Kingdom	£26,665
		USA	£27,493
	16 Total		£103,161
	17	United Kingdom	£14,287
	17 Total		£14,287
	18	Japan	£22,387
		United Kingdom	£13,382
		USA	£101,572
	18 Total		£137,341
	19	Japan	£18,710
		United Kingdom	£55,476
		USA	£23,273
	19 Total		£97,459
	20	United Kingdom	£33,090
		USA	£34,997
	20 Total		£68,087
	21	Japan	£44,262
	21 Total		£44,262
	22	Japan	£43,838
		United Kingdom	£29,407
	22 Total		£73,245
	23	United Kingdom	£24,983
	23 Total		£24,983
	24	United Kingdom	£15,798
		USA	£25,631
	24 Total		£41,429
	25	Japan	£31,276
	25 Total		£31,276
	26	USA	£95,063
	26 Total		£95,063
	27	Japan	£52,708
		USA	£28,761
	27 Total		£81,469
	28	Japan	£82,634
	28 Total		£82,634
	29	Japan	£51,404
		US	0
		USA	£54,480
	29 Total		£105,884
	30	USA	£28,859
	30 Total		£28,859
	31	Japan	£32,568
		USA	£31,935
	31 Total		£64,503
	33	USA	£116,046
	33 Total		£116,046
	34	USA	£46,126
	34 Total		£46,126
	36	USA	£70,119
	36 Total		£70,119
	37	Japan	£39,615
	37 Total		£39,615
	38	Japan	£64,951
	38 Total		£64,951
	40	Japan	£73,558
	40 Total		£73,558
	42	US	£49,621
	42 Total		£49,621
	43	Japan	£83,387
	43 Total		£83,387
	45	Japan	£129,704
	45 Total		£129,704
	46	Japan	£87,938
	46 Total		£87,938
	48	USA	£64,103
	48 Total		£64,103
	51	United Kingdom	£32,193
	51 Total		£32,193
	52	USA	£53,762
	52 Total		£53,762
	53	US	0
	53 Total		0
	56	USA	£58,265
	56 Total		£58,265
	57	US	£81,705
	57 Total		£81,705
	59	USA	£81,210
	59 Total		£81,210
	60	USA	£149,694
	60 Total		£149,694
	61	Japan	£63,408
	61 Total		£63,408
	63	Japan	£63,808
	63 Total		£63,808
	66	USA	£96,497
	66 Total		£96,497
	69	Japan	0
	69 Total		0
	71	US	0
	71 Total		0
	78	USA	£73,150
	78 Total		£73,150
	92	Japan	0
		USA	0
	92 Total		0
	97	United Kingdom	£86,543
	97 Total		£86,543
	101	Japan	0
	101 Total		0
	103	Japan	0
	103 Total		0
	104	USA	£99,853
	104 Total		£99,853
	117	United Kingdom	£88,598
	117 Total		£88,598
	120	United Kingdom	0
	120 Total		0
	124	United Kingdom	£92,995
	124 Total		£92,995
	126	Japan	0
	126 Total		0
	129	Japan	0
	129 Total		0
	131	USA	0
	131 Total		0
	132	United Kingdom	0
	132 Total		0
	149	United Kingdom	0
	149 Total		0
	152	Japan	0
	152 Total		0
	153	USA	0
	153 Total		0
	159	Japan	0
	159 Total		0
	160	United Kingdom	0
	160 Total		0
	172	USA	0
	172 Total		0
	173	Japan	0
	173 Total		0
	174	United Kingdom	0
	174 Total		0
	176	Japan	0
	176 Total		0
	178	Japan	0
	178 Total		0
	180	USA	0
	180 Total		0
	182	Japan	0
	182 Total		0
	188	USA	0
	188 Total		0
	190	United Kingdom	0
	190 Total		0
	192	USA	0
	192 Total		0
	212	US	0
	212 Total		0
	221	United Kingdom	0
	221 Total		0
	227	Japan	0
	227 Total		0
	264	USA	0
	264 Total		0
	277	USA	0
	277 Total		0
	278	United Kingdom	0
	278 Total		0
	299	USA	0
	299 Total		0
	316	United Kingdom	0
	316 Total		0
	–	United Kingdom	£0
	– Total		£0
2020 Total			£3,777,883
2030	26	USA	£36,247
	26 Total		£36,247
2030 Total			£36,247
Grand Total			£12,484,026

Table B

Year	SUM of Year	COUNTA of MARKET	SUM of Sales Volume
2018	314808	156	10325
2019	331116	164	10035
2020	357540	177	9173
2030	2030	1	26
Grand Total	1005494	498	29559

Table C

*Year*	*Sales Volume*	SUM of Sales Value
2018	-1	-£2,129
	1	£12,007
	2	£5,482
	4	£4,519
	6	£11,572
	7	£12,601
	8	£10,182
	9	£28,733
	10	£30,393
	12	£21,907
	13	£15,764
	14	£16,182
	15	£16,636
	17	£97,260
	18	£102,158
	19	£90,754
	20	£64,743
	21	£36,115
	22	£125,052
	23	£60,019
	24	£68,285
	25	£89,872
	26	£30,546
	27	£104,966
	28	£66,960
	30	£87,112
	31	£86,296
	32	£37,469
	33	£26,916
	34	£33,693
	35	£39,457
	36	£36,727
	37	£40,787
	38	£39,468
	40	£91,419
	42	£40,361
	43	£34,783
	44	£42,258
	45	£168,260
	46	£45,335
	47	£38,960
	48	£103,001
	50	£68,285
	52	£64,892
	53	£50,285
	57	£39,123
	58	£185,676
	60	£67,015
	64	£79,271
	68	£94,462
	71	£93,038
	72	£93,861
	74	£91,094
	75	£162,889
	77	£56,305
	81	£74,595
	83	0
	84	£88,268
	86	£96,036
	88	0
	90	£66,827
	94	£76,245
	99	86028
	100	£73,234
	101	£164,950
	102	£83,083
	104	£81,612
	107	0
	111	0
	112	£68,567
	115	£87,373
	121	£95,581
	126	0
	127	0
	128	0
	131	0
	137	0
	175	0
	199	0
	202	0
	215	0
	221	0
	230	0
	284	0
	322	0
	324	0
	346	0
	348	0
	357	0
	462	0
	–	£0
2018 Total		£4,401,476
2019	-1	-£1,660
	1	£7,107
	2	£14,892
	3	£7,962
	4	£3,415
	5	£31,101
	6	£21,763
	7	£11,083
	8	£28,125
	9	£13,148
	10	£40,251
	11	£18,869
	12	£55,071
	13	£51,746
	14	£57,842
	15	£13,604
	16	£46,861
	17	£84,089
	18	£65,576
	19	£36,142
	20	£75,232
	21	£44,553
	22	£66,357
	23	£113,875
	24	£131,525
	25	£121,410
	27	£161,248
	28	£115,560
	29	£44,173
	31	£94,795
	32	£32,875
	33	£33,444
	34	£76,947
	35	£71,614
	36	£36,126
	38	£45,654
	39	£247,743
	42	£98,669
	43	£143,202
	44	£84,613
	46	£79,273
	49	£47,400
	51	£51,213
	52	£51,371
	54	£62,559
	57	£147,364
	61	£153,970
	62	£39,091
	64	£89,338
	67	£126,544
	69	£80,652
	73	£167,692
	84	£87,336
	89	£95,601
	99	£68,784
	108	0
	112	0
	113	0
	114	£94,621
	117	0
	118	£88,439
	122	£91,996
	123	0
	131	0
	136	£99,306
	137	0
	138	0
	140	0
	141	0
	143	99268
	151	0
	153	0
	160	0
	165	0
	175	0
	177	0
	178	0
	182	0
	186	0
	195	0
	212	0
	221	0
	226	0
	237	0
	246	0
	262	0
	396	0
	610	0
2019 Total		£4,268,420
2020	1	£6,836
	2	£7,044
	3	£17,344
	4	£30,357
	5	£50,883
	6	£35,657
	7	£23,604
	8	£38,289
	9	£87,907
	10	£66,105
	11	£69,326
	12	£66,424
	13	£59,557
	14	£81,819
	15	£95,940
	16	£103,161
	17	£14,287
	18	£137,341
	19	£97,459
	20	£68,087
	21	£44,262
	22	£73,245
	23	£24,983
	24	£41,429
	25	£31,276
	26	£95,063
	27	£81,469
	28	£82,634
	29	£105,884
	30	£28,859
	31	£64,503
	33	£116,046
	34	£46,126
	36	£70,119
	37	£39,615
	38	£64,951
	40	£73,558
	42	£49,621
	43	£83,387
	45	£129,704
	46	£87,938
	48	£64,103
	51	£32,193
	52	£53,762
	53	0
	56	£58,265
	57	£81,705
	59	£81,210
	60	£149,694
	61	£63,408
	63	£63,808
	66	£96,497
	69	0
	71	0
	78	£73,150
	92	0
	97	£86,543
	101	0
	103	0
	104	£99,853
	117	£88,598
	120	0
	124	£92,995
	126	0
	129	0
	131	0
	132	0
	149	0
	152	0
	153	0
	159	0
	160	0
	172	0
	173	0
	174	0
	176	0
	178	0
	180	0
	182	0
	188	0
	190	0
	192	0
	212	0
	221	0
	227	0
	264	0
	277	0
	278	0
	299	0
	316	0
	–	£0
2020 Total		£3,777,883
2030	26	£36,247
2030 Total		£36,247
Grand Total		£12,484,026