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