SUM of Outstanding balance Status Customer C1003 C1004 C1006 C1010 C1012 C1013 C1026 C1028 C1029 C1036 C1037 C1045 C1048 C1051 C1055 C1057 C1058 C1061 C1066 C1069 C1075 C1076 C1082 C1085 Grand Total 0-Not Yet Due 30831 30831 1-30 Days 25579 3156 2353 31088 31-60 Days 61-90 Days 90+ Days 11791 26748 10460 29297 25315 103611 25245 24713 49958 9367 4115 1659 18793 12116 22957 20307 7791 30907 12102 12235 22997 25366 200712 Grand Total 9367 25245 30831 24713 11791 26748 4115 1659 18793 10460 12116 22957 20307 25579 7791 3156 30907 12102 12235 2353 22997 29297 25366 25315 416200

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Question
F
SUM of Outstanding balance Status
Customer
C1003
C1004
C1006
C1010
C1012
C1013
C1026
C1028
C1029
C1036
C1037
C1045
C1048
C1051
G
C1055
C1057
C1058
C1061
C1066
C1069
C1075
C1076
C1082
C1085
Grand Total
H
0-Not Yet Due
30831
30831
I
1-30 Days
25579
3156
2353
31088
J
11791
26748
31-60 Days 61-90 Days 90+ Days
9367
10460
29297
K
25315
103611
25245
24713
L
49958
4115
1659
18793
12116
22957
20307
7791
30907
12102
12235
22997
25366
200712
M
Grand Total
9367
25245
30831
24713
11791
26748
4115
1659
18793
10460
12116
22957
20307
25579
7791
3156
30907
12102
12235
2353
22997
29297
25366
25315
416200
N
Transcribed Image Text:F SUM of Outstanding balance Status Customer C1003 C1004 C1006 C1010 C1012 C1013 C1026 C1028 C1029 C1036 C1037 C1045 C1048 C1051 G C1055 C1057 C1058 C1061 C1066 C1069 C1075 C1076 C1082 C1085 Grand Total H 0-Not Yet Due 30831 30831 I 1-30 Days 25579 3156 2353 31088 J 11791 26748 31-60 Days 61-90 Days 90+ Days 9367 10460 29297 K 25315 103611 25245 24713 L 49958 4115 1659 18793 12116 22957 20307 7791 30907 12102 12235 22997 25366 200712 M Grand Total 9367 25245 30831 24713 11791 26748 4115 1659 18793 10460 12116 22957 20307 25579 7791 3156 30907 12102 12235 2353 22997 29297 25366 25315 416200 N
What is the dollar amount of total receivables? Use
a cell reference to input your answer.
What cell displays this total receivables balance? M41
(Include the reference, i.e. B2)
Which aging bucket's amount is the greatest?
Which specific customer accounts require
management's attention? List the customer
numbers.
*Not all of the following cells must be filled.
Do
http
Transcribed Image Text:What is the dollar amount of total receivables? Use a cell reference to input your answer. What cell displays this total receivables balance? M41 (Include the reference, i.e. B2) Which aging bucket's amount is the greatest? Which specific customer accounts require management's attention? List the customer numbers. *Not all of the following cells must be filled. Do http
Expert Solution
steps

Step by step

Solved in 3 steps

Blurred answer
Follow-up Questions
Read through expert solutions to related follow-up questions below.
Follow-up Question

Why did you select those customer accounts? 

also how to use a cell reference to enterthe answer for the 1st question? ( Whatis the dollar amount of total receivables? Use a cell reference to input your answer)

Solution
Bartleby Expert
SEE SOLUTION
Knowledge Booster
Completing the Accounting Cycle
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education