Retailer Target is considering running sales promotion for two juice brand, namely, Orchard Farms and Simply Organic. The store has collected the following sales promotion data. The cells marked with italic and bold font are the periods that were under promotion (you can also refer to the column, on promotion? 1 = yes, 0 = no). Can you help Target with its sales promotion analytics, so that it can decide which brand to promote?

Please fill the empty cells in the table.

Orchard Farms Juice (OFJ) Simply Organic Juice (SO) Period OFJ On SOJ On Baseline Incremental TOTAL %Store Promotion? Baseline Incremental TOTAL %Store Promotion? Volume Volume Volume Promoting (1 = yes Volume Volume Volume Promoting (1 = yes and 0 = no) and O = no) 1 52 10 63 6 o 35 8 41 8 o N 55 37 89 25 1 7 2 10 8 o 3 54 11 65 7 o 30 23 55 27 1 4 55 51 105 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 7 0 Orchard Farms Juice Simply Organic Juice Revenue Per Vol Unit $6 $8 Prom Cost Per Prom Point (Per 1% of Store Promotion) $3 $4 Please write down your answers for each box: The Effect of Orchard-Farm-Promotion on Orchard Farm, in terms of revenue: (10 points) The Effect of Orchard-Farm-Promotion on Simply Organic, in terms of revenue: (10 points) The Total Effect of Simply-Organic-Promotion, in terms of revenue: (15 points) The Total ROMI of Orchard-Farm Promotion is: (15 points) Orchard Farms Juice (OFJ) Simply Organic Juice (SO) Period OFJ On SOJ On Baseline Incremental TOTAL %Store Promotion? Baseline Incremental TOTAL %Store Promotion? Volume Volume Volume Promoting (1 = yes Volume Volume Volume Promoting (1 = yes and 0 = no) and O = no) 1 52 10 63 6 o 35 8 41 8 o N 55 37 89 25 1 7 2 10 8 o 3 54 11 65 7 o 30 23 55 27 1 4 55 51 105 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 7 0 Orchard Farms Juice Simply Organic Juice Revenue Per Vol Unit $6 $8 Prom Cost Per Prom Point (Per 1% of Store Promotion) $3 $4 Please write down your answers for each box: The Effect of Orchard-Farm-Promotion on Orchard Farm, in terms of revenue: (10 points) The Effect of Orchard-Farm-Promotion on Simply Organic, in terms of revenue: (10 points) The Total Effect of Simply-Organic-Promotion, in terms of revenue: (15 points) The Total ROMI of Orchard-Farm Promotion is: (15 points)