Tata Consumer Products QC Microbiologist Interview Questions and Answers

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

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