Integrating Spreadsheet Modeling PDF

Assessment 2

Table of Contents
INTRODUCTION...........................................................................................................................1
TASK 1............................................................................................................................................1
a. Description of business............................................................................................................1
b. Spreadsheet..............................................................................................................................1
TASK 2............................................................................................................................................4
Interpretation of the spreadsheet..................................................................................................4
CONCLUSION................................................................................................................................6
REFERENCES................................................................................................................................7

INTRODUCTION
A spreadsheet is a type of sheet of paper in computers which shows the accounting and
other calculation on some kind of data in form of rows and columns. A spreadsheet can also be
defines as a computer application software and program which simulates a physical spreadsheet
by capturing, displaying, and manipulating data and figures which are arranged in the format of
rows and columns. The report will outline a brief description of the business Blue Inc which was
founded in the year 1912 by Abraham Levy and is headquartered in London. Also in the end it
will outline some formulas and there application.
TASK 1
a. Description of business
The business chosen for the study is Blue Inc. It is a retail brand dealing in the sector of
accessories, clothing and footwear. It is a network of retail stores operating and based across
united Kingdom. This company was founded in the year 1912 by Abraham Levy and is
headquartered in London (McKenzie, Amelunxen and Purple Robot Software Inc, 2018). This
retail brand offers a variety of products like fashionable clothes of women, men, girls and boys,
ranging from formal products to a range of casual wear at competitive;y low prices. This
company sells its own manufactured products under the name of Blue Inc, Twisted Soul and
Officers Club but with this they also sell other brands like Polo Ralph Lauren, Adidas, Mossimo
etc.
b. Spreadsheet
JAN FEB
MA
R APR
MA
Y JUN
JUL
Y
AU
G SEP OCT
NO
V
DE
C
TOT
AL
AV
ER
AG
E %
Revenue 4000 4200 4410 4631 4862 5105 5360 5628 5910 6205
651
6
684
1 63669 5306
Less:
CoGS 1400 1428 1457 1486 1515 1546 1577 1608 1640 1673
170
7
174
1 18777 1565
1

GROSS
PROFIT 2600 2772 2953 3145 3347 3559 3784 4020 4269 4532
480
9
510
1 44892 3741
122.
63
%
Expenses
Salaries 1000 1000 1000 1000 1000 1000 1000 1000 1000 1000 0 0 10000 833
56.0
1%
Rent&rat
es 145 148 151 154 157 160 163 167 170 173 177 180 1945 162
10.8
9%
Marketin
g 113 115 117 119 121 123 125 127 129 131 133 135 1488 124
8.33
%
Insurance 150 153 156 159 162 165 168 171 174 177 180 183 1998 167
11.1
9%
Utilities 180 184 188 192 196 200 204 208 212 216 220 224 2424 202
13.5
8%
Total
expenses
1588 1600 1612 1624 1636 1648 1660 1673 1685 1697 710 722 17855 1488
Profit
before
tax (5%) 1012 1172 1342 1521 1711 1911 2123 2348 2585 2835
409
9
437
8 27037 2253
105.
26
%
2

Taxes 51 59 67 76 86 96 106 117 129 142 205 219 1352 113
PROFI
T
AFTER
TAX 961 1113 1275 1445 1625 1816 2017 2230 2455 2693
389
4
415
9 25685 2140
100.
00
%
Profit %
24.0
4%
26.5
1%
28.9
0%
31.2
0%
33.4
3%
35.5
7%
37.6
3%
39.6
3%
41.55
%
43.4
0%
59.
77
%
60.8
0%
3

4

