Bus0002 The Demand And Sales Assessment Answers

As part of the formal assessment for the programme you are required to submit a Using Information assessment. Please refer to your Student Handbook for full details of the programme assessment scheme and general information on preparing and submitting assignments. Learning Outcomes:

1) Investigate data types and discuss their worth to an organisation2) Understand the principles behind the construction of published financial statements.

3) Gain an appreciation of how data analytics can inform decision making within an organisation.

4) Use published data to inform a marketing decision

5) Calculate and comment on standard deviation 6) Explain how organisations can use data to improve quality. Maximum word count for the module: 1,000 words (Equivalent) Please note that exceeding the word count by over 10% will result in a reduction in grade by the same percentage that the word count is exceeded. You must not include your name in your submission because Arden University operates anonymous marking, which means that markers should not be aware of the identity of the student. However, please do not forget to include your STU number.

Page 3 of 6 Assignment Task: Assessment Part 3 Financial statements are written records of a business's financial situation. They stand as one of the more essential components of business information. a) Students are required to organise themselves into groups of three (3) students. b) As a group you are required to prepare and present in class a Group Presentation on principles behind the construction of published financial statements and which main statements form part of the published financial statements. Apply these principles to the 2017 Pets at Home financial statements which can be obtained from page 116 onwards from

Further Instructions:

• This presentation is worth 50% of the total marks for the module

• The Group Presentation work will be assessed in class by your module tutor and each student must present part of the presentation.

• Each group must not be more than 3 students. Members of the group must be approved by the tutor prior to the presentation taking place.

• Each student will receive equal marks for the Group Presentation task.

• Maximum time allowed for each Group Presentation: 30 minutes

• Failure to attend the scheduled presentation session and deliver in person will result in a non-submission for which a mark of zero will be recorded'.

• Each student must upload the presentation to the turnitin portal. Failure to do so will result in a mark of zero. References: Pets at Home, 2017. Annual Report 2017.

Page 4 of 6 Student Guidelines Development of academic skills: You MUST underpin your analysis and evaluation of the key issues with appropriate and wide ranging academic research and ensure this is referenced using the AU Harvard system. The My Study Skills Area contains the following useful resources: Guide to Harvard Referencing You must use the AU Harvard Referencing method in your assignment. Word Count: Students are required to indicate the exact word count on the title page of the assessment. The word count excludes the title page, executive summary, reference list and appendices. Where assessment questions have been reprinted from the assessment brief these will also be excluded from the word count.

ALL other printed words ARE included in the word count. Printed words include those contained within charts and tables. See ‘Word Count Policy’ on the homepage of this module for more information. Submission Guidance: Assignments submitted late will not be accepted and will be marked as a 0% fail. Your assessment should be submitted as a single Word (MS Word) or PDF file. For more information please see the “Guide to Submitting an Assignment” document available on the module page on iLearn. You must ensure that the submitted assignment is all your own work and that all sources used are correctly attributed. Penalties apply to assignments which show evidence of academic unfair practice. (See the Student Handbook which is on the homepage of your module and also in the Induction Area).

Answer:

As per the given question which deals with the demand and sales of Arden Sunglass ltd which operates in UK. As per the estimates and the figure which is shown above it can clearly be identified that the demand for the products of the business is much more than what is supplied by the company. The blue lines in the chart represents the demand for the products of the business and the red lines show the sales of the business. The general trend shows that the demand for the business is much higher tan what is supplied by the business.

Answer to Question 2 Average Monthly Market Shares

