To test the existence of inventory (i.e., "sheet to floor"), enter the quantities from the Inventory Status Report downloaded from the website for the items indicated on Work Paper 5-2. Some inventory items selected for review have already been completed. Please note that the order of the Inventory Status Report and Inventory Count Tag columns is the reverse of Work Paper 5-1 to reflect the change in the order of observation (i.e., switching from "floor to sheet" to "sheet to floor"). Then locate the Inventory Tag in the PDF files downloaded from the website to confirm the existence and accuracy of the inventory item. In an actual inventory observation, the auditor would make selections from the Inventory Status Report and the client would take the auditor to the actual inventory item and the attached count tag. For this exercise, you will vouch the selections from the Inventory Status Report (i.e., the "sheet") to the tag provided in the file above (i.e., the "floor"). Compare the quantity from the Inventory Status Report with the quantity on the tag. For inventory items where the counts differ, briefly describe which management assertion(s) appear to be violated. |
B D E F G H EARTHWEAR CLOTHIERS Inventory Floor to Sheet Test Counts December 31, 2019 5-1 Initial Here 10/12/2019 GERMANY Describe any Violations of Management's Assertions Inventory ID 101-2089 102-5573 102-8637 103-2538 103-7994 104-9326 Description Medium T-shirt M Sweater XL Sweater Photo 5 X 7 Photo 11 X 17 Duffel Bag Quantity on Quantity on Inventory Inventory Count Tags Status Report 32.789 32,789 Enter Qty. Here Enter Qty. Here 94.202 94,202 23,842 23,842 Enter Qty. Here Enter Qty. Here . 7,560 7,560 Difference 0 Enter Tag Count 0 0 Enter Tag Count 0 JAPAN Difference Describe any Violations of Management's Assertions Inventory ID 101-2089 102-5573 102-8637 103-2538 103-7994 104-9326 Description Medium T-shirt M Sweater XL Sweater Photo 5 X7 Photo 11 X 17 Duffel Bag Quantity on Quantity on Inventory Inventory Count Tags Status Report 23.324 23,324 Enter Oty. Here Enter Oty. Here . 19,805 19,805 23,901 23,901 Enter Cty. Here Enter Oty. Here . 18,345 18,345 0 Enter Tag Count 0 0 Enter Tag Count 0 The McGraw-Hill Companies, Inc., 2019 O O O O INVENTORY DATE LOCATION 01/01/2020 GERMANY ITEV INVENTORY DATE LOCATION 01/01/2020 GERMANY INVENTORY DATE LOCATION 01/01/2020 GERMANY ITEM INVENTORY DATE LOCATION 01/03/2020 GERMANY ITEN: 100-2545 101-2089 101-3573 DESCRIPTION FISHING VEST QUANTITY 101-1348 - DESCRIPTION SMALL T-SHIRT QUANTITY DESCRIPTION MEDIUM T-SHIRT QUANTITY DESCRIPTION LARGE T-SHIRT QUANTITY 11894 8349 32789 28239 COUNTED BY TOM JONES COUNTED BY TOM JONES CHECKED BY COUNTED BY TOM JONES COUNTED BY TOM JONES CHECKED BY: Sheila Beton CHECKED BY: CHECKED BY: Sheila Dietor TAG NO 502 TAG NO 541 565 597 TAG NO. TAG NO. O O O O O INVENTORY DATE LOCATION 01/01/2020 GERMANY ITEM ---------------- INVENTORY DATE LOCATION 02/01/2020 GERMANY ITEM INVENTORY DATE LOCATION 01/01/2020 GERMANY ITEM ----------------- INVENTORY DATE LOCATION 01/02/2020 GERMANY ITEM . 102-5573 102-8637 103-2538 103-5037 DESCRIPTION M SWEATER QUANTITY DESCRIPTION XL SUEATER QUANTITY DESCRIPTION PHOTO S X7 QUANTITY DESCRIPTION PHOTO 8 1/2 X 11 QUANTITY 84383 94202 23842 S3838 COUNTED BY: TOM JONES CHECKED BY COUNTED BY: TOM JONES CHECKED BY Sheila Berton COUNTED BY TOM JONES CHECKED BY: Sheila Berton COUNTED BY: TOM JONES CHECKED BY 614 633 747 752 TAG NO. TAG NO TAG NO TAG NO. O O O O INVENTORY DATE LOCATION 01/01/2020 GERMANY ITFU INVENTORY DATE LOCATION 03/01/2020 GERMANY INVENTORY DATE LOCATION 01/01/2020 GERMANY ITEM INVENTORY DATE LOCATION 01/02/2020 GERMANY ITEN 103-7994 104-3501 104-4510 104-9326 DESCRIPTION PHOTO 11 X 17 QUANTITY DESCRIPTION BRIEFCASE QUANTITY DESCRIPTION LARGE SUITCASE QUANTIT DESCRIPTION DUFFEL BAG QUANTITY 9734 84900 19007 7560 COUNTED BY: COUNTED BY: TOM JONES COUNTED BY: TOM JONES CHECKED BY: Sheila Motor COUNTED BY: TOM JONES CHECKED BY: CHECKED BY TOM JONES CHECKED BY: Shaila Bulan 762 802 824 839 TAG NO. TAG NO. TAG NO. TAG NO. O O O O FREE- INVENTORY DATE LOCATION 01/01/2020 JAPAN ITEM: INVENTORY DATE LOCATION 01/01/2020 JAPAN ITEM: --------------- INVENTORY DATE LOCATION 01/01/2020 JAPAN ITEM INVENTORY DATE LOCATION 01/01/2020 JAPAN ITEMI 100-2545 101-1348 101-2089 102-5573 DESCRIPTION FISHING VEST QUANTITY DESCRIPTION SMALL T-SHIRT QUANTITY DESCRIPTION MEDIUM T-SHIRT QUANTITY DESCRIPTION M SWEATER QUANTITY 9498 8645 23324 9687 COUNTED BY COUNTED BY: COUNTED BY: COUNTED BY: JUL SAMSON CHECKED BY JUL SAMSON JUL SAMSON JUL SAMSON CHECKED BY CHECKED BY: CHECKED BY: 1210 Brady Williams 1261 TAG NO. 1243 TAG NO. TAG NO. 1334 TAG NO. O o O O INVENTORY DATE LOCATION 01/01/2020 JAPAN . ITEM INVENTORY DATE LOCATION ol/01/2020 JAPAN ITEM: INVENTORY DATE LOCATION 01/01/2020 JAPAN ITEM INVENTORY DATE LOCATION 01/01/2020 JAPAN ITEM: 102-8637 103-2538 103-5037 103-7994 DESCRIPTION XL SWEATER QUANTITY DESCRIPTION PHOTO 5 X 7 QUANTITY DESCRIPTION PHOTO 8 1/2 X LL QUANTITY DESCRIPTION PHOTO 11 X 17 QUANTITY 19805 23901 8907 18234 COUNTED BY: COUNTED BY: JUL SAMSON COUNTED BY: JUL SAMSON CHECKED BY Brady Williams 1386 TAG NO COUNTED BY: JUL SAMSON CHECKED BY: Brady Williams CHECKED BY: JUL SAMSON CHECKED BY: Brady Williams TAG NO. 1464 TAG NO. 1441 1450 TAG NO. --------------- INVENTORY DATE LOCATION 01/01/2020 JAPAN ITEM INVENTORY DATE LOCATION 01/01/2020 JAPAN ITEM INVENTORY DATE LOCATION 01/01/2020 JAPAN ITEM 104-3501 104-4510 104-9326 DESCRIPTION DESCRIPTION BRIEFCASE QUANTITY LARGE SUITCASE DESCRIPTION DUFFEL BAG QUANTITY QUANTITY 43487 24389 18345 COUNTED BY COUNTED BY: JUL SAMSON COUNTED BY: JUL SAMSON JUL SAMSON CHECKED BY: CHECKED BY CHECKED BY: Brady Williams TAG NO. 1566 TAG NO 1505 TAG NO. 1533 Inventory Status Report International Warehouses Date: 1/1/2020 Total Inventory No. 100-2545 Item Description Fishing Vest Germany 11,894 Japan 9,498 101-1348 Small T-shirt 8,349 8,645 23,324 21,392 16,994 56,113 101-2089 Medium T-shirt 32,789 101-3573 Large T-shirt 28,239 2,342 30,581 102-5573 M Sweater 84,383 9,678 94,061 102-8637 XL Sweater 94,202 23,842 19,805 23,901 103-2538 Photo 5 X 7 114,007 47,743 62,745 103-5037 Photo 8 1/2 X 11 53,838 8,907 103-7994 Photo 11 X 17 0 18,234 Briefcase 84,900 104-3501 104-4510 104-9326 18,234 43,487 24,389 18,345 19,007 Large suitcase Duffel Bag 128,387 43,396 25,905 7,560 was given W&A Staff Auditer Note This inventory Status Report to us after the physical counts were. completed. The EarthWear staff indicate this report reflects all corrections noted during the physical inventory counts at the two international locations. RLT W/2020 B D E F G H EARTHWEAR CLOTHIERS Inventory Floor to Sheet Test Counts December 31, 2019 5-1 Initial Here 10/12/2019 GERMANY Describe any Violations of Management's Assertions Inventory ID 101-2089 102-5573 102-8637 103-2538 103-7994 104-9326 Description Medium T-shirt M Sweater XL Sweater Photo 5 X 7 Photo 11 X 17 Duffel Bag Quantity on Quantity on Inventory Inventory Count Tags Status Report 32.789 32,789 Enter Qty. Here Enter Qty. Here 94.202 94,202 23,842 23,842 Enter Qty. Here Enter Qty. Here . 7,560 7,560 Difference 0 Enter Tag Count 0 0 Enter Tag Count 0 JAPAN Difference Describe any Violations of Management's Assertions Inventory ID 101-2089 102-5573 102-8637 103-2538 103-7994 104-9326 Description Medium T-shirt M Sweater XL Sweater Photo 5 X7 Photo 11 X 17 Duffel Bag Quantity on Quantity on Inventory Inventory Count Tags Status Report 23.324 23,324 Enter Oty. Here Enter Oty. Here . 19,805 19,805 23,901 23,901 Enter Cty. Here Enter Oty. Here . 18,345 18,345 0 Enter Tag Count 0 0 Enter Tag Count 0 The McGraw-Hill Companies, Inc., 2019 O O O O INVENTORY DATE LOCATION 01/01/2020 GERMANY ITEV INVENTORY DATE LOCATION 01/01/2020 GERMANY INVENTORY DATE LOCATION 01/01/2020 GERMANY ITEM INVENTORY DATE LOCATION 01/03/2020 GERMANY ITEN: 100-2545 101-2089 101-3573 DESCRIPTION FISHING VEST QUANTITY 101-1348 - DESCRIPTION SMALL T-SHIRT QUANTITY DESCRIPTION MEDIUM T-SHIRT QUANTITY DESCRIPTION LARGE T-SHIRT QUANTITY 11894 8349 32789 28239 COUNTED BY TOM JONES COUNTED BY TOM JONES CHECKED BY COUNTED BY TOM JONES COUNTED BY TOM JONES CHECKED BY: Sheila Beton CHECKED BY: CHECKED BY: Sheila Dietor TAG NO 502 TAG NO 541 565 597 TAG NO. TAG NO. O O O O O INVENTORY DATE LOCATION 01/01/2020 GERMANY ITEM ---------------- INVENTORY DATE LOCATION 02/01/2020 GERMANY ITEM INVENTORY DATE LOCATION 01/01/2020 GERMANY ITEM ----------------- INVENTORY DATE LOCATION 01/02/2020 GERMANY ITEM . 102-5573 102-8637 103-2538 103-5037 DESCRIPTION M SWEATER QUANTITY DESCRIPTION XL SUEATER QUANTITY DESCRIPTION PHOTO S X7 QUANTITY DESCRIPTION PHOTO 8 1/2 X 11 QUANTITY 84383 94202 23842 S3838 COUNTED BY: TOM JONES CHECKED BY COUNTED BY: TOM JONES CHECKED BY Sheila Berton COUNTED BY TOM JONES CHECKED BY: Sheila Berton COUNTED BY: TOM JONES CHECKED BY 614 633 747 752 TAG NO. TAG NO TAG NO TAG NO. O O O O INVENTORY DATE LOCATION 01/01/2020 GERMANY ITFU INVENTORY DATE LOCATION 03/01/2020 GERMANY INVENTORY DATE LOCATION 01/01/2020 GERMANY ITEM INVENTORY DATE LOCATION 01/02/2020 GERMANY ITEN 103-7994 104-3501 104-4510 104-9326 DESCRIPTION PHOTO 11 X 17 QUANTITY DESCRIPTION BRIEFCASE QUANTITY DESCRIPTION LARGE SUITCASE QUANTIT DESCRIPTION DUFFEL BAG QUANTITY 9734 84900 19007 7560 COUNTED BY: COUNTED BY: TOM JONES COUNTED BY: TOM JONES CHECKED BY: Sheila Motor COUNTED BY: TOM JONES CHECKED BY: CHECKED BY TOM JONES CHECKED BY: Shaila Bulan 762 802 824 839 TAG NO. TAG NO. TAG NO. TAG NO. O O O O FREE- INVENTORY DATE LOCATION 01/01/2020 JAPAN ITEM: INVENTORY DATE LOCATION 01/01/2020 JAPAN ITEM: --------------- INVENTORY DATE LOCATION 01/01/2020 JAPAN ITEM INVENTORY DATE LOCATION 01/01/2020 JAPAN ITEMI 100-2545 101-1348 101-2089 102-5573 DESCRIPTION FISHING VEST QUANTITY DESCRIPTION SMALL T-SHIRT QUANTITY DESCRIPTION MEDIUM T-SHIRT QUANTITY DESCRIPTION M SWEATER QUANTITY 9498 8645 23324 9687 COUNTED BY COUNTED BY: COUNTED BY: COUNTED BY: JUL SAMSON CHECKED BY JUL SAMSON JUL SAMSON JUL SAMSON CHECKED BY CHECKED BY: CHECKED BY: 1210 Brady Williams 1261 TAG NO. 1243 TAG NO. TAG NO. 1334 TAG NO. O o O O INVENTORY DATE LOCATION 01/01/2020 JAPAN . ITEM INVENTORY DATE LOCATION ol/01/2020 JAPAN ITEM: INVENTORY DATE LOCATION 01/01/2020 JAPAN ITEM INVENTORY DATE LOCATION 01/01/2020 JAPAN ITEM: 102-8637 103-2538 103-5037 103-7994 DESCRIPTION XL SWEATER QUANTITY DESCRIPTION PHOTO 5 X 7 QUANTITY DESCRIPTION PHOTO 8 1/2 X LL QUANTITY DESCRIPTION PHOTO 11 X 17 QUANTITY 19805 23901 8907 18234 COUNTED BY: COUNTED BY: JUL SAMSON COUNTED BY: JUL SAMSON CHECKED BY Brady Williams 1386 TAG NO COUNTED BY: JUL SAMSON CHECKED BY: Brady Williams CHECKED BY: JUL SAMSON CHECKED BY: Brady Williams TAG NO. 1464 TAG NO. 1441 1450 TAG NO. --------------- INVENTORY DATE LOCATION 01/01/2020 JAPAN ITEM INVENTORY DATE LOCATION 01/01/2020 JAPAN ITEM INVENTORY DATE LOCATION 01/01/2020 JAPAN ITEM 104-3501 104-4510 104-9326 DESCRIPTION DESCRIPTION BRIEFCASE QUANTITY LARGE SUITCASE DESCRIPTION DUFFEL BAG QUANTITY QUANTITY 43487 24389 18345 COUNTED BY COUNTED BY: JUL SAMSON COUNTED BY: JUL SAMSON JUL SAMSON CHECKED BY: CHECKED BY CHECKED BY: Brady Williams TAG NO. 1566 TAG NO 1505 TAG NO. 1533 Inventory Status Report International Warehouses Date: 1/1/2020 Total Inventory No. 100-2545 Item Description Fishing Vest Germany 11,894 Japan 9,498 101-1348 Small T-shirt 8,349 8,645 23,324 21,392 16,994 56,113 101-2089 Medium T-shirt 32,789 101-3573 Large T-shirt 28,239 2,342 30,581 102-5573 M Sweater 84,383 9,678 94,061 102-8637 XL Sweater 94,202 23,842 19,805 23,901 103-2538 Photo 5 X 7 114,007 47,743 62,745 103-5037 Photo 8 1/2 X 11 53,838 8,907 103-7994 Photo 11 X 17 0 18,234 Briefcase 84,900 104-3501 104-4510 104-9326 18,234 43,487 24,389 18,345 19,007 Large suitcase Duffel Bag 128,387 43,396 25,905 7,560 was given W&A Staff Auditer Note This inventory Status Report to us after the physical counts were. completed. The EarthWear staff indicate this report reflects all corrections noted during the physical inventory counts at the two international locations. RLT W/2020