Data Handling and Using ICT: Retail Business Expansion Funding Report

Desklib provides past papers and solved assignments for students. This report analyzes a retail business's financial data for a loan application.

DATA HANDLING AND USING ICT - ASSIGNMENT 2
1

Table of Contents
Introduction......................................................................................................................................3
Task 1...............................................................................................................................................4
Task 2...............................................................................................................................................8
Conclusion.......................................................................................................................................9
References......................................................................................................................................10
2

Introduction
In this report it describes the retail business which is based in west London decide to enlarge its
business. Retail business wants to enhance its business qualities and decide to achieve its goals
and objectives. The company needs to gain extra funding. In this report, it shows that the
company collects the funds with its family and friends. In this situation, it is needed to gain extra
funds for its capital as well as for goods. It is describing in the upcoming tasks it shows the
spreadsheet which describes business sales and expenses of the last 12 months. It is also
described and explained by the use of charts and various formulas. In this report, it explains the
ideas for business to get the appointment for a loan. It also describes that retail business actual
image and structure which provides the information of funding’s, investments, sales, and
expenses.
3

Task 1
A. Using a maximum of 100 words, give a brief description of your business.
Create a spreadsheet which details your business sales and expenses over the last 10
months (possibly 12) to support your loan request and show that the business is successful
and is profitable.
Within the spreadsheet you should use the following:
a) Auto-sum
b) Auto-format
c) Average formula
d) Percentage
e) Password protect your spreadsheet (optional)
Particulars Jan Feb
Ma
r
Apr
il
Ma
y
Jun
e
Jul
y
Au
g
Se
p Oct
Tot
al
Percen
tage
Aver
age
Sales
70
00
75
00
65
00
66
00
77
00
72
00
58
00
63
00
71
00
72
50
689
50 100% 6895
Less: Purchases
of Goods
-
50
00
-
45
00
-
40
00
-
58
00
-
50
00
-
65
00
-
40
00
-
50
00
-
60
00
-
40
00
-
498
00 -72%
-
4980
Gross Profit
20
00
30
00
25
00
80
0
27
00
70
0
18
00
13
00
11
00
32
50
191
50 28% 1915
Less: Expenses
Wages &
salaries
-
20
0
-
30
0
-
25
0
-
10
0
-
40
0
-
10
0
-
30
0
-
35
0
-
20
0
-
50
0
-
270
0 -4% -270
Electricity
-
10
0
-
40
0
-
30
0
-
20
0
-
30
0 -50
-
25
0
-
30
0
-
20
0
-
35
0
-
245
0 -4% -245
Stationary -50
-
10
0
-
15
0
-
20
0
-
10
0
-
10
0
-
20
0
-
10
0
-
10
0
-
20
0
-
130
0 -2% -130
Commission
-
50
0
-
60
0
-
70
0
-
10
0
-
80
0
-
20
0
-
50
0
-
40
0
-
20
0
-
60
0
-
460
0 -7% -460
Profit
11
50
16
00
11
00
20
0
11
00
25
0
55
0
15
0
40
0
16
00
810
0 12% 810
4

In this spreadsheet, it explains the business sales and expenses of the last 10 months. It helps to
the business loan request and also shows that business gain profits and success. In this
spreadsheet, it used various types of formulas which include auto-sum, average formula, and
percentage. It also describes that business sales average which is £6895. In the auto-sum, it
calculates the sum of overall sales of 10 months. In the average formula, it calculates the average
of sales and expenses which shows the average sum of this business data’s (McKeever, 2016).
5

f) Create a chart which gives a clear presentation of your expenses
1 2 3 4 5 6 7 8 9 10
-900
-800
-700
-600
-500
-400
-300
-200
-100
0
-200
-300
-250
-100
-400
-100
-300
-350
-200
-500
-50
-100
-150
-200
-100 -100
-200
-100 -100
-200
-500
-600
-700
-100
-800
-200
-500
-400
-200
-600
Wages & salaries
Electricity
Stationary
Commission
In this chart, it shows the clear and understandable business expenses of retail. In this chart, it
shows wages and salaries, electricity, stationery, and commission expenses which affect the
business. All the expenses data helps to understand the actual analysis of the business (Fasoula,
2017).
6

g) Create a chart that provides a clear view on your current sources of income.
1 2 3 4 5 6 7 8 9 10
0
1000
2000
3000
4000
5000
6000
7000
8000
9000
7000
7500
6500 6600
7700
7200
5800
6300
7100 7250
Series1
In this chart, it provides a clear outline of current sources of income. It shows the present
resources of funding which helps to understand the business-data. It provides information about
various factors (Cambini, 2016).
7

h) Finally a chart that provides a clear picture of the distribution of your investment
between capital, stock and operation money.
Capital Stock Operation money
0
10000
20000
30000
40000
50000
60000
70000
80000
Amount
Amount
In this chart, it provides information about the distribution of business investment. This chart
shows the investment within the capital, stock and operation money.
8

Task 2
Write a commentary explaining your approach to the design of your spreadsheet i.e. why
you felt it appropriate to use the formulas/functions you have used in each case, why you
chose a particular type of chart, etc. (150 – 200 words)
In this report of business analysis; it is explained by the various formulas and functions. It helps
to gain information about expenses, sales and also show the profits. It is applied the auto-sum,
average and percentage formula to analysis the data’s and shows the actual picture of businesses.
Formulas help to calculate the actual funding’s, investments, capitals, and income resources. In
this case, it used the auto sum formula which helps to calculate the overall sales. The average
formula helps to calculate the average of overall sales, expenses, and profits. It also explained the
10 months business details include sales and expenses. Charts show a clear and understandable
presentation of the company expenses and current sources of income. Charts provide information
of the distribution of contribution between capital, stock and operation money. It shows the easy
presentation which helps to understand and see the data analysis in picture form (Wang,2017).
9

Conclusion
It is investigated that this report describes the spreadsheet of retail business which is based in
west London. In this report, it explained the description of the business. It also explained the
spreadsheet which provides the information business sales and expenses of the last 10 months.
This spreadsheet provides the information of business profits. It used various formulas into its
spreadsheet and also presents the business analysis by a clear presentation of charts. The purpose
of making this spreadsheet is to achieve the objectives and enhance the business. It helps to
provide the ideas to the business to the appointment the loan.
10

References
 McKeever, M., 2016. How to write a business plan. Nolo.
 Fasoula, S., Nikitas, P. and Pappa-Louisi, A., 2017. Teaching simulation and computer-
aided separation optimization in liquid chromatography by means of illustrative
Microsoft Excel spreadsheets.
 Cambini, C., Fumagalli, E. and Rondi, L., 2016. Incentives to quality and investment:
evidence from electricity distribution in Italy. Journal of Regulatory Economics, 49(1),
pp.1-32.
 Wang, R., Gupta, A. and Grewal, R., 2017. Mobility of top marketing and sales
executives in business-to-business markets: A social network perspective. Journal of
Marketing Research, 54(4), pp.650-670.
11