Meeting Title: Brainforge_Poolparts Date: 2025-02-25 Meeting participants: Nicolas Sucari, Uttam Kumaran, Payas Parab, Bo Yoon
WEBVTT
1 00:03:29.320 ⇒ 00:03:30.810 Payas Parab: Hey! Bo! How are you?
2 00:03:33.530 ⇒ 00:03:34.470 Bo Yoon: Hey? Pirates.
3 00:03:34.920 ⇒ 00:03:36.069 Payas Parab: How’s everything going.
4 00:03:37.340 ⇒ 00:03:38.489 Bo Yoon: I’m doing good.
5 00:03:38.780 ⇒ 00:03:39.597 Bo Yoon: How are you?
6 00:03:39.870 ⇒ 00:03:41.269 Payas Parab: I’m doing all right.
7 00:03:41.885 ⇒ 00:03:49.980 Payas Parab: Do you? Wanna pull up the email you had sent? We can just kind of like tick through. And just kind of go through with Dan. No need to like.
8 00:03:50.220 ⇒ 00:03:51.470 Payas Parab: We can just kind of like.
9 00:03:51.700 ⇒ 00:03:56.402 Payas Parab: just ask some of the questions. Just keep going through it with him. See, we can figure out
10 00:03:57.916 ⇒ 00:03:59.290 Payas Parab: hey, Tom.
11 00:04:00.650 ⇒ 00:04:01.880 Uttam Kumaran: Hey? Hey? Guys.
12 00:04:35.900 ⇒ 00:04:37.470 Bo Yoon: Yeah, there you go.
13 00:04:42.560 ⇒ 00:04:48.409 Bo Yoon: So yeah, the questions are basically the the freight cost that
14 00:04:48.630 ⇒ 00:04:53.470 Bo Yoon: a lot of difference with each other, like some of them were 7 to 7, and.
15 00:04:53.470 ⇒ 00:04:54.230 Payas Parab: Yeah.
16 00:04:54.440 ⇒ 00:05:02.479 Bo Yoon: A bunch of them here were ranging from a thousand to like 20,000 or something.
17 00:05:02.670 ⇒ 00:05:05.610 Payas Parab: Yeah. And we think it’s like the containers right? And it’s like trying to group.
18 00:05:05.610 ⇒ 00:05:06.000 Bo Yoon: Yeah.
19 00:05:06.000 ⇒ 00:05:16.510 Payas Parab: The container. Let’s just make sure. Like, you know, I think it’s like a few bunch of role rows based on date would like, go certain container. That’s what we want to like. Verify is the right way.
20 00:05:16.950 ⇒ 00:05:17.540 Bo Yoon: Yeah.
21 00:05:18.250 ⇒ 00:05:20.300 Payas Parab: Link, product, design,
22 00:05:23.750 ⇒ 00:05:26.069 Bo Yoon: There was a product design fee.
23 00:05:29.000 ⇒ 00:05:31.150 Bo Yoon: Yeah, I highlighted it.
24 00:05:34.270 ⇒ 00:05:39.439 Payas Parab: The General Journal. Entry thing, too, is probably just some weird accounting thing can ignore. But it’s good to confirm that
25 00:05:43.500 ⇒ 00:05:44.780 Payas Parab: for number 4.
26 00:05:45.490 ⇒ 00:05:51.105 Payas Parab: And then, yeah, I think we should just understand the dynamics of like tariff and duty, and like how we look at them.
27 00:05:51.350 ⇒ 00:05:51.910 Bo Yoon: Okay.
28 00:05:51.910 ⇒ 00:05:56.699 Payas Parab: What was the name of the customer we kind of looked at when we did like a case study view. I like. Can’t remember now.
29 00:05:57.890 ⇒ 00:05:59.060 Bo Yoon: The customer.
30 00:05:59.260 ⇒ 00:06:06.920 Payas Parab: Yeah, remember, cause he was like his homework was like, Take one customer and let’s like trace all of that and see if we can figure out for that specific customer what happened.
31 00:06:07.900 ⇒ 00:06:16.460 Bo Yoon: No, I mean, if our assumption was right, then it will be multiple customers per container. But for the one
32 00:06:17.000 ⇒ 00:06:19.840 Bo Yoon: I was that we’re looking at. It was.
33 00:06:20.150 ⇒ 00:06:22.829 Bo Yoon: I guess, for Qualco or Splash.
34 00:06:23.190 ⇒ 00:06:24.460 Payas Parab: Sure. Yep. Yeah.
35 00:06:24.460 ⇒ 00:06:29.339 Bo Yoon: There’s name and source name. So not really sure which one.
36 00:06:29.680 ⇒ 00:06:30.700 Payas Parab: Yeah, I sort of make sure.
37 00:06:30.700 ⇒ 00:06:31.230 Bo Yoon: Thanks.
38 00:06:31.570 ⇒ 00:06:35.680 Payas Parab: Specific homework Dan had assigned. And that’s what we did. We looked at like I think it was a
39 00:06:36.080 ⇒ 00:06:37.739 Payas Parab: let me see if I can find it.
40 00:06:41.090 ⇒ 00:06:42.210 Payas Parab: Let me see.
41 00:06:52.770 ⇒ 00:06:53.610 Nicolas Sucari: Hi guys.
42 00:06:55.490 ⇒ 00:06:56.270 Bo Yoon: There you go!
43 00:07:34.540 ⇒ 00:07:38.520 Payas Parab: Those blue wave. Specifically right? We were like looking at like the blue wave
44 00:07:39.390 ⇒ 00:07:41.229 Payas Parab: we filtered for that customer.
45 00:07:44.160 ⇒ 00:07:46.139 Bo Yoon: A name or a search name.
46 00:07:46.820 ⇒ 00:07:58.500 Payas Parab: Like when we were cause. I I just remember, like what I’m trying to remember is like the action item, part of like this discovery process was like, let’s take a customer. Let’s try and like, trace them through the data and like what they’re looking at. And I believe we looked at like
47 00:07:58.790 ⇒ 00:07:59.860 Payas Parab: blue wave.
48 00:08:02.280 ⇒ 00:08:14.180 Bo Yoon: Yeah, we’re we’re looking at Blue Wave. But but that blue wave is most of their orders are back in 2023. So I thought it would be better to look at the the most recent ones
49 00:08:14.500 ⇒ 00:08:16.389 Bo Yoon: for 2024.
50 00:08:16.860 ⇒ 00:08:18.060 Payas Parab: Since they
51 00:08:19.830 ⇒ 00:08:21.760 Bo Yoon: They? They started to
52 00:08:22.470 ⇒ 00:08:28.480 Bo Yoon: and pull parts to go, started to buy from Asia directly starting from 2024. I believe.
53 00:08:28.480 ⇒ 00:08:37.589 Payas Parab: Also like getting in touch with Ian more frequently, maybe, to explain some of these kind of stuff right? From all that I heard about Dan Oops.
54 00:08:37.799 ⇒ 00:08:38.879 Nicolas Sucari: We’re hearing. Yeah.
55 00:08:41.419 ⇒ 00:08:43.869 Payas Parab: I’m hearing myself. That’s crazy.
56 00:08:44.227 ⇒ 00:08:45.299 Uttam Kumaran: Was looking at.
57 00:08:45.300 ⇒ 00:08:47.520 Payas Parab: I was just looking at my fireflies, notes for the last.
58 00:08:47.520 ⇒ 00:08:51.649 Uttam Kumaran: I was like, we discussed yeah. Apologies. Nico. Sorry. So.
59 00:08:52.508 ⇒ 00:08:54.020 Nicolas Sucari: No problem. That’s fine.
60 00:08:54.200 ⇒ 00:08:56.590 Payas Parab: I’m just. I’m just reviewing like we had that work.
61 00:08:58.780 ⇒ 00:08:59.390 Nicolas Sucari: You’re on mute now.
62 00:08:59.390 ⇒ 00:09:00.130 Bo Yoon: Permit.
63 00:09:00.130 ⇒ 00:09:00.930 Nicolas Sucari: Lost. You? Yeah.
64 00:09:00.930 ⇒ 00:09:10.340 Payas Parab: Yeah, yeah, I’m just trying to review what? Like our cause, we looked at like the customer. That’s where we discovered that like $77 freight thing that was for blue wave. Specifically. So it’s like.
65 00:09:10.500 ⇒ 00:09:18.100 Payas Parab: I just remember, like the homework was, Hey, let’s look at specific clients and understand the relationship of kind of what happens and the ones we looked at
66 00:09:18.250 ⇒ 00:09:20.389 Payas Parab: or blue wave specifically.
67 00:09:24.130 ⇒ 00:09:28.420 Nicolas Sucari: But out of those ones are blue waves. I don’t know if all of those is blue waves right?
68 00:09:29.520 ⇒ 00:09:31.359 Nicolas Sucari: Because you have name. You see.
69 00:09:31.610 ⇒ 00:09:32.250 Payas Parab: Yeah, this is.
70 00:09:32.540 ⇒ 00:09:33.100 Nicolas Sucari: What?
71 00:09:33.840 ⇒ 00:09:40.450 Payas Parab: This is all of them. Yeah, we looked at it like in aggregate. But I just like my. My main thing was like, I remember, we looked at a specific case study
72 00:09:41.360 ⇒ 00:09:46.610 Payas Parab: like the flow of orders for blue waves, specifically.
73 00:09:47.780 ⇒ 00:10:02.690 Nicolas Sucari: I think what we did here with the colors that Bo was trying was just like matching like when we have like a freight cost or a tariff cost. After a set of of different orders. Right, Bo.
74 00:10:03.650 ⇒ 00:10:05.580 Bo Yoon: Yeah, yeah, that’s right.
75 00:10:05.580 ⇒ 00:10:09.999 Nicolas Sucari: And then of the client like we, we try to match, like the containers that they were sending right.
76 00:10:10.870 ⇒ 00:10:17.480 Bo Yoon: Yeah. So so the question will be, is everything from here going to this container here?
77 00:10:19.660 ⇒ 00:10:21.643 Bo Yoon: We also have to.
78 00:10:22.390 ⇒ 00:10:26.780 Bo Yoon: I mean, there, there’s gotta be a way to match the terrors to the container.
79 00:10:27.670 ⇒ 00:10:32.289 Bo Yoon: Because there isn’t there’s nothing on the Memo part here
80 00:10:32.460 ⇒ 00:10:39.199 Bo Yoon: and there are there are a lot of lines for only clarifications, for example, the package design
81 00:10:39.870 ⇒ 00:10:42.780 Bo Yoon: for which product are are they paying this for?
82 00:10:43.220 ⇒ 00:10:44.290 Bo Yoon: And
83 00:10:44.830 ⇒ 00:10:54.110 Bo Yoon: a lot of the cleanups here doesn’t really make sense so really large amount. So we’ll have to get clarification on this as well.
84 00:10:55.000 ⇒ 00:10:57.530 Payas Parab: Sure that that one might be an Ian question. Ultimately.
85 00:10:57.530 ⇒ 00:10:58.829 Bo Yoon: And the end question, okay.
86 00:10:58.830 ⇒ 00:11:06.490 Payas Parab: Potentially. Yeah. But just one thing, too, before. And Nico, do you want to ping, Dan, do you want to just like, do like a 1 off email to him is be like, now, still work with the link
87 00:11:06.690 ⇒ 00:11:11.149 Payas Parab: I I just like, and maybe just to send it directly to him. No need to like CC. Anyone.
88 00:11:11.610 ⇒ 00:11:12.240 Nicolas Sucari: Yeah.
89 00:11:15.860 ⇒ 00:11:21.926 Payas Parab: And then, Bo, do you just remember the colors that you have here like what each one of them stands for? Maybe just have that ready.
90 00:11:22.160 ⇒ 00:11:25.149 Bo Yoon: The the yellow is yellow is going to be.
91 00:11:26.240 ⇒ 00:11:28.620 Payas Parab: Great yellow is freight.
92 00:11:32.240 ⇒ 00:11:35.159 Bo Yoon: Yeah, yellow should be one second
93 00:11:38.260 ⇒ 00:11:39.510 Bo Yoon: workload.
94 00:12:03.090 ⇒ 00:12:06.609 Uttam Kumaran: He said, I just texted him, he said, push it tomorrow.
95 00:12:08.220 ⇒ 00:12:08.970 Bo Yoon: Tomorrow.
96 00:12:10.615 ⇒ 00:12:13.350 Uttam Kumaran: Just like recovered today, or something.
97 00:12:15.960 ⇒ 00:12:16.690 Payas Parab: Cool.
98 00:12:17.930 ⇒ 00:12:21.220 Bo Yoon: Okay. Then maybe we can just spend this time to to talk about.
99 00:12:21.220 ⇒ 00:12:24.450 Uttam Kumaran: Yeah, yeah, let’s just get through whatever we need to get through still.
100 00:12:24.660 ⇒ 00:12:25.750 Uttam Kumaran: And then
101 00:12:29.880 ⇒ 00:12:32.800 Uttam Kumaran: I mean same time tomorrow it probably just be me.
102 00:12:33.430 ⇒ 00:12:34.090 Nicolas Sucari: Okay.
103 00:12:35.390 ⇒ 00:12:36.350 Bo Yoon: Okay. Sure.
104 00:12:36.350 ⇒ 00:12:36.910 Payas Parab: Yep.
105 00:12:39.780 ⇒ 00:12:44.699 Bo Yoon: Okay. So so the so the yellow ones are here that the freight costs.
106 00:12:44.700 ⇒ 00:12:47.419 Payas Parab: Yeah, yellow is free. Green is tariff.
107 00:12:47.920 ⇒ 00:12:53.388 Bo Yoon: Yeah, so on the account column, it says freight cost. But
108 00:12:54.140 ⇒ 00:12:57.060 Bo Yoon: I mean this one says great for all of them.
109 00:12:58.071 ⇒ 00:13:06.079 Bo Yoon: This one it only says freight costs on the account section nothing really on the on the memo, or anything.
110 00:13:06.750 ⇒ 00:13:12.379 Bo Yoon: But they’re both I think, paying to z the U.S.A.
111 00:13:12.380 ⇒ 00:13:14.490 Payas Parab: I’m guessing some type of fulfillment.
112 00:13:15.360 ⇒ 00:13:17.930 Payas Parab: Yep, I bet you we could even look it up.
113 00:13:17.930 ⇒ 00:13:18.700 Bo Yoon: And.
114 00:13:20.740 ⇒ 00:13:24.620 Payas Parab: Zd, logistics. U.S.A, inc, maybe.
115 00:13:27.250 ⇒ 00:13:41.370 Payas Parab: Okay. So then that’s like, we think that all of these go into like a container all at once the individual products and skews. We have the cost. Here. We have some adjustments here that may be accounting questions that we just fire off to Ian.
116 00:13:42.180 ⇒ 00:13:48.650 Bo Yoon: Yeah, like, like, this kind of freight costs. They’re too low to be considered. Actually.
117 00:13:50.850 ⇒ 00:13:55.950 Bo Yoon: it’s only 6, 57, or 3 plus doesn’t make sense.
118 00:14:12.980 ⇒ 00:14:16.900 Bo Yoon: and and we still got to present some ideas for some new.
119 00:14:16.900 ⇒ 00:14:17.940 Payas Parab: Yeah, yeah, yes.
120 00:14:17.940 ⇒ 00:14:22.580 Payas Parab: I need to like, do my like 2 to 3 h sprint, though? Did you get a chance to do that with yours?
121 00:14:22.910 ⇒ 00:14:28.659 Bo Yoon: No, not yet. I just downloaded the the sand.
122 00:14:28.660 ⇒ 00:14:33.510 Payas Parab: Yeah, the the goal is just like me and you individually just go through it for 2 to 3 h exploring, and then.
123 00:14:33.510 ⇒ 00:14:33.960 Bo Yoon: Alright!
124 00:14:33.960 ⇒ 00:14:45.810 Payas Parab: Try and get that like 2 sentence deliverable to Dan. I’m gonna work on mine tonight, too, with discounts and everything, and we’ll just we’ll just like review it together tomorrow. So we can like, be like, Okay, cool. We have 2 different ideas. We’ve done.
125 00:14:45.810 ⇒ 00:14:46.240 Payas Parab: Okay.
126 00:14:46.240 ⇒ 00:14:52.280 Payas Parab: And here’s like the 3 sentence elevator pitch of what we’re trying to do. In addition to the skew stuff.
127 00:14:52.680 ⇒ 00:14:57.919 Bo Yoon: Yeah, yeah, sounds good. So so before the meeting, we’ll talk about it tomorrow.
128 00:14:59.700 ⇒ 00:15:05.800 Payas Parab: Yeah, I I was even thinking we may not bring. We may not bring it up at the meeting. The goal is like, let’s keep the skew
129 00:15:05.940 ⇒ 00:15:12.109 Payas Parab: work focused. And then that 2 to 3 sentence elevator pitch. Maybe that’s just like a slack DM or an email.
130 00:15:12.110 ⇒ 00:15:12.740 Bo Yoon: Okay.
131 00:15:12.740 ⇒ 00:15:16.429 Payas Parab: Just Dan. Specifically, we we can. Nico, you
132 00:15:16.580 ⇒ 00:15:30.389 Payas Parab: would rely on you and you, Tom. Maybe together, we can like as a group, make a decision on what’s the best way to put them first.st That’s like the the 2 to 3 sentence elevator pitch bo tomorrow. The goal is you and I to figure out like, is there something here right that we can pitch them? That’s like an analysis project?
133 00:15:30.500 ⇒ 00:15:43.550 Payas Parab: Is there something meaningful there for them? And if we both align that like this one, both or one of them is like meaningful, then we sort of just like shoot it as like a maybe even like an off the cuff like slack message, you know, or.
134 00:15:43.550 ⇒ 00:15:43.990 Bo Yoon: We.
135 00:15:43.990 ⇒ 00:15:59.310 Payas Parab: Maybe it’s even like a direct. Maybe it’s like we’ll figure out the best dynamics. But let’s figure out if, like that 3 sentence elevator pitch makes sense to both of us as like, okay, this is something meaningful that would actually help them. Or is this just going to be like a random wild goose chase. We’re going to go down.
136 00:15:59.970 ⇒ 00:16:03.169 Bo Yoon: Yeah, yeah, sure. I’ll spend some time tonight as well.
137 00:16:03.170 ⇒ 00:16:03.800 Payas Parab: Cool.
138 00:16:03.800 ⇒ 00:16:08.295 Bo Yoon: Take a look. We can talk about it tomorrow, but for the
139 00:16:09.140 ⇒ 00:16:11.380 Bo Yoon: for this excel sheet I guess
140 00:16:11.740 ⇒ 00:16:16.109 Bo Yoon: the solid questions. Guess we’ll just have to talk with with Ben.
141 00:16:16.720 ⇒ 00:16:17.170 Payas Parab: Yeah.
142 00:16:17.170 ⇒ 00:16:22.770 Bo Yoon: What? What would what each of these data points mainly.
143 00:16:23.100 ⇒ 00:16:26.540 Payas Parab: Yeah, I think we have some sense, right? We’ve like sort of figured out that
144 00:16:27.600 ⇒ 00:16:34.769 Payas Parab: you have a bunch of skews. We believe that, like the source name is like some sort of a supplier right? A lot of them have like Asian names. So I’m guessing it’s some sort
145 00:16:35.260 ⇒ 00:16:37.740 Payas Parab: 1st tier, one supplier of some kind.
146 00:16:38.176 ⇒ 00:16:50.423 Payas Parab: The customer is there and then, like sort of the shipping and tariff costs are getting grouped, and we’ll likely group them by date. Right? We’ll like Chunk this into like things and like. Maybe it’s even like
147 00:16:51.590 ⇒ 00:16:58.389 Payas Parab: it’s a forward fill, like I I don’t know you could you. You know the forward fill formula right? Like you could basically do like a
148 00:16:58.700 ⇒ 00:17:06.709 Payas Parab: if container. Then, like set container id, and then like forward, fill till the next container. Id. You know what I’m saying, like we could do something like.
149 00:17:06.710 ⇒ 00:17:07.220 Bo Yoon: That.
150 00:17:07.220 ⇒ 00:17:07.859 Payas Parab: It’s like.
151 00:17:07.869 ⇒ 00:17:08.199 Bo Yoon: Yeah.
152 00:17:08.200 ⇒ 00:17:15.120 Payas Parab: A. If we think this is how it works, and same with like tariffs, right is like we can group them roughly by date.
153 00:17:15.220 ⇒ 00:17:21.010 Payas Parab: We can put together an estimate. That’s that’s, I think, is like what we might want to pitch to him. Basically.
154 00:17:21.260 ⇒ 00:17:26.499 Payas Parab: it’s like we don’t block so like like if we look green, is tariff right? And then yellow is shipping.
155 00:17:26.690 ⇒ 00:17:31.959 Payas Parab: So let’s see if we can find like a yellow and green that we can like look at specifically with him that.
156 00:17:31.960 ⇒ 00:17:42.150 Nicolas Sucari: We have the yellow. Yeah, we have. I think we have, we. We can do it with the yellow one, and also because of the rate costs like they are like much higher than the tariff and duty costs, I think.
157 00:17:42.360 ⇒ 00:17:43.660 Nicolas Sucari: Oh, it’s probably better.
158 00:17:43.660 ⇒ 00:17:50.080 Bo Yoon: Yeah. So so I think for the the main main question for this project will be how to map
159 00:17:50.250 ⇒ 00:17:54.519 Bo Yoon: each of this cost to the to the product all right, because.
160 00:17:54.520 ⇒ 00:17:55.450 Payas Parab: Shipping costs.
161 00:17:55.450 ⇒ 00:18:01.219 Bo Yoon: We’ll have to met met the the freight cost terrorist duty package design fee.
162 00:18:01.220 ⇒ 00:18:01.630 Payas Parab: Yep.
163 00:18:01.630 ⇒ 00:18:06.150 Bo Yoon: And there there might be other other things that that we haven’t catched yet. So.
164 00:18:06.550 ⇒ 00:18:08.960 Payas Parab: I mean, I think this is most of it right. I think this is.
165 00:18:08.960 ⇒ 00:18:10.020 Bo Yoon: Yeah, yeah, yeah, yeah, sure.
166 00:18:10.020 ⇒ 00:18:13.190 Payas Parab: The memo has, like a description of a.
167 00:18:13.580 ⇒ 00:18:21.459 Payas Parab: Thing that tells me it’s a skew, right? It’s just these other things. How do we attribute these yellow and green lines to the rest of them. I think we just pay
168 00:18:21.460 ⇒ 00:18:21.860 Payas Parab: exactly.
169 00:18:21.860 ⇒ 00:18:32.059 Payas Parab: And we’re gonna use date like as like a like, it’s gonna find the latest shipment. And it’s just gonna like forward fill like that’s my viewpoint is like, okay, can.
170 00:18:32.260 ⇒ 00:18:38.640 Payas Parab: For let let can you find like a yellow and green or yellow row that’s like close to another green one that, like we can
171 00:18:38.810 ⇒ 00:18:41.980 Payas Parab: look at like close.
172 00:18:42.386 ⇒ 00:18:44.420 Bo Yoon: Close to green. One. Yeah.
173 00:18:44.420 ⇒ 00:18:51.239 Payas Parab: Yeah, so like. And let’s just let’s check if these are like large like, are they like large transactions that they’re probably for many skews.
174 00:18:51.640 ⇒ 00:18:54.149 Payas Parab: Yeah, $9,000 for shipping
175 00:18:54.310 ⇒ 00:18:57.439 Payas Parab: $1,200 for tariffs. Right?
176 00:18:57.910 ⇒ 00:19:04.770 Payas Parab: So we would tie that like this yellow and green. What would we tie? That also blue is there as well, which is a duty.
177 00:19:05.200 ⇒ 00:19:05.680 Nicolas Sucari: Yeah.
178 00:19:05.680 ⇒ 00:19:10.010 Bo Yoon: Hello! Is his duty right? What is it?
179 00:19:10.010 ⇒ 00:19:10.540 Payas Parab: Yeah, blue.
180 00:19:10.540 ⇒ 00:19:10.890 Bo Yoon: Oh, yeah.
181 00:19:13.330 ⇒ 00:19:17.210 Payas Parab: Got it. So yeah. And then it looks like
182 00:19:17.490 ⇒ 00:19:24.959 Payas Parab: one of them’s negative. We would just flip it positive, right? I like I I the there wouldn’t be a negative tariff. I don’t think right.
183 00:19:24.960 ⇒ 00:19:27.299 Nicolas Sucari: And all targets are negative. If you check, like the.
184 00:19:27.730 ⇒ 00:19:28.380 Payas Parab: From there.
185 00:19:29.320 ⇒ 00:19:32.419 Nicolas Sucari: Yeah, or that’s what I could see. The other one there.
186 00:19:32.420 ⇒ 00:19:43.950 Payas Parab: Okay? So if all tariffs are negative, then that like, let’s just note these down. So row 5, 8, 8, 1, 5, 8, 9 0. We would attribute this tariff and this freight to
187 00:19:45.190 ⇒ 00:19:51.809 Payas Parab: like what rows. Basically, that’s what I’m trying to like. Figure out is like, what is our proposal for like what we’re gonna attribute those to.
188 00:19:54.680 ⇒ 00:20:02.430 Nicolas Sucari: Can you check the dates of those tariff duty and the next like? More closed freight date.
189 00:20:02.620 ⇒ 00:20:06.599 Nicolas Sucari: You have duty on the 14th of November 15.th
190 00:20:06.600 ⇒ 00:20:11.380 Bo Yoon: This is all in and date order, assignment.
191 00:20:11.380 ⇒ 00:20:20.719 Nicolas Sucari: Okay? Yeah, that’s why. So you have 2 2 freight costs there, like one on 7 of November. And yeah, the next one on 19th of November, right the 2 yellow ones.
192 00:20:20.720 ⇒ 00:20:21.380 Payas Parab: You know.
193 00:20:21.380 ⇒ 00:20:28.460 Nicolas Sucari: Have in in the middle. You have the 2, the tariff and the duty. So maybe we need to ask if tariff and duty are paid before or
194 00:20:28.570 ⇒ 00:20:34.629 Nicolas Sucari: after the freight costs or the invoice comes. And that’s how we can match and understand like
195 00:20:35.130 ⇒ 00:20:37.630 Nicolas Sucari: how to build up that container cost right.
196 00:20:37.630 ⇒ 00:20:38.350 Payas Parab: Yep.
197 00:20:38.550 ⇒ 00:20:39.210 Bo Yoon: Okay.
198 00:20:39.420 ⇒ 00:20:45.249 Nicolas Sucari: And that’s what you’re saying. Right, payoff like. Once we identify this like, we need to fill in with all of these queues.
199 00:20:45.250 ⇒ 00:20:45.640 Payas Parab: Exactly.
200 00:20:45.640 ⇒ 00:20:52.639 Nicolas Sucari: That we have inside, so that we can attribute that cost of freight to all of those lines of those queues, costs.
201 00:20:52.640 ⇒ 00:21:03.939 Payas Parab: Exactly. Exactly. So I think we should use this example. We have like, let’s just note down. So the tariff online, I’m going to write these in in slack, real quick. But so the tariff online, what line is it? Bo?
202 00:21:05.540 ⇒ 00:21:08.890 Bo Yoon: If this is 5, 8, 8, 1.
203 00:21:09.100 ⇒ 00:21:10.509 Payas Parab: 5, 8, 8, 1.
204 00:21:11.000 ⇒ 00:21:13.440 Nicolas Sucari: And you have judium. 5, 8, 7, 9.
205 00:21:13.980 ⇒ 00:21:17.659 Payas Parab: 5, 8, 8. 1 duty is on 5, 8, 7, 9.
206 00:21:17.980 ⇒ 00:21:18.610 Bo Yoon: Oh, yeah.
207 00:21:20.020 ⇒ 00:21:22.110 Payas Parab: And then the freight is on.
208 00:21:24.820 ⇒ 00:21:26.430 Nicolas Sucari: Paid 90.
209 00:21:26.840 ⇒ 00:21:29.309 Payas Parab: 5, 8, 90, okay? And so.
210 00:21:29.310 ⇒ 00:21:31.590 Nicolas Sucari: You have one before, too. Yeah, if you wanna check.
211 00:21:31.590 ⇒ 00:21:36.619 Payas Parab: And that one of the date is 1119. I think it was.
212 00:21:37.180 ⇒ 00:21:39.020 Payas Parab: Yeah, what date.
213 00:21:40.290 ⇒ 00:21:42.670 Nicolas Sucari: Can you go? Go to the left here.
214 00:21:42.670 ⇒ 00:21:43.300 Payas Parab: Thank you.
215 00:21:44.090 ⇒ 00:21:45.890 Payas Parab: 1119, 24.
216 00:21:45.890 ⇒ 00:21:47.009 Nicolas Sucari: 1119 yeah.
217 00:21:47.010 ⇒ 00:21:55.939 Payas Parab: So our assumption right now with this like this batch right is that everything between 5, 8, 90 and the previous ship
218 00:21:56.110 ⇒ 00:21:58.959 Payas Parab: is likely all attributed together the duty.
219 00:21:59.630 ⇒ 00:22:16.369 Payas Parab: the tariff that’s our assumption we’d have to check. Does that sound right right like, do they, bill for the tariffs later, do they, bill for during it like. But I think we should just look at like these set of rows. So we know that the last freight cost was on what was the date? 11, 7.
220 00:22:17.760 ⇒ 00:22:19.880 Bo Yoon: Yes, 11 min, 11 7.
221 00:22:19.880 ⇒ 00:22:24.270 Payas Parab: So our proposal is like grouping all of the skews.
222 00:22:26.540 ⇒ 00:22:30.619 Payas Parab: and that would be from row. What row was the last freight at.
223 00:22:31.770 ⇒ 00:22:33.280 Nicolas Sucari: 5, 8, 5, 6.
224 00:22:33.280 ⇒ 00:22:39.149 Payas Parab: 5, 8, 5, 6. So our proposal would be is that all of the skews between
225 00:22:39.550 ⇒ 00:22:45.379 Payas Parab: 5, 8, 5, 6 would be attributed to the container on 1119.
226 00:22:47.810 ⇒ 00:22:48.420 Bo Yoon: Yeah.
227 00:22:48.900 ⇒ 00:22:55.009 Payas Parab: Container on 1119, and we would include
228 00:22:56.140 ⇒ 00:23:00.400 Payas Parab: the tariff and duties that are in those rows for them.
229 00:23:06.580 ⇒ 00:23:07.739 Payas Parab: Does that make sense.
230 00:23:08.070 ⇒ 00:23:13.429 Bo Yoon: Yeah, yeah, that makes sense. So so let’s just look at a at another case here.
231 00:23:14.290 ⇒ 00:23:20.310 Bo Yoon: So if our assumption is right, then everything from here to the next one
232 00:23:20.970 ⇒ 00:23:24.400 Bo Yoon: going to be right here. 3 plus
233 00:23:25.339 ⇒ 00:23:30.919 Bo Yoon: yeah. Maybe this one. Because yeah, the one above doesn’t really make sense.
234 00:23:31.250 ⇒ 00:23:41.103 Bo Yoon: But in here. There’s no, there’s no tariff, there’s no production design. There’s only beauty.
235 00:23:42.370 ⇒ 00:23:44.439 Bo Yoon: Which is this line here.
236 00:23:46.910 ⇒ 00:23:54.900 Bo Yoon: And I don’t know. Maybe something odd will be this one the the Commission Exchange fee.
237 00:23:56.110 ⇒ 00:23:56.650 Payas Parab: Hmm.
238 00:23:57.050 ⇒ 00:23:58.620 Bo Yoon: Oh, shit.
239 00:23:59.160 ⇒ 00:24:03.029 Payas Parab: Yeah, that one’s just like a sus like, I don’t know what that is, but it’s huge. So.
240 00:24:03.500 ⇒ 00:24:04.539 Nicolas Sucari: Yeah, 20,000.
241 00:24:04.540 ⇒ 00:24:10.160 Bo Yoon: No, there’s okay. And look, yeah, this.
242 00:24:11.170 ⇒ 00:24:13.740 Bo Yoon: Yeah, that’s it for dispatch. I guess
243 00:24:14.060 ⇒ 00:24:18.300 Bo Yoon: the cleanup costs here. And let’s look at the other one
244 00:24:19.140 ⇒ 00:24:23.300 Bo Yoon: another. Free cost is 22. Ignore this.
245 00:24:23.300 ⇒ 00:24:25.490 Payas Parab: Yeah, we’re gonna ignore the small ones. Let’s find the.
246 00:24:26.116 ⇒ 00:24:29.249 Bo Yoon: The big one would be.
247 00:24:30.770 ⇒ 00:24:31.220 Payas Parab: Here.
248 00:24:32.400 ⇒ 00:24:33.330 Payas Parab: Yeah.
249 00:24:33.330 ⇒ 00:24:41.999 Payas Parab: which actually makes sense like, there’s a lot of rows right there. But that freight cost is like 29,000, like, it was like a month like that. That last freight cost.
250 00:24:42.150 ⇒ 00:24:42.890 Bo Yoon: Okay.
251 00:24:42.890 ⇒ 00:24:52.350 Payas Parab: Was 29,000 on row 6,001, right? So another example, right is like, I’m gonna write these out. So on row 6,001.
252 00:24:53.820 ⇒ 00:24:57.366 Payas Parab: We have a 29 K. Freight expense, right?
253 00:24:58.460 ⇒ 00:25:00.160 Payas Parab: And what was the date on that.
254 00:25:01.180 ⇒ 00:25:04.129 Bo Yoon: The date, December 23.rd
255 00:25:04.690 ⇒ 00:25:11.029 Payas Parab: December 23, rd so the next one was
256 00:25:14.120 ⇒ 00:25:17.890 Payas Parab: the next freight cost. After that the 23.rd
257 00:25:18.996 ⇒ 00:25:22.659 Bo Yoon: The next free cost would be this one here.
258 00:25:23.300 ⇒ 00:25:24.299 Nicolas Sucari: The 9,000.
259 00:25:24.300 ⇒ 00:25:26.189 Payas Parab: 6,097, okay.
260 00:25:29.646 ⇒ 00:25:31.549 Payas Parab: 6,097.
261 00:25:31.880 ⇒ 00:25:33.819 Bo Yoon: Yeah, I mean, I I can’t really.
262 00:25:34.220 ⇒ 00:25:39.959 Bo Yoon: For these 3 cases we can’t really find a pattern right? Like a like a solid pattern.
263 00:25:40.930 ⇒ 00:25:47.879 Payas Parab: Yeah, I mean, I mean in in like, basically in all those rows, there’s a bunch of skew ones. And then there’s some duties in there
264 00:25:48.090 ⇒ 00:25:48.740 Payas Parab: right.
265 00:25:48.740 ⇒ 00:25:53.360 Bo Yoon: Yeah, I mean, there are 2 duties here in this batch.
266 00:25:53.970 ⇒ 00:25:57.450 Payas Parab: It’s possible, because there’s like multiple containers, right? Like, if I look at.
267 00:25:57.690 ⇒ 00:25:58.230 Nicolas Sucari: Yeah.
268 00:25:58.230 ⇒ 00:26:03.829 Payas Parab: That giant freight, one in the memo. There’s like 3. There’s like 3 ids of some kind. Do you see that.
269 00:26:03.830 ⇒ 00:26:06.929 Nicolas Sucari: So listen what I was thinking. Maybe it’s more than one container. Maybe.
270 00:26:06.930 ⇒ 00:26:09.100 Payas Parab: Yeah, that might be 3 containers, right? And that’s like.
271 00:26:09.100 ⇒ 00:26:09.640 Nicolas Sucari: Yeah.
272 00:26:09.640 ⇒ 00:26:12.320 Payas Parab: Like, is this 3 containers? Right?
273 00:26:12.850 ⇒ 00:26:14.240 Nicolas Sucari: 4. Yeah, something like that.
274 00:26:14.240 ⇒ 00:26:18.359 Payas Parab: Found 2 duties. We also found no tariffs right.
275 00:26:18.360 ⇒ 00:26:18.960 Nicolas Sucari: Yeah.
276 00:26:19.360 ⇒ 00:26:25.079 Payas Parab: But could we group all those skews and align it to the
277 00:26:26.570 ⇒ 00:26:45.369 Payas Parab: to those to that 29 K. Freight cost right? And that’s about 100 rows of data which, like, let’s assume there’s a bunch of weird shit in there like that’s 50 to 60 skews, right? Which they would have packed into one or 3 containers, so we could split that cost of those 3 containers across those 60 Skus. In theory.
278 00:26:47.210 ⇒ 00:26:50.590 Bo Yoon: Yes, that would be a there’ll be a good assumption.
279 00:26:50.960 ⇒ 00:26:55.480 Payas Parab: Yes, and then we could add a group where it’s like we also include the customer name. So then you have, like
280 00:26:55.960 ⇒ 00:26:58.460 Payas Parab: the amount of shipping per customer.
281 00:26:58.460 ⇒ 00:26:59.080 Bo Yoon: You know.
282 00:27:00.070 ⇒ 00:27:02.699 Payas Parab: Then total skew cost plus the
283 00:27:03.870 ⇒ 00:27:14.270 Payas Parab: like, the cost of all those containers. That’s basically how we’re thinking about this right? It’s like we just need to create between containers. We need to create logical groupings of like from one shipment to the other.
284 00:27:14.400 ⇒ 00:27:20.440 Payas Parab: We need to figure out like what things were packed into that right? Is it the stuff before, or is it the stuff after? That’s like a quick question.
285 00:27:20.440 ⇒ 00:27:20.760 Nicolas Sucari: Exactly.
286 00:27:20.760 ⇒ 00:27:25.220 Payas Parab: Like, do you get billed before? Do you get billed? After that would answer that question right? Is like
287 00:27:27.250 ⇒ 00:27:33.549 Payas Parab: for a container container. Do you get billed before or after?
288 00:27:36.920 ⇒ 00:27:43.000 Payas Parab: And then like? Are is there situations where there’s no tariffs right like tariffs and duties? Is it always there.
289 00:27:44.500 ⇒ 00:27:45.139 Bo Yoon: No.
290 00:27:46.140 ⇒ 00:27:49.899 Payas Parab: No, that like, that’s what the data says. But we need to confirm with him. Right? Like, that’s my.
291 00:27:49.900 ⇒ 00:27:50.790 Payas Parab: yeah. Yeah.
292 00:27:50.790 ⇒ 00:28:02.760 Payas Parab: like, I’m, I wanna ask him is like, are there always tariffs? Because we have in our example, which is row 6,000 to 6,009, 6,097. There are no tariffs. There’s only duties.
293 00:28:03.160 ⇒ 00:28:08.689 Bo Yoon: Yeah. And suddenly there’s 30 in the in the net. In the last.
294 00:28:08.690 ⇒ 00:28:10.360 Payas Parab: Then suddenly, there’s 3.
295 00:28:10.700 ⇒ 00:28:11.300 Bo Yoon: Hmm.
296 00:28:11.300 ⇒ 00:28:17.870 Payas Parab: And then what if that was the case? What would we attribute that one to? Well, that was on the the last day of the year, so.
297 00:28:18.400 ⇒ 00:28:19.380 Bo Yoon: Yeah.
298 00:28:19.500 ⇒ 00:28:25.220 Bo Yoon: May-, maybe something related to this, the source, name and domain.
299 00:28:26.000 ⇒ 00:28:27.449 Payas Parab: Like my my view on like how
300 00:28:27.950 ⇒ 00:28:40.800 Payas Parab: like they? They ask for a container. Then they get customer orders, and they jam as much as many customer skews into that fucking container, and then, I I assume later
301 00:28:41.130 ⇒ 00:28:50.029 Payas Parab: you get billed after you like. I assume you pay for the container upfront right. I assume they don’t like container unless you like like, especially like it’s an invoice. So like the date would be like.
302 00:28:50.590 ⇒ 00:28:53.580 Payas Parab: maybe it’s the date it shipped, or it’s like a pre order we have to ask.
303 00:28:54.460 ⇒ 00:29:00.870 Payas Parab: Then the assumption is after that, when it gets shipped and it like hits the Us. Border, or whatever border.
304 00:29:01.010 ⇒ 00:29:02.039 Payas Parab: Then you pay.
305 00:29:02.260 ⇒ 00:29:02.700 Nicolas Sucari: Do this.
306 00:29:02.700 ⇒ 00:29:06.100 Payas Parab: You pay the duties you pay the tariffs right, then.
307 00:29:06.100 ⇒ 00:29:06.710 Bo Yoon: Hi, Steve!
308 00:29:06.710 ⇒ 00:29:09.040 Payas Parab: I think the order would be like shipment
309 00:29:09.270 ⇒ 00:29:23.440 Payas Parab: duties, tariffs, and then a shit ton of skews in there, and if we could like, group them logically right? Like, it’s like you would basically have like shipment can shipment order shipment id, and then you would forward, fill that until you find the next shipment id
310 00:29:24.177 ⇒ 00:29:41.109 Payas Parab: like the next yellow row right? And then everything in between. You’re like, let’s grab all those skews. Let’s grab all of those things. Let’s grab all the customers. And now we know each shipping container, what customers were covered, what skews they packed in there, and what the cost of shipping that thing was.
311 00:29:41.460 ⇒ 00:29:42.979 Payas Parab: yeah. And then we can bring in.
312 00:29:42.980 ⇒ 00:29:49.420 Payas Parab: Divide it out. That that’s sort of the approach we’re taking. And I think we have 2 concrete examples. We can walk Dan through with the spreadsheet. Open.
313 00:29:49.915 ⇒ 00:29:55.900 Payas Parab: These like later ones that you found bo dude. Thank you for color coding. This dude. This helps so much.
314 00:29:56.050 ⇒ 00:29:56.680 Payas Parab: It’s like.
315 00:29:56.680 ⇒ 00:29:57.210 Bo Yoon: Oh, no! Worries!
316 00:29:57.210 ⇒ 00:29:58.029 Bo Yoon: I didn’t even think.
317 00:29:58.460 ⇒ 00:30:00.570 Payas Parab: Barcode it like that. That’s brilliant.
318 00:30:01.455 ⇒ 00:30:07.230 Bo Yoon: Alright, thanks, I think my assumption is this here Olympia.
319 00:30:09.210 ⇒ 00:30:10.879 Payas Parab: Terry for Olympia.
320 00:30:11.580 ⇒ 00:30:12.270 Bo Yoon: Yeah.
321 00:30:13.149 ⇒ 00:30:18.189 Bo Yoon: So maybe they’re charging this service to Olympia on
322 00:30:18.720 ⇒ 00:30:22.390 Bo Yoon: for this here, because, you see, there’s also.
323 00:30:22.570 ⇒ 00:30:23.400 Payas Parab: Yep.
324 00:30:23.550 ⇒ 00:30:28.189 Bo Yoon: There’s also for discount pools. But they’re switching.
325 00:30:28.190 ⇒ 00:30:32.210 Nicolas Sucari: But you don’t have you don’t have for the other ones, for all PIN or for.
326 00:30:32.210 ⇒ 00:30:35.730 Payas Parab: Situations where it’s just? Are there situations where there’s no.
327 00:30:36.280 ⇒ 00:30:39.630 Bo Yoon: No, I’ll PIN. I’ll PIN his charge here. This on the left.
328 00:30:39.630 ⇒ 00:30:40.540 Nicolas Sucari: Oh, okay.
329 00:30:40.540 ⇒ 00:30:41.882 Payas Parab: Us customs tariff
330 00:30:42.330 ⇒ 00:30:47.179 Bo Yoon: So. So maybe your assumption is right. They are charged like a few weeks after, or
331 00:30:47.510 ⇒ 00:30:49.100 Bo Yoon: they arrive to the end.
332 00:30:49.100 ⇒ 00:31:02.129 Payas Parab: The question, then right is like, what costs are offloaded to the customer. Right is that is, that here is, we have a negative value for tariffs is that being when we see a negative value, and we see a customer name
333 00:31:02.830 ⇒ 00:31:04.590 Payas Parab: in the memo. Right?
334 00:31:05.680 ⇒ 00:31:08.799 Payas Parab: Does that mean the cost was offloaded to the customer.
335 00:31:10.050 ⇒ 00:31:12.227 Payas Parab: or is that just for like tracking right.
336 00:31:13.340 ⇒ 00:31:18.079 Bo Yoon: Yeah. So so maybe for ace, here, for example, this will
337 00:31:19.270 ⇒ 00:31:22.110 Bo Yoon: there’s gotta be a charge in 2025, I guess.
338 00:31:22.240 ⇒ 00:31:24.819 Nicolas Sucari: Yeah, maybe if that was after. Yeah.
339 00:31:24.820 ⇒ 00:31:25.240 Bo Yoon: Yeah.
340 00:31:26.240 ⇒ 00:31:36.490 Payas Parab: Yeah. But this is, this is good. I think this is like, we have a concrete example that we can look through and like, walk us through that right. Our assumption is pack that container bunch of duties and tariffs go in.
341 00:31:36.610 ⇒ 00:31:55.099 Payas Parab: We see that they’re attributed to customers. So is that like, are you giving that to the customer or not? Or is that just like a way for you to document it? And we should consider that part of your landed cost. And then, like all of that, we now know per container. How many skews went into it, how much, how much product were you able to ship with that container.
342 00:31:55.580 ⇒ 00:32:02.239 Payas Parab: And then you’re we’re able to go back and then be like, okay, cool like per product. This cost you this much in shipping right.
343 00:32:03.290 ⇒ 00:32:03.850 Nicolas Sucari: Yeah.
344 00:32:04.960 ⇒ 00:32:22.220 Payas Parab: Yes, okay, excellent. Okay. I think we have a good grasp of this. I think this is just like something. We gotta hammer out with him, and he’ll be like, Yeah, like, you know, is the provider whatever. Okay, that’s a customer. Okay, yeah, that makes sense, or he’ll be like the order. You have the order wrong, right? He like, maybe we pay for the containers later, right? Or it’s like
345 00:32:22.550 ⇒ 00:32:27.469 Payas Parab: whatever we’ll figure that out with him. But I think we have a really good sense going in. So I feel good about this.
346 00:32:28.920 ⇒ 00:32:30.020 Bo Yoon: Yeah for
347 00:32:30.690 ⇒ 00:32:34.909 Bo Yoon: I’ll take a spend a little bit more time on this spreadsheet.
348 00:32:35.170 ⇒ 00:32:38.650 Payas Parab: Yeah. And this, this is one where I think it’s like, it’s good. It’s a group effort, because, like.
349 00:32:38.650 ⇒ 00:32:39.000 Bo Yoon: Yeah.
350 00:32:39.000 ⇒ 00:32:42.509 Payas Parab: There’s no way any one of us could have figured all this out alone. But there’s no way
351 00:32:42.510 ⇒ 00:32:46.360 Payas Parab: yeah, alright cool guys.
352 00:32:46.850 ⇒ 00:32:48.739 Payas Parab: Alright. We’ll talk tomorrow. Then.
353 00:32:49.350 ⇒ 00:32:50.459 Bo Yoon: Yeah, let me send you.
354 00:32:50.820 ⇒ 00:32:52.179 Bo Yoon: I should just in case.
355 00:32:52.180 ⇒ 00:32:54.690 Payas Parab: Yeah, cause you should be circulate that in the chat. Thank you.
356 00:32:55.040 ⇒ 00:33:00.653 Bo Yoon: Yeah, alright, yeah. I’ll see you guys tomorrow. Then
357 00:33:00.910 ⇒ 00:33:02.009 Payas Parab: See you bye.
358 00:33:02.800 ⇒ 00:33:03.450 Nicolas Sucari: Bye, bye.