Peter and Lois have decided to expand the business because they are convinced that there will be a house building explosion in the next few years and kitchen sales will skyrocket. Stewie is not convinced and has obtained data from the Office of National Statistics (ONS) that likely correlates with kitchen sales: UK population growth and houses built in the past ten years statistics. Stewie is convinced that this data should have been used in his parents' decision to expand the business, as such, the data should be appropriately collated and presented.

Your are required to:

1. Using spreadsheets: "Data-Population" and "Data-Houses Built" in the assignment workbook; create an interactive dashboard on the partially completed "Dashboard" worksheet to include a:
   1. bar chart of the population by region over the years using "YEAR" as the slicer;
   2. line graph of houses built over the years using "category" as a slicer and;
   3. cluster column chart showing year-on-year changes in the number of houses built. The slicer at (ii) above should work with this.
2. In your report, explain ways in which the directors could have used the data to make the decision to expand a more scientific/empirical approach. Using the data and other pertinent social, economic, technical and political events to critically assess whether the directors are correct in their assertion that kitchen sales will grow in the next few years.

Table 1.1: Data-Population

Population estimates for Government Office Regions (GOR), by single year of and sex, 2010 to mid-2020
Year	Regions	All Persons	All Males	All Females
2010	North East	2,586,868	1,263,696	1,323,172
2010	North West	7,019,921	3,446,551	3,573,370
2010	Yorkshire and The Humber	5,254,788	2,582,634	2,672,154
2010	East Midlands	4,507,071	2,221,698	2,285,373
2010	West Midlands	5,565,866	2,743,229	2,822,637
2010	East	5,807,402	2,855,503	2,951,899
2010	London	8,061,495	3,975,939	4,085,556
2010	South East	8,577,771	4,210,659	4,367,112
2010	South West	5,261,270	2,577,335	2,683,935
2011	North East	2,596,441	1,269,598	1,326,843
2011	North West	7,055,961	3,467,727	3,588,234
2011	Yorkshire and The Humber	5,288,212	2,601,969	2,686,243
2011	East Midlands	4,537,448	2,236,979	2,300,469
2011	West Midlands	5,608,667	2,767,260	2,841,407
2011	East	5,862,418	2,885,001	2,977,417
2011	London	8,204,407	4,053,962	4,150,445
2011	South East	8,652,784	4,251,422	4,401,362
2011	South West	5,300,831	2,599,244	2,701,587
2012	North East	2,602,387	1,273,228	1,329,159
2012	North West	7,084,470	3,483,782	3,600,688
2012	Yorkshire and The Humber	5,316,897	2,618,110	2,698,787
2012	East Midlands	4,567,798	2,251,991	2,315,807
2012	West Midlands	5,642,763	2,786,076	2,856,687
2012	East	5,905,914	2,905,789	3,000,125
2012	London	8,308,833	4,106,055	4,202,778
2012	South East	8,724,928	4,288,336	4,436,592
2012	South West	5,339,739	2,620,081	2,719,658
2013	North East	2,610,563	1,278,374	1,332,189
2013	North West	7,103,488	3,495,012	3,608,476
2013	Yorkshire and The Humber	5,337,940	2,630,036	2,707,904
2013	East Midlands	4,598,548	2,267,917	2,330,631
2013	West Midlands	5,675,030	2,803,779	2,871,251
2013	East	5,951,934	2,928,639	3,023,295
2013	London	8,417,458	4,165,752	4,251,706
2013	South East	8,793,154	4,323,843	4,469,311
2013	South West	5,377,702	2,640,617	2,737,085
2014	North East	2,618,736	1,283,116	1,335,620
2014	North West	7,133,026	3,511,220	3,621,806
2014	Yorkshire and The Humber	5,360,117	2,641,368	2,718,749
2014	East Midlands	4,637,369	2,288,061	2,349,308
2014	West Midlands	5,713,439	2,824,444	2,888,995
2014	East	6,017,250	2,962,149	3,055,101
2014	London	8,539,398	4,234,346	4,305,052
2014	South East	8,874,005	4,364,820	4,509,185
2014	South West	5,423,278	2,663,672	2,759,606
2015	North East	2,624,579	1,287,124	1,337,455
2015	North West	7,175,178	3,535,054	3,640,124
2015	Yorkshire and The Humber	5,390,211	2,658,196	2,732,015
2015	East Midlands	4,677,425	2,309,324	2,368,101
2015	West Midlands	5,755,032	2,846,808	2,908,224
2015	East	6,075,970	2,993,400	3,082,570
2015	London	8,666,930	4,305,606	4,361,324
2015	South East	8,949,392	4,405,125	4,544,267
2015	South West	5,471,610	2,688,649	2,782,961
2016	North East	2,636,589	1,293,982	1,342,607
2016	North West	7,223,961	3,563,196	3,660,765
2016	Yorkshire and The Humber	5,425,370	2,678,166	2,747,204
2016	East Midlands	4,725,390	2,335,322	2,390,068
2016	West Midlands	5,810,773	2,878,130	2,932,643
2016	East	6,129,005	3,021,335	3,107,670
2016	London	8,769,659	4,369,201	4,400,458
2016	South East	9,030,347	4,449,245	4,581,102
2016	South West	5,516,973	2,712,343	2,804,630
2017	North East	2,644,727	1,297,924	1,346,803
2017	North West	7,258,627	3,581,219	3,677,408
2017	Yorkshire and The Humber	5,450,130	2,690,510	2,759,620
2017	East Midlands	4,771,666	2,359,406	2,412,260
2017	West Midlands	5,860,706	2,904,272	2,956,434
2017	East	6,168,432	3,040,283	3,128,149
2017	London	8,825,001	4,398,848	4,426,153
2017	South East	9,080,825	4,474,409	4,606,416
2017	South West	5,559,316	2,734,182	2,825,134
2018	North East	2,657,909	1,305,486	1,352,423
2018	North West	7,292,093	3,598,698	3,693,395
2018	Yorkshire and The Humber	5,479,615	2,704,526	2,775,089
2018	East Midlands	4,804,149	2,375,362	2,428,787
2018	West Midlands	5,900,757	2,924,175	2,976,582
2018	East	6,201,214	3,055,520	3,145,694
2018	London	8,908,081	4,448,930	4,459,151
2018	South East	9,133,625	4,500,331	4,633,294
2018	South West	5,599,735	2,754,914	2,844,821
2019	North East	2,669,941	1,312,124	1,357,817
2019	North West	7,341,196	3,625,650	3,715,546
2019	Yorkshire and The Humber	5,502,967	2,717,432	2,785,535
2019	East Midlands	4,835,928	2,391,957	2,443,971
2019	West Midlands	5,934,037	2,941,291	2,992,746
2019	East	6,236,072	3,072,499	3,163,573
2019	London	8,961,989	4,475,817	4,486,172
2019	South East	9,180,135	4,523,939	4,656,196
2019	South West	5,624,696	2,767,122	2,857,574
2020	North East	2,680,763	1,317,749	1,363,014
2020	North West	7,367,456	3,640,348	3,727,108
2020	Yorkshire and The Humber	5,526,350	2,728,685	2,797,665
2020	East Midlands	4,865,583	2,407,678	2,457,905
2020	West Midlands	5,961,929	2,956,945	3,004,984
2020	East	6,269,161	3,089,445	3,179,716
2020	London	9,002,488	4,514,378	4,488,110
2020	South East	9,217,265	4,542,648	4,674,617
2020	South West	5,659,143	2,784,942	2,874,201

