Accountancy Costing of Overheads

Document Sample
Accountancy Costing of Overheads Powered By Docstoc
					This sheet is for you to record details about your setting. Please enter your details in the boxes
provided.
Those boxes coloured yellow will automatically populate your occupancy template.

The green box will automatically populate your weekly cost calculator.



Name of setting

Total number of places you are registered with Ofsted for

           Made up as             0-2
                                  2-3
                                  3-5

Number of weeks a year you are open

Hours of opening (AM to PM) eg 8 to 6
        How many hours per day are you open
        How many day per week are you open

           Session times
           E.g. 8 - 1 = 08:00 - 13:00
                       13:00 - 18:00

Number of sessions
formula's and calculations assume 2 sessions per day, 5 days per week.
           per day
           per week

Fees                                                                 Under 2      2 - 3's       3 - 5's
           per day
           per session
           per week

           Hourly rate



Name of Manager
Name of Owner if different

Address 1
Address 2
Address 3
Address 4
Post Code

Telephone
Email
Fax
Website



National Day Nurseries Association
National Early Years Enterprise Centre Longbow Close Huddersfield HD2 1GQ
tel: 01484 40 70 70 fax: 01484 40 70 60
email: info@ndna.org.uk www.ndna.org.uk
Company Limited by Guarantee Registered in England Company No: 1078275 Vat No: 758962567
Staff Training
Employers NIC
Pension
Clothing Allowance / Uniform
Gardening (Gardener)
Repairs / Maintenance / Renewals
Rent / Mortgage
Business Rates
General Rates
Insurances - Employers
Insurance - Premises
Insurance - Building & Contents
Water Rates
Electricity
Gas
Waste Disposal
Printing
Postage
Telephone
Broadband / Internet
Office Stationery
Marketing & Promotion
Mini-bus
Fuel
Motor Expenses
Outings & Special Events
This table enables you to compare what you have budgeted each month, with what you actually achieve each month
You will quickly see where you are under or achieving - helping you to focus on improving income or managing cos
expenditure.

The budget figures, in the grey column should automatically be populated from the figures you entered on the budg
only need to put in your ACTUAL figures each month in the white columns.




MONTH                                    1                 2                 3                 4
                                        Jan      Jan      Feb      Feb      Mar      Mar      Apr
                                       Budget   Actual   Budget   Actual   Budget   Actual   Budget
SALES INCOME
0 - 2 YEARS                              0                 0                 0                 0
2 - 3 YEARS                              0                 0                 0                 0
3 - 5 YEARS                              0                 0                 0                 0
OOSC, Holiday Playscheme etc             0                 0                 0                 0

Other Income                             0                 0                 0                 0

Flexible Free Entitlement Funding        0                 0                 0                 0

Sale of Assets                           0                 0                 0                 0
Bank Deposit Interest Received           0                 0                 0                 0
Milk Rebate                              0                 0                 0                 0

TOTAL                                    0        0        0        0        0        0        0

PURCHASES
Food                                     0                 0                 0                 0
Milk                                     0                 0                 0                 0
Nappies                                  0                 0                 0                 0
Toiletries/Hygiene                       0                 0                 0                 0
Toys / Equipment-0-3's                   0                 0                 0                 0
Learning / Teaching Equip't 3-5's        0                 0                 0                 0
Equipment-OOS Provision                  0                 0                 0                 0
                     Total Purchases     0        0        0        0        0        0        0

   GROSS PROFIT/LOSS                     0        0        0        0        0        0        0

DIRECT EXPENSES
Salaries 0 - 2 YEARS                     0                 0                 0                 0
Salaries 2 - 3 YEARS                     0                 0                 0                 0
Salaries 3 - 5 YEARS                     0                 0                 0                 0
Manager's Salary                         0                 0                 0                 0
Cook / Chef Salary                       0                 0                 0                 0
Other Salaries                           0                 0                 0                 0
Salaries - OOS                           0                 0                 0                 0
Agency Staff                             0                 0                 0                 0
External Teachers / Support              0                 0                 0                 0
Misc Exp OOS                               0       0       0       0
Recruitment Costs                          0       0       0       0
Misc Expenses                              0       0       0       0
                       Total Expenses      0   0   0   0   0   0   0

Total Purchases & Expenses                 0   0   0   0   0   0   0


