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

am going to set-up a Computer Systems Maintenance Company called 'RR Payroll System,' which provides a range of support for its customers, which are all businesses.

Extracts from this document...


Title - GIGO Systems - Payroll System Student Name - Student Number - Centre Name - Centre Number - Date - Contents - Analysis * Introduction * Specification * Interview With * Data Flow Diagram * Module Map * Hardware And Software Requirements * User's Skill Level ANALYSIS: Introduction I am going to set-up a Computer Systems Maintenance Company called 'RR Payroll System,' which provides a range of support for its customers, which are all businesses. Each customer is allocated to an Account Manager. A team of Account Managers are employed to handle the needs of existing customers and to find new business. The Account Managers receive a basic salary, initially between �10,000-�12,000 per year. They also receive a commission depending on their total sales of maintenance contracts in a month: � If the value of the contracts sold in any month is below �1000 no commission is paid. � For sales of �1000 or more, but less than �5000 the commission will be 3% of that month's sales. � For sales of �5000 or more but less than �10,000 the commission will be 4%. � Sales of �10,000 or greater will earn commission of 5%. A monthly target is set for each Account Manager and if they are more than 20% below this then a warning letter is generated. ...read more.


* Is there any other advice that you can give me to help me towards producing my system? He insisted I should produce macros {buttons} such as 'Exit, Print and Main Menu,' etc, which when pressed onto by the Account Managers will do the following which is stated on the button. He told me to produce a back-up of the system because the system may get damaged due to a virus and the Managers will require their system back which will be notified to them, plus more through the 'User Guide.' Specification 1. My system will be able to store details of the following; - Details of a minimum of six Account Managers, each consisting of; Employee ID, Title, First Name, Surname, Basic Salary, Monthly Target, etc. - Tax, National Insurance and Commission Rates, etc. 2. My system will be able to enter monthly Sales Contracts details and to validate data appropriately when it is entered. Use appropriate default values to minimise user entry. - calculate the monthly commission - calculate who gets the bonus for that month 3. My system will be able to produce two main types of output; - Produce a warning letter issued to those Account Managers performing below 80% of target set. ...read more.


He/she will have to help the individual Account Managers on any difficulties they encounter or they should use the 'User Guide,' which will be linked to 'RR Payroll System.' The employees who have been employed are on a high level of work as they are 'managers,' so they should be able to resolve the basic problems, which they encounter. DESIGN: Choice Of Software This system will be implemented using 'Microsoft Excel 97.' This package is ideal as it includes many features which can be used in customising the application, such as: * Ability to create a blank template. * Ability to link product details entered in one workbook with invoice details entered in a second workbook through a table lookup. * Pivot tables to create monthly summaries. * Sophisticated report facilities with the ability to format text, set margins, page layout, import a company logo and preview before printing. * Charting facilities including ability to add a trend line. * Ability to protect worksheets and workbooks so that the user cannot accidentally destroy formula or headings. * Formatting to help make it clear to the user where to enter data. * Macros which will execute automatically on opening and closing workbooks. * Customised menus and toolbars. * Auditing tools to help ensure that there are no errors in the workbook. ?? ?? ?? ?? GIGO Systems - Payroll System ...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. The Design Brief - The company is a car hire company called Citicar.

    I got their feedback, which was mostly good and got them to fill in a questionnaire about what they thought of the User guide. Overall, feedback from users has been a key aspect to my project. What the users who tested my design thought I tested my design on potential users and asked for there feedback.

  2. Creating a computer system for a video rental shop

    Excel has disadvantages as well as advantages, these include: - * If you change the name of a page after making a macro it can't find the correct page because it has changed names. This means you then have to go into Visual Basic and manually change the name of the page on the actual piece of code.

  1. Computer Systems Assignment 2

    Because DOS loads quicker, it is more productive for computer programmers (provided they are not dyslexic) who do not need all the frills that Windows provides. a) Any frills are not important to computer programmers, like the help page, the font manipulation, the background colour, the wall paper, the task

  2. ICT car insurance quotation System Coursework

    This will give the dealers that professionalism they like to show their customers. Where did you get the information for your system from? We got the information for car details box, by contacting the Autotrader and asking them if they'd allow us to copy their drop down lists of car makes and models.

  1. Creating a computer system.

    If an electronic system was chosen I could use Microsoft access to design the system on or Sybase or even Oracle. Oracle would be a difficult system to use because it too advanced for me yet. A good system to choose would be Microsoft access because it gives you help, lets you set up tables, reports, queries, forms very easily.

  2. System requirements analysis

    It is very fast printing approximately 10 pages a minute and the resolution is very high being typically 600 dots per minute and this means they can print high quality documents. The next type of printer is the ink jet printer.

  1. Chessington Motor Centre (CMC) Information Technology System

    ___/___/___ Time of start of job (hh:mm) ___:___ Time of finish of job ___:___ Mechanic Name__________________________________ Type of Job__________________________ Objectives of the new system The manager at CMC has requested that the new system to be implemented, must: * Allow workers to complete and store invoice.

  2. I.T. System for a Newsagents

    Do you use you system for any record of your business or financial work? A) No, I only use the computer for my e-mail and to write letters to people. 4) Have you employed any staff? A) No, my family and me run our business.

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