Tata Consumer Products Quality Executive Interview Questions and Answers

To calculate landing price to retailer and distributor on mark up basis, determine the cost price and apply the desired mark up percentage.

• Determine the cost price of the product

• Decide on the desired mark up percentage for the retailer and distributor

• Calculate the mark up amount by multiplying the cost price with the mark up percentage

• Add the mark up amount to the cost price to get the selling price

• The selling price is...read more

The lctr for other brands at 15% markup margin would depend on their cost of production and desired profit margin.

• Calculate the cost of production for each brand

• Add 15% markup margin to the cost of production

• Subtract the cost of production from the selling price to get the lctr

• Example: If the cost of production for Brand A is $50, the selling price would be $57.50 (15% markup). If the selling price is $70, the lctr wou

Width/ Numerical Distribution and Depth/ Weightage Distribution are two methods of measuring product distribution.

• Width/ Numerical Distribution refers to the number of outlets or stores where a product is available.

• Depth/ Weightage Distribution refers to the quantity of the product available in each outlet or store.

• Both methods are important in measuring the reach and availability of a product in the market.

• For example...read more

Yes, I am familiar with pivot and Vlookup functions in Excel.

• Pivot tables are used to summarize and analyze large data sets in Excel.

• Vlookup is used to search for a value in a table and return a corresponding value from another column.

• Pivot tables can be used to create dynamic reports and perform data analysis.

• Vlookup is commonly used for data reconciliation and merging datasets.

• Both functions are powerful tools for da