So, for that, I need to find out the Cost or stockiest Price per unit & Selling Price per unit to customers needed to achieve a profit of 20%. Now, my target is to take the percentage profit (%) per unit to 20%. Variables (B2, B3 & C2, C3): Here, variables are Cost or stockiest Price per unit & Selling Price per unit to customers, which keeps on changing month on month. ((Selling price per unit – Stockist price per unit)/ Stockist price per unit) *100 Here, B4 & C4 is the percentage profit for the month of April & May 2019, which is calculated with the help of the below-mentioned formula. Now, I have April & May month with a percentage profit for each unit, i.e. In the above-mentioned table, the monthly sales data of price per unit, containing Cost or stockiest Price per unit & Selling Price per unit to customers. ![]() ![]() You can download this Solve Equation Excel Template here – Solve Equation Excel Template
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |