Proposal Details

Zee TV

TimeBand Mix

Type

ER CPRP CPT

Market TG

Planning Market TG

Target ER/CPRP/CPT (net value)

Weeks

Planning Weeks

Ratings Type

ad break – Level 1 + 2 ad break – Level 2 commercial – Level 4

Select
Details

Band Selection

Band Name

DOW

From Time

End Time

Band Name	DOW	From Time	To Time
Wd Npt	M T W T F S S	07:00	18:00
Wd Pt	M T W T F S S	18:00	00:00
We Npt	M T W T F S S	07:00	18:00
We Pt	M T W T F S S	18:00	00:00

Parent	Band Name	Share %
	Wd Npt	56.00%
	Wd Pt	27.00%
	We Npt	5.00%
	We Pt	12.00%

Update TimebandMix Save Close

Grid

Show	Start Time	End Time	DOW	Card Rate	Billing Rate	Valuation Rate	Alloc Sec	Amount	CPRP
Repeat 1700-1800	17:00	18:00	M T W T F S S	10,700				21,05,040	23,867
Apna Time Bhi Aayega	19:00	19:30	M T W T F S S	42,800				2,16,020	39,063
Kundali Bhagya	21:30	22:00	M T W T F S S	1,46,800				16,59,520	50,350
Kyun Rishto Me Katti Batti	22:00	22:30	M T W T F S S	49,900				2,44,790	38,856
Repeat 1700-1800	17:00	18:00	M T W T F S S	10,700				1,88,240	26,815
IPML	20:00	21:30	M T W T F S S	3,00,000				15,87,200	79,360
Total					16,762	16,762	3,580	60,00,810	37,502

Sales Unit

