NOTE: Throughout this lab, every time a screenshot is requested, use your computer's screenshot tool, and paste each screenshot to the same Word document. Label each screenshot in accordance to what is noted in the lab. This document with all of the screenshots included should be uploaded through Connect as a Word or PDF document when you have reached the final step of the lab.

In this lab, you will:

Required:

1. Create a calculated field for the Gross Margin.

2. Create a summary table that shows the gross margin per customer.

Ask the Question: Which customers are the most profitable?

Master the Data: Fruitopia sells exotic fruit from throughout the world to customers throughout the country by mail order. The company keeps a sales journal that records each sale and its related sales and cost details. This sales journal is for March 14, 2021. Use data file Lab 2-4 Data.xlsx, but open in Tableau.

Software needed

• Tableau
• Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4)

Data: Lab 2-4 Data.xlsx.

Perform the Analysis: Refer to Lab 2-4 in the text for instructions and steps for each of the lab parts.

Share the Story:

2 JIIGI CLIC SLUI y. Part 1: Upload Your Files Part 2: Assessment Part 2 of 2 Required: 1. Which customer number is the least profitable with $4.80 gross margin? 5 points O 2024 0 2051 Skipped 0 2031 O 2043 eBook 2. Which "pill" do you have on the Rows shelf? Print O Gross Margin O Count(Customer #) O Customer # O Sum(Gross Margin) References 3. Which "pill do you have on the Marks card? O Customer # O Sum(Gross Margin) O Count(Customer #) O Gross Margin Tableau Lab 2.4 G Saved 2 Required information Part 2 of 2 3. Which "pill" do you have on the Marks card? O Customer # 5 points Skipped O Sum(Gross Margin) O Count(Customer #) O Gross Margin 4. What is the gross margin of customer 2070? eBook O 6.6 Print O 11.6 O 44.9 References O 107.4 5. Swap Sum(Gross Margin) for Sum(Sales). What were the total sales for customer 2047? O 357.7 O 32.9 O 78.7 O 948.5 File Home Insert Draw Page Layout Formulas Data Review View PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you nee A2 fx 3021 J A B D E F G H | 1 Invoice # Customer # Zip Code Date of Sal SKU Description Quantity (Pound: Sales Cost 2 3021 2001 67510 3/1/2021 FRT-APL Apple 15 25.52 16.36 3 3021 2001 67510 3/1/2021 FRT-GOR Goji berry 5 5.92 3.71 4 3021 2001 67510 3/1/2021 FRT-OLV Olive 35 53.92 33.26 5 3021 2001 67510 3/1/2021 FRT-REN Redcurrant 5 7.12 4.26 6 3022 2091 67621 3/1/2021 FRT-FII Fig 35 84.37 54.26 7 3023 2021 67511 3/1/2021 FRT-JUR Juniper berr 50 65.02 43.01 8 3023 2021 67511 3/1/2021 FRT-PAY Papaya 35 37.12 22.06 9 3023 2021 67511 3/1/2021 FRT-BAN Banana 5 2.52 1.56 10 3023 2021 67511 3/1/2021 FRT-PEO Persimmon 35 69.67 43.06 11 3024 2079 66401 3/1/2021 FRT-SAM Satsuma 50 34.52 22.01 12 3024 2079 66401 3/1/2021 FRT-MII Miracle fruit 15 30.77 18.01 13 3024 2079 66401 3/1/2021 FRT-CHI Chico fruit 15 26.27 15.46 14 3024 2079 66401 3/1/2021 FRT-DUA Durian 25 54.27 33.01 15 3024 2079 66401 3/1/2021 FRT-BAN Banana 35 17.52 10.86 16 3025 2099 66710 3/1/2021 FRT-SAM Satsuma 30 20.72 13.21 17 3025 2099 66710 3/1/2021 FRT-ELR Elderberry 25 60.27 38.01 18 3025 2099 66710 3/1/2021 FRT-NAC Nance 5 5.92 3.61 19 3025 2099 66710 3/1/2021 FRT-BAN Banana 45 22.52 13.96 20 3025 2099 66710 3/1/2021 FRT-LEO Lemon 5 12.32 7.41 21 3025 2099 66710 3/1/2021 FRT-ORG Orange 50 37.52 24.51 22 3026 2088 67004 3/1/2021 FRT-CHY Cherimoya 45 78.77 49.96 23 3026 2088 67004 3/1/2021 FRT-ORG Orange 35 26.27 17.16 24 3026 2088 67004 3/1/2021 FRT-LOA Loquat 45 25.67 17.11 25 3026 2088 67004 3/1/2021 FRT-FII Fig 50 120.52 77.51 26 3026 2088 67004 3/1/2021 FRT- JAB Jabuticaba 50 44.52 26.01 27 3027 2087 67831 3/1/2021 FRT-MAR Marionberry 10 9.52 6.11 28 3028 2086 67416 3/1/2021 FRT-ORG Orange 15 11.27 7.36 29 2086 67416 3/1/2021 FRT-COU Coconut 45 108.47 69.31 30 3028 2086 67416 3/1/2021 FRT-LOA Loquat 5 2.87 1.91 31 3028 2086 67416 3/1/2021 FRT-BAN Banana 40 20.02 12.41 32 3028 2086 67416 3/1/2021 FRT-MII Miracle fruit 35 71.77 42.01 33 3028 2086 67416 3/1/2021 FRT-APO Apricot 25 70.02 44.01 34 3029 2053 66402 3/1/2021 FRT-BOR Boysenberry 15 15.02 9.31 35 3030 2063 67010 3/1/2021 FRT-APL Apple 45 76.52 49.06 36 3030 2063 67010 3/1/2021 FRT-BIT Bilberty 40 80.02 46.81 37 3030 2063 67010 3/1/2021 FRT-DRI Dragonfruit 5 8.17 4.91 38 3031 2041 66404 3/1/2021 FRT-LYE Lychee 40 80.42 50.01 39 3031 2041 66404 3/1/2021 FRT-PUE Purple mang 40 40.42 23.61 40 2022 2069 67418 3/1/2021 ERT-TAN Tamarind 2012 82 27 61 Sheet1 3028 I O Type here to search T. File Home Insert Draw Page Layout Formulas Data Review Vie PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless yo A2 X fx 3021 G H 1 39 40 41 42 43 3031 3032 3032 3033 3033 3034 3035 3036 3037 3038 3039 44 45 46 47 48 49 50 3039 51 52 53 54 55 56 57 58 B C 2041 66404 2068 67418 2068 67418 2051 67332 2051 67332 2077 66749 2051 66713 2044 67516 2073 66406 2064 67012 2060 67518 2060 67518 2060 67518 2060 67518 2060 67518 2060 67518 2060 67518 2060 67518 2060 67518 2074 67422 2074 67422 2074 67422 2066 66408 2066 66408 2035 67423 2087 67731 2087 67731 2087 67731 2087 67731 2048 67018 2048 67018 2100 66226 2100 66226 2100 66226 2100 66226 2064 67732 2064 67732 2064 67732 2064 67732 2064 67722 Sheet1 3039 3039 3039 3039 3039 3039 3039 3040 3040 3040 3041 3041 3042 3043 3043 3043 3043 3044 3044 3045 3045 3045 3045 3046 3046 3046 3046 2046 D E F 3/1/2021 FRT-PUE Purple mang 3/1/2021 FRT-TAN Tamarind 3/1/2021 FRT-GRI GrapeRaisin 3/1/2021 FRT-PLT Plumcot (or 3/1/2021 FRT-SAR Salal berry 3/1/2021 FRT-BLR Blackberry 3/1/2021 FRT-CUE Cucumber 3/1/2021 FRT-CRR Cranberry 3/1/2021 FRT-GRI GrapeRaisin 3/1/2021 FRT-ORG Orange 3/2/2021 FRT-PLI Plantain 3/2/2021 FRT-DRI Dragonfruit 3/2/2021 FRT-CHR Cherry 3/2/2021 FRT-ORG Orange 3/2/2021 FRT-ORG Orange 3/2/2021 FRT-SUL Sugar apple 3/2/2021 FRT-UGI Ugli fruit 3/2/2021 FRT-ORG Orange 3/2/2021 FRT-PLT Plumcot (or 3/2/2021 FRT-SOS Solanum qu 3/2/2021 FRT-APL Apple 3/2/2021 FRT-JUR Juniper berr 3/2/2021 FRT-BAN Banana 3/2/2021 FRT-BLN Blackcurren 3/2/2021 FRT-AVD Avocado 3/2/2021 FRT-TAN Tamarind 3/2/2021 FRT-APL Apple 3/2/2021 FRT-KUA Kumquat 3/2/2021 FRT-CUE Cucumber 3/2/2021 FRT-GOR Goji berry 3/2/2021 FRT-CUN Currant 3/2/2021 FRT-JAB Jabuticaba 3/2/2021 FRT-PEA Pear 3/2/2021 FRT-BLR Blackberry 3/2/2021 FRT-RAR Raspberry 3/2/2021 FRT-POT Pomegranat 3/2/2021 FRT-LIM Lime 3/2/2021 FRT-PAY Papaya 3/2/2021 FRT-BLR Blackberry 272/2021 ERT-EE Esiina 40 40.42 20 43.82 40 50.02 20 42.02 35 39.22 40 80.02 50 91.02 45 45.47 45 56.27 50 37.52 5 10.32 20 32.62 25 62.52 15 11.27 10 7.52 40 40.42 15 16.82 25 18.77 50 105.02 20 18.82 15 25.52 50 65.02 50 25.02 30 60.02 30 30.02 50 109.52 50 85.02 15 10.67 50 91.02 45 53.12 30 52.52 5 4.47 50 91.52 5 10.02 10 11.42 15 9.77 10 9.62 5 5.32 25 50.02 un 7922 23.61 27.61 29.61 24.81 23.11 51.61 54.51 27.46 33.31 24.51 6.21 19.61 39.01 7.36 4.91 24.81 10.36 12.26 62.01 11.81 16.36 43.01 15.51 35.41 17.71 69.01 54.51 6.76 54.51 33.31 31.21 2.61 53.51 6.46 7.01 6.31 5.71 3.16 32.26 52 01 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 79 File Home Insert Draw Page Layout Formulas Data Review PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless A2 fic 3021 G H 1 77 78 79 3046 3046 3046 32.26 52.01 65.71 80 3046 3047 11.01 10.66 81 82 83 3048 3048 3048 3048 10.86 4.66 2.46 84 85 58.41 25 50.02 40 79.22 45 108.02 25 16.52 15 17.27 35 17.52 15 7.52 5 3.77 40 96.02 25 43.77 20 46.02 25 12.52 10 10.12 15 7.52 15 14.12 5 7.52 10 17.02 5 6.57 86 3048 3048 87 88 3049 3050 89 90 3050 26.01 30.41 7.76 5.91 4.66 8.41 4.66 10.91 3.86 21.36 91 3050 92 93 3050 3050 3050 3051 94 95 35 32.92 96 5.91 D E F 3/2/2021 FRT-BLR Blackberry 3/2/2021 FRT-FEO Feijoa 3/2/2021 FRT-SOO Soursop 3/2/2021 FRT-MUR Mulberry 3/2/2021 FRT-PEC Peach 3/2/2021 FRT-BAN Banana 3/2/2021 FRT-BAN Banana 3/2/2021 FRT-ORG Orange 3/2/2021 FRT-SOO Soursop 3/2/2021 FRT-CUN Currant 3/2/2021 FRT-RAA Rambutan 3/2/2021 FRT-BAN Banana 3/2/2021 FRT-PUE Purple mang 3/2/2021 FRT-BAN Banana 3/2/2021 FRT-GUV Guava 3/2/2021 FRT-YUZ Yuzu 3/2/2021 FRT-APL Apple 3/2/2021 FRT-PLM PlumPrune 3/2/2021 FRT-PAI Passionfruit 3/2/2021 FRT-SOS Solanum qu 3/2/2021 FRT-FEO Feijoa 3/2/2021 FRT-JAU Jambul 3/2/2021 FRT-CLR Cloudberry 3/2/2021 FRT-DAO Damson 3/2/2021 FRT-BLN Blackcurren 3/2/2021 FRT-PHI Physalis 3/2/2021 FRT-GUV Guava 3/2/2021 FRT-PIL Pineapple 3/2/2021 FRT-BAN Banana 3/2/2021 FRT-JUB Jujube 3/3/2021 FRT-JAI Jackfruit 3/3/2021 FRT-POL Pomelo 3/3/2021 FRT-CRR Cranberry 3/3/2021 FRT-NEN Nectarine 3/3/2021 FRT-POL Pomelo 3/3/2021 FRT-PEA Pear 3/3/2021 FRT-BAN Banana 3/3/2021 FRT-APL Apple 3/3/2021 FRT-CLR Cloudberry 3/3/2021 ERT-STR Strawberry B 2064 67732 2064 67732 2064 67732 2064 67732 2070 67522 2031 67626 2031 67626 2031 67626 2031 67626 2031 67626 2031 67626 2043 66840 2084 66936 2084 66936 2084 66936 2084 66936 2084 66936 2084 66936 2098 67023 2036 67333 2036 67333 2032 66414 2032 66414 2088 66842 2088 66842 2088 66842 2088 66842 2088 66842 2088 66842 2081 66014 2081 66014 2081 66014 2081 66014 2081 66014 2081 66014 2081 66014 2081 66014 2063 67335 2063 67335 2022 67825 Sheet1 3052 3052 3053 3053 97 10 35 45 98 99 45 100 25 45.51 50.86 49.06 33.51 11.81 44.81 22.41 16.11 10 40 101 102 103 104 40 35 105 40 9.42 69.32 87.77 78.77 51.02 20.02 72.82 37.62 26.97 20.02 59.62 9.47 23.72 45.47 73.52 82.97 54.92 22.52 17.02 70.02 12.41 38.01 106 40 15 3054 3054 3054 3054 3054 3054 3055 3055 3055 3055 3055 3055 3055 3055 3056 3056 2057 107 108 10 109 45 110 50 5.56 15.41 27.46 48.01 53.91 32.11 13.96 10.91 35 111 112 113 114 30 45 10 40 115 43.61 15.61 116 20 2402 File Home Insert Draw Page Layout Formulas Data Review PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless A2 fir 3021 G 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 3056 3057 3058 3058 3059 3059 3059 3059 3060 3061 3061 3061 3061 3061 3061 3061 3061 3062 3062 3063 3063 3063 3064 3064 3065 3065 3065 3065 3066 3067 3067 3067 3067 3067 3067 3068 3068 3068 3068 3069 B 2063 67335 2023 67835 2046 66416 2046 66416 2055 67432 2055 67432 2055 67432 2055 67432 2046 67026 2024 66937 2024 66937 2024 66937 2024 66937 2024 66937 2024 66937 2024 66937 2024 66937 2088 67631 2088 67631 2038 66725 2038 66725 2038 66725 2006 67031 2006 67031 2067 67837 2067 67837 2067 67837 2067 67837 2047 66939 2072 66736 2072 66736 2072 66736 2072 66736 2072 66736 2072 66736 2046 67035 2046 67035 2046 67035 2046 67035 2046 67025 Sheet1 D E F 3/3/2021 FRT-CLR Cloudberry 3/3/2021 FRT-STR Strawberry 3/3/2021 FRT-DUA Durian 3/3/2021 FRT-MUR Mulberry 3/3/2021 FRT-PEC Peach 3/3/2021 FRT-YUZ Yuzu 3/3/2021 FRT-ELR Elderberry 3/3/2021 FRT-CHI Chico fruit 3/3/2021 FRT-UGI Ugli fruit 3/3/2021 FRT-BAN Banana 3/3/2021 FRT-AVD Avocado 3/3/2021 FRT-CHY Cherimoya 3/3/2021 FRT-APL Apple 3/3/2021 FRT-GRI GrapeRaisin 3/3/2021 FRT-ORG Orange 3/3/2021 FRT-ORG Orange 3/3/2021 FRT-HUR Huckleberry 3/3/2021 FRT-SAR Salal berry 3/3/2021 FRT-PAI Passionfruit 3/3/2021 FRT-NEN Nectarine 3/3/2021 FRT-KUA Kumquat 3/3/2021 FRT-PEO Persimmon 3/3/2021 FRT-KII Kiwifruit 3/3/2021 FRT-SAA Salak 3/3/2021 FRT-TAL Tamarillo 3/3/2021 FRT-ORG Orange 3/3/2021 FRT-PHI Physalis 3/4/2021 FRT-DAO Damson 3/4/2021 FRT-PIL Pineapple 3/4/2021 FRT-APL Apple 3/4/2021 FRT-LYE Lychee 3/4/2021 FRT-JUB Jujube 3/4/2021 FRT-STI Star fruit 3/4/2021 FRT-MAG Mango 3/4/2021 FRT-PLI Plantain 3/4/2021 FRT-BLR Blackberry 3/4/2021 FRT-LIM Lime 3/4/2021 FRT-ORG Orange 3/4/2021 FRT-LEO Lemon 3/1/2021 ERT-COR Coi harry H 40 70.02 30 24.02 5 10.87 20 13.22 10 11.52 5 7.52 15 36.17 10 17.52 45 50.42 15 7.52 50 50.02 40 70.02 15 25.52 40 50.02 40 30.02 10 7.52 40 38.42 15 16.82 30 28.22 10 14.72 5 3.57 15 29.87 15 34.82 50 40.52 20 15.42 45 33.77 25 45.52 15 30.62 10 7.72 50 85.02 50 100.52 30 44.72 5 12.52 20 46.22 40 82.42 30 60.02 5 4.82 20 15.02 40 98.42 un 1722 1 43.61 15.61 6.61 8.81 7.11 4.66 22.81 10.31 31.06 4.66 29.51 44.41 16.36 29.61 19.61 4.91 25.21 9.91 18.31 9.61 2.26 18.46 20.56 25.01 10.21 22.06 28.01 20.11 4.61 54.51 62.51 28.51 7.86 29.41 49.61 38.71 2.86 9.81 59.21 29.61 File Home Insert Draw Page Layout Formulas Data Rev PROTECTED VIEW Be carefulfiles from the Internet can contain viruses, A2 fie 3021 G H 1 j J 2.86 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 A 3068 3068 3068 3068 3068 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3070 3070 3070 3070 3071 3071 3071 3072 3072 3072 3072 3072 3072 3072 3072 2046 67035 2046 67035 2046 67035 2046 67035 2046 67035 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2018 67342 2018 67342 2018 67342 2018 67342 2044 67042 2044 67042 2044 67042 2100 67344 2100 67344 2100 67344 2100 67344 2100 67344 2100 67344 2100 67344 2100 67344 D E F 3/4/2021 FRT-LIM Lime 3/4/2021 FRT-ORG Orange 3/4/2021 FRT-LEO Lemon 3/4/2021 FRT-GOR Goji berry 3/4/2021 FRT-LOA Loquat 3/4/2021 FRT-STR Strawberry 3/4/2021 FRT-BIT Bilberty 3/4/2021 FRT-MEC Melon 3/4/2021 FRT-QUC Quince 3/4/2021 FRT-RAR Raspberry 3/4/2021 FRT-HOR Honeyberr 3/4/2021 FRT-MAG Mango 3/4/2021 FRT-SUL Sugar app! 3/4/2021 FRT-APO Apricot 3/4/2021 FRT-BAN Banana 3/4/2021 FRT-DAT Date 3/4/2021 FRT-GRI GrapeRaisi 3/4/2021 FRT-MAR Marionbern 3/4/2021 FRT-ORG Orange 3/4/2021 FRT-DAT Date 3/4/2021 FRT-ORG Orange 3/4/2021 FRT-SAA Salak 3/4/2021 FRT-PLM Plum Prune 3/4/2021 FRT-RAA Rambutan 3/4/2021 FRT-APL Apple 3/4/2021 FRT-QUC Quince 3/4/2021 FRT-MEC Melon 3/4/2021 FRT-ORG Orange 3/4/2021 FRT-REN Redcurrant 3/4/2021 FRT-STI Star fruit 3/4/2021 FRT-COU Coconut 3/4/2021 FRT-HOR Honeyberr 3/4/2021 FRT-GOR Goji berry 3/4/2021 FRT-LOA Loquat 3/4/2021 FRT-NAC Nance 3/4/2021 FRT-KII Kiwifruit 3/4/2021 FRT-JAI Jackfruit 3/4/2021 FRT-OLV Olive 3/4/2021 FRT-JAU Jambul 3/4/2021 FRT-BOR Boysenber 3/4/2021 FRT-TAL Tamarillo 3/4/2021 FRT-HUR Hucklebern 3/4/2021 FRT-POT Pomegran 3/4/2021 FRT-CHR Cherry 5 5 4.82 20 15.02 40 98.42 40 47.22 5 2.87 35 28.02 50 100 10 19.42 45 46.37 40 45.62 40 37.62 35 80.87 25 25.27 50 140 40 20.02 5 5 4.17 50 62.52 35 33.27 20 15.02 15 12.47 40 30.02 35 28.37 10 13.12 20 46.02 20 34.02 5 5.17 30 58.22 45 33.77 15 21.32 30 75.02 35 84.37 40 37.62 10 11.82 5 2.87 40 47.22 20 46.42 20 12.62 10 15.42 40 78.02 50 50.02 35 26.97 5 4.82 40 26.02 5 12.52 9.81 59.21 29.61 1.91 18.21 58.51 12.01 28.36 28.01 23.61 51.46 15.51 88.01 12.41 2.71 37.01 21.36 9.81 8.11 19.61 17.51 7.71 30.41 21.81 3.16 36.01 22.06 12.76 47.11 53.91 23.61 7.41 1.91 28.81 27.41 7.41 9.51 45.21 31.01 17.86 3.16 16.81 7.81 Sheet1 2 JIIGI CLIC SLUI y. Part 1: Upload Your Files Part 2: Assessment Part 2 of 2 Required: 1. Which customer number is the least profitable with $4.80 gross margin? 5 points O 2024 0 2051 Skipped 0 2031 O 2043 eBook 2. Which "pill" do you have on the Rows shelf? Print O Gross Margin O Count(Customer #) O Customer # O Sum(Gross Margin) References 3. Which "pill do you have on the Marks card? O Customer # O Sum(Gross Margin) O Count(Customer #) O Gross Margin Tableau Lab 2.4 G Saved 2 Required information Part 2 of 2 3. Which "pill" do you have on the Marks card? O Customer # 5 points Skipped O Sum(Gross Margin) O Count(Customer #) O Gross Margin 4. What is the gross margin of customer 2070? eBook O 6.6 Print O 11.6 O 44.9 References O 107.4 5. Swap Sum(Gross Margin) for Sum(Sales). What were the total sales for customer 2047? O 357.7 O 32.9 O 78.7 O 948.5 File Home Insert Draw Page Layout Formulas Data Review View PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless you nee A2 fx 3021 J A B D E F G H | 1 Invoice # Customer # Zip Code Date of Sal SKU Description Quantity (Pound: Sales Cost 2 3021 2001 67510 3/1/2021 FRT-APL Apple 15 25.52 16.36 3 3021 2001 67510 3/1/2021 FRT-GOR Goji berry 5 5.92 3.71 4 3021 2001 67510 3/1/2021 FRT-OLV Olive 35 53.92 33.26 5 3021 2001 67510 3/1/2021 FRT-REN Redcurrant 5 7.12 4.26 6 3022 2091 67621 3/1/2021 FRT-FII Fig 35 84.37 54.26 7 3023 2021 67511 3/1/2021 FRT-JUR Juniper berr 50 65.02 43.01 8 3023 2021 67511 3/1/2021 FRT-PAY Papaya 35 37.12 22.06 9 3023 2021 67511 3/1/2021 FRT-BAN Banana 5 2.52 1.56 10 3023 2021 67511 3/1/2021 FRT-PEO Persimmon 35 69.67 43.06 11 3024 2079 66401 3/1/2021 FRT-SAM Satsuma 50 34.52 22.01 12 3024 2079 66401 3/1/2021 FRT-MII Miracle fruit 15 30.77 18.01 13 3024 2079 66401 3/1/2021 FRT-CHI Chico fruit 15 26.27 15.46 14 3024 2079 66401 3/1/2021 FRT-DUA Durian 25 54.27 33.01 15 3024 2079 66401 3/1/2021 FRT-BAN Banana 35 17.52 10.86 16 3025 2099 66710 3/1/2021 FRT-SAM Satsuma 30 20.72 13.21 17 3025 2099 66710 3/1/2021 FRT-ELR Elderberry 25 60.27 38.01 18 3025 2099 66710 3/1/2021 FRT-NAC Nance 5 5.92 3.61 19 3025 2099 66710 3/1/2021 FRT-BAN Banana 45 22.52 13.96 20 3025 2099 66710 3/1/2021 FRT-LEO Lemon 5 12.32 7.41 21 3025 2099 66710 3/1/2021 FRT-ORG Orange 50 37.52 24.51 22 3026 2088 67004 3/1/2021 FRT-CHY Cherimoya 45 78.77 49.96 23 3026 2088 67004 3/1/2021 FRT-ORG Orange 35 26.27 17.16 24 3026 2088 67004 3/1/2021 FRT-LOA Loquat 45 25.67 17.11 25 3026 2088 67004 3/1/2021 FRT-FII Fig 50 120.52 77.51 26 3026 2088 67004 3/1/2021 FRT- JAB Jabuticaba 50 44.52 26.01 27 3027 2087 67831 3/1/2021 FRT-MAR Marionberry 10 9.52 6.11 28 3028 2086 67416 3/1/2021 FRT-ORG Orange 15 11.27 7.36 29 2086 67416 3/1/2021 FRT-COU Coconut 45 108.47 69.31 30 3028 2086 67416 3/1/2021 FRT-LOA Loquat 5 2.87 1.91 31 3028 2086 67416 3/1/2021 FRT-BAN Banana 40 20.02 12.41 32 3028 2086 67416 3/1/2021 FRT-MII Miracle fruit 35 71.77 42.01 33 3028 2086 67416 3/1/2021 FRT-APO Apricot 25 70.02 44.01 34 3029 2053 66402 3/1/2021 FRT-BOR Boysenberry 15 15.02 9.31 35 3030 2063 67010 3/1/2021 FRT-APL Apple 45 76.52 49.06 36 3030 2063 67010 3/1/2021 FRT-BIT Bilberty 40 80.02 46.81 37 3030 2063 67010 3/1/2021 FRT-DRI Dragonfruit 5 8.17 4.91 38 3031 2041 66404 3/1/2021 FRT-LYE Lychee 40 80.42 50.01 39 3031 2041 66404 3/1/2021 FRT-PUE Purple mang 40 40.42 23.61 40 2022 2069 67418 3/1/2021 ERT-TAN Tamarind 2012 82 27 61 Sheet1 3028 I O Type here to search T. File Home Insert Draw Page Layout Formulas Data Review Vie PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless yo A2 X fx 3021 G H 1 39 40 41 42 43 3031 3032 3032 3033 3033 3034 3035 3036 3037 3038 3039 44 45 46 47 48 49 50 3039 51 52 53 54 55 56 57 58 B C 2041 66404 2068 67418 2068 67418 2051 67332 2051 67332 2077 66749 2051 66713 2044 67516 2073 66406 2064 67012 2060 67518 2060 67518 2060 67518 2060 67518 2060 67518 2060 67518 2060 67518 2060 67518 2060 67518 2074 67422 2074 67422 2074 67422 2066 66408 2066 66408 2035 67423 2087 67731 2087 67731 2087 67731 2087 67731 2048 67018 2048 67018 2100 66226 2100 66226 2100 66226 2100 66226 2064 67732 2064 67732 2064 67732 2064 67732 2064 67722 Sheet1 3039 3039 3039 3039 3039 3039 3039 3040 3040 3040 3041 3041 3042 3043 3043 3043 3043 3044 3044 3045 3045 3045 3045 3046 3046 3046 3046 2046 D E F 3/1/2021 FRT-PUE Purple mang 3/1/2021 FRT-TAN Tamarind 3/1/2021 FRT-GRI GrapeRaisin 3/1/2021 FRT-PLT Plumcot (or 3/1/2021 FRT-SAR Salal berry 3/1/2021 FRT-BLR Blackberry 3/1/2021 FRT-CUE Cucumber 3/1/2021 FRT-CRR Cranberry 3/1/2021 FRT-GRI GrapeRaisin 3/1/2021 FRT-ORG Orange 3/2/2021 FRT-PLI Plantain 3/2/2021 FRT-DRI Dragonfruit 3/2/2021 FRT-CHR Cherry 3/2/2021 FRT-ORG Orange 3/2/2021 FRT-ORG Orange 3/2/2021 FRT-SUL Sugar apple 3/2/2021 FRT-UGI Ugli fruit 3/2/2021 FRT-ORG Orange 3/2/2021 FRT-PLT Plumcot (or 3/2/2021 FRT-SOS Solanum qu 3/2/2021 FRT-APL Apple 3/2/2021 FRT-JUR Juniper berr 3/2/2021 FRT-BAN Banana 3/2/2021 FRT-BLN Blackcurren 3/2/2021 FRT-AVD Avocado 3/2/2021 FRT-TAN Tamarind 3/2/2021 FRT-APL Apple 3/2/2021 FRT-KUA Kumquat 3/2/2021 FRT-CUE Cucumber 3/2/2021 FRT-GOR Goji berry 3/2/2021 FRT-CUN Currant 3/2/2021 FRT-JAB Jabuticaba 3/2/2021 FRT-PEA Pear 3/2/2021 FRT-BLR Blackberry 3/2/2021 FRT-RAR Raspberry 3/2/2021 FRT-POT Pomegranat 3/2/2021 FRT-LIM Lime 3/2/2021 FRT-PAY Papaya 3/2/2021 FRT-BLR Blackberry 272/2021 ERT-EE Esiina 40 40.42 20 43.82 40 50.02 20 42.02 35 39.22 40 80.02 50 91.02 45 45.47 45 56.27 50 37.52 5 10.32 20 32.62 25 62.52 15 11.27 10 7.52 40 40.42 15 16.82 25 18.77 50 105.02 20 18.82 15 25.52 50 65.02 50 25.02 30 60.02 30 30.02 50 109.52 50 85.02 15 10.67 50 91.02 45 53.12 30 52.52 5 4.47 50 91.52 5 10.02 10 11.42 15 9.77 10 9.62 5 5.32 25 50.02 un 7922 23.61 27.61 29.61 24.81 23.11 51.61 54.51 27.46 33.31 24.51 6.21 19.61 39.01 7.36 4.91 24.81 10.36 12.26 62.01 11.81 16.36 43.01 15.51 35.41 17.71 69.01 54.51 6.76 54.51 33.31 31.21 2.61 53.51 6.46 7.01 6.31 5.71 3.16 32.26 52 01 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 79 File Home Insert Draw Page Layout Formulas Data Review PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless A2 fic 3021 G H 1 77 78 79 3046 3046 3046 32.26 52.01 65.71 80 3046 3047 11.01 10.66 81 82 83 3048 3048 3048 3048 10.86 4.66 2.46 84 85 58.41 25 50.02 40 79.22 45 108.02 25 16.52 15 17.27 35 17.52 15 7.52 5 3.77 40 96.02 25 43.77 20 46.02 25 12.52 10 10.12 15 7.52 15 14.12 5 7.52 10 17.02 5 6.57 86 3048 3048 87 88 3049 3050 89 90 3050 26.01 30.41 7.76 5.91 4.66 8.41 4.66 10.91 3.86 21.36 91 3050 92 93 3050 3050 3050 3051 94 95 35 32.92 96 5.91 D E F 3/2/2021 FRT-BLR Blackberry 3/2/2021 FRT-FEO Feijoa 3/2/2021 FRT-SOO Soursop 3/2/2021 FRT-MUR Mulberry 3/2/2021 FRT-PEC Peach 3/2/2021 FRT-BAN Banana 3/2/2021 FRT-BAN Banana 3/2/2021 FRT-ORG Orange 3/2/2021 FRT-SOO Soursop 3/2/2021 FRT-CUN Currant 3/2/2021 FRT-RAA Rambutan 3/2/2021 FRT-BAN Banana 3/2/2021 FRT-PUE Purple mang 3/2/2021 FRT-BAN Banana 3/2/2021 FRT-GUV Guava 3/2/2021 FRT-YUZ Yuzu 3/2/2021 FRT-APL Apple 3/2/2021 FRT-PLM PlumPrune 3/2/2021 FRT-PAI Passionfruit 3/2/2021 FRT-SOS Solanum qu 3/2/2021 FRT-FEO Feijoa 3/2/2021 FRT-JAU Jambul 3/2/2021 FRT-CLR Cloudberry 3/2/2021 FRT-DAO Damson 3/2/2021 FRT-BLN Blackcurren 3/2/2021 FRT-PHI Physalis 3/2/2021 FRT-GUV Guava 3/2/2021 FRT-PIL Pineapple 3/2/2021 FRT-BAN Banana 3/2/2021 FRT-JUB Jujube 3/3/2021 FRT-JAI Jackfruit 3/3/2021 FRT-POL Pomelo 3/3/2021 FRT-CRR Cranberry 3/3/2021 FRT-NEN Nectarine 3/3/2021 FRT-POL Pomelo 3/3/2021 FRT-PEA Pear 3/3/2021 FRT-BAN Banana 3/3/2021 FRT-APL Apple 3/3/2021 FRT-CLR Cloudberry 3/3/2021 ERT-STR Strawberry B 2064 67732 2064 67732 2064 67732 2064 67732 2070 67522 2031 67626 2031 67626 2031 67626 2031 67626 2031 67626 2031 67626 2043 66840 2084 66936 2084 66936 2084 66936 2084 66936 2084 66936 2084 66936 2098 67023 2036 67333 2036 67333 2032 66414 2032 66414 2088 66842 2088 66842 2088 66842 2088 66842 2088 66842 2088 66842 2081 66014 2081 66014 2081 66014 2081 66014 2081 66014 2081 66014 2081 66014 2081 66014 2063 67335 2063 67335 2022 67825 Sheet1 3052 3052 3053 3053 97 10 35 45 98 99 45 100 25 45.51 50.86 49.06 33.51 11.81 44.81 22.41 16.11 10 40 101 102 103 104 40 35 105 40 9.42 69.32 87.77 78.77 51.02 20.02 72.82 37.62 26.97 20.02 59.62 9.47 23.72 45.47 73.52 82.97 54.92 22.52 17.02 70.02 12.41 38.01 106 40 15 3054 3054 3054 3054 3054 3054 3055 3055 3055 3055 3055 3055 3055 3055 3056 3056 2057 107 108 10 109 45 110 50 5.56 15.41 27.46 48.01 53.91 32.11 13.96 10.91 35 111 112 113 114 30 45 10 40 115 43.61 15.61 116 20 2402 File Home Insert Draw Page Layout Formulas Data Review PROTECTED VIEW Be carefulfiles from the Internet can contain viruses. Unless A2 fir 3021 G 115 116 117 118 119 120 121 122 123 124 125 126 127 128 129 130 131 132 133 134 135 136 137 138 139 140 141 142 143 144 145 146 147 148 149 150 151 152 153 154 3056 3057 3058 3058 3059 3059 3059 3059 3060 3061 3061 3061 3061 3061 3061 3061 3061 3062 3062 3063 3063 3063 3064 3064 3065 3065 3065 3065 3066 3067 3067 3067 3067 3067 3067 3068 3068 3068 3068 3069 B 2063 67335 2023 67835 2046 66416 2046 66416 2055 67432 2055 67432 2055 67432 2055 67432 2046 67026 2024 66937 2024 66937 2024 66937 2024 66937 2024 66937 2024 66937 2024 66937 2024 66937 2088 67631 2088 67631 2038 66725 2038 66725 2038 66725 2006 67031 2006 67031 2067 67837 2067 67837 2067 67837 2067 67837 2047 66939 2072 66736 2072 66736 2072 66736 2072 66736 2072 66736 2072 66736 2046 67035 2046 67035 2046 67035 2046 67035 2046 67025 Sheet1 D E F 3/3/2021 FRT-CLR Cloudberry 3/3/2021 FRT-STR Strawberry 3/3/2021 FRT-DUA Durian 3/3/2021 FRT-MUR Mulberry 3/3/2021 FRT-PEC Peach 3/3/2021 FRT-YUZ Yuzu 3/3/2021 FRT-ELR Elderberry 3/3/2021 FRT-CHI Chico fruit 3/3/2021 FRT-UGI Ugli fruit 3/3/2021 FRT-BAN Banana 3/3/2021 FRT-AVD Avocado 3/3/2021 FRT-CHY Cherimoya 3/3/2021 FRT-APL Apple 3/3/2021 FRT-GRI GrapeRaisin 3/3/2021 FRT-ORG Orange 3/3/2021 FRT-ORG Orange 3/3/2021 FRT-HUR Huckleberry 3/3/2021 FRT-SAR Salal berry 3/3/2021 FRT-PAI Passionfruit 3/3/2021 FRT-NEN Nectarine 3/3/2021 FRT-KUA Kumquat 3/3/2021 FRT-PEO Persimmon 3/3/2021 FRT-KII Kiwifruit 3/3/2021 FRT-SAA Salak 3/3/2021 FRT-TAL Tamarillo 3/3/2021 FRT-ORG Orange 3/3/2021 FRT-PHI Physalis 3/4/2021 FRT-DAO Damson 3/4/2021 FRT-PIL Pineapple 3/4/2021 FRT-APL Apple 3/4/2021 FRT-LYE Lychee 3/4/2021 FRT-JUB Jujube 3/4/2021 FRT-STI Star fruit 3/4/2021 FRT-MAG Mango 3/4/2021 FRT-PLI Plantain 3/4/2021 FRT-BLR Blackberry 3/4/2021 FRT-LIM Lime 3/4/2021 FRT-ORG Orange 3/4/2021 FRT-LEO Lemon 3/1/2021 ERT-COR Coi harry H 40 70.02 30 24.02 5 10.87 20 13.22 10 11.52 5 7.52 15 36.17 10 17.52 45 50.42 15 7.52 50 50.02 40 70.02 15 25.52 40 50.02 40 30.02 10 7.52 40 38.42 15 16.82 30 28.22 10 14.72 5 3.57 15 29.87 15 34.82 50 40.52 20 15.42 45 33.77 25 45.52 15 30.62 10 7.72 50 85.02 50 100.52 30 44.72 5 12.52 20 46.22 40 82.42 30 60.02 5 4.82 20 15.02 40 98.42 un 1722 1 43.61 15.61 6.61 8.81 7.11 4.66 22.81 10.31 31.06 4.66 29.51 44.41 16.36 29.61 19.61 4.91 25.21 9.91 18.31 9.61 2.26 18.46 20.56 25.01 10.21 22.06 28.01 20.11 4.61 54.51 62.51 28.51 7.86 29.41 49.61 38.71 2.86 9.81 59.21 29.61 File Home Insert Draw Page Layout Formulas Data Rev PROTECTED VIEW Be carefulfiles from the Internet can contain viruses, A2 fie 3021 G H 1 j J 2.86 151 152 153 154 155 156 157 158 159 160 161 162 163 164 165 166 167 168 169 170 171 172 173 174 175 176 177 178 179 180 181 182 183 184 185 186 187 188 189 190 191 192 193 194 A 3068 3068 3068 3068 3068 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3069 3070 3070 3070 3070 3071 3071 3071 3072 3072 3072 3072 3072 3072 3072 3072 2046 67035 2046 67035 2046 67035 2046 67035 2046 67035 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 2018 67342 2018 67342 2018 67342 2018 67342 2044 67042 2044 67042 2044 67042 2100 67344 2100 67344 2100 67344 2100 67344 2100 67344 2100 67344 2100 67344 2100 67344 D E F 3/4/2021 FRT-LIM Lime 3/4/2021 FRT-ORG Orange 3/4/2021 FRT-LEO Lemon 3/4/2021 FRT-GOR Goji berry 3/4/2021 FRT-LOA Loquat 3/4/2021 FRT-STR Strawberry 3/4/2021 FRT-BIT Bilberty 3/4/2021 FRT-MEC Melon 3/4/2021 FRT-QUC Quince 3/4/2021 FRT-RAR Raspberry 3/4/2021 FRT-HOR Honeyberr 3/4/2021 FRT-MAG Mango 3/4/2021 FRT-SUL Sugar app! 3/4/2021 FRT-APO Apricot 3/4/2021 FRT-BAN Banana 3/4/2021 FRT-DAT Date 3/4/2021 FRT-GRI GrapeRaisi 3/4/2021 FRT-MAR Marionbern 3/4/2021 FRT-ORG Orange 3/4/2021 FRT-DAT Date 3/4/2021 FRT-ORG Orange 3/4/2021 FRT-SAA Salak 3/4/2021 FRT-PLM Plum Prune 3/4/2021 FRT-RAA Rambutan 3/4/2021 FRT-APL Apple 3/4/2021 FRT-QUC Quince 3/4/2021 FRT-MEC Melon 3/4/2021 FRT-ORG Orange 3/4/2021 FRT-REN Redcurrant 3/4/2021 FRT-STI Star fruit 3/4/2021 FRT-COU Coconut 3/4/2021 FRT-HOR Honeyberr 3/4/2021 FRT-GOR Goji berry 3/4/2021 FRT-LOA Loquat 3/4/2021 FRT-NAC Nance 3/4/2021 FRT-KII Kiwifruit 3/4/2021 FRT-JAI Jackfruit 3/4/2021 FRT-OLV Olive 3/4/2021 FRT-JAU Jambul 3/4/2021 FRT-BOR Boysenber 3/4/2021 FRT-TAL Tamarillo 3/4/2021 FRT-HUR Hucklebern 3/4/2021 FRT-POT Pomegran 3/4/2021 FRT-CHR Cherry 5 5 4.82 20 15.02 40 98.42 40 47.22 5 2.87 35 28.02 50 100 10 19.42 45 46.37 40 45.62 40 37.62 35 80.87 25 25.27 50 140 40 20.02 5 5 4.17 50 62.52 35 33.27 20 15.02 15 12.47 40 30.02 35 28.37 10 13.12 20 46.02 20 34.02 5 5.17 30 58.22 45 33.77 15 21.32 30 75.02 35 84.37 40 37.62 10 11.82 5 2.87 40 47.22 20 46.42 20 12.62 10 15.42 40 78.02 50 50.02 35 26.97 5 4.82 40 26.02 5 12.52 9.81 59.21 29.61 1.91 18.21 58.51 12.01 28.36 28.01 23.61 51.46 15.51 88.01 12.41 2.71 37.01 21.36 9.81 8.11 19.61 17.51 7.71 30.41 21.81 3.16 36.01 22.06 12.76 47.11 53.91 23.61 7.41 1.91 28.81 27.41 7.41 9.51 45.21 31.01 17.86 3.16 16.81 7.81 Sheet1