OVERHEADS
Staff Training                             0       0       0       0
Employers NIC                              0       0       0       0
Pension                                    0       0       0       0
Clothing Allowance / Uniform               0       0       0       0
Gardening (Gardener)                       0       0       0       0
Repairs / Maintenance Renewals             0       0       0       0
Rent / Mortgage                            0       0       0       0
Business Rates                             0       0       0       0
General Rates                              0       0       0       0
Insurances - Employers                     0       0       0       0
Insurance - Premises                       0       0       0       0
Insurance - Building & Contents            0       0       0       0
Water Rates                                0       0       0       0
Electricity                                0       0       0       0
Gas                                        0       0       0       0
Waste Disposal                             0       0       0       0
Printing                                   0       0       0       0
Postage                                    0       0       0       0
Telephone                                  0       0       0       0
Broadband / Internet                       0       0       0       0
Office Stationery                          0       0       0       0
Marketing & Promotion                      0       0       0       0
Mini-bus                                   0       0       0       0
Fuel                                       0       0       0       0
Motor Expenses                             0       0       0       0
Outings & Special Events                   0       0       0       0
                                   Total   0   0   0   0   0   0   0
                                                                   0
Bad Debt Provision / Unpaid Fees           0       0       0       0
Audit/Accountancy Fees                     0       0       0       0
Professional Fees                          0       0       0       0
Membership Fees (NDNA, PLA)                0       0       0       0
Loan Repayments (exc vehicle)              0       0       0       0
Bank Charges                               0       0       0       0
Furniture / Fitting Depreciation           0       0       0       0
Office Equipment Depreciation              0       0       0       0
Motor Vehicle Depreciation                 0       0       0       0
                                   Total   0   0   0   0   0   0   0

TOTAL 'COSTS'                              0   0   0   0   0   0   0

TOTAL INCOME                               0   0   0   0   0   0   0
PROFIT/LOSS   0   0   0   0   0   0   0
ually achieve each month.
income or managing costs and


you entered on the budget page. You




                        5                   6                 7                 8
              Apr      May        May      Jun      Jun      Jul      Jul      Aug      Aug
             Actual   Budget     Actual   Budget   Actual   Budget   Actual   Budget   Actual

                         0                  0                 0                 0
                         0                  0                 0                 0
                         0                  0                 0                 0
                         0                  0                 0                 0

                         0                  0                 0                 0

                         0                  0                 0                 0

                         0                  0                 0                 0
                         0                  0                 0                 0
                         0                  0                 0                 0

               0         0            0     0        0        0        0        0        0


                         0                  0                 0                 0
                         0                  0                 0                 0
                         0                  0                 0                 0
                         0                  0                 0                 0
                         0                  0                 0                 0
                         0                  0                 0                 0
                         0                  0                 0                 0
               0         0            0     0        0        0        0        0        0

               0         0            0     0        0        0        0        0        0


                         0                  0                 0                 0
                         0                  0                 0                 0
                         0                  0                 0                 0
                         0                  0                 0                 0
                         0                  0                 0                 0
                         0                  0                 0                 0
                         0                  0                 0                 0
                         0                  0                 0                 0
                         0                  0                 0                 0
    0       0       0       0
    0       0       0       0
    0       0       0       0
0   0   0   0   0   0   0   0   0

0   0   0   0   0   0   0   0   0



    0       0       0       0
    0       0       0       0
    0       0       0       0
    0       0       0       0
    0       0       0       0
    0       0       0       0
    0       0       0       0
    0       0       0       0
    0       0       0       0
    0       0       0       0
    0       0       0       0
    0       0       0       0
    0       0       0       0
    0       0       0       0
    0       0       0       0
    0       0       0       0
    0       0       0       0
    0       0       0       0
    0       0       0       0
    0       0       0       0
    0       0       0       0
    0       0       0       0
    0       0       0       0
    0       0       0       0
    0       0       0       0
    0       0       0       0
0   0   0   0   0   0   0   0   0

    0       0       0       0
    0       0       0       0
    0       0       0       0
    0       0       0       0
    0       0       0       0
    0       0       0       0
    0       0       0       0
    0       0       0       0
    0       0       0       0
0   0   0   0   0   0   0   0   0

0   0   0   0   0   0   0   0   0

0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0
  9                 10                11                12
 Sep      Sep      Oct      Oct      Nov      Nov      Dec      Dec     ANNUAL
Budget   Actual   Budget   Actual   Budget   Actual   Budget   Actual   ACTUAL

  0                 0                 0                 0                 0
  0                 0                 0                 0                 0
  0                 0                 0                 0                 0
  0                 0                 0                 0                 0

  0                 0                 0                 0                 0

  0                 0                 0                 0                 0

  0                 0                 0                 0                 0
  0                 0                 0                 0                 0
  0                 0                 0                 0                 0

  0        0        0        0        0        0        0        0        0


  0                 0                 0                 0                 0
  0                 0                 0                 0                 0
  0                 0                 0                 0                 0
  0                 0                 0                 0                 0
  0                 0                 0                 0                 0
  0                 0                 0                 0                 0
  0                 0                 0                 0                 0
  0        0        0        0        0        0        0        0        0

  0        0        0        0        0        0        0        0        0


  0                 0                 0                 0                 0
  0                 0                 0                 0                 0
  0                 0                 0                 0                 0
  0                 0                 0                 0                 0
  0                 0                 0                 0                 0
  0                 0                 0                 0                 0
  0                 0                 0                 0                 0
  0                 0                 0                 0                 0
  0                 0                 0                 0                 0
