Remember Me?

#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.

#2
May 4th 06, 02:07 AM posted to microsoft.public.excel.worksheet.functions
 Jim May Posts: n/a
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,

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
 Jim May Posts: n/a
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,

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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post glass-artist-web-developer Excel Discussion (Misc queries) 1 March 12th 05 03:09 AM julmcgrath Excel Discussion (Misc queries) 2 March 11th 05 04:01 PM Neil Charts and Charting in Excel 0 February 22nd 05 06:09 PM MNSNOWGAL Excel Worksheet Functions 4 January 20th 05 12:35 AM leon New Users to Excel 1 January 6th 05 03:09 PM

All times are GMT +1. The time now is 10:35 AM.