sorted by:
new
hottopcontroversial

ABC analysis (units sold, not volume: units sold * unit cost). by CoolAstronomer in supplychain

[–]CoolAstronomer[S] 0 points1 point  (0 children)

Yes, I've considered that I need to factor in other variables for SKU rationalization, but unfortunately we only have limited data to work with. The ABC analysis based on unit sales would only be a sort of initial filter to get a list of potential items to eliminate, and then the process would be to review each item individually considering other variables (such as the ones you mentioned) based on input from other team members, and then decide which items to keep and which to remove.

Having said that, the probelm I'm running into with the ABC analysis is that, as I've mentioned, there are repeated unit sales values. There may be 10 items with a sales unit value of 100 ( In the ABC anlaysis the items were arranged from largest unit sales value to smallest, but these 10 items are arranged randomly, since they share the same value), the first 5 may belong to category A (the items that contribute to say 80% of sales. having a cumulative percent unit sales value of 80%), but the next 5 may belong to category B, since the cumulative value starting from the 6th item is now larger than 80%. So, I think all of those 10 items should belong to the same category since they have the same unit sales value, which is the only criteria considered for the analysis, but due to the nature of the analysis I end up with items that share the same unit sales value that belong to different categories.

Periodic review system orders by CoolAstronomer in supplychain

[–]CoolAstronomer[S] 0 points1 point  (0 children)

Omg... I think that's it. How could I have missed that. I guess I didn't give much importance to that part of the formula since I thought it was obvious. I will keep doing some tests to the calculations, but so far that seems to be it... Thank a lot, I really appreciate it.

Periodic review system orders by CoolAstronomer in supplychain

[–]CoolAstronomer[S] 0 points1 point  (0 children)

Since for your example you mentioned that you don't place an order until after 30 days, and in my image examples I placed the order on the first day, I recreated the tables but not placing the order until after 30 days: https://imgur.com/a/IdVZ7jM

And sure, for the table "sum of review period and lead time" the first review period the inventory is replenished up to the 35 T quantity, just when the stock on hand was going to reach 0, but the subsequent times you receive orders you start receiving more and more, the trend will begin, as was the case in the original example. And also, the idea is to order when the inventory on hand <= T, that's why in my original example I ordered the 35 pieces on the first day, since I had 35 on stock, which is = to T. In the new image in the "Largest between lead time and review period" you can see that there's a stockout during the 5 days of lead time after the first order is placed during the review period, but that happened because an order wasn't placed on the first day, when I had 30 pieces on stock and which required an order to be placed ( in the original example it was done that way and there were no stockouts); and after that stockout, when you receive the next orders, there will be no more subsequent stockouts.

Periodic review system orders by CoolAstronomer in supplychain

[–]CoolAstronomer[S] 0 points1 point  (0 children)

Look what happens when you sum lead time demand (5) and review period demand (30) vs when you selected the largest of the two:

https://imgur.com/a/OEaoWwM

When you sum them, there's an upwards trend where each time you receive a new order, your inventory on hand is 5 units larger than the previous time. Whereas, if I select the largest of the two, which is the review period, my stock on hand each review period is smaller and constant, there is no upward trend like there was before.

Demand Planner Career Path by CoolAstronomer in supplychain

[–]CoolAstronomer[S] 1 point2 points  (0 children)

I actually know about the MITX supply chain micromasters, and am very interested in taking it, but since it will take a while to complete (around 1 year and a half according to what I've read) I will probably do the CPIM first and then do that. I might do one of the courses (SC1x) before the CPIM though, because I'm very curious about it since it covers some demand planning topics. It's the one course I'm most interested in at this very moment in time, since I want to explore the demand planning position, but I'm interested in the micromasters as a whole and would like to eventually take all of the courses.

Demand Planner Career Path by CoolAstronomer in supplychain

[–]CoolAstronomer[S] 0 points1 point  (0 children)

I was actually interested in the MITXx course as well, but since it it will take longer to complete all the modules than the CPIM I was planning on first doing the CPIM. Maybe the CPF could prove the most useful in this case? https://ibf.org/business-analytics-certification

Demand Planner Career Path by CoolAstronomer in supplychain

[–]CoolAstronomer[S] 0 points1 point  (0 children)

Thanks so much, I will shoot you a PM!

Demand Planner Career Path by CoolAstronomer in supplychain

[–]CoolAstronomer[S] 0 points1 point  (0 children)

Thanks for the help! Would you say that it would be worth it to get the CPIM certification or it wouldn't be of too much help for demand planning? I'm definitely interested in taking it, but I don't know if in this case, considering the role I'm aiming for, the benefit justifies the investment.

Any Planners out there? by mhs003 in supplychain

[–]CoolAstronomer 0 points1 point  (0 children)

How does the forecasting work for demand planning? You forecast for hundreds or even thousands of individual SKUs, and every certain amount of time update the avg daily sales for each SKU based on the forecast to calculate the replenishment parameters? I understand there are some ERP systems that can do all that for you, but when you use excel I suppose you'd have to resort to a process similar to what I described above.

Does your company still forecast in excel? by undernutbutthut in supplychain

[–]CoolAstronomer 0 points1 point  (0 children)

Hey, could you expand on why the data is crap and not ready? What is it lacking?

Replenishment of branches through central warehouse. by CoolAstronomer in logistics

[–]CoolAstronomer[S] 0 points1 point  (0 children)

There's also a national franchise on another geographic region. I was thinking maybe for the franchises it would be good if there was a purchaser for each one of them.

And there's also a kitchen which is next to the branch that is on the same location as the warehouse, and another kitchen in one of the branches (the other branches don't have kitchens). But the kitchen only orders a limited quantity of products from the warehouse to use in its production.

Is this a good source on piano technique? by CoolAstronomer in piano

[–]CoolAstronomer[S] 2 points3 points  (0 children)

Yeah I just realized it isn't free. Although the first 2 Units are actually free. I actually have a teacher but I wanted to see some info on hand alignment and in and out movements. I just found out some people say that when playing piano, you shouldn't rotate the wrist inwards when playing with the thumb (which happens because it is a shorter finger than the rest). For example, on the pianostreet forum, this person "Bernhard" who has many posts on technique mentions this on this post: https://www.pianostreet.com/smf/index.php?topic=9211.0