Question

1 Approved Answer

Posted on Jul 18, 2024

In this lab, you will Required: 1. Create a calculated field for the Gras Margin. 2. Create a summary table that shows the gross margin

image text in transcribed

In this lab, you will Required: 1. Create a calculated field for the Gras 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: Frutopia salis eos frut from throughout the work to customers throughout the country by mail order. The company was a sales journal that records each sale and its related sales and cost details. This sales journal is for March 1-4,2021. Use data fie Lab 2-4 Baixkx, but apart in Telmu. Software needed Tableau Screen capture tool (Windows: Snipping Toot Mac: CmdShift+4) Duta Lab 2.4 Dasar Perform the Analysis: Refer to Lab 2.4 in the text for instructions and steps for each of the lab parts Share the Story: Required: 1. Which customer number is the last profitable with $4.80 gr margin? 2004 2031 2043 2051 2. Which "pill do you have on the Rows shell SumGross Margir Gross Margin Customer Count Customer 3. Which "pil do you have on the Marks card? Gross Margin Count Customer Cuviomer SumGross Margin 4. What is the gross margin of customer 20707 449 1074 06.5 5 Swap SumGross Margin for SumSales What were the total sales for customer 20477 9573 797 1 2 4 5 6 7 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 D E F G H Invoice Customer Zip Code Date of Sale SKU Description Quantity (Pounds) Sales 3021 2001 67510 3/1/21 FRT-APL Apple 15 25.52 3021 2001 67510 3/1/21 FRT-GOR Goji berry 5 5.92 3021 2001 67510 3/1/21 FRT-OLV Olive 35 53.92 3021 2001 67510 3/1/21 FRT-REN Redcurrant 5 7.12 3022 2091 67621 3/1/21 FRT-FII Fig 35 84.37 3023 2021 67511 3/1/21 FRT-JUR Juniper berry 50 65.02 3023 2021 67511 3/1/21 FRT-PAY Papaya 35 37.12 3023 2021 67511 3/1/21 FRT-BAN Banana 5 2.52 3023 2021 67511 3/1/21 FRT-PEO Persimmon 35 69.67 3024 2079 66401 3/1/21 FRT-SAM Satsuma 50 34.52 3024 2079 66401 3/1/21 FRT-MII Miracle fruit 15 30.77 3024 2079 66401 3/1/21 FRT-CHI Chico frult 15 26.27 3024 2079 66401 3/1/21 FRT-DUA Durian 25 54.27 3024 2079 66401 3/1/21 FRT-BAN Banana 35 17.52 3025 2099 66710 3/1/21 FRT-SAM Satsuma 30 20.72 3025 2099 66710 3/1/21 FRT-ELR Elderberry 25 60.27 3025 2099 66710 3/1/21 FRT-NAC Nance 5 5.92 3025 2099 66710 3/1/21 FRT-BAN Banana 45 22.52 3025 2099 66710 3/1/21 FRT-LEO Lemon 5 12.32 3025 2099 66710 3/1/21 FRT-ORG Orange 50 37.52 3026 2088 67004 3/1/21 FRT-CHY Cherimoya 45 78.77 3026 2088 67004 3/1/21 FRT-ORG Orange 35 26.27 3026 2088 67004 3/1/21 FRT-LOA Loquat 45 25.67 3026 2088 67004 3/1/21 FRT-FII Fig 50 120.5 3026 2088 67004 3/1/21 FRT-JAB Jabuticaba 50 44.52 3027 2087 67831 3/1/21 FRT-MAR Marlonberry 10 9.52 3028 2086 67416 3/1/21 FRT-ORG Orange 15 11.27 3028 2086 67416 3/1/21 FRT-Cou Coconut 45 108.5 3028 2086 67416 3/1/21 FRT-LOA Loquat 5 2.87 3028 2086 67416 3/1/21 FRT-BAN Banana 40 20.02 3028 2086 67416 3/1/21 FRT-MII Miracle fruit 35 71.77 3028 2086 67416 3/1/21 FRT-APO Apricot 25 70.02 3029 2053 66402 3/1/21 FRT-BOR Boysenberry 15 15.02 3030 2063 67010 3/1/21 FRT-APL Apple 45 76.52 3030 2063 67010 3/1/21 FRT-BIT Biberty 40 80.02 3030 2063 67010 3/1/21 FRT-DRI Dragonfruit 5 8.17 3031 2041 66404 3/1/21 FRT-LYE Lychee 40 80.42 3031 2041 66404 3/1/21 FRT-PUE Purple mang 40 40.42 3032 2068 67418 3/1/21 FRT-TAN Tamarind 20 43.82 Cost 16.36 3.71 33.26 4.26 54.26 43.01 22.06 1.56 43.06 22.01 18.01 15.46 33.01 10.86 13.21 38.01 3.61 13.96 7.41 24.51 49.96 17.16 17.11 7751 26.01 6.11 7.36 69.31 1.91 12.41 42.01 44.01 9.31 49.06 46.81 4.91 50.01 23.61 27.61 C D E F G H 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 3032 3033 3033 3034 3035 3036 3037 3038 3039 3039 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 3046 3046 3046 2068 67418 2051 67332 2051 67332 2077 66749 2051 66713 2044 67516 2073 66405 2064 67012 2060 67518 2060 67518 2060 67518 2060 67518 2060 67518 2060 67518 2050 67518 2060 67518 2060 67518 2074 67422 2074 67422 2074 67422 2066 66408 2066 66408 2035 67423 2087 67731 2087 67731 2087 67731 2067 67731 2048 67018 2048 67018 2100 66226 2100 66226 2100 66226 2100 66226 2064 67732 2064 67732 2064 67732 2064 67732 2064 67732 2054 67732 2064 67732 3/1/21 FRT-GRI Grape Raisin 3/1/21 FRT-PLT Plumcot (or 3/1/21 FRT-SAR Salal berry 3/1/21 FRT-BLR Blackberry 3/1/21 FRT-CUE Cucumber 3/1/21 FRT-CRR Cranberry 3/1/21 FRT-GRI Grape Raisin 3/1/21 FRT-ORG Orange 3/2/21 FRT-PLI Plantain 3/2/21 FRT-DRI Dragonfruit 3/2/21 FRT-CHR Cherry 3/2/21 FRT-ORG Orange 3/2/21 FRT-ORG Orange 3/2/21 FRT-SUL Sugar apple 3/2/21 FRT-UGI Ugli fruit 3/2/21 FRT-ORG Orange 3/2/21 FRT-PLT Plumcot (or 3/2/21 FRT-SOS Solanum qui 3/2/21 FRT-APL Apple 3/2/21 FRT-JUR Juniper berry 3/2/21 FRT-BAN Banana 3/2/21 FRT-BLN Blackcurrent 3/2/21 FRT-AVD Avocado 3/2/21 FRT-TAN Tamarind 3/2/21 FRT-APL Apple 3/2/21 FRT-KUA Kumquat 3/2/21 FRT-CUE Cucumber 3/2/21 FRT-GOR Goji berry 3/2/21 FRT-CUN Currant 3/2/21 FRT-JAB Jabuticaba 3/2/21 FRT-PEA Pear 3/2/21 FRT-BLR Blackberry 3/2/21 FRT-RAR Raspberry 3/2/21 FRT-POT Pomegranat: 3/2/21 FRT-LIM Lime 3/2/21 FRT-PAY Papaya 3/2/21 FRT-BLR Blackberry 3/2/21 FRT-FEO Feijoa 3/2/21 FRT-SOO Soursop 3/2/21 FRT-MUR Mulberry 40 20 35 40 50 45 45 50 5 20 25 15 10 40 15 25 50 20 15 50 50 30 30 50 50 15 50 45 30 5 50 5 10 15 10 5 25 40 45 25 50.02 42.02 39.22 80.02 91.02 45.47 56.27 37.52 10.32 32.62 62.52 11.27 7.52 40.42 16.82 18.77 105 18.82 25.52 65.02 25.02 60.02 30.02 1095 85.02 10.67 91.02 53.12 52.52 4.47 9152 10.02 11.42 9.77 9.62 5.32 50.02 79.22 108 16.52 29.61 24.81 23.11 51.61 5451 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 5451 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 65.71 11.01 G G I 81 82 15 35 15 83 84 5 40 85 86 87 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 3047 3048 3048 3048 3048 3048 3048 3049 3050 3050 3050 3050 3050 3050 3051 3052 3052 3053 3053 3054 3054 3054 3054 3054 3054 3055 3055 3055 3055 3055 3055 3055 3055 3056 3056 3057 3058 3058 3059 3059 B C 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 2023 67835 2046 66416 2046 66416 2055 67432 2055 67432 D E F 3/2/21 FRT-PEC Peach 3/2/21 FRT-BAN Banana 3/2/21 FRT-BAN Banana 3/2/21 FRT-ORG Orange 3/2/21 FRT-500 Soursop 3/2/21 FRT-CUN Currant 3/2/21 FRT-RAA Rambutan 3/2/21 FRT-BAN Banana 3/2/21 FRT-PUE Purple mang 3/2/21 FRT-BAN Banana 3/2/21 FRT-GUV Guava 3/2/21 FRT-YUZ Yuzu 3/2/21 FRT-APL Apple 3/2/21 FRT-PLM Plum Prune 3/2/21 FRT-PAI Passionfruit 3/2/21 FRT-SOS Solanum qui 3/2/21 FRT-FEO Feijoa 3/2/21 FRT-JAU Jambul 3/2/21 FRT-CLR Cloudberry 3/2/21 FRT-DAD Damson 3/2/21 FRT-BLN Blackcurrent 3/2/21 FRT-PHI Physalis 3/2/21 FRT-GUV Guava 3/2/21 FRT-PIL Pineapple 3/2/21 FRT-BAN Banana 3/2/21 FRT-JUB Jujube 3/3/21 FRT-JAI Jackfruit 3/3/21 FRT-POL Pomelo 3/3/21 FRT-CRR Cranberry 3/3/21 FRT-NEN Nectarine 3/3/21 FRT-POL Pomelo 3/3/21 FRT-PEA Pear 3/3/21 FRT-BAN Banana 3/3/21 FRT-APL Apple 3/3/21 FRT-CLR Cloudberry 3/3/21 FRT-STR Strawberry 3/3/21 FRT-DUA Durian 3/3/21 FRT-MUR Mulberry 3/3/21 FRT-PEC Peach 3/3/21 FRT-YUZ Yuzu 25 20 25 10 15 15 5 10 5 35 10 35 45 45 25 10 40 40 35 40 40 15 10 45 50 35 30 45 10 40 30 5 20 10 5 H 17 27 17.52 7.52 3.77 96.02 43.77 46.02 12.52 10.12 7.52 14.12 7.52 17.02 6.57 32.92 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 24.02 10.87 13.22 1152 7.52 10.66 10.86 4.66 2.46 58.41 26.01 30.41 7.76 5.91 4.66 8.41 4.66 10.91 3.86 21.36 5.91 45.51 50.86 49.06 33.51 1181 44.81 22.41 16.11 12.41 38.01 5.56 15.41 27.46 48.01 53.91 32.11 13.96 10.91 43.61 15.61 6.61 8.81 7.11 4.66 B C D E G H I 15 10 45 15 50 15 10 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 155 156 157 158 159 160 3059 3059 3060 3061 3051 3051 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 3068 3068 3069 3069 3069 3069 3069 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 67035 2046 67035 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 3/3/21 FRT-ELR Elderberry 3/3/21 FRT-CHI Chico fruit 3/3/21 FRT-UGI Ugil frult 3/3/21 FRT-BAN Banana 3/3/21 FRT-AVD Avocado 3/3/21 FRT-CHY Cherimoya 3/3/21 FRT-APL Apple 3/3/21 FRT-GRI GrapeRaisin 3/3/21 FRT-ORG Orange 3/3/21 FRT-ORG Orange 3/3/21 FRT-HUR Huckleberry 3/3/21 FRT-SAR Salal berry 3/3/21 FRT-PAI Passionfruit 3/3/21 FRT-NEN Nectarine 3/3/21 FRT-KUA Kumquat 3/3/21 FRT-PEO Persimmon 3/3/21 FRT-KIT Klwitruilt 3/3/21 FRT-SAA Salak 3/3/21 FRT-TAL Tamarillo 3/3/21 FRT-ORG Orange 3/3/21 FRT-PHI Physalis 3/4/21 FRT-DAO Damson 3/4/21 FRT-PIL Pineapple 3/4/21 FRT-APL Apple 3/4/21 FRT-LYE Lychee 3/4/21 FRT-JUB Jujube 3/4/21 FRT-STI Star fruit 3/4/21 FRT-MAG Mango 3/4/21 FRT-PLI Plantain 3/4/21 FRT-BLR Blackberry 3/4/21 FRT-LIM Lime 3/4/21 FRT-ORG Orange 3/4/21 FRT-LEO Lemon 3/4/21 FRT-GOR Goji berry 3/4/21 FRT-LOA Loquat 3/4/21 FRT-STR Strawberry 3/4/21 FRT-BIT Bilberty 3/4/21 FRT-MEO Melon 3/4/21 FRT-QUC Quince 3/4/21 FRT-RAR Raspberry 15 30 10 5 15 15 50 20 45 25 15 10 50 50 & ES & & & & & & & & & & & & & & & & GEA 36.17 17.52 50.42 7.52 50.02 70.02 25.52 50.02 30.02 7.52 38.42 16.82 28.22 14.72 3.57 29.87 34.82 40.52 15.42 33.77 45.52 30.62 7.72 85.02 100.5 44.72 1252 46.22 82.42 60.02 4.82 15.02 98.42 47.22 2.87 28.02 100 19.42 46.37 45.62 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 1.91 18.21 58.51 12.01 28.36 28.01 20 30 20 40 40 5 35 50 10 45 40 G 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 195 A 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 B C 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/21 FRT-HOR Honeyberry 3/4/21 FRT-MAG Mango 3/4/21 FRT-SUL Sugar apple 3/4/21 FRT-APO Apricot 3/4/21 FRT-BAN Banana 3/4/21 FRT-DAT Date 3/4/21 FRT-GRI GrapeRaisin 3/4/21 FRT-MAR Marionberry 3/4/21 FRT-ORG Orange 3/4/21 FRT-DAT Date 3/4/21 FRT-ORG Orange 3/4/21 FRT-SAA Salak 3/4/21 FRT-PLM Plum Prune 3/4/21 FRT-RAA Rambutan 3/4/21 FRT-APL Apple 3/4/21 FRT-QUC Quince 3/4/21 FRT-MEO Melon 3/4/21 FRT-ORG Orange 3/4/21 FRT-REN Redcurrant 3/4/21 FRT-STI Star fruit 3/4/21 FRT-COU Coconut 3/4/21 FRT-HOR Honeyberry 3/4/21 FRT-GOR Goji berry 3/4/21 FRT-LOA Loquat 3/4/21 FRT-NAC Nance 3/4/21 FRT-KII Klwifruit 3/4/21 FRT-JAL Jackfruit 3/4/21 FRT-OLV Olive 3/4/21 FRT-JAU Jambul 3/4/21 FRT-BOR Boysenberry 3/4/21 FRT-TAL Tamarillo 3/4/21 FRT-HUR Huckleberry 3/4/21 FRT-POT Pomegranate 3/4/21 FRT-CHR Cherry 40 35 25 50 40 5 50 35 20 15 40 35 10 20 20 5 30 45 15 30 35 40 10 5 40 20 20 10 40 50 35 5 40 5 H 37.62 80.87 25.27 140 20.02 4.17 62.52 33.27 15.02 12.47 30.02 28.37 13.12 46.02 34.02 5.17 58.22 33.77 21.32 75.02 8437 37.62 11.82 2.87 4722 46.42 12.62 15.42 78.02 50.02 26.97 4.82 26.02 12.52 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 In this lab, you will Required: 1. Create a calculated field for the Gras 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: Frutopia salis eos frut from throughout the work to customers throughout the country by mail order. The company was a sales journal that records each sale and its related sales and cost details. This sales journal is for March 1-4,2021. Use data fie Lab 2-4 Baixkx, but apart in Telmu. Software needed Tableau Screen capture tool (Windows: Snipping Toot Mac: CmdShift+4) Duta Lab 2.4 Dasar Perform the Analysis: Refer to Lab 2.4 in the text for instructions and steps for each of the lab parts Share the Story: Required: 1. Which customer number is the last profitable with $4.80 gr margin? 2004 2031 2043 2051 2. Which "pill do you have on the Rows shell SumGross Margir Gross Margin Customer Count Customer 3. Which "pil do you have on the Marks card? Gross Margin Count Customer Cuviomer SumGross Margin 4. What is the gross margin of customer 20707 449 1074 06.5 5 Swap SumGross Margin for SumSales What were the total sales for customer 20477 9573 797 1 2 4 5 6 7 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31 32 33 34 35 36 37 38 39 40 D E F G H Invoice Customer Zip Code Date of Sale SKU Description Quantity (Pounds) Sales 3021 2001 67510 3/1/21 FRT-APL Apple 15 25.52 3021 2001 67510 3/1/21 FRT-GOR Goji berry 5 5.92 3021 2001 67510 3/1/21 FRT-OLV Olive 35 53.92 3021 2001 67510 3/1/21 FRT-REN Redcurrant 5 7.12 3022 2091 67621 3/1/21 FRT-FII Fig 35 84.37 3023 2021 67511 3/1/21 FRT-JUR Juniper berry 50 65.02 3023 2021 67511 3/1/21 FRT-PAY Papaya 35 37.12 3023 2021 67511 3/1/21 FRT-BAN Banana 5 2.52 3023 2021 67511 3/1/21 FRT-PEO Persimmon 35 69.67 3024 2079 66401 3/1/21 FRT-SAM Satsuma 50 34.52 3024 2079 66401 3/1/21 FRT-MII Miracle fruit 15 30.77 3024 2079 66401 3/1/21 FRT-CHI Chico frult 15 26.27 3024 2079 66401 3/1/21 FRT-DUA Durian 25 54.27 3024 2079 66401 3/1/21 FRT-BAN Banana 35 17.52 3025 2099 66710 3/1/21 FRT-SAM Satsuma 30 20.72 3025 2099 66710 3/1/21 FRT-ELR Elderberry 25 60.27 3025 2099 66710 3/1/21 FRT-NAC Nance 5 5.92 3025 2099 66710 3/1/21 FRT-BAN Banana 45 22.52 3025 2099 66710 3/1/21 FRT-LEO Lemon 5 12.32 3025 2099 66710 3/1/21 FRT-ORG Orange 50 37.52 3026 2088 67004 3/1/21 FRT-CHY Cherimoya 45 78.77 3026 2088 67004 3/1/21 FRT-ORG Orange 35 26.27 3026 2088 67004 3/1/21 FRT-LOA Loquat 45 25.67 3026 2088 67004 3/1/21 FRT-FII Fig 50 120.5 3026 2088 67004 3/1/21 FRT-JAB Jabuticaba 50 44.52 3027 2087 67831 3/1/21 FRT-MAR Marlonberry 10 9.52 3028 2086 67416 3/1/21 FRT-ORG Orange 15 11.27 3028 2086 67416 3/1/21 FRT-Cou Coconut 45 108.5 3028 2086 67416 3/1/21 FRT-LOA Loquat 5 2.87 3028 2086 67416 3/1/21 FRT-BAN Banana 40 20.02 3028 2086 67416 3/1/21 FRT-MII Miracle fruit 35 71.77 3028 2086 67416 3/1/21 FRT-APO Apricot 25 70.02 3029 2053 66402 3/1/21 FRT-BOR Boysenberry 15 15.02 3030 2063 67010 3/1/21 FRT-APL Apple 45 76.52 3030 2063 67010 3/1/21 FRT-BIT Biberty 40 80.02 3030 2063 67010 3/1/21 FRT-DRI Dragonfruit 5 8.17 3031 2041 66404 3/1/21 FRT-LYE Lychee 40 80.42 3031 2041 66404 3/1/21 FRT-PUE Purple mang 40 40.42 3032 2068 67418 3/1/21 FRT-TAN Tamarind 20 43.82 Cost 16.36 3.71 33.26 4.26 54.26 43.01 22.06 1.56 43.06 22.01 18.01 15.46 33.01 10.86 13.21 38.01 3.61 13.96 7.41 24.51 49.96 17.16 17.11 7751 26.01 6.11 7.36 69.31 1.91 12.41 42.01 44.01 9.31 49.06 46.81 4.91 50.01 23.61 27.61 C D E F G H 41 42 43 44 45 46 47 48 49 50 51 52 53 54 55 56 57 58 59 60 61 62 63 64 65 66 67 68 69 70 71 72 73 74 75 76 77 78 79 80 3032 3033 3033 3034 3035 3036 3037 3038 3039 3039 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 3046 3046 3046 2068 67418 2051 67332 2051 67332 2077 66749 2051 66713 2044 67516 2073 66405 2064 67012 2060 67518 2060 67518 2060 67518 2060 67518 2060 67518 2060 67518 2050 67518 2060 67518 2060 67518 2074 67422 2074 67422 2074 67422 2066 66408 2066 66408 2035 67423 2087 67731 2087 67731 2087 67731 2067 67731 2048 67018 2048 67018 2100 66226 2100 66226 2100 66226 2100 66226 2064 67732 2064 67732 2064 67732 2064 67732 2064 67732 2054 67732 2064 67732 3/1/21 FRT-GRI Grape Raisin 3/1/21 FRT-PLT Plumcot (or 3/1/21 FRT-SAR Salal berry 3/1/21 FRT-BLR Blackberry 3/1/21 FRT-CUE Cucumber 3/1/21 FRT-CRR Cranberry 3/1/21 FRT-GRI Grape Raisin 3/1/21 FRT-ORG Orange 3/2/21 FRT-PLI Plantain 3/2/21 FRT-DRI Dragonfruit 3/2/21 FRT-CHR Cherry 3/2/21 FRT-ORG Orange 3/2/21 FRT-ORG Orange 3/2/21 FRT-SUL Sugar apple 3/2/21 FRT-UGI Ugli fruit 3/2/21 FRT-ORG Orange 3/2/21 FRT-PLT Plumcot (or 3/2/21 FRT-SOS Solanum qui 3/2/21 FRT-APL Apple 3/2/21 FRT-JUR Juniper berry 3/2/21 FRT-BAN Banana 3/2/21 FRT-BLN Blackcurrent 3/2/21 FRT-AVD Avocado 3/2/21 FRT-TAN Tamarind 3/2/21 FRT-APL Apple 3/2/21 FRT-KUA Kumquat 3/2/21 FRT-CUE Cucumber 3/2/21 FRT-GOR Goji berry 3/2/21 FRT-CUN Currant 3/2/21 FRT-JAB Jabuticaba 3/2/21 FRT-PEA Pear 3/2/21 FRT-BLR Blackberry 3/2/21 FRT-RAR Raspberry 3/2/21 FRT-POT Pomegranat: 3/2/21 FRT-LIM Lime 3/2/21 FRT-PAY Papaya 3/2/21 FRT-BLR Blackberry 3/2/21 FRT-FEO Feijoa 3/2/21 FRT-SOO Soursop 3/2/21 FRT-MUR Mulberry 40 20 35 40 50 45 45 50 5 20 25 15 10 40 15 25 50 20 15 50 50 30 30 50 50 15 50 45 30 5 50 5 10 15 10 5 25 40 45 25 50.02 42.02 39.22 80.02 91.02 45.47 56.27 37.52 10.32 32.62 62.52 11.27 7.52 40.42 16.82 18.77 105 18.82 25.52 65.02 25.02 60.02 30.02 1095 85.02 10.67 91.02 53.12 52.52 4.47 9152 10.02 11.42 9.77 9.62 5.32 50.02 79.22 108 16.52 29.61 24.81 23.11 51.61 5451 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 5451 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 65.71 11.01 G G I 81 82 15 35 15 83 84 5 40 85 86 87 89 90 91 92 93 94 95 96 97 98 99 100 101 102 103 104 105 106 107 108 109 110 111 112 113 114 115 116 117 118 119 120 3047 3048 3048 3048 3048 3048 3048 3049 3050 3050 3050 3050 3050 3050 3051 3052 3052 3053 3053 3054 3054 3054 3054 3054 3054 3055 3055 3055 3055 3055 3055 3055 3055 3056 3056 3057 3058 3058 3059 3059 B C 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 2023 67835 2046 66416 2046 66416 2055 67432 2055 67432 D E F 3/2/21 FRT-PEC Peach 3/2/21 FRT-BAN Banana 3/2/21 FRT-BAN Banana 3/2/21 FRT-ORG Orange 3/2/21 FRT-500 Soursop 3/2/21 FRT-CUN Currant 3/2/21 FRT-RAA Rambutan 3/2/21 FRT-BAN Banana 3/2/21 FRT-PUE Purple mang 3/2/21 FRT-BAN Banana 3/2/21 FRT-GUV Guava 3/2/21 FRT-YUZ Yuzu 3/2/21 FRT-APL Apple 3/2/21 FRT-PLM Plum Prune 3/2/21 FRT-PAI Passionfruit 3/2/21 FRT-SOS Solanum qui 3/2/21 FRT-FEO Feijoa 3/2/21 FRT-JAU Jambul 3/2/21 FRT-CLR Cloudberry 3/2/21 FRT-DAD Damson 3/2/21 FRT-BLN Blackcurrent 3/2/21 FRT-PHI Physalis 3/2/21 FRT-GUV Guava 3/2/21 FRT-PIL Pineapple 3/2/21 FRT-BAN Banana 3/2/21 FRT-JUB Jujube 3/3/21 FRT-JAI Jackfruit 3/3/21 FRT-POL Pomelo 3/3/21 FRT-CRR Cranberry 3/3/21 FRT-NEN Nectarine 3/3/21 FRT-POL Pomelo 3/3/21 FRT-PEA Pear 3/3/21 FRT-BAN Banana 3/3/21 FRT-APL Apple 3/3/21 FRT-CLR Cloudberry 3/3/21 FRT-STR Strawberry 3/3/21 FRT-DUA Durian 3/3/21 FRT-MUR Mulberry 3/3/21 FRT-PEC Peach 3/3/21 FRT-YUZ Yuzu 25 20 25 10 15 15 5 10 5 35 10 35 45 45 25 10 40 40 35 40 40 15 10 45 50 35 30 45 10 40 30 5 20 10 5 H 17 27 17.52 7.52 3.77 96.02 43.77 46.02 12.52 10.12 7.52 14.12 7.52 17.02 6.57 32.92 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 24.02 10.87 13.22 1152 7.52 10.66 10.86 4.66 2.46 58.41 26.01 30.41 7.76 5.91 4.66 8.41 4.66 10.91 3.86 21.36 5.91 45.51 50.86 49.06 33.51 1181 44.81 22.41 16.11 12.41 38.01 5.56 15.41 27.46 48.01 53.91 32.11 13.96 10.91 43.61 15.61 6.61 8.81 7.11 4.66 B C D E G H I 15 10 45 15 50 15 10 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 155 156 157 158 159 160 3059 3059 3060 3061 3051 3051 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 3068 3068 3069 3069 3069 3069 3069 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 67035 2046 67035 2047 67838 2047 67838 2047 67838 2047 67838 2047 67838 3/3/21 FRT-ELR Elderberry 3/3/21 FRT-CHI Chico fruit 3/3/21 FRT-UGI Ugil frult 3/3/21 FRT-BAN Banana 3/3/21 FRT-AVD Avocado 3/3/21 FRT-CHY Cherimoya 3/3/21 FRT-APL Apple 3/3/21 FRT-GRI GrapeRaisin 3/3/21 FRT-ORG Orange 3/3/21 FRT-ORG Orange 3/3/21 FRT-HUR Huckleberry 3/3/21 FRT-SAR Salal berry 3/3/21 FRT-PAI Passionfruit 3/3/21 FRT-NEN Nectarine 3/3/21 FRT-KUA Kumquat 3/3/21 FRT-PEO Persimmon 3/3/21 FRT-KIT Klwitruilt 3/3/21 FRT-SAA Salak 3/3/21 FRT-TAL Tamarillo 3/3/21 FRT-ORG Orange 3/3/21 FRT-PHI Physalis 3/4/21 FRT-DAO Damson 3/4/21 FRT-PIL Pineapple 3/4/21 FRT-APL Apple 3/4/21 FRT-LYE Lychee 3/4/21 FRT-JUB Jujube 3/4/21 FRT-STI Star fruit 3/4/21 FRT-MAG Mango 3/4/21 FRT-PLI Plantain 3/4/21 FRT-BLR Blackberry 3/4/21 FRT-LIM Lime 3/4/21 FRT-ORG Orange 3/4/21 FRT-LEO Lemon 3/4/21 FRT-GOR Goji berry 3/4/21 FRT-LOA Loquat 3/4/21 FRT-STR Strawberry 3/4/21 FRT-BIT Bilberty 3/4/21 FRT-MEO Melon 3/4/21 FRT-QUC Quince 3/4/21 FRT-RAR Raspberry 15 30 10 5 15 15 50 20 45 25 15 10 50 50 & ES & & & & & & & & & & & & & & & & GEA 36.17 17.52 50.42 7.52 50.02 70.02 25.52 50.02 30.02 7.52 38.42 16.82 28.22 14.72 3.57 29.87 34.82 40.52 15.42 33.77 45.52 30.62 7.72 85.02 100.5 44.72 1252 46.22 82.42 60.02 4.82 15.02 98.42 47.22 2.87 28.02 100 19.42 46.37 45.62 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 1.91 18.21 58.51 12.01 28.36 28.01 20 30 20 40 40 5 35 50 10 45 40 G 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 195 A 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 B C 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/21 FRT-HOR Honeyberry 3/4/21 FRT-MAG Mango 3/4/21 FRT-SUL Sugar apple 3/4/21 FRT-APO Apricot 3/4/21 FRT-BAN Banana 3/4/21 FRT-DAT Date 3/4/21 FRT-GRI GrapeRaisin 3/4/21 FRT-MAR Marionberry 3/4/21 FRT-ORG Orange 3/4/21 FRT-DAT Date 3/4/21 FRT-ORG Orange 3/4/21 FRT-SAA Salak 3/4/21 FRT-PLM Plum Prune 3/4/21 FRT-RAA Rambutan 3/4/21 FRT-APL Apple 3/4/21 FRT-QUC Quince 3/4/21 FRT-MEO Melon 3/4/21 FRT-ORG Orange 3/4/21 FRT-REN Redcurrant 3/4/21 FRT-STI Star fruit 3/4/21 FRT-COU Coconut 3/4/21 FRT-HOR Honeyberry 3/4/21 FRT-GOR Goji berry 3/4/21 FRT-LOA Loquat 3/4/21 FRT-NAC Nance 3/4/21 FRT-KII Klwifruit 3/4/21 FRT-JAL Jackfruit 3/4/21 FRT-OLV Olive 3/4/21 FRT-JAU Jambul 3/4/21 FRT-BOR Boysenberry 3/4/21 FRT-TAL Tamarillo 3/4/21 FRT-HUR Huckleberry 3/4/21 FRT-POT Pomegranate 3/4/21 FRT-CHR Cherry 40 35 25 50 40 5 50 35 20 15 40 35 10 20 20 5 30 45 15 30 35 40 10 5 40 20 20 10 40 50 35 5 40 5 H 37.62 80.87 25.27 140 20.02 4.17 62.52 33.27 15.02 12.47 30.02 28.37 13.12 46.02 34.02 5.17 58.22 33.77 21.32 75.02 8437 37.62 11.82 2.87 4722 46.42 12.62 15.42 78.02 50.02 26.97 4.82 26.02 12.52 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