PPP and PPW

Vindic8ed

While reading the comments in the Land Rover announcement, alternative measurements for value was talked about (as it has been in the past).  I didn't look to see if anyone has done calculations for PPW and posted them here, but I decided to do some quick ones.  I liked the idea of using the average weight/price per piece as the value of the set.  I grabbed the entire modular range and came up with this:

Name	Released	Price	Weight (grams)	Pieces	PPW	PPP	PPW-PPP Average
Green Grocer	2008	149.99	3180	2335	0.047	0.064	0.056
Police Station	2021	199.99	4155	2903	0.048	0.069	0.059
Grand Emporium	2010	149.99	2903	2154	0.052	0.070	0.061
Fire Brigade	2009	149.99	2761	2215	0.054	0.068	0.061
Cafe Corner	2007	139.99	2591	2044	0.054	0.068	0.061
Pet Shop	2011	149.99	2820	2154	0.053	0.070	0.061
Palace Cinema	2013	149.99	2770	2170	0.054	0.069	0.062
Market Street	2007	89.99	1780	1236	0.051	0.073	0.062
Town Hall	2012	199.99	3825	2733	0.052	0.073	0.063
Parisan Restaurant	2014	159.99	2610	2449	0.061	0.065	0.063
Downtown Diner	2018	169.99	2800	2454	0.061	0.069	0.065
Detectives Office	2015	159.99	2624	2238	0.061	0.071	0.066
Brick Bank	2016	169.99	2745	2360	0.062	0.072	0.067
Jazz Club	2023	229.99	3870	2866	0.059	0.080	0.070
Assembly Square	2017	299.99	4666	3966	0.064	0.076	0.070
Botique Hotel	2022	229.99	3473	3037	0.066	0.076	0.071
Corner Garage	2019	199.99	3035	2545	0.066	0.079	0.072
Book Shop	2020	199.99	2932	2483	0.068	0.081	0.074
Modular Lego Store	2022	179.99	2440	2149	0.074	0.084	0.079
Modular Construction Site	2023	319.99	?	3371	?	0.095	?

Note 1: the weights are from Bricklink; I'm not sure if the weights are the plastic themselves or if they include the box/instructions/packaging material

Note 2: The table is sorted by the last column (PPW-PPP Average)

Vindic8ed

I know there are a lot of ways people have come up with to value a set.  PPP/PPW may still not be the best measurement of value, but I liked the suggestion of combining several metrics together.  By doing that we could come up with a universal way of comparing sets' values.

Huw

BrickLink weights are of the sealed box, used for shipping purposes. 25% of it is usually accounted for by the manual.

Brainslugged

Are those weights from Bricklink? I'd always wondered if the weights given are weight of the entire package (inc box, manual etc) or the weight of just the bricks.

Vindic8ed

Thanks Huw, that's good to know.  I have all the modulars; I'm thinking of weighing just the builds, but none of them are built atm...so it will take some time to do.  I'd also like to compare similarly priced sets to other themes to get a better dataset.

Would it be safe to assume that 30-35% of the sealed box weight does not contribute to the set?

560Heliport

@Vindic8ed I believe Bricklink's weights are for the boxed set: packaging, instructions, and parts, because the item's dimensions are listed below the weight, and they're clearly the box dimensions.
FWIW, PPP and PPW are meaningless for me. I assess the value of a set by how much I like the model, including minifigs, new/rare parts or colors, play features. This is entirely subjective, of course! 

iwybs

Bricklink has separate weights for the box and for the instructions. Subtract those and you'll be left with the weight of the parts and the plastic bags.

560Heliport

@iwybs Thank you, I didn't know that! I mostly use Bricklink just for the part inventories.

Vindic8ed

560Heliport said:

I assess the value of a set by how much I like the model.

As subjective as that is, that's honestly the best way to look at any set. However, I feel like it's a good idea to have a solid baseline of how far your money is going.

Vindic8ed

iwybs said:

Bricklink has separate weights for the box and for the instructions. Subtract those and you'll be left with the weight of the parts and the plastic bags.

That's cool, thank you!

Using the Jazz Club as an example, ~27% of the weight is the box/instructions. 

After thinking about it a little more, I'm hesitant to take those out of the calculation though as they contribute to the cost of the set.  It could be argued one way that they don't add value to the actual playability of the set; it could be argued the other way, that it helps a set retainis value.  Maybe include both, "Overall PPW" and "Brick PPW".

vizzitor

To compare each properly, you'd also have to account for inflation. Especially as somehow it's 16 years (sixteen!) since 2007, the earliest on the list.

ickis

vizzitor said:

To compare each properly, you'd also have to account for inflation. Especially as somehow it's 16 years (sixteen!) since 2007, the earliest on the list.

I forgot all about inflation.  That's a good point.  I still think both these metrics don't do much to account for premiums on complex parts and printed parts.

oldtodd33

vizzitor said:

To compare each properly, you'd also have to account for inflation. Especially as somehow it's 16 years (sixteen!) since 2007, the earliest on the list.

   No, the whole reason for the list is so you can see the inflation. For example, Green Grocer PPP is .064 and the latest Jazz Club is .080. If you adjust for inflation you would never see this. PPW is useless/pointless knowledge since it includes the weight of the box, manual and empty plastic bags which don't add anything of visual value to the actual set. 

