Question

You are a sales manager of a company that deals in cosmetic - soaps,talcum powder, moisturizer, deodorant and face pack. prepare a sales analysis in Excel worksheet and then based on that create a presentation highlighting the most profitable products of your company.

Answer 1

Answer:

In the excel worksheet, we will take different products and list then down in column form. In rows, we shall be using these fields

Row : Profit margin, Total sales /year, Expected growth rate, Material lead time, Material availability

Column : List of all the cosmetic products

Now we will do the pareto analysis on all the products and then show that value in a bar graph in EXCEL