Skip to content

Bookmark and Share

Demand Planner

Date Posted: 03.25.11

Job Code

00

Department

Operations

Responsibilities

Utilize Access data base to assemble forecasting reports for sales team. Interacts with sales team - accumulating the forecasts, assembling, checking and loading to SAP. Measure forecast against actual sales and identifies / communicates exceptions. Maintains Inventory Control processes including analyzing inventory levels at the customer level and CASA shipping locations.
  • Updates and utilize Access database for forecasting processes.
  • Demand Planner in Logility
  • Measure forecast against actual sales and identifies / communicates exceptions.
  • Maintains Inventory control process including analyzing inventory levels at the customer level and CASA shipping locations.
  • Creates and downloads data from BI for forecasting reports.
  • Works with Sales Analyst to maintain appropriate forecasting groups.
  • Creates and sends out Excel forecast reports and works with sales team for modifications.
  • Aggregates returned forecasts and creates files needed to load forecast into SAP.
  • Generates and reviews monthly forecast comparison report to look for trends, issues, discrepancies and interacts with sales teams for explanations and changes.
  • Uploads forecast into SAP.
  • Works with Finance and SAP team to match up to price lists to create customer forecasts for BI.
  • Reviews issues and email requests regarding the forecast, works with Sales to adjust as necessary and makes appropriate changes in SAP as needed.
  • Reviews MRP prompts on a weekly/bi-weekly basis to adjust forecast as necessary.
  • Reviews Short Ship Reports, Critical Item Lists, and Ops Meeting notes for forecast issues.
  • Maintain SAP Planning Hierarchy for new and discontinued materials, as well as inputs marketing forecast for these items.
  • Reviews PRF’s to ensure promotions are incorporated into the forecast.
  • Assists Manager of Forecasting with other processes as needed.
  • Makes suggestions for improvements and works with Manager of Forecasting to implement changes.
  • Train others on BI, SAP, Access, and Excel as necessary.
  • Other duties as assigned
Work Relationships and Scope:
Works Closely with: Sales team, including Director of sales, marketing, purchasing, finance and corporate SAP team, EGV operations.

Performance Expectations:
Quality, accuracy, timeliness, reliability, and thoroughness of work performed; ability to gain the trust and respect of the others; maintain the integrity of confidential customer and product information; ability to communicate effectively and develop good working relationships with team members, elevators and processors; ability to work with and through others is essential to accomplish goals and objectives of the Company.

Working Conditions:
Work is performed largely in an office environment. Hours of work will generally be during regular business hours and average at least 40 hours a week. There will be some variation in work hours due to employee shift schedules, special projects, deadlines, and other concerns.

 

Skills

  • Detail Oriented. Pays attention to details, can organize self in ways to be efficient, productive and create a system that is easily navigated by all users
  • Have excellent analytical skills.
  • Communication. Excellent communicator with the ability to intuitively understand others and deliver information in a detailed, specific and concise manner.
  • Organization and planning. Plans, organizes schedules, and coordinates with other parts of the organization in an efficient, productive manner.
  • Intelligence. Learns quickly. Demonstrates ability to quickly and proficiently understand and absorb new information.
  • Strong computer skills especially in word and excel.
  • Will be a strong SAP super user.
  • Team Player. Works well with others and gains their trust.

Experience

  • Four year degree or equivalent experience (in Mfg/Operations planning, inventory control or demand planning).
  • Intermediate to advanced knowledge of Access
  • Intermediate to advanced level knowledge in Excel is required (Pivot tables, Vlookup, etc.)
  • Collaborative interpersonal skills
  • Demonstrated data and business analytical skills
  • Experienced in working with large data sets
  • Ability to prioritize workload and execute timelines
  • Open minded and collaborative on approaches to problem solving and open to learning
  • Can work independently, but checks in and shares openly
  • Continuous learning and progress to keep abreast of new techniques and tools.

Submission Instructions

Job Posting Application Procedure
Selections will be made on the basis of Qualifications, Experience, Job Knowledge, Aptitude, Attitude, Attendance Record, and Seniority (seniority is not the sole determining factor in the selection process).

Application Process
Please apply by filling submitting a current resume to Kelly Ninmer in Human Resources no later than Thursday, March 31, 2011 at 4:00 PM.

Benefits Summary

  • Paid Vacations
  • Paid Holidays
  • A 401(k) Retirement Savings Plan
  • Group Health and Dental Insurance
  • Employee Assistance Program
  • Flexible Spending Accounts - Medical and Dependant Care
  • Company Paid Life and AD & D Insurance
  • Supplemental Life Insurance
  • Long Term and Short Term Disability
  • Paid Sick Leave
  • Continuing Education Benefit
  • Complete Fitness Center

Equal Opportunity Statement

Kaytee Products is an Equal Opportunity Employer.