I need assistance. I cant figure out how to put this formula into excel. The que

Question

I need assistance. I cant figure out how to put this formula into excel.

The questions is:In cell B13, enter a formula to calculate the percentage of all Current Year Purchases accounted for by High Value customers. (Hint: The calculation should divide the Total Sales (Current Year) for High Value Customers by the Total Sales (Current Year) for all customers.) Format the cell using the Percentage Number format with 0 decimal places.

The information is based off the information below:

                   Fit Kix Footwear Current Year: 2017 Customer Database Customer ID LastName FirstName First Order Tenure (Yrs) 2015 Purchases 2016 Purchases Growth ($) Growth (%) Current Year Purchases (YTD) Discount Y/N Discount Amount Customer Value Rating 101 Peters Kyle 2010 7 $150.55 $365.15 $          215 59% $345.25 Y 15% High 102 Porter Charles 2012 5 $76.99 $245.70 $          169 69% $75.00 N 0% Low 103 Che Jason 2016 1 $125.35 $95.10 $          (30) -32% $0.00 N 0% Low 104 Eaton Jackson 2015 2 $308.90 $225.40 $          (84) -37% $325.65 N 0% Low 105 Sullivan Blake 2014 3 $275.40 $150.00 $        (125) -84% $97.00 N 0% Low 125 Sun Sarah 2013 4 $100.50 $205.99 $          105 51% $301.25 N 0% Low 107 Martin Emily 2015 2 $55.45 $235.45 $          180 76% $410.64 N 0% Low 108 Poulin Grace 2010 7 $135.35 $256.15 $          121 47% $101.50 Y 15% High 109 Schaller Adam 2012 5 $0.00 $126.75 $           127 N/A $103.75 N 0% Low 110 Tan Daniella 2014 3 $750.45 $325.67 $        (425) -130% $275.69 Y 10% Low 111 Latham Gus 2009 8 $543.65 $187.00 $         (357) -191% $175.99 Y 15% Low 126 Valdez Ariel 2010 7 $360.75 $425.00 $            64 15% $229.50 Y 15% High 113 Rivera Sophia 2015 2 $123.50 $164.75 $             41 25% $120.00 N 0% Low 114 Smith Isabelle 2016 1 $0.00 $75.99 $             76 N/A $32.95 N 0% Low 115 Olsen Drew 2012 5 $147.65 $161.35 $             14 8% $200.60 N 0% Low 116 Lin Paul 2016 1 $0.00 $257.75 $          258 N/A $155.45 Y 10% Low 117 Maxwell Siobhan 2013 4 $245.55 $334.69 $            89 27% $231.45 Y 15% High 118 Chen Dina 2010 7 $497.98 $291.45 $        (207) -71% $279.50 Y 15% High 119 Gardner Dominick 2009 8 $1,245.01 $764.58 $       (480) -63% $303.59 Y 15% High 120 Jackson Kyle 2014 3 $377.50 $379.50 $               2 1% $281.50 Y 10% Low 121 Wafa Savannah 2013 4 $235.75 $469.65 $          234 50% $340.00 Y 15% High 122 Holtz Elizabeth 2011 6 $178.40 $88.45 $          (90) -102% $0.00 Y 15% Low 123 Ford Janice 2010 7 $657.40 $439.56 $        (218) -50% $142.50 Y 15% High 124 Moreira Claire 2014 3 $199.99 $401.45 $          201 50% $235.00 Y 10% Low

Explanation / Answer

Take it easy!

See who is your high value customer, whom you provided discount.

So total sales for high value customer would be addition of purchases of customers who got discounts.

Now you just need to totalize the current year purchase column ( for total sales for all customer)

Generate formula , (current cell value / total)×100

when you click on cell, you will get cell number , now put formula with function option and then make for complete column. Let do it , tell me if any doubt.

Related Questions

Navigate

• Browse (All)
• Browse I
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.