1. ## Goal Seek-Changing %

I have a spreadsheet where I have computed the GP% (gross Profit %). I have tried to use Goal Seek to see what the GP After deducting Variable Expenses would be if I changed the GP% to say 9%

Your assistance in this regard will be most appreciated

2. How do you want to get to the 9% GP? Changing Sales, COS or Variable Costs:

GP% = GP After / Sales
GP After = Sales - COS - Var Costs
GP% = (Sales - COS - Var Costs) / Sales

To get a GP of 9%, you can change the Sales:
Sales = (var Costs + COS) / (1-9%)

or change the Var Costs:
Var Costs = Sales (1-9%) - COS

or change the COS:
COS = Sales (1-9%) - Var Costs

Changing the Sales gives a different GPA than changing either the Var Costs or COS.

Steve

PS. If the Var Costs and COS are related to the Sales (which your spreadsheet does NOT reflect) with those dependencies you can calculate or use goal seek...

3. Hi Steve

Thanks for the info. Will change my spreadsheet accordingly

Regards

Howard

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts
•