0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0   0   0   0   0   0   0   0   0

0   0   0   0   0   0   0   0   0



0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0   0   0   0   0   0   0   0   0

0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0       0       0       0       0
0   0   0   0   0   0   0   0   0

0   0   0   0   0   0   0   0   0

0   0   0   0   0   0   0   0   0
0   0   0   0   0   0   0   0   0
           Understanding your occupancy, like your cost base is very important. You can develop a simple table that give
           your current occupancy is and what vacancies you have. It is very useful as it enables you to plan forward and
           how your costs and income are driven by occupancy.

           On this page you begin to develop your annual occupancy planner.
           Don't worry if you've never done this before, just complete what you can from information you have to hand.
           Eg registers, room lists etc. If you are unsure about the future make your best estimate and use current bookin
           you should update it as the information changes.

           In the table below the blue, yellow and grey boxes are automatically populated.

           1) Please enter the percentage to budget occupancy figure you wish to work towards achieving at CELL B30 be
           Your total FTE number will be worked out for you.

           For the purposes of this exercise

           1 FTE = 10 sessions

           3 days = 6 sessions

           2 x 1/2 day sessions = 2 sessions




OCCUPANCY TEMPLATE

Capacity               0
Budget @
= FTE's               0
           Numbers of children in FTE               1         2          3          4          5
                                                   Jan       Feb        Mar        Apr        May

Capacity    Budgeted No. Children       Ages
    0               0.0                  0-2
    0               0.0                  2-3
    0               0.0                  3-5

           TOTAL FTE's                              0          0         0          0          0

           Budgeted Occupancy @         0%         0.0        0.0       0.0        0.0         0.0
           % Occupancy to budget                 #DIV/0!    #DIV/0!   #DIV/0!    #DIV/0!     #DIV/0!
           % Occupancy to capacity               #DIV/0!    #DIV/0!   #DIV/0!    #DIV/0!     #DIV/0!


           Total Vacancies                          0          0         0          0          0

           0-2 vacancies                            0          0         0          0          0
           2-3 vacancies                            0          0         0          0          0
3-5 vacancies   0   0   0   0   0
 You can develop a simple table that gives you a snapshot of what
eful as it enables you to plan forward and can help you understand




an from information you have to hand.
our best estimate and use current bookings -




o work towards achieving at CELL B30 below.




                        6          7            8       9        10         11       12        Yearly
                       Jun        Jul          Aug     Sep       Oct       Nov       Dec      Average


                                                                                                0.0
                                                                                                0.0
                                                                                                0.0

                        0          0            0       0            0      0         0         0.0

                       0.0        0.0       0.0        0.0        0.0       0.0       0.0       0.0
                     #DIV/0!    #DIV/0!   #DIV/0!    #DIV/0!    #DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!
                     #DIV/0!    #DIV/0!   #DIV/0!    #DIV/0!    #DIV/0!   #DIV/0!   #DIV/0!   #DIV/0!


                        0          0            0       0            0      0         0         0.0

                        0          0            0       0            0      0         0         0.0
                        0          0            0       0            0      0         0         0.0
0   0   0   0   0   0   0   0.0
This page calculates your basic staffing levels based on information you have already entered elsewhere in the mo
need to be mindful about your nursery environment - is it open plan, several rooms etc.
When determining your staffing you must give consideration to shift patterns, cover for holidays/sickness/training
cover for lunches and breaks each day.
You must ensure you are appropriately staffed - this helps to serve as a guide only.

The ACTUAL figures, in the yellow table should automatically be populated from the figures you entered on the occ
The STAFFING required for each group will also appear automatically in the grey table.




 CAPACITY             0   Ratio   No. Children   No. Staff           BUDGET             0
                0-2'S      1:3          0                0                        0-2'S
                2-3'S      1:4          0                0                        2-3'S
                3-5'S      1:8          0              0.0                        3-5'S
                  Total                 0              0.0                          Total


MONTH                      1           2            3         4          5          6
                          Jan         Feb          Mar       Apr        May        Jun
Actual Number of
Children - FTE's
     0-2                    0           0           0          0         0          0
     2-3                    0           0           0          0         0          0
     3-5                    0           0           0          0         0          0

Staffing Required
Based on Actual above
      0-2                  0.0         0.0         0.0        0.0       0.0        0.0
      2-3                  0.0         0.0         0.0        0.0       0.0        0.0
      3-5                  0.0         0.0         0.0        0.0       0.0        0.0
Total Staff Required       0.0         0.0         0.0        0.0       0.0        0.0




Please indicate your staffing details below - FTE = full time equivalents

