Help with what should be a simple formula..


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
 
Ad

Advertisements

C

Clif McIrvin

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


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

Advertisements

C

Clif McIrvin

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.


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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top