Order Data Management and Demand Analysis & Forecasting for Jamnagar Bandhni
1. Style name: (LH_pink/JB) where LH stands for leheriya (design), pink is for the colour used in the particular style and JB stands for jacquard border fabric.
2. Order date: Which determines the style and quantity of the order.
3. Client name: For reliability and frequency of styles from the side of the buyer.
4. Product(style/colour/design): It categorizes the product into further details like specified style, the colour needed, and design details as demanded by the buyer.
5. Quantity: It will determine the price per unit.
The order received by the Artisans can be recorded into excel in the following format
STEP 2
The Attached excel is coded with the tool of X lookup which finds the similar style ordered in the whole database and collect it on the next spread sheet. it was observed that on the basis of order frequency and total demand the orders can be categorized into 3 categories. A (The maximum ordered styles), B( Medium ordered styles ) and C (The least ordered styles).
The above mentioned chart suggests the frequency of order for 2 week, quantity of the order, Category of the style which can be very easily presented by the following chats.
STEP 3
As per the data recorded into the workbook.
A-Category: Order Frequency 5-6
After analyzing the data on the basis of order frequency and total quantity it was identified that style EK_FANTA/JB, and LH_RGREEN/JB are the highly consistent styles among
all the styles having a total quantity of 75 units and 111 units respectively.
After analyzing the data on the basis of order frequency and total quantity it was identified that style EK_FANTA/JB, and LH_RGREEN/JB are the highly consistent styles among
all the styles having a total quantity of 75 units and 111 units respectively.
‘B’ Category: Order Frequency 3-4
It was identified that styles EK_GREY/JB, EK_RGREEN/JB, and LH_GREY/JB are the intermediate consistent styles after the A-category, having a total quantity of 35, 25and 35
units respectively.
units respectively.
C’- Category: Order Frequency 1-2
This category contains the least consistent styles among all the styles and consists most the majority of the styles being produced. Although some styles showing potential in terms of sales quantity. But also shows very poor consistency
This category contains the least consistent styles among all the styles and consists most the majority of the styles being produced. Although some styles showing potential in terms of sales quantity. But also shows very poor consistency
Conclusion: The objective of this study was to develop a framework that would help the artisans in demand identification. Once a considerable amount of data is recorded for one month(in this case), the artisan can easily identify the styles with consistent demand, and documenting the same for an year could suggest the styles which are classics and always in demand. These data and information can suggest the artisan and these small scale industries about the quantity, style and season to produce particular styles.
