Inventory Listing Gameroom Suppliers - Inventory Listing Total Categories = Product...

Question

Inventory Listing
    Gameroom Suppliers - Inventory Listing
    Total Categories =
    Product Category    Warehouse Location    Category Number    User Rating    Ending Inventory Balance - Year 1    Ending Inventory Balance - Year 2    Ending Inventory Balance - Year 3    Ending Inventory Balance - Year 4    Ending Inventory Balance - Year 5    Number of Years    Average Inventory Balance    Maximum Inventory Balance    Minimum Inventory Balance
    Air Hockey Tables    Huntington    45    5 Stars    $ 2,800    $ 3,500    $ 3,080    $ 2,100
    Arcade Games    Huntington    50    3 Stars    $ 5,880    $ - 0    $ 6,580    $ 6,160    $ 6,020
    ATM Machines    Huntington    96    5 Stars    $ - 0    $ 3,100    $ - 0    $ 2,800    $ 4,200
    Bu
le Hockey    Huntington    23    4 Stars    $ 2,240    $ - 0    $ 4,340    $ 2,380    $ 1,960
    Change Machines    Huntington    50    1 Star    $ 980    $ 1,260    $ 840    $ 280    $ 420
    Dartboards    Huntington    35    4 Stars    $ 1,540    $ 1,400    $ 1,400    $ 1,400    $ 1,470
    Foosball    Huntington    54    4 Stars    $ 1,650    $ 1,820    $ - 0    $ - 0    $ 1,330
    Bar Stools    Huntington    50    3 Stars    $ - 0    $ - 0    $ 490    $ 280    $ 560
    Bar Chairs    Jericho    45    3 Stars    $ 8,680    $ 7,980    $ 6,860    $ 7,420    $ 9,240
    Bar Benches    Jericho    54    5 Stars    $ 9,940    $ 10,360    $ 10,500    $ 9,940    $ 8,400
    Home Bars    Jericho    13    5 Stars    $ 7,000    $ 7,000    $ 7,700    $ 7,420    $ 7,350
    Kitchen Characters    Jericho    77    2 Stars    $ 5,040    $ 5,250    $ 5,460    $ 5,110    $ 4,760
    Game Room Characters    Jericho    45    5 Stars    $ 3,920    $ 3,780    $ 3,500    $ 3,640    $ 3,710
    Pub Tables    Riverhead    96    4 Stars    $ - 0    $ 6,580    $ 1,820    $ - 0    $ 3,640
    Game Table Sets    Riverhead    77    4 Stars    $ 490    $ 532    $ 1,260    $ 1,330    $ 1,050
    Jukeboxes    Riverhead    77    5 Stars    $ 1,568    $ 1,190    $ 1,540    $ 1,484    $ 1,372
    Logo Games    Riverhead    61    5 Stars    $ - 0    $ - 0    $ - 0    $ 420    $ 434
    Horseshoes    Smithtown    61    5 Stars    $ 8,680    $ 7,420    $ 4,200    $ 700    $ - 0
    Bocce    Smithtown    13    3 Stars    $ 6,440    $ 6,720    $ 6,860    $ 6,440    $ 6,440
    Pickleball    Smithtown    35    3 Stars    $ 3,220    $ 3,640    $ 3,710    $ 3,080    $ 2,660
    Other Outdoor Games    Smithtown    90    1 Star    $ 5,600    $ 5,880    $ 6,090    $ 6,160    $ 6,720
    Photo Booth    Smithtown    66    3 Stars    $ - 0    $ - 0    $ - 0    $ 2,520    $ - 0
    Pinball    Smithtown    50    3 Stars    $ 4,550    $ 4,200    $ 5,390    $ 5,040    $ 3,780
    Ping Pong    Smithtown    90    5 Stars    $ 5,880    $ 5,670    $ 5,390    $ 5,460    $ 6,160
    Pool/Billiards    Smithtown    35    5 Stars    $ 8,750    $ 8,540    $ 8,120    $ 6,860    $ 7,490
    Shuffleboard    Smithtown    90    5 Stars    $ - 0    $ - 0    $ - 0    $ 840    $ 4,900
    Table Games    Smithtown    35    5 Stars    $ 560    $ 630    $ - 0    $ - 0    $ 420
    Vending Machines    Kings Park    54    4 Stars    $ 9,100    $ 8,400    $ 8,680    $ 8,820    $ 8,750
    Air Hockey Parts    Kings Park    54    5 Stars    $ 13,300    $ 14,280    $ 14,630    $ 12,320    $ - 0
    Arcade Games Parts    Kings Park    77    5 Stars    $ 19,040    $ 19,600    $ 18,480    $ 19,390    $ 16,044
    ATM Machine Parts    Kings Park    13    4 Stars    $ 12,040    $ 11,480    $ 10,920    $ - 0    $ - 0
    Bu