560Heliport

oldtodd33 said:

vizzitor said:

To compare each properly, you'd also have to account for inflation. Especially as somehow it's 16 years (sixteen!) since 2007, the earliest on the list.

   No, the whole reason for the list is so you can see the inflation. For example, Green Grocer PPP is .064 and the latest Jazz Club is .080. If you adjust for inflation you would never see this. PPW is useless/pointless knowledge since it includes the weight of the box, manual and empty plastic bags which don't add anything of visual value to the actual set. 

No, if you don't adjust for inflation, then Green Grocer has the better PPP. But you can't buy Green Grocer new today for $149.99!

oldtodd33

560Heliport said:

oldtodd33 said:

vizzitor said:

To compare each properly, you'd also have to account for inflation. Especially as somehow it's 16 years (sixteen!) since 2007, the earliest on the list.

   No, the whole reason for the list is so you can see the inflation. For example, Green Grocer PPP is .064 and the latest Jazz Club is .080. If you adjust for inflation you would never see this. PPW is useless/pointless knowledge since it includes the weight of the box, manual and empty plastic bags which don't add anything of visual value to the actual set. 

No, if you don't adjust for inflation, then Green Grocer has the better PPP. But you can't buy Green Grocer new today for $149.99!

   Doesn't matter that I can't buy a new GG, I'm not looking to. The point is to see inflation and adjusting for it wipes that out, some call it disinformation. This isn't the US government.

Vindic8ed

ickis said:

I forgot all about inflation.  That's a good point.  I still think both these metrics don't do much to account for premiums on complex parts and printed parts.

I don't feel like the Modulars have very many complex and/or printed parts.  Most of the ones that have printed parts can be found in other sets.  One that immediately comes to mind is the sailboat tile.

Vindic8ed

oldtodd33 said:

PPW is useless/pointless knowledge since it includes the weight of the box, manual and empty plastic bags which don't add anything of visual value to the actual set. 

Calculating it out doesn't seem to be a huge issue though, since we have the weights of the box and manuals.  One example already mentioned is the Jazz Club.  Those two items account for ~27% of the weight; take out another 3-5% for the plastic bags and it should be relatively close to the actual weight of the pieces themselves.  I haven't had a chance to look at all the numbers but I should have some time to do it tomorrow.

Vindic8ed

560Heliport said:

No, if you don't adjust for inflation, then Green Grocer has the better PPP. But you can't buy Green Grocer new today for $149.99!

I will add inflation to the chart as an additional category so people can see the differences.  However, in the case of the Green Grocer, the PPP would be worse, since it's adjusted price today is $217.49 (not taking into account that it's not available): .094 PPP.

oldtodd33

Vindic8ed said:

560Heliport said:

No, if you don't adjust for inflation, then Green Grocer has the better PPP. But you can't buy Green Grocer new today for $149.99!

I will add inflation to the chart as an additional category so people can see the differences.  However, in the case of the Green Grocer, the PPP would be worse, since it's adjusted price today is $217.49 (not taking into account that it's not available): .094 PPP.

   That was my whole point. Adjusting for inflation lies about the price. If left alone it shows GG was cheaper which of course it was. Inflation has caused the price of each brick to increase by 1.6 cents not drop down 1.4 cents. That's the lie. Lies, damned lies and statistics. 

Brickchap

Thank you for posting this! I like this idea and agree combining measurements is a good way of getting an idea of price value. (as long as people don't treat it as the Word of God it's fine).

Personally I like Jangbricks 'Amount of Stuff That You Get', especially when judging play sets and sets aimed at kids. For example the 2015 Deep Sea Research Vessel I think it was called was excellent value. You got a floating ship with a crane, multiple submarines, a bunch of sea creatures, and a whole ship wreck (also with a gold story that could easily tie in to other themes like Police or Cargo). Compare that to other sets around $100 where you'd get a big police station for example but kids can't actually do all that much with it. (I would also mention if you have multiple children then play sets with lots of stuff are also often better value).

Another example would be the 2017 Airshow (2 jets plus a biplane plus a hangar and tug) for I believe it was around $70 compared to $150 for one giant plane that only fits 6 passengers (and doesnt even come with that many minifigs), too large to store easily or fit in an airport layout, large and bulky for a kid to fly around lots of prefabricated pieces so difficult to rebuild into something else.

Or that new backhoe set for $30 compared to the new Indiana Jones fighter plane chase. Naturally a child's interests will determine buying decisions, but a cool car and fighter plane that shoots stuff with 3 minifigs is much better value than just one backhoe with 1 minifig with various issues regarding how the bucket and rear drill work.

Vindic8ed

oldtodd33 said:

Vindic8ed said:

560Heliport said:

No, if you don't adjust for inflation, then Green Grocer has the better PPP. But you can't buy Green Grocer new today for $149.99!

I will add inflation to the chart as an additional category so people can see the differences.  However, in the case of the Green Grocer, the PPP would be worse, since it's adjusted price today is $217.49 (not taking into account that it's not available): .094 PPP.

   That was my whole point. Adjusting for inflation lies about the price. If left alone it shows GG was cheaper which of course it was. Inflation has caused the price of each brick to increase by 1.6 cents not drop down 1.4 cents. That's the lie. Lies, damned lies and statistics. 

