In this exercise you will be assuming the role of an Account Manager working within our Personal Care Appliances category during Amazon Black Friday. You act as a general manager responsible for managing Amazons relationship with your assigned vendor. Your focus is to maintain & improve positive customer experience and to optimize your brands business across buying, marketing, and inventory management in order to drive growth in revenue and profitability. Black Friday is one of the biggest sales weeks of the year for Amazon, it is a 5 day event that starts on Monday and culminates on Black Friday. It is an opportunity to offer Amazon customers door buster deals and drive incremental sales for our vendors. Instructions You need to create a selection of Black Friday promotions for your assigned vendor. You have been provided an Excel worksheet with product information that you should use to identify the promotions for Black Friday. You should be able to give an overview of your plan that includes a selection of the promotions you are planning. Please present your plan with the provided Excel sheet. You can add columns to the calculation if needed You have 30 minutes to work on the exercise, a further 15 minutes to present your plan/selection and another 15 minutes to answer any questions. Key Points to Consider Your promotions should deliver a total Revenue increase of 50% vs. last year. Last year the revenue was 1.2 million. All promotions must run at a minimum profit margin of 10%. All promotions are required to run at a minimum of 25% off the average price from the last 90 days. A promotion on a given product can only run once, and can run any time on Black Friday Week (Mon-Thurs) or Black Friday itself (Fri). For promotions running on Black Friday Week, you can expect daily sales to be 5 x equal to the average weekly sales of the promoted product. For promotions running on Black Friday, you can expect daily sales to be 10 x equal to the average weekly sales of the promoted product. Tips Remember your goal as an Account Manager is to drive growth in revenue & profitability and provide the best experience for Amazon customers. Consider what additional information you may require to help you better define your Black Friday plans. What processes would you simplify on Amazon to increase Customer Experience? Useful Metrics Revenue = Average Sales Price x Units % Profit = (Revenue - Cost) / Revenue Vendor Cost Price = The normal price that Amazon purchases the product from the vendor. Black Friday Cost Price = The discounted cost price offered by the vendor for Black Friday Promotions. Average Selling Price = The price that is displayed on the Amazon website that customers purchase at (including VAT).

sub-Coressory Deal Profit Margin() Eligible Y/N Black Friday Week Deals Revenue lone day) Black Friday Deals Revenue Average Product Name Black Friday Cost Average Selling Average Weekly Discounted Deal Product Code Sub-Category Customer Review Vendor Cost price Price Price last 90 Days Sales Units Price Rating Professional Hair Drye! H001 Hair Care 70.54 ADADI 786) GID Platinum Clean Version 5 4102 Ora care 3.6 64.08 39.50 55.99 900 Everyday Electric Toothbrush H002 Oral Care 2XCIDI 46. 1.750 I'rofessional Hair Straighners V2 Haircare 91.70 62.74 99.99 600 Family Clectric Toothbrush Pack H005 1,2010 Kirk Hectric Toothbrush Vi ID Tralar 24.50 22.80 27.99 50 Professional llair Straigher er V1 2007 Ilair Care 2.9 18.00 57./DE 7.50 l'latinum Clean Version / (Hurtoth) # Irakarr 4.4 79.09 46.71 89.99 40 Professional Curling Tones 1009 IlairCare 41.4 Drur Hair Dryer Haircare 159 89 131.65 199 99 250 Kids Clectric Toothbrush V2 4011 Oral Care 3.8 24./9 18.67 G D Deluxe Hair Straighten #112 Hart 3.1 211.85 149.79 24999 RO Styling Kit 10 Piece! 4013 Hal care 4.5 20.32 14.75 24.99 Styling Kits Fiece) 2014 Haircare 22.58 1798 20.99 250 Travel Hair Dryer 4015 HairCare 3.1 56.03 47.53 40 Everyday Electric Toothbrush + 4 extra heats 016 Oral Care 55.90 120 Travel Hair Straighteners 4717 Hal care 4.2 72.92 46.06 62.99 190 Basic Strughteners 1019 Hair Care 3.5 26.12 1010 Rasies Hair Dryer 4111 Hantar 11 14.89 10.24 26.99 800 Carrying Case 020 Hair Care 2.2 16.20 E 12AXI 17. Del Curling Tongs 121 Hair Care 3 67.63 46.20 74.99 100 Travel Clectric Toothbrush & Case N022 Oral Care 4.0 7231 163.81 7. 180 "One off cost price provided by the vendor to run promotions for Black Friday Definition RW: The Tenthousiam Vendor Cost Price The normal price Amazon pups to buy an Item from a manufacturer / vender per unit Black Friday Care The discounted price offered by the vendor for Black Friday actor - Profit The difference between the outcomed through selling and the amount sent through buying 3% of revenue Average Selina he price that is displayed on the Amazon website that customer pay to purchase a product linduding VAT) 1 Formula Ay Naletilini Nil I Revenue Cost / Revenue Protis- sub-Coressory Deal Profit Margin() Eligible Y/N Black Friday Week Deals Revenue lone day) Black Friday Deals Revenue Average Product Name Black Friday Cost Average Selling Average Weekly Discounted Deal Product Code Sub-Category Customer Review Vendor Cost price Price Price last 90 Days Sales Units Price Rating Professional Hair Drye! H001 Hair Care 70.54 ADADI 786) GID Platinum Clean Version 5 4102 Ora care 3.6 64.08 39.50 55.99 900 Everyday Electric Toothbrush H002 Oral Care 2XCIDI 46. 1.750 I'rofessional Hair Straighners V2 Haircare 91.70 62.74 99.99 600 Family Clectric Toothbrush Pack H005 1,2010 Kirk Hectric Toothbrush Vi ID Tralar 24.50 22.80 27.99 50 Professional llair Straigher er V1 2007 Ilair Care 2.9 18.00 57./DE 7.50 l'latinum Clean Version / (Hurtoth) # Irakarr 4.4 79.09 46.71 89.99 40 Professional Curling Tones 1009 IlairCare 41.4 Drur Hair Dryer Haircare 159 89 131.65 199 99 250 Kids Clectric Toothbrush V2 4011 Oral Care 3.8 24./9 18.67 G D Deluxe Hair Straighten #112 Hart 3.1 211.85 149.79 24999 RO Styling Kit 10 Piece! 4013 Hal care 4.5 20.32 14.75 24.99 Styling Kits Fiece) 2014 Haircare 22.58 1798 20.99 250 Travel Hair Dryer 4015 HairCare 3.1 56.03 47.53 40 Everyday Electric Toothbrush + 4 extra heats 016 Oral Care 55.90 120 Travel Hair Straighteners 4717 Hal care 4.2 72.92 46.06 62.99 190 Basic Strughteners 1019 Hair Care 3.5 26.12 1010 Rasies Hair Dryer 4111 Hantar 11 14.89 10.24 26.99 800 Carrying Case 020 Hair Care 2.2 16.20 E 12AXI 17. Del Curling Tongs 121 Hair Care 3 67.63 46.20 74.99 100 Travel Clectric Toothbrush & Case N022 Oral Care 4.0 7231 163.81 7. 180 "One off cost price provided by the vendor to run promotions for Black Friday Definition RW: The Tenthousiam Vendor Cost Price The normal price Amazon pups to buy an Item from a manufacturer / vender per unit Black Friday Care The discounted price offered by the vendor for Black Friday actor - Profit The difference between the outcomed through selling and the amount sent through buying 3% of revenue Average Selina he price that is displayed on the Amazon website that customer pay to purchase a product linduding VAT) 1 Formula Ay Naletilini Nil I Revenue Cost / Revenue Protis