A formula can be used to calculate the value of a

 A formula can be used to calculate the value of a cell

P a g e | 28
 Functions are premade formulae and can be located here:
To enter a formula you will need to:
 Select a cell
 Type the equal sign (=)
 Type your formula.
To edit a formula you will need to:
 Click the formula bar
 Edit
 Press enter.
Example mathematical formulae you may use include:
 Add cells:
 Multiply cells:
 Subtract cells:

P a g e | 29
Staff acquisition
Once you have allocated your available resources within your budget, you will need to assess whether
your human resources have the necessary skill sets to cover the project tasks. You may decide to allocate
various tasks to one individual or you may decide to train staff prior to the commencement of the
project. Depending on your organisation you may need to source and obtain human resources from
external sources in order to ensure you are able to complete all project tasks.
You can assess whether your project will require further human resources by considering the
following factors:
 Historical data – you should compare previous project requirements to determine the
human resources you will require in your project.
 Research external factors – you should consider any factors that may influence your
project, these may include, equipment, skill set, weather, events and holidays
 Organisational requirements – your organisation may have allocated a certain number
of human resources to one area of a project that you cannot amend for example one
human resource must remain on reception. This may influence which human resources
and their skill sets should be allocated to one task.
Team development
Throughout your project, you will need to monitor the work output from your human resources. There
are two formulae to measure the performance of your human resources:
 Productivity
 Efficiency.
Formulae to measure productivity:
To calculate the productivity of human resources, you will need to determine your input and output.
Your input may be hours or employees and your output may be profit or products.
Formulae to measure efficiency:
To calculate the efficiency of human resources, you should use the following formula:

P a g e | 30
The percentage of efficiency may be influenced by various factors including:
 Turnover rate of human resources
 Absentee Rate whether scheduled or unscheduled
 Idle time and actual hours needed to complete the task.
The advantage of measuring human resources’ performance and output is the ability
to record and analyse the data in future projects. The results may indicate problems areas for human
resources with the need for further training to be provided, or the data may indicate areas where too
many human resources were allocated to a particular task unnecessarily.

P a g e | 31
1.4 – Apply human resources management (HRM) methods, techniques and
tools to support engagement and performance of personnel
By the end of this chapter, you should be able to demonstrate:
