• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

Excel Project - St. Dominic's Sixth Form College

Extracts from this document...

Introduction

Excel Project AVCE ICT UNIT 3 ANALYSIS Background to the organisation & problem: My project is based on a small business called BABU MOTOR MAINTANANCE (BMM). I have interviewed the owner and gained a lot of information on it. BABU MOTOR MAINTANANCE (BMM) is in Harrow. It is a private company. Its location is at a home in the central most part of Harrow (near the main shopping facilities). It has great potential considering it is based in a busy area. The business is not very big at the moment, but is due for expansion later on in the month. The business currently has about 60-70 customers. The founder of BABU MOTOR MAINTANANCE (BMM) was a man named Babu Vadgama. The current owner is Chagan Vadgama. I have chosen this Company because my dad has used them for his repairs, since they have started up. Since then we have got to know them. Even though Mr. Vadgama is the current owner and the investor of the company he is silent in the day to day running of the business. At the moment there are four members of staff in the business. Most of the work is done by the owner but others do help him for bigger or more complex jobs. These include the owner. His name is Chagan Vadgama. The assistant. His name is Tej Vadgama. There are also two part time specialists in different fields e.g. electrician. When the company first started up six years ago, there were only one or two customers to start up with but that number has gradually risen to 70 customers. It is still rising every week. The small business has started seeing profits coming through over the last ten months, mainly due to extra competition in the mechanic field. The 70 customers vary from age and gender. The majority of customers are adults between the ages of 20 to 30. ...read more.

Middle

When the assistant try's to work out what the price of each repair should be, it takes him a very long time and is still not accurate. The Company does know how many bookings they need to make in order to break even and whether it will make a loss or profit. When organising a booking it takes the Company a very long time to work out all this data because it's all done by hand. * When the results from part orders are calculated, all the results are stored into a record book. This has proved to be fine until recently when the owner decided that the Company should have discounts for the top ten customers. The books have all the data in them but it is very hard to analyse the results. The assistant has been working out the ten top customers every week, for the past few weeks and he said it takes up a lot of time and is very difficult to calculate the top ten customers for the week. He thinks that it will be even harder to work out the top ten customers of the month and the year. The way that it is currently done is by manually adding up all the incomes of all the customers and then picking and then picking out the top ten. This is done at the same time as the expenditures are entered are into the book and it takes a very long time. Statement of the Problem: Sub-Problems: Since interviewing the assistant of the Company, I have begun to break down the problems that the Company is having at the moment. These are the problems that the Company is having: No. Problem 1. Having to manually search through customer's files to find out different things. 2. Having to manually find out who has/hasn't paid for their repairs over each week. ...read more.

Conclusion

This can result in huge problems for the Company. They would have higher costs if they recruited a new accountant. They would have to build a new room or office for the accountant. All these solutions are reasonable but the best solution for the system would be to use the Microsoft Excel software package. Justification of the chosen solution: After discussion with the assistant of the Company, it has been decided that the best solution for the Company to take is by using the Microsoft Excel software package. The assistant felt that Excel would be most suitable because he knows it quite well; he knows that the features on it are very good. The features that he thinks that Excel has which will be very helpful to the day-to-day running of the Company are: * "What if" scenarios * Writing formulae * Editing and formatting * Using Functions * Macros * Filtering lists * Creating charts Although some of the other packages also have these functions the assistant feels most comfortable with the Excel software, mainly because he has had many lessons on Excel and because he does not know how the other systems work. He thinks that it would be a waste of time learning a different software package when the Company already has Excel installed and because many people know about Excel. The assistant said that it isn't a wise idea to recruit a new member of staff because it could become quite costly and inefficient and the Company would not be able to afford it. User's Skill Level: There will be two users of this system. They are the owner, Chagan Vadgama and the assistant, Tej Vadgama. The owner of the Company is computer-literate and he has good basic knowledge of Microsoft Excel. The day-to-day running will be organised by the assistant and he has good skills. He isn't perfectly sure on the advanced features of Excel but he knows how to create formulas. ?? ?? ?? ?? Sham Bakrania 27/04/2007 ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our AS and A Level ICT in Business section.

Found what you're looking for?

  • Start learning 29% faster today
  • 150,000+ documents available
  • Just £6.99 a month

Not the one? Search for your essay title...
  • Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month

See related essaysSee related essays

Related AS and A Level ICT in Business essays

  1. Analysis of The Cadbury company.

    The next step is to separate the powder from the butter. This is done in huge heated hydraulic presses. By controlling the temperature, hydraulic pressure and duration of the process, the desired amount of fat is squeezed out. The remaining cocoa (still containing some fat)

  2. Business Aims and Objectives.

    Price changes can be implemented quickly and easily. * Electronic point of scale (EPOS) systems usually linked to a bar code reader. These systems enable information - On the quantity of stock sold to be recorded electronically. - Stock sold to be matched against existing stock levels, for later analysis by mangers.

  1. business plan and organise event

    This needs to be one of my main aims of the day because if the tournament starts late then all the games may not be completed and it could cause problems in the later stages of the tournament. 3:30pm Tournament continues/ 1st game of the day begins Chetan, Mahesh 1st

  2. Buisness at work

    Asda cares for its environment because it gives money to the 'Tickled Pink' breast cancer care. Asda has already raised over �1 million. In November 2002, Asda raised �1.2 million for BBC children in need. It is still continuing to support BBC children in need.

  1. BUSSINESS AT WORK - Coca Cola

    In a limited company, the business is owned by shareholders, run by directors and is set up as a body separate from the owners, being the shareholders. A limited company business is quite different from a sole proprietorship or

  2. IT Advertising Project- Bertrams Books

    Flyers - Again another form of advertisement that is distributed in the street, or maybe posted. Again exactly the same as the magazine or business card in these terms. Though it is in between both of them in terms of expense and size.

  1. Report on six original documents

    This information is straight forward and easy to understand. In the inside of the application form, some of the words used in this application form are very persuasive. The words such as "exclusive", "keeping the saver card" points to the fact that it is easy and fast way to receive discount with the Saver card.

  2. How standard documents are presented. I have chosen six standard documents to analyze. Three ...

    Head &Footers There are no header and footer which are visible, which seem like they are headers and footers, as there is edge to edge printing and information. No spaces or gaps left as there is no need to. This is because all the information is laid out neatly and understandingly.

  • Over 160,000 pieces
    of student written work
  • Annotated by
    experienced teachers
  • Ideas and feedback to
    improve your own work