1. Taking into account the data in Exhibit 1, construct a table that calculates when a hen is "spent" (end of 78 week) under normal conditions such as the CCF Brands contract, or that could be used to decide when it is no longer profitable to continue egg production. That is, formulate a model with formulas for which you can easily vary inputs, such as price, profit, or variable costs (such as in question 2 below). Use the output template provided below. (Hint: Distinguish between relevant and non-relevant costs. Determine the estimated revenue per dozen and weekly production costs first.)