The spreadsheet below illustrates the earnings and spendings of Harckley Hall in 3 years.
Overall, the total income stayed almost the same during the period, but expenditure increased every year. Room hire was the biggest source of income in all three years.
In Year 1, the total income was £83,500. The company earned £34,000 from hiring rooms, £3,500 from the cafe, £22,000 from the local council and £24,000 from other sources. Expenditure was £56,000, so the profit was £27,500.
In Year 2, total income increased to £85,000. Income from room hire increased to £35,000, while income from the cafe decreased to £3,000. Funding from the local council was remained the same at £22,000 and funding from other sources increased to £25,000. Expenditure also increased to £60,000, which reduced profit to £25,000.
In Year 3, total income decreased ,to £84,000. Room hire income decreased to £32,000, but cafe income increased to £4,000. Local council funding dropped to £21,000, while other funding was £27,000. Expenditure rose again to £62,000, and profit fell to £22,000.