Year	Month	Demand (£)	Sales (£)	Monthly Market Share	Revised Market Share
2001	Jan-01	£ 3,68,551	£ 1,88,833	51.24%
2001	Feb-01	£ 4,17,129	£ 1,31,313	31.48%
2001	Mar-01	£ 5,16,926	£ 95,541	18.48%	25.92%
2001	Apr-01	£ 6,50,967	£ 1,08,844	16.72%	26.09%
2001	May-01	£ 7,06,384	£ 1,59,208	22.54%	30.80%
2001	Jun-01	£ 7,55,445	£ 2,33,739	30.94%	35.91%
2001	Jul-01	£ 7,03,159	£ 3,30,675	47.03%	46.81%
2001	Aug-01	£ 6,20,501	£ 3,47,421	55.99%	45.99%
2001	Sep-01	£ 5,54,541	£ 3,92,409	70.76%	55.81%
2001	Oct-01	£ 4,52,446	£ 3,56,307	78.75%	57.42%
2001	Nov-01	£ 3,71,170	£ 3,07,694	82.90%	55.49%
2001	Dec-01	£ 3,34,718	£ 2,33,252	69.69%	51.55%
2002	Jan-02	£ 3,57,444	£ 1,52,285	42.60%	41.03%
2002	Feb-02	£ 4,34,993	£ 1,24,103	28.53%	37.08%
2002	Mar-02	£ 5,22,225	£ 1,49,449	28.62%	41.81%
2002	Apr-02	£ 6,35,459	£ 1,48,283	23.33%	34.09%
2002	May-02	£ 7,21,944	£ 1,86,184	25.79%	35.65%
2002	Jun-02	£ 7,64,136	£ 2,34,520	30.69%	36.91%
2002	Jul-02	£ 7,27,818	£ 3,18,466	43.76%	44.11%
2002	Aug-02	£ 6,46,976	£ 3,34,721	51.74%	43.80%
2002	Sep-02	£ 5,46,411	£ 3,53,894	64.77%	48.62%
2002	Oct-02	£ 4,34,262	£ 3,69,437	85.07%	57.10%
2002	Nov-02	£ 3,78,414	£ 2,80,724	74.18%	51.38%
2002	Dec-02	£ 3,54,169	£ 2,23,584	63.13%	51.49%
2003	Jan-03	£ 3,89,224	£ 1,96,541	50.50%	51.94%
2003	Feb-03	£ 4,79,703	£ 1,57,239	32.78%	44.40%
2003	Mar-03	£ 5,43,848	£ 1,30,796	24.05%	33.60%
2003	Apr-03	£ 6,67,792	£ 1,62,568	24.34%	33.89%
2003	May-03	£ 7,24,583	£ 2,04,618	28.24%	37.62%
2003	Jun-03	£ 7,49,334	£ 2,18,974	29.22%	32.79%
2003	Jul-03	£ 7,21,558	£ 3,10,977	43.10%	42.92%
2003	Aug-03	£ 6,73,315	£ 3,49,912	51.97%	46.70%
2003	Sep-03	£ 5,46,640	£ 4,03,055	73.73%	55.86%
2003	Oct-03	£ 4,51,759	£ 3,46,284	76.65%	51.43%
2003	Nov-03	£ 3,73,478	£ 3,31,439	88.74%	60.63%
2003	Dec-03	£ 3,53,049	£ 2,40,809	68.21%	53.30%
2004	Jan-04	£ 3,68,165	£ 2,14,897	58.37%	57.54%
2004	Feb-04	£ 4,70,002	£ 1,11,597	23.74%	31.61%
2004	Mar-04	£ 5,66,494	£ 1,14,126	20.15%	31.00%
2004	Apr-04	£ 6,82,433	£ 1,25,591	18.40%	26.72%
2004	May-04	£ 7,48,126	£ 2,02,967	27.13%	35.83%
2004	Jun-04	£ 7,76,188	£ 2,72,444	35.10%	39.92%
2004	Jul-04	£ 7,56,433	£ 3,37,146	44.57%	45.07%
2004	Aug-04	£ 6,54,757	£ 3,95,260	60.37%	50.92%
2004	Sep-04	£ 5,76,538	£ 3,53,852	61.38%	46.78%
2004	Oct-04	£ 4,55,581	£ 3,66,877	80.53%	56.03%
2004	Nov-04	£ 3,91,628	£ 3,19,445	81.57%	55.41%
2004	Dec-04	£ 3,71,070	£ 2,38,536	64.28%	52.36%
2005	Jan-05	£ 3,88,952	£ 2,12,728	54.69%	54.32%
2005	Feb-05	£ 4,96,429	£ 1,57,913	31.81%	42.56%
2005	Mar-05	£ 5,96,610	£ 1,59,828	26.79%	41.09%
2005	Apr-05	£ 6,89,463	£ 1,50,522	21.83%	30.32%
2005	May-05	£ 7,56,782	£ 2,06,948	27.35%	34.69%
2005	Jun-05	£ 7,87,665	£ 2,81,104	35.69%	40.77%
2005	Jul-05	£ 7,61,154	£ 3,00,531	39.48%	39.71%
2005	Aug-05	£ 6,61,650	£ 3,87,069	58.50%	49.14%
2005	Sep-05	£ 5,80,530	£ 3,80,822	65.60%	50.03%
2005	Oct-05	£ 4,90,041	£ 3,44,330	70.27%	52.04%
2005	Nov-05	£ 3,93,041	£ 3,55,658	90.49%	61.26%
2005	Dec-05	£ 3,74,507	£ 2,36,762	63.22%	48.31%
2006	Jan-06	£ 4,14,412	£ 1,89,410	45.71%	48.19%
2006	Feb-06	£ 4,62,493	£ 1,79,046	38.71%	47.81%
2006	Mar-06	£ 5,86,895	£ 1,35,035	23.01%	32.58%
2006	Apr-06	£ 7,08,987	£ 1,74,693	24.64%	37.77%
2006	May-06	£ 7,48,793	£ 1,73,687	23.20%	29.59%
2006	Jun-06	£ 7,76,754	£ 2,74,845	35.38%	38.77%
2006	Jul-06	£ 7,46,006	£ 3,64,719	48.89%	48.71%
2006	Aug-06	£ 7,00,271	£ 3,81,602	54.49%	49.13%
2006	Sep-06	£ 5,92,744	£ 3,65,345	61.64%	48.97%
2006	Oct-06	£ 4,95,922	£ 4,00,814	80.82%	57.24%
2006	Nov-06	£ 4,19,281	£ 3,39,103	80.88%	57.21%
2006	Dec-06	£ 4,00,245	£ 2,32,415	58.07%	46.87%
2007	Jan-07	£ 4,13,332	£ 1,87,342	45.32%	44.68%
2007	Feb-07	£ 5,12,546	£ 1,55,212	30.28%	38.78%
2007	Mar-07	£ 6,02,873	£ 1,22,653	20.34%	29.67%
2007	Apr-07	£ 7,05,970	£ 1,89,631	26.86%	37.00%
2007	May-07	£ 7,65,270	£ 2,31,431	30.24%	38.39%
2007	Jun-07	£ 7,99,129	£ 2,77,533	34.73%	39.31%
2007	Jul-07	£ 7,55,094	£ 3,67,372	48.65%	48.01%
2007	Aug-07	£ 6,79,151	£ 4,15,329	61.15%	51.97%
2007	Sep-07	£ 6,16,253	£ 4,19,558	68.08%	55.56%
2007	Oct-07	£ 4,72,628	£ 4,14,523	87.71%	61.04%
2007	Nov-07	£ 3,99,200	£ 3,01,126	75.43%	48.86%
2007	Dec-07	£ 3,91,921	£ 2,50,647	63.95%	53.03%
2008	Jan-08	£ 4,27,679	£ 1,78,605	41.76%	44.74%
2008	Feb-08	£ 4,92,368	£ 1,36,639	27.75%	34.86%
2008	Mar-08	£ 6,14,959	£ 1,43,836	23.39%	33.63%
2008	Apr-08	£ 6,93,240	£ 1,67,242	24.12%	33.97%
2008	May-08	£ 7,99,444	£ 2,17,811	27.25%	35.42%
2008	Jun-08	£ 7,98,267	£ 2,90,159	36.35%	41.86%
2008	Jul-08	£ 7,95,411	£ 3,71,498	46.71%	46.47%
2008	Aug-08	£ 7,22,298	£ 3,81,659	52.84%	47.81%
2008	Sep-08	£ 6,27,368	£ 4,07,801	65.00%	51.27%
2008	Oct-08	£ 5,21,100	£ 4,21,426	80.87%	58.35%
2008	Nov-08	£ 4,11,721	£ 3,42,156	83.10%	54.54%
2008	Dec-08	£ 3,83,842	£ 2,75,783	71.85%	52.92%
2009	Jan-09	£ 4,53,359	£ 2,02,672	44.70%	49.23%
2009	Feb-09	£ 5,17,732	£ 1,72,103	33.24%	44.84%
2009	Mar-09	£ 5,99,005	£ 1,76,633	29.49%	38.96%
2009	Apr-09	£ 7,31,081	£ 1,62,386	22.21%	31.36%
2009	May-09	£ 7,93,971	£ 2,47,816	31.21%	41.37%
2009	Jun-09	£ 8,05,458	£ 3,04,580	37.81%	41.66%
2009	Jul-09	£ 7,73,524	£ 3,35,442	43.37%	42.25%
2009	Aug-09	£ 7,10,963	£ 4,24,563	59.72%	52.71%
2009	Sep-09	£ 6,35,133	£ 4,13,634	65.13%	53.47%
2009	Oct-09	£ 5,12,081	£ 3,79,183	74.05%	53.33%
2009	Nov-09	£ 4,25,599	£ 3,29,763	77.48%	51.92%
2009	Dec-09	£ 4,29,413	£ 2,88,527	67.19%	56.34%
2010	Jan-10	£ 4,66,543	£ 2,26,867	48.63%	53.31%
2010	Feb-10	£ 5,33,329	£ 2,00,340	37.56%	46.65%
2010	Mar-10	£ 6,43,751	£ 1,65,747	25.75%	35.53%
2010	Apr-10	£ 7,39,483	£ 1,81,876	24.59%	34.10%
2010	May-10	£ 7,93,430	£ 1,91,366	24.12%	29.73%
2010	Jun-10	£ 8,36,175	£ 2,58,123	30.87%	34.91%
2010	Jul-10	£ 7,86,523	£ 3,40,356	43.27%	42.90%
2010	Aug-10	£ 7,34,067	£ 3,83,218	52.20%	45.83%
2010	Sep-10	£ 6,36,764	£ 4,38,370	68.84%	55.74%
2010	Oct-10	£ 5,05,462	£ 3,73,699	73.93%	50.91%
2010	Nov-10	£ 4,29,084	£ 3,18,881	74.32%	50.08%
2010	Dec-10	£ 4,22,953	£ 2,58,400	61.09%	51.12%
2011	Jan-11	£ 4,83,868	£ 2,05,095	42.39%	47.80%
2011	Feb-11	£ 5,14,129	£ 1,84,379	35.86%	43.59%
2011	Mar-11	£ 6,34,846	£ 1,48,466	23.39%	30.68%
2011	Apr-11	£ 7,38,248	£ 1,99,542	27.03%	38.81%
2011	May-11	£ 8,11,725	£ 2,58,566	31.85%	40.73%
2011	Jun-11	£ 8,34,698	£ 2,61,849	31.37%	35.47%
2011	Jul-11	£ 8,28,170	£ 3,64,157	43.97%	44.86%
2011	Aug-11	£ 7,41,671	£ 3,82,399	51.56%	45.81%
2011	Sep-11	£ 6,36,436	£ 3,95,055	62.07%	47.70%
2011	Oct-11	£ 5,53,502	£ 3,77,827	68.26%	50.94%
2011	Nov-11	£ 4,52,014	£ 3,28,066	72.58%	51.55%
2011	Dec-11	£ 4,52,216	£ 3,12,667	69.14%	56.49%
2012	Jan-12	£ 4,87,394	£ 2,11,082	43.31%	46.70%
2012	Feb-12	£ 5,22,653	£ 2,02,939	38.83%	44.88%
2012	Mar-12	£ 6,59,668	£ 1,74,763	26.49%	35.86%
2012	Apr-12	£ 7,44,208	£ 1,51,858	20.41%	29.06%
2012	May-12	£ 8,28,512	£ 2,14,952	25.94%	32.58%
2012	Jun-12	£ 8,49,146	£ 2,97,545	35.04%	39.98%
2012	Jul-12	£ 8,29,490	£ 3,33,210	40.17%	40.22%
2012	Aug-12	£ 7,51,352	£ 4,23,666	56.39%	49.89%
2012	Sep-12	£ 6,23,291	£ 4,01,552	64.42%	48.41%
2012	Oct-12	£ 5,55,211	£ 3,79,735	68.39%	50.54%
2012	Nov-12	£ 4,77,199	£ 3,61,852	75.83%	58.06%
2012	Dec-12	£ 4,51,020	£ 2,83,640	62.89%	51.09%
2013	Jan-13	£ 5,03,591	£ 2,61,158	51.86%	54.73%
2013	Feb-13	£ 5,41,958	£ 1,78,947	33.02%	39.68%
2013	Mar-13	£ 6,44,774	£ 1,68,390	26.12%	33.44%
2013	Apr-13	£ 7,41,074	£ 1,66,317	22.44%	30.69%
2013	May-13	£ 8,29,153	£ 2,53,373	30.56%	39.30%
2013	Jun-13	£ 8,31,079	£ 2,79,125	33.59%	37.66%
2013	Jul-13	£ 8,43,282	£ 3,97,302	47.11%	47.92%
2013	Aug-13	£ 7,47,221	£ 4,07,504	54.54%	49.03%
2013	Sep-13	£ 6,70,408	£ 4,39,103	65.50%	52.07%
2013	Oct-13	£ 5,33,377	£ 4,23,265	79.36%	56.65%
2013	Nov-13	£ 4,72,841	£ 3,61,822	76.52%	53.97%
2013	Dec-13	£ 4,35,820	£ 2,84,288	65.23%	53.30%
2014	Jan-14	£ 4,75,700	£ 2,14,241	45.04%	45.31%
2014	Feb-14	£ 5,54,336	£ 2,04,660	36.92%	46.96%
2014	Mar-14	£ 6,70,708	£ 1,95,692	29.18%	41.14%
2014	Apr-14	£ 7,61,764	£ 2,08,952	27.43%	37.69%
2014	May-14	£ 8,35,209	£ 2,53,961	30.41%	37.86%
2014	Jun-14	£ 8,64,701	£ 3,36,268	38.89%	44.14%
2014	Jul-14	£ 8,38,229	£ 3,78,643	45.17%	45.34%
2014	Aug-14	£ 7,73,076	£ 4,19,389	54.25%	48.50%
2014	Sep-14	£ 6,62,804	£ 4,56,313	68.85%	54.44%
2014	Oct-14	£ 5,41,434	£ 4,39,824	81.23%	56.89%
2014	Nov-14	£ 5,13,704	£ 3,68,689	71.77%	55.63%
2014	Dec-14	£ 4,54,391	£ 3,38,282	74.45%	62.48%
2015	Jan-15	£ 5,05,783	£ 2,49,627	49.35%	48.59%
2015	Feb-15	£ 5,94,044	£ 1,78,664	30.08%	39.32%
2015	Mar-15	£ 6,89,387	£ 1,56,912	22.76%	31.02%
2015	Apr-15	£ 7,92,840	£ 2,31,568	29.21%	38.98%
2015	May-15	£ 8,57,460	£ 2,41,777	28.20%	35.07%
2015	Jun-15	£ 8,50,573	£ 2,99,204	35.18%	37.74%
2015	Jul-15	£ 8,52,187	£ 4,05,570	47.59%	47.30%
2015	Aug-15	£ 7,85,422	£ 4,06,918	51.81%	47.84%
2015	Sep-15	£ 6,97,142	£ 4,06,795	58.35%	47.74%
2015	Oct-15	£ 5,99,251	£ 3,91,781	65.38%	49.88%
2015	Nov-15	£ 5,20,934	£ 3,94,270	75.69%	56.56%
2015	Dec-15	£ 4,50,174	£ 2,78,326	61.83%	46.45%
2016	Jan-16	£ 5,16,842	£ 2,18,522	42.28%	41.95%
2016	Feb-16	£ 5,65,665	£ 2,08,426	36.85%	46.30%
2016	Mar-16	£ 6,99,158	£ 1,96,521	28.11%	38.02%
2016	Apr-16	£ 8,08,765	£ 2,19,456	27.13%	38.80%
2016	May-16	£ 8,47,392	£ 2,39,685	28.29%	34.28%
2016	Jun-16	£ 8,79,403	£ 2,88,358	32.79%	35.65%
2016	Jul-16	£ 8,42,308	£ 3,55,794	42.24%	41.99%
2016	Aug-16	£ 7,84,861	£ 4,48,950	57.20%	51.05%
2016	Sep-16	£ 7,00,383	£ 4,26,546	60.90%	50.64%
2016	Oct-16	£ 5,94,204	£ 4,48,496	75.48%	57.14%
2016	Nov-16	£ 4,93,375	£ 3,96,732	80.41%	56.64%
2016	Dec-16	£ 4,73,624	£ 3,45,353	72.92%	58.12%
2017	Jan-17	£ 5,41,584	£ 2,55,315	47.14%	51.75%
2017	Feb-17	£ 5,87,806	£ 2,13,980	36.40%	45.18%
2017	Mar-17	£ 7,06,489	£ 2,16,828	30.69%	40.04%
2017	Apr-17	£ 7,98,722	£ 2,31,211	28.95%	39.33%
2017	May-17	£ 8,89,284	£ 2,74,710	30.89%	38.88%
2017	Jun-17	£ 8,71,860	£ 3,32,658	38.16%	41.65%
2017	Jul-17	£ 8,76,995	£ 3,94,499	44.98%	44.36%
2017	Aug-17	£ 8,17,547	£ 4,56,476	55.83%	52.36%
2017	Sep-17	£ 6,81,290	£ 4,50,068	66.06%	51.32%
2017	Oct-17	£ 5,79,437	£ 4,57,468	78.95%	55.96%
2017	Nov-17	£ 5,40,300	£ 3,59,933	66.62%	52.83%
2017	Dec-17	£ 5,19,108	£ 3,02,636	58.30%	52.23%
2018	Jan-18	£ 5,45,416	£ 2,84,025	52.07%	52.57%

