Inventory/Purchasing Analyst

Watsco; Phoenix (AZ); On-site; USD 55,000 - 75,000; Full time

Job summary

Watsco in Phoenix, AZ is seeking an Inventory Analyst to monitor and optimize stock levels across locations. The role encompasses analyzing discrepancies, updating costs, conducting weekly cycle counts, and coordinating with carriers, suppliers, and internal teams to maintain accurate inventory records.

You will produce weekly aging reports, review PPV variations, and drive improvements to reduce shortages and excess inventory while ensuring timely adjustments and clear communication with stores

Responsibilities

• Maintain information on all stocking items and vendor information in ERP, including costs.
• Set up and maintain new part numbers as needed.
• Monitor the timeliness of cost updates.
• Analyze and explain PPV variations at month end.
• Conduct and coordinate weekly cycle counts across locations.
• Enter inventory adjustments within 8 days after completing counts.
• Prepare and send communications to stores with significant differences and expected completion dates.
• Monitor and process Carrier and RCD invoices with price/quantity differences.
• Coordinate annual physical inventory.
• Develop policies and procedures for purchase and processing of Icron items.
• Review aging of inventory and address slow or excess stock.
• Investigate and process inventory adjustments and root-cause analyses.
• Monthly review of unavailable inventory reports and related warranty expenses.

Job description

Summary

In this role you will be responsible to perform and report a variety of analysis such as inventory discrepancies, excess or obsolete inventory, freight costs, and unavailable inventory. You will also be in charge of maintaining costs updated according to latest purchases.

Essential Duties and Responsibilities

Information Management

• Maintain information on all stocking items and vendor information, including costs, in our ERP system.
• Set up and maintain new part numbers as needed.

Cost Updates

• Monitor the timeliness of cost updates.
• Analyze and explain PPV variations at month end.

Cycle Counts

• Conduct and coordinate weekly cycle counts on all locations.
• Analyze and report results.
• Enter inventory adjustments within a maximum of 8 days after completing the inventory count.
• Recommend changes, upgrades, or policies to correct generated differences.
• Prepare and send communications to each store with significant differences and expected completion dates.

Carrier and RCD Invoices

• Monitor and process Carrier and RCD invoices with differences in price or quantity.
• Monitor orders not received 30 days past the expected receive date.
• Prepare and monitor claims related to these suppliers.
• Update claim status.
• Coordinate monthly meetings to review the status of the Carrier account.

Icron

• Monitor the aging of Icron items.
• Develop policies and procedures for purchase and processing of Icron items.
• Conduct monthly or weekly reviews of Icron as needed.
• Move items to regular inventory when determined they will not be sold.
• Provide weekly reports on aging.
• Contact owners and obtain commitments to action plans.
• Coordinate the annual physical inventory.
• Develop location reports including order and item codes.

Inventory Adjustments

• Perform permanent review of account 4000.
• Investigate and process inventory adjustments.
• Conduct root‑cause analysis of adjustments.

Soxa

• Weekly review and follow‑up to completion of outstanding issues related to operations such as negative inventory and zero cost items.
• Address price variations.
• Handle returns.

Margin Hold

• Review and approve margin hold for all segments.
• Perform activity on a daily or weekly basis.
• Contact order owners or managers for explanations of differences.

Freight In

• Keep a log of all freight expenses by vendor and purchase orders placed by all vendors.
• Analyze freight logs to calculate freight factor per vendor, twice a year or as needed.

ESD

• Review and analyze ESD (excess, slow, and damaged) inventory.
• Host and present results in weekly meetings.

Unavailable Inventory

• Monthly review, follow‑up, and investigation of unavailable inventory reports to set month‑end reserve.
• Investigate and process warranty expenses in unavailable inventory.
• Monitor the collection and elimination of unavailable inventory from stores.