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 ll the empty cells in the table? The empty cells are in the third table. Table 1: Orchard Farms Juice (OFJ) Simply Organic Juice (SOJ) OFJ On SOJ On Promotion? Promotion? Baseline Incremental %Store (1 = yes Baseline Incremental TOTAL %Store ('I = yes Volume Volume Promoting and O = no) Volume Volume Volume Promoting and 0 = no) 52 10 6 0 35 8 43 8 O 55 37 23 i 7 2 9 8 0 54 l l 7 30 23 53 27 i 55 51 31 6 37 7 O 46 l2 3! 25 56 27 i 7 42 7 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)