Tuesday, December 3, 2019

Lego: Christmas gift without bricking the bank



Four years ago right around Christmas time, I had posted an analysis of how the prices of Lego sets were related to their number of pieces.

Checking a Lego Christmas catalog last week, I had the feeling that:
  1. prices had gone up in general
  2. yet the 10-pieces-per-dollar ratio I had estimated 4 years ago still appeared to be valid.
This conclusion would then naturally be that the number of pieces had also gone up.

I pulled all the prices and number of pieces by Lego theme (over 40 nowadays!), and revisited the analysis.

The data needed some clean-up again, especially regarding sets with with abnormal prices for the number of pieces: the Duplo sets (oversized blocks are much more expensive), the Mindstorms sets (the color sensor is over $40) and Powered-Up sets (the move hub is $80). Similarly to last time, I also split themes into those that are based on an external partnership (Star Wars, Harry Potter, Marvel, DC...) and those entirely developed by Lego (City, Friends, Creator Expert...).

Here's the plot of pieces versus price for all sets less than $200 (95% of sets), and removing the outliers mentioned in the previous paragraph:


It's quite tempting to look at the range for the pieces-to-price ratio across sets, splitting by theme:


Out of the top 10 themes with best median ratio, 9 are themes Lego developed in-house, and only one is through external partnership (car makers, deal might not have been as lucrative as for Marvel or Star Wars rights).

We can fit a linear model to fit the number of pieces against price, partnership, and their interaction:


The result is that for non-partnership sets, we get a pieces-to-price ratio of approximately 10.7, ratio that drops to just over 9 for the partnership sets. The difference is highly significant and confirms our previous observations. The intercepts are slightly different but not significantly so.

A question we might be interested in is whether we observe any diminishing or increasing returns as the prices go up. This can be done by observing the pieces-to-price ratio for various pice buckets:

As we might have expected, our pieces-to-price improves as we go into the more expensive sets. This makes sense as the pieces are only one of the costs for sets, there are many other fixed costs in terms of packaging and marketing that will make the smaller sets less attractive to the smart buyer.
Non-partnership sets appear to always outperform the partnership sets, but one should keep in mind that the sample size is pretty small in the $200+ bucket.
The previous result also throws some shade on our linear models, the slopes (pieces-to-price ratio) are actually not constant. If we wanted to improve the models, we would probably need to include a quadratic term for price.

So to recap, your best pieces per dollar will come from non-partnership and bigger sets. Of course it could be your child has a specific theme in mind, so to help out with your Christmas purchases, here's the list of the best sets for each theme:

ThemeProduct NamePiecesPriceRatio
Architecturetrafalgar-square119779.9914.96
Boostdroid-commander1177199.995.89
Brickheadzthanksgiving-scarecrow1779.9917.72
Citypizza-van24919.9912.46
Classicbricks-bricks-bricks150059.9925.00
Creator-3-in-1deep-sea-creatures23014.9915.34
Creator-Experttaj-mahal5923369.9916.01
Dc1989-batmobile3306249.9913.22
Disneythe-disney-castle4080349.9911.66
Disney-Frozen-2elsa-s-magical-ice-palace70179.998.76
Duplocreative-fun12039.993.00
Fantastic-Beastsnewt-s-case-of-magical-creatures69449.9913.88
Friendsunderwater-loop38929.9912.97
Harry-Potterhogwarts-castle6020399.9915.05
Hidden-Sideshrimp-shack-attack57949.9911.58
Ideaslego-nasa-apollo-saturn-v1969119.9916.41
Juniorscity-central-airport37649.997.52
Jurassic-Worldjurassic-park-t-rex-rampage3120249.9912.48
Lego-Batman-Sets1989-batmobile3306249.9913.22
Lego-Spider-Manspider-mech-vs-venom60449.9912.08
Marvelthe-hulkbuster-smash-up37529.9912.50
Mindstormslego-mindstorms-ev3601349.991.72
Minecraftthe-wool-farm26019.9913.01
Minifiguresmf-set-ninjago-20195912.994.54
Ninjagoninjago-city4867299.9916.22
Overwatchdorado-showdown41929.9913.97
Power-Functionslego-power-functions-train-motor713.990.50
Powered-Updisney-train-and-station2925329.998.86
Powerpuff-Girlsmojo-jojo-strikes22829.997.60
Serious-Playwindow-exploration-bag4900484.9910.10
Speed-Championsformula-e-panasonic-jaguar-racing56529.9918.84
Star-Warsyoda177199.9917.71
Stranger-Thingsthe-upside-down2287199.9911.44
Techniccherry-picker1559.9915.52
The-Lego-Movie-2pop-up-party-bus102479.9912.80
The-Lego-Ninjago-Movieninjago-city4867299.9916.22
Toy-Story-4woody-rc699.996.91
Unikittyunikitty-cloud-car1269.9912.61
Xtratraffic-lights463.9911.53

Now one important caveat should be mentioned here. Number of pieces is a great proxy for size and time to build, but it isn't perfect. Going through some sets I've noticed a tendency of adding more and more small decorative pieces. This trick can significantly and artificially bump up the piece number. Ideally we should also include weight to control for that aspect, but weight was not available and would probably not have been available at the desired granularity level. Take the new gingerbread house for instance. At $99 for 1477 pieces it seems like a great deal, but take a closer look at what's inside:

Look at all those small pieces! Especially the red and white candy canes around the doors and windows. Just tiny 1-by-1 round shapes staked together. Almost 100 of them, and I doubt they're worth $10!

Now of course, these were just models, and you can throw them all out the window when it comes Ole Kirk's house. Who? Ole Kirk as in Ole Kirk Christiansen, the man who created The Lego Company. His house is an extremely rare Lego set which was gifted only to employees (and a few special visitors). At 912 pieces we would roughly estimate it at $90, but good luck finding it at less than $300, prices of $500 are not uncommon for unopened sets!


No comments:

Post a Comment