Not adjusting for inflation also shows the outliers, and how arbitrary pricing can be.  One of the newer sets, the police station, appears to be one of the best deals.

oldtodd33

^ Why is Police station an outlier? At .069 each and the average price of a modular being .067 each over the years it's just above average. I did not include the last two modulars as they are not official Lego sets and the last set isn't finalized for pieces or price.

560Heliport

@Brickchap If you're going to compare sets, please get your facts straight. 
2016's #60103 Airport Air Show was $119.99 AU$, #60104 Airport Passenger Terminal was $149.99 and did include six minifigures. So $120 vs. $150, not $70 vs. $150.
This year's #60385 Construction Digger is $32.99 AU$ and includes two figures. #77012 Fighter Plane Chase is $49.99 nd includes three figures.

Brickchap

@560Heliport Okay so I confused the Yank price for the Aussie one. Airport Air Show is still much better value. Also, while yes Passenger Terminal does have 6 minifigs, that's all airport staff, the pilot, ground crew and passengers. You should get at least 5 regular civilian passengers. And the problems with the plane remain.

Okay and for 60385 and 77012 well how do the Yank prices compare?

Brickchap

@Vindic8ed Yeah Police Station is great value. Sadly Boutique Hotel, but particularly Jazz Club are terrible value. I mean, just look at Police Station ($300 AU) compared to Jazz Club ($350 AU). Police Station is one of the taller, more imposing modulars, while JC is one of the shortest. To my knowledge people were pretty happy with Police Station (aside from the absence of any form of police vehicle was is rather silly) whereas Jazz Club from what I've read and seen 99% of people find it to be very 'meh'/underwhelming/disappointing etc. It's interesting too that even more controversial modulars like Downtown Diner had lots of people who really liked it, or at least certain parts of it, whereas Jazz Club it's not that anyone is saying it's terrible but there doesn't seem to be much anyone really likes about it. Police Station had lots of fun details and wasn't really lacking anything, whereas Jazz Club the pizzeria is barely as detailed as a City or Friends set (some Friends sets actually outdo it) while the rest of the building is pretty lacking or underwhelming with detail.

560Heliport

@Brickchap #60385 is $19.99 and #77012 is $34.99. So #60385 is a slightly better value, relative to #77012, in the U.S. compared to Australia.
I dislike "price points"- it means compromises must be made to hit e.g. $19.99. The designers either have to add some little side build or omit something else to make the perceived value come in at $19.99. I'd much prefer it if all the $19.99 sets actually got priced at their "true" price: one might be $18.63, another $21.84. 

Vindic8ed

oldtodd33 said:

^ Why is Police station an outlier? At .069 each and the average price of a modular being .067 each over the years it's just above average. I did not include the last two modulars as they are not official Lego sets and the last set isn't finalized for pieces or price.

I was using the PPW/PPP calculation, not just the PPP.  I'll be posting the updated chart below, which deducts the weight of the box/instructions.

Vindic8ed

New chart:

Name	Price	PPP	PPW	TPPW	TPPW/PPP	PPW/PPP
Green Grocer	149.99	0.064	0.069	0.047	0.056	0.067
Police Station	199.99	0.069	0.066	0.048	0.059	0.068
Cafe Corner	139.99	0.068	0.067	0.054	0.061	0.068
Market Street	89.99	0.073	0.065	0.051	0.062	0.069
Grand Emporium	149.99	0.070	0.070	0.052	0.061	0.070
Town Hall	199.99	0.073	0.068	0.052	0.063	0.071
Fire Brigade	149.99	0.068	0.074	0.054	0.061	0.071
Pet Shop	149.99	0.070	0.072	0.053	0.062	0.071
Palace Cinema	149.99	0.069	0.073	0.054	0.062	0.071
Parisan Restaurant	159.99	0.065	0.083	0.061	0.063	0.074
Downtown Diner	169.99	0.069	0.085	0.061	0.065	0.077
Detectives Office	159.99	0.071	0.084	0.061	0.066	0.078
Brick Bank	169.99	0.072	0.083	0.062	0.067	0.078
Jazz Club	229.99	0.080	0.082	0.059	0.070	0.081
Assembly Square	299.99	0.076	0.087	0.064	0.070	0.082
Modular Lego Store	179.99	0.084	?	0.074	0.079	0.084
Botique Hotel	229.99	0.076	0.094	0.066	0.071	0.085
Corner Garage	199.99	0.079	0.092	0.066	0.073	0.086
Book Shop	199.99	0.081	0.092	0.068	0.075	0.087
Modular Construction Site	319.99	0.095	?	?	0.095	0.095
Average	184.99	0.074	0.070	0.055	0.067	0.076

Note1: Chart is sorted by PPW/PPP (last column)
Note2: TPPW = Total Price Per Weight (set, box, instructions) vs. PPW (just the set)

Notice that--for the most part--PPW and PPP are relatively close.  There are a few outliers, like Detective's Office and Brick Bank.

Vindic8ed

