Power Bi Assignment (1)

docx

School

Seneca College *

*We aren’t endorsed by this school

Course

340

Subject

Accounting

Date

Nov 24, 2024

Type

docx

Pages

9

Uploaded by ridhimamalhotra1216

Report
Power BI ASSIGNMENT IAF340NJJ Antony Oleynikov: 179215215 Ridhima Malhotra: 144124195 Taylor Kampen: 174655217
Task 1: I. II. III.
IV. V.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
VI. VII.
Task 2: I.
II.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help
III.
Task 3: To: Audit Partner From: Senior Auditor Date: November 24, 2023 Subject: Estimation of Allowance for Bad Debts The first thing to look at when determining the allowance for doubtful accounts is the trend on the amount of credit purchases that people are making. Hannaford’s General Store has had an increase of more than fifty thousand dollars in credit sales in just one year. With the rise of credit sales, comes the uncertainty of whether or not people will pay late, or not pay at all. Another important thing to note about Hannaford’s General Store is that there are only twenty two customers that are paying with credit. Since there aren’t very many, and the company is quite small, the owners will very quickly recognize the customers that do pay on time versus the ones that pay late or haven’t paid. They year end outstanding invoices have a value of $34,604.60k but more than 84% of that amount are invoices that should’ve been paid already, with a lot of them being over a year late. 4 of their customers regularly pay on time, meaning 18 customers regularly pay late, with 8 customers that regularly pay after their invoices have been more than 180 days late. There is also one customer that regularly pays over a year and a half late and this customer (1604-LIFKX) has late invoices with a total $8,265.47k, which is 28% of the total of late invoices. There are only 22 customers paying with credit now but that number is rising, and with that rise comes uncertainty about new customers. By looking at the previous year and what the customers tend to do we can determine the appropriateness of the 3% used for the allowance for doubtful account. It is quite common for invoices to be outstanding and to be paid late, and the records of Hannaford’s General Store show this very clearly. Many of the customers do not pay their invoices on time but will still pay, many are regularly paying late. Their records show that only 4 customers regularly pay on time. For this particular business, I would conclude that the 3% they use in determining the allowance for doubtful account is appropriate. Even though the amount of credit sales has been increasing, since they are a small business they can have better connections with the customers and they probably have a lot of repeat customers, meaning it is quite easy to get an idea of who
will pay and who won’t. The number of credit sales will just cause the amount in allowance for doubtful accounts to increase even though the percentage isn’t changing.
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
  • Access to all documents
  • Unlimited textbook solutions
  • 24/7 expert homework help