Merchandise Planning Analyst  

What you will do:

1. Target Setting:
   • Assist in setting monthly sales targets based on historical sales trends per month per class category and store performance.
2. Sales Data Analysis:
   • Monitor sell-through of all collections launched within the past six months.
   • Generate monthly store sales reports for assigned categories.
3. Demand Planning and Execution for New Collections:
   • Collaborate in proposing collection budgets based on historical sales trends.
   • Assist in planning upcoming collection demand by analyzing class type, sub-class types, sizes, fabric, color, and design/styles.
   • Support in proposing store budgets aligned with the total demand planned for upcoming collections.
   • Assist in allocating inventory to stores and online platforms based on targets.
   • Coordinate with Production and Quality Control departments to ensure the availability of new collections before the launch date.
   • Coordinate with the Distribution Department to align delivery schedules based on allocation.
   • Generate reports comparing transfer orders versus out slips for new collections.
4. Inventory Management:
   • Analyze monthly inventory and three-month average sales to identify Months to Sell (MTS).
   • Facilitate the repeat of available stocks from the warehouse and pull-out from other stores based on demand.
   • Identify and consolidate low and broken on-hand quantities per style in all stores to the store with the highest sales demand.
   • Support markdown strategies based on a markdown calendar and propose markdowns based on remaining on-hand quantities and sell-through rates.
5. Competitors Check:
   • Conduct regular competitor checks through online research and physical store visits.

What we are looking for:

• Bachelor's degree in Business Administration, Marketing, or related field.
• Strong analytical skills with proficiency in Data and Category analysis tools and techniques.
• Excellent communication and interpersonal skills.
• Detail-oriented with the ability to manage multiple tasks simultaneously.
• Knowledge of retail operations, inventory management, and demand planning principles.
• Proficiency in Microsoft Excel and other relevant software applications.
• Ability to work collaboratively in a team environment and adapt to changing priorities.
• Prior experience in a similar role in the retail industry is preferred.