QUESTION: Switch to the Inventory Listing tab and, in the appropriate location, enter a formula to display the fifth-year LIFO inventory balance for 4K Ultra HD TVs.

B C D E F G H K L M N 1 Electronic World - Inventory Listing 2 Total Categories = 71 3 Department 12 33 75 23 98 41 58 12 33 98 58 41 23 75 58 33 12 98 41 41 98 98 4 Product Category 5 4K Ultra HD TV's 6 LED TV's 7 Outdoor TV'S 8 8 OLED TV's 9 Curved TV'S 10 Projectors & Screens 11 Home Theatre Systems 12 Sound Bars 13 Speakers 14 Receivers & Amplifiers 15 Stereo Shelf Systems 16 Wireless & Multiroom Audio 17 CD Players & Turntables 18 Headphones 19 Blu-Ray Players 20 3D Blu-Ray Players 21 DVD Players 22 Streaming Media Players 23 Streaming Blu-Ray Players 24 DVR'S 25 Remote TV Streaming 26 TV Stands 27 TV Mounts 28 AN Component Racks 29 AN Component Shelving 30 Home Theatre Seating 31 Gaming Chairs 32 Speaker Stands & Mounts 33 TV Mount Finder 34 TV Antennas 35 HDMI Cables 36 A Cables & Connectors 37 Remote Controls 38 3D Accessories 39 Home Theatre Networking 40 TV & Media Cleaning & Care 41 AN Switchers 42 2-in-1's 43 Kids Tablets 44 E-Readers 45 Standard Laptops 46 Laptop Packages 47 Gaming Laptops 48 Desktop Packages 49 Desktop Towers Shipping Region North Southwest South East Coast Southwest Central West Coast Southwest Northeast West Coast Southeast North Northeast South North North Mountain Mountain Southeast Central Northwest Mountain Southwest Northwest Central Northwest Central West Coast West Coast North Southeast Northeast North Southwest North Northwest Southwest Southwest West Coast Central North South South East Coast Central Internal Classification Level 3 Level 6 Level 3 Level 2 Level 8 Level 2 Level 2 Level Level 6 Level 3 Level 3 Level 9 Level 3 Level 2 Level 2 Level 3 Level 3 Level 3 Level 6 Level 6 Level 8 Level 6 Level 6 Level 3 Level 3 Level Level 3 Level 2 Level 3 Level 3 Level 2 Level 6 Level 6 Level 9 Level 3 Level 9 Level 2 Level 2 Level 3 Level 3 Level 9 Level 8 Level 6 Level 6 Level 2 Ending Inventory Ending Inventory Ending Inventory Ending Inventory Ending Inventory Balance - Year 1 Balance - Year 2 Balance - Year 3 Balance - Year 4 Balance - Year 5 $ 9,122 $ 11.405 $ 10,035 $ 8.550 $ 19.157 $ $ 21.440 $ 20,070 $ 19.614 $ $ 10,100 $ - $ 9,122 $ 13,685 $ 7,298 $ $ $ 14,140 $ 7,755 $ 6,385 $ 3,194 $ 4,105 $ 2,737 S $ 913 $ 1,368 $ 5,018 $ 4,561 $ 4,561 $ 4,561 $ 4,790 $ 5,377 $ 5,931 $ $ $ 4,334 $ $ $ $ 1,597 $ 913 $ 1,824 $ 28,281 $ 26,001 $ 22,351 $ 24,175 $ 30,105 $ 32,386 5 $ 33,755 5 34,212S 32,386 $ 27,368 $ 22.807 $ 22,807 $ 25,088 $ $ 24,175 $ 23.948 $ 16,422 $ 17,106 $ 17,790 $ 16,649 $ 15,509 $ 12,772 $ 12,316 S 5 11,405 $ $ 11,859 $ 12,088 $ $ 21.440 $ 5,931 $ $ 11,859 $ 1,597 $ 1,734 $ $ 4,105 $ 4,334 $ 3,421 $ 5,109 $ 3,877 $ 5,018 S 4,834 S 4,469 $ $ $ $ $ 1,368 $ 1,413 $ 28,281 $ 24,175 S 13,685 S $ 2,281 $ $ 20,983 S $ 21,894 S 22,351 $ 20,983 $ 20,983 $ 10,492 $ 11,859 $ 12,088 $ 10,035 $ 8,668 $ 18,246 $ 19,157 $ 19,843 $ $ 20,070 $ 21,894 $ $ $ $ 8,211 $ $ 14,825 $ 13,685 $ $ 17,562 S 16,422 $ 12,316 $ 19,157 $ 18.474 $ 17,562 $ 17,790 S 20,070 $ 28,509 $ 27,825 $ 26,457 $ $ 22,351 $ 24,404 $ $ - $ $ 2,737 S 15,966 $ 1,824 $ $ 2,053 $ - $ $ 1,368 $ 29,649 $ 27,368 $ 28,281 S $ 28,738 $ 28,509 $ 43,334 S 46,528 $ 47,668 $ 40,141 $ $ 62,037 $ 63,861 S 60,211 $ 63,177 $ 52,275 $ 39,229 $ 37,404 $ 35,579 $ $ $ 18.246 $ 19,157 $ 19,843 S $ 22,124 $ $ 13,685 $ $ $ 12,772 $ 9,579 $ 25,544 5 23,720 $ 24,175 $ 23,264 $ 22,351 $ 3,877 $ 5,245 $ 6,477 $ $ 6,796 $ 4,380 $ 1,459 $ 2,053 $ 730 $ $ 2,510 $ S $ $ $ 27,368 $ 36,492 $ 38,317 $ 36,947 $ 5,931 $ $ 43,791 $ 10,492 $ $ $ $ 34,667 $ 32,386 $ 33,755 $ 36,036 S 19,614 $ 25 544 $ 5,931 $ $ 1,368 S $ 12,316 $ $ $ $ $ 43,791 $ 4,380 $ 4,015 $ S 3,969 $ $ 2,737 $ 3,329 $ 27,825 $ 24,175 $ 26,457 $ 25,317 $ 18,703 $ 7,298 $ $ 8,211 $ 5,245 $ 4,790 $ 5,474 Number of Average Inventory Maximum Inventory Minimum Inventory Years Balance Balance Balance 4 $ 9,778 S 11,405 $ 8,550 5 $ 16,056 $ 21,440 $ 5 5 $ 6,581 $ 13,685 S $ 5 $ 7,116 $ 14,140 S $ 5 $ 2.463 $ 4,105 S 913 5 $ 4,698 $ 5,018 $ 4,561 5 $ 3,128 S 5,931 $ 5 $ 867 $ 1.824 $ 5 $ 26,183 $ 30,105 $ 22,351 5 $ 32,021 $ 34,212 S 27,368 5 $ 23,765 $ 25,088 $ $ 22,807 5 $ 16,695 $ 17,790 $ 15,509 5 $ 12,088 $ 12,772 $ 11405 5 $ 7.846 $ 21,440 $ 5 $ 3,038 $ 4,334 $ 1,597 5 $ 4,661 $ 5,109 $ 3,877 5 $ 556 $ 1,413 $ $ 5 $ 13,684 S $ 28,281 $ 5 $ 21,439 $ 22,351 $ 20.983 5 $ 10,628 $ 12,088 $ 8,668 5 $ 19,842 $ 21,894 $ 18,246 5 $ 1,642 $ 8,211 $ 5 $ 14,962 $ 17,562 $ 12,316 5 $ 18,611 $ 20,070 $ 17,562 5 $ 25,909 $ 28,509 5 $ 22,351 5 $ 3,741 $ 15,966 $ 5 $ $ 1,049 $ 2,053 S 5 $ 28,509 5 $ 29,649 $ 27,368 5 $ 35,534 $ 47,668 5 $ 5 S 60,312 $ 63,861 $ 52 275 5 $ 22,442 $ 39,229 $ 5 $ 15,874 $ 22,124 $ 5 $ 7,207 $ 13,685 $ 5 $ 23,811 $ 25,544 $ 22,351 5 $ 5,355 $ 6,796 $ 3,877 5 $ 1,350 $ 2,510 $ 5 $ 5,474 $ 27,368 $ 5 $ 23,537 $ 38,317 S $ 5 $ 10,857 $ 43,791 $ 5 $ 31,292 $ 36,036 $ 19,614 5 S 9,032 $ 25,544 $ 5 $ 8,758 $ 43,791 $ 5 $ 3,686 $ 4,380 S $ 2,737 5 $ 24,495 $ 27825 18,703 5 $ 6,204 $ 8,211 $ $ 4,790 58 23 23 12 75 75 33 58 98 98 58 58 58 41 12 98 98 12 12 12 75 23 33 A B C D D E F G G H ] K L M N 5,474 16,193 4,790 8,668 33 33 58 98 8,211 1,824 23 41 12 75 41 14,140 2,829 22,351 41 98 75 33,299 18.703 5,474 12,772 5 49 Desktop Towers 50 Gaming Desktops 51 Gaming Monitors 52 LCD Monitors 53 LED Monitors 54 Routers 55 DSL & Cable Modems 56 Network Cards 57 USN Wireless Adapters 58 Range Extenders 59 Ethernet Hubs & Switches 60 External Hard Drives 61 Internal Hard Drives 62 Solid State Drives 63 USB Flash Drives 64 3D Printers & Filament 65 All-in-One Printers 66 Inkjet Printers 67 Laser Printers 68 Photo Printers 69 Portable Printers 70 Ink & Toner 71 Speakers 72 Bookshelf Speakers 73 Floor Speakers 74 Subwoofer Speakers 75 Outdoor Speakers 76 Totals: 77 75 58 23 33 Central Northwest Mountain Northeast Central Southwest West Coast Southwest East Coast West Coast Central Southwest Mountain Southeast Central Southwest Northeast Northeast South East Coast North North South East Coast Southeast East Coast Southeast Level 2 Level 6 Level 3 Level 6 Level 2 Level 2 Level 3 Level Level 3 Level 3 Level 3 Level 6 Level 6 Level 2 Level 6 Level 2 Level 2 Level 9 Level 9 Level 3 Level 9 Level 6 Level 6 Level 3 Level 3 Level 8 Level 8 $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ 7,298 $ 8.668 $ $ 16,422 $ 8,211 $ 3,421 $ $ 17,333 $ 2.964 $ 31,929 $ 25,544 $ 41,510 $ 22,580 $ 5,474 $ $ 6,204 $ 2,714 $ 4,265 $ 4,569 $ 506 $ $ 1,356 $ 4,343 $ S $ 7,927 $ 2,388 $ 4,775 $ 8,987 $ 960,004 $ 8,211 $ 10,492 $ 15,966 $ 8,438 $ 4,105 $ $ $ 17,790 $ 2.829 S $ 34,667 $ $ 40,141 $ 18,703 $ $ $ $ 3,490 $ S 3,877 $ 5,040 $ $ $ 7,355 $ 1.473 $ 3,295 $ $ 7,946 $ 2,483 $ 5,100 $ 7,354 5 $ 876,439 S 5,245 $ 11,859 $ 14,140 S $ 8,895 $ 4,380 $ 2,964 $ 15,966 $ 2,918 $ 33,755 $ $ 39,229 $ 19,614 $ 12,088 $ 28,738 $ 12,020 $ 2,326 $ 3,877 $ $ 1,356 $ 5,040 $ 3,490 $ 4,265 $ $ 8,098 $ 3,438 $ 5,426 $ 6,952 S 890,129 $ 4,790 $ 12,772 $ $ 11,859 $ 3,740 $ $ 7,481 $ 16,422 $ 3,512 $ 28,738 5 $ $ 35,352 $ 24,861 $ 10,948 $ 26.457 $ 6,591 $ 775 $ 3,877 $ 4,085 $ 775 $ $ 3,682 $ 4,110 $ 1,163 $ 7,602 $ $ 4,548 $ 5,539 $ 790,624 S 10,492 1,824 12,772 14,140 3,329 22,351 5,931 33,299 23,720 12,545 18,017 5,428 1,163 4,070 3,682 1,551 10,081 2,907 3,799 1,201 8,442 5 $ 5 $ 5 $ 5 $ 5 5 $ 5 $ 5 $ 5 $ 5 $ 5 S 5 5 $ 5 $ 5 S 5 S 5 $ 5 S 5 $ $ 5 $ 5 S 5 $ 5 5 $ 5 S 5 $ 5 S 5 $ 5 $ 5 $ 6,204 $ 11,997 $ 9,306 $ 9,579 $ 3,494 $ $ 4,643 $ 16,330 S $ 3,110 $ $ 30,288 S 6,295 $ 37,906 $ 21,896 $ 10,765 $ 14,642 5 $ 6,049 $ 2,094 5 $ 3,993 $ 3,475 $ S 838 $ 4,495 $ 2,582 $ 3,962 $ 473 $ 8,003 $ $ 1,662 $ 5,107 $ 6,431 $ 8.211 $ 16,193 $ 16,422 $ 11,859 $ 4,380 $ 12,772 S 17,790 $ 3,512 S 34,667 $ 25,544 $ 41,510 $ 24,861 5 12,772 $ 28,738 $ 12,020 $ 3,490 S S 4,265 $ 5,040 $ 1,551 $ 10,081 $ 3,682 $ $ 4,343 $ 1,2015 $ 8.442 $ 3,438 $ 5,688 $ 8,987 $ 775 3,877 33 23 12 58 58 1,356 3.295 33 23 75 75 98 7,602 5,688 3,323 783,996 4,548 3,323 98 Sanding Accessories Inventory Costing Method Comparison Methods to be used: Units in Ending Inventory: Last-In, First-Out First-In, First-Out Weighted Average 23 Units 18 in un 21 Beginning Inventory Purchase #1 Purchase #2 Purchase #3 Purchase #4 Cost per Unit Total $ 475 $ 8,550 $ 477 $ 10,017 $ $ 478 $ 9,082 $ 480 $ 16,320 $ 482 $ 5,784 $ 49,753 19 34 12 104 LIFO Inventory Balance: FIFO Inventory Balance: WA Inventory Balance: in un $ $ $ 10,935 11,064 11,003