Develop a work program and generate plan target

Assignment Help Project Management
Reference no: EM133421078

Project Planning and Scheduling

Learning Outcome 1: Ability to develop project report using EVMS and communicate with project stakeholders

INSTRUCTION:

1. Project

2. Please develop a work program (refer to the attached excel - tasklist), generate plan target and update actual progress. Based on the work program answer and submit the project based on following questions.

QUESTIONS:

1. Setting for the project:
- File Name: Put Your Full Name as the File Name for Ms Project File
- Project Start Date: 1 January 2024 (Monday)
- Daily Schedule: 8 am - 7 pm (8 am - 12 pm, then 1 pm - 7 pm setting in calendar)
- Working Day: Every day (No holiday)
- Daily hours: 10 hours
- Weekly hours: 70 hours
- Day in Month: 30 Days
- Save File into folder name 1. Original

2. Generate Plan/Target Progress:
- Save Files into Folder Name 2. Plan
- Generate data (blue colour) for financial (actual cost) and physical progress (% complete) based on biweekly target cycle date as shown below.
- Save files based on the biweekly plan target date (green colour)

3. Update Actual Progress:
- Save files into folder name 3. Actual
- Files need to be save/set baseline first before updating/tracking.
- Generate data (yellow colour) for financial (actual cost) and physical progress (% complete) based on biweekly updated cycle date as shown below. You can also calculate the variance value (orange colour) once you got actual cost and % complete values.
- Please update based on three (3) dates only based on the given scenario:
o Info on 14/1/2024

• Survey & Setting Out at Zone A - Actual Start Date (1/1/2024), Actual Finish Date (11/1/2024)
• Earthwork at Zone A - Actual Start Date (12/1/2024), % complete 20%
• Survey & Setting Out at Zone B - Actual Start Date (12/1/2024), % complete 10%.

o Info on 28/1/2024
• Earthwork at Zone A - Actual Start Date (12/1/2024), Actual Finish Date (24/6/2023)
• Survey & Setting Out at Zone B - Actual Start Date (12/1/2024), Actual Finish Date (19/1/2024)
• Earthwork at Zone B - Actual Start Date (25/1/2024), % complete 5%
• Excavation footing at Zone A - Actual Start Date (25/1/2024), % complete 5%.

o Info on 11/2/2024
• Earthwork at Zone B - Actual Start Date (25/1/2024), Actual Finish Date (4/2/2024)
• Excavation footing at Zone A - Actual Start Date (25/1/2024), Actual Finish Date (5/2/2024)
• Lean Concrete at Zone A - Actual Start Date (6/2/2024), Actual Finish Date (7/2/2024)
• Formwork at Zone A - Actual Start Date (8/2/2024), % complete 18%
• Excavation footing at Zone B - Actual Start Date (5/2/2024), % complete 80%.

4. Draw Financial and Physical Progress Graph:

- Based on the updated financial and physical progress values as in item (3), please use excel software to draw the financial and physical progress graph that shows the 3 in 1 graph i.e., target, actual and variance values.
***Note:

- You are given 3 files (Excel Task list, Steps, Setting) to assist you in completing the exercise.

Attachment:- Project.rar

Reference no: EM133421078

Questions Cloud

What was one effort to reform those living in the territory : discuss two examples of the treaties, wars, and/or laws that allowed for the expansion or settlement of the US's territory from the 1860s to the early-1900s.
Suffering from high blood pressure and insomnia : Susan is now suffering from high blood pressure and insomnia.
Do you think the progressive era was truly progressive : Base on your understanding of the US History text, Progressive Era presentation and internet links, Do you think the Progressive Era was truly "Progressive"?
Thinking over the prothero readings : Thinking over the Prothero readings, is his project successful in your opinion?
Develop a work program and generate plan target : MKAM 1053 Project Planning & Scheduling, University of Technology, Malaysia - develop project report using EVMS and communicate with project stakeholders
What were contributing factors leading to war with mexico : What were the contributing factors leading to War with Mexico and identifying top 3 military leaders and the important role they played in this conflict.
Consider the role of african american women in racial uplift : Consider the role of African American women in racial uplift. What is the importance of African American suffragists in this uplift? Who is Anna Julia Cooper
Explain correct process for weighing and creating portions : Explain the correct process for weighing and creating portions for the following ingredients commonly used in commercial kitchens.
Correct process for weighing and creating portions : Explain the correct process for weighing and creating portions for the following ingredients commonly used in commercial kitchens

Reviews

Write a Review

Project Management Questions & Answers

  Project based on assigned and actual work

Evaluate status of a Project Based on Assigned and Actual Work - the formula concerning schedule and cost refers to the financial data but when there are only dates how does that calculation go?

  Organization to fill positions needed in projects

When is cross-training important in an organization to fill positions needed in projects?

  How would you design authorities of a project manager

What caused the conflict between the project managers and the other employees and how would you design the authorities of a project manager at BEC?

  Plan for the denver international airport project

Installation of a baggage handling system (BHS) was an important part of the plan for the Denver International Airport (DIA) project.

  Why do lessons learned programs often fail

Why do lessons learned programs often fail to capture meaningful information that could help guide future projects?

  What type of culture promotes a strong project environment

Describe how organizational culture is related to project management. What type of culture promotes a strong project environment?

  Multiple-choice constraint on decision making

Describe how effective this multiple-choice constraint has on decision making.

  What factors would you consider in your forecast

If rent control policies are in place that keep rent below the market price determined by supply and demand, will there be a shortage or a surplus of apartments?

  What are strategies used by project managers to assess

What are Strategies used by Project Managers to Assess, Monitor, and Communicate Project Risks to Stakeholders

  Project charter and project management plan

In this assessment item you have to define the high-level goals and objectives of your project. The Project Charter is a contract between you and the client.

  Project managementassume you work in a small firm that has

project managementassume you work in a small firm that has multiple projects happening simultaneously and that the

  Number of proposals labeled patients bill of rights

A number of proposals labeled "patient's bill of rights" have emerged in the last 7 years with many states already enacting such legislation. Although patient privacy was an issue, there was an exception for releasing patient information under certai..

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd