View Question
Q: Excel Question ( No Answer,   3 Comments )
 Question
 Subject: Excel Question Category: Computers > Algorithms Asked by: fdic-ga List Price: \$10.00 Posted: 03 Apr 2005 20:10 PDT Expires: 04 Apr 2005 11:33 PDT Question ID: 504541
 ```I have a problem that I am trying to work out. I own several orchards in different parts of the US. I need help developing a formula to determine an efficiency factor for each orchard. These orchards have many different characteristics such as size, climate, cost of water, amount of chemicals needed etc. The orchards have undeveloped land and we are constantly adding more seedling trees. There are four elements that I know, Total acreage developed Total cost for maintaining the orchard for a time period Total number of trees planted in the orchard Density of acreage (number of trees per acre) Number of trees planted in a time period I worked out the following formula but there is a problem with it. I had to put it the rest of the question in HTML so you can see the chart. Please paste it to an HTML editor and you will get it. Please ask if you have any questions. I have a problem that I am trying to work out

I have a problem that I am trying to work out.  I own several orchards in different parts of the US.  I need help developing a formula to determine an efficiency factor for each orchard.  These orchards have many different characteristics such as size, climate, cost of water, amount of chemicals needed etc.  The orchards have undeveloped land and we are constantly adding more seedling trees.

There are four elements that I know,

Total acreage developed

Total cost for maintaining the orchard for a time period

Total number of trees planted in the orchard

Density of acreage (number of trees per acre)

Number of trees planted in a time period

I worked out the following formula but there is a problem with it.

The reason why I chose 1000 is because that is the capacity of an acre.

I did the following in Excel (2nd row shows formulas, 3rd has values).

A

B

C

D

E

F

G

H

Trees total

Developed acres

Density

Total Maintenance expense

Number of Plantings

Cost per acre

Adjusted cost per acre

Factor

25000

200

=((A4/B4)/1000)

200000

2000

=D4/B4

=F4*C4

=(G4/E4)*100

25000

200

0.125

200000

2000

1000

125

6.25

When I change the density and the cost stays the same the factor should go down (more upkeep but the same cost) but instead it goes up.

Everything else works fine but this one part.

``` Clarification of Question by fdic-ga on 04 Apr 2005 09:02 PDT ```That did help by reducing my factor if more trees were identified and added, it changed the density of the orchard but what if I add more acreage it should decrease my factor (more acreage maintained at the same dollars). For some reason it changes the cost per acre and the density but not the adjusted cost per acre or the factor. Something in the math???```
 There is no answer at this time.

 ```I think your formula in column G is reversed. To get the adjusted cost per acre you multiply F4 by C4. The units for this would be (cost/acre)*(tree/acre)=(cost*tree)/(acre^2). If you want to find cost per tree then G4 should be =F4/C4. Hope this helps!```
 ```It changes here. I would look at my formulas more closely and see if they are in fact referencing the appropriate values.```
 ```I figured out what the problem was it was a reference problem as you correctly suggested. Thank you for your help.```