software

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,0465.3%
$201,786 $191,066 $10,7205.3%
$89,421 $82,452 $6,9697.8%
$78,808 $71,891 $6,9178.8%
$63,114 $58,706 $4,4077.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.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,
quot;Pasko1quot; wrote:

gt; I am trying to calculate, based on a known product cost, what the gross sales
gt; and gross profit dollars would be as a result of different GP percentages.
gt;
gt; I.E. Here is some data for my company's products:
gt;
gt; Sales Cost GP $GP %
gt; $208,400 $197,354 $11,0465.3%
gt; $201,786 $191,066 $10,7205.3%
gt; $89,421 $82,452 $6,9697.8%
gt; $78,808 $71,891 $6,9178.8%
gt; $63,114 $58,706 $4,4077.0%
gt;
gt; If I wanted to figure out how much the GP $ and Sales were for the first row
gt; using a GP % of 22%, for example, how could I calculate them? Thank you.
gt;

make that:
Input =B2/(1-0.22) in E2 and copy down
sorry,

quot;Jim Mayquot; wrote:

gt; Input =F2/(1-0.22) in E2 and copy down
gt; where a1:d6 is:
gt; Sales Cost GP$ GP%
gt; $208,400 $197,354 $11,046 5.30%
gt; $201,786 $191,066 $10,720 5.30%
gt; $89,421 $82,452 $6,969 7.80%
gt; $78,808 $71,891 $6,917 8.80%
gt; $63,114 $58,706 $4,407 7.00%
gt;
gt; HTH,
gt;
gt;
gt;
gt; quot;Pasko1quot; wrote:
gt;
gt; gt; I am trying to calculate, based on a known product cost, what the gross sales
gt; gt; and gross profit dollars would be as a result of different GP percentages.
gt; gt;
gt; gt; I.E. Here is some data for my company's products:
gt; gt;
gt; gt; Sales Cost GP $GP %
gt; gt; $208,400 $197,354 $11,0465.3%
gt; gt; $201,786 $191,066 $10,7205.3%
gt; gt; $89,421 $82,452 $6,9697.8%
gt; gt; $78,808 $71,891 $6,9178.8%
gt; gt; $63,114 $58,706 $4,4077.0%
gt; gt;
gt; gt; If I wanted to figure out how much the GP $ and Sales were for the first row
gt; gt; using a GP % of 22%, for example, how could I calculate them? Thank you.
gt; gt;