| Discussion Forum: Thread 315822 |
|
 |
| | | Author: | Ziegelmeister  | | Posted: | Jan 15, 2022 17:27 | | Subject: | Cost calculations (for part outs) | | Viewed: | 131 times | | Topic: | Selling | |
|
| When I originally uploaded the first batch of ~100,000 pieces I didn't care
much about inputting my costs because I knew what I spent and that was my target
break even point.
... I always forget about taxes. 
So moving forward I want to enter those fields in BS and as far as I can tell
there are at least two ways to do this:
1: Divide the amount spent by the total number of parts. This is imprecise though
because a 1x1 plate shouldn't have the same cost as, say, a minifigure.
It can get a price in but it means I'll pay higher taxes on minifig sales.
2: Normalize the prices by working from the part out values. Here I would do
the mass pricing for the set in BrickStore, then calculate that piece's percentage
in to that total price, then multiply that percentage by the original purchase
price.
EXAMPLES
1: Set price plus tax, $107
Total pieces 994
107 ÷ 994 = $0.107
So a $9.00 minifig from this set would have ~$8.89 of taxable profit. (Booooo
Mr. Taxman)
----
2: The same parted out set is priced at $331.60.
$9.00 Minifigure accounts for 2.7% of the part out price.
$107 x 2.7% = $2.89
This drops the taxable income to $6.11. (Still; Boooo Mr. Taxman)
----
Personally I prefer method #2, but it's cumbersome, requires excel, and apparently
BS doesn't like to open XML files I save.
Is there a work around for this or just do it manually?
And/Or is there another method I'm overlooking?
|
|
|
| | | | | |
| | | | | Author: | Ziegelmeister | | Posted: | Jan 15, 2022 17:58 | | Subject: | Re: Cost calculations (for part outs) | | Viewed: | 48 times | | Topic: | Selling | |
|
| Oh oops... Clarification; for pieces that have more than 1 in the set, you need
to use number in the "total" column, not the "price" column.
|
|
| | | | | |
| | | | | Author: | kzinti | | Posted: | Jan 15, 2022 19:09 | | Subject: | Re: Cost calculations (for part outs) | | Viewed: | 110 times | | Topic: | Selling | |
|
| In Selling, Yellow.Brick writes:
| | When I originally uploaded the first batch of ~100,000 pieces I didn't care
much about inputting my costs because I knew what I spent and that was my target
break even point.
... I always forget about taxes.
So moving forward I want to enter those fields in BS and as far as I can tell
there are at least two ways to do this:
1: Divide the amount spent by the total number of parts. This is imprecise though
because a 1x1 plate shouldn't have the same cost as, say, a minifigure.
It can get a price in but it means I'll pay higher taxes on minifig sales.
2: Normalize the prices by working from the part out values. Here I would do
the mass pricing for the set in BrickStore, then calculate that piece's percentage
in to that total price, then multiply that percentage by the original purchase
price.
EXAMPLES
1: Set price plus tax, $107
Total pieces 994
107 ÷ 994 = $0.107
So a $9.00 minifig from this set would have ~$8.89 of taxable profit. (Booooo
Mr. Taxman)
----
2: The same parted out set is priced at $331.60.
$9.00 Minifigure accounts for 2.7% of the part out price.
$107 x 2.7% = $2.89
This drops the taxable income to $6.11. (Still; Boooo Mr. Taxman)
----
Personally I prefer method #2, but it's cumbersome, requires excel, and apparently
BS doesn't like to open XML files I save.
Is there a work around for this or just do it manually?
And/Or is there another method I'm overlooking?
|
I take cost of the set as the basis, part out set into Brickstore, then take
total cost of current market value, divide that by cost of set, and that gives
you the percentage to multiply Brickstore prices by to get their weighted actual
cost by current market value.
Example: If a set costs $100, parted out into Brickstore shows all parts at 6
mos avg total value of $180, divide $100 cost by $180 value, and you get .556,
or 55.6%. Bulk multiply all parts values in Brickstore by a decrease of 55.6%,
and you'll have your actual weighted cost by current market value.
|
|
|
|
|
|
|
USA, Ohio
