Question: O V {E Apo||o_|nventory_Audit_Mini_Case V Insert Page Layout Formulas Data Review View A Share A as . ' ' '3 Insert V 2 V v

O V {E Apo||o_|nventory_Audit_Mini_Case V InsertO V {E Apo||o_|nventory_Audit_Mini_Case V InsertO V {E Apo||o_|nventory_Audit_Mini_Case V InsertO V {E Apo||o_|nventory_Audit_Mini_Case V InsertO V {E Apo||o_|nventory_Audit_Mini_Case V InsertO V {E Apo||o_|nventory_Audit_Mini_Case V InsertO V {E Apo||o_|nventory_Audit_Mini_Case V InsertO V {E Apo||o_|nventory_Audit_Mini_Case V InsertO V {E Apo||o_|nventory_Audit_Mini_Case V InsertO V {E Apo||o_|nventory_Audit_Mini_Case V InsertO V {E Apo||o_|nventory_Audit_Mini_Case V InsertO V {E Apo||o_|nventory_Audit_Mini_Case V InsertO V {E Apo||o_|nventory_Audit_Mini_Case V InsertO V {E Apo||o_|nventory_Audit_Mini_Case V InsertO V {E Apo||o_|nventory_Audit_Mini_Case V InsertO V {E Apo||o_|nventory_Audit_Mini_Case V InsertO V {E Apo||o_|nventory_Audit_Mini_Case V InsertO V {E Apo||o_|nventory_Audit_Mini_Case V InsertO V {E Apo||o_|nventory_Audit_Mini_Case V InsertO V {E Apo||o_|nventory_Audit_Mini_Case V InsertO V {E Apo||o_|nventory_Audit_Mini_Case V InsertO V {E Apo||o_|nventory_Audit_Mini_Case V InsertO V {E Apo||o_|nventory_Audit_Mini_Case V InsertO V {E Apo||o_|nventory_Audit_Mini_Case V InsertO V {E Apo||o_|nventory_Audit_Mini_Case V InsertO V {E Apo||o_|nventory_Audit_Mini_Case V InsertO V {E Apo||o_|nventory_Audit_Mini_Case V InsertO V {E Apo||o_|nventory_Audit_Mini_Case V InsertO V {E Apo||o_|nventory_Audit_Mini_Case V InsertO V {E Apo||o_|nventory_Audit_Mini_Case V InsertO V {E Apo||o_|nventory_Audit_Mini_Case V InsertO V {E Apo||o_|nventory_Audit_Mini_Case V Insert
O V {E Apo||o_|nventory_Audit_Mini_Case V Insert Page Layout Formulas Data Review View A" Share A as . ' ' '3 Insert V 2 V v [Times New... Vl [10 Vl AA Av = = 6') V ' General V l 1 v l i v L v A v V & VA ' " ' I J 5" Delete V E V Z? Paste B I u v 3 v v v :2 g :: 4-: ~> Merge & Center v v 'y 3 *- - Conditional Format Cell .e. Sort a 6' C _ - $ 0 .oo *0 Formatting as Table Styles El \"rm\" ' 0 ' Filter 0 Office Update To keep uptodate with security updates, fixes, and improvements. choose Check for Updates Check for Updates ' B9 : f3: When you are nished with the entire workbook, rename this document |NV_Firstna me_Lastna me and upload. V A B C D 1 Apollo Inventory Audit MiniCase 2 In this minicase you will perform some substantive procedures related to the audit of Apollo's Inventory. As part of your audit you will evaluate documents 3 such as inventory observation memos, count sheets, and purchase invoices. For ease, your audit senior has already picked up the PBC schedules for you. 4 Instructions: Read all memos from your manager, then read the steps in the audit program for Inventory found on Work Paper H-0 and familiarize yourself with work papers H-l through H-7. Complete all the remaining steps on the audit program. Be sure to document your work using the designated tick marks. The tick mark legend is located at the bottom of each work paper. Remember that cross-references on the le indicate the number is from that document and on the 5 right if the number goes to that document. 6 7 When you are nished with each workpaper, enter your initials in the box in the top right marked "Prepared By" 8 9 IWben you are finished with the entire workbook, rename this document INV_Firstname_Lastname and upload. I I 10 11 12 13 14 15 16 17 18 19 20 1 1 ' } Instructions Emails A-1 PEG 2019 Trial Balance Av2 PEG 2020 Trial Balance H-O Inventory Program H-1 Inventory Lead Sheet H-2 Inventory Observation Memo + Ready E - ---w-- + 145% O : XE Apollo_lnventory_Audit_Mini_Case , Insert Page Layout Formulas Data Review View 2+ Share A 36 . ~ = _ :L. . '3 Insert V 2 V , Callbrl (Body) v 11 V AA Av ' = 6 V _ 9 Wrap Text General V v l l v v A v E E? v " ' ' ' ' $7 ' / J - , , . , ,, , [E ' J L Z? 5* Delete v E v Paste v A v E E E E = H v v 0 *- - Conditional Format Cell ..... Sort 81 6 B I Q ' ' - ' _ _ _ ' 'L ._ Merge & Center W 'M' Formatting as Table styles I Format ' O ' Filter 9 Office Update To keep uptodate with security updates, fixes, and improvements, choose Check for Updates A1 $ r V A a c D r. r G H I J K L M N o P a R s r u v w x 1 |:1 2 Date: 2 FEB 2020 10:24:53 +0000 3 From: "Darlene Wardlm" mm 4 Subject: HELP! Apollo mummy nightmare! 5 6 I really need your help, I realize I you are busy but we need to wrap up Apollo's inventory and 7 Taylor just called in sick Some kind of stomach bug 3 v A v _ H Merge 81 Center v $ v % ) " '00 Conditional Format Cell ..... Sort s 8 - M Formatting as Table Styles El Format ' O ' Filter 9 Ofce Update To keep up todate With seounty updates, fixes, and Improvements. choose Check for Updates Check for Updates 51 r ' A B C D E F G H | J K L M N 0 P 0. S T U V 1 Apollo Shoes, Inc. H-2.l - 1-1-217 I Ii 2 Inventory count instructions and count sheets PBC 3 For Year Ended 12l31f2020 4 5 6 Apollo Shoes 7 Inventory Count Instructions 8 9 10 11 Counts will be performed in teams of two, consisting of a counter and a writerl 1 1 12 2. For each bin, identify the item located in it and the count of that item. If more than one item is in the bin, write in the 13 bin number, the additional item description, and the count' in the open space at the bottom of your count sheet. 1: 3. Aer counting a bin, place an inventory count tag on the bin to mark it as having been counted. 16 4 Aer a team nishes' 1ts counts, each count team member should write his/her name in the "Count Team" line on each 17 count sheet and the team should then turn in the sheets to the inventory manager 18 19 5 Aer receiving the count sheets(s), the inventory manager will review and sign them, and then submit them to the 20 inventory clerk for processing 2: 6 The inventory clerk will enter the counts into the computer system, run a variance report. and submit the variance report 2 3 to the inventory manager. 24 7. The inventory manager will assign recounts for variances to the count teams, Each team will then recount the assigned 25 bins and initial beside the recount on the count sheet. 2 6 27 8 The recounts will be resubmitted to the inventory manager, who will review and sign them, and then submit them to the 23 inventory clerk for nal entry 25 3 9. There will be NO sales and N0 movement of inventory during the counL 3 1 3 Z 33 H-2 1 34 APOLLO SHOES, INC. 35 INVENTORY COUNT SHEET 3: December 31, 2020 SHEET N0. 31 38 ' } H-2.1 Thru H-2.7 lnv. Counts H-3 Inventory 12-31 H-4 Inventory Counts H-5 Purchase Summary H-6 LCNRV Calc H7 Inventory Obs. Calculation + Ready m U + 100% Apollo_Inventory Audit Mini_Case Q Search Sheet Home Insert Page Layout Formulas Data Review View "+ Share ~ Times New... 11 A- A- = = Insert Wrap Text General AP. * Delete Paste B I UV A . ELLE Merge & Center $ ~ % .00 Conditional Format Cell Sort & Formatting as Table Styles Format Filter Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates $70 X V fx A B C D E F G H I J K L M N 0 P Q R S T U V 33 H-2.1 34 APOLLO SHOES, INC. 35 INVENTORY COUNT SHEET 36 December 31, 202 SHEET NO. 81 37 38 39 COUNT TEAM R. Thomas, Q. Greene 40 41 ENTERED BY B. Harrington 42 43 44 REVIEWED BY A. Jacobs 45 46 Quantity Pallet Location Sku# Type Size 47 Style Counted 48 C46 30180 Spotlight Men's 23 1080 H-4 49 C47 30180 Spotlight Men's 23 1080 H-4 C48 30180 Spotlight Men's 23 74 H-4 H-2.2 APOLLO SHOES, INC. INVENTORY COUNT SHEET December 31, 2020 SHEET NO. 20 COUNT TEAM J. Morris, T. Peters ENTERED BY G. R. Samuels REVIEWED BY A. Jacobs 70 H-2.1 Thru H-2.7 Inv. Counts H-3 Inventory 12-31 H-4 Inventory Counts H-5 Purchase Summary H-6 LCNRV Calc H-7 Inventory Obs. Calculation + Ready + 100%Apollo_Inventory Audit Mini_Case Q Search Sheet Home Insert Page Layout Formulas Data Review View "+ Share ~ Insert Times New... 11 A- A- = = Wrap Text General AP. * Delete .00 Paste B I UV A . Merge & Center $ ~ % Conditional Format Cell Sort & Formatting as Table Styles Format Filter x Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates S108 X V fx A B C D E F G H K L M N 0 P Q R S T U V 71 Quantity 72 Pallet Location Sku#t Style Type Size Counted 73 74 A65 10200 Siren Women's 3.5 1080 H-4 75 66 10200 Siren Women's 6.5 1080 H-4 76 77 A67 10200 Siren Women's 6.5 1080 H-4 78 79 A68 10200 Siren Women's 6.5 1080 H-4 80 A69 Women's 680 H-4 81 10200 Siren 6 5 82 83 84 85 H-2.3 86 87 APOLLO SHOES, INC. 88 INVENTORY COUNT SHEET 89 December 31, 2020 SHEET NO. 37 90 COUNT TEAM S. Adams, H. Frey 94 ENTERED BY E. Meadows 95 96 REVIEWED BY A. Jacobs 98 Quantity 99 Pallet Location Sku# Style Type Size Counted 100 B25 7.5 1080 H-4 101 20040 Speaker Men's 102 B26 20040 Speaker Men's 7.5 1080 H-4 103 104 B27 20040 Speaker Men's 7.5 1080 H-4 105 106 B28 20040 Speaker Men's 7.5 1080 H-4 107 B29 20040 Speaker Men's 7.5 1080 H-4 108 H-2.1 Thru H-2.7 Inv. Counts H-3 Inventory 12-31 H-4 Inventory Counts H-5 Purchase Summary H-6 LCNRV Calc H-7 Inventory Obs. Calculation + Ready + 100%Apollo_Inventory Audit Mini_Case Q Search Sheet Home Insert Page Layout Formulas Data Review View "+ Share ~ Times New... 11 A- A- = = General Insert Wrap Text AP. * Delete Paste B A . ELLE Merge & Center $ ~ % .00 Conditional Format Cell Sort & Formatting as Table Styles Format Filter Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates S144 X V fx A B C D F G H K L M N 0 P Q R S T U V 107 B29 20040 Speaker Men's 75 1080 H-4 108 109 B30 20040 Speaker Men's 7.5 1080 H-4 110 111 B31 20040 Speaker Men's 7.5 1080 H-4 112 113 B32 20040 Speaker Men's 7.5 1080 H-4 114 B33 20040 Speaker Men's 7.5 1080 H-4 115 116 B34 20040 Speaker Men's 7.5 1080 H-4 117 118 B35 20040 Speaker Men's 7.5 1080 H-4 119 120 B36 20040 Speaker Men's 7.5 1080 H-4 121 B37 20040 Speaker Men's 7.5 1080 H-4 122 123 B38 20040 Speaker Men's 7.5 2788 H-4 124 125 126 127 H-2.4 128 APOLLO SHOES, INC. 129 INVENTORY COUNT SHEET 130 December 31, 2020 SHEET NO. 56 131 132 133 COUNT TEAM K. Landry, L. Robertson 134 135 ENTERED BY N. Johnston 136 137 REVIEWED BY A. Jacobs 138 139 Quantity 140 Pallet Location Sku# Style Type Size Counted 141 142 B213 20220 Speaker Women's 1080 H-4 143 144 B214 20220 Speaker Women's 1080 H-4 H-2.1 Thru H-2.7 Inv. Counts H-3 Inventory 12-31 H-4 Inventory Counts H-5 Purchase Summary H-6 LCNRV Calc H-7 Inventory Obs. Calculation + Ready + 100%Apollo_Inventory Audit Mini_Case Q Search Sheet Home Insert Page Layout Formulas Data Review View "+ Share ~ Times New... 11 A- A- = = Wrap Text General Insert AP. * Delete Paste B A . ELLE Merge & Center $ ~ % .00 Conditional Format Cell Sort & Formatting as Table Styles Format Filter Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates S162 X V fx A B C D E F G H J K L M N 0 P Q R S T U V 142 B213 20220 Speaker Women's 1080 H-4 143 144 B214 20220 Speaker Women's 1080 H-4 145 B215 20220 Speaker Women's 1080 H-4 146 147 B216 20220 Speaker Women's 1080 H-4 148 149 B217 20220 Speaker Women's 1080 H-4 150 B218 20220 Speaker Women's 1080 H-4 151 152 B219 20220 Speaker Women's 1080 H-4 153 154 B220 20220 Speaker Women's 1080 H-4 155 156 B221 20220 Speaker Women's 1080 H-4 157 B222 20220 Speaker Women's 1080 H-4 158 159 B223 20220 Speaker Women's 1080 H-4 160 161 B224 20220 Speaker Women's 1080 H-4 162 163 B225 20220 Speaker Women's 1080 H-4 164 B226 20220 Speaker Women's 586 H-4 165 166 167 168 H-2.5 169 APOLLO SHOES, INC. 170 171 INVENTORY COUNT SHEET 172 December 31, 2020 SHEET NO. 64 173 174 175 COUNT TEAM R. Thomas, Q. Greene 176 177 ENTERED BY B. Harrington 178 179 REVIEWED BY A. Jacobs H-2.1 Thru H-2.7 Inv. Counts H-3 Inventory 12-31 H-4 Inventory Counts H-5 Purchase Summary H-6 LCNRV Calc H-7 Inventory Obs. Calculation + Ready + 100%Apollo_Inventory Audit Mini_Case Q Search Sheet Home Insert Page Layout Formulas Data Review View "+ Share ~ Insert Times New... 11 A- A- = = Wrap Text General AP. * Delete Paste B I UV A . ELE Merge & Center $ ~ % .00 Conditional Format Cell Sort & Formatting as Table Styles Format Filter x Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates S217 X V fx A B C D E F G H K L M N 0 P Q R S T U V 180 Quantity 181 182 Pallet Location Skut Style Type Size Counted 183 C1 30010 Spotlight Men's 1080 H-4 184 185 C2 30010 Spotlight Men's 1080 H-4 186 187 C3 30010 Spotlight Men's 1080 H-4 188 C4 30010 Spotlight Men's 6 36 H-4 189 190 191 192 193 194 195 196 197 H-2.6 198 199 APOLLO SHOES, INC. 200 INVENTORY COUNT SHEET 201 December 31, 2020 SHEET NO. 96 202 203 204 COUNT TEAM R. Thomas, Q Q. Greene 205 206 ENTERED BY B. Harrington 207 208 REVIEWED BY A. Jacobs 209 210 Quantity 211 Pallet Location Sku# Style Type Size Counted 212 213 C102 30330 Spotlight Women's 12 1080 H-4 214 C103 30330 Spotlight Women's 12 1080 H-4 215 216 C104 30330 Spotlight Women's 12 1080 H-4 217 H-2.1 Thru H-2.7 Inv. Counts H-3 Inventory 12-31 H-4 Inventory Counts H-5 Purchase Summary H-6 LCNRV Calc H-7 Inventory Obs. Calculation + Ready + 100%Apollo_Inventory Audit Mini_Case Q Search Sheet Home Insert Page Layout Formulas Data Review View "+ Share ~ Times New... 11 A- A- = = General Insert Wrap Text AP. * Delete Paste B A . Merge & Center $ ~ % .00 Conditional Format Cell Sort & Formatting as Table Styles Format Filter x Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates S255 X V fx B C D F G H K L M N 0 P Q R S T U V C 105 30330 Spotlight Women's 12 90 H-4 219 220 221 222 223 224 225 226 227 228 H-2.7 229 230 APOLLO SHOES, INC. 231 INVENTORY COUNT SHEET 232 December 31, 2020 SHEET NO. 3 233 234 235 COUNT TEAM J. Morris, T. Peters 236 237 ENTERED BY G. R. Samuels 238 239 REVIEWED BY A. Jacobs 240 241 Quantity 242 Pallet Location Sku# Style Type Size Counted 243 A10 10030 Siren Men's 1080 H-4 244 245 A11 10030 Siren Men's co 1080 H-4 246 247 A12 10030 Siren Men's CO 1080 H-4 248 A13 10030 Siren Men's 8 249 890 H-4 250 251 252 253 254 255 H-2.1 Thru H-2.7 Inv. Counts H-3 Inventory 12-31 H-4 Inventory Counts H-5 Purchase Summary H-6 LCNRV Calc H-7 Inventory Obs. Calculation + Ready + 100%Apollo_Inventory Audit_Mini_Case Q Search Sheet Home Insert Page Layout Formulas Data Review View "+ Share ~ Insert Times New... 12 A- A = Wrap Text Custom AP. * Delete Paste B I U. A . E E ELLE Merge & Center $ ~ % " 00 .00 Conditional Format Cell Sort & Formatting as Table Styles Format Filter x Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates 4R x 13C V X V fx 12/31/2020 A B C D E F G H I J K L M N O P Q R S T U V Apollo Shoes, Inc H-3 Inventory Status Report PBC TAWNY Post Physical Inventory Count 31-Dec-20 Inventory, 12/31/2019 Inventory, 12/31/2020 Sku# Style Type Size Quantity Unit Price Ext Price Quantity Unit Price Ext Price 10010 Siren Men's 7 507 138.08 70,006.56 4,002 H-4 139.76 559,319.52 1 00 10020 Siren Men's 71/2 544 138.0 75,115.52 4,572 H-4 139.76 638,982.72 10 10030 Siren Men's 660 138.0 91,132.80 4,130 H-4 39.76 577,208.80 11 10040 Siren Men's 1/2 718 138.08 99,141.44 4.079 H-4 139.76 570,081.04 12 10050 Siren Men's 9 529 138.08 73,044.32 4.337 H-4 139.76 606,139.12 13 10060 Siren Men's 9 1/2 1,007 138.08 139,046.56 4,640 H-4 139.76 648,486.40 14 10070 Siren Men's 10 997 138.08 137,665.76 4,840 H-4 139.76 676,438.40 15 10080 Siren Men's 10 1/2 912 138.08 125,928.96 4,585 H-4 139.76 640, 799.60 16 10090 Siren Men's 539 138.08 74,425.12 3,644 H-4 139.76 509,285.44 17 10100 Siren Men's 11 1/2 756 138.08 104,388.48 1,774 H-4 139.76 247,934.24 18 10110 Siren Men's 12 509 138.08 70,282.72 3,632 H-4 139.76 507,608.32 10120 Siren Men's 12 1/2 581 138.08 80,224.48 2,420 H-4 139.76 338,219.20 20 10130 Siren Men's 13 631 138.08 87,128.48 1,424 H-4 139.76 199,018.24 21 10140 Siren Men's 13 1/2 423 138.08 58,407.84 746 H-4 139.76 104,260.96 22 10150 Siren Men's 14 324 138.08 44,737.92 408 H-4 139.76 57,022.08 23 10160 Siren Men's 14 1/2 496 138.08 68, 487.68 352 H-4 139.7 49,195.52 24 10170 Siren Women's 538 138.08 74,287.04 1,827 H-4 139.7 255,341.52 25 10180 Siren Women's 5 1/2 849 138.08 117,229.92 2,581 H-4 139.76 360,720.56 26 10190 Siren Women's 6 995 138.08 137,389.60 4,129 H-4 139.76 577,069.04 27 10200 Siren Women's 6 1/2 614 138.08 84,781.12 5,000 H-4 139.76 698,800.00 28 10210 Siren Women's 768 138.08 106,045.44 5,781 H-4 139.76 807,952.56 29 10220 Siren Women's 7 1/2 980 138.08 135,318.40 3,491 H-4 139.76 487,902.16 30 10230 Siren Women's 8 926 138.08 127,862.08 4,756 H-4 139.76 664,698.56 31 10240 Siren Women's 8 1/2 820 138.08 113,225.60 2,650 H-4 139.76 370,364.00 32 10250 Siren Women's 9 936 138.08 129,242.88 4,573 H-4 139.76 639,122.48 33 10260 Siren Women's 9 1/2 839 138.08 115,849.12 2,673 H-4 139.76 373,578.48 120 no on 1in an 120 75 non con TO H-2.1 Thru H-2.7 Inv. Counts H-3 Inventory 12-31 H-4 Inventory Counts H-5 Purchase Summary H-6 LCNRV Calc H-7 Inventory Obs. Calculation + Ready Average: 31-Dec-20 Count: 6 Sum: 31-Dec-20 + 100%Apollo_Inventory Audit Mini_Case Q Search Sheet Home Insert Page Layout Formulas Data Review View "+ Share ~ Times New... 12 A- A = Insert = 1 Wrap Text General AP. * Delete Paste B I U. . A . Merge & Center $ ~ % 00 .00 Conditional Format Cell Sort & Formatting as Table Styles Format Filter x Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates A57 X V fx 20170 A B C D F G H K M N O P Q R S T U V 25 10180 Siren Women's 5 1/2 849 138.08 117,229.92 2,581 H-4 139.76 360,720.56 26 10190 Siren Women's 6 995 138.08 137,389.60 4,129 H-4 139.76 577,069.04 27 10200 Siren Women's 6 1/2 614 138.08 84,781.12 5,000 H-4 39.76 698,800.00 28 10210 Siren Women's 768 138.08 106,045.44 5,781 H-4 139.76 807,952.56 29 10220 Siren Women's 7 1/2 980 138.08 135,318.40 3,491 H-4 139.76 487,902.16 30 10230 Siren Women's 8 926 138.08 127,862.08 4,756 H-4 139.76 664,698.56 31 10240 Siren Women's 8 1/2 820 138.08 113,225.60 2,650 H-4 139.76 370,364.0 32 10250 Siren Women's 9 936 138.0 129,242.88 4,573 H-4 139.76 639,122.48 33 10260 Siren Women's 9 1/2 839 138.0 115,849.12 2,673 H-4 139.76 373,578.48 34 10270 Siren Women's 10 649 138.0 89,613.92 2,072 H-4 39.76 289,582.72 35 10280 Siren Women's 10 1/2 510 138.08 70,420.80 1,715 H-4 139.76 239,688.40 36 10290 Siren Women's 11 631 138.08 87,128.48 740 H-4 139.76 103,422.40 37 10300 Siren Women's 11 1/2 513 138.08 70,835.04 658 H-4 39.76 80'796'I 38 10310 Siren Women's 12 701 138.08 96,794.08 609 H-4 139.76 85,113.84 39 10320 Siren Women's 12 1/2 737 138.08 101,764.96 823 H-4 139.76 115,022.48 40 10330 Siren Women's 13 301 138.08 41,562.08 68 H-4 139.76 135,287.68 41 20010 Speaker Men's 498 230.07 114,574.86 7,123 H-4 116.71 831,325.33 42 20020 Speaker Men's 6 1/2 920 230.07 211,664.40 8,351 H-4 116.71 974,645.2 43 20030 Speaker Men's 1,019 230.07 234,441.33 9,170 H-4 1 16.7 1,070,230.70 44 20040 Speaker Men's 7 1/2 1,663 230.07 382,606.41 16,828 H-4 116.71 1,963,934.47 45 20050 Speaker Men's 1,302 230.07 299,551.14 11,540 H-4 116.71 1,346,833.40 46 20060 Speaker Men's 8 1/2 1,580 230.07 363,510.60 15,273 H-4 116.71 1, 782,511.83 47 20070 Speaker Men's 1,778 230.07 409,064.46 15,425 H-4 116.7 1,800,251.75 48 20080 Speaker Men's 1/2 2,146 230.07 493,730.22 2 H-4 116.7 , 194, 176.72 49 20090 Speaker Men's 10 2,248 230.07 517,197.36 14,260 H-4 116.7 1,664,284.60 50 20100 Speaker Men's 10 1/2 1,982 230.07 455,998.74 ,012 H-4 116.71 1,518,630.52 51 20110 Speaker Men's 11 1,720 230.07 395,720.40 9,170 H-4 116.71 1,070,230.70 52 20120 Speaker Men's 11 1/2 1,131 230.07 260,209.17 3,162 H-4 116.71 369,037.02 53 20130 Speaker Men's 12 1,267 230.07 291,498.69 2,239 H-4 1 16.71 261,313.69 54 20140 Speaker Men's 12 1/2 1,055 230.07 242,723.85 2,764 H-4 1 16.71 322,586.44 55 20150 Speaker Men's 13 673 230.07 154,837.11 1,360 H-4 116.71 158,725.60 56 20160 Speaker Women's 5 736 230.07 169,331.52 11,975 H-4 116.71 1,397,602.25 57 20170 Speaker Women's 5 1/2 1,137 230.0 261,589.59 13,569 H-4 116.71 1,583,637.99 101 14 TV 4 110 71 H-2.1 Thru H-2.7 Inv. Counts H-3 Inventory 12-31 H-4 Inventory Counts H-5 Purchase Summary H-6 LCNRV Calc H-7 Inventory Obs. Calculation + Ready + 100%Apollo_Inventory Audit Mini_Case Q Search Sheet Home Insert Page Layout Formulas Data Review View "+ Share ~ Times New... 12 A- A = = 1 Wrap Text General Insert AP. * Delete Paste B I U. A . ELLE Merge & Center $ ~ % 00 .00 Conditional Format Cell Sort & Formatting as Table Styles Format Filter Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates A83 X V fx 30140 A B D F G H K M N O P Q R S T U V 51 20110 Speaker Men's 11 1,720 230.07 395,720.40 9,170 H-4 116.71 1,070,230.70 52 20120 Speaker Men's 11 1/2 1,131 230.07 260,209.17 3,162 H-4 116.71 369,037.02 53 20130 Speaker Men's 12 1,267 230.07 291,498.69 2,239 H-4 116.71 261,313.69 54 20140 Speaker Men's 12 1/2 1,055 230.07 242, 723.85 2,764 H-4 116.71 322,586.44 55 20150 Speaker Men's 13 673 230.07 154,837.11 1,360 H-4 116.71 158,725.60 56 20160 Speaker Women's 5 736 230.07 69,331.52 11,975 H-4 116.71 1,397,602.25 57 20170 Speaker Women's 5 1/2 1,137 230.07 261,589.59 13,569 H-4 116.71 1,583,637.99 58 20180 Speaker Women's 6 1,399 230.07 321,867.93 12,116 H-4 116.71 1,414,058.36 59 20190 Speaker Women's 6 1/2 1,548 230.07 356,148.36 12,890 H-4 116.7 1,504,391.90 60 20200 Speaker Women's 1,858 230.07 427,470.06 13,620 H-4 116.7 ,589,590.20 61 20210 Speaker Women's 7 1/2 1,527 230.07 351,316.89 14,905 H-4 116.7 ,739,562.55 62 20220 Speaker Women's 2,037 230.07 468,652.59 14,626 H-4 116.7 ,707,000.46 63 20230 Speaker Women's 8 1/2 2,248 230.07 517,197.36 14,116 H-4 116.71 1,647,478.36 64 20240 Speaker Women's 9 1,507 230.07 346,715.49 14,413 H-4 116.71 1,682, 141.23 65 20250 Speaker Women's 9 1/2 1,757 230.07 404,232.99 12,083 H-4 116.71 1,410,206.93 66 20260 Speaker Women's 10 1,420 230.07 26,699.40 8,378 H-4 1 16.71 77,796.38 67 20270 Speaker Women's 10 1/2 1,041 230.07 239,502.87 3,256 H-4 116.71 380,007.76 68 20280 Speaker Women's 11 1,282 230.07 294,949.74 2,260 H-4 116.71 263,764.60 69 20290 Speaker Women's 11 1/2 1,120 230.07 257,678.40 1,051 H-4 1 16.7 122,662.2 70 30010 Spotlight Men's 898 203.5 182,743.0 3,276 H-4 205.27 672,464.52 71 30020 Spotlight Men's 6 1/2 752 203.5 153,032.00 2,346 H-4 205.27 481,563.42 72 30030 Spotlight Men's 1,046 203.5 212,861.00 2,518 H-4 205.27 516,869.86 73 30040 Spotlight Men's ' 1/2 776 203.5 157,916.00 3,147 H-4 205.27 645,984.69 74 30050 Spotlight Men's 10o 624 203.5 126,984.00 3.107 H-4 205.27 637,773.89 75 30060 Spotlight Men's 8 1/2 864 203.5 175,824.00 2,560 H-4 205.27 525,491.20 30070 Spotlight Men's 9 980 203.5 199,430.00 3,361 H-4 205.27 689,912.47 30080 Spotlight Men's 9 1/2 774 203.5 157,509.00 3,187 H-4 205.27 654,195.49 78 30090 Spotlight Men's 710 203.5 144,485.00 2,641 H-4 205.27 542,118.07 79 30100 Spotlight Men's 10 1/2 1,310 203.5 266,585.00 2,633 H-4 205.27 540,475.91 80 30110 Spotlight Men's 11 1.244 203.5 253,154.00 2,161 H-4 205.27 443,588.47 81 30120 Spotlight Men's 11 1/2 808 203.5 64,428.00 2,304 H-4 205.27 472,942.08 82 30130 Spotlight Men's 12 442 203.5 89,947.00 1,518 H-4 205.27 311,599.86 83 30140 Spotlight Men's 12 1/2 170 203.5 34,595.00 565 H-4 205.27 115,977.55 102 740 20 H-2.1 Thru H-2.7 Inv. Counts H-3 Inventory 12-31 H-4 Inventory Counts H-5 Purchase Summary H-6 LCNRV Calc H-7 Inventory Obs. Calculation + Ready + 100%Apollo_Inventory Audit Mini_Case Q Search Sheet Home Insert Page Layout Formulas Data Review View "+ Share ~ Insert Times New... 12 A- A = = Wrap Text General AP. * Delete Paste B h . A . EE Merge & Center $ ~ % 00 .00 Conditional Format Cell Sort & Formatting as Table Styles Format Filter x Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates A109 X V fx B C D E F G H K M N O P Q R S T U V 77 30080 Spotlight Men's 9 1/2 774 203.5 157,509.00 3,187 H-4 205.27 654,195.49 78 30090 Spotlight Men's 10 710 203.5 144,485.00 2,641 H-4 205.27 542,118.07 79 30100 Spotlight Men's 10 1/2 1,310 203.5 266,585.00 2,633 H-4 205.27 540,475.91 80 30110 Spotlight Men's 11 1,244 203.5 253,154.00 2,161 H-4 205.27 443,588.47 81 30120 Spotlight Men's 11 1/2 808 203.5 164,428.00 2,304 H-4 205.27 472,942.08 82 30130 Spotlight Men's 12 442 203.5 89,947.00 1,518 H-4 205.27 311,599.86 83 30140 Spotlight Men's 12 1/2 170 203.5 34,595.00 565 H-4 205.27 115,977.55 84 30150 Spotlight Men's 13 268 203.5 54,538.00 939 H-4 205.27 192,748.53 85 30160 Spotlight Men's 14 394 203.5 80,179.00 1,270 H-4 205.27 260,692.90 86 30170 Spotlight Men's 15 354 203.5 72,039.00 1,320 H-4 205.27 270,956.40 87 30180 Spotlight Men's 23 3,854 197.16 759.854.64 2.234 H-4 197.16 440,455.44 88 30190 Spotlight Women's 5 520 203.5 105,820.00 1,884 H-4 205.27 386,728.68 89 30200 Spotlight Women's 5 1/2 518 203.5 105,413.00 3,760 H-4 205.27 771,815.20 90 30210 Spotlight Women's 6 722 203.5 146,927.00 4,096 H-4 205.27 840,785.92 91 30220 Spotlight Women's 6 1/2 842 203.5 171,347.00 4,582 H-4 205.27 940,547.14 92 30230 Spotlight Women's 666 203.5 135,531.00 3,531 H-4 205.27 724,808.37 93 30240 Spotlight Women's 7 1/2 1,394 203.5 283,679.00 4,901 H-4 205.27 1,006,028.27 94 30250 Spotlight Women's 8 .024 203.5 208,384.00 3,779 H-4 205.27 775,715.33 95 30260 Spotlight Women's 8 1/2 924 203.5 188,034.00 4,489 H-4 205.27 921,457.03 96 30270 Spotlight Women's S 1,028 203.5 209,198.00 4,316 H-4 205.27 885,945.32 97 30280 Spotlight Women's 9 1/2 1,290 203.5 262,515.00 4,134 H-4 205.27 848,586.18 98 30290 Spotlight Women's 10 1,188 203.5 241,758.00 3,762 H-4 205.27 772,225.74 99 30300 Spotlight Women's 10 1/2 652 203.5 132,682.00 2,071 H-4 205.27 425,114.17 100 30310 Spotlight Women's 11 928 203.5 188,848.00 3.127 H-4 205.27 641,879.29 30320 Spotlight Women's 11 1/2 986 203.5 200,651.00 3,079 H-4 205.27 632,026.33 102 30330 Spotlight Women's 12 542 203.5 110,297.00 3,330 H-4 205.27 683,549.10 103 30340 Spotlight Women's 12 1/2 472 203.5 96,052.00 3,185 H-4 205.27 653,784.95 104 30350 Spotlight Women's 13 408 203.5 83,028.00 2,063 H-4 205.27 123,472.01 105 18,825,464.77 67, 724,527.50 106 107 108 109 H-2.1 Thru H-2.7 Inv. Counts H-3 Inventory 12-31 H-4 Inventory Counts H-5 Purchase Summary H-6 LCNRV Calc H-7 Inventory Obs. Calculation + Ready + 100%Apollo_Inventory_Audit Mini_Case Q Search Sheet "+ Share ~ Home Insert Page Layout Formulas Data Review View Insert E . Times New... 12 A - A - Wrap Text General AP . * Delete Cell Sort & Paste B I U. E Merge & Center $ ~ % " Conditional Format Formatting as Table Styles Format Filter Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates A1 V X V fx K L M N 0 P Q R S T U V W A B C D E F G H I J H-4 Inventory Warehouse Report -- Post Physical Inventory Count PBC WNH 31-Dec-20 Pallet Total 5 Pallet Location Sku# Style Type Size Quantity Quantity 6 Al 10010 Siren Men's 1,080 7 A2 10010 Siren Men's 1,080 8 A3 10010 Siren Men's 1,080 9 A4 10010 Siren Men's 7 762 4,002 H-3 10 A5 10020 Siren Men's 7 1/2 1,080 11 A6 10020 Siren Men's 7 1/2 1,080 12 A7 10020 Siren Men' 7 1/2 1,080 13 A8 10020 Siren Men's 7 1/2 1.080 14 A9 10020 Siren Men's 7 1/2 252 4,572 H-3 15 A10 030 Siren Men' ,080 H-2.7 16 All 10030 Siren Men's 1,080 H-2.7 00 00 00 00 17 A12 10030 Siren Men's 1,080 H-2.7 18 A13 10030 Siren Men's 890 H-2.7 4,130 H-3 19 A14 10040 Siren Men's 3 1/2 1080 20 A15 10040 Siren Men's 8 1/2 1,080 21 A16 10040 Siren Men's 8 1/2 .,080 22 A17 10040 Siren Men's 8 1/2 839 4,079 H-3 23 A18 0050 Siren Men's ,080 24 A19 10050 Siren Men's 1,080 25 A20 10050 Siren Men's 6 6 6 1,080 26 A21 10050 Siren Men's 1,080 27 A22 10050 Siren Men's 17 4,337 H-3 28 A23 10060 Siren Men's 1/2 1,080 29 A24 10060 Siren Men's 9 1/2 1,080 30 A25 10060 Siren Men's 1/2 1.080 31 A26 10060 Siren Men's 9 1/2 1.080 32 A27 10060 Siren Men's 91/2 320 4,640 H-3 33 A28 10070 Siren Men's 10 1,080 H-2.1 Thru H-2.7 Inv. Counts H-3 Inventory 12-31 H-4 Inventory Counts H-5 Purchase Summary H-6 LCNRV Calc H-7 Inventory Obs. Calculation + + 100% EnterApollo_Inventory_Audit Mini_Case Q Search Sheet "+ Share ~ Home Insert Page Layout Formulas Data Review View Insert E . Times New... 12 A - A - Wrap Text General AP . * Delete B $ ~ % " Conditional Format Cell Sort & Paste I U. E Merge & Center Formatting as Table Styles Format Filter Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates A1 V X V fx C D E F G H I J K L M N 0 P R S T V W B Q U A H-4 Inventory Warehouse Report -- Post Physical Inventory Count PBC WNH 31-Dec-20 Pallet Total 5 Pallet Location Sku# Style Type Size Quantity Quantity 6 Al 10010 Siren Men's 1,080 7 A2 10010 Siren Men's 1,080 8 A3 10010 Siren Men's 1,080 9 A4 10010 Siren Men's 7 762 4,002 H-3 10 A5 10020 Siren Men's 7 1/2 1,080 11 A6 10020 Siren Men's 7 1/2 1,080 12 A7 10020 Siren Men' 7 1/2 1,080 13 A8 10020 Siren Men's 7 1/2 1.080 14 A9 10020 Siren Men's 7 1/2 252 4,572 H-3 15 A10 030 Siren Men' ,080 H-2.7 16 All 10030 Siren Men's 1,080 H-2.7 00 00 00 00 17 A12 10030 Siren Men's 1,080 H-2.7 18 A13 10030 Siren Men's 890 H-2.7 4,130 H-3 19 A14 10040 Siren Men's 3 1/2 1080 20 A15 10040 Siren Men's 8 1/2 1,080 21 A16 10040 Siren Men's 8 1/2 .,080 22 A17 10040 Siren Men's 8 1/2 839 4,079 H-3 23 A18 0050 Siren Men's ,080 24 A19 10050 Siren Men's 1,080 25 A20 10050 Siren Men's 6 6 6 1,080 26 A21 10050 Siren Men's 1,080 27 A22 10050 Siren Men's 17 4,337 H-3 28 A23 10060 Siren Men's 1/2 1,080 29 A24 10060 Siren Men's 9 1/2 1,080 30 A25 10060 Siren Men's 1/2 1.080 31 A26 10060 Siren Men's 9 1/2 1.080 32 A27 10060 Siren Men's 91/2 320 4,640 H-3 33 A28 10070 Siren Men's 10 1,080 H-2.1 Thru H-2.7 Inv. Counts H-3 Inventory 12-31 H-4 Inventory Counts H-5 Purchase Summary H-6 LCNRV Calc H-7 Inventory Obs. Calculation + + 100% EnterApollo_Inventory Audit Mini_Case Q Search Sheet Page Layout Data Review "+ Share ~ Home Insert Formulas View Insert Times New... 12 A- A = = 1 Wrap Text General AP. * Delete I UV A . Merge & Center $ ~ % " 00 .00 Conditional Format Cell Sort & Paste B ELE Formatting as Table Styles Format Filter Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates A63 X V fx A58 T U V W A B C D E F G H I J K L M N 0 P Q R S 32 A27 10060 Siren Men's 9 1/2 320 4,640 H-3 33 A28 10070 Siren Men's 10 ,080 34 A29 10070 Siren Men's 10 1,080 35 A30 10070 Siren Men's 10 1,080 36 A31 10070 Siren Men's ,080 37 A32 10070 Siren Men's 10 520 4,840 H-3 38 A33 0080 Siren Men's 10 1/2 ,080 39 A34 10080 Siren Men's 10 1/2 1.080 40 A35 10080 Siren Men's 10 1/2 1,080 41 A36 10080 Siren Men's 10 1/2 1,080 42 A37 10080 Siren Men's 10 1/2 265 4,585 H-3 43 A38 10090 Siren Men's 11 1,080 44 A39 10090 Siren Men's 11 1,080 45 A40 10090 Siren Men's 11 1,080 46 A41 10090 Siren Men's 11 404 3,644 H-3 47 A42 10100 Siren Men' 1 1 1/2 1,080 48 A43 10100 Siren Men's 11 1/2 694 1,774 H-3 49 A44 10110 Siren Men' 12 1,080 50 A45 10110 Siren Men's 12 1,080 51 A46 10110 Siren Men' 12 1,080 52 A47 10110 Siren Men's 12 392 3,632 H-3 53 A48 10120 Siren Men's 2 1/2 ..080 54 A49 10120 Siren Men's 12 1/2 1,080 55 A50 10120 Siren Men's 12 1/2 260 2,420 H-3 56 A51 0130 Siren Men's 13 1,080 57 A52 10130 Siren Men's 13 344 1,424 H-3 58 A53 0140 Siren Men's 13 1/2 746 746 H-3 59 A54 10150 Siren Men's 14 108 408 H-3 60 A55 10160 Siren Men's 14 1/2 352 352 H-3 61 A56 10170 Siren Women's 1,080 62 A57 10170 Siren Women's 747 1,827 H-3 63 A58 10180 Siren Women's 5 1/2 1,080 64 A59 10180 Siren Women's 5 1/2 1.080 H-2.1 Thru H-2.7 Inv. Counts H-3 Inventory 12-31 H-4 Inventory Counts H-5 Purchase Summary H-6 LCNRV Calc H-7 Inventory Obs. Calculation + + 100% ReadyApollo_Inventory Audit Mini_Case Q Search Sheet "+ Share ~ Home Insert Page Layout Formulas Data Review View Insert Times New... 12 A- A = = 1 Wrap Text General AP. * Delete Paste B A . Merge & Center $ ~ % " 00 .00 Conditional Format Cell Sort & Formatting as Table Styles Format Filter x Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates A94 V X V fx A89 U V W A B C D E F G H I J K L M N 0 P Q R S T 62 A57 10170 Siren Women's 5 747 1,827 H-3 63 A58 10180 Siren Women's 5 1/2 1,080 64 A59 10180 Siren Women's 5 1/2 1,080 65 A60 10180 Siren Women's 5 1/2 421 2,581 H-3 66 A61 0190 Siren Women's 6 ,080 67 A62 10190 Siren Women's 1,080 a a 68 A63 0190 Siren Women's .,080 69 A64 10190 Siren Women's 6 889 4,129 H-3 70 A65 0200 Siren Women's 5 1/2 ,080 H-2.2 71 A66 10200 Siren Women's 6 1/2 1,080 H-2.2 72 A67 10200 Siren Women's 6 1/2 1,080 H-2.2 73 A68 10200 Siren Women's 6 1/2 1080 H-2.2 74 A69 10200 Siren Women's 6 1/2 680 H-2.2 5000 H-3 75 A70 10210 Siren Women's 1,080 76 A71 10210 Siren Women's 1,080 77 A72 10210 Siren Women's 1,080 78 A73 10210 Siren Women's 1,080 79 A74 10210 Siren Women's 1,080 80 A75 10210 Siren Women's 381 5,781 H-3 81 A76 10220 Siren Women's 7 1/2 .080 82 A77 10220 Siren Women's 7 1/2 1,080 83 A78 10220 Siren Women's 7 1/2 1,080 84 A79 10220 Siren Women's 7 1/2 251 3,491 H-3 85 A80 0230 Siren Women's 1,080 86 A81 10230 Siren Women's 1,080 87 A82 10230 Siren Women's 00 00 00 00 00 1,080 88 A83 10230 Siren Women's 080 89 A84 10230 Siren Women's 436 4,756 H-3 90 A85 10240 Siren Women's 8 1/2 1,080 91 A86 10240 Siren Women's 8 1/2 1,080 92 A87 10240 Siren Women's 8 1/2 490 2,650 H-3 93 A88 10250 Siren Women's 9 1,080 94 A89 10250 Siren Women's 1,080 H-2.1 Thru H-2.7 Inv. Counts H-3 Inventory 12-31 H-4 Inventory Counts H-5 Purchase Summary H-6 LCNRV Calc H-7 Inventory Obs. Calculation + + 100% ReadyApollo_Inventory Audit Mini_Case Q Search Sheet Home Insert Page Layout Formulas Data Review View "+ Share ~ Times New... 12 A- A = Insert = 1 Wrap Text General AP. * Delete Paste B Merge & Center $ ~ % " 00 .00 Conditional Format Cell Sort & Formatting as Table Styles Format Filter Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates A122 X V fx B13 A B D E F G H I J K L M N 0 P Q R S T U V W 91 A86 10240 Siren Women's 8 1/2 1,080 92 A87 10240 Siren Women's 8 1/2 490 2,650 H-3 93 A88 10250 Siren Women's 1,080 94 A89 10250 Siren Women's 1,080 6 6 6 6 95 A90 0250 Siren Women's 1,080 96 A91 0250 Siren Women's 1,080 97 A92 10250 Siren Women's 253 4,573 H-3 98 A93 0260 Siren Women's 9 1/2 ,080 99 A94 10260 Siren Women's 9 1/2 1.080 100 A95 10260 Siren Women's 9 1/2 513 2,673 H-3 101 A96 10270 Siren Women's 10 .080 102 A97 10270 Siren Women's 992 2,072 H-3 103 A98 10280 Siren Women's 10 1/2 1,080 104 A99 10280 Siren Women's 10 1/2 635 1,715 H-3 105 A100 10290 Siren Women's 11 740 740 H-3 106 A101 10300 Siren Women's 11 1/2 658 58 H-3 107 A10 10310 Siren Women' 12 509 509 H-3 108 A10 10320 Siren Women's 12 1/2 323 823 H-3 109 A104 0330 Siren Women's 13 968 968 H-3 110 B1 20010 Speaker Men's ,080 111 B2 010 Speak 1,080 112 B3 r Men's 1,080 a a a a a o 113 B4 20010 Speaker Men's ,080 114 B5 20010 Speaker Men's 1,080 115 B6 20010 Speaker Men's 1,080 116 B7 20010 Speaker Men's 6 643 7,123 H-3 117 B8 20020 Speaker Men's 1/2 1,080 118 B9 20020 Speaker Men's 6 1/2 1.080 119 B10 20020 Speaker Men's 6 1/2 1.080 120 B11 20020 Speaker Men's 6 1/2 121 B12 20020 Speaker Men's 6 1/2 1,080 122 B13 20020 Speaker Men's 6 1/2 1,080 123 B14 20020 Speaker Men's 6 1/2 1.080 H-2.1 Thru H-2.7 Inv. Counts H-3 Inventory 12-31 H-4 Inventory Counts H-5 Purchase Summary H-6 LCNRV Calc H-7 Inventory Obs. Calculation + Ready + 100%Apollo_Inventory Audit Mini_Case Q Search Sheet Home Insert Page Layout Formulas Data Review View "+ Share ~ 12 = Insert Times New... A- A = 1 Wrap Text General AP. * Delete Paste B I U. A . Merge & Center $ ~ % " 00 .00 Conditional Format Cell Sort & Formatting as Table Styles Format Filter Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates A154 V X V fx B45 A B D E F G H J K L M N 0 P Q R S T U V W 122 B13 20020 Speaker Men's 6 1/2 1,080 123 B14 20020 Speaker Men's 6 1/2 1,080 124 B15 20020 Speaker Men's 6 1/2 791 8,351 H-3 125 B16 20030 Speaker Men's ,080 126 B17 20030 Speaker Men's 1,080 127 B18 20030 Speaker Men's 1,080 128 B19 20030 Speaker Men's 1.080 129 B20 20030 Speaker Men' 1,080 130 B21 20030 Speaker Men's 1,080 131 B22 20030 Speaker Men's 1,080 132 B23 20030 Speaker Men's 1,080 133 B24 20030 Speaker Men's 7 530 9,170 H-3 134 B25 20040 Speaker Men's 7 1/2 1,080 H-2.3 135 B26 20040 Speaker Men's 7 1/2 1,080 H-2.3 136 B27 20040 Speaker Men's 7 1/2 1.080 H-2.3 137 B28 20040 Speaker Men's 7 1/2 1,080 H-2.3 138 B29 20040 Speaker Men's 7 1/2 1,080 H-2.3 139 B30 20040 Speaker Men's 7 1/2 1,080 H-2.3 140 B31 20040 Speaker Men's 7 1/2 1,080 H-2.3 141 B32 20040 Speaker Men's 7 1/2 1,080 H-2.3 142 B33 20040 Speaker Men's 7 1/2 1,080 H-2.3 143 B34 20040 Speaker Men's 7 1/2 1,080 H-2.3 144 B35 20040 Speaker Men's 7 1/2 1,080 H-2.3 145 B36 20040 Speaker Men's 7 1/2 1,080 H-2.3 146 B37 20040 Speaker Men's 7 1/2 1,080 H-2.3 147 B38 20040 Speaker Men's 7 1/2 2,788 H-2.3 16,828 H-3 148 B39 20050 Speaker Men's 1,080 149 B40 20050 Speaker Men's 1,080 150 B41 Men's 1.080 151 B42 20050 Speaker Men's 10 00 00 00 00 00 00 1,080 152 B43 20050 Speaker Men's 1,080 153 B44 20050 Speaker Men's 1,080 154 B45 20050 Speaker Men's ,080 H-2.1 Thru H-2.7 Inv. Counts H-3 Inventory 12-31 H-4 Inventory Counts H-5 Purchase Summary H-6 LCNRV Calc H-7 Inventory Obs. Calculation + Ready + 100%Apollo_Inventory Audit Mini_Case Q Search Sheet Home Insert Page Layout Formulas Data Review View "+ Share ~ Times New... 12 A- A = Insert = 1 Wrap Text General AP. * Delete Paste B I U A . EE Merge & Center $ ~ % " 00 .00 Conditional Format Cell Sort & Formatting as Table Styles Format Filter Office Update To keep up-to-date with security updates, fixes, and improvements, choose Check for Updates. Check for Updates A185 V X V fx B76 A B D E F G H J K L M N 0 P Q R S T U V W 153 B44 20050 Speaker Men's 1,080 154 B45 20050 Speaker Men's 1,080 00 00 00 00 155 B46 20050 Speaker Men's 1,080 156 B47 20050 Speaker Men's 1,080 157 B48 20050 Speaker Men's .080 158 B49 20050 Speaker Men's 740 11,540 H-3 159 B50 20060 Speaker Men's 3 1/2 ,080 160 B51 20060 Speaker Men' 8 1/2 1,080 161 B52 20060 Speaker Men's 8 1/2 1,080 162 B53 20060 Speaker Men's 8 1/2 1,080 163 B54 20060 Speaker Men's 8 1/2 1,080 164 B55 20060 Speaker Men's 8 1/2 1,080 165 B56 20060 Speaker Men's 8 1/2 1.080 166 B57 20060 Speaker Men's 8 1/2 1.080 167 B58 20060 Speaker Men's 8 1/2 168 B59 20060 Speaker Men's 8 1/2 1,080 169 B60 20060 Speaker Men's 8 1/2 1,080 170 B61 20060 Speaker Men's 8 1/2 1,080 171 B62 20060 Speaker Men's 8 1/2 1.080 172 B63 20060 Speaker Men's 8 1/2 1.080 173 B64 20060 Speaker Men's 8 1/2 153 15,273 H-3 174 B65 20070 Speaker Men's 1,080 175 B66 20070 Speaker Men's 1,080 176 B67 20070 Speaker Men's 1,080 177 B68 20070 Speaker Men's 1,080 178 B69 20070 Speaker Men's 1,080 179 B70 20070 Speaker Men's 1,080 180 B71 Men's 1,080 181 B72 20070 Speaker Men's 1,080 182 B73 20070 Speaker Men's 1,080 183 B74 20070 Speaker Men'

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!