Trees, Demand, STD Dev, For Sale, In$-$Field

Christmas Palm, $81,31,74,440$

Washingtonia, $165,155,374,4$

Gumbo Limbo, $159,35,70,0$

Tyellow Poinciana, $49,32,42,394$

Weeping Podo, $185,68,290,226$

Your first task is to evaluate the inventory $$position$$ of each tree. The farm does not keep any backorder information, so the only data you have is $$for$-$sale$$ and $$in$-$field$$ quantities. Think about $$for$-$sale$$ as on$-$hand trees, and $$in$-$field$$ as on$-$order trees. Calculate the inventory position using two measures: the actual number of trees and an estimate of the years$-$of$-$supply for each tree. The current year forecast can be used to estimate years$-$of$-$supply. Answer this question by creating two columns that capture this information.