Required information (The following information applies to the questions displayed below.) 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. Summarize the late accounts receivable by customer. Show the Pivottable. 2. Get the detailed receivables for the customer "Thai Tap." Ask the Question: How can we use PivotTables on the total detailed accounts receivables balance to get specific detail on invoices due by customer? Master the Data: To begin, we have a list of 200 receivables on specific invoices that are all past their due date as of today's date of 12/31/2021. This is shown in the Excel file Lab 2-1 Data.xlsx. Software needed Excel Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data: Excel File Lab 2-1 Alt Data.xlsx. Perform the Analysis: Refer to Lab 2-1 Alternative in the text for instructions and Lab 2-1 steps for each of the lab parts. Share the Story: Now that we have the detail by customer, we can better follow up with them to help with collections. All employees interfacing with the client should have this detail when they talk and interact with that specific customer. A B C D E F G H 1 J K L M Today's Dat 12/31/21 1 1 Customer 2 We Fry it All 3 We Fry it All 4 Taste of Thai 5 Grandma's Greasy Spoon 6 Brewed Miracles 7 Grandma's Greasy Spoon 8 Taste of Thai 9 Pita Pan 10 We Fry it All 11 We Fry it All 12 Wok Delight 13 Onein a Million 14 Tequila Taste 15 We Fry it All 16 Pita Pan 17 Pita Pan 18 One in a Million 19 Planet of the Grapes 20 Grandma's Greasy Spoon 21 Pita Pan 22 Wok Delight 23 Wok Delight 24 Taste of Thai 25 Tequila Taste 26 The Godfather 27 The Godfather 28 Wok Delight 29 Tequila Taste 30 Tequila Taste 31 Brewed Miracles 32 Soup'r Salad 33 Taste of Thai 34 Taste of Thai 35 Wok Delight 36 Pita Pan 37 Brewed Miracles InvoiceAmount 269.65 456.16 157.11 243.05 127.75 416.56 492.93 98.73 370.26 235.79 96.39 372.13 100.78 217.81 320.1 480.96 256.1 487.73 160.61 450.77 168.81 261.41 221.42 268.95 220.19 492.03 206.37 475.72 250.48 270.87 96.17 130.84 299.84 480.01 77.93 188.93 Due Date 7/21/21 7/22/21 7/25/21 7/25/21 7/26/21 7/27/21 7/27/21 7/28/21 7/30/21 8/1/21 8/2/21 8/2/21 8/4/21 8/5/21 8/6/21 8/6/21 8/8/21 8/9/21 8/10/21 8/10/21 8/11/21 8/11/21 8/12/21 8/13/21 8/14/21 8/14/21 8/15/21 8/15/21 8/16/21 8/16/21 8/17/21 8/17/21 8/17/21 8/18/21 8/19/21 8/20/21 FILOFON 37 Brewed Miracles 38 One in a Million 39 Tequila Taste 40 One in a Million 41 Grandma's Greasy Spoon 42 Planet of the Grapes 43 The Godfather 44 Tequila Taste 45 | Thai Tap 46 The Godfather 47|Thai Tap 48 Grandma's Greasy Spoon 49 Soup 'r Salad 50 Thai Tap 51) Thai Tap 52 Planet of the Grapes 53 Soup 'r Salad 54 |Thai Tap 55 The Godfather 56 We Fry it All 57 Planet of the Grapes 58 Thai Tap 59 We Fry it All 60 The Godfather 61 The Godfather 62 Onein a Million 63 One in a Million 64 We Fry it All 65 Brewed Miracles 66 Soup 'r Salad 67 Wok Delight 68 Pita Pan 69 Taste of Thai 70 Soup 'r Salad 71 Brewed Miracles 72 We Fry it All 188.93 327.58 401.58 456.44 93.14 270.11 298.01 423.7 248.76 260.56 393.55 202.62 164.42 207.96 97.89 238.52 419.62 170.13 240.24 146.01 146.91 265.42 251.98 374.15 129.08 180.42 218.29 83.27 297.8 363.68 449.46 121.66 463.07 386.33 435.44 124.53 8/20/21 8/20/21 8/20/21 8/20/21 8/21/21 8/21/21 8/21/21 8/21/21 8/23/21 8/23/21 8/24/21 8/25/21 8/28/21 8/28/21 8/29/21 8/30/21 8/31/21 9/1/21 9/1/21 9/4/21 9/4/21 9/4/21 9/5/21 9/5/21 9/6/21 9/6/21 9/6/21 9/8/21 9/8/21 9/8/21 9/8/21 9/10/21 9/10/21 9/11/21 9/11/21 9/12/21 111 We Fry it All 112] Thai Tap 113 One in a Million 114 The Godfather 115 Taste of Thai 116 We Fry it All 117 Tequila Taste 118 Grandma's Greasy Spoon 119 Planet of the Grapes 120 One in a Million 121 Tequila Taste 122 Tequila Taste 123 Tequila Taste 124 Grandma's Greasy Spoon 125 Soup 'r Salad 126| Thai Tap 127 Pita Pan 128| Thai Tap 129 Brewed Miracles 130 Pita Pan 131 Soup 'r Salad 132 Taste of Thai 133 Brewed Miracles 134 Wok Delight 135 Brewed Miracles 136 Grandma's Greasy Spoon 137 Soup 'r Salad 138 Taste of Thai 139 One in a Million 140 Grandma's Greasy Spoon 141 Brewed Miracles 142 One in a Million 143 Taste of Thai 144 Tequila Taste 145 Planet of the Grapes 146 Planet of the Grapes 427.37 76.99 236.81 274.98 197.56 176.1 217.37 304.32 182.14 270.09 289.5 455.29 345.41 228.17 137.09 365.47 367.17 116.37 351.37 233.57 316.33 378.44 108.36 246.99 331.45 337.14 228.37 108.87 406.68 501.78 489.69 146.61 413.67 367.76 331.28 351.22 10/13/21 10/16/21 10/16/21 10/16/21 10/18/21 10/19/21 10/19/21 10/19/21 10/20/21 10/20/21 10/20/21 10/20/21 10/21/21 10/22/21 10/23/21 10/23/21 10/23/21 10/24/21 10/24/21 10/25/21 10/25/21 10/26/21 10/29/21 10/29/21 10/30/21 10/30/21 10/31/21 11/3/21 11/3/21 11/3/21 11/4/21 11/5/21 11/6/21 11/9/21 11/10/21 11/11/21 147 Thai Tp 148| Wok Delight 149 One in a Million 150 Wok Delight 151 Tequila Taste 152 Pita Pan 153 The Godfather 154| Thai Tap 155 Pita Pan 156 The Godfather 157 One in a Million 158 The Godfather 159 Planet of the Grapes 160 Taste of Thai 161 The Godfather 162 We Fry it All 163 Soup 'r Salad 164 Planet of the Grapes 165 Grandma's Greasy Spoon 166 Planet of the Grapes 167| Thai Tap 168 The Godfather 169 Grandma's Greasy Spoon 170| Thai Tap 171 One in a Million 172 Wok Delight 173 Planet of the Grapes 174 We Fry it All 175 Planet of the Grapes 176 Taste of Thai 177 Planet of the Grapes 178 Tequila Taste 179 Soup 'r Salad 180 Planet of the Grapes 181 Taste of Thai 182 Onein a Million 450.57 137.18 478.15 231.43 326.47 343.96 412.24 319.79 174.26 190.37 433.62 461.72 434.34 354.16 108.52 475.93 112.1 105.68 110.6 372.54 232.33 352.31 355.08 471.92 487.24 319.02 408.65 102.88 125.87 334.91 459.66 78.59 204.09 218.76 91.18 125.14 11/11/21 11/13/21 11/13/21 11/15/21 11/15/21 11/15/21 11/15/21 11/16/21 11/17/21 11/18/21 11/18/21 11/18/21 11/19/21 11/21/21 11/22/21 11/22/21 11/23/21 11/24/21 11/24/21 11/25/21 11/26/21 11/27/21 11/27/21 11/27/21 11/28/21 11/29/21 11/29/21 11/30/21 12/2/21 12/2/21 12/2/21 12/3/21 12/3/21 12/3/21 12/6/21 12/6/21 183 he Godfather 184 he Godfather 185 rewed Miracles 186 ita Pan 187 Vok Delight 188 oup 'r Salad 189 Vok Delight 190 aste of Thai 191 hai Tap 192 rewed Miracles 193 ita Pan 194 Ve Fry it All 195 One in a Million 196 ita Pan 197 Vok Delight 198 rewed Miracles 199 Ve Fry it All 200 hai Tap 201 Ve Fry it All 202 203 204 205 206 207 208 436.62 87.37 257.38 394.56 387.63 339.42 469.88 278.25 340.4 219.35 266.82 327.29 103.84 249.04 419.69 461.4 345.81 480.75 482.44 12/6/21 12/8/21 12/8/21 12/8/21 12/11/21 12/12/21 12/12/21 12/13/21 12/13/21 12/14/21 12/14/21 12/14/21 12/15/21 12/15/21 12/16/21 12/16/21 12/18/21 12/20/21 12/22/21 209 210 211 212 Required information (The following information applies to the questions displayed below.) 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. Summarize the late accounts receivable by customer. Show the Pivottable. 2. Get the detailed receivables for the customer "Thai Tap." Ask the Question: How can we use PivotTables on the total detailed accounts receivables balance to get specific detail on invoices due by customer? Master the Data: To begin, we have a list of 200 receivables on specific invoices that are all past their due date as of today's date of 12/31/2021. This is shown in the Excel file Lab 2-1 Data.xlsx. Software needed Excel Screen capture tool (Windows: Snipping Tool; Mac: Cmd+Shift+4) Data: Excel File Lab 2-1 Alt Data.xlsx. Perform the Analysis: Refer to Lab 2-1 Alternative in the text for instructions and Lab 2-1 steps for each of the lab parts. Share the Story: Now that we have the detail by customer, we can better follow up with them to help with collections. All employees interfacing with the client should have this detail when they talk and interact with that specific customer. A B C D E F G H 1 J K L M Today's Dat 12/31/21 1 1 Customer 2 We Fry it All 3 We Fry it All 4 Taste of Thai 5 Grandma's Greasy Spoon 6 Brewed Miracles 7 Grandma's Greasy Spoon 8 Taste of Thai 9 Pita Pan 10 We Fry it All 11 We Fry it All 12 Wok Delight 13 Onein a Million 14 Tequila Taste 15 We Fry it All 16 Pita Pan 17 Pita Pan 18 One in a Million 19 Planet of the Grapes 20 Grandma's Greasy Spoon 21 Pita Pan 22 Wok Delight 23 Wok Delight 24 Taste of Thai 25 Tequila Taste 26 The Godfather 27 The Godfather 28 Wok Delight 29 Tequila Taste 30 Tequila Taste 31 Brewed Miracles 32 Soup'r Salad 33 Taste of Thai 34 Taste of Thai 35 Wok Delight 36 Pita Pan 37 Brewed Miracles InvoiceAmount 269.65 456.16 157.11 243.05 127.75 416.56 492.93 98.73 370.26 235.79 96.39 372.13 100.78 217.81 320.1 480.96 256.1 487.73 160.61 450.77 168.81 261.41 221.42 268.95 220.19 492.03 206.37 475.72 250.48 270.87 96.17 130.84 299.84 480.01 77.93 188.93 Due Date 7/21/21 7/22/21 7/25/21 7/25/21 7/26/21 7/27/21 7/27/21 7/28/21 7/30/21 8/1/21 8/2/21 8/2/21 8/4/21 8/5/21 8/6/21 8/6/21 8/8/21 8/9/21 8/10/21 8/10/21 8/11/21 8/11/21 8/12/21 8/13/21 8/14/21 8/14/21 8/15/21 8/15/21 8/16/21 8/16/21 8/17/21 8/17/21 8/17/21 8/18/21 8/19/21 8/20/21 FILOFON 37 Brewed Miracles 38 One in a Million 39 Tequila Taste 40 One in a Million 41 Grandma's Greasy Spoon 42 Planet of the Grapes 43 The Godfather 44 Tequila Taste 45 | Thai Tap 46 The Godfather 47|Thai Tap 48 Grandma's Greasy Spoon 49 Soup 'r Salad 50 Thai Tap 51) Thai Tap 52 Planet of the Grapes 53 Soup 'r Salad 54 |Thai Tap 55 The Godfather 56 We Fry it All 57 Planet of the Grapes 58 Thai Tap 59 We Fry it All 60 The Godfather 61 The Godfather 62 Onein a Million 63 One in a Million 64 We Fry it All 65 Brewed Miracles 66 Soup 'r Salad 67 Wok Delight 68 Pita Pan 69 Taste of Thai 70 Soup 'r Salad 71 Brewed Miracles 72 We Fry it All 188.93 327.58 401.58 456.44 93.14 270.11 298.01 423.7 248.76 260.56 393.55 202.62 164.42 207.96 97.89 238.52 419.62 170.13 240.24 146.01 146.91 265.42 251.98 374.15 129.08 180.42 218.29 83.27 297.8 363.68 449.46 121.66 463.07 386.33 435.44 124.53 8/20/21 8/20/21 8/20/21 8/20/21 8/21/21 8/21/21 8/21/21 8/21/21 8/23/21 8/23/21 8/24/21 8/25/21 8/28/21 8/28/21 8/29/21 8/30/21 8/31/21 9/1/21 9/1/21 9/4/21 9/4/21 9/4/21 9/5/21 9/5/21 9/6/21 9/6/21 9/6/21 9/8/21 9/8/21 9/8/21 9/8/21 9/10/21 9/10/21 9/11/21 9/11/21 9/12/21 111 We Fry it All 112] Thai Tap 113 One in a Million 114 The Godfather 115 Taste of Thai 116 We Fry it All 117 Tequila Taste 118 Grandma's Greasy Spoon 119 Planet of the Grapes 120 One in a Million 121 Tequila Taste 122 Tequila Taste 123 Tequila Taste 124 Grandma's Greasy Spoon 125 Soup 'r Salad 126| Thai Tap 127 Pita Pan 128| Thai Tap 129 Brewed Miracles 130 Pita Pan 131 Soup 'r Salad 132 Taste of Thai 133 Brewed Miracles 134 Wok Delight 135 Brewed Miracles 136 Grandma's Greasy Spoon 137 Soup 'r Salad 138 Taste of Thai 139 One in a Million 140 Grandma's Greasy Spoon 141 Brewed Miracles 142 One in a Million 143 Taste of Thai 144 Tequila Taste 145 Planet of the Grapes 146 Planet of the Grapes 427.37 76.99 236.81 274.98 197.56 176.1 217.37 304.32 182.14 270.09 289.5 455.29 345.41 228.17 137.09 365.47 367.17 116.37 351.37 233.57 316.33 378.44 108.36 246.99 331.45 337.14 228.37 108.87 406.68 501.78 489.69 146.61 413.67 367.76 331.28 351.22 10/13/21 10/16/21 10/16/21 10/16/21 10/18/21 10/19/21 10/19/21 10/19/21 10/20/21 10/20/21 10/20/21 10/20/21 10/21/21 10/22/21 10/23/21 10/23/21 10/23/21 10/24/21 10/24/21 10/25/21 10/25/21 10/26/21 10/29/21 10/29/21 10/30/21 10/30/21 10/31/21 11/3/21 11/3/21 11/3/21 11/4/21 11/5/21 11/6/21 11/9/21 11/10/21 11/11/21 147 Thai Tp 148| Wok Delight 149 One in a Million 150 Wok Delight 151 Tequila Taste 152 Pita Pan 153 The Godfather 154| Thai Tap 155 Pita Pan 156 The Godfather 157 One in a Million 158 The Godfather 159 Planet of the Grapes 160 Taste of Thai 161 The Godfather 162 We Fry it All 163 Soup 'r Salad 164 Planet of the Grapes 165 Grandma's Greasy Spoon 166 Planet of the Grapes 167| Thai Tap 168 The Godfather 169 Grandma's Greasy Spoon 170| Thai Tap 171 One in a Million 172 Wok Delight 173 Planet of the Grapes 174 We Fry it All 175 Planet of the Grapes 176 Taste of Thai 177 Planet of the Grapes 178 Tequila Taste 179 Soup 'r Salad 180 Planet of the Grapes 181 Taste of Thai 182 Onein a Million 450.57 137.18 478.15 231.43 326.47 343.96 412.24 319.79 174.26 190.37 433.62 461.72 434.34 354.16 108.52 475.93 112.1 105.68 110.6 372.54 232.33 352.31 355.08 471.92 487.24 319.02 408.65 102.88 125.87 334.91 459.66 78.59 204.09 218.76 91.18 125.14 11/11/21 11/13/21 11/13/21 11/15/21 11/15/21 11/15/21 11/15/21 11/16/21 11/17/21 11/18/21 11/18/21 11/18/21 11/19/21 11/21/21 11/22/21 11/22/21 11/23/21 11/24/21 11/24/21 11/25/21 11/26/21 11/27/21 11/27/21 11/27/21 11/28/21 11/29/21 11/29/21 11/30/21 12/2/21 12/2/21 12/2/21 12/3/21 12/3/21 12/3/21 12/6/21 12/6/21 183 he Godfather 184 he Godfather 185 rewed Miracles 186 ita Pan 187 Vok Delight 188 oup 'r Salad 189 Vok Delight 190 aste of Thai 191 hai Tap 192 rewed Miracles 193 ita Pan 194 Ve Fry it All 195 One in a Million 196 ita Pan 197 Vok Delight 198 rewed Miracles 199 Ve Fry it All 200 hai Tap 201 Ve Fry it All 202 203 204 205 206 207 208 436.62 87.37 257.38 394.56 387.63 339.42 469.88 278.25 340.4 219.35 266.82 327.29 103.84 249.04 419.69 461.4 345.81 480.75 482.44 12/6/21 12/8/21 12/8/21 12/8/21 12/11/21 12/12/21 12/12/21 12/13/21 12/13/21 12/14/21 12/14/21 12/14/21 12/15/21 12/15/21 12/16/21 12/16/21 12/18/21 12/20/21 12/22/21 209 210 211 212