le Hockey Parts    Kings Park    45    3 Stars    $ 5,600    $ 5,880    $ 6,090    $ 6,790    $ - 0
    Darts Parts    Kings Park    77    3 Stars    $ 4,200    $ - 0    $ - 0    $ 3,920    $ 2,940
    Foosball Parts    Kings Park    50    2 Stars    $ 7,840    $ 7,280    $ 7,420    $ 7,140    $ 6,860
    Jukeboxes Parts    Kings Park    77    5 Stars    $ 1,190    $ 1,610    $ 1,988    $ 2,086    $ 1,344
    Logo Games Parts    Kings Park    38    2 Stars    $ 448    $ 630    $ 224    $ - 0    $ 770
    Logo Accessories Parts    Syosset    50    4 Stars    $ - 0    $ - 0    $ - 0    $ - 0    $ 8,400
    Neon Clocks    Syosset    50    4 Stars    $ 11,200    $ 11,760    $ 11,340    $ 1,820    $ - 0
    Neon Signs    Syosset    54    5 Stars    $ 13,440    $ 3,220    $ - 0    $ - 0    $ - 0
    Outdoor Games Parts    Syosset    35    5 Stars    $ 10,640    $ 9,940    $ 10,360    $ 11,060    $ 6,020
    Photo Booth Parts    Syosset    77    2 Stars    $ 7,840    $ 1,820    $ - 0    $ 420    $ 3,780
    Pinball Parts    Syosset    96    1 Star    $ - 0    $ - 0    $ - 0    $ - 0    $ 13,440
    Ping Pong Parts    Syosset    96    3 Stars    $ 1,344    $ 1,232    $ 1,218    $ 840    $ 1,022
    Pool/Billiards Parts    Syosset    23    3 Stars    $ 8,540    $ 7,420    $ 8,120    $ 7,770    $ 5,740
    Shuffleboard Parts    Syosset    35    4 Stars    $ 2,240    $ 2,520    $ 1,610    $ 1,470    $ 1,680
    Table Games Parts    Syosset    90    3 Stars    $ 2,660    $ 3,220    $ 3,640    $ 3,920    $ 4,970
    Vending Machines Parts    Syosset    66    5 Stars    $ 5,040    $ 4,900    $ 4,340    $ - 0    $ - 0
    Clearance Machines    Syosset    45    3 Stars    $ 2,520    $ 2,590    $ 2,730    $ 3,640    $ 3,220
    Clearance Parts    Syosset    35    4 Stars    $ 1,050    $ 1,260    $ 1,344    $ 1,148    $ 560
    Sale Machines    Syosset    50    4 Stars    $ - 0    $ - 0    $ 910    $ 2,296    $ 3,920
    Sale Parts    Syosset    54    5 Stars    $ 5,320    $ 5,460    $ 4,900    $ 5,040    $ 4,340
    Game Manuals    Syosset    50    1 Star    $ 910    $ 868    $ 896    $ 1,078    $ 1,022
    Game Schematics    Syosset    20    5 Stars    $ 9,800    $ 10,640    $ 10,360    $ 8,820    $ 6,860
    Game Books    Manhasset    54    5 Stars    $ 7,840    $ - 0    $ - 0    $ - 0    $ 1,820
    Personalized Décor    Manhasset    35    5 Stars    $ 12,740    $ 12,320    $ 12,040    $ 10,850    $ 10,220
    Personalized Games    Manhasset    50    3 Stars    $ 6,930    $ 5,740    $ 6,020    $ 7,630    $ 7,280
    Personalized Books    Manhasset    61    3 Stars    $ 1,680    $ 3,920    $ 3,710    $ 3,360    $ 3,850
    Personalized Seating    Manhasset    13    4 Stars    $ - 0    $ - 0    $ 8,820    $ 8,120    $ 5,530
    Totals:
Air Hockey Tables
    Air Hockey Tables
    Inventory Costing Method Comparison
    Methods to be used:        Units in Ending Inventory:            18
    Last-In, First-Out
    First-In, First-Out
    Weighted Average
        Units    Cost per Unit    Total
    Beginning Inventory    15    $ 140    $ 2,100
    Purchase #1    18    $ 142    $ 2,556
    Purchase #2    8    $ 146    $ 1,168
    Purchase #3    12    $ 147    $ 1,764
    Purchase #4    17    $ 148    $ 2,516
        70        $ 10,104

