Hello,
I want to use formulas to project sales for next years and maintain a gross profit Margin of (11.25%, 13.67% , 15.26%). Can anyone suggest me the best method to use in the below example? Can I use the Solver - add in?
<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>Thank you
I want to use formulas to project sales for next years and maintain a gross profit Margin of (11.25%, 13.67% , 15.26%). Can anyone suggest me the best method to use in the below example? Can I use the Solver - add in?
Particulars | Year-1 | Year-2 | Year-3 | Year-4 |
Sales | 10,000.00 | |||
| ||||
Rent | 2,000.00 | |||
Wages | 2,050.00 | |||
Printing | 3,050.00 | |||
Salaries | 1,600.00 | |||
Interest | 260.00 | |||
Gross Profit | 1,040.00 | |||
Gross Profit (%) | 10.40% | 11.25% | 13.67% | 15.26% |
<colgroup><col><col><col><col span="2"></colgroup><tbody>
</tbody>