Formulas to use:

Cell B7 Cell B12

Cell B13

Cell B14 Cell B15

Fixed Expense per Copier is a sum of the three costs in B4:B6. Revenue = Number of Copiers Leased X Copies/Month/Copier multiplied by Price Charged per Copy Cost of Goods Sold = Number of Copiers Leased multiplied by Copies/Month/Copier X Variable Cost per Copy Contribution Margin = Revenue minus Cost of Goods Sold

General & Admin. Costs = Number of Copiers Leased multiplied by the sum of the Fixed Expense per Copier and the Space Rental Rate. Net Income = Contribution Margin minus General & Admin. Costs.

Cell B16 The Margin per Copy calculation in E7 (Price Charged minus Variable Cost) is completed

in the worksheet for you.

When youve completed entering the formulas as specified above, your worksheet will look like this: