• 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

OMD project management currently do all of their invoicing on paper. This means that the consultant will remember his hours his expenses and his hourly rate in his head and when it comes around to invoicing the client he will type all of

Extracts from this document...

Introduction

Coursework Company: OMD Project Management Background Information: OMD Project Management is a consultancy that provides construction project management for its clients. OMD Project Management was set up approximately eighteen months ago and has a staff of three. They have access to a large skill base, which may be called upon as required to satisfy project conditions. This helps to reduce overheads and increase profit ability. The works include the following services: * measured surveys, * Schedule of condition (report on the state of the building, identifying any areas that will incur rectification at the clients cost. * Lease appraisal (review legal documents on clients behalf) * Cost estimate of works. * Tender works to specialist contractors * Manage projects * Agree final costs of the project with contractors on behalf of client * Ensure statutory regulations are complied with (planning approvals building regulations and disabled discrimination act) Although OMD Project management is a small company it has a large client base. These vary from large multi-national companies to small private businesses. They specialise with the retail sector where they have at least twenty years of experience Problem: A current issue that the company has is invoicing. Invoicing currently can take up to an hour to complete. Invoicing is currently done by hand and on paper, this is not a very efficient way of doing this job because it takes up too much time and human error is often an issue. ...read more.

Middle

Calculate the amount of expenses owed for travelling. Calculate the amount of expenses owed for staying in hotels. Calculate sub-total, VAT and the final total. Output: A full invoice with the amount owed for work done and the amount owed for expenses with sub-totals, VAT added and the final total at the end. It should also display the company logo, company address, company logo and the client address. It should look professional. Test Strategy: I will test my program in three different ways. I will ask my end user to use my new system and ask them to give me feedback on it so I am able to adjust it to their liking. Also I will devise tests that will be conducted during and after the implementation stage this will allow me to improve my system greatly and identify any errors that are in my system. Test Number Test Test Data Expected Outcome Actual Outcome Corrective Action 1a b c Check date Validation rule. Normal 10/08/05 Extreme 32/08/05 Erroneous 374hcbsi Will accept Data. Won't accept the date. Should not accept this As expected As expected As expected 2 Check that the formula has worked to calculate the sub-total. N/A The sum of the total money owed for work and expenses. As expected 3 Check that the formula for working out the VAT works. N/A The product of the sub-total multiplied by 17.5%. As expected 4 Check that the formula for working out the total works. ...read more.

Conclusion

I entered the same formula for the 4 cells below but each time increasing the column index number by one. This is the formula that copies the amount of money owed for work from the breakdown sheet onto the summary sheet. This formula is the same as above except that it copies the total amount of expenses owed instead of the amount of money owed for work Here is the formula to calculate the sub-total. And here is the formula to work out the VAT to be added. And finally the formula that will work out the total amount of money owed. This is me recording the macro that will take you from the main menu page to the breakdown page. I will do the same for each macro that is used for navigation. To create the macro button I used the forms toolbar and clicked on the button icon and I drew the button. I then right clicked it and assigned the appropriate macro to it. So now whenever I click the button it will take me to the specified page. Here I am assigning the macro to the macro button. I have recorded a macro that deletes all the entries that have been entered into the invoice breakdown sheet. This macro button clears all the information, on the invoice summary page, that changes. And for the addresses it changes the code so that a line is displayed instead of the client address. I did this each time I recorded a new macro and just chose a new name for it. ?? ?? ?? ?? Oliver Tatum ...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 Computer Science 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 Computer Science essays

  1. Computing Project

    The shop clerk is computer literate but will require a bit of training before using the actual system. 3. User needs and acceptable limitations The shop clerk would like the system to: * Have some sort of security so I will be placing a username and password as security *

  2. Business blue print document for the implementation of SAP R/3 (4.6B) payroll at Mastek ...

    Hence the payroll area defined in the SAP R/3 system for MSI is: - 02 - Semi Monthly - USA PAY SCALE GROUP The Pay Scale Group will be in terms of grades in the organization. The list of Pay Scale Group that is to be customized as under: - 1.

  1. Computing Project

    Also when taking an interview the user may not tell everything that he wants and in some cases the interviewee are not honest. This would mean that the system I make would not be as useful as it could be.

  2. Excel Coursework - Engineering Hours Accounting System.

    Performance Indicators My solution will have to: * Prevent all employees seeing other employees' hours. * Be simple to use, and not waste employees' time. * Prevent errors wherever possible by using validation and combo-boxes. * Allow Mr. Salomon to create reports (with graphs)

  1. For this project I will be constructing an I.T. solution for Castle Couriers. Castle ...

    1.1.2 User Requirements The owners of Castle Couriers have a number of requirements: -Reduce time spent on inputting data -This will aid the expansion process because an increase in data will not lead to a further increase in time spent processing.

  2. Ilford Cricket Team Data Analysis Project.

    This is all what is needed by a coach and captain of a team to improve his quality of work and also his tactics and hopefully win games. Data Flow Diagram Current System SYMBOL KEY: = ENTITY = PROCESS = DATA FLOW FIGURE 1.1 Process Flowcharts Data Flow Diagram Proposed

  1. The Data Management Structure: Components and the data structure

    Beginning from the second row (Row 2) onwards we have the DATA. For example "John Smith" is one data in the "Name" field, the number "52396587" is one data in the "Tel" field and the address "10, Riverdale St" is one data in the "Address" field. An entire set of data in a single row is called a RECORD in database terminology.

  2. Computer Aided Design Package

    The other point is that people may damage their eyes from the computer screens, but if they take a break every hour and comply with the health and safety laws they should not suffer any negative effects from their work.

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