$\backslash$table$[[,$Expected Yearly Demand,Std Dev,Quantity For Sale,In$-$Field Quantity$],[$Christmas Palm,$81,31,74,440],[$Washingtonia$,165,155,374,4],[$Gumbo Limbo,$159,35,70,0],[$Yellow Poinciana,$49,32,42,290],[$Weeping Podo,$185,68,290,]]$

The Expected Yearly Demand is an estimate of the demand over the next year for the tree. The Std Dev is the standard deviation, a measure of the error, that corresponds to the forecast. For sale and in$-$field quantities are given. The demand

$\frac{?}{\text{b}\text{a}\text{r}}($ Page $610)$

forecast and quantities are updated on an ongoing basis as trees are sold and planted on the farm.

Assignment

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.