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.
<html xmlns:v="urn:schemas-microsoft-com:vml"
xmlns:o="urn:schemas-microsoft-com:office:office"
xmlns:w="urn:schemas-microsoft-com:office:word"
xmlns:x="urn:schemas-microsoft-com:office:excel"
xmlns:st2="urn:schemas-microsoft-com:office:smarttags"
xmlns:st1="urn:schemas-microsoft-com:office:cs:smarttags"
xmlns="http://www.w3.org/TR/REC-html40">
<head>
<meta http-equiv=Content-Type content="text/html; charset=windows-1252">
<meta name=ProgId content=Word.Document>
<meta name=Generator content="Microsoft Word 11">
<meta name=Originator content="Microsoft Word 11">
<link rel=File-List
href="I%20have%20a%20problem%20that%20I%20am%20trying%20to%20work%20out_files/filelist.xml">
<title>I have a problem that I am trying to work out</title>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="country-region"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:smarttags"
name="place"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:cs:smarttags"
name="NumConv6p6"/>
<o:SmartTagType namespaceuri="urn:schemas-microsoft-com:office:cs:smarttags"
name="NumConv6p0"/>
<!--[if gte mso 9]><xml>
<o:DocumentProperties>
<o:Author>farrissf</o:Author>
<o:LastAuthor>farrissf</o:LastAuthor>
<o:Revision>1</o:Revision>
<o:TotalTime>96</o:TotalTime>
<o:Created>2005-04-04T01:06:00Z</o:Created>
<o:LastSaved>2005-04-04T03:00:00Z</o:LastSaved>
<o:Pages>1</o:Pages>
<o:Words>194</o:Words>
<o:Characters>1109</o:Characters>
<o:Company>SCI</o:Company>
<o:Lines>9</o:Lines>
<o:Paragraphs>2</o:Paragraphs>
<o:CharactersWithSpaces>1301</o:CharactersWithSpaces>
<o:Version>11.6360</o:Version>
</o:DocumentProperties>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:WordDocument>
<w:SpellingState>Clean</w:SpellingState>
<w:GrammarState>Clean</w:GrammarState>
<w:DrawingGridHorizontalSpacing>6 pt</w:DrawingGridHorizontalSpacing>
<w:DisplayHorizontalDrawingGridEvery>2</w:DisplayHorizontalDrawingGridEvery>
<w:DisplayVerticalDrawingGridEvery>2</w:DisplayVerticalDrawingGridEvery>
<w:ValidateAgainstSchemas/>
<w:SaveIfXMLInvalid>false</w:SaveIfXMLInvalid>
<w:IgnoreMixedContent>false</w:IgnoreMixedContent>
<w:AlwaysShowPlaceholderText>false</w:AlwaysShowPlaceholderText>
<w:Compatibility>
<w:BreakWrappedTables/>
<w:SnapToGridInCell/>
<w:WrapTextWithPunct/>
<w:UseAsianBreakRules/>
<w:UseWord2002TableStyleRules/>
</w:Compatibility>
<w:BrowserLevel>MicrosoftInternetExplorer4</w:BrowserLevel>
</w:WordDocument>
</xml><![endif]--><!--[if gte mso 9]><xml>
<w:LatentStyles DefLockedState="false" LatentStyleCount="156">
</w:LatentStyles>
</xml><![endif]--><!--[if !mso]><object
classid="clsid:38481807-CA0E-42D2-BF39-B33AF135CC4D" id=ieooui></object>
<style>
st2\:*{behavior:url(#ieooui) }st1\:*{behavior:url(#ieooui) }
</style>
<![endif]-->
<style>
<!--
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{mso-style-parent:"";
margin:0in;
margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:12.0pt;
font-family:"Times New Roman";
mso-fareast-font-family:"Times New Roman";}
@page Section1
{size:8.5in 11.0in;
margin:1.0in 1.25in 1.0in 1.25in;
mso-header-margin:.5in;
mso-footer-margin:.5in;
mso-paper-source:0;}
div.Section1
{page:Section1;}
-->
</style>
<!--[if gte mso 10]>
<style>
/* Style Definitions */
table.MsoNormalTable
{mso-style-name:"Table Normal";
mso-tstyle-rowband-size:0;
mso-tstyle-colband-size:0;
mso-style-noshow:yes;
mso-style-parent:"";
mso-padding-alt:0in 5.4pt 0in 5.4pt;
mso-para-margin:0in;
mso-para-margin-bottom:.0001pt;
mso-pagination:widow-orphan;
font-size:10.0pt;
font-family:"Times New Roman";
mso-ansi-language:#0400;
mso-fareast-language:#0400;
mso-bidi-language:#0400;}
</style>
<![endif]--><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="2050"/>
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1"/>
</o:shapelayout></xml><![endif]-->
</head>
<body lang=EN-US style='tab-interval:.5in'>
<div class=Section1>
<p class=MsoNormal>I have a problem that I am trying to work out.<span
style='mso-spacerun:yes'> </span>I own several orchards in different parts of
the <st2:country-region w:st="on"><st2:place
w:st="on">US</st2:place></st2:country-region>.<span
style='mso-spacerun:yes'> </span>I need help developing a formula to determine
an efficiency factor for each orchard.<span style='mso-spacerun:yes'>
</span>These orchards have many different characteristics such as size,
climate, cost of water, amount of chemicals needed etc.<span
style='mso-spacerun:yes'> </span>The orchards have undeveloped land and we are
constantly adding more seedling trees. </p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>There are four elements that I know,</p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Total acreage developed</p>
<p class=MsoNormal>Total cost for maintaining the orchard for a time period</p>
<p class=MsoNormal>Total number of trees planted in the orchard</p>
<p class=MsoNormal>Density of acreage (number of trees per acre)</p>
<p class=MsoNormal>Number of trees planted in a time period</p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I worked out the following formula but there is a problem
with it.</p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>The reason why I chose <st1:NumConv6p0 val="1000" sch="1"
w:st="on">1000</st1:NumConv6p0> is because that is the capacity of an acre.</p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>I did the following in Excel (<st1:NumConv6p0 val="2" sch="1"
w:st="on">2</st1:NumConv6p0><sup>nd</sup> row shows formulas, <st1:NumConv6p0
val="3" sch="1" w:st="on">3</st1:NumConv6p0><sup>rd</sup> has values).</p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<table class=MsoNormalTable border=0 cellspacing=0 cellpadding=0 width="102%"
style='width:102.82%;border-collapse:collapse;mso-padding-alt:0in
5.4pt 0in 5.4pt'>
<tr style='mso-yfti-irow:0;mso-yfti-firstrow:yes;height:12.75pt'>
<td width="8%" nowrap valign=bottom style='width:8.56%;background:#E0E0E0;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal align=center style='text-align:center'><b
style='mso-bidi-font-weight:normal'><span style='font-size:10.0pt;font-family:
Arial'>A<o:p></o:p></span></b></p>
</td>
<td width="8%" nowrap valign=bottom style='width:8.44%;background:#E0E0E0;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal align=center style='text-align:center'><b
style='mso-bidi-font-weight:normal'><span style='font-size:10.0pt;font-family:
Arial'>B<o:p></o:p></span></b></p>
</td>
<td width="18%" nowrap valign=bottom style='width:18.44%;background:#E0E0E0;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal align=center style='text-align:center'><b
style='mso-bidi-font-weight:normal'><span style='font-size:10.0pt;font-family:
Arial'>C<o:p></o:p></span></b></p>
</td>
<td width="14%" nowrap valign=bottom style='width:14.5%;background:#E0E0E0;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal align=center style='text-align:center'><b
style='mso-bidi-font-weight:normal'><span style='font-size:10.0pt;font-family:
Arial'>D<o:p></o:p></span></b></p>
</td>
<td width="11%" nowrap valign=bottom style='width:11.98%;background:#E0E0E0;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal align=center style='text-align:center'><b
style='mso-bidi-font-weight:normal'><span style='font-size:10.0pt;font-family:
Arial'>E<o:p></o:p></span></b></p>
</td>
<td width="16%" nowrap valign=bottom style='width:16.64%;background:#E0E0E0;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal align=center style='text-align:center'><b
style='mso-bidi-font-weight:normal'><span style='font-size:10.0pt;font-family:
Arial'>F<o:p></o:p></span></b></p>
</td>
<td width="8%" nowrap valign=bottom style='width:8.18%;background:#E0E0E0;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal align=center style='text-align:center'><b
style='mso-bidi-font-weight:normal'><span style='font-size:10.0pt;font-family:
Arial'>G<o:p></o:p></span></b></p>
</td>
<td width="13%" nowrap valign=bottom style='width:13.26%;background:#E0E0E0;
padding:0in 5.4pt 0in 5.4pt;height:12.75pt'>
<p class=MsoNormal align=center style='text-align:center'><b
style='mso-bidi-font-weight:normal'><span style='font-size:10.0pt;font-family:
Arial'>H<o:p></o:p></span></b></p>
</td>
</tr>
<tr style='mso-yfti-irow:1;height:12.75pt'>
<td width="8%" nowrap valign=bottom style='width:8.56%;padding:0in
5.4pt 0in 5.4pt;
height:12.75pt' x:num>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:Arial'>Trees
total<o:p></o:p></span></p>
</td>
<td width="8%" nowrap valign=bottom style='width:8.44%;padding:0in
5.4pt 0in 5.4pt;
height:12.75pt'>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:Arial'>Developed
acres<o:p></o:p></span></p>
</td>
<td width="18%" nowrap valign=bottom style='width:18.44%;padding:0in
5.4pt 0in 5.4pt;
height:12.75pt'>
<p class=MsoNormal><span
style='font-size:10.0pt;font-family:Arial'>Density<o:p></o:p></span></p>
</td>
<td width="14%" nowrap valign=bottom style='width:14.5%;padding:0in
5.4pt 0in 5.4pt;
height:12.75pt'>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:Arial'>Total
Maintenance expense<o:p></o:p></span></p>
</td>
<td width="11%" nowrap valign=bottom style='width:11.98%;padding:0in
5.4pt 0in 5.4pt;
height:12.75pt'>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:Arial'>Number of
Plantings<o:p></o:p></span></p>
</td>
<td width="16%" nowrap valign=bottom style='width:16.64%;padding:0in
5.4pt 0in 5.4pt;
height:12.75pt'>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:Arial'>Cost per
acre<o:p></o:p></span></p>
</td>
<td width="8%" nowrap valign=bottom style='width:8.18%;padding:0in
5.4pt 0in 5.4pt;
height:12.75pt'>
<p class=MsoNormal><span style='font-size:10.0pt;font-family:Arial'>Adjusted
cost per acre<o:p></o:p></span></p>
</td>
<td width="13%" nowrap valign=bottom style='width:13.26%;padding:0in
5.4pt 0in 5.4pt;
height:12.75pt'>
<p class=MsoNormal><span
style='font-size:10.0pt;font-family:Arial'>Factor<o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:2;height:12.75pt'>
<td width="8%" nowrap valign=bottom style='width:8.56%;padding:0in
5.4pt 0in 5.4pt;
height:12.75pt' x:num>
<p class=MsoNormal><st1:NumConv6p0 val="25000" sch="1" w:st="on"><span
style='font-size:10.0pt;font-family:Arial'>25000</span></st1:NumConv6p0><span
style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></p>
</td>
<td width="8%" nowrap valign=bottom style='width:8.44%;padding:0in
5.4pt 0in 5.4pt;
height:12.75pt' x:num>
<p class=MsoNormal><st1:NumConv6p0 val="200" sch="1" w:st="on"><span
style='font-size:10.0pt;font-family:Arial'>200</span></st1:NumConv6p0><span
style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></p>
</td>
<td width="18%" nowrap valign=bottom style='width:18.44%;padding:0in
5.4pt 0in 5.4pt;
height:12.75pt' x:num="0.125" x:fmla="=((A2/B2)/1000)">
<p class=MsoNormal><span
style='font-size:10.0pt;font-family:Arial'>=((A<st1:NumConv6p0
val="4" sch="1" w:st="on">4</st1:NumConv6p0>/B<st1:NumConv6p0 val="4" sch="1"
w:st="on">4</st1:NumConv6p0>)/<st1:NumConv6p0 val="1000" sch="1"
w:st="on">1000</st1:NumConv6p0>)<o:p></o:p></span></p>
</td>
<td width="14%" nowrap valign=bottom style='width:14.5%;padding:0in
5.4pt 0in 5.4pt;
height:12.75pt' x:num>
<p class=MsoNormal><st1:NumConv6p0 val="200000" sch="1" w:st="on"><span
style='font-size:10.0pt;font-family:Arial'>200000</span></st1:NumConv6p0><span
style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></p>
</td>
<td width="11%" nowrap valign=bottom style='width:11.98%;padding:0in
5.4pt 0in 5.4pt;
height:12.75pt' x:num>
<p class=MsoNormal><st1:NumConv6p0 val="2000" sch="1" w:st="on"><span
style='font-size:10.0pt;font-family:Arial'>2000</span></st1:NumConv6p0><span
style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></p>
</td>
<td width="16%" nowrap valign=bottom style='width:16.64%;padding:0in
5.4pt 0in 5.4pt;
height:12.75pt' x:num="1000" x:fmla="=D2/B2">
<p class=MsoNormal><span
style='font-size:10.0pt;font-family:Arial'>=D<st1:NumConv6p0
val="4" sch="1" w:st="on">4</st1:NumConv6p0>/B<st1:NumConv6p0 val="4" sch="1"
w:st="on">4</st1:NumConv6p0><o:p></o:p></span></p>
</td>
<td width="8%" nowrap valign=bottom style='width:8.18%;padding:0in
5.4pt 0in 5.4pt;
height:12.75pt' x:num="125" x:fmla="=F2*C2">
<p class=MsoNormal><span
style='font-size:10.0pt;font-family:Arial'>=F<st1:NumConv6p0
val="4" sch="1" w:st="on">4</st1:NumConv6p0>*C<st1:NumConv6p0 val="4" sch="1"
w:st="on">4</st1:NumConv6p0><o:p></o:p></span></p>
</td>
<td width="13%" nowrap valign=bottom style='width:13.26%;padding:0in
5.4pt 0in 5.4pt;
height:12.75pt' x:num="6.25" x:fmla="=(G2/E2)*100">
<p class=MsoNormal><span
style='font-size:10.0pt;font-family:Arial'>=(G<st1:NumConv6p0
val="4" sch="1" w:st="on">4</st1:NumConv6p0>/E<st1:NumConv6p0 val="4" sch="1"
w:st="on">4</st1:NumConv6p0>)*<st1:NumConv6p0 val="100" sch="1"
w:st="on">100</st1:NumConv6p0><o:p></o:p></span></p>
</td>
</tr>
<tr style='mso-yfti-irow:3;mso-yfti-lastrow:yes;height:12.75pt'>
<td width="8%" nowrap valign=bottom style='width:8.56%;padding:0in
5.4pt 0in 5.4pt;
height:12.75pt' x:num>
<p class=MsoNormal><st1:NumConv6p0 val="25000" sch="1" w:st="on"><span
style='font-size:10.0pt;font-family:Arial'>25000</span></st1:NumConv6p0><span
style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></p>
</td>
<td width="8%" nowrap valign=bottom style='width:8.44%;padding:0in
5.4pt 0in 5.4pt;
height:12.75pt' x:num>
<p class=MsoNormal><st1:NumConv6p0 val="200" sch="1" w:st="on"><span
style='font-size:10.0pt;font-family:Arial'>200</span></st1:NumConv6p0><span
style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></p>
</td>
<td width="18%" nowrap valign=bottom style='width:18.44%;padding:0in
5.4pt 0in 5.4pt;
height:12.75pt' x:num="0.125">
<p class=MsoNormal><st1:NumConv6p6 val="0.125" sch="4" w:st="on"><st1:NumConv6p0
val="0.125" sch="1" w:st="on"><span style='font-size:10.0pt;font-family:
Arial'>0.125</span></st1:NumConv6p0></st1:NumConv6p6><span
style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></p>
</td>
<td width="14%" nowrap valign=bottom style='width:14.5%;padding:0in
5.4pt 0in 5.4pt;
height:12.75pt' x:num>
<p class=MsoNormal><st1:NumConv6p0 val="200000" sch="1" w:st="on"><span
style='font-size:10.0pt;font-family:Arial'>200000</span></st1:NumConv6p0><span
style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></p>
</td>
<td width="11%" nowrap valign=bottom style='width:11.98%;padding:0in
5.4pt 0in 5.4pt;
height:12.75pt' x:num>
<p class=MsoNormal><st1:NumConv6p0 val="2000" sch="1" w:st="on"><span
style='font-size:10.0pt;font-family:Arial'>2000</span></st1:NumConv6p0><span
style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></p>
</td>
<td width="16%" nowrap valign=bottom style='width:16.64%;padding:0in
5.4pt 0in 5.4pt;
height:12.75pt' x:num>
<p class=MsoNormal><st1:NumConv6p0 val="1000" sch="1" w:st="on"><span
style='font-size:10.0pt;font-family:Arial'>1000</span></st1:NumConv6p0><span
style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></p>
</td>
<td width="8%" nowrap valign=bottom style='width:8.18%;padding:0in
5.4pt 0in 5.4pt;
height:12.75pt' x:num>
<p class=MsoNormal><st1:NumConv6p0 val="125" sch="1" w:st="on"><span
style='font-size:10.0pt;font-family:Arial'>125</span></st1:NumConv6p0><span
style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></p>
</td>
<td width="13%" nowrap valign=bottom style='width:13.26%;padding:0in
5.4pt 0in 5.4pt;
height:12.75pt' x:num>
<p class=MsoNormal><st1:NumConv6p6 val="6.25" sch="4" w:st="on"><span
style='font-size:10.0pt;font-family:Arial'>6.25</span></st1:NumConv6p6><span
style='font-size:10.0pt;font-family:Arial'><o:p></o:p></span></p>
</td>
</tr>
</table>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>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.</p>
<p class=MsoNormal><o:p> </o:p></p>
<p class=MsoNormal>Everything else works fine but this one part.</p>
</div>
</body>
</html> |
