<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by Lokesh Patil on Medium]]></title>
        <description><![CDATA[Stories by Lokesh Patil on Medium]]></description>
        <link>https://medium.com/@lokeshpatilwork?source=rss-ab62986d0d97------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*LPV2qaJbtxNvmvMb</url>
            <title>Stories by Lokesh Patil on Medium</title>
            <link>https://medium.com/@lokeshpatilwork?source=rss-ab62986d0d97------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Thu, 19 Nov 2026 23:27:08 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@lokeshpatilwork/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[The Invisible Layer: Why Personal Care Manufacturing Still Runs on Spreadsheets]]></title>
            <link>https://medium.com/@lokeshpatilwork/the-invisible-layer-why-personal-care-manufacturing-still-runs-on-spreadsheets-5d7d6f90311f?source=rss-ab62986d0d97------2</link>
            <guid isPermaLink="false">https://medium.com/p/5d7d6f90311f</guid>
            <category><![CDATA[personal-care]]></category>
            <category><![CDATA[automation]]></category>
            <category><![CDATA[manufacturing]]></category>
            <category><![CDATA[cosmetics]]></category>
            <category><![CDATA[contract-manufacturing]]></category>
            <dc:creator><![CDATA[Lokesh Patil]]></dc:creator>
            <pubDate>Tue, 11 Aug 2026 20:06:12 GMT</pubDate>
            <atom:updated>2026-08-11T20:41:29.055Z</atom:updated>
            <content:encoded><![CDATA[<figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*vb67eqWWaD9HKeKJJt-l4Q.png" /></figure><p>It’s been almost a year since I joined procurement at a personal care manufacturer, and if there’s one thing that’s surprised me more than anything else, it’s this: an industry that produces some of the most technically sophisticated formulas in consumer goods is still, in large part, run on spreadsheets, email chains, and institutional memory.</p><p>That’s not a knock on the people doing the work. Everyone I’ve worked with is sharp, resourceful, and good at their jobs. The problem isn’t talent. It’s that the tools available to most manufacturers in this space were never built for how fast and how interconnected the actual work is.</p><h3>The gap nobody talks about</h3><p>There’s been a lot of attention on the consumer facing side of beauty and personal care: virtual try on, AI driven personalization, direct to consumer formulation quizzes. That side of the industry is crowded with venture money and new tooling.</p><p>The manufacturing side is a different story. Large enterprises, the household names, solved their operational problems years ago, mostly by building internal tools tailored to their own processes. They have the scale to justify custom software, dedicated IT teams, and integrations that quietly keep formula, procurement, production, and compliance in sync.</p><p>Everyone else, the midsize contract manufacturers and own brand manufacturers that make up a huge share of this industry, doesn’t have that. They’re running on general purpose ERPs (SAP, NetSuite, ProcessPro, or nothing at all) that are good at recording what happened, but not at understanding what <em>should</em> happen next. The result is a layer of operational intelligence that simply doesn’t exist for most of the industry, and that gap gets filled by people, manually, every single day.</p><h3>Where the gap actually shows up</h3><p>It’s easy to say “things are manual” in the abstract. It’s more useful to talk about where, specifically, that manual work lives, because once you see the pattern, it’s hard to unsee.</p><p><strong>Formula changes don’t travel on their own.</strong> When R&amp;D adjusts a formula (swaps an ingredient, changes a percentage, reformulates for cost or performance), that change has ripple effects across procurement, production scheduling, and compliance. In a mature system, that ripple would happen automatically: new material requirements calculated, purchase orders adjusted, compliance status re-checked. In most midsize operations, that ripple happens because someone remembers to mention it. Formula changes and procurement systems are rarely, if ever, actually connected.</p><p><strong>Compliance is a moving target, tracked by hand.</strong> Personal care manufacturers in the U.S. operate under an increasingly complex regulatory environment. Cosmetic specific requirements have gotten more demanding in recent years, and any product that edges into OTC drug territory (sunscreens, antiperspirants, acne treatments) is regulated as a drug, with a much stricter compliance bar. Tracking active ingredient percentages against monograph limits, keeping safety substantiation files current, managing label requirements, monitoring registration and listing deadlines: all of this requires constant vigilance, and in most operations, it’s tracked in whatever system happens to be available, whether that’s a shared spreadsheet, a compliance binder, or someone’s calendar reminders. It works, until the day it doesn’t. And the cost of it not working isn’t hypothetical; it’s a blocked shipment or a regulatory letter.</p><p><strong>Procurement runs on relationships and reorder points, not intelligence.</strong> Purchase orders in a lot of midsize operations get triggered by simple reorder logic (hit a threshold, place an order) rather than any real signal about what upcoming production actually needs based on the current formula and schedule. Price changes from suppliers often get absorbed quietly rather than flagged and negotiated, because nobody has a clean, current view of what a material <em>should</em> cost versus what’s being paid. Multiply that across dozens of suppliers and hundreds of SKUs, and there’s a lot of value quietly leaking out of the system.</p><p><strong>Component readiness is tracked by asking around.</strong> Whether a production run can actually start on schedule depends on a dozen different things being true at once: raw materials received, actives verified, packaging on hand, compliance documentation cleared, QC results back. In a lot of operations, the answer to “are we ready to run this batch” comes from someone walking the floor or sending a few messages, not from a system that already knows.</p><p><strong>Finance reconciliation happens after the fact, not in real time.</strong> Matching a purchase order to a receipt to an invoice (three way matching) sounds like it should be simple. In practice, when goods arrive short, when landed costs come in higher than expected due to freight or duties, or when a supplier quietly raises prices without notice, someone has to catch it, investigate it, and resolve it manually, often weeks after the fact when the numbers show up in a monthly close.</p><h3>Why this persists</h3><p>None of this is because the industry hasn’t noticed. It’s a structural issue. Midsize manufacturers are exactly the segment least likely to have the resources to build custom tooling and least well served by generic enterprise software, which tends to be either too basic (accounting focused systems with no manufacturing intelligence) or too heavy and expensive to justify for a company this size. The software market has, for the most part, either targeted enterprise scale manufacturers who can afford bespoke systems, or targeted the consumer facing side of beauty, where the money and attention has concentrated. The operational core of midsize manufacturing, the actual work of turning a formula into a compliant, cost effective, on time product, has been left to figure itself out.</p><h3>The cost of the gap</h3><p>It’s tempting to write this off as inefficiency at the margins, but the stakes are higher than that in this particular industry. Formula and compliance are tightly coupled in personal care manufacturing in a way they aren’t in a lot of other consumer goods categories. An OTC product with an active ingredient percentage that drifts outside its allowed range isn’t just an operational miss, it’s a regulatory problem. A missed facility renewal or an expired product listing can stop a product from being legally sold. A supplier price increase that goes unnoticed for a quarter can quietly erode margin on a product line that looked profitable on paper.</p><p>When the connective tissue between formula, procurement, production, and compliance runs through people instead of systems, all of that risk sits with whoever happens to catch it in time. And it doesn’t always get caught in time.</p><h3>Where this goes from here</h3><p>I don’t think the answer here is “manufacturers need to work harder” or “just hire more people.” The people are already good. What’s missing is the layer of software that most other capital intensive industries take for granted at this point: something that actually understands the relationships between formula, materials, compliance, and cost, and surfaces problems before they become expensive ones.</p><p>Enterprise manufacturers built that layer for themselves, a long time ago, because they could afford to. The interesting question, and the one I keep coming back to a year into this industry, is what it would take for that same kind of operational intelligence to become available to everyone else.</p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=5d7d6f90311f" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>