Adding the Overheads
To complete this spreadsheet we need to add the OVERHEAD expenses associated with this business. Power, rent, phone etc.
The overheads for the six months are estimated to be $18000.
This should appear below the WAGES row in your spreadsheet.
Exercise
-
Insert a row below WAGES and label it OVERHEADS in
column A.
You may have to re-adjust the column size for column A.
-
Enter 18000 in column H as the total of this row.
We will allocate OVERHEADS equally to the months.
- Position the cursor in the cell which will hold January's allocation.
- Enter a = sign to tell Excel to expect a formula.
- Type $H$10
Ensure that you have inserted the correct
number of rows else this cell reference may be wrong.
(we will explain the $ sign shortly)
- Type /6 to divide by 6.
- Press the Enter key.
This has built the required formula in the first cell.
All that remains is to copy that cell across to the other five months.
EDITING A FORMULA
Notice the total expenses calculation does not include the
OVERHEADS we just added. We will now correct that.
Exercise
- Position the cursor in January's total expense cell.
- Press F2 to enter the EDIT mode. Note that the formula that is contained in this cell is displayed on the
formula bar for you to edit.
- Type a + sign then use the cursor, or mouse, to select the cell above and hit Enter.
- Now copy both the OVERHEAD formula and the new total expense formula across to the other cells.
Your spreadsheet should look like this :