"Bull and Bear Books" is a medium sized company who sell special books and videos about business management for the education market.

Authors Avatar

Introduction

“Bull and Bear Books” is a medium sized company who sell special books and videos about business management for the education market.

The company was established in 1985 and is run as a partnership.  A partnership is a business involving 2-20 people.  All the people involved share the costs, skills and ideas.  But each person is responsible for each others debts. From time to time, there may be disagreements between partners.

“Bull and Bear Books” got most of their business by sending out catalogues to schools, colleges and universities.  These catalogues cost the business a lot of money and they get less than a 10% response.  They sometimes buy lists from companies that specialise in the sale of lists but they have found that 25% of them are often inaccurate.

The staff at “Bull and Bear Books” are I.T literate and they use a generic commercial packaging for word processing and issuing invoices.

The partners want to find a way to develop the existing I.T systems to improve the company’s profits and increase their market share.  They also want to use I.T in an integrated way to keep records of their stock and monitor scales.

I am to produce a report for them about the way in which they could use I.T in the future.

Synopsis

This report will show how “Bull and Bear Books” could use IT to increase they amount of profit they get and their market share.  

Using IT can make the business more efficient but it can also cause many problems.  IT could make the whole business more efficient by cutting costs on wages and keeping better records so that they can keep control of the business.

If “Bull and Bear Books” do decide to introduce IT, there is a possibility that many problems could be caused and this report will look at some of these in detail.

This report will be mainly about how databases and spreadsheets can be used to keep information.  A database is a collection of information needed for a particular task.  It is stored in a way that data from records can be found easily.  A spreadsheet is a software package that allows the operator to make financial calculations with a large number of figures; it is also very fast.

The company may decide to introduce other technologies along with IT which they might want to use, but this may be inappropriate, for example, “Bull and Bear Books” may want to introduce E-mail but if they are only selling books, then this may not be needed.

If “Bull and Bear Books” do decide to bring IT into the company, they could use databases to make records of each of the customer’s details.

Spreadsheets

A spreadsheet is a computer program, which is designed to display and process numbers.  It is made up of a grid which numbers are entered.  The program contains a lot of mathematical and financial calculations that can be applied to the numbers.  Many spreadsheets can also show the numbers in the form of graphs.

The power of a spreadsheet comes from its ability to do calculations with numbers.  The contents of one cell can be calculated from other cells in the sheet by using a formula.

A business may want to use a spreadsheet to make:

  • Balance sheets
  • Trading accounts
  • Profit and loss accounts

A spreadsheet could also calculate a loan repayment to work out how much the interest is, and/or work out percentage increases and averages.

The main advantages of using a spreadsheet are:

  • Calculates sums automatically using a formula.
  • Quicker
  • Can search for data very quickly
  • Easy to keep and change targets.
  • Can change figures easily.

‘Bull and Bear Books’ could use spreadsheets for experimenting with different mathematical models and asking ‘What if?’  

For example, the manager could find out how much money he should invest in the company based on the amount of profit/loss the company is currently making.  He could also investigate how much more profit the business would make if he increased the prices of the books.


Profit and Loss Accounts

A profit and loss account is a summary of the expenses, losses and overheads of a firm, which is used to calculate the net profit over a period of time.  The net profit that the business has made during the previous year is shown after all the expenses are taken away from the gross profit.

A profit and loss account is a continuation of the trading account.  The trading account shows how much money has been spent on stock and how much money was made when the product/service was sold and the gross profit.  

Example 1 is an example of a trading account.  As you can see, all of the expenses are calculated on the left-hand side and on the right, the sales are also calculated.   All of the figures are calculated by using a formula, which is shown in example 2.  By using a few starting figures and formulas, you can experiment by putting higher/lower figures.

‘Bull and Bear Books’ could use spreadsheets to produce trading accounts at first and if they want more accurate figures, they could produce profit and loss accounts.


Balance Sheet

A balance sheet is a statement of how the financial part of the business is doing at the moment.  It shows all that a business owes (liabilities) and all that it owns (assets).

Join now!

Liabilities – There are two main types of liabilities: current and long-term.  Long-term liabilities are debts (mortgages or loans) that do not have to be paid within a year.  And current liabilities are debts, which demand short-term payments e.g. tax or money owed to creditors and overdrafts.  Long-term liabilities are often listed before the current liabilities on a balance sheet.

Assets –         This shows all that the business owns from equipment to the amount of cash in the bank.  Again there are two different types of assets: Fixed assets and Current assets.  Fixed assets are permanent possessions, which ...

This is a preview of the whole essay