Homework answers / question archive / Assignment 3 - Earned Value Analysis Develop a model that conducts earned value analysis

Assignment 3 - Earned Value Analysis Develop a model that conducts earned value analysis

Computer Science

Share With

---

Assignment 3 - Earned Value Analysis

Develop a model that conducts earned value analysis. The model takes two inputs:

1. a CSV file

2. a report date from the user’s input. (Please use Week 4 for the default example)

The output will be the answer to parts a through d below. Assume all activities are reported to have started on time:

a) EV Analysis at the “report date” in a table (or tabulated) format as shown below:

Task | ACWP | BCWP | BCWS | SPI | SV | CEI | CV

b) Draw the EV graph for the project (prediction portion of curves are not needed). Build a function to analyze and return what the current status of the project is in terms of schedule and budget underneath the graph:

The project is_____ budget

The project is_____ schedule

Provide your EV graph values in an output table (or tabulated) format as shown below:

Task	Planned Duration	Actual Duration till now	BCWS/Week	ACWP/Week	BCWP/Week

 

c) Assuming the project continues at the same rate, build a function to return the EAC and the estimated projected duration.

Estimate at completion:

Estimated project duration:

d) Assume that the productivity of the remainder of the activities (those that have not started till the report date), will remain as planned (i.e. actual durations remain the same as planned durations). What would be the revised schedule, considering the schedule changes that have occurred to the project till this point? Provide the answer in a table/tabulated format as below where o subscript indicates the original dates and r subscript indicates the revised dates.

Task	Duration	ES0	EF0	LS0	LF0	ESr	EFr	LSr	LFr

 

Submission Requirements:

Submit to Assignment 3 Dropbox folder on D2L

1. A well-commented source code. Please use: first name_family format for naming of the files (e.g.

2. A page describing the logic used for each code in graphical format (PDF file). You can use flowcharts, pseudo-codes, workflow diagram, or one of the common formats of expressing the logic.

Notes:

• There is no need to submit the original csv file. A csv file with different content but same format will be utilized to test and verify your code.

 

• Your program should be commented well enough for the instructor to understand it; e.g. function defined, variables. Please use in-text comments. You are encouraged to use built-in in text comment such as Live script, Jupyter notebook, or Pycharm. Please refer to the following link for best practices for in-text comments and implement these in your code:
• Please include a Header Block for your submission that includes the information printed in the example below. You can decide on the format:

Assignment: ASSIGNMENT NUMBER AND TITLE

Author: STUDENT'S NAME HERE

Due Date: Assignment Due Date Here

Language: NAME OF LANGUAGE IN WHICH THE PROGRAM IS WRITTEN AND THE

NAME OF THE COMPILER USED TO COMPILE IT WHEN IT WAS TESTED

To Compile: EXPLAIN HOW TO COMPILE THIS PROGRAM

Description: DESCRIBE THE PROBLEM THAT THIS PROGRAM WAS WRITTEN TO SOLVE.

Input: DESCRIBE THE INPUT THAT THE PROGRAM REQUIRES.

Output: DESCRIBE THE OUTPUT THAT THE PROGRAM PRODUCES.

Algorithm: OUTLINE THE LIST OF MAIN ALGORITHMS USED TO SOLVE THE PROBLEM.

Not Addressed: DESCRIBE HERE ANY REQUIREMENTS OF THE ASSIGNMENT THAT THE PROGRAM

IS NOT ABLE TO ADDRESS.

Known Bugs: IF THE PROGRAM DOES NOT FUNCTION CORRECTLY IN SOME SITUATIONS,

DESCRIBE THE SITUATIONS AND PROBLEMS HERE.

Grading Rubrics (100)

a) EV Analysis values at the “report date” in a table (or tabulated) format. (20)

b) EV graph + Reporting the status. (15)

EV graph values in table (or tabulated) format. (15)

c) Build a function to return the EAC and the projected duration. (10)

d) Revised schedule, table/tabulated format. (25)

Graphical logic diagram (5)

Well commented source code throughout: (10)

Input method (opening CSV file): Your program should work with any other input file. If the program can only solve the given question, i.e., is not able to read any other files: -50%

Bonus (10 marks)

PLEASE NOTE:

Assignments are individual work. It is important that, under no circumstances, students exchange or share their codes/files, in part or full, with one other students. Any sharing of code will be considered plagiarism, and both the person(s) who shared it, and those who have received it will be reported for academic misconduct. As part of the assignment, students should be ready to explain and comment on their codes. For each assignment, random work will be selected to be examined; the submitter of the selected work will be asked to explain their code and answer questions about it. If a satisfactory explanation about how the code is written is not provided, or questions are not answered, no grade will be given for that assignment.