|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Display Modes |
|
#1
May 4th 06, 01:31 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Calculate gross profit based on varying percentages
I am trying to calculate, based on a known product cost, what the gross sales
and gross profit dollars would be as a result of different GP percentages. I.E. Here is some data for my company's products: Sales Cost GP $ GP % $208,400 $197,354 $11,046 5.3% $201,786 $191,066 $10,720 5.3% $89,421 $82,452 $6,969 7.8% $78,808 $71,891 $6,917 8.8% $63,114 $58,706 $4,407 7.0% If I wanted to figure out how much the GP $ and Sales were for the first row using a GP % of 22%, for example, how could I calculate them? Thank you. 
|
| Ads |
|
#2
May 4th 06, 02:07 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate gross profit based on varying percentages
Input =F2/(1-0.22) in E2 and copy down
where a1:d6 is: Sales Cost GP$ GP% $208,400 $197,354 $11,046 5.30% $201,786 $191,066 $10,720 5.30% $89,421 $82,452 $6,969 7.80% $78,808 $71,891 $6,917 8.80% $63,114 $58,706 $4,407 7.00% HTH, "Pasko1" wrote: > I am trying to calculate, based on a known product cost, what the gross sales > and gross profit dollars would be as a result of different GP percentages. > > I.E. Here is some data for my company's products: > > Sales Cost GP $ GP % > $208,400 $197,354 $11,046 5.3% > $201,786 $191,066 $10,720 5.3% > $89,421 $82,452 $6,969 7.8% > $78,808 $71,891 $6,917 8.8% > $63,114 $58,706 $4,407 7.0% > > If I wanted to figure out how much the GP $ and Sales were for the first row > using a GP % of 22%, for example, how could I calculate them? Thank you. >
|
|
#3
May 4th 06, 03:14 AM
posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
Calculate gross profit based on varying percentages
make that:
Input =B2/(1-0.22) in E2 and copy down sorry, "Jim May" wrote: > Input =F2/(1-0.22) in E2 and copy down > where a1:d6 is: > Sales Cost GP$ GP% > $208,400 $197,354 $11,046 5.30% > $201,786 $191,066 $10,720 5.30% > $89,421 $82,452 $6,969 7.80% > $78,808 $71,891 $6,917 8.80% > $63,114 $58,706 $4,407 7.00% > > HTH, > > > > "Pasko1" wrote: > > > I am trying to calculate, based on a known product cost, what the gross sales > > and gross profit dollars would be as a result of different GP percentages. > > > > I.E. Here is some data for my company's products: > > > > Sales Cost GP $ GP % > > $208,400 $197,354 $11,046 5.3% > > $201,786 $191,066 $10,720 5.3% > > $89,421 $82,452 $6,969 7.8% > > $78,808 $71,891 $6,917 8.8% > > $63,114 $58,706 $4,407 7.0% > > > > If I wanted to figure out how much the GP $ and Sales were for the first row > > using a GP % of 22%, for example, how could I calculate them? Thank you. > >
|
| Thread Tools | |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| How do I calculate charges based on elasped time(H:MM) & rate($)? | glass-artist-web-developer | Excel Discussion (Misc queries) | 1 | March 12th 05 02:09 AM |
| gross profit margin formula | julmcgrath | Excel Discussion (Misc queries) | 2 | March 11th 05 03:01 PM |
| Calendar based on varying information/ Pivot Table General | Neil | Charts and Charting in Excel | 0 | February 22nd 05 05:09 PM |
| How do I calculate sum based on 3 conditions? | MNSNOWGAL | Excel Worksheet Functions | 4 | January 19th 05 11:35 PM |
| How do I calculate interest and deduct late fees based on date pa. | leon | New Users to Excel | 1 | January 6th 05 02:09 PM |
Linear Mode
