Pricing Administrator
Current• Analyze opportunities for new business based on lead information from salespersons and create sales quotesthat align with competitive market pricing and manufacturing BOM costing data to achieve consistency in customer acquisition and recurrent new sales orders• Perform pricing updates for contract customers on a quarterly basis by analyzing and applying quarter-over-quarter changes in industry-standard plastics materials cost figures as well as freight cost changes utilizing customer-specific spreadsheets• Create and utilize Excel spreadsheets containing pivot tables, xlookups and vlookups, graphs and charts, and advanced formulas to pull and calculate BOM item information, sales order information, etc. from our ERP system, IQMS, to efficiently and accurately work up quotes for sales proposals for new items and customers• Perform daily “ship-hold” reports using Excel where appropriate sales order data is pulled from our ERP system to determine the day’s current, updated sales orders on ship-hold and production hold to send to appropriate senior-level executives and salespersons for daily reporting updates on company-wide production status• Perform weekly “open sales orders reviews” using Excel where any open sales orders are analyzed for their potentiality in price increase or decrease based on any changes in plastics resin/sheet material cost or customers’ contract (or non-contract) pricing schedule since the sales order’s initial PO date• Enter all pricing changes for each customer under their AKA (also-known-as) item information in IQMS as required for new sales order quotes or for quarterly contract and non-contract pricing changes
