수요예측ㆍ재고관리 전문가 채널
내용
[subtitle-meta] lang=en auto=True
Storytime on how I almost ruined my
business because of a spreadsheet. Like,
I was literally running everything on
vibes and gut feelings. And honestly, it
was a total nightmare. I'd be out of
stock on my best sellers for weeks, but
then I'd have a warehouse full of stuff
nobody even wanted. I realized the big
guys have these crazy expensive systems,
but I'm just me. Then I started using
InStock and everything basically
changed. It's built for brands like mine
that have those super long lead times.
It forecasts the next 12 months, month
by month. So, it actually accounts for
the season the stock lands in. If I know
a big promo is coming up, I just go in
and set the number myself. I can even
leave a little note explaining why I
changed it. If it's a yearly thing, I
just mark it as recurring for next year.
It literally shows me the math behind
how many units I need to order. No more
3:00 a.m. spreadsheet stress. It's
basically big company tech without that
insane price tag. Seriously, if you're
still using Excel for your stock, how
are you even sleeping at night? Let me
know your inventory horror stories in
the comments.
원문 자막 펼치기
WEBVTT Kind: captions Language: en 00:00:00.000 --> 00:00:02.510 align:start position:0% Storytime<00:00:00.920><c> on</c><00:00:01.040><c> how</c><00:00:01.240><c> I</c><00:00:01.320><c> almost</c><00:00:01.880><c> ruined</c><00:00:02.320><c> my</c> 00:00:02.510 --> 00:00:02.520 align:start position:0% Storytime on how I almost ruined my 00:00:02.520 --> 00:00:05.630 align:start position:0% Storytime on how I almost ruined my business<00:00:03.320><c> because</c><00:00:03.760><c> of</c><00:00:03.880><c> a</c><00:00:03.960><c> spreadsheet.</c><00:00:05.040><c> Like,</c> 00:00:05.630 --> 00:00:05.640 align:start position:0% business because of a spreadsheet. Like, 00:00:05.640 --> 00:00:07.710 align:start position:0% business because of a spreadsheet. Like, I<00:00:05.840><c> was</c><00:00:06.120><c> literally</c><00:00:06.600><c> running</c><00:00:06.960><c> everything</c><00:00:07.520><c> on</c> 00:00:07.710 --> 00:00:07.720 align:start position:0% I was literally running everything on 00:00:07.720 --> 00:00:11.310 align:start position:0% I was literally running everything on vibes<00:00:08.480><c> and</c><00:00:08.720><c> gut</c><00:00:09.000><c> feelings.</c><00:00:09.880><c> And</c><00:00:10.200><c> honestly,</c><00:00:11.040><c> it</c> 00:00:11.310 --> 00:00:11.320 align:start position:0% vibes and gut feelings. And honestly, it 00:00:11.320 --> 00:00:13.910 align:start position:0% vibes and gut feelings. And honestly, it was<00:00:11.560><c> a</c><00:00:11.680><c> total</c><00:00:12.240><c> nightmare.</c><00:00:13.200><c> I'd</c><00:00:13.440><c> be</c><00:00:13.640><c> out</c><00:00:13.800><c> of</c> 00:00:13.910 --> 00:00:13.920 align:start position:0% was a total nightmare. I'd be out of 00:00:13.920 --> 00:00:16.910 align:start position:0% was a total nightmare. I'd be out of stock<00:00:14.320><c> on</c><00:00:14.440><c> my</c><00:00:14.640><c> best</c><00:00:15.120><c> sellers</c><00:00:15.640><c> for</c><00:00:15.880><c> weeks,</c><00:00:16.680><c> but</c> 00:00:16.910 --> 00:00:16.920 align:start position:0% stock on my best sellers for weeks, but 00:00:16.920 --> 00:00:19.350 align:start position:0% stock on my best sellers for weeks, but then<00:00:17.280><c> I'd</c><00:00:17.480><c> have</c><00:00:17.720><c> a</c><00:00:17.800><c> warehouse</c><00:00:18.520><c> full</c><00:00:18.840><c> of</c><00:00:18.960><c> stuff</c> 00:00:19.350 --> 00:00:19.360 align:start position:0% then I'd have a warehouse full of stuff 00:00:19.360 --> 00:00:22.270 align:start position:0% then I'd have a warehouse full of stuff nobody<00:00:19.920><c> even</c><00:00:20.240><c> wanted.</c><00:00:21.080><c> I</c><00:00:21.240><c> realized</c><00:00:21.920><c> the</c><00:00:22.000><c> big</c> 00:00:22.270 --> 00:00:22.280 align:start position:0% nobody even wanted. I realized the big 00:00:22.280 --> 00:00:24.790 align:start position:0% nobody even wanted. I realized the big guys<00:00:22.600><c> have</c><00:00:22.760><c> these</c><00:00:22.960><c> crazy</c><00:00:23.480><c> expensive</c><00:00:24.080><c> systems,</c> 00:00:24.790 --> 00:00:24.800 align:start position:0% guys have these crazy expensive systems, 00:00:24.800 --> 00:00:27.950 align:start position:0% guys have these crazy expensive systems, but<00:00:25.040><c> I'm</c><00:00:25.200><c> just</c><00:00:25.840><c> me.</c><00:00:26.640><c> Then</c><00:00:27.000><c> I</c><00:00:27.120><c> started</c><00:00:27.600><c> using</c> 00:00:27.950 --> 00:00:27.960 align:start position:0% but I'm just me. Then I started using 00:00:27.960 --> 00:00:30.030 align:start position:0% but I'm just me. Then I started using InStock<00:00:28.840><c> and</c><00:00:29.120><c> everything</c><00:00:29.800><c> basically</c> 00:00:30.030 --> 00:00:30.040 align:start position:0% InStock and everything basically 00:00:30.040 --> 00:00:33.710 align:start position:0% InStock and everything basically changed.<00:00:31.440><c> It's</c><00:00:31.760><c> built</c><00:00:32.080><c> for</c><00:00:32.240><c> brands</c><00:00:32.759><c> like</c><00:00:33.000><c> mine</c> 00:00:33.710 --> 00:00:33.720 align:start position:0% changed. It's built for brands like mine 00:00:33.720 --> 00:00:36.670 align:start position:0% changed. It's built for brands like mine that<00:00:33.960><c> have</c><00:00:34.200><c> those</c><00:00:34.560><c> super</c><00:00:34.960><c> long</c><00:00:35.360><c> lead</c><00:00:35.680><c> times.</c> 00:00:36.670 --> 00:00:36.680 align:start position:0% that have those super long lead times. 00:00:36.680 --> 00:00:39.830 align:start position:0% that have those super long lead times. It<00:00:36.920><c> forecasts</c><00:00:37.720><c> the</c><00:00:37.840><c> next</c><00:00:38.240><c> 12</c><00:00:38.680><c> months,</c><00:00:39.480><c> month</c> 00:00:39.830 --> 00:00:39.840 align:start position:0% It forecasts the next 12 months, month 00:00:39.840 --> 00:00:42.350 align:start position:0% It forecasts the next 12 months, month by<00:00:40.040><c> month.</c><00:00:40.880><c> So,</c><00:00:41.160><c> it</c><00:00:41.320><c> actually</c><00:00:41.800><c> accounts</c><00:00:42.240><c> for</c> 00:00:42.350 --> 00:00:42.360 align:start position:0% by month. So, it actually accounts for 00:00:42.360 --> 00:00:44.990 align:start position:0% by month. So, it actually accounts for the<00:00:42.520><c> season</c><00:00:42.920><c> the</c><00:00:43.040><c> stock</c><00:00:43.440><c> lands</c><00:00:43.800><c> in.</c><00:00:44.360><c> If</c><00:00:44.600><c> I</c><00:00:44.720><c> know</c> 00:00:44.990 --> 00:00:45.000 align:start position:0% the season the stock lands in. If I know 00:00:45.000 --> 00:00:47.790 align:start position:0% the season the stock lands in. If I know a<00:00:45.080><c> big</c><00:00:45.400><c> promo</c><00:00:45.840><c> is</c><00:00:45.960><c> coming</c><00:00:46.360><c> up,</c><00:00:46.920><c> I</c><00:00:47.080><c> just</c><00:00:47.360><c> go</c><00:00:47.600><c> in</c> 00:00:47.790 --> 00:00:47.800 align:start position:0% a big promo is coming up, I just go in 00:00:47.800 --> 00:00:50.390 align:start position:0% a big promo is coming up, I just go in and<00:00:47.960><c> set</c><00:00:48.240><c> the</c><00:00:48.360><c> number</c><00:00:48.680><c> myself.</c><00:00:49.760><c> I</c><00:00:49.920><c> can</c><00:00:50.160><c> even</c> 00:00:50.390 --> 00:00:50.400 align:start position:0% and set the number myself. I can even 00:00:50.400 --> 00:00:52.550 align:start position:0% and set the number myself. I can even leave<00:00:50.640><c> a</c><00:00:50.680><c> little</c><00:00:50.960><c> note</c><00:00:51.400><c> explaining</c><00:00:52.200><c> why</c><00:00:52.440><c> I</c> 00:00:52.550 --> 00:00:52.560 align:start position:0% leave a little note explaining why I 00:00:52.560 --> 00:00:55.630 align:start position:0% leave a little note explaining why I changed<00:00:53.000><c> it.</c><00:00:53.760><c> If</c><00:00:54.000><c> it's</c><00:00:54.200><c> a</c><00:00:54.280><c> yearly</c><00:00:54.760><c> thing,</c><00:00:55.440><c> I</c> 00:00:55.630 --> 00:00:55.640 align:start position:0% changed it. If it's a yearly thing, I 00:00:55.640 --> 00:00:58.750 align:start position:0% changed it. If it's a yearly thing, I just<00:00:56.000><c> mark</c><00:00:56.280><c> it</c><00:00:56.400><c> as</c><00:00:56.840><c> recurring</c><00:00:57.480><c> for</c><00:00:57.680><c> next</c><00:00:58.080><c> year.</c> 00:00:58.750 --> 00:00:58.760 align:start position:0% just mark it as recurring for next year. 00:00:58.760 --> 00:01:00.910 align:start position:0% just mark it as recurring for next year. It<00:00:59.000><c> literally</c><00:00:59.520><c> shows</c><00:00:59.880><c> me</c><00:01:00.000><c> the</c><00:01:00.120><c> math</c><00:01:00.520><c> behind</c> 00:01:00.910 --> 00:01:00.920 align:start position:0% It literally shows me the math behind 00:01:00.920 --> 00:01:03.550 align:start position:0% It literally shows me the math behind how<00:01:01.080><c> many</c><00:01:01.360><c> units</c><00:01:01.760><c> I</c><00:01:01.840><c> need</c><00:01:02.080><c> to</c><00:01:02.200><c> order.</c><00:01:02.960><c> No</c><00:01:03.240><c> more</c> 00:01:03.550 --> 00:01:03.560 align:start position:0% how many units I need to order. No more 00:01:03.560 --> 00:01:06.550 align:start position:0% how many units I need to order. No more 3:00<00:01:04.120><c> a.m.</c><00:01:04.559><c> spreadsheet</c><00:01:05.199><c> stress.</c><00:01:06.200><c> It's</c> 00:01:06.550 --> 00:01:06.560 align:start position:0% 3:00 a.m. spreadsheet stress. It's 00:01:06.560 --> 00:01:09.590 align:start position:0% 3:00 a.m. spreadsheet stress. It's basically<00:01:07.280><c> big</c><00:01:07.640><c> company</c><00:01:08.160><c> tech</c><00:01:08.800><c> without</c><00:01:09.360><c> that</c> 00:01:09.590 --> 00:01:09.600 align:start position:0% basically big company tech without that 00:01:09.600 --> 00:01:12.750 align:start position:0% basically big company tech without that insane<00:01:10.160><c> price</c><00:01:10.520><c> tag.</c><00:01:11.400><c> Seriously,</c><00:01:12.400><c> if</c><00:01:12.600><c> you're</c> 00:01:12.750 --> 00:01:12.760 align:start position:0% insane price tag. Seriously, if you're 00:01:12.760 --> 00:01:15.190 align:start position:0% insane price tag. Seriously, if you're still<00:01:13.200><c> using</c><00:01:13.600><c> Excel</c><00:01:14.000><c> for</c><00:01:14.120><c> your</c><00:01:14.320><c> stock,</c><00:01:15.000><c> how</c> 00:01:15.190 --> 00:01:15.200 align:start position:0% still using Excel for your stock, how 00:01:15.200 --> 00:01:17.550 align:start position:0% still using Excel for your stock, how are<00:01:15.320><c> you</c><00:01:15.520><c> even</c><00:01:15.800><c> sleeping</c><00:01:16.280><c> at</c><00:01:16.440><c> night?</c><00:01:17.200><c> Let</c><00:01:17.440><c> me</c> 00:01:17.550 --> 00:01:17.560 align:start position:0% are you even sleeping at night? Let me 00:01:17.560 --> 00:01:19.590 align:start position:0% are you even sleeping at night? Let me know<00:01:17.800><c> your</c><00:01:18.080><c> inventory</c><00:01:18.720><c> horror</c><00:01:19.040><c> stories</c><00:01:19.480><c> in</c> 00:01:19.590 --> 00:01:19.600 align:start position:0% know your inventory horror stories in 00:01:19.600 --> 00:01:22.440 align:start position:0% know your inventory horror stories in the<00:01:19.680><c> comments.</c>