IC-Agile-Product-Requirements-Template-Example_Google_Sheets

	B	C	D	E	F	G	H	I	J	K
1

2	AGILE PRODUCT REQUIREMENTS TEMPLATE EXAMPLE					https://www.smartsheet.com/try-it?trp=11943&utm_source=template-google-sheet&utm_medium=content&utm_campaign=Agile+Product+Requirement+Example-google-sheet-11943&lpa=Agile+Product+Requirement+Example+google-sheet+11943
3	NAME		Product Beta Tracking System			START DATE	END DATE	OVERALL PROGRESS
4	PROJECT MANAGER		Brent Williams			09/02	10/10	35%
5
6	AT RISK	TASK NAME	FEATURE TYPE	RESPONSIBLE	STORY POINTS	START	FINISH	DURATION in days	STATUS	COMMENTS
7	No	SPRINT 1		Alex B.		09/03	09/13	11	Complete
8	No	Feature 1		Frank C.		09/03	09/07	5	Complete
9	Yes	Feature 2		Jacob S.		09/07	09/12	6	Not Started
10	No	Feature 3		Jacob S.		09/09	09/13	5	In Progress
11	No	SPRINT 2		Jacob S.		09/16	09/24	9	Complete
12	Yes	Feature 4		Alex B.		09/16	09/17	2	Approved
13	No	Feature 5		Frank C.		09/17	09/21	5	On Hold
14	No	Feature 6		Shari W.		09/22	09/24	3	Complete
15	No	SPRINT 3		Shari W.		09/24	10/05	12	Not Started
16	No	Feature 7		Alex B.		09/24	09/29	6	Not Started
17	No	Feature 8		Kennedy K.		09/27	10/02	6	Not Started
18	No	Feature 9		Jacob S.		10/02	10/05	4	Not Started
19
20	REQUIREMENTS
21	1. USER STORY
22	As a customer, I want to be able to track my order status so that I can plan accordingly.
23	ACCEPTANCE CRITERIA	• The customer should be able to view real-time order status updates. • Notifications should be sent for significant status changes.
24	2. DESCRIPTION
25	FEATURE / REQUIREMENT NAME	Order Tracking System
26	DESCRIPTION	Develop a system that allows customers to track their order status from placement to delivery.			PRIORITY	High
27	ESTIMATION	8 story points
28	3. DEPENDENCIES
29	DEPENDENT USER STORIES	None
30	EXTERNAL DEPENDENCIES	Integration with courier service APIs for real-time updates.
31	4. ACCEPTANCE CRITERIA
32	CRITERIA 1	Customers can see the current status (e.g., processing, shipped, delivered) when they log in.
33	CRITERIA 2	Notifications are sent via email and mobile app push notifications.
34	5. ASSUMPTIONS AND CONSTRAINTS
35	ASSUMPTIONS
36	Customers have stable internet connections for real-time updates.
37	CONSTRAINTS
38	Budget allocation for third-party API integration is limited.
39	6. RISKS AND MITIGATION
40	RISK		IMPACT		MITIGATION
41	Potential delays in API integration from courier services.		Could delay the real-time tracking feature rollout.		Explore alternative courier APIs and develop a fallback plan.
42	7. ITERATION / RELEASE PLAN
43	ITERATION: Sprint 5
44	USER STORIES INCLUDED	Order Tracking System, User Profile Enhancements
45	ESTIMATED COMPLETION DATE	End of this sprint
46	8. REVIEW AND RETROSPECTIVE NOTES
47	REVIEW NOTES	Order tracking system implemented successfully. Some users reported delayed notifications.
48	RETROSPECTIVE	Improve notification system performance for future sprints.
49
50	CLICK HERE TO CREATE IN SMARTSHEET
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100