Show	Start Time	End Time	DOW	TVR	Card Rate	CPRP	Action
RODP NPT WD 0700-0900	07:00	09:00	M T W T F S S	0.03	2,900	96,667	G I S
Morning Repeats	08:00	08:30	M T W T F S S	0.03	2,300	76,667	G I S
Morning Repeat	08:30	09:00	M T W T F S S	0.04	2,200	55,000	G I S
RODP 9-12 MF	09:00	12:00	M T W T F S S	0.21	9,650	45,952	G I S
Repeat 0900-0930 MF	09:00	09:30	M T W T F S S	0.09	11,600	1,28,889	G I S
Repeat 0930-1000 MF	09:30	10:00	M T W T F S S	0.20	10,000	50,000	G I S
Repeat 1000-1030 MF	10:00	10:30	M T W T F S S	0.16	11,400	71,250	G I S
Repeat 1030-1100 MF	10:30	11:00	M T W T F S S	0.22	12,200	55,455	G I S
Repeat 1100-1130 MF	11:00	11:30	M T W T F S S	0.27	14,710	54,481	G I S
Repeat 1130-1200 MF	11:30	12:00	M T W T F S S	0.26	12,900	49,615	G I S
Repeat 1200-1230 MF	12:00	12:30	M T W T F S S	0.23	13,400	58,261	G I S
RODP 12-15 MF	12:00	15:00	M T W T F S S	0.27	10,450	38,704	G I S
Repeat 1230-1300 MF	12:30	13:00	M T W T F S S	0.29	13,600	46,897	G I S
Repeat 1300-1330 MF	13:00	13:30	M T W T F S S	0.32	14,710	45,969	G I S
Repeat 1330-1400 MF	13:30	14:00	M T W T F S S	0.29	12,200	42,069	G I S
Repeat 1400-1430 MF	14:00	14:30	M T W T F S S	0.23	13,400	58,261	G I S
Repeat 1430-1500 MF	14:30	15:00	M T W T F S S	0.21	10,500	50,000	G I S
Repeat 1500-1530 MF	15:00	15:30	M T W T F S S	0.25	13,530	54,120	G I S
RODP 15-18 MF	15:00	18:00	M T W T F S S	0.30	10,090	33,633	G I S
Repeat 1530-1600 MF	15:30	16:00	M T W T F S S	0.28	13,530	48,321	G I S
Repeat 1600-1700	16:00	17:00	M T W T F S S	0.32	12,800	40,000	G I S
Repeat 1700-1800	17:00	18:00	M T W T F S S	0.30	10,700	35,667	G I S
Repeat 18:00-19:00 MF	18:00	19:00	M T W T F S S	0.36	17,100	47,500	G I S
Apna Time Bhi Aayega	19:00	19:30	M T W T F S S	0.79	42,800	54,177	G I S
RODP without Kum Kum and Kundali	19:00	23:00	M T W T F S S	0.79	43,100	54,557	G I S
Hamari Wali Good News	19:30	20:00	M T W T F S S	0.70	42,800	61,143	G I S
Teri meri ek jindri	20:00	20:30	M T W T F S S	0.91	71,300	78,352	G I S
Teri meri ek jindri	20:00	20:30	M T W T F S S	0.91	71,300	78,352	G I S
Tujhse Hai Raabta	20:30	21:00	M T W T F S S	0.95	71,300	75,053	G I S
Tujhse Hai Raabta	20:30	21:00	M T W T F S S	0.95	71,300	75,053	G I S
Kumkum Bhagya	21:00	21:30	M T W T F S S	1.76	1,50,000	85,227	G I S
Kumkum Bhagya	21:00	21:30	M T W T F S S	1.76	1,50,000	85,227	G I 1
Kundali Bhagya	21:30	22:00	M T W T F S S	2.06	1,46,800	71,262	G I S
Kundali Bhagya	21:30	22:00	M T W T F S S	2.06	1,46,800	71,262	G I S
Kyun Rishto Me Katti Batti	22:00	22:30	M T W T F S S	0.90	49,900	55,444	G I S
Kyun Rishto Me Katti Batti	22:00	22:30	M T W T F S S	0.90	49,900	55,444	G I S
Qurbaan hua	22:30	23:00	M T W T F S S	0.58	45,000	77,586	G I S
Qurbaan hua	22:30	23:00	M T W T F S S	0.58	45,000	77,586	G I S
Kum Kum Bhagya 23-23:30 MF	23:00	23:30	M T W T F S S	0.21	11,000	52,381	G I S
Kum Kum Bhagya 23-23:30 MF	23:00	23:30	M T W T F S S	0.21	11,000	52,381	G I S
RODP 23- 24 MF	23:00	00:00	M T W T F S S	0.19	7,200	37,895	G I S
Repeat 2330-24:00 MF	23:30	00:00	M T W T F S S	0.17	7,100	41,765	G I S
Repeat 1600-1700	16:00	17:00	M T W T F S S	0.31	12,800	41,290	G I S
Repeat 1700-1800	17:00	18:00	M T W T F S S	0.29	10,700	36,897	G I S
Repeat 18:00-19:00 MF	18:00	19:00	M T W T F S S	0.35	17,100	48,857	G I S
RODP 0700 - 0900 SS	07:00	09:00	M T W T F S S	0.02	2,300	1,15,000	G I S
RODP NPT WE 0900-1200	09:00	12:00	M T W T F S S	0.10	8,900	89,000	G I S
RODP NPT WE 1200-1500	12:00	15:00	M T W T F S S	0.16	10,000	62,500	G I S
RODP 15-18 SS	15:00	18:00	M T W T F S S	0.26	11,400	43,846	G I S
Repeat 1600-1700	16:00	17:00	M T W T F S S	0.27	12,800	47,407	G I S
Repeat 1700-1800	17:00	18:00	M T W T F S S	0.27	10,700	39,630	G I S
Repeat 18:00-19:00 MF	18:00	19:00	M T W T F S S	0.34	17,100	50,294	G I S
RODP 18-20 SS	18:00	20:00	M T W T F S S	0.48	20,000	41,667	G I S
IPML	20:00	21:30	M T W T F S S	2.50	3,00,000	1,20,000	G I S
Brahmarakshas - 2	21:00	22:00	M T W T F S S	0.63	57,000	90,476	G I S
RODP SS 22-24	22:00	00:00	M T W T F S S	0.21	14,300	68,095	G I S

Impact

