AUDIT
bamberry
3 years ago
1
files (2)ACCT444-CourseProject.docx
ACCT444CD1Exhibits.docx
ACCT444-CourseProject.docx
Task #1
Green, CPA, is completing audit procedures for the December 31, year 4, audit of JBU Co., a non-issuer (not a public corporation). An auditor from Green attended the physical inventory observation at year-end. JBU Co. maintains a perpetual inventory system integrated with its general ledger. The auditor noted some issues that require further investigation while reviewing JBU's inventory count sheets and warehouse location maps.
The source documents examined by the auditor are in this file ACCT444CD#1Exhibits.docx (FILE ATTACHED)
The auditor established the following information relating to the inventory count and product lines of JBU.
· There was no product movement on the day of the count.
· The loading dock is part of Warehouse A for the purposes of the count.
· All product lines within each storage area are on the warehouse maps.
· The warehouse map is reflective of the warehouse on the day of the count.
· Inventory values in the perpetual inventory listing are the most recent purchase price.
· Materiality for year-end audit $8,000
· Performance materiality: $5,000
Complete the inventory tasks below by using the information provided in the exhibits:
1. In column B, quantify the required adjustment, if any, to the product line in the perpetual inventory system.
· Enter increases to the perpetual inventory listing as positive whole dollars.
· Enter decreases to the perpetual inventory listing as negative whole do
· If no adjustment to the perpetual inventory listing is required, enter a zero (0).
2. In column C, select the justification for the required audit adjustment, or the reason why no audit adjustment is required, by selecting from the option list provided. A justification is once, more than once, or not used at all.
Assume that there is only one reason for each product line discrepancy
Choices for the Justification
|
Task #2
Based on the work performed above, select from the option list provided a conclusion on the ending inventory balance. Assume that the auditor performed any follow-up procedures to confirm the initial reasons for the differences identified and therefore any adjustments required are accurate and there are no other adjustments to consider other than those above.
Choices for the Conclusion:
image1.png
image2.png
ACCT444CD1Exhibits.docx
ACCT444 – Course Project Exhibits – Deliverable #1
#1 – Letter from the Controller
From: [email protected]
Date: January 11 year 5
Subject: Re: Returns
Auditor,
Please see my response to your question inline below. Also, it should be noted that on closer look, there is an issue with the physical counts of the 5mm widgets. The perpetual records are correct. This has been validated by your associate, Lily. Lastly, it looks like the perpetual inventory listing includes 750 units of SKU 267-1 that have been consigned.
Thanks,
Controller
#2 – Email from the Auditor
From: [email protected]
Date: January 10, year 5
Subject: Returns
Hi,
Can you please tell me whether the items in the returns area have been included in the count?
Thanks,
Auditor
[Controller] Yes, the counts are correct and returns have been included in the counts. However, they would not yet have been processed in the perpetual inventory system.
#3 – Inventory Count Sheets
|
Inventory Count Sheet [Warehouse A] |
|
|
267-4 |
4,098 |
|
490-2 |
541 |
|
267-3 |
-- |
|
561-3 |
7,975 |
|
290-1 |
121 |
|
583-5 |
-- |
|
671-0 |
2,683 |
|
267-1 |
131 |
|
352-2 |
20 |
|
Inventory Count Sheet [Warehouse B] |
|
|
267-4 |
-- |
|
490-2 |
491 |
|
267-3 |
5 |
|
561-3 |
1,950 |
|
290-1 |
800 |
|
583-5 |
150 |
|
671-0 |
10,188 |
|
267-1 |
119 |
|
352-2 |
136 |
#4 – Supplier Report: Widget-Wiz Co
SKU 267-3
On September 25, year 4, JBU acquired 100 units of SKU 267-3 with a unit price of $7.99. Subsequent to this acquisition, JBU sold a total of 25 units of 267-3 to third parties for $11.99, and utilized 70 units of the product in the manufacture of equipment being held for sale in warehouse B.
SKU 267-5
The company has not made a purchase of SKU 267-5 subsequent to February, year 3. In prior years, JBU had a regular customer for this product line but during year 3, this customer became insolvent.
SKU 267-1
In March, year 4, JBU purchased 5,000 units of SKU 267-1. Half of the units had been used in the manufacture of equipment that has subsequently been sold. A further 30% of the units were sold to third parties during year 4, and 5% of the units are in ending inventory. The remaining 15% of the units were provided to a customer on a consignment basis. As of December 31, year 4, all of the consigned goods were sold by the customer.
SKU 267-4
In December, year 3, the company acquired 10,000 units of SKU 267-4 at a price of $1.56 per unit. During year 4, the company sold 5,898 units of the product to third parties. The last sale was made in November, year 4, with shipment that same month.
#5 – Perpetual Inventory Listing
|
Perpetual Inventory Listing |
|||||
|
Product |
SKU |
Last purchase date |
Last purchase item cost ($) |
Item Count |
Inventory Value ($) |
|
Wrenches |
583-5 |
6/3/year 4 |
12.78 |
150 |
1,917.00 |
|
Widgets - 10mm |
267-1 |
3/8/year 4 |
4.99 |
1,000 |
4,990.00 |
|
Bolts - ¾ inch |
490-2 |
1/1/year 1 |
3.28 |
1,032 |
3,384.96 |
|
Flat washers |
671-0 |
12/26/year 4 |
2.60 |
12,871 |
33,464.60 |
|
Widgets - 20mm |
267-3 |
9/25/year 4 |
7.99 |
5 |
39.95 |
|
Hex bolts |
561-3 |
9/30/year 3 |
12.89 |
9,875 |
127,288.75 |
|
Widgets - 15mm |
267-5 |
2/7/year 3 |
6.78 |
-- |
-- |
|
Widgets - 5mm |
267-4 |
12/28/year 3 |
1.56 |
4,102 |
6,399.12 |
|
Copper coil |
290-1 |
10/15/year 4 |
3.77 |
921 |
3,472.17 |
|
Large plates |
352-2 |
4/16/year 4 |
10.89 |
156 |
1,698.84 |
|
Total |
182,655.39 |
#6 – Memo from Staff Accountant
To: JBU, Co. Audit File
From: Lily, Staff Auditor
Date: December 31, year 4
Subject: SKU 267-4 Widgets - 5mm
I met with the controller of JBU, Co. on December 31, year 4, to resolve discrepancies between the perpetual inventory listing for SKU 267-4 and the count sheets prepared during the inventory observation. I then visited the warehouse again with the controller to perform a recount of these items. I counted 4,102 units of SKU 267-4. I validated that the perpetual inventory listing for SKU 267-4 was correct and the initial count reflected on the inventory count sheet was incorrect.
image1.png
ACCT444-CourseProject.docx
Task #1
Green, CPA, is completing audit procedures for the December 31, year 4, audit of JBU Co., a non-issuer (not a public corporation). An auditor from Green attended the physical inventory observation at year-end. JBU Co. maintains a perpetual inventory system integrated with its general ledger. The auditor noted some issues that require further investigation while reviewing JBU's inventory count sheets and warehouse location maps.
The source documents examined by the auditor are in this file ACCT444CD#1Exhibits.docx (FILE ATTACHED)
The auditor established the following information relating to the inventory count and product lines of JBU.
· There was no product movement on the day of the count.
· The loading dock is part of Warehouse A for the purposes of the count.
· All product lines within each storage area are on the warehouse maps.
· The warehouse map is reflective of the warehouse on the day of the count.
· Inventory values in the perpetual inventory listing are the most recent purchase price.
· Materiality for year-end audit $8,000
· Performance materiality: $5,000
Complete the inventory tasks below by using the information provided in the exhibits:
1. In column B, quantify the required adjustment, if any, to the product line in the perpetual inventory system.
· Enter increases to the perpetual inventory listing as positive whole dollars.
· Enter decreases to the perpetual inventory listing as negative whole do
· If no adjustment to the perpetual inventory listing is required, enter a zero (0).
2. In column C, select the justification for the required audit adjustment, or the reason why no audit adjustment is required, by selecting from the option list provided. A justification is once, more than once, or not used at all.
Assume that there is only one reason for each product line discrepancy
Choices for the Justification
|
Task #2
Based on the work performed above, select from the option list provided a conclusion on the ending inventory balance. Assume that the auditor performed any follow-up procedures to confirm the initial reasons for the differences identified and therefore any adjustments required are accurate and there are no other adjustments to consider other than those above.
Choices for the Conclusion:
