Accounting: Retail Business Description, Spreadsheet Development

ACCOUNTING

TABLE OF CONTENTS
TASK 1............................................................................................................................................1
(a) Brief description of retail business........................................................................................1
(b) Development of spreadsheet..................................................................................................1
TASK 2........................................................................................................................................................11
Table 1Average expenses................................................................................................................4
Table 2Sales classification in retail business...................................................................................5
Table 3Cash flows...........................................................................................................................6
Table 4Expenses as percentage of expenditure...............................................................................7
Table 5Expenditure breakdown and percentage share in expenses...............................................10
Figure 1Auto sum formula application............................................................................................1
Figure 2Auto format........................................................................................................................2
Figure 3Auto format dialog box......................................................................................................3
Figure 4Average formula.................................................................................................................4
Figure 5Percentage using absolute reference..................................................................................5
Figure 6Expenditure trend...............................................................................................................8
Figure 7Current source of income...................................................................................................9
Figure 8Percentage share of capital, stock and operation money..................................................10

TASK 1
(a) Brief description of retail business
Big deal is the one of the retail stores in the West London in the UK. Store offer wide variety of products that can be classified
in to grocery and non-grocery items. There are number of competitors in the market and due to this reason, it is very important to do
something special and different in the business. For financing business operations £10000 is collected from the family and friends.
Apart from this, amount valued at £2500 is needed extra to finance business operations. £50000 is also needed to purchase goods.
Thus, it can be said that requirement amount is high and due to this reason, it become important to resort to the banks to get finance
for business operations. Main focus of the retail store is on marketing of its product and in this regard heavy expenditure is made on
the marketing of the product lines. Marketing alone cover 20% to 25% of overall sales revenue. Thus, it can be said that heavy
investment is made in the business and efforts are also made to capitalize opportunity.
(b) Development of spreadsheet
(a)Auto sum formula
Figure 1Auto sum formula application
1

(b) Auto format
Figure 2Auto format
On upper left side icon is given by clicking on which below given dialog box open.
2