1. 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. Trees Inventory Supply Christmas Palm Washingtonia Gumbo Limbo Yellow Poinciana Weeping Podo