You're not able to sort the data from the chart here on the forums, but if you put it into Excel and sort by the different categories there are some interesting trends (again, with some outliers).

For example, taking the TPPW, the cheapest set has the lowest weight and the most expensive set has the highest weight:

Market Street

2007

89.99

1780

Assembly Square

2017

299.99

4666

Two of the outliers are:

Downtown Diner

2018

169.99

2800

Green Grocer

2008

149.99

3180

There are a couple changes when sorting by PPW but it's place in the chart is relatively consistent to TPPW (IE, Assembly Square is still the most and Market Street still the least).  I believe weight has a significant role to play in price point (at least in this data I've gathered for the modulars).

This does not take into account inflation, but I think that makes this even more interesting, because the prices have remained relatively the same (if not arguably low) if you are looking at the weight alone.  Sets that have more material cost more and sets that have less cost less).

Vindic8ed

Here are all of the sets from 1980-2023  that are $150+.  The table is sorted by PPP/PPW average (last column, low to high).

Number	Year	Weight (g)	Pieces	RRP	PPP	PPW	PPP/PPW Average
31203-1	2021	5482	11695	$249.99	$0.02	$0.05	$0.03
10189-1	2008	6402	5922	$299.99	$0.05	$0.05	$0.05
3450-1	2000	6500	2882	$199.00	$0.07	$0.03	$0.05
10181-1	2007	4500	3428	$199.99	$0.06	$0.04	$0.05
70620-1	2017	6200	4867	$299.99	$0.06	$0.05	$0.06
10185-1	2008	3180	2352	$149.99	$0.06	$0.05	$0.06
10214-1	2010	4335	4287	$239.99	$0.06	$0.06	$0.06
10276-1	2020	10780	9036	$549.99	$0.06	$0.05	$0.06
10284-1	2021	6820	5509	$349.99	$0.06	$0.05	$0.06
70657-1	2018	4470	3553	$229.99	$0.06	$0.05	$0.06
10278-1	2021	4155	2923	$199.99	$0.07	$0.05	$0.06
42078-1	2018	3805	2595	$179.99	$0.07	$0.05	$0.06
10030-1	2002	9093	3096	$269.99	$0.09	$0.03	$0.06
10307-1	2022	11680	10001	$629.99	$0.06	$0.05	$0.06
3723-1	2000	4075	1850	$149.00	$0.08	$0.04	$0.06
10143-1	2005	6811	3441	$269.99	$0.08	$0.04	$0.06
42055-1	2016	5858	3929	$279.99	$0.07	$0.05	$0.06
71741-1	2021	5996	5685	$349.99	$0.06	$0.06	$0.06
10211-1	2010	2903	2182	$149.99	$0.07	$0.05	$0.06
10018-1	2001	3712	1868	$150.00	$0.08	$0.04	$0.06
8421-1	2005	3605	1884	$150.00	$0.08	$0.04	$0.06
10197-1	2009	2761	2231	$149.99	$0.07	$0.05	$0.06
10256-1	2017	6254	5923	$369.99	$0.06	$0.06	$0.06
42098-1	2019	3620	2493	$179.99	$0.07	$0.05	$0.06
8258-1	2009	3570	1877	$149.99	$0.08	$0.04	$0.06
910027-1	2023	4332	3889	$249.99	$0.06	$0.06	$0.06
10232-1	2013	2770	2196	$149.99	$0.07	$0.05	$0.06
21322-1	2020	4510	2545	$199.99	$0.08	$0.04	$0.06
10294-1	2021	14000	9090	$679.99	$0.07	$0.05	$0.06
70618-1	2017	2974	2295	$159.99	$0.07	$0.05	$0.06
80036-1	2022	3157	2187	$159.99	$0.07	$0.05	$0.06
31206-1	2022	3040	1998	$149.99	$0.08	$0.05	$0.06
42082-1	2018	5932	4057	$299.99	$0.07	$0.05	$0.06
10224-1	2012	3825	2766	$199.99	$0.07	$0.05	$0.06
10243-1	2014	2610	2469	$159.99	$0.06	$0.06	$0.06
10299-1	2022	6860	5876	$399.99	$0.07	$0.06	$0.06
10218-1	2011	2820	2032	$149.99	$0.07	$0.05	$0.06
10184-1	2008	2888	1981	$149.99	$0.08	$0.05	$0.06
21310-1	2017	2700	2049	$149.99	$0.07	$0.06	$0.06
76139-1	2019	4670	3306	$249.99	$0.08	$0.05	$0.06
42128-1	2021	3205	2017	$159.99	$0.08	$0.05	$0.06
10260-1	2018	2800	2480	$169.99	$0.07	$0.06	$0.06
10253-1	2016	3605	4163	$249.99	$0.06	$0.07	$0.06
75827-1	2016	6416	4634	$349.99	$0.08	$0.05	$0.07
70922-1	2017	5168	3444	$269.99	$0.08	$0.05	$0.07
75936-1	2019	4906	3120	$249.99	$0.08	$0.05	$0.07
21330-1	2021	5390	3955	$299.99	$0.08	$0.06	$0.07
10246-1	2015	2624	2262	$159.99	$0.07	$0.06	$0.07
80013-1	2020	3690	1959	$169.99	$0.09	$0.05	$0.07

