Supply Chain Cost Analyst
Second Harvest of Silicon Valley is one of the largest food banks in the country. It moves over 140 million pounds of food to the people who need it every year! Tracked, analyzed and reported costs related to supply chain functions for $90 million budget in data driven decision-making environment. Interfaced with accounting and finance managers to review headcount, expense, capital, A/P and policy decisions. Investigated and influenced change in internal processes for greater… Show more Second Harvest of Silicon Valley is one of the largest food banks in the country. It moves over 140 million pounds of food to the people who need it every year! Tracked, analyzed and reported costs related to supply chain functions for $90 million budget in data driven decision-making environment. Interfaced with accounting and finance managers to review headcount, expense, capital, A/P and policy decisions. Investigated and influenced change in internal processes for greater efficiency and cost savings. Developed modeling to help achieve budget variances under 1% in utilities and building maintenance. * Produced cost per pound data for organization, by year, by account, by function. Implemented budget and forecast updates. Extensive use of Excel linkages, formulas, functions, charts, pivot tables, VLOOKUP, etc. * Produced trend and rate/volume account analysis along with high level impact summaries. Reduced freight accruals by 90%. Influenced supplier to reduce invoicing days from 22 to 12. Renegotiated contracts, assisted facilities manager with data and reduced waste account by 16% in FY16. Reduced utilities costs innumerable times. * Produced very detailed analysis of returned product using pivot tables, VLOOKUP and myriad of Excel functions, illuminating data. * Collaborated with cross-functional managers team, developed and tracked customer service statistical trends. Member of key user sub-committee. Provided trend analysis to influence and drive process improvement. * Tracked $5m capital remodel from bid to audit. Member cross sectional team of engineers, architects, general contractor, dept. heads. Provided forecasts & monthly actuals for VP Operations. Worked with talented A/P, legal dept. to implement contract, asset assignment, determine retention payout. Show less