A well-developed multi-tab interrelated Excel sheet.

Cost Basis Table 1: Material cost per unit Table 2: Labor cost per unit Table 3: Assets (Equipment and their annual straight-line depreciation) Table 4: Overhead Table 5: Selling and Administrative Variable costs Fixed costs Table 6: Fix and Variable Costs (Combine Table 4 and 5; remember to add DM and DL to the calculation of the variable cost) Variable Costs DM (From Table 1) DL (From Table 2) Variable OH ( From Table 4) Variable S&A ( From Table 5) Fixed Costs Fixed OH (From Table 4) Fixed S&A (From Table 5) Total Fixed Costs (This will be used for CVP analysis)