Apply the same steps as Lab 1 performed in the chapter text to the Lab 1 Alt Data.xlsx dataset. Open Excel File Lab 1 Alt Data.xlsx

Required: 

Age the receivables in six 30-day buckets including 1–30 days, 31–60 days, 61–90 days, 91–120 days, 121–150 days, and 151–180 days. Detail the receivables from the 31–60 day bucket.

Assessment:
1. Perform the analysis, and take a screenshot of your aged receivables; label it “Lab 1 Alt Submission 1.jpg”. Submit to your instructor.
2. Take a screenshot of your detailed receivables in the 31–60 day aging bucket, and label it “Lab 1 Alt Submission 2.jpg”. Submit it to your instructor.
3. Answer the multiple choice questions.
1. What is the gross amount of receivables owed?
a. $53,179.57
b. $37,732.45
c. $56,381.41
d. $34,499.08
e. Cannot be determined
2. What is the total receivables due in the 31–60 day A/R aging bucket?
a. $11,880.62
b. $11,499.66
c. $7,986.14
d. $12,574.47
3. Accountants and auditors age receivables to primarily do which task?
a. Determine the most profitable products
b. Determine the most profitable customers
c. Help estimate the total amount of gross receivables
d. Help estimate the allowance for doubtful accounts
4. What is the total receivables due in the 151–180 day A/R aging bucket?
a. $3,336.51
b. $11,499.66
c. $7,986.14
d. $9,104.01
5. In the detailed 31-60 A/R aging bucket, what is the amount owed by the customer named Nin Com Soup?
a. $96.17
b. $112.10
c. $164.42
d. $419.62