3. 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? Orchard Farms Juice (OFJ) Simply Organie Juice (SOJ) OFJ On SOJ On Promotion? (1 = yes and 0- no) Promotion? (1- yes Volume Promoting and 0- no) Volume Baseline Incremental TOTAL Volume Baseline Incremental TOTAL Volume 43 %Store %Store Period Volume Promoting Volume 53 10 62 6. 35 37 55 54 92 23 53.8 274 11 65 24 30 31 51 106 31 37 47 12 12 568 42 27X4 58 8. 31 25 63 75 35 Simply Organic Juice $8 Orchard Farms Juice $5 Revenue Per Vol Unit Prom Cost Per Prom Point (Per 1% of Store Promotion) $2 $4 Rev profit-1oss Please write down your answers The Effect of Orchard-Farm-Promotion on Orchard Farm, in terms of revenue: (4 points) 802 C656 The Effect of Orchard-Farm-Promotion on Simply Organic in terms of revenue: (4 points) 1458 R+INDIR The Total Effect of Simply-Organic-Promotion for these two brands, in terms of revenue: (8 points) The ROMI of Orchard-Farm-Promotion on Orchard-Farm: (6 points) OFJ, ON PROMO Avgor Revenve -Total vol. OF PROMO ONor X 990-108 (802 #5]-[ store promoloN opX 2] OF ON PROMO 3. 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? Orchard Farms Juice (OFJ) Simply Organie Juice (SOJ) OFJ On SOJ On Promotion? (1 = yes and 0- no) Promotion? (1- yes Volume Promoting and 0- no) Volume Baseline Incremental TOTAL Volume Baseline Incremental TOTAL Volume 43 %Store %Store Period Volume Promoting Volume 53 10 62 6. 35 37 55 54 92 23 53.8 274 11 65 24 30 31 51 106 31 37 47 12 12 568 42 27X4 58 8. 31 25 63 75 35 Simply Organic Juice $8 Orchard Farms Juice $5 Revenue Per Vol Unit Prom Cost Per Prom Point (Per 1% of Store Promotion) $2 $4 Rev profit-1oss Please write down your answers The Effect of Orchard-Farm-Promotion on Orchard Farm, in terms of revenue: (4 points) 802 C656 The Effect of Orchard-Farm-Promotion on Simply Organic in terms of revenue: (4 points) 1458 R+INDIR The Total Effect of Simply-Organic-Promotion for these two brands, in terms of revenue: (8 points) The ROMI of Orchard-Farm-Promotion on Orchard-Farm: (6 points) OFJ, ON PROMO Avgor Revenve -Total vol. OF PROMO ONor X 990-108 (802 #5]-[ store promoloN opX 2] OF ON PROMO