Meeting Title: COGS sync Date: 2025-07-21 Meeting participants: Rebecca, Demilade Agboola
WEBVTT
1 00:00:34.230 ⇒ 00:00:35.430 Demilade Agboola: Hi! Rebecca!
2 00:00:36.120 ⇒ 00:00:37.339 Rebecca: Hey! How are you?
3 00:00:37.920 ⇒ 00:00:39.249 Demilade Agboola: I’m doing well. How are you?
4 00:00:39.820 ⇒ 00:00:40.890 Rebecca: Doing, good.
5 00:00:41.761 ⇒ 00:00:49.710 Demilade Agboola: So just a heads up. I lost my voice over the weekend. It’s partially back, but my voice might randomly like trail off.
6 00:00:50.350 ⇒ 00:00:51.980 Rebecca: Oh, I’m sorry! Are you saying.
7 00:00:51.980 ⇒ 00:00:52.530 Demilade Agboola: Okay.
8 00:00:53.489 ⇒ 00:01:02.349 Demilade Agboola: I mean, I traveled to Berlin, and there was just a lot of like smoke in the air. It just felt like the air just felt very uncomfortable, and I think he like messed up my throat.
9 00:01:02.790 ⇒ 00:01:05.006 Rebecca: Oh, yep, I can imagine.
10 00:01:07.416 ⇒ 00:01:12.179 Demilade Agboola: But it. So I actually wanted to check in on 2 things.
11 00:01:13.268 ⇒ 00:01:20.309 Demilade Agboola: So the 1st thing is about the Booth wing request and wanting to have the file sizes.
12 00:01:21.104 ⇒ 00:01:22.589 Demilade Agboola: and quantity shipped.
13 00:01:24.699 ⇒ 00:01:27.699 Demilade Agboola: I know, like Annie has sent you
14 00:01:28.513 ⇒ 00:01:32.509 Demilade Agboola: a Csv containing that. I was wondering if that has been useful.
15 00:01:33.099 ⇒ 00:01:35.399 Demilade Agboola: If you build to use that. Okay.
16 00:01:35.600 ⇒ 00:01:46.645 Rebecca: Yes, that is sufficient for like all intents and purposes right now. So I think that we should be okay on that request, and also, too, with
17 00:01:47.240 ⇒ 00:01:58.959 Rebecca: moving forward. We have some new variants added for some new pharmacies, so you probably need me to put in the vial sizes for those as well, I would assume, correct.
18 00:01:59.580 ⇒ 00:02:00.730 Demilade Agboola: Yes.
19 00:02:01.460 ⇒ 00:02:04.719 Rebecca: Okay, I can do that.
20 00:02:05.180 ⇒ 00:02:13.767 Demilade Agboola: Okay. Alright, that’s that’s great. That’ll be very helpful. Also, I wanted to ask
21 00:02:15.910 ⇒ 00:02:23.450 Demilade Agboola: The second thing I wanted to mention was the cogs element of this so
22 00:02:24.280 ⇒ 00:02:29.269 Demilade Agboola: ideally. If we want to have the most accurate version of cogs
23 00:02:29.750 ⇒ 00:02:36.610 Demilade Agboola: where we can apply to, you know orders in the past.
24 00:02:36.840 ⇒ 00:02:40.080 Demilade Agboola: and we know the exact date that the calls are valid, for
25 00:02:40.280 ⇒ 00:02:43.889 Demilade Agboola: we will need to have a historical cogs sheet.
26 00:02:44.830 ⇒ 00:02:45.730 Rebecca: Okay.
27 00:02:46.000 ⇒ 00:03:04.389 Demilade Agboola: No, the problem is so. The problem is, it seems like there hasn’t necessarily been like, obviously, people put like cogs in the sheets. But sometimes we’ll have duplicates, because maybe you know, human error so like the new cogs comes in, old cogs doesn’t go out.
28 00:03:04.730 ⇒ 00:03:20.479 Demilade Agboola: So we’re gonna have duplicates and things like that. But ideally, what we would want is to have a sheet where we could have, like a valid from date and a valid to date, and we can say, Hey, from maybe the 1st of January 2025 to the 1st of
29 00:03:21.080 ⇒ 00:03:34.300 Demilade Agboola: March 2025. The cogs for this variant was 70 whatever, and we can kind of use those numbers
30 00:03:34.860 ⇒ 00:03:39.769 Demilade Agboola: to apply that to each of the orders placed within that timeframe.
31 00:03:42.130 ⇒ 00:03:46.559 Demilade Agboola: Ideally, I know that that’s a lot of work, because they’re a lot of variants.
32 00:03:46.993 ⇒ 00:03:58.050 Demilade Agboola: And there’s been also lots of cogs changes across, you know, even just this year, even if we say we don’t want to do it like all time we could, even if it’s just this year. That’s still a lot of work.
33 00:03:58.791 ⇒ 00:04:03.360 Demilade Agboola: So I’m thinking, like, if is there any way we can number one.
34 00:04:05.640 ⇒ 00:04:07.750 Demilade Agboola: Make this easier.
35 00:04:09.190 ⇒ 00:04:10.220 Demilade Agboola: Yes, I think.
36 00:04:10.220 ⇒ 00:04:26.539 Rebecca: There is a way to make it easier, because they’re all input the same way. And there’s a whole bunch of different variants per pharmacy, but the vial sizes are what we price them out at. So we could potentially.
37 00:04:26.740 ⇒ 00:04:40.819 Rebecca: if I were to deliver to you like this variant that says, dose one is a 1 Ml. Vial, and at absolute. It is $50, or whatever it is, and then I can say.
38 00:04:41.010 ⇒ 00:04:43.469 Rebecca: dose 2 is
39 00:04:43.810 ⇒ 00:04:52.950 Rebecca: a 2 ml. Vial, and that’s $55. And so that way, if we change pharmacies, then
40 00:04:53.180 ⇒ 00:05:03.410 Rebecca: you would just be updating the cost per that same vial size, but the doses wouldn’t change. It would still be like dose one dose 2. If that makes sense.
41 00:05:04.290 ⇒ 00:05:14.640 Demilade Agboola: Okay. But what about when the the cost values themselves change like what happens when you, the the cost of goods sold for that value changes.
42 00:05:16.900 ⇒ 00:05:25.359 Rebecca: Well, ever since we stopped doing that big sheet like the product offering sheet.
43 00:05:26.150 ⇒ 00:05:43.429 Rebecca: We have just been like telling you guys via slack messages. So it’s not like really an official way. But if you want to create some type of file where we can load it in, we can make it official. So that way you can just put it in like. However, you want to see it
44 00:05:43.690 ⇒ 00:05:47.030 Rebecca: and put like start date, end date. And then we could fill it in.
45 00:05:48.000 ⇒ 00:05:50.610 Demilade Agboola: Okay, can I share? Can I share my screen.
46 00:05:52.815 ⇒ 00:05:55.729 Rebecca: I’m driving right now, so I can’t really see your screen.
47 00:05:56.220 ⇒ 00:06:02.879 Demilade Agboola: Okay, gotcha so I’ll what I’ll do I’ll share. I’ll share the link in.
48 00:06:03.090 ⇒ 00:06:07.170 Demilade Agboola: But when you, when you’re when you are stationary. You can look at it.
49 00:06:07.878 ⇒ 00:06:10.860 Demilade Agboola: So I’ll show you to slack in our conversation thread.
50 00:06:11.200 ⇒ 00:06:17.049 Demilade Agboola: But basically this would be what a sample would look like.
51 00:06:19.710 ⇒ 00:06:23.839 Demilade Agboola: And but I’m trying to send it to you.
52 00:06:25.256 ⇒ 00:06:31.480 Demilade Agboola: Alright. So I just sent it and basically the idea here is this is what a sample will look like.
53 00:06:32.120 ⇒ 00:06:41.130 Demilade Agboola: And it’s basically 5 or 6 columns. We have the variant id, the pharmacy product, name
54 00:06:41.350 ⇒ 00:06:47.520 Demilade Agboola: the the cogs valid from and valid to.
55 00:06:47.660 ⇒ 00:06:53.460 Demilade Agboola: And so the idea is we can retrospectively go back
56 00:06:53.830 ⇒ 00:07:03.199 Demilade Agboola: and change the value from a value to date. But if the value to is null that suggests that that’s a current value that we’re using.
57 00:07:03.680 ⇒ 00:07:04.770 Demilade Agboola: And
58 00:07:04.970 ⇒ 00:07:13.129 Demilade Agboola: when when we when it stops being a current value, we’ll replace the not old, replace the entry space with the
59 00:07:13.540 ⇒ 00:07:19.460 Demilade Agboola: dates that that value stopped being the current value, or when it became
60 00:07:19.740 ⇒ 00:07:27.500 Demilade Agboola: the old cogs. So that way we can always kind of keep track of what the cogs was at each point in time, and how that changed over time.
61 00:07:29.320 ⇒ 00:07:32.630 Demilade Agboola: And that allows us for easy like revenue calculation.
62 00:07:34.450 ⇒ 00:07:36.069 Rebecca: Okay, yeah, we can do that.
63 00:07:36.700 ⇒ 00:07:45.289 Demilade Agboola: Okay, I I’m thinking I’m just trying to think of like
64 00:07:45.430 ⇒ 00:07:51.179 Demilade Agboola: I can. I share details with you? I don’t like where you look at it. Can you just let me know your thoughts?
65 00:07:51.684 ⇒ 00:07:57.660 Demilade Agboola: There’s some values there, but they’re dummy values, so don’t like. The idea was just to kind of show.
66 00:07:58.295 ⇒ 00:08:03.259 Demilade Agboola: How this would look like like, it’s sample data. I guess that you think of it that way.
67 00:08:04.135 ⇒ 00:08:04.690 Demilade Agboola: Okay.
68 00:08:04.810 ⇒ 00:08:15.039 Demilade Agboola: But the idea is just like. So every time a new value comes in we just will impute it. And we don’t have to worry about like duplicates there, because it’s meant to have duplicates based off the time.
69 00:08:15.973 ⇒ 00:08:18.800 Demilade Agboola: So one is like one is active
70 00:08:19.870 ⇒ 00:08:31.859 Demilade Agboola: from a certain period, the other stops at a certain period and picks up. The one starts at a certain period, ends at a certain period, and the other one picks up from there. So that way we can always kind of keep track of what what’s going on with cogs.
71 00:08:32.820 ⇒ 00:08:33.460 Rebecca: Okay.
72 00:08:33.750 ⇒ 00:08:34.530 Demilade Agboola: Anyway.
73 00:08:34.783 ⇒ 00:08:40.639 Demilade Agboola: so which call it? Which column is like the dummy column? Or can you just like spell it out so that way, I know.
74 00:08:40.640 ⇒ 00:08:51.779 Demilade Agboola: Oh, like the the cogs the values for cogs were just here to like. They’re just dummies, the the 72 and 70. I think I was also into Christine of how it will look
75 00:08:52.220 ⇒ 00:08:57.770 Demilade Agboola: in practice. I kind of just put out the and also the dates. I’ll also add, like
76 00:08:58.060 ⇒ 00:09:00.580 Demilade Agboola: duplicates, or just dummy data. Sorry?
77 00:09:01.454 ⇒ 00:09:03.189 Demilade Agboola: So there there is.
78 00:09:04.310 ⇒ 00:09:10.189 Demilade Agboola: If this 1st product, which is the Meta trim level 2 monthly.
79 00:09:10.330 ⇒ 00:09:18.409 Demilade Agboola: If you had a call from the 1st of April to the 1st of June, at 70
80 00:09:18.760 ⇒ 00:09:22.740 Demilade Agboola: till date, then to be null, and then we can kind of just use.
81 00:09:24.620 ⇒ 00:09:31.850 Demilade Agboola: the value of Santa 2. From everything, from the 1st of June till the 6th of to the 1st of April to the 1st of June.
82 00:09:32.050 ⇒ 00:09:37.840 Demilade Agboola: and there’s $70 from everything from the 1st of June till date that way, you know. Yeah.
83 00:09:39.050 ⇒ 00:09:42.890 Demilade Agboola: so ideally, we will. We would like to have something historical.
84 00:09:44.500 ⇒ 00:09:49.499 Rebecca: Yeah. Have you shared this with Christiana as well? This sheet.
85 00:09:50.980 ⇒ 00:09:59.069 Demilade Agboola: Yeah, I mean, I showed it with Christiana. She but I think what? Why she talked to was, she said. She doesn’t have access to like. There’s no like historical sheet.
86 00:10:00.580 ⇒ 00:10:22.709 Rebecca: Okay, yeah. I mean, we haven’t been keeping track of when pricing changes have occurred. We’ve just been putting it into the slack channel and just communicating it across to whoever needs to know? So I’ll have to go back through my emails and stuff and see when pricing was renegotiated. So that’s gonna take me a while to do.
87 00:10:23.400 ⇒ 00:10:25.309 Demilade Agboola: Yeah, I can imagine. I can imagine.
88 00:10:28.787 ⇒ 00:10:34.740 Demilade Agboola: Yeah, I think that would just help us with like being able to come to a place where.
89 00:10:34.920 ⇒ 00:10:38.210 Demilade Agboola: like we feel, the cogs is in great in a great spot.
90 00:10:39.172 ⇒ 00:10:45.690 Demilade Agboola: I don’t. Obviously it’ll be great, or it’ll be best. If we could have something automated.
91 00:10:46.910 ⇒ 00:10:47.740 Rebecca: Yes.
92 00:10:48.300 ⇒ 00:10:50.400 Demilade Agboola: That would be very, very helpful.
93 00:10:51.150 ⇒ 00:10:56.990 Rebecca: Well, if we can get all of this plugged into eaten OS, then that would be the best.
94 00:10:57.580 ⇒ 00:10:58.986 Demilade Agboola: Yeah. Yeah.
95 00:11:00.200 ⇒ 00:11:06.829 Demilade Agboola: I think something to just like raise with Sebastian and Ryan, and just kind of see, like what their plans are for
96 00:11:07.350 ⇒ 00:11:11.070 Demilade Agboola: the cogs, and if they have any plans to integrate that like
97 00:11:12.926 ⇒ 00:11:17.170 Demilade Agboola: like integrate with the pharmacies in particular.
98 00:11:17.928 ⇒ 00:11:24.459 Demilade Agboola: But I’m also wondering the cogs when you renegotiate cogs, does it come in as
99 00:11:24.730 ⇒ 00:11:30.180 Demilade Agboola: is it like an email thread? Or do you have like Csvs where they like? Send it to you?
100 00:11:32.150 ⇒ 00:11:34.220 Rebecca: It. Typically it’s in an email.
101 00:11:34.750 ⇒ 00:11:35.430 Demilade Agboola: Oh, okay.
102 00:11:37.389 ⇒ 00:11:45.779 Demilade Agboola: it could have potentially been easier if they were like, maybe for the new ids. These are the new cogs.
103 00:11:46.290 ⇒ 00:11:53.530 Demilade Agboola: We could probably create an automation to handle, you know, taking that data and creating like a master sheet
104 00:11:53.760 ⇒ 00:11:54.720 Demilade Agboola: for it.
105 00:11:55.640 ⇒ 00:12:02.170 Rebecca: Well, usually it’s only like 4 prices. It’s like for the one ml, 2 ml. 3 ml. 4 ml.
106 00:12:02.280 ⇒ 00:12:25.810 Rebecca: so it’s not really like a Csv sheet worthy, since it’s just 4 prices that we’re negotiating each time, and then the other products that we renegotiate cogs for are kind of like whenever we hit a certain volume, then we rediscuss what the pricing is going to be. So they’re more on like a 1 on one basis rather than multiple at one time.
107 00:12:26.280 ⇒ 00:12:29.139 Rebecca: So that’s why I guess we haven’t really needed a Csv.
108 00:12:29.840 ⇒ 00:12:37.849 Demilade Agboola: But I’m curious, though. I know that there are multiple variants.
109 00:12:39.080 ⇒ 00:12:43.989 Demilade Agboola: or, for for instance, for summer, or whatever like product.
110 00:12:44.150 ⇒ 00:12:49.480 Demilade Agboola: My question is, is it just? Is it does the does the
111 00:12:49.770 ⇒ 00:12:54.419 Demilade Agboola: parents not matter? Or is it just solely a function of products and file size?
112 00:12:56.187 ⇒ 00:12:59.360 Rebecca: It is solely a function of product and vial size.
113 00:13:00.370 ⇒ 00:13:07.929 Demilade Agboola: Gotcha gotcha. So if there’s a change to Sama one like one ml.
114 00:13:08.670 ⇒ 00:13:12.539 Demilade Agboola: all summer whenever gets gets the new cogs, basically.
115 00:13:12.860 ⇒ 00:13:14.280 Rebecca: Yes, that’s correct.
116 00:13:15.320 ⇒ 00:13:16.230 Demilade Agboola: Gotcha.
117 00:13:16.420 ⇒ 00:13:21.830 Rebecca: So it doesn’t matter which variant gets one. Ml, all of those one Mls are going to be the same price
118 00:13:22.280 ⇒ 00:13:30.179 Rebecca: because there’s 3 different. No, there’s like 6 different types. There’s like 3 different titrations and 3 different maintenance.
119 00:13:30.470 ⇒ 00:13:39.969 Rebecca: So that’s 6 different types of Sema. But all of them have a. 1 ml. 2 ml. 3 ml. 4 ml. For the most part absolute only has a 1, 2, and 4,
120 00:13:40.080 ⇒ 00:13:43.120 Rebecca: but for the most part everybody has that
121 00:13:44.070 ⇒ 00:13:48.389 Rebecca: 1, 2, 3, 4, so it’ll be the same cost throughout.
122 00:13:49.730 ⇒ 00:13:50.780 Demilade Agboola: And.
123 00:13:52.300 ⇒ 00:14:01.700 Rebecca: So if you know which file size each one of those variants are, then you’ll be able to determine pricing. But that’s something that I need to provide to you.
124 00:14:02.430 ⇒ 00:14:07.598 Demilade Agboola: Yeah, that’s that’s the that’s what I was going to say. Like, if there was a way in which
125 00:14:08.190 ⇒ 00:14:13.620 Demilade Agboola: every product automatically had their vow sizes right beside the name
126 00:14:14.050 ⇒ 00:14:24.399 Demilade Agboola: like that would be so much easier, because once you send an update on like Hey, every summer for one Ml, is now this price.
127 00:14:24.820 ⇒ 00:14:31.900 Demilade Agboola: It’s easy to just go, hey, there’s a column for one Ml, or like a column, for like the file sizes.
128 00:14:32.080 ⇒ 00:14:36.030 Demilade Agboola: and then so just broadcast this new cogs across that date
129 00:14:36.630 ⇒ 00:14:42.099 Demilade Agboola: or send you. Yeah, it’ll it’ll be much easier to just to do that as a
130 00:14:42.510 ⇒ 00:14:44.700 Demilade Agboola: as an automated process.
131 00:14:46.080 ⇒ 00:14:51.479 Demilade Agboola: Do you think it’s something you can get past to do to give us like to add the
132 00:14:52.110 ⇒ 00:14:59.520 Demilade Agboola: the file sizes to the products information. So when they give us like data extracts. We can just have it as well.
133 00:15:00.170 ⇒ 00:15:03.129 Rebecca: Yeah, that would be amazing. I could definitely ask for that.
134 00:15:03.690 ⇒ 00:15:13.800 Demilade Agboola: Okay. Alright, let me, because we have a call with bask tomorrow, I’m trying to. So we’re just trying to put off like, put everything that we could put to bask. That will make our lives easier. Generally.
135 00:15:15.130 ⇒ 00:15:15.910 Rebecca: Yeah, for sure.
136 00:15:16.770 ⇒ 00:15:19.161 Rebecca: Ask them for whatever you need to make
137 00:15:22.720 ⇒ 00:15:26.570 Rebecca: here, too. Honestly, if we had the vial size inside of the tone.
138 00:15:30.990 ⇒ 00:15:31.740 Demilade Agboola: I’ll mute that.
139 00:15:32.400 ⇒ 00:15:34.760 Demilade Agboola: Sorry I couldn’t hear you for a bit. I don’t know.
140 00:15:36.930 ⇒ 00:15:41.073 Rebecca: Oh, sorry. I’m driving through a a little patchy area, but
141 00:15:41.710 ⇒ 00:15:48.299 Rebecca: if yes, if you need to get the file size added to the title. That would be easier for my team as well.
142 00:15:49.280 ⇒ 00:15:50.129 Demilade Agboola: Okay, cool.
143 00:15:51.000 ⇒ 00:15:59.739 Demilade Agboola: Yeah, I I don’t necessarily need it to be the title per se. It could just literally be the what’s it called like its own separate column.
144 00:16:00.420 ⇒ 00:16:14.019 Demilade Agboola: So you know, the valve size. Yeah. So that way, even updating the sheet. Even if it was like when I was automated updating sheets would be easier because you could just filter for the valve size of, say, one Ml, and just put the new cog value
145 00:16:14.220 ⇒ 00:16:26.720 Demilade Agboola: there. You know that. And that’s everything done. They need to go to 1.7. Do the same thing. Yeah, or 3 ml, onto the same thing. I think that just makes it a a much faster process.
146 00:16:27.840 ⇒ 00:16:33.220 Rebecca: Yeah, so that way, you would get the name, and you would get the file size cause right now.
147 00:16:33.220 ⇒ 00:16:37.180 Rebecca: exactly the file size, I guess. Web hook right.
148 00:16:38.552 ⇒ 00:16:43.130 Demilade Agboola: Well, the file size. We’re not getting it in the product extracts. No.
149 00:16:43.980 ⇒ 00:16:44.590 Rebecca: Okay.
150 00:16:45.240 ⇒ 00:16:46.640 Demilade Agboola: And probably shut snow.
151 00:16:47.270 ⇒ 00:16:48.570 Rebecca: I’ll see if he can add that.
152 00:16:49.200 ⇒ 00:16:52.263 Demilade Agboola: Okay, thank you.
153 00:16:53.830 ⇒ 00:17:03.379 Demilade Agboola: yeah. Is there any other thing that would make just the farm up smoother in terms of either things from bask, or just like general processes.
154 00:17:06.650 ⇒ 00:17:09.010 Rebecca: I mean you’ve got it covered.
155 00:17:10.507 ⇒ 00:17:11.702 Demilade Agboola: Okay, alright.
156 00:17:12.500 ⇒ 00:17:17.049 Demilade Agboola: I think that’ll be it. And I just wanted to sync with you on this, so that we’re on the same page.
157 00:17:17.650 ⇒ 00:17:20.609 Demilade Agboola: and this has been helpful. At least we know what to ask from Bask.
158 00:17:21.440 ⇒ 00:17:22.349 Rebecca: Yes.
159 00:17:22.450 ⇒ 00:17:28.949 Rebecca: that will be helpful for us as well, and then you share the sheet with me, and I’ll add in the file sizes per dose.
160 00:17:30.040 ⇒ 00:17:31.630 Demilade Agboola: Okay. Alright. Thank you very much.
161 00:17:31.630 ⇒ 00:17:33.533 Rebecca: Their file size. Yes.
162 00:17:35.200 ⇒ 00:17:36.530 Demilade Agboola: Alright, then thank you.
163 00:17:36.530 ⇒ 00:17:37.839 Rebecca: I have some homework.
164 00:17:40.710 ⇒ 00:17:43.089 Demilade Agboola: Thank you very much. Appreciate it.
165 00:17:43.410 ⇒ 00:17:45.349 Rebecca: Yup, you’re welcome. Have a good day.
166 00:17:45.670 ⇒ 00:17:46.859 Demilade Agboola: You too, bye.
167 00:17:46.860 ⇒ 00:17:47.335 Rebecca: Bye.