how to find projected sales for 10%clothes just for children 1 or more. Provide steps Calibri (Body)

how to find projected sales for 10%clothes just for children 1 or more. Provide steps 

 

 

Transcribed Image Text:

Calibri (Body) BI U AutoSave OFF Home Insert Draw Page Layout G Paste Dve ... Formulas A V Data Review View Automate GroupProjectDatabase 2022.xlsx Tell me - Read-Only V 12 v A General V $ % 9000 V .00 Conditional Format Cell Formatting as Table Styles Q19 fx A B C D E F G J K L M N 0 P Q R S 1 Customer # Children Household li Number of V Mobile Use Region. SALES W/O PROM SALES W/ PI PROJECTED SALES FOR 10% CLOTHES 2 1 0 2 71 1 6 22.95 B 2 0 4 46 0 8 4 3 2 2 73 0 5 38 5 4 2 2 97 0 5 31.6 5 5 0 2 72 0 1 57.9 7 6 1 3 68 0 8 37.5 B 7 0 4 82 0 4 49.7 9 8 1 3 15 0 8 43.7 L0 9 3 4 34 1 5 1 10 1 2 18 0 8 2 11 2 1 99 1 5 3 12 3 4 60 0 1 4 13 2 3 70 1 3 66.7 5 14 3 1 92 1 4 146.9 6 15 3 2 52 1 5 70.7 7 16 1 2 75 0 7 60.1 8 17 0 3 41 0 5 9 18 0 4 45 0 2 89.8 20 19 3 1 24 1 8 97.2 1 20 2 3 61 1 4 123 22 21 0 1 36 0 8 20.3 50.4 23 22 2 3 100 1 8 146.9 24 23 1 2 18 1 7 48.5 25 24 0 3 9 1 7 26 25 1 1 54 0 2 27 26 3 2 23 0 8 22.6 28 27 1 3 57 1 2 27.7 9 28 0 3 36 0 2 #0 29 0 4 34 1 6 1 30 0 1 48 1 4 26.3 2 31 2 4 40 0 6 127.9 3 32 2 4 44 1 6 33.1 4 33 2 1 91 1 2 58.15 5 34 2 4 82 1 4 6 35 1 1 90 0 8 =7 36 1 1 47 1 6 119.2 48 37 0 2 77 1 2 37.3 9 38 2 4 16 0 8 70.5 0 39 0 2 26 1 5 1 40 2 4 14 1 3 152.4 2 41 2 1 46 1 8 39.5 3 42 0 3 32 1 1 4 43 0 2 84 1 6 5 44 0 4 21 0 6 66.85 13.6 6 45 3 2 75 1 5 7 46 3 3 77 1 3 41.4 8 47 0 4 29 0 7 23.7 25.1 9 48 3 2 1 1 90.8 50 49 1 3 19 1 5 10.6 51 50 3 1 62 0 8 16.7 52 51 0 2 29 0 1 55.66666667 3 52 0 3 48 1 8 52.26666667 4 53 2 4 45 1 6 55 54 3 2 38 0 6 88.8 56 55 1 1 80 1 6 28 57 56 58 57 59 58 50 59 51 60 2 61 3 62 0223003 1 39 1 7 85.9 4 17 1 8 84.8 4 23 0 3 45.2 2 81 0 5 55.6 36.2 3 53 1 5 1 45 1 8 2 75 0 6 49.4 Insert Delete Format v NUMBER OF CHILDREN Average of SALES W/ PROMO 1 79.36564885 2 78.32314815 3 82.04126984 Grand Total 79.98082192 NUMBER OF CHILDREN Average of SALES W/ PROMO 1 79.36564885 2 78.32314815 3 82.04126984 Grand Total 79.98082192 WE V v Sort & Find & Filter Select U V W X Calibri (Body) BI U AutoSave OFF Home Insert Draw Page Layout G Paste Dve ... Formulas A V Data Review View Automate GroupProjectDatabase 2022.xlsx Tell me - Read-Only V 12 v A General V $ % 9000 V .00 Conditional Format Cell Formatting as Table Styles Q19 fx A B C D E F G J K L M N 0 P Q R S 1 Customer # Children Household li Number of V Mobile Use Region. SALES W/O PROM SALES W/ PI PROJECTED SALES FOR 10% CLOTHES 2 1 0 2 71 1 6 22.95 B 2 0 4 46 0 8 4 3 2 2 73 0 5 38 5 4 2 2 97 0 5 31.6 5 5 0 2 72 0 1 57.9 7 6 1 3 68 0 8 37.5 B 7 0 4 82 0 4 49.7 9 8 1 3 15 0 8 43.7 L0 9 3 4 34 1 5 1 10 1 2 18 0 8 2 11 2 1 99 1 5 3 12 3 4 60 0 1 4 13 2 3 70 1 3 66.7 5 14 3 1 92 1 4 146.9 6 15 3 2 52 1 5 70.7 7 16 1 2 75 0 7 60.1 8 17 0 3 41 0 5 9 18 0 4 45 0 2 89.8 20 19 3 1 24 1 8 97.2 1 20 2 3 61 1 4 123 22 21 0 1 36 0 8 20.3 50.4 23 22 2 3 100 1 8 146.9 24 23 1 2 18 1 7 48.5 25 24 0 3 9 1 7 26 25 1 1 54 0 2 27 26 3 2 23 0 8 22.6 28 27 1 3 57 1 2 27.7 9 28 0 3 36 0 2 #0 29 0 4 34 1 6 1 30 0 1 48 1 4 26.3 2 31 2 4 40 0 6 127.9 3 32 2 4 44 1 6 33.1 4 33 2 1 91 1 2 58.15 5 34 2 4 82 1 4 6 35 1 1 90 0 8 =7 36 1 1 47 1 6 119.2 48 37 0 2 77 1 2 37.3 9 38 2 4 16 0 8 70.5 0 39 0 2 26 1 5 1 40 2 4 14 1 3 152.4 2 41 2 1 46 1 8 39.5 3 42 0 3 32 1 1 4 43 0 2 84 1 6 5 44 0 4 21 0 6 66.85 13.6 6 45 3 2 75 1 5 7 46 3 3 77 1 3 41.4 8 47 0 4 29 0 7 23.7 25.1 9 48 3 2 1 1 90.8 50 49 1 3 19 1 5 10.6 51 50 3 1 62 0 8 16.7 52 51 0 2 29 0 1 55.66666667 3 52 0 3 48 1 8 52.26666667 4 53 2 4 45 1 6 55 54 3 2 38 0 6 88.8 56 55 1 1 80 1 6 28 57 56 58 57 59 58 50 59 51 60 2 61 3 62 0223003 1 39 1 7 85.9 4 17 1 8 84.8 4 23 0 3 45.2 2 81 0 5 55.6 36.2 3 53 1 5 1 45 1 8 2 75 0 6 49.4 Insert Delete Format v NUMBER OF CHILDREN Average of SALES W/ PROMO 1 79.36564885 2 78.32314815 3 82.04126984 Grand Total 79.98082192 NUMBER OF CHILDREN Average of SALES W/ PROMO 1 79.36564885 2 78.32314815 3 82.04126984 Grand Total 79.98082192 WE V v Sort & Find & Filter Select U V W X