TASK 2
Interpretation of the spreadsheet
The spreadsheet is a very interactive computer application used to organize, store and
analyze the data in the tabular form. This program operates as the data entered in the cells of the
table (Handayani, Kusumahati and Badriah, 2017). Each and every cell either contains the
numeric data or the text data then some formulas are applied on the data and the results thereof is
automatically calculated and displays a value which is based on the contents of other cells. A
spreadsheet can also be known as an electronic document.
A spreadsheet consists of a table made up of different cells which are arranged into the
format of rows and columns and are referred to as X and Y locations (Borthick, Schneider and
Viscelli, 2016). X locations are known as columns and are normally represented by letters such
as A, B, C and continuously. On the other hand the rows are generally represented as numbers
like 1, 2, 3, 4 and so on.
A formula refers to an expression which helps the person in calculating the values of a
cell (Campbell, Knight and Comertoglu, Microsoft Technology Licensing LLC, 2017). These
formulas are some pre- defined formulas and functions which are already installed or available in
excel. For doing the above calculations we have used many formulas like auto - sum, auto -
format, percentage, average formula etc. The functions and the formulas both play a crucial and
important role in making the application and calculation easy and leads to more perfection and
accuracy in the calculations (García - Hernández, Gella - Marín, Huertas - Talón and Berges -
Muro, 2016). It also helps in determining the relationship among the different values coming in
the cells of the spreadsheet and for performing some mathematical calculations with application
with help of application of those values in order to bring outcome for the values in the cell. The
formulas always starts with the equals to (=) sign. For example, if the formula =SUM(5 + 4 – 6)
is entered into cell A1 and the value 3 appears in that location. When cell A1 is selected, the
formula displays in the formula bar above the worksheet will be of sum. Like in the above table
we totaled all the expenses by doing the sum or by adding all the expenses (Wilson, Domke and
Ek, 2014).
Also, the percentage can be calculated in excel in not much time and also without any
complication (Khoshnevisan, Wang and Juang, 2016). The basic formula of the percentage is
(particular/ whole) * 100 = percentage
5

For example suppose, you have the number of "Ordered items" in column B and "Delivered
items" in column C. To find out the percentage of delivered products, perform the following
steps:
Enter the formula =C2/B2 in cell D2, and copy it down to as many rows as you need.
Click the Percent Style button (Home tab > Number group) to display the resulting decimal
fractions as percentages.
Remember to increase the number of decimal places if needed (Uziak, Gandure and Martin,
2014).
CONCLUSION
By the end it can be concluded that the use of the spreadsheet in doing calculations is
very necessary and crucial. The report highlighted the different types of excel formulas and there
applications in the business in solving the problem fast.
6

REFERENCES
Books and journals
Borthick, A.F., Schneider, G.P. and Viscelli, T.R., 2016. Analyzing data for decision making:
Integrating spreadsheet modeling and database querying. Issues in Accounting
Education. 32(1). pp.59-66.
Campbell, J., Knight, M. and Comertoglu, C., Microsoft Technology Licensing LLC,
2017. Representation of people in a spreadsheet. U.S. Patent 9,753,910.
García-Hernández, C., Gella-Marín, R., Huertas-Talón, J.L. and Berges-Muro, L., 2016.
Algorithm for measuring gears implemented with general-purpose spreadsheet
software.Measurement. 85. pp.1-12.
Handayani, I., Kusumahati, H. and Badriah, A.N., 2017. Pemanfaatan Google Spreadsheet
Sebagai Media Pembuatan Dashboard pada Official Site iFacility di Perguruan
Tinggi. Sisfotenika. 7(2). pp.177-186.
Hubalovsky, S. and Musilek, M., 2014. Algorithm for Automatic Deciphering of Mono-
Alphabetical Substituted Cipher Realized in MS Excel Spreadsheet. In Applied
Mechanics and Materials (Vol. 513, pp. 624-627). Trans Tech Publications.
Khoshnevisan, S., Wang, L. and Juang, C.H., 2016. Simplified procedure for reliability-based
robust geotechnical design of drilled shafts in clay using spreadsheet. Georisk:
Assessment and Management of Risk for Engineered Systems and Geohazards. 10(2).
pp.121-134.
LeBlanc, L.J., Bartolacci, M.R. and Grossman, T.A., 2016. ASP, the art and science of practice:
increasing productivity and minimizing errors in operations research spreadsheet
models. Interfaces. 47(3). pp.260-269.
McKenzie, S.C., Amelunxen, P.A. and Purple Robot Software Inc, 2018. Peer to peer
spreadsheet processing. U.S. Patent Application 10/013,412.
Uziak, J., Gandure, J. and Martin, D.L., 2014. Spreadsheet application in beam bending
calculations. World Trans. on Engng. and Technol. Educ. 12(3). pp.402-407.
Wilson, D.C., Domke, G.M. and Ek, A.R., 2014. Forest Age Class Change Simulator (FACCS):
A spreadsheet-based model for estimation of forest change and biomass availability.
7