assignment

profilesandeep soman
ProjectPackage5_TeamBurnRate-ResourceRate-ReleaseVelocity_GroupMembers_v1.0_GroupMembers_v1.01.xlsx
Home>Information Systems homework help>assignment

Product Backlog-Master

Product Roadmap Report
Sprint Number Epic 1 No. Epic Description No. Story ID. User story Task ID Tasks Priority Status Environment Created Date Start Date End Date Duration Man-Hours Man-Hours Story Points
Sprint 1-7: October 15, 2019 - January 31 2020 Planned Hours Actual Hours Planned Rurned Rate Actual Burn Rate
Sprint 1 Epic 1 US1 As an Admin user, I should be able to LOGIN to Double Travels Application so that I can add/edit/delete/retrieve user profile information from the system (Front end/Back end) 1.1 Install Visual Studio (For coding platform) High Done In Production 10/1/19 10/15/19 10/31/19 16 50 48 5
Sprint 1 Epic 1 1.1 Install Authentication system (3rd party tool) High Done In Production 10/1/19 10/15/19 10/31/19 16 40 35 5
Sprint 1 Epic 1 US2 As an Admin user, I should be able have access to the following modules when login so that I can view the contents information and manage for business uses. 2.1 Module 1 for website content (manageable by Admin only) High Done In Production 10/1/19 10/15/19 10/31/19 16 60 55 5
Sprint 1 Epic 1 US9 As an Admin user, I want to get a popup (an alert message) when an user register for Umrah package so that admin can login to Double H Travels and view customer information. 9.1 create pop up message when Umrah Package registered High Done In Production 10/1/19 10/15/19 10/24/19 10 30 25 5
58 180 163 3.10 2.81 20
Sprint 2 Epic 2 US5 As an Admin user I should be able to Add/modify/delete system notice (system error message) when server is down and/or under maintenance. 5.1 Test to create server down situation and test High Done In Production 10/2/19 11/1/19 11/14/19 13 10 10 21
Sprint 2 Epic 2 US6 As a public user, I should be able to view a server down error message like “Server is temporarily unavailable due to the maintenance work, we will be back soon, sorry for your inconvenience“ so that I can contact website matters offline via phone calls 6.1 make Skype compatible for incoming calls High Done In Production 10/2/19 11/1/19 11/14/19 13 8 8 8
94 228 206 2.43 2.19 29
Sprint 3 Epic 3 US7 As a Public user, I should be able to register Hajj Package from the DoubleHTravels, so that Travel Agency can have my profile information for planning my Hajj Package. 7.1 Add package information from exiting Flyer Medium Done In Production 10/3/19 11/1/19 11/14/19 13 2 2 5
13 2 2 0.15 0.15 5
Sprint 4 Epic 4 US7 7.2 Create "Hajj Package" module under Admin item Medium Done In Production 10/4/19 11/1/19 11/14/19 13 2 2 13
Sprint 4 Epic 4 US8 As a public user, I should be download forms from the help menu so that I can send my visa request offline. 8.1 PDF format for downloadable High Done In Production 10/4/19 11/1/19 11/14/19 13 10 10 8
Sprint 4 Epic 4 Us8 Done In Production 10/4/19 11/1/19 11/14/19 13 2 2 5
39 14 14 0.36 0.36 26
Sprint 5 Epic 5 US10 As a public user, I should be able to send an email from contact us without logging into my personal email account so that the system stores all emails under [email protected] account 10.1 Create email domain from gmail.com and Define TCP or UDP High Done In Production 10/7/19 11/1/19 11/14/19 13 2 2 5
13 2 2 0.15 0.15 5 85
Sprint 6 Epic 6 US10 10.2 POP3 Server (Incoming Messages) High Work-in-Progress (WIP) In Dev 10/10/19 11/15/19 11/29/19 14 2 2 8
Sprint 6 Epic 6 US10 10.3 SMTP Server (Outgoing Messages) High Work-in-Progress (WIP) In Dev 10/10/19 11/15/19 11/29/19 14 2 2 5
Sprint 6 Epic 6 US10 10.4 Email testing High Work-in-Progress (WIP) In Dev 10/10/19 11/15/19 11/29/19 14 2 2 8
Sprint 6 Epic 6 US3 As a Public user, I should be able to register Hajj Package from the DoubleHTravels, so that Travel Agency can have my profile information for planning my Hajj Package. 3.1 Add package information from exiting Flyer Low Work-in-Progress (WIP) In Dev 10/10/19 11/15/19 11/29/19 14 2 2 5
56 8 8 0.14 0.14 26
Sprint 7 Epic 7 Home Page - enhance UI elements DoubleH1.0 The user should be able to see a friendly user interface when they visit Double H Travels website Update UI Design Medium Not Started Backlog 10/10/19 12/2/19 12/16/19 14 14 14 13
Sprint 7 Epic 7 US4 As an admin user, I should be able to manage (Add/modify/delete) Double H travels Website content privately Medium Not Started Backlog 10/10/19 12/2/19 12/16/19 8
14 14 14 1.00 1.00 21