Inventory Listing
    Brown's Toy Store - Inventory Listing
    Total Categories =
    Product Category    Sales Location    Manufacturer    Department    Ending Inventory Balance - Year 1    Ending Inventory Balance - Year 2    Ending Inventory Balance - Year 3    Ending Inventory Balance - Year 4    Ending Inventory Balance - Year 5    Number of Years    Average Inventory Balance    Maximum Inventory Balance    Minimum Inventory Balance
    Balance Bikes    In-Store    Toy Makerz    14 Years & Up    $ 7,280    $ 9,100    $ 8,008    $ 2,496
    Pedal & Push Riding Toys    Online    Bouncing Balls    10-14 Years    $ 15,288    $ - 0    $ 17,108    $ 16,016    $ 15,652
    Powered Riding Toys    All Locations    Olaf Corp.    3-6 Years    $ - 0    $ 8,060    $ - 0    $ 7,280    $ 10,920
    Rockers & Spring Horses    Mail Order    JYS Inc.    6-10 Years    $ 5,824    $ - 0    $ 11,284    $ 6,188    $ 5,096
    Tricycles    Trade Shows    Bouncing Balls    0-3 Years    $ 2,548    $ 3,276    $ 2,184    $ 728    $ 1,092
    Wagons    In-Store    Pop-Rok    0-3 Years    $ 4,004    $ 3,640    $ 3,640    $ 3,640    $ 3,822
    Basic Blocks    In-Store    Baby Play Co.    3-6 Years    $ 4,290    $ 4,732    $ - 0    $ - 0    $ 3,458
    Building Sets & Kits    In-Store    Bouncing Balls    0-3 Years    $ - 0    $ - 0    $ 1,274    $ 728    $ 1,456
    Magnetic Construction    In-Store    Toy Makerz    14 Years & Up    $ 22,568    $ 20,748    $ 17,836    $ 19,292    $ 24,024
    Stacking & Shape Toys    In-Store    Baby Play Co.    0-3 Years    $ 25,844    $ 26,936    $ 27,300    $ 25,844    $ 21,840
    Specialty Building Toys    In-Store    ToyMatic    6-10 Years    $ 18,200    $ 18,200    $ 20,020    $ 19,292    $ 19,110
    Clay, Dough & Pottery    In-Store    Checks & Bal.    10-14 Years    $ 13,104    $ 13,650    $ 14,196    $ 13,286    $ 12,376
    Craft Kits    In-Store    Toy Makerz    10-14 Years    $ 10,192    $ 9,828    $ 9,100    $ 9,464    $ 9,646
    Drawing & Coloring    Online    Olaf Corp.    3-6 Years    $ - 0    $ 17,108    $ 4,732    $ - 0    $ 9,464
    Easels & Art Tables    Online    Checks & Bal.    3-6 Years    $ 1,274    $ 1,383    $ 3,276    $ 3,458    $ 2,730
    Jewelry & Bead Kits    Online    Checks & Bal.    0-3 Years    $ 4,077    $ 3,094    $ 4,004    $ 3,858    $ 3,567
    Painting    Online    Outdoor Fun    14 Years & Up    $ - 0    $ - 0    $ - 0    $ 1,092    $ 1,128
    School Supplies    All Locations    Outdoor Fun    10-14 Years    $ 22,568    $ 19,292    $ 10,920    $ 1,820    $ - 0
    Scrapbooking & Photo    All Locations    ToyMatic    6-10 Years    $ 16,744    $ 17,472    $ 17,836    $ 16,744    $ 16,744
    Sewing    All Locations    Pop-Rok    6-10 Years    $ 8,372    $ 9,464    $ 9,646    $

utf-8ea4-e1-inventory20q120-20extend20your20skills20-20pre-loaded20with20starting20data-tm5owxue.xlsx utf-8ea4-e2-inventory20q220-20extend20your20skill20-20pre-loaded20with20starting20data-cbvrnllb.xlsx efa-c04-ygvpulaz.pdf extendyourskillsassignment1-akcgxymf.png extendyourskillsassignment2-ohowiwjx.png

Akshay Kumar · Accepted Answer

Inventory PivotTable
	Sales Location	(Multiple Items)
	Sum of Ending Inventory Balance - Year 4	Column Labels
	Row Labels	Balance Bikes	Building Sets & Kits	Craft Kits	Electronic Toys	Interactive Gaming Figures	Learning Books	Magnetic Construction	Puppets	Tools & Workshops	Tricycles	Grand Total
	0-3 Years		728								728	1456
	10-14 Years			9464								9464
	14 Years & Up	2496					2803	19292				24591
	3-6 Years				5970				0	4732		10702
	6-10 Years					9464						9464
	Grand Total	2496	728	9464	5970	9464	2803	19292	0	4732	728	55677
