• Join over 1.2 million students every month
  • Accelerate your learning by 29%
  • Unlimited access from just £6.99 per month
Page
  1. 1
    1
  2. 2
    2
  3. 3
    3
  4. 4
    4
  5. 5
    5
  6. 6
    6
  7. 7
    7
  8. 8
    8
  9. 9
    9
  10. 10
    10
  11. 11
    11
  12. 12
    12
  13. 13
    13
  14. 14
    14
  15. 15
    15
  16. 16
    16
  17. 17
    17
  18. 18
    18
  19. 19
    19
  20. 20
    20
  21. 21
    21
  22. 22
    22
  23. 23
    23
  24. 24
    24
  25. 25
    25
  26. 26
    26
  27. 27
    27
  28. 28
    28
  29. 29
    29
  • Level: GCSE
  • Subject: ICT
  • Word count: 2520

Billing System

Extracts from this document...

Introduction

USER SPECIFICATION INTRODUCTION Mr. Atchuthan Narayanan, Mr. Thamotharan Atchuthan and Mr. Ramesh Atchuthan are the partners in a firm called "VEEYEN MILLS". This mill is situated in Grandpass. This mill was opened on the 6th of February in the year 1984. This mill is dealing in oils such as Coconut oil, Sesame oil and Pulses, which was manufactured in the mill itself. This mill also mills flour such as Kurakan flour, Orid flour and Rice flour. This mill has various machines, it takes 85-horse power to run these machines. EXISTING SYSTEM The existing system, the accountant writes down the sales of goods roughly on A4 papers. At the end of the day the accountant writes down the sales of goods on three accounts books and he calculates the profit and the loss of the day, he does this every day. This is a very long process because he had to write the sales of goods in three accounting books, therefore it consumes a long time to finish the calculating and balancing. DISADVANTAGES OF EXISTING SYSTEM Presently the way of calculating the profit is done manually. This done by using calculators. This leads to some disadvantages. They are as follows: Human Errors:- This is a common disadvantage, where they misplace the A4 papers which contain the record of sales of goods and also sometimes the accounts books. ...read more.

Middle

It needs a Main Memory of 16MB Ram and a monitor. These are the 1minimum requirements needed for to run Microsoft Excel. Minimum requirements needed by Microsoft Excel MB Hard Disk space 1.21GB MB Ram 16 MB Clock Speed 65 KHz Intel 486 MMX Monitor 16 Colors DATA CAPTURE I captured the relevant data in 3 main ways. They are as follows. 1) Going through the past Accounting books and Backup files. 2) Questioning the Accountant. Going through the past Accounting books and Backup files The accounting books contain details on the goods sold. These details are like the invoice number, quantity of the product sold and the grand total. The backup file contains an overall description of the goods sold for a day. The overall description contains informations like the invoice numbers of a day and grand totals of each invoice. When I went through the accounting books. I found out that there were a lot of details missing. I suppose that they must be omitted because the quantity bought should have be less than two. Hence this gave a false record in the backup file. An invoice of the firm VEEYEN MILLS. Questioning the Accountant I asked the accountant some questions on the Invoicing System. A few important questions are: 1) How is your firm's invoicing system? ...read more.

Conclusion

.LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With With Selection.Borders(xlEdgeTop) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With With Selection.Borders(xlEdgeBottom) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With With Selection.Borders(xlEdgeRight) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With With Selection.Borders(xlInsideVertical) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With With Selection.Borders(xlInsideHorizontal) .LineStyle = xlContinuous .Weight = xlThin .ColorIndex = xlAutomatic End With ActiveCell.Select End Sub The Marco To Go To Invoice Sub viewInvoice() Sheets("Invoice").Select End Sub The Marco To Go To Codes Section Sub viewcodes() Sheets("codes").Select End Sub The Marco To Go To Backup Section Sub viewbackup() Sheets("Backup").Select End Sub The Marco To Return To Main Menu From The Invoice Sub intomm() Sheets("Main Menu").Select End Sub The Marco To Return To Main Menu From The Codes Section Sub cotomm() Sheets("Main Menu").Select End Sub The Marco To Main Menu Form The Backup Section Sub butomm() Sheets("Main Menu").Select End Sub EVALUATION OF MAN/MACHINE INTERFACE This system is 100% efficiency, easy and helps any user who has a little knowledge on computer or to the ones who don't have any thing at all. I say it because I have created a main menu which guides the user to go to the invoice, to the codes section and to the backup section. This is done by macros. Hence this saves time when doing the billing system on a computer using excel other than writing on bill books and accounts books ?? ?? ?? ?? ...read more.

The above preview is unformatted text

This student written piece of work is one of many that can be found in our GCSE ICT Systems and Application 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 GCSE ICT Systems and Application essays

  1. Benefits of using my IT system in the Travel Agents.

    Finally I am going to click on print. The logo was printed successfully but the only error was that it printed out in the wrong colour. It would have been easier if there were screenshots or images Additionally I think the user guide needs to show how to use colour when printing.

  2. Producing documents for a company. Spreadsheet, Invoice and Website.

    * Can't relate data * Software needs to be purchased Objectives Paper and calculator Web-page Database Spreadsheet have colour and text be user-friendly Products and services for sale must be found easily and It must contain all vital information It Must use Vlook(s)

  1. IT A1

    I changed the bullet points to smiley faces. I did this by going into the slide master and highlighting the first level, I went to Format, Bullets and Numbering, Customize then I chose my symbol and clicked Ok. When creating a Presentation you can choose either to put background colours

  2. Design Section

    details page Forename, Surname on the Customer Details Page Text N/A manually entered by the user House Number on the Customer Details Page Number N/A manually entered by the user Country, City/State on the Customer Details Page Text N/A manually entered by the user Email Address on the Customer Details

  1. System requirements analysis

    internal print server, HP Jet direct connectivity cards �46,50 I think a HP Business Inkjet 2800 Printer is most suitable for the health centre. The resolution is between 300 to 600 dots per inch and the cheapest ones are well under a �100 and also they are quite small.

  2. Computerised accounting

    money Less Space Required Again this is a another benefit of a computerised accounting system as the less space that an accounting firm needs the cheaper it is going to be. Therefore this means that accounting firms can locate their premises in the main cities were it will be accessible

  1. The new system is required to calculate the costs of a new car as ...

    > The system must validate data as it is input and must not allow the user to enter invalid data in a cell i.e. entering text when the cell should only contain numbers. Available Hardware and Software There are certain limitations in terms of resources available, in order to produce

  2. drum kit costing system

    Chris also mentioned to me that his old system wasn't very effective, and that he wanted a much simpler costing model. He gave me some background information about the type of drum kits and prices etc, to change the current system.

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