Arvind Fashions - Retail Planner (1-3 yrs)

1. Reporting and MIS:

Establish a structured reporting system to track progress towards the set targets. Circulate the following reports every Monday with accuracy:

- Sales Lead Generation Report:- As per discussed format.-Frequency -Weekly

- Customer Enquiry as per discussed format. Frequency -Weekly

- Target vs Achievement comparison - Sales team wise, month wise, brand wise, and sales channel wise. Frequency -Weekly

- Order Bible for FY24-25:Frequency -Weekly

o Capture details such as customer name, customer code, style code, order quantity, PO validation, billing rate, COGS, PO release date to sourcing, delivery due date, current status from sourcing, WH inward status and date with size-wise inward quantity, CBA approval status, invoice number, LR details, and final delivery date.

- YTD Invoice Register: Frequency -Weekly

o Month wise analysis by customer, brand, category wise sale compared to the current year plan. Frequency -Monthly

2. PO Tracker and Validation: Frequency As and when new POs come

- Maintain all purchase orders (POs) at the customer level including brand-category-style code-size level - Qty - Billing rate - PO received date - PO release date to Sourcing details.

3. Collection Report: Frequency - Weekly - Every Tuesday

- Compile a weekly collection report comparing the collection target versus actual collections.

- Regularly follow up with the sales team to ensure 100% collection against targets.

4. Sample Tracker: Frequency - Weekly - Every Wednesday

- Maintain a detailed sample tracker recording all samples issued to the sales team from warehouses or stores.

- Include issuance dates, product details, approval status, sample return status, and return dates for effective sample management.

5. Daily Sales Reports (DSR): Frequency - Daily

- Generate daily DSRs showcasing sales performance against targets on a daily, monthly-to-date (MTD), quarterly, and year-to-date (YTD) basis.

- Analyse variances between targets and achievements to identify areas for improvement.

6. Order vs GRN Report :Frequency - Daily

- Produce a daily report comparing customer orders with goods received notes (GRN) at warehouses.

- Monitor order fulfilment efficiency by tracking brand, product details, WH GRN, and order receipts.

7. Order vs GRN vs Billing Report: Frequency - Daily

- Develop a comprehensive report aligning orders with GRNs and billing statuses.

- Identify pending billings along with reasons for delays to expedite the billing process.

8. Distributor Monthly SOH and Sale tracker - Frequency - Monthly

9. GeM portal registration and CSD backend Support and Co-ordination