Help with what should be a simple formula..

  • Thread starter Thread starter Shaun H
  • Start date Start date
S

Shaun H

Hi guys! I'm blanking out on how to write this simple formula, and
honestly, not sure how to search the forum for help with this
particular one.

I'm trying to find profit margins basically. I want to break down
profits into 1 Hr, 2 Hrs 8 hrs, etc.. for example, I the time it takes
to produce item#1...say 10 Minutes.. In the 1 hr box want to figure
out the profit based on 60 minutes of work.. My table looks like
this..

A1=Item#1; B1=Cost to make Item; C1=Selling Price; D1=Time to make
Item; E1=60 Minute profit; E2=120 Minute Profie.etc.tec.etc.
A2=Item#2............................................

Data is like this for the first 2 items

A1=Item 1; B1=25; C1=48; D1=120 E1; F1; G1 are what im trying to find
A2=Item 2; B2=10; C2=10; THen find same info..



Thanks for all of your help.
Shaun
 
Shaun H said:
Hi guys! I'm blanking out on how to write this simple formula, and
honestly, not sure how to search the forum for help with this
particular one.

I'm trying to find profit margins basically. I want to break down
profits into 1 Hr, 2 Hrs 8 hrs, etc.. for example, I the time it takes
to produce item#1...say 10 Minutes.. In the 1 hr box want to figure
out the profit based on 60 minutes of work.. My table looks like
this..

A1=Item#1; B1=Cost to make Item; C1=Selling Price; D1=Time to make
Item; E1=60 Minute profit; E2=120 Minute Profie.etc.tec.etc.
A2=Item#2............................................

Data is like this for the first 2 items

A1=Item 1; B1=25; C1=48; D1=120 E1; F1; G1 are what im trying to find
A2=Item 2; B2=10; C2=10; THen find same info..
Click to expand...


Off the top oof my head, calculate the profit per minute then multiply
by 60, 120, ...

so,
E1 (1 hr) = 1*60*(C1-B1)/D1
F1 (2 hr) = 2*60*(C1-B1)/D1

or, to avoid re-calculating the cost for each cell:

F1 = 2*E1

then copy each formula down.
 
Clif McIrvin said:
Off the top oof my head, calculate the profit per minute then multiply
by 60, 120, ...

so,
E1 (1 hr) = 1*60*(C1-B1)/D1
F1 (2 hr) = 2*60*(C1-B1)/D1

or, to avoid re-calculating the cost for each cell:

F1 = 2*E1

then copy each formula down.
Click to expand...


Something else you could do which would 1) give you column headings and
2) allow you to see different time periods without changing formulas:

Make Row 1 a column headings row, with cells A1-E1 containing what you
said above. Format F1 [ Number | Custom = 0 \Hr\s\. ] and paste that
format as far to the right as you wish. The [ \ ] is an escape character
that tells Excel to print the following character "as is" when it
formats the cell. Thus, F1 = 2 would display as [ 2 Hrs. ], F1 = 8 would
display as [ 8 Hrs. ], etc.

Moving your example data down one row, your formulas now would be:
E2 (1 hr) = 1*60*(C2-B2)/D2
F2 = F$1*$E2
Copy F2 to the right as far as you need.
Copy E2-?2 down.
 
Back
Top