YEAR OF UNIVERSALIZATION AND HEALTH.

NATIONAL UNIVERSITY OF PIURA

SCHOOL OF MINING ENGINEERING

SCHOOL OF MINING ENGINEERING

ALUMNO:HEINER YAMIL ORDOÑEZ SANTOS

TOPIC: USE OF MS PROJECT

COURSE: MINING OPERATIONS CONTROL

TEACHER: DR. ENG. JOSE LUIS VEGA FARFAN

 PIURA – PERU – 2020

ABSTRACT

This document shows a reference oriented to the use of Microsoft

Project program, similarly oriented to the administration of a project from the initial.

configuration of local configuration, work calendars, activity planning, link

generation, construction of Gantt diagrams, Gantt tracking, route identification,

resource allocation, tracking and other basic aspects.

The structure of the document is aimed at understanding the Project

work logic using practical cases with the learning by doing methodology.

It should be noted that the use of this program depends on its daily use.

and that there are different procedures that lead to the same result, which is

why what is referred to in the document and in-person explanation is not the

only way to achieve the proposed objectives. With Microsoft Project, you can do

the following

Create project plans.

Form project teams and assign resources.

See different views of tasks and resources.

Measure progress.

• Manage budgets (Microsoft office, 2017).

SUMMARY

This document provides a reference oriented towards the use of

Microsoft Project program, focused on the management of a
project from the initial setup of local configuration, calendars of
work, planning of activities, generation of links, construction of
Gantt charts, tracking Gantt, path identification, assignment
of resources, monitoring and other fundamental aspects.

The structure of the document is aimed at understanding the

work logic of Project using practical cases with the methodology
to learn by doing.

It should be noted that the use of this program will depend on its usage

everyday life and that there are different procedures that lead to it
result, reason why what is referred to in the document and explanation
in-person is not the only way to achieve the proposed objectives. With
Microsoft Project can do the following:

Create project plans.

Form project teams and assign resources.

View different views of tasks and resources.

Measure progress.

Manage budgets (Microsoft Office, 2017).

INTRODUCTION
Microsoft Project is a support tool for the Initiation process,

planning, execution, monitoring and closure, established by management

Projects during the different phases of its life cycle, with the aim of

achieve effective and timely control regarding deviations in scope, the

cost, time, and quality of a project, which allows and facilitates decision making

assertive decisions for the success of the project.

In this tutorial, you will find an easy way to get to know and learn the

operation of the Microsoft Project tool, through the execution of

a practical exercise consisting of the application of some surveys that

guidelines on the processes that should be followed for the development of a project

taking as a model that of the example.

It is project management software designed, developed and

marketed by Microsoft to assist project managers in the

development of plans, allocation of resources to tasks, follow-up on

progress, manage budget, and analyze workload.

OBJECTIVES

GENERAL OBJECTIVES

The main objective of this report is to have a

broader knowledge of earned value using the tool

Microsoft Project, while solving the exercise presented in class.

The objective of this workshop is to understand the functions of the program.

PROJECT, its utilities and how it can help us

students in the construction of our knowledge.

SPECIFIC OBJECTIVES

Know the different phases that make up a project.

Create a project plan.
Define tasks.
Linking of tasks.
Recognize and differentiate the different types of resources involved
in a project.
Assign resources to each of the tasks.
Analyze the costs of each of the resources.
Optimize planning.
Carry out project monitoring and analyze the variations that occur.
produced with the initial planning.
Control the scheduling (time) and finances (costs) of a
project, knowing the deviations from the planning
initially developed.
Report on the progress or advancement of an ongoing project.
Use of MS Project according to what was requested in the exercise.

attached file.
THEORETICAL FRAMEWORK

EARNED VALUE METHOD.

Earned Value Management is a methodology

explained in this module that serves to determine the performance of the

costs and project scheduling. This analysis is one of the

tools for measuring performance and more effective feedback

to manage projects, which also takes into account the risk in the project.

This tool, although new to me, seems to be an excellent analysis of

project control that I hope to master and be able to use in

large projects. To do this, I would like to first understand, in a way

general, the results obtained and the limitations that this method entails.

Regarding the first point, it has already been explained that it provides an objective measure.

how much work has been completed on the project, through

comparisons between the work that has been planned to be completed to date and

the one that has really been carried out. In this way, it is determined whether the

cost, deadline, and the work done are in accordance with the plan.

On the other hand, it is necessary to know the limitations that this method involves.

to look for others that implement it or replace it for the determination of

certain aspects necessary for planning.

For example, the variation of the programming, in terms of time,

it presents complications in the earned value analysis to calculate the delay

or advance in units of time, which could confuse the Manager of the

Work. For this, the Earned Programming Technique (PG) will be used,

simple and more precise.

The Earned Programming (EP) consists of the amount of time units,

what has really been achieved regarding the total scheduled time for the work,

with the work done by the cutoff date. With this, it can be estimated

Actually, how behind or ahead we are in relation to the deadline of

contract, encompassing the total magnitude of the project's items.

For a more detailed analysis of these time variations would be more

a study of the Baseline with a Gantt Chart is convenient for each

scheduled counteractivity or task.

The differences between the delay measured in a follow-up to the Gantt chart and

the delay measured in a follow-up with Earned Value is the

following:

a) The verifiable delays in the Gantt Chart can be traced at the level of

tasks; in the Earned Programming, the delay corresponds to the total that remains for

to do and is out of sync with the valued work schedule.

 b) The delay in time in the Gantt chart cannot tell us how much of

Additional time we need in order to be on schedule (deadline

global additional).

c) It is possible to assess the amount that represents the delay of the entire project (and

therefore, calculate the loss and even including the date by which one has to

proceed to assess extensions of time or penalties for delays.

It should be clarified that Earned Value and Planned Value techniques measure

all the progress of the work, they do not go into specific details about it, and how

such, it is in that area of action where it shows all its potential as

tool for a Project and Construction Manager.

PHASES OF A PROJECT
RESOURCES AND COSTS

The staff and equipment are the resources with which it works

project. With Microsoft Project, you can assign resources to tasks and

after using the tools and presentations in Microsoft Project

to manage these resources and the entire project more effectively

efficient.

The cost is an important aspect of programming and control.

project. For example, cost considerations determine the

speed at which tasks are carried out and how they are employed

resources. In some cases, the success of the project is measured by the

deviation between the project's final costs and the projected costs.

HISTORY AND CHARACTERISTICS OF MS PROJECT

Project management software.

Created by Microsoft.

First version in 1984, for DOS operating system.

Macintosh version: July 1991

• Create scheduling of critical routes, critical chains, and methodology of

chain events.

["Gantt chart.","Recognizes different types of users. (Project access)."]

Microsoft revealed that future versions of Microsoft Project will include

Fluid user interface.

DEVELOPMENT

PROPOSED EXERCISE
The construction project of a park must begin on January 2nd of
2021 and its activities have a simple connection, that is to say, a sequence.
FC.
Determine:
a) The baseline and determine its total initial cost and its
total duration of the project and of each of the phases
Make the following changes
 Activity Start Change
l
Demolition of 4 days
sidewalks
old
Formwork 4 days later
news
finished
leveling
Concrete It took me 6 days
Garden cleaning It took me 20 days.
Excavation 8 days
Add soil from 7 days
chakra

With these changes, what is it:

a. What is the new duration of the project and each phase?

b. The new project costs for each phase and their variations with
regarding the initial
c. Carry out a monthly progress control of the work and determine in
every month:
a. If you are earning financially and yes, you are
within the scheduled date.
b. You should prepare a data table PV, EV, AC
in each control month and show the S curve for
each frame.
c. Determinar el CPI, SPI, EAC y VAC de cada mes
d. Crear una tabla en la vista de diagrama de Gantt
determining (I work 50% of the project's progress.
a. It must have the fields duration, duration of
línea de base, costo, Costo previsto, trabajo,
expected work.
b. You must create a field that displays the phrase:
HE IS MAKING A PROFIT ECONOMICALLY, BUT
LOSING PHYSICALLY o THIS
SAVING costs, BUT YOU ARE
DELAYING IN THE PHYSICAL PROGRESS OF
PROJECT
DEVELOPMENT

A) The baseline and determine its total initial cost and total duration

project and of each of the phases:

Duración Comienzo End of Work Cost of

Task Name
foreseen foreseen planned baseline baseline
Sat game 5,064
PROJECT 89 days $33,025.00
14/11/20 18/03/21 horas
sat play
PATHS 19 days 896 hours S/3,965.00
14/11/20 10/12/20
game 4,168
GARDENS 70 days Thu 10/12/20 S/29,060.00
18/03/21 hours

B) What is the new duration of the project and of each phase when carrying out the

corresponding changes:

Task Name Duration Beginning End

PROJECT 105 days sat 02/01/21 vie 28/05/21

PATHS 26 days Sat 01/02/21 Mon 08/02/21

GARDENS 79 days Mon 08/02/21 vie 28/05/21

C) New project costs, for each phase and their variations with

regarding the initial.

Name of Accumulation
Total cost Expected Variation
task of fixed costs
PROJECT Prorrateo S/35,169.00 S/33,025.00 S/2,144.00
PATHS Proration S/4,429.00 S/3,965.00 S/464.00
GARDENS Prorrateo S/30,740.00 S/29,060.00 S/1,680.00

JANUARY FEBRUARY MARCH APRIL MAY

S/9,869.0 S/33,025.0
S/21,545.00 S/33,025.00 S/33,025.00
PV 0 0
S/2,655.0
S/5,813.00 S/9,089.00 S/16,625.00 S/33,025.00
EV 0
S/2,839.0 S/10,493.0
$6,893.00 S/18,769.00 S/35,169.00
AC 0 0
D) Carry out a progress control of the project MONTH by MONTH and determine in

every month:

a. If you are making a profit and you are within the

programming date.

JANUARY FEBRUARY MARZO APRIL MAY

S/9,869.0
S/21,545.00 S/33,025.00 $33,025.00 S/33,025.00
PV 0
$2,655.0
S/5,813.00 S/9,089.00 S/16,625.00 $33,025.00
EV 0
S/2,839.0
S/6,893.00 S/10,493.00 $18,769.00 $35,169.00
AC 0
VC -S/184.00 -S/1,080.00 -S/1,404.00 -S/2,144.00 -S/2,144.00
 b. You must prepare a table of data PV, EV, AC in each
control month and display the S curve for each frame.

JANUARY FEBRUARY MARCH APRIL MAY

S/9,869.0 S/33,025.0
S/21,545.00 S/33,025.00 S/33,025.00
PV 0 0
S/2,655.0
S/5,813.00 S/9,089.00 S/16,625.00 S/33,025.00
EV 0
S/2,839.0 $10,493.0
S/6,893.00 S/18,769.00 S/35,169.00
AC 0 0

$40,000.00

S/35,000.00

S/30,000.00

S/25,000.00

S/20,000.00

S/15,000.00

S/10,000.00

S/5,000.00

S/0.00
0.5 1 1.5 2 2.5 3 3.5 4 4.5 5 5.5

PV=CPTP EV = CPTR = VA AC= CRTR

 c. Determine the CPI, SPI, EAC, and VAC for each month

JANUARY FEBRUARY MARCH APRIL MAY

PV S/9,869.00 S/21,545.00 S/33,025.00 S/33,025.00 S/33,025.00
EV S/2,655.00 S/5,813.00 S/9,089.00 S/16,625.00 S/33,025.00
AC S/2,839.00 S/6,893.00 S/10,493.00 S/18,769.00 S/35,169.00
VC -S/184.00 -S/1,080.00 -S/1,404.00 -S/2,144.00 -S/2,144.00
- -
6.93032015 15.4472439
% VC 1 -18.57904696 2 -12.8962406 -6.492051476
0.93518844 0.86619651
CPI 7 0.843319309 2 0.885769087 0.93903722
EAC 33,025.00 33,025.00 33,025.00 33,025.00 33,025.00
BAC S/35,313.74 S/39,160.73 S/38,126.45 S/37,283.98 S/35,169.00
VAC -S/2,288.74 -S/6,135.73 -S/5,101.45 -S/4,258.98 -S/2,144.00
SPI 1.01 1.04 1.06 1.15 0.00

E) Create a table in the Gantt chart view