If staff are contracted to work 40 hours per week they would be recorded as 1. A part-time mem
working 20 hours would be recorded as 0.5. Also apportion staff by FTE where they may share
between different child age groups e.g., 4 staff = 2.5 FTE's @ 2 to 3 year olds, 1.5 FTE's @ 3 to 4
olds.

1) Please enter ACTUAL staff below - CELLS - M54 to M56
2) Please enter ACTUAL number of indirect staff below - CELL M59

Total number of staff as FTE's and percentage of staff supporting 3 & 4 year olds will be calcula
NB: Indirect staff = management, cleaner, caretaker etc


                                                                       CAPACITY
Number of Staff Directly Supporting 0 - 2 Year Olds as FTE's
Number of Staff Directly Supporting 2 - 3 Year Olds as FTE's
Number of Staff Directly Supporting 3 - 5 Year Olds as FTE's
                                                               TOTAL

Number of Indirect Staff as Full Time Equivalents
(Staff who do not work in direct contact with children)

Total Number of Staff as Full Time Equivalents

Percentage of Total Staff Supporting 3 & 4 Year Olds
already entered elsewhere in the model BUT you

cover for holidays/sickness/training as well as



m the figures you entered on the occupancy sheet.




                Ratio    No. Children   No. Staff
                 1:3          0.0            0.0
                 1:4          0.0            0.0
                 1:8          0.0            0.0
                              0.0            0.0


                  7            8             9      10     11    12
                 Jul          Aug           Sep     Oct   Nov   Dec


                  0             0             0     0      0     0
                  0             0             0     0      0     0
                  0             0             0     0      0     0



                 0.0           0.0           0.0    0.0   0.0   0.0
                 0.0           0.0           0.0    0.0   0.0   0.0
                 0.0           0.0           0.0    0.0   0.0   0.0
                 0.0           0.0           0.0    0.0   0.0   0.0




ecorded as 1. A part-time member of staff
 by FTE where they may share their time
 3 year olds, 1.5 FTE's @ 3 to 4 year




 3 & 4 year olds will be calculated for you.
CAPACITY   BUDGET     ACTUAL
   0.0        0.0
   0.0        0.0
   0.0        0.0
   0.0        0.0       0.0




              0.0       0.0

            #DIV/0!   #DIV/0!
                                          £p       where applicable
Budgeted Annual Yearly Costs                0.00

No. Weeks Open                              0.00

Budgeted Average Annual Occupancy           0.00

Budgeted Average Monthly Costs              0.00

Budgeted Average Weekly Costs           #DIV/0!

Budgeted Average Daily Costs            #DIV/0!

Budgeted Average Daily Costs per FTE    #DIV/0!

Budgeted Average Hourly Costs per FTE   #DIV/0!

Budgeted BREAK EVEN - hourly rate           0.00




                                          £p
Actual Annual Yearly Costs                  0.00

No. Weeks Open                              0.00

Actual Average Occupancy                    0.00

Actual Average Monthly Costs                0.00

Actual Average Weekly Costs             #DIV/0!

Actual Average Daily Costs              #DIV/0!

Actual Average Daily Costs per FTE      #DIV/0!

Actual Average Hourly Costs per FTE     #DIV/0!
The most important thing for any business is to ensure that they can cover all their costs through income raised
- a nursery is no different.

The main source of your income will come from parent fees, so it is important that fees are set at the correct rate
and that they are collected in a timely manner. If your fees are too low you will struggle to remain sustainable.

It is important that you set your fees above your breakeven point - this is the point at which you neither make a
profit or a loss.

To calculate your break even point you need to know key facts about your performance.

* Annual costs
* Budgeted average number of FTE's (full time equivalents)
* Number Hours per Day
* Number Days per Week
* Number Weeks per Year

Based on what you have entered in the model your figures are as follows:

                  * Annual costs

                  * Budgeted average number of FTE's (full time equivalents)

                  * Number Hours per Day
                  * Number Days per Week
                  * Number Weeks per Year

Based on your figures we can calculate the following:

                  No. hours available per FTE per year

                  Total number of hours per year

From the figures above we can now calculate the hourly rate you would have to charge to breakeven
on your budgeted annual costs and budgeted total number of hours attended per year.

1 ) Click on the button below to arrive at the average hourly rate you need to achieve to breakeven on your budget.




                                      Hourly Rate




So you will need to achieve


Alternatively, you might wish to know what level of occupancy you need to achieve to breakeven if you have a
different hourly rate.

1) Please enter your desired hourly rate (£0.00p) in the yellow box opposite

2) Click on the button below to arrive at the average FTE occupancy of your nursery required to breakeven on your
desired hourly rate.


                                      Occupancy




So if you wish to charge      £0.00
to breakeven.

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:16
posted:12/4/2010
language:English
pages:977
Description: Accountancy Costing of Overheads document sample