![]() Variable Cells: C2 (Cost or stockiest Price per unit) and C3 (Selling Price per unit to customers).Target Cell: D4 (Profit %) should give a 20% profit.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 |