Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

In this lab, you will: Required: 1. Age the recelvables in six 30-day buckets (similar to Lab 6-1 above), including 1-30 days, 31-60 days. 61-90

image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
In this lab, you will: Required: 1. Age the recelvables in six 30-day buckets (similar to Lab 6-1 above), including 1-30 days, 31-60 days. 61-90 days, 91-120 days, 121-150 days, and 151-180 days 2. Detail the receivables from the 151-180 days bucket Ask the Question: How can we age receivables using Excel pivottables? Master the Data: Apply the same steps as Lab 6-1 to the Lab 6-1 Alt Data.xlsx dataset, Software needed Excel Screen capture tool (Windows: Snipping Tool: Mac: Cmd+Shift+4) . Data: Excel File Lab 6-1 Alt Data xlsx Perform the Analysis: Refer to Lab 6-1 Alternate in the text for instructions and Lab 6-1 steps for each the of lab parts Share the Story: Now that you have aged the receivables, the company is better able to estimate its allowance for doubtful accounts (the contra receivable accounts that reduces gross accounts receivable into net accounts receivable). As a rule, as accounts receivable age, they are less likely to be collected, Required: 1. What is the gross amount of receivables owed? O $53,179.57 O $34,499.08 O $37.732.45 O Cannot be determined O $56,381.41 2. What is the total receivables due in the 31-60 day A/R aging bucket? $11.880.62 O $12,574.47 $11,499.66 O $7,986.14 3. Accountants and auditors age receivables to primarily do which task? To help estimate the allowance for doubtful accounts O To determine the most profitable products O To help estimate the total amount of gross receivables To determine the most profitable customers 4. What is the total receivables due in the 151-180 day A/R aging bucket? O $3,336.51 O $7,986.14 O $11,499.66 O $9,104.01 5. In the detailed 151-180 A/R aging bucket, what is the amount owed by the customer named Brewed Miracles? O $372.13 $1,331.86 $12775 O $659.61 32 Soup 'r Salad 33 Taste of Thai 34 Taste of Thai 35 Wok Delight 36 Pita Pan 37 Brewed Miracles 38 One in a Million 39 Tequila Taste 40 One in a Million 41 Grandma's Greasy Spoor 42 Planet of the Grapes 43 The Godfather 44 Tequila Taste 45 Thai Tap 46 The Godfather 47 Thai Tap 48 Grandma's Greasy Spoot 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 One in a Million 63 One in a Million 64 We Fry it All 65 Brewed Miracles hur Coun salad Sheet1 96.17 130.84 299.84 480.01 77.93 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 8/17/2021 8/17/2021 8/17/2021 8/18/2021 8/19/2021 8/20/2021 8/20/2021 8/20/2021 8/20/2021 8/21/2021 8/21/2021 8/21/2021 8/21/2021 8/23/2021 8/23/2021 8/24/2021 8/25/2021 8/28/2021 8/28/2021 8/29/2021 8/30/2021 8/31/2021 9/1/2021 9/1/2021 9/4/2021 9/4/2021 9/4/2021 9/5/2021 9/5/2021 9/6/2021 9/6/2021 9/6/2021 9/8/2021 9/8/2021 0/0 000 B 61 The Godfather 62 One in a Million 63 One in a Million a 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 73 We Fry it All 74 The Godfather 75 Wok Delight 76 One in a Million 77 Planet of the Grapes 78 Brewed Miracles 79 Tequila Taste 80 One in a Million 81 Pita Pan 82 The Godfather 83 One in a Million 84 Thai Tap 85 Grandma's Greasy Spoon 86 Tequila Taste 87 Planet of the Grapes 88 We Fry it All 89 Thai Tap 90 Grandma's Greasy Spoon 91 Wok Delight 92 Pita Pan 93 Tequila Taste 94 Wok Delight 06 Soul Salad Sheet1 129.08 180.42 218.29 83.27 297.8 363.68 449.46 121.66 463.07 386.33 435.44 124.53 293.65 333.08 113.31 86.04 256.71 153.94 121.82 346.05 474.9 156.21 295.83 419.99 135.53 175.47 296.67 403.37 137.21 466.73 135.52 210.66 235.76 279.39 24207 9/6/2021 9/6/2021 9/6/2021 9/8/2021 9/8/2021 9/8/2021 9/8/2021 9/10/2021 9/10/2021 9/11/2021 9/11/2021 9/12/2021 9/15/2021 9/15/2021 9/16/2021 9/17/2021 9/20/2021 9/23/2021 9/24/2021 9/25/2021 9/27/2021 9/28/2021 9/28/2021 9/28/2021 9/29/2021 9/29/2021 9/29/2021 9/29/2021 9/30/2021 9/30/2021 10/3/2021 10/3/2021 10/3/2021 10/3/2021 1021 B A 88 We Fry it All 89 Thai Tap 90 Grandma's Greasy Spoon 91 Wok Delight 92 Pita Pan 93 Tequila Taste 94 Wok Delight 95 Soup 'r Salad 96 Brewed Miracles 97 Brewed Miracles 98 Pita Pan 99 Tequila Taste 100 Planet of the Grapes 101 Tequila Taste 102 Wok Delight 103 Thai Tap 104 Wok Delight 105 Brewed Miracles 106 Taste of Thai 107 Pita Pan 108 Pita Pan 109 Brewed Miracles 110 Grandma's Greasy Spoor 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 Spoor 119 Planet of the Grapes 120 One in a Million 121 Tequila Taste 12 Tamil act Sheet1 403.37 9/29/2021 137.21 9/30/2021 466.73 9/30/2021 135.52 10/3/2021 210.66 10/3/2021 235.76 10/3/2021 279.39 10/3/2021 243.97 10/4/2021 372.58 10/5/2021 411.63 10/5/2021 421.4 10/6/2021 481.53 10/6/2021 86.54 10/8/2021 139.95 10/8/2021 364.57 10/8/2021 282.43 10/9/2021 340.19 10/9/2021 87.35 10/10/2021 241.31 10/10/2021 282.74 10/10/2021 137.64 10/12/2021 239.22 10/12/2021 379.87 10/12/2021 427.37 10/13/2021 76.99 10/16/2021 236.81 10/16/2021 274.98 10/16/2021 197.56 10/18/2021 176.1 10/19/2021 217.37 10/19/2021 304.32 10/19/2021 182.14 10/20/2021 270.09 10/20/2021 289.5 10/20/2021 15520 1010/2011 React B 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 Spoor 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 147 Thai Tap 148 Wok Delight 149 One in a Million 150 Wok Delight 151 Tequila Taste 1152 ts Da Sheet1 C 304.32 10/19/2021 182.14 10/20/2021 270.09 10/20/2021 289.5 10/20/2021 455.29 10/20/2021 345.41 10/21/2021 228.17 10/22/2021 137.09 10/23/2021 365.47 10/23/2021 367.17 10/23/2021 116.37 10/24/2021 351.37 10/24/2021 233.57 10/25/2021 316.33 10/25/2021 378.44 10/26/2021 108.36 10/29/2021 246.99 10/29/2021 331.45 10/30/2021 337.14 10/30/2021 228.37 10/31/2021 108.87 11/3/2021 406.68 11/3/2021 501.78 11/3/2021 489.69 11/4/2021 146.61 11/5/2021 413.67 11/6/2021 367.76 11/9/2021 331.28 11/10/2021 351.22 11/11/2021 450.57 11/11/2021 137.18 11/13/2021 478.15 11/13/2021 231.43 11/15/2021 326.47 11/15/2021 1112001 2nzar Ready B 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 Spoor 170 Thal 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 12onin Milli Sheet1 137.18 11/13/2021 478.15 11/13/2021 231.43 11/15/2021 326.47 11/15/2021 343.96 11/15/2021 412.24 11/15/2021 319.79 11/16/2021 174.26 11/17/2021 190.37 11/18/2021 433.62 11/18/2021 461.72 11/18/2021 434.34 11/19/2021 354.16 11/21/2021 108.52 11/22/2021 475.93 11/22/2021 112.1 11/23/2021 105.68 11/24/2021 110.6 11/24/2021 372.54 11/25/2021 232.33 11/26/2021 352.31 11/27/2021 355.08 11/27/2021 471.92 11/27/2021 487.24 11/28/2021 319.02 11/29/2021 408.65 11/29/2021 102.88 11/30/2021 125.87 12/2/2021 334.91 12/2/2021 459.66 12/2/2021 78.59 12/3/2021 204.09 12/3/2021 218.76 12/3/2021 91.18 12/6/2021 125 1 12/16/2021 B [170 Thai Tap 171 One in a Million a 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 One in a Million 183 The Godfather 184 The Godfather 185 Brewed Miracles 186 Pita Pan 187 Wok Delight 188 Soup 'r Salad 189 Wok Delight 190 Taste of Thai 191 Thai Tap 192 Brewed Miracles 193 Pita Pan 194 We Fry it All 195 One in a Million 196 Pita Pan 197 Wok Delight 198 Brewed Miracles 199 We Fry it All 200 Thai Tap 201 We Fry it All 202 471.92 11/27/2021 487.24 11/28/2021 319.02 11/29/2021 408.65 11/29/2021 102.88 11/30/2021 125.87 12/2/2021 334.91 12/2/2021 459.66 12/2/2021 78.59 12/3/2021 204.09 12/3/2021 218.76 12/3/2021 91.18 12/6/2021 125.14 12/6/2021 436.62 12/6/2021 87.37 12/8/2021 257.38 12/8/2021 394.56 12/8/2021 387.63 12/11/2021 339.42 12/12/2021 469.88 12/12/2021 278.25 12/13/2021 340.4 12/13/2021 219.35 12/14/2021 266.82 12/14/2021 327.29 12/14/2021 103.84 12/15/2021 249.04 12/15/2021 419.69 12/16/2021 461.4 12/16/2021 345.81 12/18/2021 480.75 12/20/2021 482.44 12/22/2021 203 B 1 Customer InvoiceAmount Due Date 2 We Fry it All 269.65 7/21/2021 3 We Fry it All 456.16 7/22/2021 4 Taste of Thai 157.11 7/25/2021 5 Grandma's Greasy Spoor 243.05 7/25/2021 6 Brewed Miracles 127.75 7/26/2021 7 Grandma's Greasy Spool 416.56 7/27/2021 8 Taste of Thai 492.93 7/27/2021 9 Pita Pan 98.73 7/28/2021 10 We Fry it All 370.26 7/30/2021 11 We Fry it All 235.79 8/1/2021 12 Wok Delight 96.39 8/2/2021 13 One in a Million 372.13 8/2/2021 14 Tequila Taste 100.78 8/4/2021 15 We Fry it All 217.81 8/5/2021 16 Pita Pan 320.1 8/6/2021 17 Pita Pan 480.96 8/6/2021 18 One in a Million a 256.1 8/8/2021 19 Planet of the Grapes 487.73 8/9/2021 20 Grandma's Greasy Spoon 160.61 8/10/2021 21 Pita Pan 450.77 8/10/2021 22 Wok Delight 168.81 8/11/2021 23 Wok Delight 261.41 8/11/2021 24 Taste of Thal 221.42 8/12/2021 25 Tequila Taste 268.95 8/13/2021 26 The Godfather 220.19 8/14/2021 27 The Godfather 492.03 8/14/2021 28 Wok Delight 206.37 8/15/2021 29 Tequila Taste 475.72 8/15/2021 30 Tequila Taste 250.48 8/16/2021 31 Brewed Miracles 270.87 8/16/2021 32 Soup'r Salad 96.17 8/17/2021 33 Taste of Thai 130.84 8/17/2021 34 Taste of Thai 299.84 8/17/2021 25 Mlak natiaht 80001 10021 Sheet1 In this lab, you will: Required: 1. Age the recelvables in six 30-day buckets (similar to Lab 6-1 above), including 1-30 days, 31-60 days. 61-90 days, 91-120 days, 121-150 days, and 151-180 days 2. Detail the receivables from the 151-180 days bucket Ask the Question: How can we age receivables using Excel pivottables? Master the Data: Apply the same steps as Lab 6-1 to the Lab 6-1 Alt Data.xlsx dataset, Software needed Excel Screen capture tool (Windows: Snipping Tool: Mac: Cmd+Shift+4) . Data: Excel File Lab 6-1 Alt Data xlsx Perform the Analysis: Refer to Lab 6-1 Alternate in the text for instructions and Lab 6-1 steps for each the of lab parts Share the Story: Now that you have aged the receivables, the company is better able to estimate its allowance for doubtful accounts (the contra receivable accounts that reduces gross accounts receivable into net accounts receivable). As a rule, as accounts receivable age, they are less likely to be collected, Required: 1. What is the gross amount of receivables owed? O $53,179.57 O $34,499.08 O $37.732.45 O Cannot be determined O $56,381.41 2. What is the total receivables due in the 31-60 day A/R aging bucket? $11.880.62 O $12,574.47 $11,499.66 O $7,986.14 3. Accountants and auditors age receivables to primarily do which task? To help estimate the allowance for doubtful accounts O To determine the most profitable products O To help estimate the total amount of gross receivables To determine the most profitable customers 4. What is the total receivables due in the 151-180 day A/R aging bucket? O $3,336.51 O $7,986.14 O $11,499.66 O $9,104.01 5. In the detailed 151-180 A/R aging bucket, what is the amount owed by the customer named Brewed Miracles? O $372.13 $1,331.86 $12775 O $659.61 32 Soup 'r Salad 33 Taste of Thai 34 Taste of Thai 35 Wok Delight 36 Pita Pan 37 Brewed Miracles 38 One in a Million 39 Tequila Taste 40 One in a Million 41 Grandma's Greasy Spoor 42 Planet of the Grapes 43 The Godfather 44 Tequila Taste 45 Thai Tap 46 The Godfather 47 Thai Tap 48 Grandma's Greasy Spoot 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 One in a Million 63 One in a Million 64 We Fry it All 65 Brewed Miracles hur Coun salad Sheet1 96.17 130.84 299.84 480.01 77.93 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 8/17/2021 8/17/2021 8/17/2021 8/18/2021 8/19/2021 8/20/2021 8/20/2021 8/20/2021 8/20/2021 8/21/2021 8/21/2021 8/21/2021 8/21/2021 8/23/2021 8/23/2021 8/24/2021 8/25/2021 8/28/2021 8/28/2021 8/29/2021 8/30/2021 8/31/2021 9/1/2021 9/1/2021 9/4/2021 9/4/2021 9/4/2021 9/5/2021 9/5/2021 9/6/2021 9/6/2021 9/6/2021 9/8/2021 9/8/2021 0/0 000 B 61 The Godfather 62 One in a Million 63 One in a Million a 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 73 We Fry it All 74 The Godfather 75 Wok Delight 76 One in a Million 77 Planet of the Grapes 78 Brewed Miracles 79 Tequila Taste 80 One in a Million 81 Pita Pan 82 The Godfather 83 One in a Million 84 Thai Tap 85 Grandma's Greasy Spoon 86 Tequila Taste 87 Planet of the Grapes 88 We Fry it All 89 Thai Tap 90 Grandma's Greasy Spoon 91 Wok Delight 92 Pita Pan 93 Tequila Taste 94 Wok Delight 06 Soul Salad Sheet1 129.08 180.42 218.29 83.27 297.8 363.68 449.46 121.66 463.07 386.33 435.44 124.53 293.65 333.08 113.31 86.04 256.71 153.94 121.82 346.05 474.9 156.21 295.83 419.99 135.53 175.47 296.67 403.37 137.21 466.73 135.52 210.66 235.76 279.39 24207 9/6/2021 9/6/2021 9/6/2021 9/8/2021 9/8/2021 9/8/2021 9/8/2021 9/10/2021 9/10/2021 9/11/2021 9/11/2021 9/12/2021 9/15/2021 9/15/2021 9/16/2021 9/17/2021 9/20/2021 9/23/2021 9/24/2021 9/25/2021 9/27/2021 9/28/2021 9/28/2021 9/28/2021 9/29/2021 9/29/2021 9/29/2021 9/29/2021 9/30/2021 9/30/2021 10/3/2021 10/3/2021 10/3/2021 10/3/2021 1021 B A 88 We Fry it All 89 Thai Tap 90 Grandma's Greasy Spoon 91 Wok Delight 92 Pita Pan 93 Tequila Taste 94 Wok Delight 95 Soup 'r Salad 96 Brewed Miracles 97 Brewed Miracles 98 Pita Pan 99 Tequila Taste 100 Planet of the Grapes 101 Tequila Taste 102 Wok Delight 103 Thai Tap 104 Wok Delight 105 Brewed Miracles 106 Taste of Thai 107 Pita Pan 108 Pita Pan 109 Brewed Miracles 110 Grandma's Greasy Spoor 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 Spoor 119 Planet of the Grapes 120 One in a Million 121 Tequila Taste 12 Tamil act Sheet1 403.37 9/29/2021 137.21 9/30/2021 466.73 9/30/2021 135.52 10/3/2021 210.66 10/3/2021 235.76 10/3/2021 279.39 10/3/2021 243.97 10/4/2021 372.58 10/5/2021 411.63 10/5/2021 421.4 10/6/2021 481.53 10/6/2021 86.54 10/8/2021 139.95 10/8/2021 364.57 10/8/2021 282.43 10/9/2021 340.19 10/9/2021 87.35 10/10/2021 241.31 10/10/2021 282.74 10/10/2021 137.64 10/12/2021 239.22 10/12/2021 379.87 10/12/2021 427.37 10/13/2021 76.99 10/16/2021 236.81 10/16/2021 274.98 10/16/2021 197.56 10/18/2021 176.1 10/19/2021 217.37 10/19/2021 304.32 10/19/2021 182.14 10/20/2021 270.09 10/20/2021 289.5 10/20/2021 15520 1010/2011 React B 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 Spoor 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 147 Thai Tap 148 Wok Delight 149 One in a Million 150 Wok Delight 151 Tequila Taste 1152 ts Da Sheet1 C 304.32 10/19/2021 182.14 10/20/2021 270.09 10/20/2021 289.5 10/20/2021 455.29 10/20/2021 345.41 10/21/2021 228.17 10/22/2021 137.09 10/23/2021 365.47 10/23/2021 367.17 10/23/2021 116.37 10/24/2021 351.37 10/24/2021 233.57 10/25/2021 316.33 10/25/2021 378.44 10/26/2021 108.36 10/29/2021 246.99 10/29/2021 331.45 10/30/2021 337.14 10/30/2021 228.37 10/31/2021 108.87 11/3/2021 406.68 11/3/2021 501.78 11/3/2021 489.69 11/4/2021 146.61 11/5/2021 413.67 11/6/2021 367.76 11/9/2021 331.28 11/10/2021 351.22 11/11/2021 450.57 11/11/2021 137.18 11/13/2021 478.15 11/13/2021 231.43 11/15/2021 326.47 11/15/2021 1112001 2nzar Ready B 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 Spoor 170 Thal 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 12onin Milli Sheet1 137.18 11/13/2021 478.15 11/13/2021 231.43 11/15/2021 326.47 11/15/2021 343.96 11/15/2021 412.24 11/15/2021 319.79 11/16/2021 174.26 11/17/2021 190.37 11/18/2021 433.62 11/18/2021 461.72 11/18/2021 434.34 11/19/2021 354.16 11/21/2021 108.52 11/22/2021 475.93 11/22/2021 112.1 11/23/2021 105.68 11/24/2021 110.6 11/24/2021 372.54 11/25/2021 232.33 11/26/2021 352.31 11/27/2021 355.08 11/27/2021 471.92 11/27/2021 487.24 11/28/2021 319.02 11/29/2021 408.65 11/29/2021 102.88 11/30/2021 125.87 12/2/2021 334.91 12/2/2021 459.66 12/2/2021 78.59 12/3/2021 204.09 12/3/2021 218.76 12/3/2021 91.18 12/6/2021 125 1 12/16/2021 B [170 Thai Tap 171 One in a Million a 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 One in a Million 183 The Godfather 184 The Godfather 185 Brewed Miracles 186 Pita Pan 187 Wok Delight 188 Soup 'r Salad 189 Wok Delight 190 Taste of Thai 191 Thai Tap 192 Brewed Miracles 193 Pita Pan 194 We Fry it All 195 One in a Million 196 Pita Pan 197 Wok Delight 198 Brewed Miracles 199 We Fry it All 200 Thai Tap 201 We Fry it All 202 471.92 11/27/2021 487.24 11/28/2021 319.02 11/29/2021 408.65 11/29/2021 102.88 11/30/2021 125.87 12/2/2021 334.91 12/2/2021 459.66 12/2/2021 78.59 12/3/2021 204.09 12/3/2021 218.76 12/3/2021 91.18 12/6/2021 125.14 12/6/2021 436.62 12/6/2021 87.37 12/8/2021 257.38 12/8/2021 394.56 12/8/2021 387.63 12/11/2021 339.42 12/12/2021 469.88 12/12/2021 278.25 12/13/2021 340.4 12/13/2021 219.35 12/14/2021 266.82 12/14/2021 327.29 12/14/2021 103.84 12/15/2021 249.04 12/15/2021 419.69 12/16/2021 461.4 12/16/2021 345.81 12/18/2021 480.75 12/20/2021 482.44 12/22/2021 203 B 1 Customer InvoiceAmount Due Date 2 We Fry it All 269.65 7/21/2021 3 We Fry it All 456.16 7/22/2021 4 Taste of Thai 157.11 7/25/2021 5 Grandma's Greasy Spoor 243.05 7/25/2021 6 Brewed Miracles 127.75 7/26/2021 7 Grandma's Greasy Spool 416.56 7/27/2021 8 Taste of Thai 492.93 7/27/2021 9 Pita Pan 98.73 7/28/2021 10 We Fry it All 370.26 7/30/2021 11 We Fry it All 235.79 8/1/2021 12 Wok Delight 96.39 8/2/2021 13 One in a Million 372.13 8/2/2021 14 Tequila Taste 100.78 8/4/2021 15 We Fry it All 217.81 8/5/2021 16 Pita Pan 320.1 8/6/2021 17 Pita Pan 480.96 8/6/2021 18 One in a Million a 256.1 8/8/2021 19 Planet of the Grapes 487.73 8/9/2021 20 Grandma's Greasy Spoon 160.61 8/10/2021 21 Pita Pan 450.77 8/10/2021 22 Wok Delight 168.81 8/11/2021 23 Wok Delight 261.41 8/11/2021 24 Taste of Thal 221.42 8/12/2021 25 Tequila Taste 268.95 8/13/2021 26 The Godfather 220.19 8/14/2021 27 The Godfather 492.03 8/14/2021 28 Wok Delight 206.37 8/15/2021 29 Tequila Taste 475.72 8/15/2021 30 Tequila Taste 250.48 8/16/2021 31 Brewed Miracles 270.87 8/16/2021 32 Soup'r Salad 96.17 8/17/2021 33 Taste of Thai 130.84 8/17/2021 34 Taste of Thai 299.84 8/17/2021 25 Mlak natiaht 80001 10021 Sheet1

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Inventory Best Practices

Authors: Steven M. Bragg

2nd Edition

1118000749, 9781118000748

More Books

Students also viewed these Accounting questions