Homework on Sales Promotion (Individual) At Start Assignment Due Wednesday by 11:59pm Points 50 Submitting a text entry box or a file upload Attempts 0 Allowed Attempts 1 Available Sep 19 at 12am - Dec 11 at 11:59pm 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. Note that (1) there is no need to consider the variable cost in this case; (2) you can only submit your answer once. Please do not share your work with your classmates as the final grade is based on your relative standing in this class. Orchard Farms Juice (OFJ) Simply Organic Juice (SOJ) OFJ On Period Baseline Incremental TOTAL soJ On %Store Promotion? Baseline | Incremental | TOTAL Volume Volume Volume %Store Promotion? Promoting g (1 = yes and Volume Volume Volume Promoting |(1 = yes an 0 = no ) 0 = no) 52 10 63 6 0 35 8 41 8 55 37 89 20 2 15 00 0 54 11 65 30 23 52 24 1 55 51 100 31 1 31 6 37 7 0 46 12 58 8 0 31 25 56 27 1 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 $5 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 BOMI of Orchard-Farm Promotion is: (15 points) NOV 23 astv 59 O ... O4 55 51 100 31 1 31 6 37 7 0 5 46 58 8 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 $5 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)