Average Monthly Share				48.16%	45.17%

As shown in the above table the average monthly shares for all the years comes to about 48.16% which more than the revised market share which is computed considering the sales which are related to each month happens in two months earlier.

Answer to Question 3

As shown in the above table in question 2, the average monthly rate for the revised strategy is shown to be 45.17% which considers the sales of current year taking place two months earlier.

Answer to Question 4

As per the calculations which is shown in the excel sheet, the options which are available to the business is customer promotion, customer competition, 2 branches option, merge with competitor option and 10 branches option. It is note from the computation that the 10 branches option has the maximum average monthly market shares which shows it is more favorable. The sales which is generated by the 10 branches is much more than any other option.

Answer to Question 5

The option which is to open 10 branches of the company will also be attracting significant amount of costs which is the main reason due to which the revenue generated by the company is not up to the mark with expectations of the business. In addition to this, it will be resulting in difficulty in the managing the operations of the business.

Answer to Question 6

Year	Month	Demand (£)	Sales (£)	Profit Margin	Net Profit (£)	Quarterly Profit(£)
2001	Jan-01	£ 3,68,551	£ 1,88,833	50%	£ 94,416
2001	Feb-01	£ 4,17,129	£ 1,31,313	50%	£ 65,656
2001	Mar-01	£ 5,16,926	£ 95,541	50%	£ 47,771	£ 2,07,843
2001	Apr-01	£ 6,50,967	£ 1,08,844	30%	£ 32,653
2001	May-01	£ 7,06,384	£ 1,59,208	30%	£ 47,762
2001	Jun-01	£ 7,55,445	£ 2,33,739	30%	£ 70,122	£ 1,50,537
2001	Jul-01	£ 7,03,159	£ 3,30,675	25%	£ 82,669
2001	Aug-01	£ 6,20,501	£ 3,47,421	25%	£ 86,855
2001	Sep-01	£ 5,54,541	£ 3,92,409	25%	£ 98,102	£ 2,67,626
2001	Oct-01	£ 4,52,446	£ 3,56,307	40%	£ 1,42,523
2001	Nov-01	£ 3,71,170	£ 3,07,694	40%	£ 1,23,078
2001	Dec-01	£ 3,34,718	£ 2,33,252	40%	£ 93,301	£ 3,58,901
2002	Jan-02	£ 3,57,444	£ 1,52,285	50%	£ 76,142
2002	Feb-02	£ 4,34,993	£ 1,24,103	50%	£ 62,052
2002	Mar-02	£ 5,22,225	£ 1,49,449	50%	£ 74,725	£ 2,12,919
2002	Apr-02	£ 6,35,459	£ 1,48,283	30%	£ 44,485
2002	May-02	£ 7,21,944	£ 1,86,184	30%	£ 55,855
2002	Jun-02	£ 7,64,136	£ 2,34,520	30%	£ 70,356	£ 1,70,696
2002	Jul-02	£ 7,27,818	£ 3,18,466	25%	£ 79,617
2002	Aug-02	£ 6,46,976	£ 3,34,721	25%	£ 83,680
2002	Sep-02	£ 5,46,411	£ 3,53,894	25%	£ 88,473	£ 2,51,770
2002	Oct-02	£ 4,34,262	£ 3,69,437	40%	£ 1,47,775
2002	Nov-02	£ 3,78,414	£ 2,80,724	40%	£ 1,12,289
2002	Dec-02	£ 3,54,169	£ 2,23,584	40%	£ 89,434	£ 3,49,498
2003	Jan-03	£ 3,89,224	£ 1,96,541	50%	£ 98,270
2003	Feb-03	£ 4,79,703	£ 1,57,239	50%	£ 78,620
2003	Mar-03	£ 5,43,848	£ 1,30,796	50%	£ 65,398	£ 2,42,288
2003	Apr-03	£ 6,67,792	£ 1,62,568	30%	£ 48,770
2003	May-03	£ 7,24,583	£ 2,04,618	30%	£ 61,385
2003	Jun-03	£ 7,49,334	£ 2,18,974	30%	£ 65,692	£ 1,75,848
2003	Jul-03	£ 7,21,558	£ 3,10,977	25%	£ 77,744
2003	Aug-03	£ 6,73,315	£ 3,49,912	25%	£ 87,478
2003	Sep-03	£ 5,46,640	£ 4,03,055	25%	£ 1,00,764	£ 2,65,986
2003	Oct-03	£ 4,51,759	£ 3,46,284	40%	£ 1,38,514
2003	Nov-03	£ 3,73,478	£ 3,31,439	40%	£ 1,32,576
2003	Dec-03	£ 3,53,049	£ 2,40,809	40%	£ 96,323	£ 3,67,413
2004	Jan-04	£ 3,68,165	£ 2,14,897	50%	£ 1,07,448
2004	Feb-04	£ 4,70,002	£ 1,11,597	50%	£ 55,799
2004	Mar-04	£ 5,66,494	£ 1,14,126	50%	£ 57,063	£ 2,20,310
2004	Apr-04	£ 6,82,433	£ 1,25,591	30%	£ 37,677
2004	May-04	£ 7,48,126	£ 2,02,967	30%	£ 60,890
2004	Jun-04	£ 7,76,188	£ 2,72,444	30%	£ 81,733	£ 1,80,301
2004	Jul-04	£ 7,56,433	£ 3,37,146	25%	£ 84,286
2004	Aug-04	£ 6,54,757	£ 3,95,260	25%	£ 98,815
2004	Sep-04	£ 5,76,538	£ 3,53,852	25%	£ 88,463	£ 2,71,565
2004	Oct-04	£ 4,55,581	£ 3,66,877	40%	£ 1,46,751
2004	Nov-04	£ 3,91,628	£ 3,19,445	40%	£ 1,27,778
2004	Dec-04	£ 3,71,070	£ 2,38,536	40%	£ 95,414	£ 3,69,943
2005	Jan-05	£ 3,88,952	£ 2,12,728	50%	£ 1,06,364
2005	Feb-05	£ 4,96,429	£ 1,57,913	50%	£ 78,956
2005	Mar-05	£ 5,96,610	£ 1,59,828	50%	£ 79,914	£ 2,65,234
2005	Apr-05	£ 6,89,463	£ 1,50,522	30%	£ 45,157
2005	May-05	£ 7,56,782	£ 2,06,948	30%	£ 62,084
2005	Jun-05	£ 7,87,665	£ 2,81,104	30%	£ 84,331	£ 1,91,572
2005	Jul-05	£ 7,61,154	£ 3,00,531	25%	£ 75,133
2005	Aug-05	£ 6,61,650	£ 3,87,069	25%	£ 96,767
2005	Sep-05	£ 5,80,530	£ 3,80,822	25%	£ 95,206	£ 2,67,106
2005	Oct-05	£ 4,90,041	£ 3,44,330	40%	£ 1,37,732
2005	Nov-05	£ 3,93,041	£ 3,55,658	40%	£ 1,42,263
2005	Dec-05	£ 3,74,507	£ 2,36,762	40%	£ 94,705	£ 3,74,700
2006	Jan-06	£ 4,14,412	£ 1,89,410	50%	£ 94,705
2006	Feb-06	£ 4,62,493	£ 1,79,046	50%	£ 89,523
2006	Mar-06	£ 5,86,895	£ 1,35,035	50%	£ 67,517	£ 2,51,745
2006	Apr-06	£ 7,08,987	£ 1,74,693	30%	£ 52,408
2006	May-06	£ 7,48,793	£ 1,73,687	30%	£ 52,106
2006	Jun-06	£ 7,76,754	£ 2,74,845	30%	£ 82,453	£ 1,86,967
2006	Jul-06	£ 7,46,006	£ 3,64,719	25%	£ 91,180
2006	Aug-06	£ 7,00,271	£ 3,81,602	25%	£ 95,401
2006	Sep-06	£ 5,92,744	£ 3,65,345	25%	£ 91,336	£ 2,77,917
2006	Oct-06	£ 4,95,922	£ 4,00,814	40%	£ 1,60,326
2006	Nov-06	£ 4,19,281	£ 3,39,103	40%	£ 1,35,641
2006	Dec-06	£ 4,00,245	£ 2,32,415	40%	£ 92,966	£ 3,88,933
2007	Jan-07	£ 4,13,332	£ 1,87,342	50%	£ 93,671
2007	Feb-07	£ 5,12,546	£ 1,55,212	50%	£ 77,606
2007	Mar-07	£ 6,02,873	£ 1,22,653	50%	£ 61,326	£ 2,32,603
2007	Apr-07	£ 7,05,970	£ 1,89,631	30%	£ 56,889
2007	May-07	£ 7,65,270	£ 2,31,431	30%	£ 69,429
2007	Jun-07	£ 7,99,129	£ 2,77,533	30%	£ 83,260	£ 2,09,579
2007	Jul-07	£ 7,55,094	£ 3,67,372	25%	£ 91,843
2007	Aug-07	£ 6,79,151	£ 4,15,329	25%	£ 1,03,832
2007	Sep-07	£ 6,16,253	£ 4,19,558	25%	£ 1,04,889	£ 3,00,565
2007	Oct-07	£ 4,72,628	£ 4,14,523	40%	£ 1,65,809
2007	Nov-07	£ 3,99,200	£ 3,01,126	40%	£ 1,20,450
2007	Dec-07	£ 3,91,921	£ 2,50,647	40%	£ 1,00,259	£ 3,86,519
2008	Jan-08	£ 4,27,679	£ 1,78,605	50%	£ 89,302
2008	Feb-08	£ 4,92,368	£ 1,36,639	50%	£ 68,320
2008	Mar-08	£ 6,14,959	£ 1,43,836	50%	£ 71,918	£ 2,29,540
2008	Apr-08	£ 6,93,240	£ 1,67,242	30%	£ 50,173
2008	May-08	£ 7,99,444	£ 2,17,811	30%	£ 65,343
2008	Jun-08	£ 7,98,267	£ 2,90,159	30%	£ 87,048	£ 2,02,564
2008	Jul-08	£ 7,95,411	£ 3,71,498	25%	£ 92,875
2008	Aug-08	£ 7,22,298	£ 3,81,659	25%	£ 95,415
2008	Sep-08	£ 6,27,368	£ 4,07,801	25%	£ 1,01,950	£ 2,90,240
2008	Oct-08	£ 5,21,100	£ 4,21,426	40%	£ 1,68,570
2008	Nov-08	£ 4,11,721	£ 3,42,156	40%	£ 1,36,862
2008	Dec-08	£ 3,83,842	£ 2,75,783	40%	£ 1,10,313	£ 4,15,746
2009	Jan-09	£ 4,53,359	£ 2,02,672	50%	£ 1,01,336
2009	Feb-09	£ 5,17,732	£ 1,72,103	50%	£ 86,051
2009	Mar-09	£ 5,99,005	£ 1,76,633	50%	£ 88,316	£ 2,75,704
2009	Apr-09	£ 7,31,081	£ 1,62,386	30%	£ 48,716
2009	May-09	£ 7,93,971	£ 2,47,816	30%	£ 74,345
2009	Jun-09	£ 8,05,458	£ 3,04,580	30%	£ 91,374	£ 2,14,435
2009	Jul-09	£ 7,73,524	£ 3,35,442	25%	£ 83,861
2009	Aug-09	£ 7,10,963	£ 4,24,563	25%	£ 1,06,141
2009	Sep-09	£ 6,35,133	£ 4,13,634	25%	£ 1,03,408	£ 2,93,410
2009	Oct-09	£ 5,12,081	£ 3,79,183	40%	£ 1,51,673
2009	Nov-09	£ 4,25,599	£ 3,29,763	40%	£ 1,31,905
2009	Dec-09	£ 4,29,413	£ 2,88,527	40%	£ 1,15,411	£ 3,98,990
2010	Jan-10	£ 4,66,543	£ 2,26,867	50%	£ 1,13,434
2010	Feb-10	£ 5,33,329	£ 2,00,340	50%	£ 1,00,170
2010	Mar-10	£ 6,43,751	£ 1,65,747	50%	£ 82,873	£ 2,96,477
2010	Apr-10	£ 7,39,483	£ 1,81,876	30%	£ 54,563
2010	May-10	£ 7,93,430	£ 1,91,366	30%	£ 57,410
2010	Jun-10	£ 8,36,175	£ 2,58,123	30%	£ 77,437	£ 1,89,409
2010	Jul-10	£ 7,86,523	£ 3,40,356	25%	£ 85,089
2010	Aug-10	£ 7,34,067	£ 3,83,218	25%	£ 95,805
2010	Sep-10	£ 6,36,764	£ 4,38,370	25%	£ 1,09,593	£ 2,90,486
2010	Oct-10	£ 5,05,462	£ 3,73,699	40%	£ 1,49,480
2010	Nov-10	£ 4,29,084	£ 3,18,881	40%	£ 1,27,552
2010	Dec-10	£ 4,22,953	£ 2,58,400	40%	£ 1,03,360	£ 3,80,392
2011	Jan-11	£ 4,83,868	£ 2,05,095	50%	£ 1,02,548
2011	Feb-11	£ 5,14,129	£ 1,84,379	50%	£ 92,190
2011	Mar-11	£ 6,34,846	£ 1,48,466	50%	£ 74,233	£ 2,68,970
2011	Apr-11	£ 7,38,248	£ 1,99,542	30%	£ 59,863
2011	May-11	£ 8,11,725	£ 2,58,566	30%	£ 77,570
2011	Jun-11	£ 8,34,698	£ 2,61,849	30%	£ 78,555	£ 2,15,987
2011	Jul-11	£ 8,28,170	£ 3,64,157	25%	£ 91,039
2011	Aug-11	£ 7,41,671	£ 3,82,399	25%	£ 95,600
2011	Sep-11	£ 6,36,436	£ 3,95,055	25%	£ 98,764	£ 2,85,403
2011	Oct-11	£ 5,53,502	£ 3,77,827	40%	£ 1,51,131
2011	Nov-11	£ 4,52,014	£ 3,28,066	40%	£ 1,31,226
2011	Dec-11	£ 4,52,216	£ 3,12,667	40%	£ 1,25,067	£ 4,07,424
2012	Jan-12	£ 4,87,394	£ 2,11,082	50%	£ 1,05,541
2012	Feb-12	£ 5,22,653	£ 2,02,939	50%	£ 1,01,469
2012	Mar-12	£ 6,59,668	£ 1,74,763	50%	£ 87,381	£ 2,94,392
2012	Apr-12	£ 7,44,208	£ 1,51,858	30%	£ 45,557
2012	May-12	£ 8,28,512	£ 2,14,952	30%	£ 64,486
2012	Jun-12	£ 8,49,146	£ 2,97,545	30%	£ 89,264	£ 1,99,307
2012	Jul-12	£ 8,29,490	£ 3,33,210	25%	£ 83,303
2012	Aug-12	£ 7,51,352	£ 4,23,666	25%	£ 1,05,917
2012	Sep-12	£ 6,23,291	£ 4,01,552	25%	£ 1,00,388	£ 2,89,607
2012	Oct-12	£ 5,55,211	£ 3,79,735	40%	£ 1,51,894
2012	Nov-12	£ 4,77,199	£ 3,61,852	40%	£ 1,44,741
2012	Dec-12	£ 4,51,020	£ 2,83,640	40%	£ 1,13,456	£ 4,10,091
2013	Jan-13	£ 5,03,591	£ 2,61,158	50%	£ 1,30,579
2013	Feb-13	£ 5,41,958	£ 1,78,947	50%	£ 89,474
2013	Mar-13	£ 6,44,774	£ 1,68,390	50%	£ 84,195	£ 3,04,247
2013	Apr-13	£ 7,41,074	£ 1,66,317	30%	£ 49,895
2013	May-13	£ 8,29,153	£ 2,53,373	30%	£ 76,012
2013	Jun-13	£ 8,31,079	£ 2,79,125	30%	£ 83,737	£ 2,09,644
2013	Jul-13	£ 8,43,282	£ 3,97,302	25%	£ 99,325
2013	Aug-13	£ 7,47,221	£ 4,07,504	25%	£ 1,01,876
2013	Sep-13	£ 6,70,408	£ 4,39,103	25%	£ 1,09,776	£ 3,10,977
2013	Oct-13	£ 5,33,377	£ 4,23,265	40%	£ 1,69,306
2013	Nov-13	£ 4,72,841	£ 3,61,822	40%	£ 1,44,729
2013	Dec-13	£ 4,35,820	£ 2,84,288	40%	£ 1,13,715	£ 4,27,750
2014	Jan-14	£ 4,75,700	£ 2,14,241	50%	£ 1,07,120
2014	Feb-14	£ 5,54,336	£ 2,04,660	50%	£ 1,02,330
2014	Mar-14	£ 6,70,708	£ 1,95,692	50%	£ 97,846	£ 3,07,296
2014	Apr-14	£ 7,61,764	£ 2,08,952	30%	£ 62,686
2014	May-14	£ 8,35,209	£ 2,53,961	30%	£ 76,188
2014	Jun-14	£ 8,64,701	£ 3,36,268	30%	£ 1,00,881	£ 2,39,755
2014	Jul-14	£ 8,38,229	£ 3,78,643	25%	£ 94,661
2014	Aug-14	£ 7,73,076	£ 4,19,389	25%	£ 1,04,847
2014	Sep-14	£ 6,62,804	£ 4,56,313	25%	£ 1,14,078	£ 3,13,586
2014	Oct-14	£ 5,41,434	£ 4,39,824	40%	£ 1,75,929
2014	Nov-14	£ 5,13,704	£ 3,68,689	40%	£ 1,47,476
2014	Dec-14	£ 4,54,391	£ 3,38,282	40%	£ 1,35,313	£ 4,58,718
2015	Jan-15	£ 5,05,783	£ 2,49,627	50%	£ 1,24,813
2015	Feb-15	£ 5,94,044	£ 1,78,664	50%	£ 89,332
2015	Mar-15	£ 6,89,387	£ 1,56,912	50%	£ 78,456	£ 2,92,601
2015	Apr-15	£ 7,92,840	£ 2,31,568	30%	£ 69,470
2015	May-15	£ 8,57,460	£ 2,41,777	30%	£ 72,533
2015	Jun-15	£ 8,50,573	£ 2,99,204	30%	£ 89,761	£ 2,31,765
2015	Jul-15	£ 8,52,187	£ 4,05,570	25%	£ 1,01,393
2015	Aug-15	£ 7,85,422	£ 4,06,918	25%	£ 1,01,729
2015	Sep-15	£ 6,97,142	£ 4,06,795	25%	£ 1,01,699	£ 3,04,821
2015	Oct-15	£ 5,99,251	£ 3,91,781	40%	£ 1,56,713
2015	Nov-15	£ 5,20,934	£ 3,94,270	40%	£ 1,57,708
2015	Dec-15	£ 4,50,174	£ 2,78,326	40%	£ 1,11,330	£ 4,25,751
2016	Jan-16	£ 5,16,842	£ 2,18,522	50%	£ 1,09,261
2016	Feb-16	£ 5,65,665	£ 2,08,426	50%	£ 1,04,213
2016	Mar-16	£ 6,99,158	£ 1,96,521	50%	£ 98,261	£ 3,11,735
2016	Apr-16	£ 8,08,765	£ 2,19,456	30%	£ 65,837
2016	May-16	£ 8,47,392	£ 2,39,685	30%	£ 71,906
2016	Jun-16	£ 8,79,403	£ 2,88,358	30%	£ 86,508	£ 2,24,250
2016	Jul-16	£ 8,42,308	£ 3,55,794	25%	£ 88,949
2016	Aug-16	£ 7,84,861	£ 4,48,950	25%	£ 1,12,237
2016	Sep-16	£ 7,00,383	£ 4,26,546	25%	£ 1,06,636	£ 3,07,822
2016	Oct-16	£ 5,94,204	£ 4,48,496	40%	£ 1,79,398
2016	Nov-16	£ 4,93,375	£ 3,96,732	40%	£ 1,58,693
2016	Dec-16	£ 4,73,624	£ 3,45,353	40%	£ 1,38,141	£ 4,76,232
2017	Jan-17	£ 5,41,584	£ 2,55,315	50%	£ 1,27,657
2017	Feb-17	£ 5,87,806	£ 2,13,980	50%	£ 1,06,990
2017	Mar-17	£ 7,06,489	£ 2,16,828	50%	£ 1,08,414	£ 3,43,062
2017	Apr-17	£ 7,98,722	£ 2,31,211	30%	£ 69,363
2017	May-17	£ 8,89,284	£ 2,74,710	30%	£ 82,413
2017	Jun-17	£ 8,71,860	£ 3,32,658	30%	£ 99,797	£ 2,51,574
2017	Jul-17	£ 8,76,995	£ 3,94,499	25%	£ 98,625
2017	Aug-17	£ 8,17,547	£ 4,56,476	25%	£ 1,14,119
2017	Sep-17	£ 6,81,290	£ 4,50,068	25%	£ 1,12,517	£ 3,25,261
2017	Oct-17	£ 5,79,437	£ 4,57,468	40%	£ 1,82,987
2017	Nov-17	£ 5,40,300	£ 3,59,933	40%	£ 1,43,973
2017	Dec-17	£ 5,19,108	£ 3,02,636	40%	£ 1,21,055	£ 4,48,015
2018	Jan-18	£ 5,45,416	£ 2,84,025	40%	£ 1,13,610

