Please see the attached excel screen shot:PROJECT DATA

The ProjectData Excel file contains data collected by the project manager for the Twin Pine Properties project. Initial data is listed in Week $0,$and is updated week by week. There are $4$ weeks left in the project. Data for Weeks $21-24$ are empty, and will be populated with actuals. The project data consists of budget $($in dollars$),$baseline SLOC $($the number of software lines of code in the baseline$),$defects $($the number of defects that need to be resolved$),$and story point backlog $($the amount of work to be done, measured by story point estimates on user stories$).$

QUANTITATIVE STATUS REPORT

Write a report on the quantitative status of the project at the end of Week

$20$

$.$

$$The report will include plots and findings for the following metrics, based on the historical data captured in the ProjectData file.

BUDGET BURN RATE

The data file contains the total budget over time through Week

$20$

$.$

$$Plot the budget data over time. Calculate the amount of budget consumed each week. What is the average budget consumed per week? Which week was the most expensive? Based on the current budget in Week

$20$

$$and average burn rate, will the project overrun or underrun the budget? And by how much?

SLOC VELOCITY

$/$

PRODUCTION

The data file contains the total number of Software Lines of Code $($SLOC$)$in the baseline over time through Week $20.$Plot the baselined SLOC data over time. Calculate the number of SLOC added each week. On average, how many SLOC were developed each week? Which week produced the most SLOC? Which week had the lowest SLOC production?

DEFECT DENSITY

The data file contains the total number of defects in the baseline over time through Week $20.$Plot the number of defects per SLOC over time. Which week has the highest density of defects? The team's density goal is to have less than $0\mathrm{.}001$ defects$/$SLOC$,$ does the project currently have good quality or poor quality?

SPRINT VELOCITY

The data file contains the total story points in the backlog over time through Week $20.$ Plot the story point backlog over time. Calculate the number of story points completed each week. On average, what is the number of story points completed per week? Based on story points, which week was the most productive? Which week was the least productive? Considering the amount of story points left in the backlog and the weekly sprint velocity, do you think the team is behind, ahead, or on schedule to deliver at the end of Week $24?$