Show	Start Time	End Time	DOW	Card Rate	Billing Rate	Valuation Rate	Alloc Sec	Amount	CPRP	Planning CPRP	Impact
Repeat 18:00-19:00 MF	18:00	19:00	M T W T F S S	17,100				1,60,000	44,444	0
Total					16,000	16,000	100	1,60,000	44,444	0

Secondary Items

Show	Start Time	End Time	DOW	Unit	Valuation Rate	Billing Rate	Amount	Base Duration	Secondary items
Kumkum Bhagya	21:00	21:30	M T W T F S S				1,00,000	1
				10			1,00,000

Comment

Zee TV

TimeBand Mix

Type

ER CPRP CPT

Market TG

Planning Market TG

Target ER/CPRP/CPT (net value)

Weeks

Planning Weeks

Ratings Type

ad break – Level 1 + 2 ad break – Level 2 commercial – Level 4

Select
Details

Band Selection

Band Name

DOW

From Time

End Time

Band Name	DOW	From Time	To Time
Wd Npt	M T W T F S S	07:00	18:00
Wd Pt	M T W T F S S	18:00	00:00
We Npt	M T W T F S S	07:00	18:00
We Pt	M T W T F S S	18:00	00:00

Parent	Band Name	Share %
	Wd Npt	56.00%
	Wd Pt	27.00%
	We Npt	5.00%
	We Pt	12.00%

Grid

Show	Start Time	End Time	DOW	Card Rate	Billing Rate	Valuation Rate	Alloc Sec	Amount	CPRP
Repeat 1700-1800	17:00	18:00	M T W T F S S	10,700				21,05,040	23,867
Apna Time Bhi Aayega	19:00	19:30	M T W T F S S	42,800				2,16,020	39,063
Kundali Bhagya	21:30	22:00	M T W T F S S	1,46,800				16,59,520	50,350
Kyun Rishto Me Katti Batti	22:00	22:30	M T W T F S S	49,900				2,44,790	38,856
Repeat 1700-1800	17:00	18:00	M T W T F S S	10,700				1,88,240	26,815
IPML	20:00	21:30	M T W T F S S	3,00,000				15,87,200	79,360
Total					16,762	16,762	3,580	60,00,810	37,502

Sales Unit

