3. Project Estimation Document.xlsx

	A	B	C	D	E	F	G	H
1	DESIGNER ESTIMATION — PLAN vs ACTUAL
2	Project: PodSeries - Audio Streaming App \| Client: Devsol \| PM: Ussama Javed \| Date: Jan–Apr 2025
3	Project Name:	PodSeries - Audio Streaming App			Client:	Devsol
4	PM / Scrum Master:	Ussama Javed			Date:	Jan–Apr 2025
5	SECTION A — WIREFRAMES (Plan vs Actual)
6	Screen / Flow Name	Planned Hrs	Actual Hrs	Variance		Notes	Status	Priority
7	Onboarding / Splash Screen	3	3	0		Brand colors + audio theme animation	Done	High
8	Login	1	1	0		Email + Google OAuth	Done	High
9	Sign Up	1	2	1		Profile + preferred categories setup	Done	High
10	Home Screen (Series + Podcast Tabs)	5	6	1		Dual tab layout with featured content	Done	High
11	Series List & Detail	4	4	0		Episode list with sequence order	Done	High
12	Podcast List & Detail	4	5	1		Category filter + guest bio section	In Progress	High
13	Audio Player Screen	4	3	-1		Full-screen player + mini player	In Progress	High
14	Admin Panel – Series Upload	3	—	—		Multi-step upload form	To Do	Medium
15	Admin Panel – Analytics Dashboard	3	—	—		Play count charts	To Do	Medium
16	User Profile & Settings	2	—	—		Preferences, notification settings	To Do	Low
17	TOTAL WIREFRAME HOURS	30	24
18
19	SECTION B — DESIGN COMP (Plan vs Actual)
20	Screen / Flow Name	Planned Hrs	Actual Hrs	Variance		Notes	Status	Priority
21	Onboarding / Splash Screen	8	8	0		Brand colors, audio waveform animation	Done	High
22	Login	3	3	0		Clean minimal UI	Done	High
23	Sign Up	3	4	1		Multi-step category preference form	Done	High
24	Home Screen (Series + Podcast Tabs)	16	18	2		Featured banner + dual tab layout	Done	High
25	Series List & Detail + Episode List	12	12	0		Episodic card list with play buttons	Done	High
26	Podcast List & Category Filter	12	—	—		Category pills + podcast cards	In Progress	High
27	Audio Player (Full Screen + Mini)	10	—	—		Waveform, progress bar, controls	In Progress	High
28	Admin Panel UI (Web)	16	—	—		Upload forms, tables, charts	To Do	Medium
29	TOTAL DESIGN HOURS	80	45
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
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