Vindic8ed

42043-1	2015	4513	2793	$229.99	$0.08	$0.05	$0.07
10251-1	2016	2745	2380	$169.99	$0.07	$0.06	$0.07
41732-1	2023	2969	2010	$159.99	$0.08	$0.05	$0.07
42110-1	2019	3550	2573	$199.99	$0.08	$0.06	$0.07
80039-1	2022	3380	2433	$189.99	$0.08	$0.06	$0.07
21333-1	2022	2790	2316	$169.99	$0.07	$0.06	$0.07
71006-1	2014	3618	2523	$199.99	$0.08	$0.06	$0.07
42069-1	2017	3006	2382	$179.99	$0.08	$0.06	$0.07
76161-1	2020	3900	2363	$199.99	$0.08	$0.05	$0.07
70839-1	2019	2757	1826	$149.99	$0.08	$0.05	$0.07
42009-1	2013	4207	2606	$219.99	$0.08	$0.05	$0.07
21137-1	2017	5050	2863	$249.99	$0.09	$0.05	$0.07
10272-1	2020	5000	3898	$299.99	$0.08	$0.06	$0.07
80024-1	2021	3396	1949	$169.99	$0.09	$0.05	$0.07
10217-1	2011	2330	2025	$149.99	$0.07	$0.06	$0.07
10257-1	2017	3142	2670	$199.99	$0.07	$0.06	$0.07
10312-1	2023	3870	2899	$229.99	$0.08	$0.06	$0.07
10255-1	2017	4666	4002	$299.99	$0.07	$0.06	$0.07
71043-1	2018	7520	6020	$469.99	$0.08	$0.06	$0.07
10297-1	2022	3473	3066	$229.99	$0.08	$0.07	$0.07
10279-1	2021	2959	2207	$179.99	$0.08	$0.06	$0.07
10264-1	2019	3035	2569	$199.99	$0.08	$0.07	$0.07
10179-1	2007	10215	5197	$499.99	$0.10	$0.05	$0.07
10247-1	2015	3125	2464	$199.99	$0.08	$0.06	$0.07
21311-1	2018	2645	2321	$179.99	$0.08	$0.07	$0.07
10283-1	2021	3249	2354	$199.99	$0.08	$0.06	$0.07
21318-1	2019	3870	3036	$249.99	$0.08	$0.06	$0.07
71040-1	2016	5700	4080	$349.99	$0.09	$0.06	$0.07
75810-1	2019	3323	2287	$199.99	$0.09	$0.06	$0.07
10270-1	2020	2932	2504	$199.99	$0.08	$0.07	$0.07
BL19001-1	2019	4034	2015	$199.99	$0.10	$0.05	$0.07
75978-1	2020	6640	5544	$449.99	$0.08	$0.07	$0.07
10237-1	2013	3092	2359	$199.99	$0.08	$0.06	$0.07
71016-1	2015	3463	2179	$199.99	$0.09	$0.06	$0.07
70912-1	2017	2609	1628	$149.99	$0.09	$0.06	$0.07
10228-1	2012	2880	2064	$179.99	$0.09	$0.06	$0.07
70840-1	2019	5329	3178	$299.99	$0.09	$0.06	$0.08
10292-1	2021	2812	2048	$179.99	$0.09	$0.06	$0.08
10241-1	2014	2801	1518	$149.99	$0.10	$0.05	$0.08
910023-1	2022	4185	3470	$289.99	$0.08	$0.07	$0.08
8110-1	2011	3610	2048	$199.99	$0.10	$0.06	$0.08
76193-1	2021	2316	1901	$159.99	$0.08	$0.07	$0.08
10316-1	2023	6890	6167	$499.99	$0.08	$0.07	$0.08
10225-1	2012	2590	2127	$179.99	$0.08	$0.07	$0.08
42054-1	2016	2853	1977	$179.99	$0.09	$0.06	$0.08
10196-1	2009	3220	3263	$249.99	$0.08	$0.08	$0.08
10305-1	2022	6062	4514	$399.99	$0.09	$0.07	$0.08
10244-1	2014	2180	1746	$149.99	$0.09	$0.07	$0.08
10188-1	2008	8060	3803	$399.99	$0.11	$0.05	$0.08
41704-1	2022	2647	1682	$159.99	$0.10	$0.06	$0.08

Vindic8ed

