• 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. Marked by a teacher

    The systems development life cycle (SDLC) is a conceptual model used in project management ...

    3 star(s)

    If users are able to require all proposed features be included in the final system this can lead to feature creep. Developer attachment to prototype: Developers can also become attached to prototypes they have spent a great deal of effort producing; this can lead to problems like attempting to convert

  2. 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 *

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

    At Mastek the salaries are defined in terms of Total Annual Gross (TAG) and then the money is divided into the various wage types of the employee. For the purpose of customization, one Pay Scale Level will be defined For the US compensation, Dallas has been taken as base location.

  2. I have been given the task to design a database for a company called ...

    * With tables you cannot have buttons, where as, you can with forms. Over all forms are better for this type of system as they are more user friendly because they look less intimidating than tables and require less work on behalf of the user as they can have buttons

  1. Spare Parts Database Project

    New data will be added to the database at a convenient time, possibly at the end of the week. The procedure that the user will fellow is described in the design section. 4.2 TABLES AND RELATIONSHIPS Tables and relationships were set up as specified in the design section.

  2. The Controversy of Head Start

    This federally funded program feels the noose tightening because of plans to let individual states "opt in" with their own state-run "head start-like" programs. Supporters of Head Start believe that by allowing this a majority of funding that the federal government provides will be diverted from Head Start to build up new state-run programs.

  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. ict implementation

    clicks on the stock list button and the "Build your own pc " worksheet opens: As you can see below the worksheet "customer details " opens and works Test number 4 The user clicks on the stock list button and the "invoice" worksheet opens: As you can see below the worksheet "invoice " opens and works: Test number 5 1)

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