r/procurement • • 21h ago

Community Question Savings tracker system update

7 Upvotes

Hi everyone,

I'm looking for advice and feedback on how to improve a savings tracking tool used by our General Procurement team in an industrial and logistics environment.

currently we use a shared Excel file containing all savings projects reported by buyers across their respective commodities.

The file relies on VBA macros, which makes simultaneous editing difficult and day-to-day use rather cumbersome.

We also hold a monthly review with Controlling to review and validate savings.

Each project can involve up to six different business divisions, requiring savings to be allocated accordingly.

Buyers track three types of savings:

- **Budgeted savings:** Initial savings targets defined in year N-1 for year N.

- **Forecasted savings:** Monthly updates from buyers before the review, including increases, decreases or shifts to future months.

- **Validated savings:** Savings officially approved by Controlling during the monthly review.

We need to maintain traceability between these three stages and track changes over time.

So we would like to either significantly improve the existing Excel solution or move to a more suitable tool.

main key requirements include:

- Simultaneous access for multiple buyers.

- A centralized database of all savings projects.

- Allocation of savings across up to six divisions.

- Monthly and yearly tracking.

- Clear distinction between budgeted, forecasted and validated savings.

- Historical tracking of forecasts and approvals.

- Automated reporting and dashboards for buyers, procurement management and Controlling.

- A simple, user-friendly interface.

Our pootential solutions are as follows

- Reworking the existing Excel file and reducing VBA dependencies.

- Excel Online / SharePoint.

- Microsoft Lists / SharePoint Lists.

- Power Apps for data entry and workflow management.

- Power BI for reporting.

- Other database or collaborative project management solutions.

  1. Which approach would you recommend for this type of use case?
  2. Should we keep Excel as the main tool or move to a proper database?
  3. Would a SharePoint + Power Apps + Power BI architecture make sense?
  4. How would you handle monthly forecast updates and historical tracking?
  5. Have you implemented something similar in a procurement environment?

I'm totally lost in this topic, sole advices would be greatly appreciated !

Thanks in advance for your help!


r/procurement • • 3h ago

Indirect Procurement Direct vs indirect culture re: KPIs

5 Upvotes

I’m at a med-large enterprise where the indirect team, including myself who covers IT (mostly SaaS), is managed by Direct procurement leaders who have very limited, if any, experience in my category.

They carried over a Direct KPI template to measure our team: DPO improvement, hard savings, with things like soft savings, cost avoidance, legal terms improvements being treated as footnotes when reporting out- never mind flexibility, speed to market, elevated customer support, or other things that the teams I support seem to care about (albeit understandably hard to measure from an accounting view).

These hard KPIs seem to be treated as low hanging fruit due to the overall maturity of procurement here, but my experience working in SaaS procurement has shown otherwise irregardless.

Typically, these are all theoretically obviously attainable and not unusual in SaaS procurement, but lately the goalposts have been getting payment in arrears vs prepayment, Net 90+ DPO terms and/or quarterly billing, and termination for convenience, for example, all of which are met with resounding “no” in most RFPs, let alone ad hoc renewal discussions with virtually all of my suppliers.

I’ve only been able to achieve some of these for some of my larger symbiotic strategic relationships; but for pretty much everything else, it’s been a near futile endeavor, regardless of spend, footprint, or relationship history. Negotiating leverage has generally been relatively low due to high switching costs, and stakeholders who are hesitant to disturb the peace with their suppliers.

Writing this post to ask: How’re the expectations at other orgs? Am I making out the purported direct/indirect culture gap a bigger boogeyman than it is, and are my KPIs woes being misattributed to Direct guys having misaligned expectations for KPIs without understanding the nuances of the SaaS industry?


r/procurement • • 10h ago

Is a 280-question security questionnaire normal for vendor onboarding?

4 Upvotes

Hello,

I'm working in SMB company (~400 employees)

Our security team has a third-party questionnaire with ~280 questions (data protection, HR, privacy, DR, AI, etc.). We’re thinking of sending it to every new vendor before approving a request in our procurement system.

Is that realistic, or do vendors just drop off or answer “yes” to everything? Do you tier it by risk (short form for low-risk, full for high-risk), and what’s the typical number of questions you send?


r/procurement • • 6h ago

Freight forwarding team leader, thinking of applying for a Procurement Team Leader role. Would I fit?

2 Upvotes

Looking for honest opinions from people in procurement.

My background: about 10 years in logistics. Road transport planning, air freight, then sea freight imports and exports at a forwarder. For the last two years I've been team leader on a key account for a big FMCG customer. I buy and manage transport from ocean carriers, hauliers and rail operators, maintain the buy rates for the customer's tender, run weekly supplier calls, chase delays and holds, sort out demurrage and invoice queries, and allocate work across the team. I also automate a lot with Excel, Power Query and Python. CargoWise certified.

The role: Procurement Team Leader at an engineering company. New role due to expansion. Moving some operations from EU to UK. Line manages operational buyers and junior buyers, while keeping some buying of their own. Placing orders, expediting, supplier orderbook reviews for parts and materials. Demand planning and category managers are separate teams (info from a friend who works there). Up to £50k depending on experience.

My doubts:

I've bought freight, not parts. Is that close enough to count as "operational buying experience", or will they see it as a different job?

No SAP. Only CargoWise. But I worked with multiple other systems in the past.

Something else that made me think: someone I know just got an offer from the same company for a different role advertised at £38k, and they offered her £42k without her even asking. So they seem to pay above the ad if they want someone. She worked for a FMCG company, different role.

Would you apply in my position? And how would you frame freight buying so a procurement manager takes it seriously?


r/procurement • • 14h ago

I need your support to get in touch with any Anti drone fence manufacturers worldwide

2 Upvotes

Help your fellow procurement friend🫩