In Table 2 replace Max capacity in the Units column with the value in Table 1. Calculate Mid point by dividing Max capacity by two. Create Excel formulas and use cell references to calculate revenue and cost values based on the Units value in the first column. TR = Sx, TC = VCx FC, New TC = VCx "FC - New", and Adjusted TC = VCx "FC - Adjusted", where x = units. New TC is calculated after adding the Total Amount Due from the Case 1 invoice to the original Fixed Cost. The Adjusted TC is calculated from the supplier giving TysonBooks an overall discount of 8% on the Total Amount Due from the Case 1 invoice. The 8% discount is applied to the new purchases only and not the original fixed costs