OMD Project Management Essay

Background cultivation OMD conduct perplexity is a consultancy that provides construction realise perplexity for its lymph nodes. OMD sound discoverion heed was set up approximately eighteen months ago and has a ply of three. They waste access to a huge acquisition base, which may be c wholeed upon as required to encounter project conditions. This helps to bring down overheads and increase profit ability. The flora include the following services* measured surveys,* agendum of condition (report on the state of the building, identifying any(prenominal) argonas that leave behinding incur rectification at the lymph nodes cost.* Lease judgement (review legal documents on invitees behalf)* Cost estimate of endures.* press whole shebang to specialist contractors* Manage projects* Agree concluding costs of the project with contractors on behalf of client* agree statutory regulations are complied with (planning approvals building regulations and disabled inconsis tency act)Although OMD Project management is a sm exclusively troupe it has a large client base. These vary from large multi-national companies to sm altogether private businesses. They specialise with the retail area where they take over at least twenty years of experienceProblem A current fare that the union has is invoicing. Invoicing currently do-nothing take up to an hour to complete. Invoicing is currently d superstar by strive and on paper, this is not a very good way of doing this argument because it takes up withal a great deal date and human erroneous belief is often an issue. These errors washstand include charging too much or too little specie. By providing an handbill clay it would husband the familiarity large make divulges of time an effort. It would similarly reduce the heart of human error and increase the verity of the placard.Current Invoice System OMD project management currently do all of their invoicing on paper. This representation t hat the consultant forget remember his hours his expenses and his hourly drift in his head and when it comes around to invoicing the client he go away quality all of these things up on to Microsoft word, print it off and give it to the client so the are able to pay the company. As you could tuck this is a very inefficient way of invoicing the client. This grass similarly lead to large summate of errors during the invoicing process, for compositors case a client may be low charged or over charged.End substance absubstance absubstance abuser Skills The primary(prenominal) user of the document that I willing shit is of the grey-haireder generation. He prefers to do things the old fashioned way, this means that he deals to do his invoicing on paper using a calculator and a pen and it would currently take him longer to create an invoice on the estimator than it would for him to do it on paper, however he is not congeries computer illiterate and he is able to use close w ord processing and spread sheet platformmes. OMD Project Management would like to me to create an invoice musical arrangement that is simple yet effective so that he is able to save time by move his invoice system onto computer and they would excessively like me to create a system that is able to be apply by everyone in the company.RequirementsGeneral* The invoice must(prenominal)iness be in Lucida sans console.* The text must be black in colour* The broadcast must be user friendly* The company logo must be at the slip away of the invoice* The clients book of facts point must be at the top left of the rascal but lower than the logo.* The invoice trope should be on the left hand side of the marrow squashmon and under the citation.* A division of the invoice should be in the middle of the rapscallion honest to a lower place the invoice be.* The match, in bold, will go underneath the invoice dislocation.* The company address will go at the bottom of the scally wag.* It must look professional.qualitative* The plan must be able to gestate all of the different types of expenses.* The class must be able to name different types of jobs.* The program must double up as an estimating system.* The program must produce an accurate invoice.* The program must fend for different client addressesQuantitative* From start to finish off the invoice must scarce take 15 minutes.* The invoice must be able to hold 3 different types of jobs* The program must be able to hold at least 20 different client addressesHardware and Software there is a currently a huge amount of hardware available on the market. You post steal many different types of computer each one worthy for a different purpose, for example laptops are por bow and contribute be taken anywhere, this can be very convenient as the user is able to do his work anywhere and also with the invention of wireless technology the user can connect to the meshwork anywhere that wireless internet is available. Another type of PC that is available is background knowledge PC. This is a PC that stays stationary. This type of PC gives you a lot much room to type etc and also has a mouse as standard, these can be permanently linked up to a printer and/or the internet.The current system that OMD Project management runs is a Compaq Presario with an Intel Pentium 4 processor. OMD Project Management tints that there is no need to purchase a modern system because they feel that their current system is sufficient and suitable for the job in hand. on that point are many different types of software that is suitable for this project. I believe that the most capture is a spreadsheet package. This is because you are able to use the program to picture lots of different things. With a bit of self teaching you are able to use the program to do lots of different processes. OMD Project Management already has Microsoft office XP installed on their system and they feel that I should use Micro soft Excel to create their invoice system. This is so that it is compatible with their system. I believe that this is a good choice as Excel is more than adequate for the task in hand.Input move in the job type engraveEnter all the things to with the amount of work done* The reckon of sidereal days worked.* Enter the correct code that corresponds to the appropriate expenditure paid per dayEnter all the applicable expenses flesh out* The progeny of miles travelled and the number of nights stayed in a hotel.Enter the code for the desired client addressEnter the client addresses.* Code number* Address retrace 1* Address line 2* postcode* contact number movementLookup the type of job according to the code and multiply the rate of pay by the number of days worked.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. outturnA 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. shew 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. to a fault I will devise tests that will be conducted during and after the implementation stage this will acknowledge me to improve my system greatly and identify any errors that are in my system. canvassNumberTestTest DataExpectedOutcome developedOutcomeCorrectiveAction1abc chasten dateValidation run. average10/08/05Extreme32/08/05 preposterous374hcbsiWill yieldData.Wont hold the date.Should not accept thisAs anticipateAs expectedAs expected2 note that the commandment has worked to suppose the sub-total.N/AThe sum of the total cash owed for work and expenses.As expected3 occlusive t hat the reflexion for operative out the VAT works.N/AThe product of the sub-total multiplied by 17.5%.As expected4Check that the look for working out the total works.N/AThe sum of the sub-total and the VAT.As expected5 abcCheck the hunting function works for the job type code number.no(prenominal)mal2Extreme4Erroneous224hsdnsgIt should return 315.00.It comes up with an error messageIt should come up with an error message.As expectedIt comes up with 275 which is the value for 3As expectedPut a governance rule on it so that no number higher than 3 can be entered.6Check that the normal for working out the total amount of money owed for work done works.N/AThe product of the price paid per day and the number of days worked.As expected7Check that reflection for calculating travel expenses works.N/AThe product of the price per mile and the number of miles travelled.As expected8Check that formula for calculating the amount of money owed for staying in hotels.N/AThe product of the pri ce paid per night and the number of nights stayed.As expected9Check that formula for calculating the total expenses owed for works.N/AThe sum of the amount owed for travelling and the amount owed for hotelsAs expected10Check that the sum-up page big spill works.N/AThe sacking takes you to the summary page.As expected11Check that the breakdown page large instruction handout works.N/AThe spillage takes you to the breakdown page.As expected12Check that the job type page macro button works.N/AThe button takes you to the job type page.As expected13Check that the client address page macro button works.N/AThe button takes you to client address pageAs expected14Check that the vindicated invoice/summary macro button works.N/AThe button clears all of the entries that are on the invoice.As expected15Check that clear breakdown macro button works.N/AThe button will clear all of the entries that are on the summary sheet.As expected16Check that the back to briny placard macro button on t he breakdown sheet works.N/AThe button will take you back to the master(prenominal) card page.As expected17Check that the back to main menu macro button on the job type sheet works.N/AThe button will take you back to the main menu page.As expected18 abcCheck data validation for D2D14 on breakdown sheet to allow numbers only.Normal30ExtremeDErroneousdn8949The program allows entry.It shows an error message to explain that no letter are allowed.As above.As expectedAs expectedAs expected19 abTest the lookup function for the client addressesNormal3Extreme51Erroneous73hdhb.It will look up the client address with that code number.It shows N/A in the electric cell meaning there is an error in the formula.As above.As expectedIt comes up with zeroAs expectedI will put a validation rule on the cell so that it will only allow numbers below 51.20Check that the back to main menu macro button on the client details sheet works.N/AThe button will take you back to the main menu page.As expected21Gi ve the program to OMD project Management for them to test itImplementation Log17/11/05The first stage of my implementation was to go into two worksheets.I whence renamed my worksheets for easy reference the sheets will be named Main Menu, Summary, Breakdown, Job typewrite and Client Details. here(predicate) I fuck off entered all of the column headings for the client details addresses present I have highlighted cells A1F51 this allows the user to enter up to 50 different addresses as stated in the requirements. I then named the table Address.Here I have entered all the data for the different types of jobs.And here I have doted the cells to currency so that the data in these cells is displayed as a currency.I highlighted cells B2D5 and inserted a name. The table name is now jobs.Here I have entered all of the headings for this table and I have then highlighted cells A1F15 and named them Breakdown.Here I have entered the vlookup formula,that will lookup the different rates that c orrespond to the code No. entered and put them onto this sheet.As you can see the vlookup formula has worked as it has entered the rate of pay. I have also put in the formula to workout amount of money owed.I have entered the formula to calculate the amount of money owed for travelling.Here I have entered the formulae to work out the total amount of money owed for expenses and to work out the money owed for staying in hotels. I have also formatted all the cells containing monetary set to currency.As you can see here I have entered all the text onto the summary sheet.Here I have entered a validation rule to the date cell on the invoice which only allows a date to be entered in the format 00/00/00 and it must be greater than 01/01/2000.I also added my own error message to inform the user of what the need to enter.Here I have entered the vlookup formula which will lookup each part of the address that corresponds to the code and the transfer them onto this sheet. I entered the same for mula 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 workHere 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 use for navigation. To create the macro button I used the forms toolbar and clacked on the button icon and I move 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 d eletes 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.