Pharma Supply Chain manager Excel Data set
Budget: $30 – $250 USD
I have a last-minute interview for a Supply Chain Manager role at a pharmaceutical company today and need a ready-to-use Excel workbook that looks like something I would have created myself. It must showcase the core areas a hiring panel is likely to probe—procurement processes, distribution network design and performance, and detailed stock management.
Please populate realistic pharmaceutical-sector data (SKUs, batch numbers, lead times, cold-chain flags, supplier scores, lane capacities, MOQ, safety stock, service levels, expiry horizons, etc.) and structure everything as clear tables and lists—no charts required this time. If you can weave in useful formulas (e.g., EOQ, safety-stock, OTIF) and a couple of pivot tables to summarise spend by supplier and inventory by warehouse, even better.
I need the file today, well before my interview, so speed and clarity are critical. Once delivered, I should be able to walk through each sheet confidently and answer follow-up questions on the logic behind the numbers.
Please populate realistic pharmaceutical-sector data (SKUs, batch numbers, lead times, cold-chain flags, supplier scores, lane capacities, MOQ, safety stock, service levels, expiry horizons, etc.) and structure everything as clear tables and lists—no charts required this time. If you can weave in useful formulas (e.g., EOQ, safety-stock, OTIF) and a couple of pivot tables to summarise spend by supplier and inventory by warehouse, even better.
I need the file today, well before my interview, so speed and clarity are critical. Once delivered, I should be able to walk through each sheet confidently and answer follow-up questions on the logic behind the numbers.