Instructions

Retailer Target has collected the following sales promotion data on Orchard Farms Juice and Simply Organic Juice. The cells marked with italic and bold font are the period that was under promotion (you can also refer to the column, "on promotion? 1 = yes, 0 = no). Based on the following information, can you fill the empty cells in the table? The empty cells are in the third table.

Table 1:

	Orchard Farms Juice (OFJ)	Simply Organic Juice (SOJ)
Period	Baseline Volume	Incremental Volume	TOTAL Volume	%Store Promoting	OFJ On Promotion? (1 = yes and 0 = no)	Baseline Volume	Incremental Volume	TOTAL Volume	%Store Promoting	SOJ On Promotion? (1 = yes and 0 = no)
1	52	10	62	6	0	35	8	43	8	0
2	55	37	92	23	1	7	2	9	8	0
3	54	11	65	7	0	30	23	53	27	1
4	55	51	106	31	1	31	6	37	7	0
5	46	12	58	8	0	31	25	56	27	1
6	63	12	75	6	0	35	7	42		0

Table 2:

	Orchard Farms Juice	Simply Organic Juice
Revenue Per Vol Unit	$5	$8
Prom Cost Per Prom Point (Per 1% of Store Promotion)	$2	$4

Table 3:

	Please write down your answers
The Effect of Orchard-Farm-Promotion on Orchard Farm, in terms of revenue: (20 points)
The Effect of Orchard-Farm-Promotion on Simply Organic, in terms of revenue: (20 points)
The Total Effect of Simply-Organic-Promotion for these two brands, in terms of revenue: (30 points)
The Total ROMI of Orchard-Farm-Promotion: (30 points)