|
 |
| | | Author: | ToriHada  | | Posted: | Feb 12, 2014 10:05 | | Subject: | Automate Costs When Parting Out | | Viewed: | 264 times | | Topic: | Suggestions | | Status: | Open | | Vote: | [Yes|No] | |
|
| BrickLink does not have a convenient way to enter costs when parting out a set.
The cost needs to be entered manually for each item.
For BL2.0 please provide a feature whereby costs are automatically entered by
BrickLink when the part-out page is first submitted for approval. Let's say
you want to part out ten (10) of set number 75022
The way this would work is as follows:
1. On this page, where parting out begins:
http://www.bricklink.com/invSet.asp?itemType=S&itemNo=75022-1
add a box for the seller to input his total cost for all sets being parted out.
2. Part out like you normally would withOUT entering any costs and then click
"Verify Items" at the bottom of the page.
3. This will pull up the next page:
http://www.bricklink.com/invSetVerify.asp
where everything is listed for the seller to review and approve before uploading.
For this example, using Price Guide averages, the TOTAL part-out value shown
by BrickLink is $426.89. BrickLink can automatically divide the seller's
total cost ($260.00) by this total part-out value ($426.89) to automatically
determine that the cost per item is 0.609 times the listed price for each item.
Thus, for example, for minifigure sw493 BrickLink would automatically enter the
cost as $5.65 or 0.609 times the listed price of $9.58.
Currently, the seller cannot change anything on this page. So an added tweak
would be to make items (or at least the costs) editable on this page should the
seller wish to change them.
Hit "Upload Items" and, voila, your costs are automatically entered.
Thor
|
|
|
| | | | | |
| | | | | Author: | Rob_and_Shelagh | | Posted: | Feb 12, 2014 10:17 | | Subject: | Re: Automate Costs When Parting Out | | Viewed: | 67 times | | Topic: | Suggestions | |
|
| In Suggestions, fosterbengoshi writes:
| | BrickLink does not have a convenient way to enter costs when parting out a set.
The cost needs to be entered manually for each item.
For BL2.0 please provide a feature whereby costs are automatically entered by
BrickLink when the part-out page is first submitted for approval. Let's say
you want to part out ten (10) of set number 75022
The way this would work is as follows:
1. On this page, where parting out begins:
http://www.bricklink.com/invSet.asp?itemType=S&itemNo=75022-1
add a box for the seller to input his total cost for all sets being parted out.
2. Part out like you normally would withOUT entering any costs and then click
"Verify Items" at the bottom of the page.
3. This will pull up the next page:
http://www.bricklink.com/invSetVerify.asp
where everything is listed for the seller to review and approve before uploading.
For this example, using Price Guide averages, the TOTAL part-out value shown
by BrickLink is $426.89. BrickLink can automatically divide the seller's
total cost ($260.00) by this total part-out value ($426.89) to automatically
determine that the cost per item is 0.609 times the listed price for each item.
Thus, for example, for minifigure sw493 BrickLink would automatically enter the
cost as $5.65 or 0.609 times the listed price of $9.58.
Currently, the seller cannot change anything on this page. So an added tweak
would be to make items (or at least the costs) editable on this page should the
seller wish to change them.
Hit "Upload Items" and, voila, your costs are automatically entered.
Thor
|
How would this handle existing lots with costs already attached? i.e. you already
have some of the parts from this set in your store with costs calculated from
another set...and you don't want to create a new lot for the same part. Not
that I use part out for adding to inventory but just curious how this would work.
Robert
|
|
|
| | | | | | | | | |
| | | | | | | Author: | FigBits | | Posted: | Feb 12, 2014 15:03 | | Subject: | Re: Automate Costs When Parting Out | | Viewed: | 40 times | | Topic: | Suggestions | |
|
| In Suggestions, Rob_and_Shelagh writes:
| |
How would this handle existing lots with costs already attached? i.e. you already
have some of the parts from this set in your store with costs calculated from
another set...and you don't want to create a new lot for the same part. Not
that I use part out for adding to inventory but just curious how this would work.
Robert
|
Same as it does now -- it calculates a weighed average between the existing
inventory and the new upload.
--
Marc.
|
|
| | | | | |
| | | | | Author: | ToriHada | | Posted: | Feb 12, 2014 10:20 | | Subject: | Re: Automate Costs When Parting Out | | Viewed: | 72 times | | Topic: | Suggestions | |
|
| In Suggestions, fosterbengoshi writes:
| | BrickLink does not have a convenient way to enter costs when parting out a set.
The cost needs to be entered manually for each item.
For BL2.0 please provide a feature whereby costs are automatically entered by
BrickLink when the part-out page is first submitted for approval. Let's say
you want to part out ten (10) of set number 75022
The way this would work is as follows:
1. On this page, where parting out begins:
http://www.bricklink.com/invSet.asp?itemType=S&itemNo=75022-1
add a box for the seller to input his total cost for all sets being parted out.
2. Part out like you normally would withOUT entering any costs and then click
"Verify Items" at the bottom of the page.
3. This will pull up the next page:
http://www.bricklink.com/invSetVerify.asp
where everything is listed for the seller to review and approve before uploading.
For this example, using Price Guide averages, the TOTAL part-out value shown
by BrickLink is $426.89. BrickLink can automatically divide the seller's
total cost ($260.00) by this total part-out value ($426.89) to automatically
determine that the cost per item is 0.609 times the listed price for each item.
Thus, for example, for minifigure sw493 BrickLink would automatically enter the
cost as $5.65 or 0.609 times the listed price of $9.58.
Currently, the seller cannot change anything on this page. So an added tweak
would be to make items (or at least the costs) editable on this page should the
seller wish to change them.
Hit "Upload Items" and, voila, your costs are automatically entered.
Thor
|
One additional tweak for those who consolidate lots. Using my example above,
let's say that prior to this part out you already have 10 sw493 minifigures
listed in your shop for $9.00 each and a cost of $6.00 each. Right now, the seller
can choose to consolidate prices by averaging them or picking the price for the
current or new lot to apply to all 20 figures. Under this suggestion, costs can
also be consolidated and automatically calculated by BrickLink as follows:
1. Calculate the total cost for the current listing (10 x 6.00 = 60.00)
2. Calculate the total cost for the new listing (10 x 5.65 = 56.50)
3. Add 1 and 2 and divide by the total number of items in the listing (116.50
divided by 20 figures equals a cost of $5.825 per figure). Although this slightly
reduces the total cost amount for the part out, that reduction is added to your
previous costs to make your total inventory cost balance out.
Thor
|
|
|
| | | | | | | | | |
| | | | | | | Author: | dmoser22 | | Posted: | Feb 12, 2014 11:07 | | Subject: | Re: Automate Costs When Parting Out | | Viewed: | 56 times | | Topic: | Suggestions | |
|
| In Suggestions, fosterbengoshi writes:
| | In Suggestions, fosterbengoshi writes:
| | BrickLink does not have a convenient way to enter costs when parting out a set.
The cost needs to be entered manually for each item.
For BL2.0 please provide a feature whereby costs are automatically entered by
BrickLink when the part-out page is first submitted for approval. Let's say
you want to part out ten (10) of set number 75022
The way this would work is as follows:
1. On this page, where parting out begins:
http://www.bricklink.com/invSet.asp?itemType=S&itemNo=75022-1
add a box for the seller to input his total cost for all sets being parted out.
2. Part out like you normally would withOUT entering any costs and then click
"Verify Items" at the bottom of the page.
3. This will pull up the next page:
http://www.bricklink.com/invSetVerify.asp
where everything is listed for the seller to review and approve before uploading.
For this example, using Price Guide averages, the TOTAL part-out value shown
by BrickLink is $426.89. BrickLink can automatically divide the seller's
total cost ($260.00) by this total part-out value ($426.89) to automatically
determine that the cost per item is 0.609 times the listed price for each item.
Thus, for example, for minifigure sw493 BrickLink would automatically enter the
cost as $5.65 or 0.609 times the listed price of $9.58.
Currently, the seller cannot change anything on this page. So an added tweak
would be to make items (or at least the costs) editable on this page should the
seller wish to change them.
Hit "Upload Items" and, voila, your costs are automatically entered.
Thor
|
One additional tweak for those who consolidate lots. Using my example above,
let's say that prior to this part out you already have 10 sw493 minifigures
listed in your shop for $9.00 each and a cost of $6.00 each. Right now, the seller
can choose to consolidate prices by averaging them or picking the price for the
current or new lot to apply to all 20 figures. Under this suggestion, costs can
also be consolidated and automatically calculated by BrickLink as follows:
1. Calculate the total cost for the current listing (10 x 6.00 = 60.00)
2. Calculate the total cost for the new listing (10 x 5.65 = 56.50)
3. Add 1 and 2 and divide by the total number of items in the listing (116.50
divided by 20 figures equals a cost of $5.825 per figure). Although this slightly
reduces the total cost amount for the part out, that reduction is added to your
previous costs to make your total inventory cost balance out.
Thor
|
Yes, Yes, Yes!
|
|
|
| | | | | | | | | |
| | | | | | | Author: | Rob_and_Shelagh | | Posted: | Feb 12, 2014 11:45 | | Subject: | Re: Automate Costs When Parting Out | | Viewed: | 66 times | | Topic: | Suggestions | |
|
| In Suggestions, fosterbengoshi writes:
| | In Suggestions, fosterbengoshi writes:
| | BrickLink does not have a convenient way to enter costs when parting out a set.
The cost needs to be entered manually for each item.
For BL2.0 please provide a feature whereby costs are automatically entered by
BrickLink when the part-out page is first submitted for approval. Let's say
you want to part out ten (10) of set number 75022
The way this would work is as follows:
1. On this page, where parting out begins:
http://www.bricklink.com/invSet.asp?itemType=S&itemNo=75022-1
add a box for the seller to input his total cost for all sets being parted out.
2. Part out like you normally would withOUT entering any costs and then click
"Verify Items" at the bottom of the page.
3. This will pull up the next page:
http://www.bricklink.com/invSetVerify.asp
where everything is listed for the seller to review and approve before uploading.
For this example, using Price Guide averages, the TOTAL part-out value shown
by BrickLink is $426.89. BrickLink can automatically divide the seller's
total cost ($260.00) by this total part-out value ($426.89) to automatically
determine that the cost per item is 0.609 times the listed price for each item.
Thus, for example, for minifigure sw493 BrickLink would automatically enter the
cost as $5.65 or 0.609 times the listed price of $9.58.
Currently, the seller cannot change anything on this page. So an added tweak
would be to make items (or at least the costs) editable on this page should the
seller wish to change them.
Hit "Upload Items" and, voila, your costs are automatically entered.
Thor
|
One additional tweak for those who consolidate lots. Using my example above,
let's say that prior to this part out you already have 10 sw493 minifigures
listed in your shop for $9.00 each and a cost of $6.00 each. Right now, the seller
can choose to consolidate prices by averaging them or picking the price for the
current or new lot to apply to all 20 figures. Under this suggestion, costs can
also be consolidated and automatically calculated by BrickLink as follows:
1. Calculate the total cost for the current listing (10 x 6.00 = 60.00)
2. Calculate the total cost for the new listing (10 x 5.65 = 56.50)
3. Add 1 and 2 and divide by the total number of items in the listing (116.50
divided by 20 figures equals a cost of $5.825 per figure). Although this slightly
reduces the total cost amount for the part out, that reduction is added to your
previous costs to make your total inventory cost balance out.
Thor
|
That answers my question, thanks! Not something I would use with our current
business model but I can certainly see the benefit for those that want/need to
track allocated purchase cost by part.
Robert
|
|
|
| | | | | | | | | |
| | | | | | | Author: | jeslego | | Posted: | Feb 12, 2014 12:46 | | Subject: | Re: Automate Costs When Parting Out | | Viewed: | 48 times | | Topic: | Suggestions | |
|
| In Suggestions, fosterbengoshi writes:
| | In Suggestions, fosterbengoshi writes:
| | BrickLink does not have a convenient way to enter costs when parting out a set.
The cost needs to be entered manually for each item.
For BL2.0 please provide a feature whereby costs are automatically entered by
BrickLink when the part-out page is first submitted for approval. Let's say
you want to part out ten (10) of set number 75022
The way this would work is as follows:
1. On this page, where parting out begins:
http://www.bricklink.com/invSet.asp?itemType=S&itemNo=75022-1
add a box for the seller to input his total cost for all sets being parted out.
2. Part out like you normally would withOUT entering any costs and then click
"Verify Items" at the bottom of the page.
3. This will pull up the next page:
http://www.bricklink.com/invSetVerify.asp
where everything is listed for the seller to review and approve before uploading.
For this example, using Price Guide averages, the TOTAL part-out value shown
by BrickLink is $426.89. BrickLink can automatically divide the seller's
total cost ($260.00) by this total part-out value ($426.89) to automatically
determine that the cost per item is 0.609 times the listed price for each item.
Thus, for example, for minifigure sw493 BrickLink would automatically enter the
cost as $5.65 or 0.609 times the listed price of $9.58.
Currently, the seller cannot change anything on this page. So an added tweak
would be to make items (or at least the costs) editable on this page should the
seller wish to change them.
Hit "Upload Items" and, voila, your costs are automatically entered.
Thor
|
One additional tweak for those who consolidate lots. Using my example above,
let's say that prior to this part out you already have 10 sw493 minifigures
listed in your shop for $9.00 each and a cost of $6.00 each. Right now, the seller
can choose to consolidate prices by averaging them or picking the price for the
current or new lot to apply to all 20 figures. Under this suggestion, costs can
also be consolidated and automatically calculated by BrickLink as follows:
1. Calculate the total cost for the current listing (10 x 6.00 = 60.00)
2. Calculate the total cost for the new listing (10 x 5.65 = 56.50)
3. Add 1 and 2 and divide by the total number of items in the listing (116.50
divided by 20 figures equals a cost of $5.825 per figure). Although this slightly
reduces the total cost amount for the part out, that reduction is added to your
previous costs to make your total inventory cost balance out.
Thor
|
1) Great suggestion.
One of BL 2.0's challenges will be to enable processes that are specific
to so many different laws and cultures.
It has been 30 years since I had to crack an accounting text. None of my other
businesses have inventory, and Make Up Sets has very little. But, for what it
is worth, this is what I know.
Inventory items have both market value and a tax basis. Market value reflects
what they could be sold for in a reasonable amount of time under the current
market conditions. It is, therefore somewhat subjective.
In the US the tax basis is a cost that can be deducted from the revenue generated
when an item is sold.
When a business buys and sells commodity, it often has items purchased at different
prices in inventory. And, since the items are commodities, it is likely that
the actual item sold is not known with certainty.
Governments provide rules to businesses regarding how they may match items sold
with a tax basis. Two of the most common are First In First Out (FIFO) and Last
In First Out (FIFO). Both work the way their names suggest. If I buy two
items and sell one, the cost of the first is used as the tax basis under FIFO
and the second is used for LIFO.
I am not aware of any system that uses averages, but that does not mean that
none exist. Any such system would be subject to stress as items were sold in
multiple tax years while inventory was being added.
It would appear then, that the tax basis should be an attribute of each part
in inventory and that sellers need to be allowed to specify their inventory method.
It would be nice to know that the new data model accommodates these wrinkles,
though I would be pleasantly surprised if it did.
|
|
|
| | | | | | | | | |
| | | | | | | Author: | FigBits | | Posted: | Feb 12, 2014 15:05 | | Subject: | Re: Automate Costs When Parting Out | | Viewed: | 44 times | | Topic: | Suggestions | |
|
| In Suggestions, fosterbengoshi writes:
| | One additional tweak for those who consolidate lots. Using my example above,
let's say that prior to this part out you already have 10 sw493 minifigures
listed in your shop for $9.00 each and a cost of $6.00 each. Right now, the seller
can choose to consolidate prices by averaging them or picking the price for the
current or new lot to apply to all 20 figures. Under this suggestion, costs can
also be consolidated and automatically calculated by BrickLink as follows:
|
I agree with the suggestion. This part, though, already exists.
--
Marc.
|
|
| | | | | |
| | | | | Author: | jhkc... | | Posted: | Feb 12, 2014 10:27 | | Subject: | (Cancelled) | | Viewed: | 52 times | | Topic: | Suggestions | |
|
| | (Cancelled) |
|
| | | | | |
| | | | | Author: | par016 | | Posted: | Feb 12, 2014 10:30 | | Subject: | Re: Automate Costs When Parting Out | | Viewed: | 44 times | | Topic: | Suggestions | |
|
| I was actually wishing BrickLink had this exact feature last night when parting
out a buunch of sets. It would be really useful. I made something that works
for excel and does this, but it really isn't great. One incorporated into
BrickLink would be way better.
-Pete
In Suggestions, fosterbengoshi writes:
| | BrickLink does not have a convenient way to enter costs when parting out a set.
The cost needs to be entered manually for each item.
For BL2.0 please provide a feature whereby costs are automatically entered by
BrickLink when the part-out page is first submitted for approval. Let's say
you want to part out ten (10) of set number 75022
The way this would work is as follows:
1. On this page, where parting out begins:
http://www.bricklink.com/invSet.asp?itemType=S&itemNo=75022-1
add a box for the seller to input his total cost for all sets being parted out.
2. Part out like you normally would withOUT entering any costs and then click
"Verify Items" at the bottom of the page.
3. This will pull up the next page:
http://www.bricklink.com/invSetVerify.asp
where everything is listed for the seller to review and approve before uploading.
For this example, using Price Guide averages, the TOTAL part-out value shown
by BrickLink is $426.89. BrickLink can automatically divide the seller's
total cost ($260.00) by this total part-out value ($426.89) to automatically
determine that the cost per item is 0.609 times the listed price for each item.
Thus, for example, for minifigure sw493 BrickLink would automatically enter the
cost as $5.65 or 0.609 times the listed price of $9.58.
Currently, the seller cannot change anything on this page. So an added tweak
would be to make items (or at least the costs) editable on this page should the
seller wish to change them.
Hit "Upload Items" and, voila, your costs are automatically entered.
Thor
|
|
|
|
| | | | | |
| | | | | Author: | TheBrickGuys | | Posted: | Feb 12, 2014 11:29 | | Subject: | Re: Automate Costs When Parting Out | | Viewed: | 59 times | | Topic: | Suggestions | |
|
| The way I accomplish close to the same thing you are looking for is quite simple...
I like to have all our parts in our store to be between 23% and 29% off the 6
month sales average depending on the type of part (such as, more off for wedge
plates and less for bricks) so I just choose the setting to automatically set
the price at the 6 month sales average. Then I go into my inventory and put the
different categories of parts up on sale for the 23% to 29% off.
I have my inventory marked to save all my listings after they are sold out so
that when I part out new sets I dont have to re-apply the sales off percentage
- the only exception is when adding new parts or new part colors which only means
going into my inventory once in a while to reset the percentages off.
If there are certain individual parts I want at less or more then I only need
to set that percentage off once.
The added benefit is that my inventory always reflects the changing 6 month sales
average.
If nothing else, this is a good work around in the interim.
Jim
|
|
|
| | | | | | | | | |
| | | | | | | Author: | FigBits | | Posted: | Feb 12, 2014 15:10 | | Subject: | Re: Automate Costs When Parting Out | | Viewed: | 56 times | | Topic: | Suggestions | |
|
| In Suggestions, TheBrickGuys writes:
| | The way I accomplish close to the same thing you are looking for is quite simple...
I like to have all our parts in our store to be between 23% and 29% off the 6
month sales average depending on the type of part (such as, more off for wedge
plates and less for bricks) so I just choose the setting to automatically set
the price at the 6 month sales average. Then I go into my inventory and put the
different categories of parts up on sale for the 23% to 29% off.
I have my inventory marked to save all my listings after they are sold out so
that when I part out new sets I dont have to re-apply the sales off percentage
- the only exception is when adding new parts or new part colors which only means
going into my inventory once in a while to reset the percentages off.
If there are certain individual parts I want at less or more then I only need
to set that percentage off once.
The added benefit is that my inventory always reflects the changing 6 month sales
average.
If nothing else, this is a good work around in the interim.
Jim
|
I am not following how that sets the My Cost attribute for the parts.
Myself, I do it in BrickStore, but it's annoying. I part-out in BrickStore,
then set to the 6-month average, then apply a % discount to bring the total value
down to my total cost. Then I edit the output file and change the PRICE field
to MYCOST, upload to a stockroom and manually set the price I want to sell it
for.
--
Marc.
|
|
|
| | | | | | | | | | | | | |
| | | | | | | | | Author: | TheBrickGuys | | Posted: | Feb 12, 2014 16:21 | | Subject: | Re: Automate Costs When Parting Out | | Viewed: | 50 times | | Topic: | Suggestions | |
|
| Your right. I was being an idiot and obviously did not read it close enough to
see that he was taking about HIS COST that he paid for each part.
Ummm, never mind.
Jim, an idiot.
|
|
| | | | | |
| | | | | Author: | bsohn | | Posted: | Feb 13, 2014 16:42 | | Subject: | Re: Automate Costs When Parting Out | | Viewed: | 54 times | | Topic: | Suggestions | |
|
| In Suggestions, fosterbengoshi writes:
| | BrickLink does not have a convenient way to enter costs when parting out a set.
The cost needs to be entered manually for each item.
For BL2.0 please provide a feature whereby costs are automatically entered by
BrickLink when the part-out page is first submitted for approval. Let's say
you want to part out ten (10) of set number 75022
The way this would work is as follows:
1. On this page, where parting out begins:
http://www.bricklink.com/invSet.asp?itemType=S&itemNo=75022-1
add a box for the seller to input his total cost for all sets being parted out.
2. Part out like you normally would withOUT entering any costs and then click
"Verify Items" at the bottom of the page.
3. This will pull up the next page:
http://www.bricklink.com/invSetVerify.asp
where everything is listed for the seller to review and approve before uploading.
For this example, using Price Guide averages, the TOTAL part-out value shown
by BrickLink is $426.89. BrickLink can automatically divide the seller's
total cost ($260.00) by this total part-out value ($426.89) to automatically
determine that the cost per item is 0.609 times the listed price for each item.
Thus, for example, for minifigure sw493 BrickLink would automatically enter the
cost as $5.65 or 0.609 times the listed price of $9.58.
Currently, the seller cannot change anything on this page. So an added tweak
would be to make items (or at least the costs) editable on this page should the
seller wish to change them.
Hit "Upload Items" and, voila, your costs are automatically entered.
Thor
|
Funny thing is I actually do all of this within an Excel file that I use for
inventory uploading though I not only have it give me a price per part in the
set but it weights the costs based on the average cost per part in the set. So
say a set costs $10.00 for 100 parts or $.10 each part and the part out value
is $20.00 but one part is worth $5.00.. The Excell setup I have takes that part
and will weight it 25% in comparison with the other parts making that parts cost
$2.50 with the other 99 parts being .076 each. Granted when you have all the
different values the calculations get a little more intense but it makes it so
all parts that are low value their cost remains below the selling cost.
I wish I was more intune to data bases and scripting so that I could actually
gather the data easier when I have parts that cannot be exported with pricing..
I Have to manually due the average by quantity when I have similar parts as was
shown by someone earlier in this post as bricklink doesn't seem to do this..
I have my own scripting using imacros and a webpage I made to crete an XML upload
file from the Excel CSV output.
It is complex but it does ease having to figure out costs of parts.
Brion
|
|
|
| | | | | | | | | |
| | | | | | | Author: | BLUSER_29702 | | Posted: | Feb 13, 2014 20:14 | | Subject: | Re: Automate Costs When Parting Out | | Viewed: | 34 times | | Topic: | Suggestions | |
|
| In Suggestions, bsohn writes:
| | Funny thing is I actually do all of this within an Excel file that I use for
inventory uploading though I not only have it give me a price per part in the
set but it weights the costs based on the average cost per part in the set. So
say a set costs $10.00 for 100 parts or $.10 each part and the part out value
is $20.00 but one part is worth $5.00.. The Excell setup I have takes that part
and will weight it 25% in comparison with the other parts making that parts cost
$2.50 with the other 99 parts being .076 each. Granted when you have all the
different values the calculations get a little more intense but it makes it so
all parts that are low value their cost remains below the selling cost.
I wish I was more intune to data bases and scripting so that I could actually
gather the data easier when I have parts that cannot be exported with pricing..
I Have to manually due the average by quantity when I have similar parts as was
shown by someone earlier in this post as bricklink doesn't seem to do this..
I have my own scripting using imacros and a webpage I made to crete an XML upload
file from the Excel CSV output.
It is complex but it does ease having to figure out costs of parts.
Brion
|
Do you guys have to track this for tax purposes, or is it enough to just say
"This year I spent $$ on buying new product, and made $$ from selling"?
|
|
|
| | | | | | | | | | | | | |
| | | | | | | | | Author: | bsohn | | Posted: | Feb 22, 2014 14:35 | | Subject: | Re: Automate Costs When Parting Out | | Viewed: | 40 times | | Topic: | Suggestions | |
|
| In Suggestions, Pearson writes:
| | In Suggestions, bsohn writes:
| | Funny thing is I actually do all of this within an Excel file that I use for
inventory uploading though I not only have it give me a price per part in the
set but it weights the costs based on the average cost per part in the set. So
say a set costs $10.00 for 100 parts or $.10 each part and the part out value
is $20.00 but one part is worth $5.00.. The Excell setup I have takes that part
and will weight it 25% in comparison with the other parts making that parts cost
$2.50 with the other 99 parts being .076 each. Granted when you have all the
different values the calculations get a little more intense but it makes it so
all parts that are low value their cost remains below the selling cost.
I wish I was more intune to data bases and scripting so that I could actually
gather the data easier when I have parts that cannot be exported with pricing..
I Have to manually due the average by quantity when I have similar parts as was
shown by someone earlier in this post as bricklink doesn't seem to do this..
I have my own scripting using imacros and a webpage I made to crete an XML upload
file from the Excel CSV output.
It is complex but it does ease having to figure out costs of parts.
Brion
|
Do you guys have to track this for tax purposes, or is it enough to just say
"This year I spent $$ on buying new product, and made $$ from selling"?
|
You only really need to track it down to pennies if you want to make sure you
are making money, as for Taxes usually it is a How Much you purchased, how much
you have remaining in your inventory, and how much you made in $$ values.
Brion Sohn
|
|
|
| | | | | | | | | | | | | | | | | |
| | | | | | | | | | | Author: | ToriHada | | Posted: | Feb 22, 2014 18:48 | | Subject: | Re: Automate Costs When Parting Out | | Viewed: | 52 times | | Topic: | Suggestions | |
|
| In Suggestions, bsohn writes:
| | ... as for Taxes usually it is a How Much you purchased, how much
you have remaining in your inventory, and how much you made in $$ values.
|
I always thought the same thing. But this year I changed accountants and he says
I cannot carryover inventory cost from year to year. He says I need to determine
my total inventory cost at the beginning and end of my tax year, in addition
to factoring in what I bought and sold during the year. Maybe someone else can
explain it better. I'm not very good when it comes to taxes. I pay my guy
$500 a year to do my taxes. This year I have to file FOUR separate Schedule C's.
Thor
|
|
| | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | Author: | QCBricks | | Posted: | Feb 22, 2014 19:43 | | Subject: | Re: Automate Costs When Parting Out | | Viewed: | 50 times | | Topic: | Suggestions | |
|
| In Suggestions, fosterbengoshi writes:
| | In Suggestions, bsohn writes:
| | ... as for Taxes usually it is a How Much you purchased, how much
you have remaining in your inventory, and how much you made in $$ values.
|
I always thought the same thing. But this year I changed accountants and he says
I cannot carryover inventory cost from year to year. He says I need to determine
my total inventory cost at the beginning and end of my tax year, in addition
to factoring in what I bought and sold during the year. Maybe someone else can
explain it better. I'm not very good when it comes to taxes. I pay my guy
$500 a year to do my taxes. This year I have to file FOUR separate Schedule C's.
Thor
|
Been this way for a year or two. Not sure that it directly affects what you
owe in taxes, but I think what you value as inventory is tracked. Stops people
from transferring taxable income into inventory to avoid taxes.
I think the rule change had something to do with the rules governing "current
value" versus "basis value". (Basis value is what you paid for the inventory)
This is why we use an accountant.
Scott
|
|
|
| | | | | | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | | | Author: | jeslego | | Posted: | Feb 22, 2014 19:59 | | Subject: | Re: Automate Costs When Parting Out | | Viewed: | 48 times | | Topic: | Suggestions | |
|
| In Suggestions, QCBricks writes:
| | In Suggestions, fosterbengoshi writes:
| | In Suggestions, bsohn writes:
| | ... as for Taxes usually it is a How Much you purchased, how much
you have remaining in your inventory, and how much you made in $$ values.
|
I always thought the same thing. But this year I changed accountants and he says
I cannot carryover inventory cost from year to year. He says I need to determine
my total inventory cost at the beginning and end of my tax year, in addition
to factoring in what I bought and sold during the year. Maybe someone else can
explain it better. I'm not very good when it comes to taxes. I pay my guy
$500 a year to do my taxes. This year I have to file FOUR separate Schedule C's.
Thor
|
Been this way for a year or two. Not sure that it directly affects what you
owe in taxes, but I think what you value as inventory is tracked. Stops people
from transferring taxable income into inventory to avoid taxes.
I think the rule change had something to do with the rules governing "current
value" versus "basis value". (Basis value is what you paid for the inventory)
This is why we use an accountant.
Scott
|
this may be one of the situations where size matters. My accountant is an enrolled
agent. He has never asked about inventory valuation. However, he has been very
clear that whatever rule I use to account for inventory needs to be used without
change.
For me, this means that I have two inventories. The sets that I resell are expensed
at the time of sale. If I bought a box (or a bunch of parts with instructions)
in 2010, I do not list it as an expense until the box or bag is resold.
The other inventory is of parts that I buy either in bulk or via Bricklink to
complete used sets. That is expensed in the year purchased.
If I ever get involved with the sale of a large number of parts, I suspect that
my accountant will sound a lot more like yours.
|
|
|
| | | | | | | | | | | | | | | | | | | | | |
| | | | | | | | | | | | | Author: | bsohn | | Posted: | Mar 6, 2014 18:10 | | Subject: | Re: Automate Costs When Parting Out | | Viewed: | 51 times | | Topic: | Suggestions | |
|
| In Suggestions, fosterbengoshi writes:
| | In Suggestions, bsohn writes:
| | ... as for Taxes usually it is a How Much you purchased, how much
you have remaining in your inventory, and how much you made in $$ values.
|
I always thought the same thing. But this year I changed accountants and he says
I cannot carryover inventory cost from year to year. He says I need to determine
my total inventory cost at the beginning and end of my tax year, in addition
to factoring in what I bought and sold during the year. Maybe someone else can
explain it better. I'm not very good when it comes to taxes. I pay my guy
$500 a year to do my taxes. This year I have to file FOUR separate Schedule C's.
Thor
|
The Inventory beginning of the year and end of the year numbers are to track
how much existing inventory was sold and then of course you have tracked what
came in and out during the year.. In some states I think they have a different
Tax Basis for first in - first out or last in - first out inventory. Not totally
sure how it works but knowing the yearly expenditures on inventory and the beginning
and end difference allows them to figure out exactly how much inventory has sold
and whether or not you had an inventory increase or decrease.
So in essence you are carrying inventory forward from year to year BUT it is
also setting up deportation if you are allowed to depreciate old stock.
Brion
|
|
|
| | | | | |
| | | | | Author: | renhoffman | | Posted: | Feb 13, 2014 20:30 | | Subject: | Re: Automate Costs When Parting Out | | Viewed: | 46 times | | Topic: | Suggestions | |
|
| Yes please!
In Suggestions, fosterbengoshi writes:
| | BrickLink does not have a convenient way to enter costs when parting out a set.
The cost needs to be entered manually for each item.
For BL2.0 please provide a feature whereby costs are automatically entered by
BrickLink when the part-out page is first submitted for approval. Let's say
you want to part out ten (10) of set number 75022
The way this would work is as follows:
1. On this page, where parting out begins:
http://www.bricklink.com/invSet.asp?itemType=S&itemNo=75022-1
add a box for the seller to input his total cost for all sets being parted out.
2. Part out like you normally would withOUT entering any costs and then click
"Verify Items" at the bottom of the page.
|
To clarify this part, you could adjust your selling prices, but not adjust the
cost, as it has been set already. The example shown below is if the seller did
not adjust anything.
| | 3. This will pull up the next page:
http://www.bricklink.com/invSetVerify.asp
where everything is listed for the seller to review and approve before uploading.
For this example, using Price Guide averages, the TOTAL part-out value shown
by BrickLink is $426.89. BrickLink can automatically divide the seller's
total cost ($260.00) by this total part-out value ($426.89) to automatically
determine that the cost per item is 0.609 times the listed price for each item.
Thus, for example, for minifigure sw493 BrickLink would automatically enter the
cost as $5.65 or 0.609 times the listed price of $9.58.
Currently, the seller cannot change anything on this page. So an added tweak
would be to make items (or at least the costs) editable on this page should the
seller wish to change them.
Hit "Upload Items" and, voila, your costs are automatically entered.
Thor
|
Thank you, that will be a very important feature for some of us  .
Darren
|
|
|
| | | | | |
| | | | | Author: | Black_Armor | | Posted: | Feb 22, 2014 21:47 | | Subject: | Re: Automate Costs When Parting Out | | Viewed: | 57 times | | Topic: | Suggestions | |
|
| Yes, please.
Editing the XML code to add the cost is dreadful too.
|
|
| | | | | |
| | | | | Author: | crazybirdman | | Posted: | Feb 27, 2014 19:28 | | Subject: | Re: Automate Costs When Parting Out | | Viewed: | 33 times | | Topic: | Suggestions | |
|
| Couldn't this also be done based on a percentage of what you are pricing
your parts at?
|
|
|
|
|
USA, North Carolina
United Kingdom, England
Canada, Ontario
Singapore