Forum Replies Created
-
AuthorPosts
-
Wow. Where in the east mountains? I’ll bet I know the area!
Love green chile. Going to can another batch this week. Love being able to go down to the basement, grab a quart jar of Green Chile, heat up some tortillas and dinner is served!
I was born in ABQ, lived in Bernalillo, Grants, and Edgewood. Went to HS in Moriarty, and graduated college from NMHU in Las Vegas. We lived all over the country (Texas, Maryland, Virginia), but are in Colorado now.
Best part is I’m back in the land of green chile!
Hola Beth! I was born and raised in NM, so glad to hear from someone back home!
Aerospace…I’m thinking you are in ABQ at Sandia, or in Alamagordo around White Sands?
02/26/2018 at 9:08 am in reply to: Scavenger Life Episode 349: Having A Huge Inventory Is Not The Goal, It’s The Strategy #33854Week of 2/18-2/24
Total Items in Store: 1,884 (Up 30% YOY)
Number of Items Listed: 80
Number of Items Sold: 65 (Down 2% YOY)
(Includes 1 Etsy, 1 Bonanza, 0 TrueGether)
Weekly STR: 15% (Down 5% YOY)Total Product Sales: $1,544 (Up 23% YOY)
Cost of Items Sold: $308
Highest Item Sold: $90 – Cole Haan Shoes
Competition: Highest Priced Sale: Veronica wins the week and Troy leads the year at 5-3.eBay Clothing
# Listed: 1,150
# Sold: 42
STR: 16%
ASP: $23.79eBay Shoes
# Listed: 112
# Sold: 11
STR: 42%
ASP: $32.61eBay Hard Goods
# Listed: 622
# Sold: 11
STR: 8%
ASP: $15.32Etsy Hard Goods
# Listed: 122
# Sold: 1
STR: 4%
ASP: $34.81Great talk about the inventory level. Your focus is NOT on the inventory level first. Your focus is on what weekly income you are looking for, THEN your inventory generates that profit. It is textbook on how we forecast our business. If I know my inventory level, my STR, and my ASP, then I can forecast my revenue. I can also calculate the inventory level needed to generate the revenue I need by using the same formula.
And yes, the comparison game is difficult. You guys handle the large inventory, low STR model well because you buy very low and you have a low fixed cost for storage. Those are the two main keys to make that work. Your only risk is that you will have inventory that will never sell, and that is lost money and time. For others that buy low and have a low STR, they need to have a plan to store the large inventory needed to get the weekly profit they need. It is all about knowing what your model is, what that model will generate, and what the constraints and risks are.
Hey Katie. We just followed you on Instagram. We are verosvault on Instagram.
See you out there!
Sonia, you are correct, and I wasn’t thinking as much about the Schedule C calculation. For that reason, I think you have to NOT show a return as an Inventory Purchase for the Schedule C.
Let’s look at the scenario of we sold out our inventory in 2017 down to $0, and the only transaction for the year is the return. If we treat the return as just a return (not a new purchase):
Schedule C:
Beginning Inventory: $0
+ Inventory Purchases: $0
– Ending Inventory: $10
= COGS: ($10)We show a negative COGS, as we should, since the return gave us negative sales.
2018 P&L should show
Sales: ($100)
COGS: ($10)
Loss: ($90)If you treat the return as a new purchase:
Schedule C:
Beginning Inventory: $0
+ Inventory Purchases: $10
– Ending Inventory: $10
= COGS: $02018 P&L would show
Sales: ($100)
COGS: ($0)
Loss: ($100)That second scenario is not correct. For purposes of the Schedule C calculation, all returns should NOT be added to the Inventory Purchases for the year.
It really depends on how you get your inventory value at the end of the year. Whether you put it as a purchase, or just add it to your list of inventory, it doesn’t matter.
Think of it this way. If it was returned in January of 2018 and it did NOT sell in 2018, how would you make sure that your year end inventory had the value included? That is what matters.
Sonia, Junque is taking you in the right direction. Hopefully to make this make sense, let’s look at the impact on the financials for each year. Let me lay out how you would do the journal entries to account for each transaction. If you don’t care about that part (it helps me lay it out in my head), then you can skip to the paragraphs at the end.
2017
Purchase item for $10Debit Inventory $10
Credit Cash $10.This is only on the balance sheet, moving $10 from the asset Cash to the asset Inventory
Sell item for $100
Debit Cash $100
Credit Sales $100
Debit COGS $10
Credit Inventory $10Removes the asset from the balance sheet for $10, adds the asset Cash for $100
End of 2017 Financials
Balance Sheet – $100 Cash
Profit & Loss – $100 Sales, $10 COGS2018
Item is ReturnedDebit Inventory $10
Credit COGS $10
Debit Sales $100
Credit Cash $100You are basically reversing the sales transaction. You will also notice that you now have a negative P&L of $90 (Reduced sales by $100, Reduced COGS by $10)
Item resells
Sell item for $100
Debit Cash $100
Credit Sales $100
Debit COGS $10
Credit Inventory $10The effect of this transaction essentially zeros out the return transaction. At the end of the day, these two are net $0
I realize all of this is doing it like a dorky accounting nerd would do this with journal entries (I can’t escape who I am), but that helps to explain what the answer should be and we can make sure we get there.
Now in your case, you ain’t doing these transactions. You are calculating your COGS at the end of each year. So here is the important part to getting this right. You HAVE to make sure that you have accurate inventory numbers at the end of the year. Your inventory HAS to match your record of inventory for taxes.
So to boil this down. When you get a return, you HAVE to increase your financial Inventory record to account for that return. Spreadsheet, the Easy Auction Tracker file, SixBit, even by hand, it doesn’t matter. When you get a return, you HAVE to increase your financial record of the value of your inventory. If you do that, you will be fine.
02/23/2018 at 6:19 pm in reply to: Scavenger Life Episode 348: Acknowledge When Hard Work Pays Off #33782LOL!
I can relate, due to my prior work. But I also notice that now that the books are the lesser part of the business (important, but lesser), I’m more for simple and as fast as possible. I love my numbers and analysis, but now I want them quick.
It is nice to be the Owner analyzing the numbers, not just the geek generating them…
Nice score!
Interesting. I take all my photos in the portrait position, square or rectangle. Though for rotational issue solving, I move the phone down into the shot, and that seems to set the orientation correctly.
02/23/2018 at 11:15 am in reply to: Scavenger Life Episode 343: Our Business = Little Things Every Day #33767Katie:
#2 – Amazing how so many things are similar. Flipping on eBay, flipping houses, flipping cars, trading stocks, Investing in real estate, bonds… Learning the ability to see value where others don’t, and then knowing how to sell that value to the marketplace. It is all around us…
#3 – Made me think of my dad. I grew up on a small family farm, and my dad “flipped” cattle. We always had one or two young calves that he would by at the auction that were sickly and skinny, he would nurse to health and fatten up, and then sell at the auction months later. And now…he made sure his new place in Montana was large enough that he qualified for an agricultural tax exemption. Knowledge is king…
02/22/2018 at 7:37 pm in reply to: Scavenger Life Episode 344: Decluttering and Auction Cravings #33734Katie: loved that post!
PS – #8 +1 ;).
02/22/2018 at 3:11 pm in reply to: Scavenger Life Episode 348: Acknowledge When Hard Work Pays Off #33698Thanks Paulo. Good to know that my advice is what you are looking for.
Relating to COGS, I understand all of what you described. I was a CPA and Controller in a Cost Accounting environment for over 20 years. I get those definitions.
I was more asking about what other items you are putting in COGS in your financials. For me, COGS is only the cost of the inventory. That is it. You can (correctly) argue that the poly mailers, bubble wrap, boxes that we pay for is COGS as well, as it is part of the finished product that is sold, so it is ODM (Other Direct Materials). I just don’t because I don’t care (and I don’t have to strictly follow GAAP for a non-material cost, follow SEC reporting rules any more, and I’m not audited by a Big 6 Accounting Firm anymore so…my rules, I make them up!)
So I was referring to your statement “putting 10 of the 11 COGS lines that are exclusively related to eBay, Etsy, Bonanza, my actual COGS is 92% of Gross Sales.” I was wondering what the other 10 or 11 COGS items you are referring to.
02/22/2018 at 2:56 pm in reply to: Scavenger Life Episode 348: Acknowledge When Hard Work Pays Off #33696Philmount is in my old stomping grounds. Born and raised in NM, and went to college at NM Highlands in Las Vegas NM. Never made it to Philmont, but I have heard lots of great things about it.
Thanks for the advice. I’ve been doing a lot of work under weight at this point. Walking the dogs with the pack. Hiking with the pack. I have even started wearing a 10lb weighted vest everyday (all day) just to add weight to the body.
Good to know about the stair work as well. There is a steep winding trail by the house I call Lombard Trail that I should practice just up and down over and over again. The 10,000 feet elevation is the only other concern. I’m at almost 6,000 feet now, but I know when I go hunting at 9,000 what the difference is like.
My biggest fear…being ready gear-wise and mentally…and by body fails.
-
AuthorPosts