Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Task #1) Inventory adjustments. Task #2 Audit opinion on inventory. #1 Letter from the Controller From : controller To : Auditor Date : January 11

Task #1) Inventory adjustments.

Task #2 Audit opinion on inventory.

#1 Letter from the Controller

From: controller

To: Auditor

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: Auditor

To: controller

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.

image text in transcribed

image text in transcribed

#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.

image text in transcribed

#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.

image text in transcribed

#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 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 #5 - Perpetual Inventory Listing Perpetual Inventory Listing Last purchase date Last purchase item cost ($) Inventory Value ($) Product SKU Item Count 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 - 34 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 #7 - Warehouse Map Warehouse A Warehouse B Hex Bolts (561-3) Bolts - 4 inch [490-2] Bolts - % inch [490-2] Widgets - 10mm (267-1] Flat Washers [671-0) Widgets - 20mm [267-3] Hex Bolts (561-3) Flat Washers [671-0] Widgets - 10mm (267-1] Copper Coil (290-1) Wrenches (583-5] Copper Coil [ 290-1] Large Plates (352-2] Widgets - 5mm (267-4) Hex Bolts (561-3] Loading Docks: Returns Area: Hex Bolts (561-3) Large Plates (352-2] Copper Coil (290-1) #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 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 #5 - Perpetual Inventory Listing Perpetual Inventory Listing Last purchase date Last purchase item cost ($) Inventory Value ($) Product SKU Item Count 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 - 34 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 #7 - Warehouse Map Warehouse A Warehouse B Hex Bolts (561-3) Bolts - 4 inch [490-2] Bolts - % inch [490-2] Widgets - 10mm (267-1] Flat Washers [671-0) Widgets - 20mm [267-3] Hex Bolts (561-3) Flat Washers [671-0] Widgets - 10mm (267-1] Copper Coil (290-1) Wrenches (583-5] Copper Coil [ 290-1] Large Plates (352-2] Widgets - 5mm (267-4) Hex Bolts (561-3] Loading Docks: Returns Area: Hex Bolts (561-3) Large Plates (352-2] Copper Coil (290-1)

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Information Technology Control And Audit

Authors: Sandra Senft, Frederick Gallegos, Aleksandra Davis

4th Edition

1439893209, 978-1439893203

More Books

Students also viewed these Accounting questions

Question

10. Is preferred stock more like bonds or common stock? Explain

Answered: 1 week ago