Show	Start Time	End Time	DOW	TVR	Card Rate	CPRP	Action
RODP NPT WD 0700-0900	07:00	09:00	M T W T F S S	0.03	2,900	96,667	G I S
Morning Repeats	08:00	08:30	M T W T F S S	0.03	2,300	76,667	G I S
Morning Repeat	08:30	09:00	M T W T F S S	0.04	2,200	55,000	G I S
RODP 9-12 MF	09:00	12:00	M T W T F S S	0.21	9,650	45,952	G I S
Repeat 0900-0930 MF	09:00	09:30	M T W T F S S	0.09	11,600	1,28,889	G I S
Repeat 0930-1000 MF	09:30	10:00	M T W T F S S	0.20	10,000	50,000	G I S
Repeat 1000-1030 MF	10:00	10:30	M T W T F S S	0.16	11,400	71,250	G I S
Repeat 1030-1100 MF	10:30	11:00	M T W T F S S	0.22	12,200	55,455	G I S
Repeat 1100-1130 MF	11:00	11:30	M T W T F S S	0.27	14,710	54,481	G I S
Repeat 1130-1200 MF	11:30	12:00	M T W T F S S	0.26	12,900	49,615	G I S
Repeat 1200-1230 MF	12:00	12:30	M T W T F S S	0.23	13,400	58,261	G I S
RODP 12-15 MF	12:00	15:00	M T W T F S S	0.27	10,450	38,704	G I S
Repeat 1230-1300 MF	12:30	13:00	M T W T F S S	0.29	13,600	46,897	G I S
Repeat 1300-1330 MF	13:00	13:30	M T W T F S S	0.32	14,710	45,969	G I S
Repeat 1330-1400 MF	13:30	14:00	M T W T F S S	0.29	12,200	42,069	G I S
Repeat 1400-1430 MF	14:00	14:30	M T W T F S S	0.23	13,400	58,261	G I S
Repeat 1430-1500 MF	14:30	15:00	M T W T F S S	0.21	10,500	50,000	G I S
Repeat 1500-1530 MF	15:00	15:30	M T W T F S S	0.25	13,530	54,120	G I S
RODP 15-18 MF	15:00	18:00	M T W T F S S	0.30	10,090	33,633	G I S
Repeat 1530-1600 MF	15:30	16:00	M T W T F S S	0.28	13,530	48,321	G I S
Repeat 1600-1700	16:00	17:00	M T W T F S S	0.32	12,800	40,000	G I S
Repeat 1700-1800	17:00	18:00	M T W T F S S	0.30	10,700	35,667	G I S
Repeat 18:00-19:00 MF	18:00	19:00	M T W T F S S	0.36	17,100	47,500	G I S
Apna Time Bhi Aayega	19:00	19:30	M T W T F S S	0.79	42,800	54,177	G I S
RODP without Kum Kum and Kundali	19:00	23:00	M T W T F S S	0.79	43,100	54,557	G I S
Hamari Wali Good News	19:30	20:00	M T W T F S S	0.70	42,800	61,143	G I S
Teri meri ek jindri	20:00	20:30	M T W T F S S	0.91	71,300	78,352	G I S
Teri meri ek jindri	20:00	20:30	M T W T F S S	0.91	71,300	78,352	G I S
Tujhse Hai Raabta	20:30	21:00	M T W T F S S	0.95	71,300	75,053	G I S
Tujhse Hai Raabta	20:30	21:00	M T W T F S S	0.95	71,300	75,053	G I S
Kumkum Bhagya	21:00	21:30	M T W T F S S	1.76	1,50,000	85,227	G I S
Kumkum Bhagya	21:00	21:30	M T W T F S S	1.76	1,50,000	85,227	G I 1
Kundali Bhagya	21:30	22:00	M T W T F S S	2.06	1,46,800	71,262	G I S
Kundali Bhagya	21:30	22:00	M T W T F S S	2.06	1,46,800	71,262	G I S
Kyun Rishto Me Katti Batti	22:00	22:30	M T W T F S S	0.90	49,900	55,444	G I S
Kyun Rishto Me Katti Batti	22:00	22:30	M T W T F S S	0.90	49,900	55,444	G I S
Qurbaan hua	22:30	23:00	M T W T F S S	0.58	45,000	77,586	G I S
Qurbaan hua	22:30	23:00	M T W T F S S	0.58	45,000	77,586	G I S
Kum Kum Bhagya 23-23:30 MF	23:00	23:30	M T W T F S S	0.21	11,000	52,381	G I S
Kum Kum Bhagya 23-23:30 MF	23:00	23:30	M T W T F S S	0.21	11,000	52,381	G I S
RODP 23- 24 MF	23:00	00:00	M T W T F S S	0.19	7,200	37,895	G I S
Repeat 2330-24:00 MF	23:30	00:00	M T W T F S S	0.17	7,100	41,765	G I S
Repeat 1600-1700	16:00	17:00	M T W T F S S	0.31	12,800	41,290	G I S
Repeat 1700-1800	17:00	18:00	M T W T F S S	0.29	10,700	36,897	G I S
Repeat 18:00-19:00 MF	18:00	19:00	M T W T F S S	0.35	17,100	48,857	G I S
RODP 0700 - 0900 SS	07:00	09:00	M T W T F S S	0.02	2,300	1,15,000	G I S
RODP NPT WE 0900-1200	09:00	12:00	M T W T F S S	0.10	8,900	89,000	G I S
RODP NPT WE 1200-1500	12:00	15:00	M T W T F S S	0.16	10,000	62,500	G I S
RODP 15-18 SS	15:00	18:00	M T W T F S S	0.26	11,400	43,846	G I S
Repeat 1600-1700	16:00	17:00	M T W T F S S	0.27	12,800	47,407	G I S
Repeat 1700-1800	17:00	18:00	M T W T F S S	0.27	10,700	39,630	G I S
Repeat 18:00-19:00 MF	18:00	19:00	M T W T F S S	0.34	17,100	50,294	G I S
RODP 18-20 SS	18:00	20:00	M T W T F S S	0.48	20,000	41,667	G I S
IPML	20:00	21:30	M T W T F S S	2.50	3,00,000	1,20,000	G I S
Brahmarakshas - 2	21:00	22:00	M T W T F S S	0.63	57,000	90,476	G I S
RODP SS 22-24	22:00	00:00	M T W T F S S	0.21	14,300	68,095	G I S

Impact

Show	Start Time	End Time	DOW	Card Rate	Billing Rate	Valuation Rate	Alloc Sec	Amount	CPRP	Planning CPRP	Impact
Repeat 18:00-19:00 MF	18:00	19:00	M T W T F S S	17,100				1,60,000	44,444	0
Total					16,000	16,000	100	1,60,000	44,444	0

Secondary Items

Show	Start Time	End Time	DOW	Unit	Valuation Rate	Billing Rate	Amount	Base Duration	Secondary items
Kumkum Bhagya	21:00	21:30	M T W T F S S				1,00,000	1
				10			1,00,000

Comment

Date	Channel	Version	User	Comment	File Name	Role Name
02/20/2020	Zee Tv	2	Zameer Shah	Please change the rate of IPML to 1,98,400.		National Head
02/20/2020	Zee Tv	2	R1	Client deal uploaded to the system.	Proposal 24806 - Dealmemo.pdf	Sales Executive

Proposal Details

Proposal Details Proposal - 24806 Version - 2

TimeBand Mix

Grid

Sales Unit

Impact

Secondary Items

TimeBand Mix

Grid

Sales Unit

Impact

Secondary Items

Comment

Proposal

Zee TV

System Proposed

Outlay

Programme

Grid	Net Rate	Billing Rate	FCT	FCT %	Net Outlay	Net Outlay %	Billing Outlay	GRP	Planning GRP
Zee TV	19024	22022	12220	17%	23247750	86%	26911000	541	639
Zee Anmol	331	0	24440	33%	809500	3%	0	54	57
Zee TV HD	777	0	36660	50%	2847750	11%	0	104	102
Total			73320	100%	26905000	100%	26911000	699	798

			Current Deal					ER deviation
Parent Band	Band Name	Request (FCT/GRP) %	Final FCT%	Final GRP%	ER	FCT	CPRP / CPT	Reference Deal	Rate Card
	Wd Npt	56.00	82.12	55.12	7,160	2,940	23,866	0.00	-33.08
	Wd Pt	27.00	8.38	27.99	70,678	300	47,339	0.00	-29.27
	We Npt	5.00	7.26	4.39	7,240	260	26,814	0.00	-32.34
	We Pt	12.00	2.23	12.50	1,98,400	80	79,360	0.00	-33.87
			99	100	16,762	3,580	37,502	0	-31

Band Name	Request (FCT/GRP) %	Final FCT%	Final GRP%	ER	FCT	CPRP
Wd Npt	56.00	82.12	55.12	7,160	2,940	23,866
Wd Pt	27.00	8.38	27.99	70,678	300	47,339
We Npt	5.00	7.26	4.39	7,240	260	26,814
We Pt	12.00	2.23	12.50	1,98,400	80	79,360
		100	100	16,762	3,580	37,502

Channel Name	Location Name	Sequence Name	Employee Name	Actioned On	Remarks
Zee TV	ASIA	MIS	Zameer Mahesh Shah	27/01/2021 18:44:18.0	Approved on Mail
Zee TV	ASIA	Regional Head	RajKiran Santosh Singh	27/01/2021 18:45:03.0	Approved on Mail
Zee TV	ASIA	National Head	Pankaj Mehra	27/01/2021 18:47:12.0	Approved on Mail
Zee TV	ASIA	Cluster head	Vijay Sanil	27/01/2021 21:18:11.0	Approved on UI
Zee TV	ASIA	Pricing Team		28/01/2021 06:03:41.0	Approved on UI
Zee TV	ASIA	CCD ZEEL		28/01/2021 10:16:31.0	Approved on UI