I have never used Solver in Excel before :(
Here is the scenario for a company say "Company1". Sample File Attached.
1) I want to increase the profit margin for the quarter as a whole to 2.25%.
Say I plan to do this by reducing expenses and increasing sales, as follows:-
a) Reducing payroll expenses in both February and March to £7350
b) Reducing marketing expenses in March to £750
a) Increasing January Merchandise sales by means of a post-Christmas Sale.
The owner of "Company1" believes he will have to spend an additional £250 on marketing in January in order to promote the Sale. He needs to know the answer to the following question:-
How much Merchandise does he need to sell in January in order to achieve a quarterly profit margin of 2.25%? (In other words, what sales are needed in January to achieve his target, given the above constraints?).
I need to create an Report comparing the original and final values for the Target and Adjustable.
How should I go about it? I am using Excel 2003.