Equipment and Parts Forecast Analyst

Employer Information

Organization Name: Lohmiller & Company dba Carrier West
About Our Organization: Lohmiller & Company dba Carrier West is a leading HVAC (Heating, Ventilation & Air Conditioning) distributor in the Rocky Mountain region for over 30 years. We partner with contractors, engineers and developers to provide comfort solutions for buildings and structures of all types and sizes. People and products make our organization the leader that it is today.

We are a drug-free workplace. Pre-employment and other routine drug screening is mandatory.

We are also one of The Denver Posts Top Places to Work for 2012, 2013, 2014, 2015, 2017, 2018, 2019, 2020, 2021, 2023 and 2024.

Lohmiller & Company is an equal opportunity employer. Lohmiller & Company is committed in all areas to providing a work environment that is free from harassment.

Benefits:

• Competitive pay
• Benefits package including: Medical, Dental and Vision Insurance
• Health and wellness events
• Paid Time Off and Holidays
• 401(k)

Relocation expenses are NOT included with this job offer.

Behaviors Contributing to Our Success:

• Require integrity in all dealings and relationships
• Treat people with dignity and respect
• Address issues in a prompt and honest manner
• Foster an environment where employees trust one another to be honest and do what is right
• Promote understanding that both individual accountability and teamwork are essential to our success
• Strive to create an atmosphere that is challenging, rewarding and fun
• Formulate decisions and evaluations based upon facts and objective considerations
• Recognize that with self-confidence, change is viewed as an opportunity for continuous improvement
• Continue development of our skills and talents to help ensure long-term business and personal growth
• Establish aggressive objectives that are understandable and achievable

Website: www.Lohmiller.com/careers
Job Department: Purchasing
Reports to: John Willis, VP of Supply Chain and Logistics
Job Location: Denver, CO
FLSA Status: Exempt; Full Time M-F

SCOPE OF POSITION:

The Forecast Analyst & Buyer is responsible for forecasting demand, managing inventory levels, and ensuring the seamless procurement of goods. This role requires strategic thinking, strong analytical skills, and a proactive approach to optimize inventory, minimize stockouts, and maximize supplier performance. The position will work closely with cross-functional teams to ensure business goals are achieved efficiently.

Requirements:

• Bachelor’s degree (4-year) in Supply Chain Management, Business Administration, Operations Management, or a related field required.
• Minimum of 7 years of experience in demand planning and procurement.
• Proficiency in demand forecasting software and advanced Microsoft Excel skills.
• Strong analytical, organizational, and problem-solving skills.
• Excellent communication and interpersonal skills.

Key Responsibilities:

• Demand Forecasting and Planning:
  • Utilize demand forecasting software to predict inventory needs and align with sales and operational goals.
  • Analyze historical data, market trends, and seasonal fluctuations to develop accurate demand plans.
• Inventory Management:
  • Monitor and maintain optimal inventory levels to ensure alignment with company KPIs.
  • Identify and address inventory inefficiencies, including excess and obsolete stock.
• Procurement and Supplier Management:
  • Develop and maintain strong relationships with suppliers to ensure consistent quality, lead time adherence, and cost control.
  • Evaluate and negotiate contracts with suppliers to secure favorable terms.
• Performance Analysis and Reporting:
  • Track and report on key performance indicators (KPIs) to evaluate inventory efficiency and supplier performance.
  • Provide actionable insights to improve procurement and demand planning processes.
• Other duties as assigned that include but not limited to:
  • Help in all areas of inventory control which includes but not limited to OSD's (Over, Short and Damage) Freight Claims, Cycle Counts, Inventory returns, and Inventory discrepancies.
  • Maintain, create and approve purchase orders and update order acknowledgments to verify cost, order quantity and ship dates.
  • Check all return authorizations for completion
  • Work with pricing department to maintain cost in P21

Key Performance Indicators (KPIs):

• Days Inventory on Hand (DIO):
  • Formula: Forecasted DOIOH from Blue Ridge
  • Purpose: Calculates the average number of days it takes to sell the entire inventory. Lower DIO indicates better inventory efficiency.
• Stockout Rate:
  • Formula: (Number of Stockouts ÷ Total Orders) × 100
  • Purpose: Measures how often items are out of stock when customers order them. A lower stockout rate suggests better inventory planning.
• Supplier Lead Time Variability:
  • Formula: Standard deviation or variance in lead time from suppliers
  • Purpose: Tracks consistency in supplier delivery performance. Higher variability can lead to stockouts or excess inventory.
• Purchase Order Accuracy:
  • Formula: (Correct Orders ÷ Total Orders) × 100
  • Purpose: Measures how accurately orders are fulfilled by suppliers. Higher accuracy reduces the likelihood of discrepancies and returns.
• Obsolete Stock Percentage:
  • Formula: (Obsolete Inventory ÷ Total Inventory) × 100
  • Purpose: Tracks the percentage of stock that is no longer sellable. Reducing obsolete stock helps minimize waste and tied-up capital.
• Purchase Price Variance (PPV):
  • Formula: (Actual Purchase Price - Standard Price) × Quantity Purchased
  • Purpose: Monitors whether the company is buying materials at higher or lower costs than expected. A positive variance indicates savings, while a negative variance indicates overspending.
• Service Level (Fill Rate):
  • Formula: (Units Delivered on Time ÷ Total Units Ordered) × 100
  • Purpose: Tracks the ability of the company to fulfill customer orders on time and in full. Higher service levels indicate better performance in meeting customer demand.

Competencies:

• Strong analytical mindset with attention to detail.
• Ability to work collaboratively in a fast-paced, cross-functional environment.
• Results-oriented with a focus on continuous improvement.
• Proactive and self-motivated with excellent time management skills.