Days On Hand Lego Instructions Complete the attached file. Submit the Excel file and your 1 page Executive Summary in Word (double spaced, Times New Roma

Days On Hand Lego Instructions

Complete the attached file. Submit the Excel file and your 1 page Executive Summary in Word (double spaced, Times New Roma

Click here to Order a Custom answer to this Question from our writers. It’s fast and plagiarism-free.

Instructions

Complete the attached file.  Submit the Excel file and your 1 page Executive Summary in Word (double spaced, Times New Roman, 12 pt font) into this dropbox.

Days on Hand calculations should be expressed with at least one decimal point. Do not round to the nearest whole number.

Every Executive Summary should have a title, along with your name and the date.  Begin the first paragraph with text, not a graphic or table.  

The Excel file will be 20 of the 30 possible points and the Executive Summary will be 10 of 30 possible points.

For full credit on the Executive Summary I am looking for something more than reduce the inventory on the slow movers and increase the inventory on the fast movers. While this is the ultimate goal, some sort of plan or action should be suggested.

Lego Inventory

<

Place your order now for a similar assignment and have exceptional work written by one of our experts, guaranteeing you an A result.

Need an Essay Written?

This sample is available to anyone. If you want a unique paper order it from one of our professional writers.

Get help with your academic paper right away

Quality & Timely Delivery

Free Editing & Plagiarism Check

Security, Privacy & Confidentiality

Item Annual Cost of Goods Sold Daily COGS Inventory Level $ Days on Hand
Advent $ 153,300 $ 12,600
Advent Sub-Set $ 359,925 $ 26,625
Adventurers $ 602,250 $ 23,100
Agents $ 441,900 $ 8,475
Agori $ 985,500 $ 18,900
Airjitzu $ 810,975 $ 71,100
Airport $ 702,600 $ 34,650
Airport 2 $ 294,300 $ 3,225
Alien Conquest $ 1,081,350 $ 59,250
Alpha Team $ 1,416,525 $ 166,875
An Unexpected Journey $ 1,052,850 $ 37,500
Angry Birds $ 364,125 $ 19,950
Angry Birds 2 $ 343,575 $ 27,300
Animals $ 987,450 $ 37,875
Animals 2 $ 269,775 $ 51,000
Aquanauts $ 880,650 $ 127,875
Aquaraiders I $ 638,100 $ 73,425
Aquaraiders II $ 926,850 $ 17,775
Aquasharks $ 579,225 $ 69,825
Aquazone $ 828,750 $ 140,775
Architecture $ 1,138,575 $ 68,625
Arctic $ 285,450 $ 16,425
Arctic Technic $ 336,825 $ 30,450
Atlantis $ 379,950 $ 34,350
Avatar $ 962,700 $ 79,125
Avengers $ 2,641,725 $ 14,475
Barraki $ 3,494,850 $ 28,725
Basic $ 2,369,325 $ 129,825
Basic Model $ 610,650 $ 21,750
Basic Set $ 315,600 $ 29,400
Basketball $ 2,637,525 $ 332,400
Batman $ 1,907,625 $ 99,300
Battle Vehicles $ 1,615,125 $ 3,375
Belville $ 1,752,750 $ 177,675
Ben 10 $ 387,150 $ 37,125
Bionicle $ 1,360,575 $ 37,275
Black Falcons $ 617,175 $ 37,200
Black Knights $ 164,250 $ 4,050
Blacktron I $ 290,175 $ 3,975
Blacktron II $ 1,601,850 $ 136,050
Boat $ 2,534,700 $ 187,500
Bohrok $ 173,175 $ 21,825
Bohrok Va $ 385,500 $ 25,350
Bohrok Va 2 $ 180,150 $ 24,675
Bohrok-Kal $ 288,150 $ 15,000
Bohrok-Kal 2 $ 199,200 $ 15,825
Books $ 369,600 $ 20,250
Books 2 $ 1,142,325 $ 115,800
Brickheadz $ 692,625 $ 18,975
Brickheadz 2 $ 316,950 $ 39,075
Bricktober $ 557,475 $ 33,600
Bricktober 2 $ 853,050 $ 86,475
Building $ 926,850 $ 35,550
Building 2 $ 186,150 $ 10,200
Building Set with People $ 841,350 $ 103,725
Building Set with People 2 $ 673,275 $ 68,250
Bulk Bricks $ 320,550 $ 33,375
Bulk Bricks 2 $ 119,987 $ 700
Cargo $ 543,450 $ 101,250
Cargo 2 $ 849,825 $ 53,550
Cars $ 716,475 $ 45,150
Cars 2 $ 1,916,250 $ 10,900
Castle $ 621,825 $ 11,925
Castle 2 $ 1,193,325 $ 71,925
Chamber of Secrets $ 972,525 $ 101,250
Chamber of Secrets 2 $ 2,971,575 $ 398,925
Christmas $ 966,750 $ 50,325
Christmas 2 $ 1,040,250 $ 59,850
City $ 808,200 $ 46,500
City 2 $ 534,225 $ 45,375
Classic $ 826,725 $ 11,325
Classic 2 $ 190,050 $ 17,700
Classic Basic $ 365,025 $ 9,000
Classic Basic 2 $ 181,800 $ 12,450
Classic Castle $ 647,850 $ 69,225
Classic Castle 2 $ 410,625 $ 1,125
Classic Space $ 322,725 $ 29,175
Classic Space 2 $ 84,750 $ 16,725
Classic Town $ 300,000 $ 82,050
Classic Town 2 $ 84,225 $ 3,000
Clikits $ 473,175 $ 54,450
Clikits 2 $ 390,075 $ 12,825
Coast Guard $ 801,450 $ 148,725
Coast Guard 2 $ 179,475 $ 8,850
Collectible Minifigures $ 351,825 $ 52,050
Collectible Minifigures 2 $ 14,325 $ 1,725
Competition $ 3,119,925 $ 290,625
Competition 2 $ 127,725 $ 5,250
Constraction $ 1,830,900 $ 85,275
Constraction 2 $ 251,850 $ 17,250
Construction $ 1,445,400 $ 19,800
Construction 2 $ 159,675 $ 5,250
Control Lab $ 447,675 $ 20,850
Control Lab 2 $ 24,300 $ 600
Cowboys $ 329,175 $ 35,882
Cowboys 2 $ 102,000 $ 6,150
Creator $ 369,600 $ 26,325
Creator 2 $ 92,775 $ 10,043
Creature $ 634,875 $ 45,225
Creature 2 $ 19,575 $ 1,500
Crusaders $ 3,399,375 $ 260,775
Crusaders 2 $ 10,425 $ 600
Dark Forest $ 684,375 $ 37,500
Dark Forest 2 $ 11,700 $ 5,175
DC Comics Super Heroes $ 250,650 $ 35,025
DC Comics Super Heroes 2 $ 411,075 $ 73,200
Desert $ 887,325 $ 99,675
Desert 2 $ 552,975 $ 45,450
Designer Sets $ 692,325 $ 45,525
Designer Sets 2 $ 68,475 $ 750
DFB Minifigures $ 700,425 $ 55,650
DFB Minifigures 2 $ 822,450 $ 101,400
Dimensions $ 765,525 $ 117,450
Dimensions 2 $ 912,525 $ 30,000
Dino $ 1,234,125 $ 165,675
Dino 2 $ 68,475 $ 3,000
Dino 2010 $ 1,284,375 $ 42,225
Dino Attack $ 3,839,325 $ 42,075
Dino Island $ 807,750 $ 161,550
Dinosaurs $ 1,938,975 $ 281,550
Discovery $ 870,300 $ 57,225
Disney $ 1,429,275 $ 129,225
Disney Princess $ 2,299,500 $ 81,900
Disney’s Mickey Mouse $ 1,317,075 $ 64,950
Divers $ 420,225 $ 65,625
Dragon Knights $ 204,975 $ 25,275
Drome Racers $ 1,299,525 $ 60,525
Duplo $ 1,953,675 $ 101,700
Easter $ 831,300 $ 43,275
Educational and Dacta $ 1,039,425 $ 187,950
eLAB $ 555,450 $ 47,175
Elves $ 466,125 $ 48,525
EV3 $ 891,225 $ 21,975
Exo-Force $ 669,150 $ 16,500
Expert Builder $ 27,375 $ 4,575
Explore $ 408,600 $ 45,992
Exploriens $ 379,950 $ 34,350
Extreme Team $ 104,025 $ 1,425
Fabuland $ 757,350 $ 56,025
Factory $ 768,600 $ 111,600
Fairy-Tale $ 383,250 $ 12,600
Fantasy $ 632,700 $ 15,600
Fantasy Era $ 179,700 $ 11,325
Farm $ 1,000,575 $ 79,500
Ferrari $ 889,050 $ 102,300
Ferries $ 474,525 $ 7,800
Fire $ 602,250 $ 42,900
FIRST LEGO League $ 475,950 $ 57,375
Food & Drink $ 852,525 $ 49,050
Forestmen $ 1,012,875 $ 16,650
Freemakers $ 1,273,425 $ 101,175
Freestyle $ 180,225 $ 5,925
Friends $ 698,475 $ 63,150
Fright Knights $ 652,275 $ 41,100
Fusion $ 349,575 $ 12,450
Futuron $ 221,175 $ 15,150
Galaxy Squad $ 1,189,200 $ 110,775
Game $ 572,775 $ 40,800
Gas Station $ 551,475 $ 61,950
Gear $ 32,850 $ 1,350
Gears $ 861,600 $ 44,850
Ghostbusters $ 5,098,875 $ 321,300
Glatorian $ 3,883,575 $ 159,600
Glatorian Legends $ 618,375 $ 28,800
Goblet of Fire $ 621,825 $ 47,700
Golden Land $ 16,725 $ 1,650
Gravity Games $ 346,425 $ 24,675
Guardians of the Galaxy $ 1,982,400 $ 260,700
Halloween $ 70,500 $ 7,802
Harbor $ 528,600 $ 42,000
Harry Potter $ 545,550 $ 20,925
Hero Factory $ 4,253,475 $ 337,950
Heroes $ 418,875 $ 22,950
HO 1:87 Vehicles $ 595,875 $ 48,975
Hobby Sets $ 782,175 $ 45,000
Hockey $ 677,550 $ 29,700
Holiday $ 535,575 $ 33,750
Homemaker $ 353,475 $ 43,575
Hospital $ 54,750 $ 450
Hydronauts $ 1,152,225 $ 34,725
Ice Planet 2002 $ 264,000 $ 10,125
Imperial Armada $ 314,850 $ 20,700
Imperial Guards $ 509,850 $ 44,700
Imperial Soldiers $ 503,100 $ 39,975
Indiana Jones $ 785,250 $ 81,750
Indians $ 951,300 $ 83,400
Insectoids $ 294,675 $ 13,725
Inventor $ 336,000 $ 10,125
Iron Man $ 588,600 $ 32,250
Island Xtreme Stunts $ 640,275 $ 31,575
Islanders $ 1,284,450 $ 175,950
Jack Stone $ 484,800 $ 63,750
Jumbo Bricks $ 1,777,575 $ 150,975
Jungle $ 796,350 $ 24,000
Jungle Rescue $ 552,600 $ 89,325
Juniors $ 623,325 $ 88,800
Jurassic Park III $ 1,513,200 $ 480,675
Jurassic World $ 429,675 $ 38,850
Justice League $ 1,207,425 $ 92,625
Key Chain $ 1,032,825 $ 104,700
Kingdom of the Crystal Skull $ 788,550 $ 99,375
Kingdoms $ 560,475 $ 29,175
Knights Kingdom I $ 627,375 $ 61,875
Knights Kingdom II $ 517,050 $ 75,075
Lamborghini $ 662,025 $ 68,925
Last Crusade $ 1,106,850 $ 112,200
Launch Command $ 1,689,450 $ 32,400
Learning $ 1,431,675 $ 154,125
Legend Beasts $ 720,900 $ 71,100
Legends of Chima $ 1,111,275 $ 97,425
LEGO Brand Store $ 1,894,350 $ 51,900
LEGO Exclusive $ 363,375 $ 40,223
LEGO Ideas and CUUSOO $ 97,500 $ 4,275
Legoland $ 1,973,175 $ 205,425
Legoland Parks $ 344,100 $ 54,675
Life On Mars $ 728,175 $ 19,950
Lion Knights $ 2,599,725 $ 213,675
M:Tron $ 7,274,925 $ 318,900
Mars Mission $ 834,000 $ 34,275
Marvel $ 1,170,300 $ 51,300
Marvel Super Heroes $ 668,475 $ 91,575
Master Building Academy $ 647,400 $ 65,625
Matoran of Light $ 493,575 $ 43,275
Matoran of Mahri Nui $ 403,350 $ 16,575
Matoran of Mata Nui $ 1,206,975 $ 72,750
Matoran of Metru Nui $ 204,675 $ 11,775
Matoran of Voya Nui $ 217,575 $ 23,483
Mecha $ 225,075 $ 22,200
Mindstorms $ 1,026,000 $ 70,275
Minecraft $ 299,100 $ 44,250
Mini $ 133,875 $ 42,000
Minifig Pack $ 395,775 $ 26,025
Minitalia $ 1,004,925 $ 66,075
Mission Deep Freeze $ 417,450 $ 13,725
Mission Deep Sea $ 372,300 $ 20,400
Mistika $ 1,334,550 $ 58,500
Mixels $ 516,900 $ 24,075
Model $ 202,575 $ 8,325
Model Team $ 650,175 $ 114,000
Modular Buildings $ 711,750 $ 1,850
Monster Fighters $ 824,325 $ 20,325
Monthly Mini Model Build $ 311,400 $ 13,650
Mosaic $ 733,650 $ 20,100
My Own Creation $ 657,000 $ 21,600
My Own Train $ 1,085,250 $ 41,625
name $ 353,250 $ 30,000
Nexo Knights $ 317,550 $ 13,050
Nijago $ 547,500 $ 36,000
Ninja $ 395,100 $ 64,950
Ninjago $ 639,900 $ 14,025
NXT $ 163,200 $ 22,800
Off-Road $ 494,944 $ 126,109
Order of the Phoenix $ 418,125 $ 50,400
Orient Expedition $ 244,875 $ 24,150
Other $ 832,050 $ 86,625
Outback $ 270,675 $ 6,675
Paradisa $ 208,350 $ 10,275
Phantoka $ 500,550 $ 9,600
Pharaoh’s Quest $ 379,800 $ 65,550
Pick A Model $ 450,300 $ 35,775
Piraka $ 3,257,625 $ 6,000
Pirates $ 673,050 $ 53,475
Pirates I $ 453,525 $ 54,675
Pirates II $ 968,625 $ 34,500
Pirates III $ 555,300 $ 21,300
Pirates of the Caribbean $ 351,750 $ 31,800
Planet Series 1 $ 301,125 $ 825
Planet Series 2 $ 471,075 $ 55,500
Planet Series 3 $ 883,800 $ 84,750
Planet Series 4 $ 160,800 $ 17,801
Playhouse $ 561,225 $ 6,150
Playsets $ 132,300 $ 2,175
Police $ 349,275 $ 31,575
Post Office $ 376,575 $ 50,550
Power Functions $ 1,505,625 $ 169,125
Power Miners $ 380,025 $ 17,700
Power Racers $ 14,250 $ 900
Primo $ 17,625 $ 675
Prince of Persia $ 564,900 $ 17,025
Prisoner of Azkaban $ 310,725 $ 17,025
Promotional $ 410,625 $ 21,375
Protectors $ 1,715,925 $ 220,950
Quatro $ 2,002,650 $ 175,575
Race $ 1,110,750 $ 100,425
Racers $ 89,100 $ 11,475
Radio Control $ 159,825 $ 16,200
Rahaga $ 447,600 $ 24,525
Rahi $ 217,500 $ 10,725
Rahkshi $ 223,425 $ 22,650
Raiders of the Lost Ark $ 438,000 $ 1,200
RC Train $ 392,400 $ 64,500
RCX $ 4,198,650 $ 92,025
Recreation $ 564,375 $ 72,675
Res-Q $ 1,677,900 $ 190,360
Riding Cycle $ 547,500 $ 34,500
RoboForce $ 490,200 $ 42,975
RoboRiders $ 517,200 $ 39,675
Robot $ 324,675 $ 32,025
Rock Raiders $ 743,700 $ 48,900
Royal Knights $ 1,328,400 $ 147,031
Samsonite $ 818,025 $ 114,300
Scala $ 266,175 $ 21,150
Scooby-Doo $ 259,500 $ 17,775
Sculptures $ 1,397,400 $ 241,200
Seasonal $ 1,572,075 $ 90,450
Series 1 $ 522,975 $ 27,225
Series 1 Minifigures $ 217,050 $ 8,325
Series 10 Minifigures $ 302,100 $ 48,000
Series 11 Minifigures $ 139,650 $ 22,575
Series 12 Minifigures $ 196,800 $ 19,950
Series 13 Minifigures $ 204,825 $ 65,000
Series 14 Minifigures $ 211,275 $ 22,575
Series 15 Minifigures $ 714,900 $ 137,100
Series 16 Minifigures $ 26,025 $ 1,425
Series 17 Minifigures $ 13,725 $ 150
Series 2 $ 1,249,275 $ 75,300
Series 2 Minifigures $ 272,025 $ 35,025
Series 3 $ 507,675 $ 45,900
Series 3 Minifigures $ 846,900 $ 37,125
Series 4 $ 427,875 $ 31,650
Series 4 Minifigures $ 871,200 $ 40,575
Series 5 $ 289,125 $ 38,025
Series 5 Minifigures $ 309,900 $ 23,775
Series 6 $ 558,225 $ 35,175
Series 6 Minifigures $ 396,525 $ 35,850
Series 7 $ 346,725 $ 8,550
Series 8 $ 1,434,150 $ 263,250
Series 8 Minifigures $ 1,745,925 $ 43,050
Series 9 $ 607,200 $ 18,300
Series 9 Minifigures $ 5,151,375 $ 395,175
Service Packs $ 264,375 $ 27,525
Skull Spiders $ 161,400 $ 30,075
Skylines $ 395,850 $ 28,200
Soccer $ 299,100 $ 33,600
Soft Bricks $ 466,275 $ 38,325
Sorcerer’s Stone $ 108,900 $ 13,125
Space $ 89,400 $ 7,350
Space Police I $ 299,700 $ 32,669
Space Police II $ 148,725 $ 15,075
Space Police III $ 130,050 $ 1,425
Space Port $ 243,450 $ 24,675
Speed Champions $ 132,675 $ 4,725
Speed Racer $ 126,300 $ 15,225
Speed Slammers $ 248,700 $ 23,850
Speedorz $ 205,350 $ 9,000
Spider-Man $ 953,550 $ 31,350
Spider-Man 2 $ 20,625 $ 3,000
SpongeBob SquarePants $ 1,263,150 $ 72,675
Sports $ 266,925 $ 23,400
Spybiotics $ 497,475 $ 39,525
Spyrius $ 600,750 $ 29,625
Star Wars $ 152,100 $ 25,425
Star Wars Clone Wars $ 157,425 $ 24,150
Star Wars Episode 1 $ 215,175 $ 21,925
Star Wars Episode 2 $ 162,675 $ 31,650
Star Wars Episode 3 $ 903,375 $ 12,375
Star Wars Episode 4/5/6 $ 401,175 $ 28,575
Star Wars Episode 7 $ 438,000 $ 14,400
Star Wars Episode 8 $ 394,350 $ 34,575
Star Wars Expanded Universe $ 574,875 $ 33,075
Star Wars Other $ 301,875 $ 19,775
Star Wars Rebels $ 109,500 $ 2,700
Star Wars Rogue One $ 142,350 $ 15,945
Stars $ 214,050 $ 6,450
Station $ 456,075 $ 54,975
Stingrays $ 250,275 $ 4,800
Studios $ 615,975 $ 27,000
Super Heroes $ 608,100 $ 46,650
Superman $ 379,500 $ 22,875
Supplemental $ 68,475 $ 3,000
Team GB $ 18,000 $ 1,575
Technic $ 541,050 $ 25,200
Teenage Mutant Ninja Turtles $ 1,231,875 $ 3,375
Temple of Doom $ 240,150 $ 14,475
Thanksgiving $ 1,036,650 $ 65,325
The Battle of the Five Armies $ 565,725 $ 37,200
The Desolation of Smaug $ 1,363,200 $ 201,675
The Fellowship of the Ring $ 378,525