Job Title
Last Reviewed
FLSA Classification
Reports To
Location
Job Type
Summary
The Allocation Assistant provides high-level administrative and operational support to the Director of Purchasing/Allocations. This role is responsible for data entry and creating shipping spreadsheet infrastructure. The ideal candidate combines strong Excel skills, process-improvement mindset, and excellent attention to detail, helping drive efficiency and accuracy in allocating products across multiple store locations.
Key Responsibilities
- Create and maintain spreadsheets for product allocations.
- Allocate products to individual store locations using established formulas and guidelines.
- Follow allocation instructions provided by the Director of Purchasing/Allocations.
- Review product quantities and confirm allocation totals for accuracy.
- Develop shipment plans based on store allocations, inventory availability, and business priorities.
- Map out shipping logistics and coordinate with warehouse and shipping teams.
- Prepare clear allocation and shipment instructions for each store.
- Track products from receipt through allocation and shipment.
- Update spreadsheets and internal systems as products are received, allocated, and shipped.
- Identify discrepancies involving quantities, allocations, or shipment information.
- Communicate allocation updates, shortages, and other concerns to the Director of Purchasing/Allocations.
- Maintain organized and accurate product and shipment records.
- Assist with additional purchasing, inventory, and allocation projects as needed.
- The ability to go into store quarterly for special projects.
- Assist with inventory/product audits when needed.
Qualifications
- High school diploma or equivalent.
- Previous experience in inventory, allocation, warehouse operations, retail, purchasing support, or a related position is preferred.
- Expert level experience of Microsoft Excel or Google Sheets.
- Ability to create, update, and maintain organized spreadsheets.
- Ability to follow existing formulas, processes, and detailed instructions.
- Basic math skills, including addition, subtraction, multiplication, division, and percentages.
- Strong attention to detail and accuracy.
- Ability to organize and prioritize multiple daily assignments.
- Effective written and verbal communication skills.
- Ability to work independently and collaborate with purchasing, warehouse, shipping, and store teams.
- Ability to work efficiently in a fast-paced, high-volume environment.
Preferred Qualifications
- Knowledge of sports cards, Pokémon, trading card games, comics, collectibles, or related products.
- Experience allocating merchandise across multiple retail locations.
- Experience receiving products and coordinating shipments.
- Familiarity with inventory-management or point-of-sale systems.
Physical Requirements
- Ability to sit or stand for extended periods.
- Ability to use a computer and review spreadsheets for extended periods.
- Ability to lift, carry, and move product shipments weighing up to 40 pounds, with or without reasonable accommodation.
- Ability to perform repetitive tasks involving sorting, counting, and organizing products.
Ideal Candidate
The ideal candidate is highly organized, dependable, and comfortable working with spreadsheets and numbers. They carefully follow established allocation formulas while checking their work for accuracy. They can manage daily product receipts, coordinate multiple store allocations, and help create efficient shipping plans. An interest in sports cards and collectibles, along with the ability to learn product categories quickly, will help this individual succeed in the role.
Target Compensation: