2. What is the total receivables due in the 31-60 day A/R aging bucket? $11,499.66 $7,986.14 $11,880.62 $12,574,47 3. Accountants and auditors age receivables to primarily do which task? To help estimate the allowance for doubtful accounts To help estimate the total amount of gross receivables To determine the most profitable customers To determine the most profitable products 4. What is the total receivables due in the 151180 day A/R aging bucket? $11,499.66 $7,986.14 $9,104.01 $3,336.51 5. In the detailed 151-180 A/R aging bucket, what is the amount owed by the customer named Brewed Miracles? $372.13 $12775 $659.61 $1,331.86 \begin{tabular}{|l|r|r|} \hline \multicolumn{1}{l}{ InvoiceAmount } & Due Date \\ \hline Customer & 269.65 & 7/21/21 \\ \hline We Fry it All & 456.16 & 7/22/21 \\ \hline We Fry it All & 157.11 & 7/25/21 \\ \hline Taste of Thai & 243.05 & 7/25/21 \\ \hline Grandma's Greasy Spoon & 127.75 & 7/26/21 \\ \hline Brewed Miracles & 416.56 & 7/27/21 \\ \hline Grandma's Greasy Spoon & 492.93 & 7/27/21 \\ \hline Taste of Thai & 98.73 & 7/28/21 \\ \hline Pita Pan & 370.26 & 7/30/21 \\ \hline We Fry it All & 235.79 & 8/1/21 \\ \hline We Fry it All & 96.39 & 8/2/21 \\ \hline Wok Delight & 372.13 & 8/2/21 \\ \hline One in a Million & 100.78 & 8/4/21 \\ \hline Tequila Taste & 217.81 & 8/5/21 \\ \hline We Fry it All & 320.1 & 8/6/21 \\ \hline Pita Pan & 480.96 & 8/6/21 \\ \hline Pita Pan & 256.1 & 8/8/21 \\ \hline One in a Million & 487.73 & 8/9/21 \\ \hline Planet of the Grapes & 160.61 & 8/10/21 \\ \hline Grandma's Greasy Spoon & 450.77 & 8/10/21 \\ \hline Pita Pan & 168.81 & 8/11/21 \\ \hline Wok Delight & & \\ \hline \end{tabular} \begin{tabular}{lrr} \hline Wok Delight & 261.41 & 8/11/21 \\ \hline Taste of Thai & 221.42 & 8/12/21 \\ \hline Tequila Taste & 268.95 & 8/13/21 \\ \hline The Godfather & 220.19 & 8/14/21 \\ \hline The Godfather & 492.03 & 8/14/21 \\ \hline Wok Delight & 206.37 & 8/15/21 \\ \hline Tequila Taste & 475.72 & 8/15/21 \\ \hline Tent Size \\ \hline Brewed Miraste & 250.48 & 8/16/21 \\ \hline Soup 'r Salad & 270.87 & 8/16/21 \\ \hline Taste of Thai & 96.17 & 8/17/21 \\ \hline Taste of Thai & 130.84 & 8/17/21 \\ \hline Wok Delight & 299.84 & 8/17/21 \\ \hline Pita Pan & 480.01 & 8/18/21 \\ \hline Brewed Miracles & 77.93 & 8/19/21 \\ \hline One in a Million & 188.93 & 8/20/21 \\ \hline Tequila Taste & 327.58 & 8/20/21 \\ \hline One in a Million & 401.58 & 8/20/21 \\ \hline Planet of the Grapes & 456.44 & 8/20/21 \\ \hline The Godfather & 93.14 & 8/21/21 \\ \hline Tequila Taste & 270.11 & 8/21/21 \\ \hline \end{tabular} \begin{tabular}{lrr} Thai Tap & 248.76 & 8/23/21 \\ \hline The Godfather & 260.56 & 8/23/21 \\ \hline Thai Tap & 393.55 & 8/24/21 \\ \hline Grandma's Greasy Spoon & 202.62 & 8/25/21 \\ \hline Soup 'r Salad & 164.42 & 8/28/21 \\ \hline Thai Tap & 207.96 & 8/28/21 \\ \hline Thai Tap & 97.89 & 8/29/2 \\ \hline Planet of the Grapes \\ \hline Soup 'r Salad & 238.52 & 8/30/21 \\ \hline Thai Tap & 419.62 & 8/31/21 \\ \hline The Godfather & 170.13 & 9/1/21 \\ \hline We Fry it All & 240.24 & 9/1/21 \\ \hline Planet of the Grapes & 146.01 & 9/4/21 \\ \hline Thai Tap & 146.91 & 9/4/21 \\ \hline We Fry it All & 265.42 & 9/4/21 \\ \hline The Godfather & 251.98 & 9/5/21 \\ \hline The Godfather & 374.15 & 9/5/21 \\ \hline One in a Million & 129.08 & 9/6/21 \\ \hline One in a Million & 180.42 & 9/6/21 \\ \hline We Fry it All & 218.29 & 9/6/21 \\ \hline Brewed Miracles & 83.27 & 9/8/21 \\ \hline Soup 'r Salad & 297.8 & 9/8/21 \\ \hline & 363.68 & 9/8/21 \\ \hline \end{tabular} \begin{tabular}{lrc} \hline Thai Tap & & C \\ \hline Grandma's Greasy Spoon & 137.21 & 9/30/21 \\ \hline Wok Delight & 466.73 & 9/30/21 \\ \hline Pita Pan & 135.52 & 10/3/21 \\ \hline Tequila Taste & 210.66 & 10/3/21 \\ \hline Wok Delight & 235.76 & 10/3/21 \\ \hline Soup 'r Salad & 279.39 & 10/3/21 \\ \hline Brewed Miracles & 243.97 & 10/4/21 \\ \hline Brewed Miracles & 372.58 & 10/5/21 \\ \hline Pita Pan & 411.63 & 10/5/21 \\ Tequila Taste & 421.4 & 10/6/21 \\ \hline Planet of the Grapes & 481.53 & 10/6/21 \\ Tequila Taste & 86.54 & 10/8/21 \\ \hline Wok Delight & 139.95 & 10/8/21 \\ Thai Tap & 364.57 & 10/8/21 \\ \hline Wok Delight & 282.43 & 10/9/21 \\ \hline Brewed Miracles & 340.19 & 10/9/21 \\ Taste of Thai & 87.35 & 10/10/21 \\ \hline Pita Pan & 241.31 & 10/10/21 \\ \hline Pita Pan & 282.74 & 10/10/21 \\ \hline Brewed Miracles & 137.64 & 10/12/21 \\ Grandma's Greasy Spoon & 239.22 & 10/12/21 \\ sheet1 + & 379.87 & 10/12/21 \\ \hline \end{tabular} \begin{tabular}{lcr} One in a Million & 406.68 & 11/3/21 \\ \hline Grandma's Greasy Spoon & 501.78 & 11/3/21 \\ \hline Brewed Miracles & 489.69 & 11/4/21 \\ \hline One in a Million & 146.61 & 11/5/21 \\ \hline Taste of Thai & 413.67 & 11/6/21 \\ \hline Tequila Taste & 367.76 & 11/9/21 \\ \hline Planet of the Grapes & 331.28 & 11/10/21 \\ \hline Planet of the Grapes & 351.22 & 11/11/21 \\ \hline Thai Tap & 450.57 & 11/11/21 \\ \hline Wok Delight & 137.18 & 11/13/21 \\ \hline One in a Million & 478.15 & 11/13/21 \\ \hline Wok Delight & 231.43 & 11/15/21 \\ \hline Tequila Taste & 326.47 & 11/15/21 \\ \hline Pita Pan & 343.96 & 11/15/21 \\ \hline The Godfather & 412.24 & 11/15/21 \\ \hline Thai Tap & 319.79 & 11/16/21 \\ \hline Pita Pan & 174.26 & 11/17/21 \\ \hline The Godfather & 190.37 & 11/18/21 \\ \hline One in a Million & 433.62 & 11/18/21 \\ \hline The Godfather & 461.72 & 11/18/21 \\ \hline Planet of the Grapes & 434.34 & 11/19/21 \\ \hline Taste of Thai & 354.16 & 11/21/21 \\ \hline \end{tabular} 2. What is the total receivables due in the 31-60 day A/R aging bucket? $11,499.66 $7,986.14 $11,880.62 $12,574,47 3. Accountants and auditors age receivables to primarily do which task? To help estimate the allowance for doubtful accounts To help estimate the total amount of gross receivables To determine the most profitable customers To determine the most profitable products 4. What is the total receivables due in the 151180 day A/R aging bucket? $11,499.66 $7,986.14 $9,104.01 $3,336.51 5. In the detailed 151-180 A/R aging bucket, what is the amount owed by the customer named Brewed Miracles? $372.13 $12775 $659.61 $1,331.86 \begin{tabular}{|l|r|r|} \hline \multicolumn{1}{l}{ InvoiceAmount } & Due Date \\ \hline Customer & 269.65 & 7/21/21 \\ \hline We Fry it All & 456.16 & 7/22/21 \\ \hline We Fry it All & 157.11 & 7/25/21 \\ \hline Taste of Thai & 243.05 & 7/25/21 \\ \hline Grandma's Greasy Spoon & 127.75 & 7/26/21 \\ \hline Brewed Miracles & 416.56 & 7/27/21 \\ \hline Grandma's Greasy Spoon & 492.93 & 7/27/21 \\ \hline Taste of Thai & 98.73 & 7/28/21 \\ \hline Pita Pan & 370.26 & 7/30/21 \\ \hline We Fry it All & 235.79 & 8/1/21 \\ \hline We Fry it All & 96.39 & 8/2/21 \\ \hline Wok Delight & 372.13 & 8/2/21 \\ \hline One in a Million & 100.78 & 8/4/21 \\ \hline Tequila Taste & 217.81 & 8/5/21 \\ \hline We Fry it All & 320.1 & 8/6/21 \\ \hline Pita Pan & 480.96 & 8/6/21 \\ \hline Pita Pan & 256.1 & 8/8/21 \\ \hline One in a Million & 487.73 & 8/9/21 \\ \hline Planet of the Grapes & 160.61 & 8/10/21 \\ \hline Grandma's Greasy Spoon & 450.77 & 8/10/21 \\ \hline Pita Pan & 168.81 & 8/11/21 \\ \hline Wok Delight & & \\ \hline \end{tabular} \begin{tabular}{lrr} \hline Wok Delight & 261.41 & 8/11/21 \\ \hline Taste of Thai & 221.42 & 8/12/21 \\ \hline Tequila Taste & 268.95 & 8/13/21 \\ \hline The Godfather & 220.19 & 8/14/21 \\ \hline The Godfather & 492.03 & 8/14/21 \\ \hline Wok Delight & 206.37 & 8/15/21 \\ \hline Tequila Taste & 475.72 & 8/15/21 \\ \hline Tent Size \\ \hline Brewed Miraste & 250.48 & 8/16/21 \\ \hline Soup 'r Salad & 270.87 & 8/16/21 \\ \hline Taste of Thai & 96.17 & 8/17/21 \\ \hline Taste of Thai & 130.84 & 8/17/21 \\ \hline Wok Delight & 299.84 & 8/17/21 \\ \hline Pita Pan & 480.01 & 8/18/21 \\ \hline Brewed Miracles & 77.93 & 8/19/21 \\ \hline One in a Million & 188.93 & 8/20/21 \\ \hline Tequila Taste & 327.58 & 8/20/21 \\ \hline One in a Million & 401.58 & 8/20/21 \\ \hline Planet of the Grapes & 456.44 & 8/20/21 \\ \hline The Godfather & 93.14 & 8/21/21 \\ \hline Tequila Taste & 270.11 & 8/21/21 \\ \hline \end{tabular} \begin{tabular}{lrr} Thai Tap & 248.76 & 8/23/21 \\ \hline The Godfather & 260.56 & 8/23/21 \\ \hline Thai Tap & 393.55 & 8/24/21 \\ \hline Grandma's Greasy Spoon & 202.62 & 8/25/21 \\ \hline Soup 'r Salad & 164.42 & 8/28/21 \\ \hline Thai Tap & 207.96 & 8/28/21 \\ \hline Thai Tap & 97.89 & 8/29/2 \\ \hline Planet of the Grapes \\ \hline Soup 'r Salad & 238.52 & 8/30/21 \\ \hline Thai Tap & 419.62 & 8/31/21 \\ \hline The Godfather & 170.13 & 9/1/21 \\ \hline We Fry it All & 240.24 & 9/1/21 \\ \hline Planet of the Grapes & 146.01 & 9/4/21 \\ \hline Thai Tap & 146.91 & 9/4/21 \\ \hline We Fry it All & 265.42 & 9/4/21 \\ \hline The Godfather & 251.98 & 9/5/21 \\ \hline The Godfather & 374.15 & 9/5/21 \\ \hline One in a Million & 129.08 & 9/6/21 \\ \hline One in a Million & 180.42 & 9/6/21 \\ \hline We Fry it All & 218.29 & 9/6/21 \\ \hline Brewed Miracles & 83.27 & 9/8/21 \\ \hline Soup 'r Salad & 297.8 & 9/8/21 \\ \hline & 363.68 & 9/8/21 \\ \hline \end{tabular} \begin{tabular}{lrc} \hline Thai Tap & & C \\ \hline Grandma's Greasy Spoon & 137.21 & 9/30/21 \\ \hline Wok Delight & 466.73 & 9/30/21 \\ \hline Pita Pan & 135.52 & 10/3/21 \\ \hline Tequila Taste & 210.66 & 10/3/21 \\ \hline Wok Delight & 235.76 & 10/3/21 \\ \hline Soup 'r Salad & 279.39 & 10/3/21 \\ \hline Brewed Miracles & 243.97 & 10/4/21 \\ \hline Brewed Miracles & 372.58 & 10/5/21 \\ \hline Pita Pan & 411.63 & 10/5/21 \\ Tequila Taste & 421.4 & 10/6/21 \\ \hline Planet of the Grapes & 481.53 & 10/6/21 \\ Tequila Taste & 86.54 & 10/8/21 \\ \hline Wok Delight & 139.95 & 10/8/21 \\ Thai Tap & 364.57 & 10/8/21 \\ \hline Wok Delight & 282.43 & 10/9/21 \\ \hline Brewed Miracles & 340.19 & 10/9/21 \\ Taste of Thai & 87.35 & 10/10/21 \\ \hline Pita Pan & 241.31 & 10/10/21 \\ \hline Pita Pan & 282.74 & 10/10/21 \\ \hline Brewed Miracles & 137.64 & 10/12/21 \\ Grandma's Greasy Spoon & 239.22 & 10/12/21 \\ sheet1 + & 379.87 & 10/12/21 \\ \hline \end{tabular} \begin{tabular}{lcr} One in a Million & 406.68 & 11/3/21 \\ \hline Grandma's Greasy Spoon & 501.78 & 11/3/21 \\ \hline Brewed Miracles & 489.69 & 11/4/21 \\ \hline One in a Million & 146.61 & 11/5/21 \\ \hline Taste of Thai & 413.67 & 11/6/21 \\ \hline Tequila Taste & 367.76 & 11/9/21 \\ \hline Planet of the Grapes & 331.28 & 11/10/21 \\ \hline Planet of the Grapes & 351.22 & 11/11/21 \\ \hline Thai Tap & 450.57 & 11/11/21 \\ \hline Wok Delight & 137.18 & 11/13/21 \\ \hline One in a Million & 478.15 & 11/13/21 \\ \hline Wok Delight & 231.43 & 11/15/21 \\ \hline Tequila Taste & 326.47 & 11/15/21 \\ \hline Pita Pan & 343.96 & 11/15/21 \\ \hline The Godfather & 412.24 & 11/15/21 \\ \hline Thai Tap & 319.79 & 11/16/21 \\ \hline Pita Pan & 174.26 & 11/17/21 \\ \hline The Godfather & 190.37 & 11/18/21 \\ \hline One in a Million & 433.62 & 11/18/21 \\ \hline The Godfather & 461.72 & 11/18/21 \\ \hline Planet of the Grapes & 434.34 & 11/19/21 \\ \hline Taste of Thai & 354.16 & 11/21/21 \\ \hline \end{tabular}
