Sunday, December 14, 2014

Indian Saris- New Book by Priyank Goyal


This book has come out after a constant search for details related to Indian traditional saris and with the experience of the author dealing with these saris as a category manager, buyer and merchandiser. This is the first volume of the series. In this volume a total of sixteen saris from different parts of India are presented. The brief is kept to the point and as simple as possible. Each chapter starts with one sari and a picture of that sari. The book is kept free from the clutter of the myths and stories associated with the saris. Technical parameters such as count, construction and weaving techniques are given for each of the saris. 

This is helpful for someone who wants to get the knowledge of all different types of Indian saris at one place. This is going to help immensely the students of Indian Traditional Textiles, researchers, merchandisers of saris and general textile enthusiast.


Wednesday, October 1, 2014

Essential Fabric Knowledge for the Merchandisers- My New Book

I take it a great pleasure to announce the arrival of my new book on Kindle. I am getting recurrent queries from readers who want the basic textile knowledge. I have conducted several sessions with store managers, buyers and merchandisers, who wished to have some basic book explaining all the relevant terms related to fabrics. I myself have struggled a lot when buying fabrics, as the terminologies are very different than those taught in textbooks of textile technology. 

It is said that merchandising is all about merchandise and the “ing” part is “right time, right place, and right cost. Thus It seems imperative that the merchandisers in the apparel trade should know about the merchandise, the building block of apparels, the fabrics.
This book is aimed at the industry professionals who are in this trade but are from a non-textile background and who want to know about fabrics. However this is equally useful for managers who are new in this trade and textile enthusiasts. 
Most of the other books dealing with fabrics are written in complex language and give more than necessary information about fabrics. In the process they go sometimes too technical and difficult to read. This book is an attempt to bridge the gap and help even novice to learn the tricks of trade very easily.
Every chapter starts with a day in the life of a merchandiser and these situations are used in this book to help learning, situations that the merchandisers learn in this trade day-in and day-out.
Special emphasis is made to cover Indian ethnic and Indian common fabrics, these are not found anywhere in this context. These fabrics have their own peculiar characteristics which make them unique to define.

I hope this book will fill a void which was long awaited to be filled.

Thursday, July 3, 2014

How to change row color based on a single cell's value

Suppose you want to change the color from rows 1-10 by putting a "yes" in column F

a. Select the rows 1-10
b. with the rows selected, click conditional formatting while selecting those rows.
c. click new rule
4. click "use a formula to determine which cell to format"
5. Put =INDIRECT("F"&ROW())="Yes"
6. Click format and change the color
7. click ok
8. click ok
9. click ok
10. You are done 

Sunday, December 30, 2012

MFM Entrance- Which Books to Refer

I have received the following question from one of my readers:

"I need some guidance like how to prepare for nift entrance exam, Which books to refer ... I would really appriciate, if you can help us out".

My advice would be to look at the entrance as any other MBA entrance examination. The level of the test is of MAT. The following books will help you a lot in preparing for the entrance.

Quantative Aptitude

1. Mathematics for MBA by RS Aggarwal: A very good book for practicing topics.

2. Magical Book on Quicker Maths: Do this book together with that from RS aggarwal. The quicker methods will help you a lot.

3. Data Interpretation - Dhillon Publication: A very good book with comprehensive practice of the data interpretation.

Reasoning and Mental Ability

1. Reasoning by R.S. Aggarwal: A very good book for practicing topics.

2. Magical Book on Analytical Reasoning: by M.K. Pandey. Do this together with that from R.S. Aggarwal.

3. Magical Book on Non Verbal Reasoning : by Javed Prabhat. A very good book for understanding non verbal topics.


1. English is Easy by Chetnanand Singh: An amazing book to brush up your grammar.

2. Word Power Made Easy: By Normal Lewis: For Vocabulary.

3. Reading Comprehension- Dhillon Publication.


Any GK book and periodic magazines will help.

Tuesday, December 4, 2012

Rural Marketing for MFM

Rural market is defined as those consisting of villages and small towns having less than 1 million population. It represents a market of 1 million consumers and USD 1 trillion market. It represents 56% of India's income and 64% of the spending and 33% of the savings. Also it is the largest consumption market for FMCG and durables. ( Source )

Rural markets represent a great potential as far as India is concerned. As per Mr Pradeep Kashyap, founder and CEO Mart, a knowledge based consulting firm on emerging markets, the biggest challenge is to  reach your product to 600,000 villages as compared to 5000 towns in urban India. 

Talking of textiles, the views are very different. As per a report in 2010, rural market is not very attractive for textile industry. A need is felt to cater to the need of the rural markets. The marketing strategies would have to be volume based. It should be low value and high volume garments which the rural markets can afford. 

As far as Ready Made Garment Sector is concerned, despite being a big chunk of India's population- about 70%, the rural market segment contributes only 54 per cent of the total domestic RMG industry in 2011. 

Talking of the categories- Saris, trousers, salwaar kameez, jeans and T-shirts account for more than 60% of the domestic RMG market ( value terms). Volume of shirts, trousers, jeans and T-shirts in the rural areas is higher than as compared to urban areas. However, as the unit realisations of these categories are higher in urban areas, their market size is higher in the urban areas. For Sarees and salwaar kameez, the gap in realisations in rural and urban areas is the least among the above-mentioned six major categories. Moreover, owing to higher sales volumes, the market size of sarees and salwar kameez in rural areas is higher than in urban areas ( Source - CRISIL)

Wednesday, November 14, 2012

Working out an ERP Application for fashion industry- My Experience

The following points I can definitely say about this:

1. The implementer themselves do not know the capabilities and limitations of their programs. So whatever they promise, take it with a pinch of salt.

2. The vision of the software in your mind will be different that you see actually, even if you have given that vision to the implementers in writing.

3. Once committed, they would try to thrust upon their vision to you. Any request for change will meet a resistance in the following way

  - Can be done in the next build
  - that will change the structure of the logic.
  - This is your wish list, wish lists keep on coming.
  - But that is what we discussed initially, and you have agreed to it.
  - But you also have to do some work to run the system.
  - this is a problem of formatting, can be done when logic is closed.

4. Building an issue list doesn't help. There will be key issues which keep on pending, the minor issues will be corrected.

5. There will be no white box testing at their end. They expect you to envisage all scenarios and give the result to them in black box testing. Every issue list will meet a resistance.

6.  If an issue is corrected, then a new issue is created in correcting the first one. Then you have to fight your way to get that issue corrected.

7. Dates and deadlines are never met.

8. If there are n steps to complete a process, with an ERP application, it will take at least n+2 steps. They say this is logical.

9. The biggest drawback here is that they have a one-fix-for-all solution with them. They try to fit all scenarios with that solution, with the result that they lose touch with the reality.

10. There are no error message which are intelligent, no user friendly tips, to start with. Every singly error message, you have to point out to them.

11. They will not document for you, will not train your staff. You have to do this that, yourself.

Thursday, July 26, 2012

Some Facts about Apparel Exports

1. EU not only accounts for 49 percent of India’s total apparel exports worth $13 billion, but is also its largest trading partner.

2. Presently, EU imposes an import duty of 9.6 percent per garment and five percent on other textile items from India.

3. So far, Indian goods cost 10-15 percent more than Chinese products and 15-20 percent higher than Bangladesh’s products.