42083-1	2018	5900	3599	$349.99	$0.10	$0.06	$0.08
70810-1	2014	3818	2741	$249.99	$0.09	$0.07	$0.08
910009-1	2022	2440	2149	$179.99	$0.08	$0.07	$0.08
10261-1	2018	5800	4124	$379.99	$0.09	$0.07	$0.08
21325-1	2021	2415	2164	$179.99	$0.08	$0.07	$0.08
10019-1	2001	4565	1747	$200.00	$0.11	$0.04	$0.08
71042-1	2017	2800	2294	$199.99	$0.09	$0.07	$0.08
75059-1	2014	4437	3296	$299.99	$0.09	$0.07	$0.08
21338-1	2023	2480	2082	$179.99	$0.09	$0.07	$0.08
8275-1	2007	2885	1384	$149.99	$0.11	$0.05	$0.08
60380-1	2023	3280	2010	$199.99	$0.10	$0.06	$0.08
71797-1	2023	2300	1739	$159.99	$0.09	$0.07	$0.08
76178-1	2021	5042	3772	$349.99	$0.09	$0.07	$0.08
77015-1	2023	2285	1545	$149.99	$0.10	$0.07	$0.08
10306-1	2022	3510	2532	$239.99	$0.09	$0.07	$0.08
10937-1	2013	2485	1619	$159.99	$0.10	$0.06	$0.08
10273-1	2020	4261	3231	$299.99	$0.09	$0.07	$0.08
75060-1	2015	3166	1996	$199.99	$0.10	$0.06	$0.08
10234-1	2013	5670	2989	$319.99	$0.11	$0.06	$0.08
910008-1	2023	4643	3371	$319.99	$0.09	$0.07	$0.08
80012-1	2020	2075	1629	$149.99	$0.09	$0.07	$0.08
910004-1	2023	2200	2705	$199.99	$0.07	$0.09	$0.08
76023-1	2014	3443	1869	$199.99	$0.11	$0.06	$0.08
76218-1	2022	3404	2708	$249.99	$0.09	$0.07	$0.08
71411-1	2022	3874	2807	$269.99	$0.10	$0.07	$0.08
70751-1	2015	2952	2028	$199.99	$0.10	$0.07	$0.08
76405-1	2022	7200	5129	$499.99	$0.10	$0.07	$0.08
71374-1	2020	4160	2646	$269.99	$0.10	$0.06	$0.08
910002-1	2023	5820	4062	$399.99	$0.10	$0.07	$0.08
10212-1	2010	3985	2503	$259.99	$0.10	$0.07	$0.08
71395-1	2021	2740	2064	$199.99	$0.10	$0.07	$0.08
910013-1	2022	2620	2779	$229.99	$0.08	$0.09	$0.09
75331-1	2022	8150	6187	$599.99	$0.10	$0.07	$0.09
42056-1	2016	5020	2704	$299.99	$0.11	$0.06	$0.09
BL19004-1	2019	2108	1496	$149.99	$0.10	$0.07	$0.09
76391-1	2021	4180	3010	$299.99	$0.10	$0.07	$0.09
80023-1	2021	2150	1462	$149.99	$0.10	$0.07	$0.09
8458-1	2000	3160	1431	$170.00	$0.12	$0.05	$0.09
80045-1	2023	2030	1705	$159.99	$0.09	$0.08	$0.09
BL19002-1	2019	2700	1278	$149.99	$0.12	$0.06	$0.09
60097-1	2015	3150	1683	$189.99	$0.11	$0.06	$0.09
43179-1	2020	2573	1739	$179.99	$0.10	$0.07	$0.09
42042-1	2015	2238	1401	$149.99	$0.11	$0.07	$0.09
42114-1	2020	4145	2193	$249.99	$0.11	$0.06	$0.09
10303-1	2022	5870	3756	$399.99	$0.11	$0.07	$0.09
10198-1	2009	2176	1408	$149.99	$0.11	$0.07	$0.09
21332-1	2022	2645	2585	$229.99	$0.09	$0.09	$0.09
76052-1	2016	3889	2526	$269.99	$0.11	$0.07	$0.09
21010-1	2011	2248	2276	$199.99	$0.09	$0.09	$0.09
75192-1	2017	13150	7541	$849.99	$0.11	$0.06	$0.09

Vindic8ed

10210-1	2010	2590	1664	$179.99	$0.11	$0.07	$0.09
60125-1	2016	2490	1277	$149.99	$0.12	$0.06	$0.09
10274-1	2020	3145	2352	$239.99	$0.10	$0.08	$0.09
21323-1	2020	5780	3662	$399.99	$0.11	$0.07	$0.09
42100-1	2019	6451	4108	$449.99	$0.11	$0.07	$0.09
75190-1	2017	2400	1416	$159.99	$0.11	$0.07	$0.09
75105-1	2015	2244	1329	$149.99	$0.11	$0.07	$0.09
7191-1	2000	2296	1300	$150.00	$0.12	$0.07	$0.09
76215-1	2022	5550	2961	$349.99	$0.12	$0.06	$0.09
8480-1	1996	2400	1368	$158.00	$0.12	$0.07	$0.09
75181-1	2018	2478	1967	$199.99	$0.10	$0.08	$0.09
76042-1	2015	5300	2996	$349.99	$0.12	$0.07	$0.09
42145-1	2022	2689	2001	$209.99	$0.10	$0.08	$0.09
42143-1	2022	6990	3778	$449.99	$0.12	$0.06	$0.09
10221-1	2011	6965	3152	$399.99	$0.13	$0.06	$0.09
910001-1	2021	1944	1957	$179.99	$0.09	$0.09	$0.09
8479-1	1997	2900	1280	$164.00	$0.13	$0.06	$0.09
42156-1	2023	2750	1775	$199.99	$0.11	$0.07	$0.09
21337-1	2022	3160	2339	$249.99	$0.11	$0.08	$0.09
75159-1	2016	8101	4016	$499.99	$0.12	$0.06	$0.09
60200-1	2018	2405	1211	$149.99	$0.12	$0.06	$0.09
60162-1	2017	2252	1250	$149.99	$0.12	$0.07	$0.09
10317-1	2023	2850	2336	$239.99	$0.10	$0.08	$0.09
910003-1	2022	1750	2085	$179.99	$0.09	$0.10	$0.09
75315-1	2021	2304	1336	$159.99	$0.12	$0.07	$0.09
75095-1	2015	2804	1685	$199.99	$0.12	$0.07	$0.10
21050-1	2013	2747	1210	$159.99	$0.13	$0.06	$0.10
75189-1	2017	1840	1376	$149.99	$0.11	$0.08	$0.10
71044-1	2019	4243	2925	$329.99	$0.11	$0.08	$0.10
75308-1	2021	2743	2314	$239.99	$0.10	$0.09	$0.10
75212-1	2018	2361	1414	$169.99	$0.12	$0.07	$0.10
75244-1	2019	2520	1768	$199.99	$0.11	$0.08	$0.10
75098-1	2016	3290	2144	$249.99	$0.12	$0.08	$0.10
75309-1	2021	5620	3292	$399.99	$0.12	$0.07	$0.10
21128-1	2016	2949	1600	$199.99	$0.12	$0.07	$0.10
42096-1	2019	2270	1580	$179.99	$0.11	$0.08	$0.10
41999-1	2013	2943	1585	$199.99	$0.13	$0.07	$0.10
42115-1	2020	6090	3696	$449.99	$0.12	$0.07	$0.10
75144-1	2017	2530	1703	$199.99	$0.12	$0.08	$0.10
60271-1	2020	3040	1517	$199.99	$0.13	$0.07	$0.10
75222-1	2018	4690	2812	$349.99	$0.12	$0.07	$0.10
75257-1	2019	2300	1351	$169.99	$0.13	$0.07	$0.10
10300-1	2022	2142	1872	$199.99	$0.11	$0.09	$0.10
75252-1	2019	12480	4784	$699.99	$0.15	$0.06	$0.10
10295-1	2021	1979	1458	$169.99	$0.12	$0.09	$0.10
42125-1	2021	2360	1677	$199.99	$0.12	$0.08	$0.10
76240-1	2021	3706	2049	$269.99	$0.13	$0.07	$0.10
75313-1	2021	10708	6785	$849.99	$0.13	$0.08	$0.10
75275-1	2020	2346	1673	$199.99	$0.12	$0.09	$0.10
10227-1	2012	2796	1487	$199.99	$0.13	$0.07	$0.10

Vindic8ed

60229-1	2019	2348	1055	$149.99	$0.14	$0.06	$0.10
10236-1	2013	3031	1990	$249.99	$0.13	$0.08	$0.10
43197-1	2021	2768	1709	$219.99	$0.13	$0.08	$0.10
76389-1	2021	1859	1176	$149.99	$0.13	$0.08	$0.10
75355-1	2023	2810	1949	$239.99	$0.12	$0.09	$0.10
10265-1	2019	1820	1471	$169.99	$0.12	$0.09	$0.10
10304-1	2022	1830	1456	$169.99	$0.12	$0.09	$0.10
75574-1	2022	1714	1212	$149.99	$0.12	$0.09	$0.11
21327-1	2021	2714	2079	$249.99	$0.12	$0.09	$0.11
42131-1	2021	6030	3854	$499.99	$0.13	$0.08	$0.11
10262-1	2018	1514	1290	$149.99	$0.12	$0.10	$0.11
10195-1	2009	3400	1758	$249.99	$0.14	$0.07	$0.11
10240-1	2013	2270	1559	$199.99	$0.13	$0.09	$0.11
42157-1	2023	2420	1492	$199.99	$0.13	$0.08	$0.11
42066-1	2017	2009	1151	$159.99	$0.14	$0.08	$0.11
7898-1	2006	3400	856	$149.99	$0.18	$0.04	$0.11
75290-1	2020	4260	3187	$399.99	$0.13	$0.09	$0.11
42130-1	2022	2781	1920	$249.99	$0.13	$0.09	$0.11
9398-1	2012	2810	1327	$199.99	$0.15	$0.07	$0.11
42030-1	2014	3590	1636	$249.99	$0.15	$0.07	$0.11
75288-1	2020	1857	1267	$169.99	$0.13	$0.09	$0.11
75341-1	2022	2400	1890	$239.99	$0.13	$0.10	$0.11
10302-1	2022	1670	1508	$179.99	$0.12	$0.11	$0.11
42141-1	2022	2268	1432	$199.99	$0.14	$0.09	$0.11
42070-1	2017	4001	1862	$289.99	$0.16	$0.07	$0.11
60351-1	2022	2111	1010	$159.99	$0.16	$0.08	$0.12
76210-1	2022	5580	4049	$549.99	$0.14	$0.10	$0.12
21335-1	2022	3335	2065	$299.99	$0.15	$0.09	$0.12
42080-1	2018	1682	1003	$149.99	$0.15	$0.09	$0.12
4558-1	1991	2800	784	$149.00	$0.19	$0.05	$0.12
60336-1	2022	2735	1153	$199.99	$0.17	$0.07	$0.12
75323-1	2022	2069	1022	$169.99	$0.17	$0.08	$0.12
3677-1	2011	2605	831	$159.99	$0.19	$0.06	$0.13
8043-1	2010	2580	1123	$199.99	$0.18	$0.08	$0.13
42129-1	2021	3300	2110	$329.99	$0.16	$0.10	$0.13
71774-1	2022	1370	989	$149.99	$0.15	$0.11	$0.13
6990-1	1987	2950	731	$155.00	$0.21	$0.05	$0.13
60266-1	2020	2268	745	$149.99	$0.20	$0.07	$0.13
8485-1	1995	3210	1079	$219.00	$0.20	$0.07	$0.14
60198-1	2018	2720	1226	$229.99	$0.19	$0.08	$0.14
10001-1	2001	1825	782	$149.00	$0.19	$0.08	$0.14
4535-1	2002	3289	762	$170.00	$0.22	$0.05	$0.14
60098-1	2015	2740	984	$199.99	$0.20	$0.07	$0.14
7939-1	2010	2817	839	$179.99	$0.21	$0.06	$0.14
42144-1	2022	1400	835	$149.99	$0.18	$0.11	$0.14
75253-1	2019	1669	1177	$199.99	$0.17	$0.12	$0.14
60052-1	2014	2904	888	$199.99	$0.23	$0.07	$0.15
17101-1	2017	1381	843	$159.99	$0.19	$0.12	$0.15
60197-1	2018	2065	677	$159.99	$0.24	$0.08	$0.16
60051-1	2014	2200	610	$149.99	$0.25	$0.07	$0.16