1-Burn Rate

Sprint Number Story ID. Start Date End Date Total Days Planned Hours Actual Hours Planned Burn Rate (Hours) Actual Burn Rate (Hours)
Sprint 1 US1 10/15/19 10/31/19 16 50 48
Sprint 1 10/15/19 10/31/19 16 40 35
Sprint 1 US2 10/15/19 10/31/19 16 60 55
Sprint 1 US9 10/15/19 10/24/19 10 30 25
58 180 163 3.10 2.81
A=Total Planned Hours/Total Planned Days=Burn Hour Rate is 3.10
B=Total Actual Hours/Total Actual Days=Burn Hour Rate is 2.81

2-Resource Utilization

Sprint Number Epic 1 No. Epic Description No. Story ID. User story Task ID Tasks Priority Status Env. Team Allocated Hrs/Day Allocated Hrs (%) Allocated Hrs/Day (Based on %) Current Date (Today 11/20) Actual Hrs used until today Created Date Start Date End Date Duration
Sprint 6 Epic 6 US10 10.2 POP3 Server (Incoming Messages) High WIP In Dev Baby 8 0.5 4 11/20/19 5 10/10/19 11/15/19 11/29/19 14
Sprint 6 Epic 6 US10 10.3 SMTP Server (Outgoing Messages) High WIP In Dev Baby 8 0.5 4 11/20/19 5 10/10/19 11/15/19 11/29/19 14
Sprint 6 Epic 6 US10 10.4 Email testing High WIP In Dev Jane 8 0.25 2 11/20/19 5 10/10/19 11/15/19 11/29/19 14
Sprint 6 Epic 6 US3 As a Public user, I should be able to register Hajj Package from the DoubleHTravels, so that Travel Agency can have my profile information for planning my Hajj Package. 3.1 Add package information from exiting Flyer Low WIP In Dev Sandeep 8 0.25 2 11/20/19 5 10/10/19 11/15/19 11/29/19 14
Total 32 100% 12 20
B A
Rule: A/B= (20/12)
Days Used 1.67 rounded as 2 Days
So we are on about 3rd days of our current sprint (Sprint 6) as per planned date.
Hence, the Resource Utilization Rate is 1.67 hours per day.
Notes
Projected hrs= 32 The assumption hrs like 196
12 Total team hrs like 14
2.67 =3rd day
So the answer is as follows:
Team used 1.67 (2 hrs) hrs per day
Team is on the 2.67 (3rd day) day

3-Release Velocity

Product Roadmap Report
Sprint Number Epic 1 No. Story ID. Status Environment Created Date Start Date End Date Story Points
Sprint 1 Epic 1 US1 Done In Production 10/1/19 10/15/19 10/31/19 5
Sprint 1 Epic 1 Done In Production 10/1/19 10/15/19 10/31/19 5
Sprint 1 Epic 1 US2 Done In Production 10/1/19 10/15/19 10/31/19 5
Sprint 1 Epic 1 US9 Done In Production 10/1/19 10/15/19 10/24/19 5
20
Sprint 2 Epic 2 US5 Done In Production 10/2/19 11/1/19 11/14/19 21
Sprint 2 Epic 2 US6 Done In Production 10/2/19 11/1/19 11/14/19 8
29
Sprint 3 Epic 3 US7 Done In Production 10/3/19 11/1/19 11/14/19 5
5
Sprint 4 Epic 4 US7 Done In Production 10/4/19 11/1/19 11/14/19 13
Sprint 4 Epic 4 US8 Done In Production 10/4/19 11/1/19 11/14/19 8
Sprint 4 Epic 4 Us8 Done In Production 10/4/19 11/1/19 11/14/19 5
26
Sprint 5 Epic 5 US10 Done In Production 10/7/19 11/1/19 11/14/19 5
5
Sprint 6 Epic 6 US10 Work-in-Progress (WIP) In Dev 10/10/19 11/15/19 11/29/19 8
Sprint 6 Epic 6 US10 Work-in-Progress (WIP) In Dev 10/10/19 11/15/19 11/29/19 5
Sprint 6 Epic 6 US10 Work-in-Progress (WIP) In Dev 10/10/19 11/15/19 11/29/19 8
Sprint 6 Epic 6 US3 Work-in-Progress (WIP) In Dev 10/10/19 11/15/19 11/29/19 5
26
Sprint 7 Epic 7 Not Started Backlog 12/6/19 12/2/19 12/16/19 13
13
1 Total Completed Story Points (Sprint 1-5) 85 Notes:
Number Completed Sprints (5-done) 5 (For 6 months - 13 sprints)
Total Story Points (Total Points 1-7) 124
Team Velocity (All story points / # completed sprints = Velocity) 24.8 (124/5)
Total # of Sprints 7
Release Velocity (Velocity * total sprints = release velocity) 173.6 (24.8*7)