Shawn Bausinger Email & Phone Number

Exton, Pennsylvania, United States

•Refresh and publish forecast changes on an agreed upon schedule and communicate significant changes to purchasing.•Partner with Sales to gather customer information relevant to producing an accurate forecast. Information will include product assortments (by customer), new item introductions, timing for discontinued styles, and promotional plans.•Meet regularly with Sales, Operations, and Supply Planning to monitor current forecast status and required actions such as contingency planning.•Consolidate multiple projections into a by item shipment projection.•Reconcile item level forecasts with sales projections. Identify and understand reasons for gaps.•Make recommended adjustments to the forecast based on changes in demand and market trends.•Actively participates in the Sales & Operations Planning (S&OP) / Integrated Business Planning (IBP) Process – develops monthly forecasts by product family and key account, communicates changes to aggregate forecasts, and raises S&OP forecast issues for resolution.•Provide short to medium term project support and analysis to the Demand Planning Manager.

New Castle, Delaware, United States

Forecasting, analysis, and inventory control for over 60% of the company’s business (Walmart, Lowes, Home Depot, National Hospitality).Created multiple tools in the use of tracking both on-hand inventory to service the business, as well as raw material components used in on-site production for large scale customer replenishment needs.Worked through supply chain issues in 2021 to take average inventory in-stock percentage for Walmart from 76% to 95% within six months.Maintained continuity in both sourcing and logistics when company was shorthanded, including working internationally with Global Sourcing team in China and creating inventory allocation reports for warehouses in Delaware.Executed all planning and forecasting through excel spreadsheets while new ERP system was being implemented.Oversaw initial rollout of new item assortment in Walmart stores nationally.Worked closely with company leadership on strategy and execution, leading projects and presenting results in an easily digestible manner.Provided insights and analysis for multiple departments across the company, including Channel, Sales, Logistics, Sourcing, and Product Management.

West Chester, Pennsylvania, United States

•Led large scale promotional and sales projects across organization to inform vision, strategy, features, and prioritization for clearance and liquidation products.•Oversaw addition of $14M+ of QVC liquidation inventory, doubling current size and shortening life cycle, reducing obsolescence by absorbing aged goods.•Doubled clearance and liquidation sales to over $3M per month within 5 months of assuming control of inventory by focusing sales on identified inventory and creating new promotional ideas.•Identified and communicated key sales driver opportunities by influencing planning decision making to ensure an in-stock position which met or exceeded demand sales plans.•Devised new workflow process to shorten inventory life cycle from three years to two years through promotion and liquidation channels to reduce obsolescence and ease pressure on margin.•Performed extensive analysis of large data sets to deliver forecasting, insights, and recommendations for overall strategy, promotion, price, etc. for clearance and liquidation fashion products.•Consistently exceeded $200K in daily digital sales of targeted inventory by creating ongoing special offers for the website.•Identified and expedited liquidation of distressed and aged inventory by coordinating with liquidation team to target opportunities to move surplus goods and ease margin pressure.•Absorbed all digital promotions and management of total jewelry inventory for a teammate out on maternity leave.

West Chester, Pennsylvania

•Maintained $5M+ yearly sales for each specified business by planning on-air programming and collaborating with off-air and Ecommerce planners to maximize promotion.•Scripted all on-air programs according to basic standard and scripting guidelines to make or exceed stated goals for targeted businesses.•Analyzed show and item performance and recommend and initiate next actions within 48 hours.•Controlled and managed inventory, including item reorders, identifying and expediting returns to vendors, and understanding cadence and cycle of distressed items.•Established initial price for all items by adhering pricing to assigned margins and shipping and handling guidelines, along with organizing markdowns.

Qvc Studio Park

•Delivered weekly, monthly, quarterly, yearly, and ad-hoch reporting on all categories along with host achievement rate by recognizing successful trends, optimizing host and category effectiveness.•Established weekly, company-wide “Green, Red, Yellow” report focused on on-air achievement rate to plan for shows by measuring demand sales achievement rate against stated planned sales.•Uploaded monthly airtime road maps and uploaded specified airtime to weekly calendar on MP4 system, noting for conflicts or errors by teaming with planning managers to optimize airtime effectiveness.•Partnered with category planning managers and reconciled goals for monthly airtime prior to monthly schedules being released.•Updated and maintained TSV achievement and statistics on a weekly basis by pulling metrics from a content management system (Microstrategy) and comparing achievement to stated sales goals.•Streamlined app for Roku / Amazon Fire TV from conception to implementation, serving as integral member of team for rebrand and upgrade.•Increased active QVC app downloads from ~200K to over 1M installs in less than one year by expanding application content and promotional advertisements. •Oversaw maintenance and daily and weekly updates for QVC streaming app by controlling all customer facing content.•Recipient of quarterly Key Contributor Award for work on streaming app upgrade.•Led presentation of upgraded app to entire QVC US operation in a company-wide presentation.•Handpicked by Senior VP of Programming to join team after speaking in a meeting on career trajectory and company landscape.

Qvc

Qvc, West Chester Pa

Qvc Studio Park