Highest Profit						£ 4,76,232

The highest profit is shown in the month of December 2016 which is shown to be £ 4,76,232 and the same is shown as highest in the table which is shown above.

Answer to Question 7


Year	Month	Demand (£)	Sales (£)	Profit Margin	Net Profit (£)	Increase in Profit	Increase of Quarterly Profit
2001	Jan-01	£ 3,68,551	£ 1,88,833	50%	£ 94,416	7,553.30
2001	Feb-01	£ 4,17,129	£ 1,31,313	50%	£ 65,656	5,252.52
2001	Mar-01	£ 5,16,926	£ 95,541	50%	£ 47,771	3,821.65	£ 16,627
2001	Apr-01	£ 6,50,967	£ 1,08,844	30%	£ 32,653	2,612.24
2001	May-01	£ 7,06,384	£ 1,59,208	30%	£ 47,762	3,820.99
2001	Jun-01	£ 7,55,445	£ 2,33,739	30%	£ 70,122	5,609.74	£ 12,043
2001	Jul-01	£ 7,03,159	£ 3,30,675	25%	£ 82,669	6,613.50
2001	Aug-01	£ 6,20,501	£ 3,47,421	25%	£ 86,855	6,948.41
2001	Sep-01	£ 5,54,541	£ 3,92,409	25%	£ 98,102	7,848.19	£ 21,410
2001	Oct-01	£ 4,52,446	£ 3,56,307	40%	£ 1,42,523	11,401.83
2001	Nov-01	£ 3,71,170	£ 3,07,694	40%	£ 1,23,078	9,846.20
2001	Dec-01	£ 3,34,718	£ 2,33,252	40%	£ 93,301	7,464.07	£ 28,712
2002	Jan-02	£ 3,57,444	£ 1,52,285	50%	£ 76,142	6,091.39
2002	Feb-02	£ 4,34,993	£ 1,24,103	50%	£ 62,052	4,964.13
2002	Mar-02	£ 5,22,225	£ 1,49,449	50%	£ 74,725	5,977.97	£ 17,034
2002	Apr-02	£ 6,35,459	£ 1,48,283	30%	£ 44,485	3,558.79
2002	May-02	£ 7,21,944	£ 1,86,184	30%	£ 55,855	4,468.42
2002	Jun-02	£ 7,64,136	£ 2,34,520	30%	£ 70,356	5,628.48	£ 13,656
2002	Jul-02	£ 7,27,818	£ 3,18,466	25%	£ 79,617	6,369.32
2002	Aug-02	£ 6,46,976	£ 3,34,721	25%	£ 83,680	6,694.43
2002	Sep-02	£ 5,46,411	£ 3,53,894	25%	£ 88,473	7,077.87	£ 20,142
2002	Oct-02	£ 4,34,262	£ 3,69,437	40%	£ 1,47,775	11,821.97
2002	Nov-02	£ 3,78,414	£ 2,80,724	40%	£ 1,12,289	8,983.16
2002	Dec-02	£ 3,54,169	£ 2,23,584	40%	£ 89,434	7,154.70	£ 27,960
2003	Jan-03	£ 3,89,224	£ 1,96,541	50%	£ 98,270	7,861.63
2003	Feb-03	£ 4,79,703	£ 1,57,239	50%	£ 78,620	6,289.58
2003	Mar-03	£ 5,43,848	£ 1,30,796	50%	£ 65,398	5,231.85	£ 19,383
2003	Apr-03	£ 6,67,792	£ 1,62,568	30%	£ 48,770	3,901.62
2003	May-03	£ 7,24,583	£ 2,04,618	30%	£ 61,385	4,910.82
2003	Jun-03	£ 7,49,334	£ 2,18,974	30%	£ 65,692	5,255.36	£ 14,068
2003	Jul-03	£ 7,21,558	£ 3,10,977	25%	£ 77,744	6,219.53
2003	Aug-03	£ 6,73,315	£ 3,49,912	25%	£ 87,478	6,998.25
2003	Sep-03	£ 5,46,640	£ 4,03,055	25%	£ 1,00,764	8,061.11	£ 21,279
2003	Oct-03	£ 4,51,759	£ 3,46,284	40%	£ 1,38,514	11,081.09
2003	Nov-03	£ 3,73,478	£ 3,31,439	40%	£ 1,32,576	10,606.05
2003	Dec-03	£ 3,53,049	£ 2,40,809	40%	£ 96,323	7,705.88	£ 29,393
2004	Jan-04	£ 3,68,165	£ 2,14,897	50%	£ 1,07,448	8,595.87
2004	Feb-04	£ 4,70,002	£ 1,11,597	50%	£ 55,799	4,463.90
2004	Mar-04	£ 5,66,494	£ 1,14,126	50%	£ 57,063	4,565.03	£ 17,625
2004	Apr-04	£ 6,82,433	£ 1,25,591	30%	£ 37,677	3,014.17
2004	May-04	£ 7,48,126	£ 2,02,967	30%	£ 60,890	4,871.21
2004	Jun-04	£ 7,76,188	£ 2,72,444	30%	£ 81,733	6,538.66	£ 14,424
2004	Jul-04	£ 7,56,433	£ 3,37,146	25%	£ 84,286	6,742.92
2004	Aug-04	£ 6,54,757	£ 3,95,260	25%	£ 98,815	7,905.21
2004	Sep-04	£ 5,76,538	£ 3,53,852	25%	£ 88,463	7,077.04	£ 21,725
2004	Oct-04	£ 4,55,581	£ 3,66,877	40%	£ 1,46,751	11,740.08
2004	Nov-04	£ 3,91,628	£ 3,19,445	40%	£ 1,27,778	10,222.24
2004	Dec-04	£ 3,71,070	£ 2,38,536	40%	£ 95,414	7,633.14	£ 29,595
2005	Jan-05	£ 3,88,952	£ 2,12,728	50%	£ 1,06,364	8,509.11
2005	Feb-05	£ 4,96,429	£ 1,57,913	50%	£ 78,956	6,316.50
2005	Mar-05	£ 5,96,610	£ 1,59,828	50%	£ 79,914	6,393.13	£ 21,219
2005	Apr-05	£ 6,89,463	£ 1,50,522	30%	£ 45,157	3,612.52
2005	May-05	£ 7,56,782	£ 2,06,948	30%	£ 62,084	4,966.74
2005	Jun-05	£ 7,87,665	£ 2,81,104	30%	£ 84,331	6,746.50	£ 15,326
2005	Jul-05	£ 7,61,154	£ 3,00,531	25%	£ 75,133	6,010.62
2005	Aug-05	£ 6,61,650	£ 3,87,069	25%	£ 96,767	7,741.38
2005	Sep-05	£ 5,80,530	£ 3,80,822	25%	£ 95,206	7,616.44	£ 21,368
2005	Oct-05	£ 4,90,041	£ 3,44,330	40%	£ 1,37,732	11,018.55
2005	Nov-05	£ 3,93,041	£ 3,55,658	40%	£ 1,42,263	11,381.07
2005	Dec-05	£ 3,74,507	£ 2,36,762	40%	£ 94,705	7,576.39	£ 29,976
2006	Jan-06	£ 4,14,412	£ 1,89,410	50%	£ 94,705	7,576.40
2006	Feb-06	£ 4,62,493	£ 1,79,046	50%	£ 89,523	7,161.82
2006	Mar-06	£ 5,86,895	£ 1,35,035	50%	£ 67,517	5,401.39	£ 20,140
2006	Apr-06	£ 7,08,987	£ 1,74,693	30%	£ 52,408	4,192.64
2006	May-06	£ 7,48,793	£ 1,73,687	30%	£ 52,106	4,168.48
2006	Jun-06	£ 7,76,754	£ 2,74,845	30%	£ 82,453	6,596.27	£ 14,957
2006	Jul-06	£ 7,46,006	£ 3,64,719	25%	£ 91,180	7,294.39
2006	Aug-06	£ 7,00,271	£ 3,81,602	25%	£ 95,401	7,632.05
2006	Sep-06	£ 5,92,744	£ 3,65,345	25%	£ 91,336	7,306.91	£ 22,233
2006	Oct-06	£ 4,95,922	£ 4,00,814	40%	£ 1,60,326	12,826.05
2006	Nov-06	£ 4,19,281	£ 3,39,103	40%	£ 1,35,641	10,851.29
2006	Dec-06	£ 4,00,245	£ 2,32,415	40%	£ 92,966	7,437.29	£ 31,115
2007	Jan-07	£ 4,13,332	£ 1,87,342	50%	£ 93,671	7,493.67
2007	Feb-07	£ 5,12,546	£ 1,55,212	50%	£ 77,606	6,208.46
2007	Mar-07	£ 6,02,873	£ 1,22,653	50%	£ 61,326	4,906.11	£ 18,608
2007	Apr-07	£ 7,05,970	£ 1,89,631	30%	£ 56,889	4,551.15
2007	May-07	£ 7,65,270	£ 2,31,431	30%	£ 69,429	5,554.35
2007	Jun-07	£ 7,99,129	£ 2,77,533	30%	£ 83,260	6,660.78	£ 16,766
2007	Jul-07	£ 7,55,094	£ 3,67,372	25%	£ 91,843	7,347.45
2007	Aug-07	£ 6,79,151	£ 4,15,329	25%	£ 1,03,832	8,306.58
2007	Sep-07	£ 6,16,253	£ 4,19,558	25%	£ 1,04,889	8,391.16	£ 24,045
2007	Oct-07	£ 4,72,628	£ 4,14,523	40%	£ 1,65,809	13,264.75
2007	Nov-07	£ 3,99,200	£ 3,01,126	40%	£ 1,20,450	9,636.04
2007	Dec-07	£ 3,91,921	£ 2,50,647	40%	£ 1,00,259	8,020.71	£ 30,921
2008	Jan-08	£ 4,27,679	£ 1,78,605	50%	£ 89,302	7,144.18
2008	Feb-08	£ 4,92,368	£ 1,36,639	50%	£ 68,320	5,465.57
2008	Mar-08	£ 6,14,959	£ 1,43,836	50%	£ 71,918	5,753.44	£ 18,363
2008	Apr-08	£ 6,93,240	£ 1,67,242	30%	£ 50,173	4,013.82
2008	May-08	£ 7,99,444	£ 2,17,811	30%	£ 65,343	5,227.46
2008	Jun-08	£ 7,98,267	£ 2,90,159	30%	£ 87,048	6,963.82	£ 16,205
2008	Jul-08	£ 7,95,411	£ 3,71,498	25%	£ 92,875	7,429.97
2008	Aug-08	£ 7,22,298	£ 3,81,659	25%	£ 95,415	7,633.19
2008	Sep-08	£ 6,27,368	£ 4,07,801	25%	£ 1,01,950	8,156.01	£ 23,219
2008	Oct-08	£ 5,21,100	£ 4,21,426	40%	£ 1,68,570	13,485.62
2008	Nov-08	£ 4,11,721	£ 3,42,156	40%	£ 1,36,862	10,948.99
2008	Dec-08	£ 3,83,842	£ 2,75,783	40%	£ 1,10,313	8,825.04	£ 33,260
2009	Jan-09	£ 4,53,359	£ 2,02,672	50%	£ 1,01,336	8,106.90
2009	Feb-09	£ 5,17,732	£ 1,72,103	50%	£ 86,051	6,884.12
2009	Mar-09	£ 5,99,005	£ 1,76,633	50%	£ 88,316	7,065.31	£ 22,056
2009	Apr-09	£ 7,31,081	£ 1,62,386	30%	£ 48,716	3,897.26
2009	May-09	£ 7,93,971	£ 2,47,816	30%	£ 74,345	5,947.59
2009	Jun-09	£ 8,05,458	£ 3,04,580	30%	£ 91,374	7,309.91	£ 17,155
2009	Jul-09	£ 7,73,524	£ 3,35,442	25%	£ 83,861	6,708.84
2009	Aug-09	£ 7,10,963	£ 4,24,563	25%	£ 1,06,141	8,491.25
2009	Sep-09	£ 6,35,133	£ 4,13,634	25%	£ 1,03,408	8,272.68	£ 23,473
2009	Oct-09	£ 5,12,081	£ 3,79,183	40%	£ 1,51,673	12,133.87
2009	Nov-09	£ 4,25,599	£ 3,29,763	40%	£ 1,31,905	10,552.42
2009	Dec-09	£ 4,29,413	£ 2,88,527	40%	£ 1,15,411	9,232.87	£ 31,919
2010	Jan-10	£ 4,66,543	£ 2,26,867	50%	£ 1,13,434	9,074.68
2010	Feb-10	£ 5,33,329	£ 2,00,340	50%	£ 1,00,170	8,013.61
2010	Mar-10	£ 6,43,751	£ 1,65,747	50%	£ 82,873	6,629.88	£ 23,718
2010	Apr-10	£ 7,39,483	£ 1,81,876	30%	£ 54,563	4,365.01
2010	May-10	£ 7,93,430	£ 1,91,366	30%	£ 57,410	4,592.78
2010	Jun-10	£ 8,36,175	£ 2,58,123	30%	£ 77,437	6,194.95	£ 15,153
2010	Jul-10	£ 7,86,523	£ 3,40,356	25%	£ 85,089	6,807.12
2010	Aug-10	£ 7,34,067	£ 3,83,218	25%	£ 95,805	7,664.36
2010	Sep-10	£ 6,36,764	£ 4,38,370	25%	£ 1,09,593	8,767.40	£ 23,239
2010	Oct-10	£ 5,05,462	£ 3,73,699	40%	£ 1,49,480	11,958.38
2010	Nov-10	£ 4,29,084	£ 3,18,881	40%	£ 1,27,552	10,204.18
2010	Dec-10	£ 4,22,953	£ 2,58,400	40%	£ 1,03,360	8,268.80	£ 30,431
2011	Jan-11	£ 4,83,868	£ 2,05,095	50%	£ 1,02,548	8,203.81
2011	Feb-11	£ 5,14,129	£ 1,84,379	50%	£ 92,190	7,375.18
2011	Mar-11	£ 6,34,846	£ 1,48,466	50%	£ 74,233	5,938.64	£ 21,518
2011	Apr-11	£ 7,38,248	£ 1,99,542	30%	£ 59,863	4,789.01
2011	May-11	£ 8,11,725	£ 2,58,566	30%	£ 77,570	6,205.59
2011	Jun-11	£ 8,34,698	£ 2,61,849	30%	£ 78,555	6,284.37	£ 17,279
2011	Jul-11	£ 8,28,170	£ 3,64,157	25%	£ 91,039	7,283.14
2011	Aug-11	£ 7,41,671	£ 3,82,399	25%	£ 95,600	7,647.98
2011	Sep-11	£ 6,36,436	£ 3,95,055	25%	£ 98,764	7,901.09	£ 22,832
2011	Oct-11	£ 5,53,502	£ 3,77,827	40%	£ 1,51,131	12,090.46
2011	Nov-11	£ 4,52,014	£ 3,28,066	40%	£ 1,31,226	10,498.12
2011	Dec-11	£ 4,52,216	£ 3,12,667	40%	£ 1,25,067	10,005.35	£ 32,594
2012	Jan-12	£ 4,87,394	£ 2,11,082	50%	£ 1,05,541	8,443.28
2012	Feb-12	£ 5,22,653	£ 2,02,939	50%	£ 1,01,469	8,117.54
2012	Mar-12	£ 6,59,668	£ 1,74,763	50%	£ 87,381	6,990.52	£ 23,551
2012	Apr-12	£ 7,44,208	£ 1,51,858	30%	£ 45,557	3,644.59
2012	May-12	£ 8,28,512	£ 2,14,952	30%	£ 64,486	5,158.85
2012	Jun-12	£ 8,49,146	£ 2,97,545	30%	£ 89,264	7,141.09	£ 15,945
2012	Jul-12	£ 8,29,490	£ 3,33,210	25%	£ 83,303	6,664.20
2012	Aug-12	£ 7,51,352	£ 4,23,666	25%	£ 1,05,917	8,473.32
2012	Sep-12	£ 6,23,291	£ 4,01,552	25%	£ 1,00,388	8,031.04	£ 23,169
2012	Oct-12	£ 5,55,211	£ 3,79,735	40%	£ 1,51,894	12,151.51
2012	Nov-12	£ 4,77,199	£ 3,61,852	40%	£ 1,44,741	11,579.27
2012	Dec-12	£ 4,51,020	£ 2,83,640	40%	£ 1,13,456	9,076.46	£ 32,807
2013	Jan-13	£ 5,03,591	£ 2,61,158	50%	£ 1,30,579	10,446.30
2013	Feb-13	£ 5,41,958	£ 1,78,947	50%	£ 89,474	7,157.90
2013	Mar-13	£ 6,44,774	£ 1,68,390	50%	£ 84,195	6,735.59	£ 24,340
2013	Apr-13	£ 7,41,074	£ 1,66,317	30%	£ 49,895	3,991.60
2013	May-13	£ 8,29,153	£ 2,53,373	30%	£ 76,012	6,080.95
2013	Jun-13	£ 8,31,079	£ 2,79,125	30%	£ 83,737	6,698.99	£ 16,772
2013	Jul-13	£ 8,43,282	£ 3,97,302	25%	£ 99,325	7,946.03
2013	Aug-13	£ 7,47,221	£ 4,07,504	25%	£ 1,01,876	8,150.08
2013	Sep-13	£ 6,70,408	£ 4,39,103	25%	£ 1,09,776	8,782.05	£ 24,878
2013	Oct-13	£ 5,33,377	£ 4,23,265	40%	£ 1,69,306	13,544.48
2013	Nov-13	£ 4,72,841	£ 3,61,822	40%	£ 1,44,729	11,578.29
2013	Dec-13	£ 4,35,820	£ 2,84,288	40%	£ 1,13,715	9,097.21	£ 34,220
2014	Jan-14	£ 4,75,700	£ 2,14,241	50%	£ 1,07,120	8,569.63
2014	Feb-14	£ 5,54,336	£ 2,04,660	50%	£ 1,02,330	8,186.41
2014	Mar-14	£ 6,70,708	£ 1,95,692	50%	£ 97,846	7,827.67	£ 24,584
2014	Apr-14	£ 7,61,764	£ 2,08,952	30%	£ 62,686	5,014.86
2014	May-14	£ 8,35,209	£ 2,53,961	30%	£ 76,188	6,095.07
2014	Jun-14	£ 8,64,701	£ 3,36,268	30%	£ 1,00,881	8,070.44	£ 19,180
2014	Jul-14	£ 8,38,229	£ 3,78,643	25%	£ 94,661	7,572.87
2014	Aug-14	£ 7,73,076	£ 4,19,389	25%	£ 1,04,847	8,387.79
2014	Sep-14	£ 6,62,804	£ 4,56,313	25%	£ 1,14,078	9,126.25	£ 25,087
2014	Oct-14	£ 5,41,434	£ 4,39,824	40%	£ 1,75,929	14,074.36
2014	Nov-14	£ 5,13,704	£ 3,68,689	40%	£ 1,47,476	11,798.05
2014	Dec-14	£ 4,54,391	£ 3,38,282	40%	£ 1,35,313	10,825.01	£ 36,697
2015	Jan-15	£ 5,05,783	£ 2,49,627	50%	£ 1,24,813	9,985.08
2015	Feb-15	£ 5,94,044	£ 1,78,664	50%	£ 89,332	7,146.57
2015	Mar-15	£ 6,89,387	£ 1,56,912	50%	£ 78,456	6,276.46	£ 23,408
2015	Apr-15	£ 7,92,840	£ 2,31,568	30%	£ 69,470	5,557.62
2015	May-15	£ 8,57,460	£ 2,41,777	30%	£ 72,533	5,802.66
2015	Jun-15	£ 8,50,573	£ 2,99,204	30%	£ 89,761	7,180.89	£ 18,541
2015	Jul-15	£ 8,52,187	£ 4,05,570	25%	£ 1,01,393	8,111.41
2015	Aug-15	£ 7,85,422	£ 4,06,918	25%	£ 1,01,729	8,138.36
2015	Sep-15	£ 6,97,142	£ 4,06,795	25%	£ 1,01,699	8,135.90	£ 24,386
2015	Oct-15	£ 5,99,251	£ 3,91,781	40%	£ 1,56,713	12,537.00
2015	Nov-15	£ 5,20,934	£ 3,94,270	40%	£ 1,57,708	12,616.65
2015	Dec-15	£ 4,50,174	£ 2,78,326	40%	£ 1,11,330	8,906.42	£ 34,060
2016	Jan-16	£ 5,16,842	£ 2,18,522	50%	£ 1,09,261	8,740.88
2016	Feb-16	£ 5,65,665	£ 2,08,426	50%	£ 1,04,213	8,337.04
2016	Mar-16	£ 6,99,158	£ 1,96,521	50%	£ 98,261	7,860.86	£ 24,939
2016	Apr-16	£ 8,08,765	£ 2,19,456	30%	£ 65,837	5,266.94
2016	May-16	£ 8,47,392	£ 2,39,685	30%	£ 71,906	5,752.44
2016	Jun-16	£ 8,79,403	£ 2,88,358	30%	£ 86,508	6,920.60	£ 17,940
2016	Jul-16	£ 8,42,308	£ 3,55,794	25%	£ 88,949	7,115.89
2016	Aug-16	£ 7,84,861	£ 4,48,950	25%	£ 1,12,237	8,978.99
2016	Sep-16	£ 7,00,383	£ 4,26,546	25%	£ 1,06,636	8,530.91	£ 24,626
2016	Oct-16	£ 5,94,204	£ 4,48,496	40%	£ 1,79,398	14,351.88
2016	Nov-16	£ 4,93,375	£ 3,96,732	40%	£ 1,58,693	12,695.41
2016	Dec-16	£ 4,73,624	£ 3,45,353	40%	£ 1,38,141	11,051.30	£ 38,099
2017	Jan-17	£ 5,41,584	£ 2,55,315	50%	£ 1,27,657	10,212.59
2017	Feb-17	£ 5,87,806	£ 2,13,980	50%	£ 1,06,990	8,559.21
2017	Mar-17	£ 7,06,489	£ 2,16,828	50%	£ 1,08,414	8,673.14	£ 27,445
2017	Apr-17	£ 7,98,722	£ 2,31,211	30%	£ 69,363	5,549.06
2017	May-17	£ 8,89,284	£ 2,74,710	30%	£ 82,413	6,593.04
2017	Jun-17	£ 8,71,860	£ 3,32,658	30%	£ 99,797	7,983.80	£ 20,126
2017	Jul-17	£ 8,76,995	£ 3,94,499	25%	£ 98,625	7,889.97
2017	Aug-17	£ 8,17,547	£ 4,56,476	25%	£ 1,14,119	9,129.53
2017	Sep-17	£ 6,81,290	£ 4,50,068	25%	£ 1,12,517	9,001.37	£ 26,021
2017	Oct-17	£ 5,79,437	£ 4,57,468	40%	£ 1,82,987	14,638.99
2017	Nov-17	£ 5,40,300	£ 3,59,933	40%	£ 1,43,973	11,517.84
2017	Dec-17	£ 5,19,108	£ 3,02,636	40%	£ 1,21,055	9,684.37	£ 35,841
2018	Jan-18	£ 5,45,416	£ 2,84,025	40%	£ 1,13,610	9,088.81

