File Home Insert Page Layout Formulas Data Review View Help X Cut Calibri 11 AA ae Wrap Text General Paste [ Copy Format Painter BIU- CE E Merge & Center $ ~ % 9 68 Condi Format Clipboard Font Alignment Number A26 X V A B C D E F G H K 1 Lululemon offers pants, shorts, tops, and jackets for healthy lifestyle and athletic activities, such as yoga, running, and 2 training. They recently tested four different workout outfits in a direct mail campaign. There were two creative packages tested for each outfit. For example, two direct mail packages were tested for Product 1 - Package 1A and Package 1B. Based on the information provided below, calculate the % ROI for each of the eight test cells. Which Product/Package combo has the highest ROI NOTE: Do your calculations by using Excel formulas in the yellow area below. An example of an Excel formula is =K17*K18) 10 11 12 13 Test Cell: 1 2 3 4 5 6 7 8 14 Product 1 Product 2 Product 3 Product 4 15 Package 1A Package 1B Package 2A Package 2B Package 3A |Package 3B Package 4A Package 4B 16 A B D E F G H 17 Test Size 24,000 22,500 14,400 5,300 18,900 22,200 4,800 23,100 18 Response rates 1.11% 1.17% 2.78% 2.92% 3.52% 3.70% 3.87% 1.06% 19 Marketing cost per piece mailed $2.50 $2.80 $2.30 $2.6 $2.20 $2.50 $2.10 $2.40 20 Product profit per unit $320.00 $320.00 $154.00 $154.00 $307.00 $307.00 $150.00 $150.00 21 22 Total Product Profit 23 Total Marketing Cost 24 Profit after Marketing 25 ROI (%) 26