The following exercises are intended to review the information you acquired in the two courses on Project Management and to give you a chance to test your knowledge.
You will be using MS Excel to calculate the costs, prices and gross profit margin of translation projects:
- Exercise 1: Here you will have to calculate Gross Profit Margin from the given costs of a project and the price paid by the customer.
- Exercise 2: In this exercise you will have to create a quote for a translation project.
- Exercise 3: From the analysis made in a TM system on the basis of an existing Translation Memory (including exact and fuzzy matches) you will have to calculate the translation costs.
- Exercise 4 and 5: Planning exercise where you will need to allocate resources, divide the tasks and set deadlines for each of them.
If you need information on how to write formulas in Excel, have a look at Question 7 in our ICT Skills course 4.