Help in learning Linear programming for real time cases

I got hired as a DS for the supply chain team and am pretty much a lone wolf here. I have zero knowledge of LPP and optimization and has somehow scraped by in the last couple of months.

I have gone through many articles but they only use predefined equations. Most of my problems came from inability to convert the Excel solver to pulp format equations.

Can I please get some advice on learning about LP optimization?

articles cases datascience knowledge linear optimization programming supply chain team through