determining (I work 50% of the project's progress.

a. It must have the fields duration, line duration

base, costo, Costo

planned, work, planned work.

Duration
Work on
%
Name of Start Duration Work Cost of o line
Fin complete Cost
task n o o baseline planned base
o
o estimated
a
life 5,656 5,064
PROJECT105 Sat S/35,169.0 S/33,025.0 89
28/05/2 50% hour hour
O days 2/01/21 0 0 days
1 s s
1,032 896
26 sat moon 100% S/4,429.00 per hour S/3,965.00 per hour
19
PATHS days 2/01/21 8/02/21 days
s s
life 4,624 4,168
79 moon S/30,740.0 S/29,060.0 70
28/05/2 36% hour hour
GARDENS days 8/02/21 0 0 days
1 s s
 Name % completado Cost Line cost Variation of

base cost

PROJECT 50% S/35,169.00 S/33,025.00 S/2,144.00

Value Value
Name of
planned: accumulated PV: AC (CRTR) VP VC CEF CPF VAF
task
(CPTP) VA (CPTR)

PROJECT S/33,025.00 S/8,236.96 S/9,581.00 -S/24,788.04 -S/1,344.04 S/38,413.75 S/33,025.00 -S/5,388.75

PATHS S/3,965.00 S/3,965.00 S/4,429.00 S/0.00 - S/4,429.00

S/464.00 S/3,965.00 -S/464.00

GARDENS S/29,060.00 S/4,271.96 S/5,152.00 -S/24,788.04 -S/880.04 S/35,046.47 S/29,060.00 -S/5,986.47

35000

30000

25000

20000

15000

10000

5000

0
'20 '21 '21 '21 '21 '21 '21 '21 '21 '21 '21 '21 '21 '21 '21 '21 '21 '21 '21 '21 '21 '21

CRTR CPTR CPTP

The accumulated value of the Project based on the status date. If the

real cost (CRTR) is greater than the accrued value (CPTR), the Project

it is above budget. If the planned value (CPTP) is greater

that the accumulated value, the project is behind schedule with respect to the

programming.

You must create a field that displays the phrase: 'YOU ARE WINNING'
economically, but losing physically or is saving costs, but

You are delaying the physical progress of the project.

you are delaying the physical progress of the project and the actual budget is short

above what was planned

USES OF MS PROJECT

It is a work tool for administrators and project managers,

used to organize and track tasks efficiently, in order to avoid thus

los retrasos y no salirse del presupuesto previsto. básicamente, crea

programs and follows its process, in addition to calculating costs. it can be

complement with elements of Microsoft Excel. there are many types of

tools within this software, so that the analysis of the

data is much simpler.

TYPES OF TOOLS IN MS PROJECT

Critical Path.

Gantt chart.

Resource overload.

Project summary.

Cost calculation. • Project control.

ADVANTAGES AND DISADVANTAGES

ADVANTAGES

See the impact of a change.

Ease of control of finances.

Flexible monitoring and analysis of projects.

Utilization of graphs and charts.

You can change the background color of the cells or the rows with Highlighting

cell background.

Use of enhanced views.

Information sharing.

It helps to better organize the work and allows the staff to guarantee

that projects are delivered on time and within budget.

Getting help when needed.

Time-saving with templates. Create your own templates.

customized.
DISADVANTAGES

It only works on Windows platforms, not freeware. It is not software.

multiplatform.

80% of MS Project users use 20% of its numerous features.

options.

The productivity of machines and people cannot be measured,

nor performance. high cost and investment.

CONCLUSIONES
we can deduce that Project is a great work tool that

it makes it easier for us to carry out projects such as in the

allocation of resources to tasks, managing budgets, and having a

follow-up.

Project is a very useful program for planning and organization.

any activity, if you want to do it efficiently, contains

the necessary tools for the proper development, monitoring and

channeling of any project.

It helps us manage the phases and resources correctly from time.

os, materials, budgets, personnel, costs, generate reports,

representations thanks in the shortest time and of course with the

minimum effort, for this Project must always be fed with

useful and correct data.

Its use is very user-friendly and this represents the feasibility to take it to

cable within any work, school, personal, etc.

RECOMMENDATIONS

Break down the tasks to the level of detail for tracking that is

They should be broken down in more detail in the areas that

present a greater risk.

Ensure that the task completion criteria are met.

clearly defined. Define the tasks that are short in comparison

with the total duration of the project. The shorter tasks allow

estimate the time and resources more easily.

Review the project scope and the task list.

Obtain historical information on durations and resources.

Consider how the quantity of resources affects the durations.

Consider how capacity and quality affect durations.

Review and refine the duration estimates.

Identify the types and quantities of resources needed.

Entrust an expert with reviewing the resource requirements.

BIBLIOGRAPHIC REFERENCES
MICROSOFT PROJECT MANUAL.

[Link]

the-desk-of-project-6e74dc79-0e2d-480b-b600-3a466bf289a3