Highest Increase in Profit							£ 38,099

The policy of the HR is applicable to Assessment 3 Introduction

As per the requirement of the assessment, financial statements of Pets at home is to be analyzed so that the principles which are used in the preparation of the financial statements can be identified. Financial statements are the basis on which the performance of the company is measured. In other words, the statement provides a clear idea as to what activities does the business engages in and also determine the financial position of the business. The investors depend on such statements to take necessary decision regarding investments of the business.

Overview of the Company

Pets at home is a leading company which is engaged in providing any kind of accessories which pets need. The company is retail chain which provides all the services which are necessary for a pet to lead a happy and healthy life. The company is regarded as UK’s leading specialist in Pet retailer and pet care. The services and products which are provided by the business are food and accessories, specialist advices, grooming services and veterinary care.

Fundamental Principles of Financial Statement

The preparation of the financial statement is rather a complex process and therefore to make the process of preparing a financial statement somewhat simple, General Purpose Reporting framework is introduced and also certain principles are assumed while making the financial statement of the business (Edmonds et al. 2013). Accounting Principles the basis on which financial statements are prepared and they make the accounting process valuable and also comparable. The general principles which are followed for the preparation of the financial statement of the company are discussed below in details:

Accrual Concept: This is the most fundamental concept which is followed in accounting. The principle states that revenues should be recognized when they are earned and not when they are actually received and expenses should be recognized when they are incurred and not when actual payments is made. This principle facilitates that revenues and expenses are recorded to the period which they accrue to and not when the money relating to income and expenses are actually received or paid. As per the financial statement of Pets at home, the financial data are recorded following accrual concept. Accrual Principle is the fundamental requirement of preparing a financial statement.
Going Concern Principle: As per this principle, it is assumed that the company will be continuing its business operation for the foresee able future and has no intention of discontinuing or dissolving its business (Provasi and Riva 2015). The concept is a simple one but very important when it comes to preparation of the financial statements. If the company is expected to dissolve than its financial statements are to be prepared following break-up basis. The term foreseeable future means at least one year. As per the financial statements which are prepared by Pets at home, the notes to accounts makes it clear that the company follows going concern principle as the same is disclosed in the notes to accounts.
Time period Principle: The financial statements of the business are normally prepared for a particular time period. The principle states that the financial statements should be prepared for a particular time period which may be quarterly, half yearly or yearly. This principle facilitates that the performance of the business can be measured over a time frame. As per the financial statements of Pets at home, the business has prepared the financial statements following annual basis which is evident from the income statement and balance sheet.
Revenue Recognition principle: This principle is a continuation of the accrual principles which also states that revenues of the business should be recorded on the basis of the accrual concept. The financial statement of the Pet at Home is prepared following such a concept.
Historic Cost Principle: The principle states that the financial statements should be prepared on the basis of historical cost method. The historical cost method requires the items of the financial statements to be represented in historical cost. As per the financial statements of Pet at Home, the assets of the business are recorded at historical cost method.
Matching Principles: As per this principle, the expenses which are related to earning any particular revenue must be recorded. The principle states that every expense should be matched with the revenues earned by the business during a particular. Matching principle is regarded to be at the heart of accrual basis of accounting. If such a principle is not followed then the income which is recorded in the financial statement of the company might be understated or overstates. The financial statements of the business are made following the Matching principles as this is the fundamental principle of accounting.
Consistency Principles: As per this principle, the polices which are followed by the business must be consistently followed over the years of practice for the business such as policies relating to depreciation, measuring asset of the business. The financial statements of Pet at Home shows that the business consistently follows the policy of depreciation for the business which follows straight line basis of depreciation.

Components of the Financial Statements

The major statements which are included in the financial statements of Pet at Home are discussed below:

Income Statement: The income statement forms an important part of the financial statements as it displays the net profit which is earned by the business during the year. The income statement also reveals the various expenses which the business has undertaken for earning the revenues and whether the business is making profits or not (Bartov and Mohanram 2014). As per the statement of Income of Pet at home, the company has earned profit of £ 75,364 which is in the year 2017 and the same was £ 72,783 in the year 2016. The statement of income also shows various expenses and income which the business has undertaken during the year.
Balance Sheet: The balance sheet is a statement which shows the financial position of a company at a end of financial year. In this statement the asset and liabilities of the business are tallied to show that the asset and liability side matches each other. The Balance sheet of the company for the year 2017 shows that the total assets of the company comes to £ 1,320.286,000 and the liabilities is shown as £ 437,642,000. The equity capital of the business is shown to be £ 882,644. The combined figure of equity and liabilities matches the figure of total assets of the business.
Cash Flow Statement: The cash flow statement shows the cash liquidity position of the business. The statement reveals the cash inflows and outflows of the business. The cash flow statement of the company reveals that the cash and cash equivalent balance is shown at £ 56,345,000 as per 2017 results. The cash and cash equivalent have increased from the previous year’s estimate. The cash flow statement records transaction on cash basis which means the transaction are recorded for the amount which is actually received during the period. The cash flows statement is very useful to depict the liquidity of the business and also reveal the various operating, investing and financial activities which the business engages for the purpose of the business.