Table 1.2: -Data-Housing Built

Source: Office of National Statistics (ONS)
HOUSE BUILDINGS COMPLETED IN ENGLAND 2010-2020
YEAR	CATEGORY	Completed Houses
2010	Private Enterprise	83,280
2010	Housing Association	22,660
2010	Local Authorities	790
2010	All Dwellings	106,730
2011	Private Enterprise	85,890
2011	Housing Association	25,950
2011	Local Authorities	2,230
2011	All Dwellings	114,030
2012	Private Enterprise	88,750
2012	Housing Association	25,440
2012	Local Authorities	1,410
2012	All Dwellings	115,590
2013	Private Enterprise	87,010
2013	Housing Association	21,600
2013	Local Authorities	840
2013	All Dwellings	109,450
2014	Private Enterprise	92,850
2014	Housing Association	23,790
2014	Local Authorities	1,180
2014	All Dwellings	117,820
2015	Private Enterprise	110,700
2015	Housing Association	30,130
2015	Local Authorities	1,660
2015	All Dwellings	142,480
2016	Private Enterprise	115,350
2016	Housing Association	24,430
2016	Local Authorities	2,110
2016	All Dwellings	141,880
2017	Private Enterprise	133,460
2017	Housing Association	27,290
2017	Local Authorities	1,750
2017	All Dwellings	162,470
2018	Private Enterprise	135,190
2018	Housing Association	27,550
2018	Local Authorities	2,680
2018	All Dwellings	165,420
2019	Private Enterprise	144,080
2019	Housing Association	32,040
2019	Local Authorities	2,190
2019	All Dwellings	178,300
2020	Private Enterprise	114,542
2020	Housing Association	27,248
2020	Local Authorities	1,040
2020	All Dwellings	142,830

This the worksheet dashboard format below

KITCHEN CRAZE plc

NON-FINANCIAL DATA MONITORING DASHBOARD

References

Arnold, G.A. Lewis D (2019) Corporate Financial ManagementSixth edition Pearson Publishers

Wood, F,(2018) Business Accounting Volume 1, 14 edition ,Pearson Publishers

Drury, C. (2013) Management & Cost Accounting, Low-priced edition, Cengage Learning.