Balance Bikes	0-3 Years	10-14 Years	14 Years 	&	 Up	3-6 Years	6-10 Years	2496	Building Sets 	&	 Kits	0-3 Years	10-14 Years	14 Years 	&	 Up	3-6 Years	6-10 Years	728	Craft Kits	0-3 Years	10-14 Years	14 Years 	&	 Up	3-6 Years	6-10 Years	9464	Electronic Toys	0-3 Years	10-14 Years	14 Years 	&	 Up	3-6 Years	6-10 Years	5970	Interactive Gaming Figures	0-3 Years	10-14 Years	14 Years 	&	 Up	3-6 Years	6-10 Years	9464	Learning Books	0-3 Years	10-14 Years	14 Years 	&	 Up	3-6 Years	6-10 Years	2803	Magnetic Construction	0-3 Years	10-14 Years	14 Years 	&	 Up	3-6 Years	6-10 Years	19292	Puppets	0-3 Years	10-14 Years	14 Years 	&	 Up	3-6 Years	6-10 Years	0	Tools 	&	 Workshops	0-3 Years	10-14 Years	14 Years 	&	 Up	3-6 Years	6-10 Years	4732	Tricycles	0-3 Years	10-14 Years	14 Years 	&	 Up	3-6 Years	6-10 Years	728	
Inventory Listing
	Brown's Toy Store - Inventory Listing
	Total Categories = 	67
	Product Category	Sales Location	Manufacturer	Department	Ending Inventory Balance - Year 1	Ending Inventory Balance - Year 2	Ending Inventory Balance - Year 3	Ending Inventory Balance - Year 4	Ending Inventory Balance - Year 5	Number of Years	Average Inventory Balance	Maximum Inventory Balance	Minimum Inventory Balance
	Balance Bikes	In-Store	Toy Makerz	14 Years & Up	$   7,280	$   9,100	$   8,008	$   2,496	$   3,272	5	$   6,031	$   9,100	$   2,496
	Pedal & Push Riding Toys	Online	Bouncing Balls	10-14 Years	$   15,288	$   - 0	$   17,108	$   16,016	$   15,652	5	$   12,813	$   17,108	$   - 0
	Powered Riding Toys	All Locations	Olaf Corp.	3-6 Years	$   - 0	$   8,060	$   - 0	$   7,280	$   10,920	5	$   5,252	$   10,920	$   - 0
	Rockers & Spring Horses	Mail Order	JYS Inc.	6-10 Years	$   5,824	$   - 0	$   11,284	$   6,188	$   5,096	5	$   5,678	$   11,284	$   - 0
	Tricycles	Trade Shows	Bouncing Balls	0-3 Years	$   2,548	$   3,276	$   2,184	$   728	$   1,092	5	$   1,966	$   3,276	$   728
	Wagons	In-Store	Pop-Rok	0-3 Years	$   4,004	$   3,640	$   3,640	$   3,640	$   3,822	5	$   3,749	$   4,004	$   3,640
	Basic Blocks	In-Store	Baby Play Co.	3-6 Years	$   4,290	$   4,732	$   - 0	$   - 0	$   3,458	5	$   2,496	$   4,732	$   - 0
	Building Sets & Kits	In-Store	Bouncing Balls	0-3 Years	$   - 0	$   - 0	$   1,274	$   728	$   1,456	5	$   692	$   1,456	$   - 0
	Magnetic Construction	In-Store	Toy Makerz	14 Years & Up	$   22,568	$   20,748	$   17,836	$   19,292	$   24,024	5	$   20,894	$   24,024	$   17,836
	Stacking & Shape Toys	In-Store	Baby Play Co.	0-3 Years	$   25,844	$   26,936	$   27,300	$   25,844	$   21,840	5	$   25,553	$   27,300	$   21,840
	Specialty Building Toys	In-Store	ToyMatic	6-10 Years	$   18,200	$   18,200	$   20,020	$   19,292	$   19,110	5	$   18,964	$   20,020	$   18,200
	Clay, Dough & Pottery	In-Store	Checks & Bal.	10-14 Years	$   13,104	$   13,650	$   14,196	$   13,286	$   12,376	5	$   13,322	$   14,196	$   12,

Inventory Listing Gameroom Suppliers - Inventory Listing Total Categories = Product Category Warehouse Location Category Number User Rating Ending Inventory Balance - Year 1 Ending Inventory Balance -...

Solution

Answer To This Question Is Available To Download

Related Questions & Answers

Submit New Assignment