In this minl-case you will test Inventory for EarthWear Clothlers. EarthWear has a calendar year-end and conducted their Inventory observation on January 1, 2023. Inventory was counted at two different forelgn distribution centers (Germany and Japan) where the International Inventory Is stored. There was no movement of Inventory on January 1st. A brlef description of the Inventory Count process has been provided below. INSTRUCTIONS: Please download the files below to complete the audit tasks assoclated with this minl-case. The Excel workbook contalns the Instructions and workpapers you are to complete. 12e_Ch5_Minl_case_Inventory. 12e_Physical Inventory Count Description 12e_Inventory_Status_Report 12e_Inventory_Tags_Germany. Using your completed Excel file, answer the questions presented below. Input your responses from Work Paper 5-1 and 5-2 Into the corresponding questlons in Connect. Note: Leave no cells blank - be certaln to enter " 0 " In numerlc flelds or "None" In text flelds wherever requlred. Work Paper 5-1 GERMANY Inventory ID 101-2089 102-5573 102-8637 103-2538 103-7994 104-9326 IADAN Work Paper 5.2 \begin{tabular}{|c|c|c|c|} \hline 0 & 0 & 0 & 0 \\ \hline & & & \\ \hline 1002545 & 1011348 & & 1013573 \\ \hline & & & \begin{tabular}{l} LARGE T-SHART \\ LART \end{tabular} \\ \hline 11894 & 8349 & 32789 & 28239 \\ \hline Tom Javes & Tom Jowes & Tom Javes & Tom Javes \\ \hline & & & sortone \\ \hline 502 & 541 & 565 & 597 \\ \hline \end{tabular} \begin{tabular}{|c|} \hline . \\ \hline \\ \hline 1025573 \\ \hline \\ \hline 84383 \\ \hline \\ \hline AG No. 614 \\ \hline \end{tabular} \begin{tabular}{|c|} \hline O \\ \hline \\ \hline 102-83? \\ \hline \\ \hline 94202 \\ \hline Tom Javes \\ \hline \\ \hline TAG No. 633 \\ \hline \end{tabular} \begin{tabular}{|c|} \hline \\ \hline 103-2538 \\ \hline \\ \hline 23842 \\ \hline Tom saves \\ \hline \\ \hline 747 \\ \hline \end{tabular} \begin{tabular}{|c|} \hline \multirow[t]{2}{*}{0} \\ \hline \\ \hline 103794 \\ \hline \\ \hline 9734 \\ \hline Tom Jones \\ \hline Sticich sorton \\ \hline 762 \\ \hline \end{tabular} \begin{tabular}{|c|} \hline \\ \hline \\ \hline \\ \hline 84900 \\ \hline \\ \hline ino. \\ \hline \end{tabular} Inventory Status Report International Warehouses Date: 1/1/2023 WeA Staff Auditor Note: RLT 1/2023 \begin{tabular}{|c|} \hline \\ \hline \\ \hline 1002545 \\ \hline \begin{tabular}{l} ofeccanow \\ FISHNG VEST \end{tabular} \\ \hline 9498 \\ \hline JUL SAMSON \\ \hline . 1210 \\ \hline \end{tabular} \begin{tabular}{|c|} \hline \\ \hline \\ \hline \\ \hline \\ \hline 23324 \\ \hline JUL SAMSON \\ \hline \\ \hline 1261 \\ \hline \end{tabular} \begin{tabular}{|c|} \hline \\ \hline \\ \hline 1025573 \\ \hline \\ \hline 9687 \\ \hline \\ \hline 133 \\ \hline \end{tabular} \begin{tabular}{|c|} \hline \\ \hline \\ \hline 10-83? \\ \hline \\ \hline 19805 \\ \hline JUL SAMSON \\ \hline \\ \hline 1380 \\ \hline \end{tabular} \begin{tabular}{|c|} \hline 0 \\ \hline \\ \hline 1032538 \\ \hline \\ \hline 23901 \\ \hline JUL SAMSON \\ \hline Brady nimens \\ \hline \begin{tabular}{|ll} TAG No. & 1441 \\ \end{tabular} \\ \hline \end{tabular} \begin{tabular}{|c|} \hline \multirow{2}{*}{O} \\ \hline \\ \hline 1043501 \\ \hline \begin{tabular}{c} oetcanpon \\ BRIEFCASE \\ \end{tabular} \\ \hline 43487 \\ \hline \\ \hline \begin{tabular}{ll} TAG No. 1505 \\ \end{tabular} \\ \hline \end{tabular} \begin{tabular}{|c|} \hline \\ \hline \\ \hline 1049326 \\ \hline \\ \hline 18345 \\ \hline JUL SAMSON \\ \hline Brady witums \\ \hline \begin{tabular}{ll} TAG No. 1566 \\ \end{tabular} \\ \hline \end{tabular} Description of the inventory count process: EarthWear's Procedures: During EarthWear's year-end inventory count in each warehouse, representatives of the company count all inventory items and record the count for each inventory item on an inventory "count tag." Once the count at a particular warehouse is finished, all tags are collected and compared with the Inventory Status Report. Corrections are recorded on the Inventory Status Report and entered into the Inventory program. Auditor's Procedures: Inventory observation is a required procedure under Generally Accepted Auditing Standards. In addition to inquiry regarding the client's count controls and procedures and observing the client's overall inventory count process and the organization of the warehouse, the external auditor performs test counts on a sample of inventory items. Some of the selections are made from count tags, which are then traced to the inventory status report to verify that the inventory status report is complete and accurate. This procedure is often referred to as a "floor to sheet" test (i.e., all inventory items on the warehouse "floor" have been included in the inventory status report "sheet"), and is primarily a test for the completeness and accuracy assertions. The auditor also makes some test count selections from the inventory status report and vouches the selected inventory items to the corresponding inventory count tags to verify that inventory listed on the inventory status report exists and is accurate. This procedure is often referred to as a "sheet to floor" test (i.e., all inventory items included on the inventory status report "sheet" represent items that actually exist on the warehouse "floor"), and is primarily a test for the existence and accuracy assertions. The auditor signs his or her name on each count tag for which he or she has recounted the corresponding inventory to indicate that it has been independently verified. The auditor retains a copy of all of the count tags, even those that he or she does not verify. Tags that were not verified will not bear the auditor's signature