References

Bartov, E. and Mohanram, P.S., 2014. Does income statement placement matter to investors? The case of gains/losses from early debt extinguishment. The Accounting Review, 89(6), pp.2021-2055.

Edmonds, T.P., McNair, F.M., Olds, P.R. and Milam, E.E., 2013. Fundamental financial accounting concepts. New York, NY: McGraw-Hill Irwin.

Provasi, R. and Riva, P., 2015. Assessment of going concern for the Italian listed companies: An empirical study.

Buy Bus0002 The Demand And Sales Assessment Answers Online

Talk to our expert to get the help with Bus0002 The Demand And Sales Assessment Answers to complete your assessment on time and boost your grades now

The main aim/motive of the management assignment help services is to get connect with a greater number of students, and effectively help, and support them in getting completing their assignments the students also get find this a wonderful opportunity where they could effectively learn more about their topics, as the experts also have the best team members with them in which all the members effectively support each other to get complete their diploma assignments. They complete the assessments of the students in an appropriate manner and deliver them back to the students before the due date of the assignment so that the students could timely submit this, and can score higher marks.Â The experts of the assignment help services at urgenthomework.com are so much skilled, capable, talented, and experienced in their field of programming homework help writing assignments, so, for this, they can effectively write the best economics assignment help services.

Get Online Support for Bus0002 The Demand And Sales Assessment Answers Assignment Help Online

); } export default Bus0002ggg;

Not the Exact Question you were looking for ? Post your question for assignment help and get instant help on your homework and assignment questions from our experts