Insert a PivotTable and a PivotChart 15. Create a PivotTable on the Inventory Listing tab based on the inventory balances displayed for all five years. 16. Rename the new worksheet tab containing the PivotTable. 17. Display the Year 5 Inventory Balances within the PivotTable with: Department in the Rows area Product Category in the Columns area A filter that excludes the Northeast shipping region 18. Add a slicer that limits the data to product categories with an internal classification of at least Level 6. 19. Create a Clustered Bar PivotChart and display the Internal Classification category in the legend
$ $ $ $ $ $ $ $ $ 5 $ 5$ 5 $ 5 $ 5 $ 5 $ 5 $ 5 $ 5 $ 5$ 14,140 2,829 22,351 - 33,299 18,703 5,474 - 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 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 3 Level 8 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 5$ 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 $ - $ 7,927 $ 2,388 $ 4,775 $ 8,987 $ 960,004 $ 17,790 $ 2,829 $ 34,667 $ - $ 40,141 $ 18,703 $ 12,772 $ - $ - $ 3,490 $ 3,877 $ 5,040 $ - $ 7,355 $ 1,473 $ 3,295 $ - $ 7,946 $ 2,483 $ 5,100 $ 7,354 $ 876,439 $ 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 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 $ 890,129 $ 16,422 $ 3,512 $ 28,738 $ - $ 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 $ 16,330 $ 3,110 $ 30,288 $ 6,295 $ 37,906 $ 21,896 $ 10,765 $ 14,642 $ 6,049 $ 2,094 $ 3,993 $ 3,475 $ 838 $ 4,495 $ 2,582 $ 3,962 $ 473 $ 8,003 $ 1,662 $ 5,107 $ 6,431 $ $ $ $ $ $ $ $ $ $ $ $ $ 17,790 $ 3,512 $ 34,667 $ 25,544 $ 41,510 $ 24,861 $ 12,772 $ 28,738 $ 12,020 $ 3,490 $ 4,265 $ 5,040 $ 1,551 $ 10,081 $ 3,682 $ 4,343 $ 1,201 $ 8,442 $ 3,438 $ 5,688 $ 8,987 $ 775 3,877 -. 5$ 5 $ 5$ 5$ 1,356 3,295 5 s 5 $ 5 $ 5 $ 5 $ 5$ 7,602 - 4,548 3,323 98 5,688 3,323 794,921 E F G H K VI 17,562 $ 17,562 $ 26,457 $ 12,316 17,562 22,351 12,316 20,070 24,404 15,966 1,368 28,509 27,368 52,275 52,275 26 TV Stands 27 TV Mounts 28 A/V Component Racks 29 A/V 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/V Cables & Connectors 37 Remote Controls 38 3D Accessories 39 Home Theatre Networking 40 TV & Media Cleaning & Care 41 A/V 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 50 Gaming Desktops 51 Gaming Monitors 52 LCD Monitors 53 LED Monitors 54 Routers 8,211 $ 16,422 $ 17,790 $ 22,351 $ 2,737 $ $ 28,738 $ 40,141 $ 63,177 $ - $ 22,124 $ 12,772 $ 23,264 $ 6,796 $ 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 Northwest Mountain Northeast Central Southwest $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Level 6 Level 6 Level 3 Level 3 Level 3 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 Level 6 Level 3 Level 6 Level 2 Level 2 - $ 14,825 $ 19,157 $ 28,509 $ - $ 1,824 $ 29,649 $ 43,334 $ 62,037 $ 39,229 $ 18,246 $ 13,685 $ 25,544 $ 3,877 $ 1,459 $ - $ 36,492 $ 43,791 $ 34,667 $ 25,544 $ - $ 4,380 $ 27,825 $ 7,298 $ 8,668 $ - $ 13,685 $ 18,474 $ 27,825 $ - $ 2,053 $ 27,368 $ 46,528 $ 63,861 $ 37,404 $ 19,157 $ - $ 23,720 $ 5,245 $ 2,053 $ - $ 38,317 $ 10,492 $ 32,386 $ 5,931 $ - $ 4,015 $ 24,175 $ 8,211 $ 10,492 $ - $ 28,281 $ 47,668 $ 60,211 $ 35,579 $ 19,843 $ - $ 24,175 $ 6,477 $ 730 $ - $ 36,947 $ 22,351 3,877 9,579 22,351 4,380 2,510 27,368 5 $ 5 $ 5 $ 5 $ 5ls 5$ 5 $ 5 $ 5 $ 5 $ 5 $ 5 $ 5 $ 5 $ 5$ 5 $ 5 $ 5 $ 5 $ 5 S 5 S 5 ls 5 $ $ 1,642 $ 14,962 $ 18,611 $ 25,909 $ 3,741 $ 1,049 $ 28,509 $ 35,534 $ 60,312 $ 22,442 $ 15,874 $ 7,207 $ 23,811 $ 5,355 $ 1,350 $ 5,474 $ 23,537 $ 10,857 $ 31,292 $ 9,032 $ 8,758 $ 3,686 $ 24,495 $ 6,204 $ 11,997 $ 9,306 $ 9,579 $ 3,494 $ 4,643 $ 8,211 $ 17,562 $ 20,070 $ 28,509 $ 15,966 $ 2,053 $ 29,649 $ 47,668 $ 63,861 $ 39,229 $ 22,124 $ 13,685 $ 25,544 $ 6,796 $ 2,510 $ 27,368 $ 38,317 $ 43,791 $ 36,036 $ 25,544 $ 43,791 $ 4,380 $ 27,825 $ 8,211 $ 16,193 $ 16,422 $ 11,859 $ 4,380 $ 12,772 $ - $ 5,931 $ 19,614 33,755 $ - $ $ $ $ $ $ $ $ $ 19,614 12,316 43,791 3,329 18,703 5,474 16,193 36,036 $ 1,368 $ - $ 2,737 $ 25,317 $ 4,790 $ 12,772 $ - $ 11,859 $ 3,740 $ 7,481 $ 5 $ 5 3,969 26,457 5,245 11,859 14,140 8,895 4,380 2,964 2,737 18,703 4,790 8,668 $ $ $ $ $ $ $ $ 8,211 $ 3,421 $ - $ 8,438 4,105 - $ $ $ 10,492 1,824 12,772 5 $ 55 5 ls 5$ 8,211 1,824 1,04 $ Electronic World - Inventory Listing Total Categories = e Departm ent 58 Kas seen in en om na te se Product Category 5 4K Ultra HD TV's 5 LED TV's - Outdoor TV's B OLED TV's Curved TV's 0 Projectors & Screens 1 Home Theatre Systems 2 Sound Bars 3 Speakers 4 Receivers & Amplifiers 5 Stereo Shelf Systems 6 Wireless & Multiroom Audio 7 CD Players & Turntables 8 Headphones 9 Blu-Ray Players 0 3D Blu-Ray Players 1 DVD Players 2 Streaming Media Players 3 Streaming Blu-Ray Players 4 DVR'S 5 Remote TV Streaming 6 TV Stands 98 Ending Ending Ending Ending Ending Inventory Inventory Inventory Inventory Inventory Balance - Balance - Balance - Year Balance - Year Balance - Year 1 Year 2 Year 5 $ 9,122 $ 11,405 $ 10,035 $ 8,550 $ 10,925 $ 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 $ 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 $ 33,755 $ 34,212 $ 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 $ 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 $ 4,834 $ 4,469 $ - $ - $ - $ 1,368 $ 1,413 $ 28,281 $ 24,175 $ 13,685 $ 2,281 $ - $ 20,983 $ 21,894 $ 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 $ 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 Internal classification Level 3 Level 6 Level 3 Level 2 Level 8 Level 2 Level 2 Level 6 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 Numb Average Maximum Minimum er of Inventory Inventory Inventory Years Balance Balance Balance 5 $ 10,007 $ 11,405 $ 8,550 5 $ 16,056 $ 21,440 $ - 5 $ 6,581 $ 13,685 $ 5 $ 7,116 $ 14,140 $ 5 $ 2,463 $ 4,105 $ 913 5 $ 4,698 $ 5,018 $ 4,561 5$ 3,128 $ 5,931 $ 5 $ 867 $ 1,824 $ 5 $ 26,183 $ 30,105 $ 22,351 5 $ 32,021 $ 34,212 $ 27,368 5 $ 23,765 $ 25,088 $ 22,807 5 $ 16,695 $ 17,790 $ 15,509 5 $ 12,088 $ 12,772 $ 11,405 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 $ 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 $ . na naman Sanding Accessories Inventory Costing Method Comparison Units in Ending Inventory: 23 Methods to be used: Last-In, First-Out First-In, First-Out Weighted Average Units 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 104 LIFOInventory Balance: FIFOInventory: WAInventory Balance: $ $ $ 10,925 11,064 11,003 $ $ $ $ $ $ $ $ $ 5 $ 5$ 5 $ 5 $ 5 $ 5 $ 5 $ 5 $ 5 $ 5$ 14,140 2,829 22,351 - 33,299 18,703 5,474 - 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 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 3 Level 8 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 5$ 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 $ - $ 7,927 $ 2,388 $ 4,775 $ 8,987 $ 960,004 $ 17,790 $ 2,829 $ 34,667 $ - $ 40,141 $ 18,703 $ 12,772 $ - $ - $ 3,490 $ 3,877 $ 5,040 $ - $ 7,355 $ 1,473 $ 3,295 $ - $ 7,946 $ 2,483 $ 5,100 $ 7,354 $ 876,439 $ 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 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 $ 890,129 $ 16,422 $ 3,512 $ 28,738 $ - $ 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 $ 16,330 $ 3,110 $ 30,288 $ 6,295 $ 37,906 $ 21,896 $ 10,765 $ 14,642 $ 6,049 $ 2,094 $ 3,993 $ 3,475 $ 838 $ 4,495 $ 2,582 $ 3,962 $ 473 $ 8,003 $ 1,662 $ 5,107 $ 6,431 $ $ $ $ $ $ $ $ $ $ $ $ $ 17,790 $ 3,512 $ 34,667 $ 25,544 $ 41,510 $ 24,861 $ 12,772 $ 28,738 $ 12,020 $ 3,490 $ 4,265 $ 5,040 $ 1,551 $ 10,081 $ 3,682 $ 4,343 $ 1,201 $ 8,442 $ 3,438 $ 5,688 $ 8,987 $ 775 3,877 -. 5$ 5 $ 5$ 5$ 1,356 3,295 5 s 5 $ 5 $ 5 $ 5 $ 5$ 7,602 - 4,548 3,323 98 5,688 3,323 794,921 E F G H K VI 17,562 $ 17,562 $ 26,457 $ 12,316 17,562 22,351 12,316 20,070 24,404 15,966 1,368 28,509 27,368 52,275 52,275 26 TV Stands 27 TV Mounts 28 A/V Component Racks 29 A/V 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/V Cables & Connectors 37 Remote Controls 38 3D Accessories 39 Home Theatre Networking 40 TV & Media Cleaning & Care 41 A/V 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 50 Gaming Desktops 51 Gaming Monitors 52 LCD Monitors 53 LED Monitors 54 Routers 8,211 $ 16,422 $ 17,790 $ 22,351 $ 2,737 $ $ 28,738 $ 40,141 $ 63,177 $ - $ 22,124 $ 12,772 $ 23,264 $ 6,796 $ 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 Northwest Mountain Northeast Central Southwest $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ $ Level 6 Level 6 Level 3 Level 3 Level 3 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 Level 6 Level 3 Level 6 Level 2 Level 2 - $ 14,825 $ 19,157 $ 28,509 $ - $ 1,824 $ 29,649 $ 43,334 $ 62,037 $ 39,229 $ 18,246 $ 13,685 $ 25,544 $ 3,877 $ 1,459 $ - $ 36,492 $ 43,791 $ 34,667 $ 25,544 $ - $ 4,380 $ 27,825 $ 7,298 $ 8,668 $ - $ 13,685 $ 18,474 $ 27,825 $ - $ 2,053 $ 27,368 $ 46,528 $ 63,861 $ 37,404 $ 19,157 $ - $ 23,720 $ 5,245 $ 2,053 $ - $ 38,317 $ 10,492 $ 32,386 $ 5,931 $ - $ 4,015 $ 24,175 $ 8,211 $ 10,492 $ - $ 28,281 $ 47,668 $ 60,211 $ 35,579 $ 19,843 $ - $ 24,175 $ 6,477 $ 730 $ - $ 36,947 $ 22,351 3,877 9,579 22,351 4,380 2,510 27,368 5 $ 5 $ 5 $ 5 $ 5ls 5$ 5 $ 5 $ 5 $ 5 $ 5 $ 5 $ 5 $ 5 $ 5$ 5 $ 5 $ 5 $ 5 $ 5 S 5 S 5 ls 5 $ $ 1,642 $ 14,962 $ 18,611 $ 25,909 $ 3,741 $ 1,049 $ 28,509 $ 35,534 $ 60,312 $ 22,442 $ 15,874 $ 7,207 $ 23,811 $ 5,355 $ 1,350 $ 5,474 $ 23,537 $ 10,857 $ 31,292 $ 9,032 $ 8,758 $ 3,686 $ 24,495 $ 6,204 $ 11,997 $ 9,306 $ 9,579 $ 3,494 $ 4,643 $ 8,211 $ 17,562 $ 20,070 $ 28,509 $ 15,966 $ 2,053 $ 29,649 $ 47,668 $ 63,861 $ 39,229 $ 22,124 $ 13,685 $ 25,544 $ 6,796 $ 2,510 $ 27,368 $ 38,317 $ 43,791 $ 36,036 $ 25,544 $ 43,791 $ 4,380 $ 27,825 $ 8,211 $ 16,193 $ 16,422 $ 11,859 $ 4,380 $ 12,772 $ - $ 5,931 $ 19,614 33,755 $ - $ $ $ $ $ $ $ $ $ 19,614 12,316 43,791 3,329 18,703 5,474 16,193 36,036 $ 1,368 $ - $ 2,737 $ 25,317 $ 4,790 $ 12,772 $ - $ 11,859 $ 3,740 $ 7,481 $ 5 $ 5 3,969 26,457 5,245 11,859 14,140 8,895 4,380 2,964 2,737 18,703 4,790 8,668 $ $ $ $ $ $ $ $ 8,211 $ 3,421 $ - $ 8,438 4,105 - $ $ $ 10,492 1,824 12,772 5 $ 55 5 ls 5$ 8,211 1,824 1,04 $ Electronic World - Inventory Listing Total Categories = e Departm ent 58 Kas seen in en om na te se Product Category 5 4K Ultra HD TV's 5 LED TV's - Outdoor TV's B OLED TV's Curved TV's 0 Projectors & Screens 1 Home Theatre Systems 2 Sound Bars 3 Speakers 4 Receivers & Amplifiers 5 Stereo Shelf Systems 6 Wireless & Multiroom Audio 7 CD Players & Turntables 8 Headphones 9 Blu-Ray Players 0 3D Blu-Ray Players 1 DVD Players 2 Streaming Media Players 3 Streaming Blu-Ray Players 4 DVR'S 5 Remote TV Streaming 6 TV Stands 98 Ending Ending Ending Ending Ending Inventory Inventory Inventory Inventory Inventory Balance - Balance - Balance - Year Balance - Year Balance - Year 1 Year 2 Year 5 $ 9,122 $ 11,405 $ 10,035 $ 8,550 $ 10,925 $ 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 $ 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 $ 33,755 $ 34,212 $ 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 $ 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 $ 4,834 $ 4,469 $ - $ - $ - $ 1,368 $ 1,413 $ 28,281 $ 24,175 $ 13,685 $ 2,281 $ - $ 20,983 $ 21,894 $ 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 $ 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 Internal classification Level 3 Level 6 Level 3 Level 2 Level 8 Level 2 Level 2 Level 6 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 Numb Average Maximum Minimum er of Inventory Inventory Inventory Years Balance Balance Balance 5 $ 10,007 $ 11,405 $ 8,550 5 $ 16,056 $ 21,440 $ - 5 $ 6,581 $ 13,685 $ 5 $ 7,116 $ 14,140 $ 5 $ 2,463 $ 4,105 $ 913 5 $ 4,698 $ 5,018 $ 4,561 5$ 3,128 $ 5,931 $ 5 $ 867 $ 1,824 $ 5 $ 26,183 $ 30,105 $ 22,351 5 $ 32,021 $ 34,212 $ 27,368 5 $ 23,765 $ 25,088 $ 22,807 5 $ 16,695 $ 17,790 $ 15,509 5 $ 12,088 $ 12,772 $ 11,405 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 $ 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 $ . na naman Sanding Accessories Inventory Costing Method Comparison Units in Ending Inventory: 23 Methods to be used: Last-In, First-Out First-In, First-Out Weighted Average Units 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 104 LIFOInventory Balance: FIFOInventory: WAInventory Balance: $ $ $ 10,925 11,064 11,003