Vindic8ed

42140-1	2022	1205	772	$149.99	$0.19	$0.12	$0.16
60337-1	2022	2199	764	$189.99	$0.25	$0.09	$0.17
10268-1	2018	2140	826	$199.99	$0.24	$0.09	$0.17
9747-1	1999	2985	717	$200.00	$0.28	$0.07	$0.17
3804-1	2001	2677	717	$200.00	$0.28	$0.07	$0.18
6991-1	1994	3790	573	$178.00	$0.31	$0.05	$0.18
60339-1	2022	1470	598	$159.99	$0.27	$0.11	$0.19
42099-1	2019	2156	958	$249.99	$0.26	$0.12	$0.19
4534-1	2002	2722	456	$160.00	$0.35	$0.06	$0.20
9719-1	1998	1072	733	$200.00	$0.27	$0.19	$0.23
9735-1	1999	1956	390	$150.00	$0.38	$0.08	$0.23
1349-1	2000	2495	442	$180.00	$0.41	$0.07	$0.24
8527-1	2006	2186	577	$249.99	$0.43	$0.11	$0.27
51515-1	2020	2063	949	$359.99	$0.38	$0.17	$0.28
8547-1	2009	2157	619	$279.99	$0.45	$0.13	$0.29
31313-1	2013	1784	601	$349.99	$0.58	$0.20	$0.39

Vindic8ed

I removed sets that didn't have weights (such as the new Bat Cave) and other sets that had really high PPP (such as the educational sets) or the "sets" that were not actually toys (furniture, watches, clothes, etc.)

Also, I used the entire weight (box, instructions, bags, etc.) because I feel that that more accurately describes what we are paying for as a consumer (all of LEGO's costs get passed onto us).

560Heliport

If the instruction book is twice as big as it needs to be, you aren't really getting more value; you're just paying for more paper. IMHO.

iwybs

When I calculate PPW, I exclude the weight of the box and the instructions. It's the PPW for the actual parts that interests me.

Vindic8ed

560Heliport said:

If the instruction book is twice as big as it needs to be, you aren't really getting more value; you're just paying for more paper. IMHO.

iwybs said:

When I calculate PPW, I exclude the weight of the box and the instructions. It's the PPW for the actual parts that interests me.

I agree, but it's still a cost that is passed down to us, so ignoring that data point doesn't give an accurate account of what goes into pricing a set.

Vindic8ed

There are quite a few newer sets (which arguable have the bigger instruction books you mentioned) that have a better PPW (box, instructions, bags, etc.) than the older sets.  Just look at the first 10 entries in the table I posted:

31203-1	2021	5482	11695	$249.99	$0.02	$0.05	$0.03
10189-1	2008	6402	5922	$299.99	$0.05	$0.05	$0.05
3450-1	2000	6500	2882	$199.00	$0.07	$0.03	$0.05
10181-1	2007	4500	3428	$199.99	$0.06	$0.04	$0.05
70620-1	2017	6200	4867	$299.99	$0.06	$0.05	$0.06
10185-1	2008	3180	2352	$149.99	$0.06	$0.05	$0.06
10214-1	2010	4335	4287	$239.99	$0.06	$0.06	$0.06
10276-1	2020	10780	9036	$549.99	$0.06	$0.05	$0.06
10284-1	2021	6820	5509	$349.99	$0.06	$0.05	$0.06
70657-1	2018	4470	3553	$229.99	$0.06	$0.05	$0.06

5 of these 10 of these sets were made in the last 6 years.