Docstoc

Business_planning_guide

Document Sample
Business_planning_guide Powered By Docstoc
					Profit & loss year 1           Jan           Feb           Mar           Apr           May           Jun
     Variable income:
Sales (of craft products)        -£5,000       -£5,500       -£6,200       -£6,700       -£6,800       -£7,000
Assumption: sales will
gradually build up as
repeat orders have an
effect. Lower figures for
July, August are usual in
this sector due to holidays,
December (Christmas) is
our busiest month.


TEC Training Grant                   -£500         -£750         -£750         -£750         -£750         -£750
Assumption: this grant is
based on 5 trainees per
month @ £150. Full
occupancy needed to
claim full payment.
Recruitment and holiday
underoccupancy are
reflected.

       Fixed Income
Start up Grant                       -£300         -£300         -£300         -£300         -£300         -£300
Assumption: Agreed in
writing with social services


NHS Trust Contract                   -£500         -£500         -£500         -£500         -£500         -£500
Assumptions:This is a
three year contract @
£500 per month for the
provision of 3 workplaces
in the enterprise for Trust
clients. The monthly
payment is not ocupancy
related.



Total Income                     -£6,300       -£7,050       -£7,750       -£8,250       -£8,350       -£8,550

Fixed Costs
      Property Costs
rent                                 £450          £450          £450          £450          £450          £450
Assumptions: lease has
been signed for the project
premises @ £5400 for
year one. Repairs and
maintenance are the
responsibility of the
property owner.
gas/electric                  £150     £150     £150     £130     £120     £100
Assumptions:Usage
calculated based on
previous location of craft
project. Seasonal heating
demands are reflected as
are highest product output
periods.


rates                          £95      £95      £95      £95      £95      £95
Assumptions:This
ammount may reduce if
the enterprise attains
charitable status later in
the year. This is one
option being considered.



   Administration Costs
telephone/fax/email            £45      £50      £50      £50      £50      £50

Assumptions:based on
previous trends, slight
variations due to busy
production and customer
orders.


stationery/printing            £40      £40      £40      £40      £40      £40
Assumptions:This is
regular stationery, not
brochures and publications
for marketing
purposes.Costs based on
previous project.



postage                        £20      £20      £20      £20      £20      £20
Assumptions:Regular
client and contractor
correspondence
Photocopying                  £100     £100     £100     £100     £100     £100
Assumptions:Contract for
leased copier @ £100 per
month includes service
costs.

Office                         £30      £30      £30      £30      £30      £30
Materials/Consumables
Assumptions:
        Staff Costs
wages                        £2,583   £2,583   £2,583   £2,583   £2,583   £2,583
Assumptions: 2 staff @
£18,000, 1 sales staff @
£8000 basic, part time
office staff @ £5000


nat.ins & pension              £349      £349      £349      £349      £349      £349
Assumptions:estimated @
13.5% of staff wages, all
staff have pension rights


Staff travel and training      £200      £200      £200      £200      £200      £200


Assumptions: Mileage of
300 miles per month is
estimated payable to staff
@ 35p per mile. Training
funds in year onne are
limited but all staff are
qualified and trained for
their current posts.




          Other Costs
insurance                      £191      £191      £191      £191      £191      £191
Assumptions:Agreed
liability premium £1200,
property and contents
insurance £1100

advertising                     £30       £30       £30       £30       £30       £30
Assumptions:includes
advertising for TEC
trainees, general
advertising and publicity

marketing                      £450      £450      £450      £450      £450      £450
Assumptions: Flyer
production £400, brochure
printing £2000, other
marketing and promotion
costs £3000



      Variable Costs
Trainee allowances           £166.00   £250.00   £250.00   £250.00   £250.00   £250.00

Assumptions:Tec trainees
receive £50 per month
from this project to cover
travel and expenses
Cost of sales- materials             £500          £550          £620           £670          £680           £700

Assumptions:Calculated
@ 10% of total sales cost,
the main cost in the craft
products in our range is
the labour cost



Cost of sales transport              £250          £275          £310           £335          £340           £350
Assumptions:estimated by
our market research @
5% of product sales

Sales staff commission               £500          £550          £620           £670          £680           £700
Assumptions:Agreed @
10% of total sales
Unforseen costs                       £50           £50           £50            £50           £50            £50
Assumptions:Provision for
miscellaneous items

Total Expenditure                   £6,199     £6,413        £6,588            £6,693     £6,708            £6,738

Total Income                    -£6,300        -£7,050       -£7,750       -£8,250        -£8,350       -£8,550

Balance                             -£101          -£637     -£1,162       -£1,557        -£1,642       -£1,812

Note: This is a sample
profit and loss
spreadsheet, none of the
values should be taken as
examples of likely cost.
Your project will have
different income and
expenditure headings.

Cashflow year 1               Jan            Feb           mar           Apr            May           Jun
     Variable income:
Sales (of craft products)           -£500      -£2,800       -£4,595       -£5,610        -£6,105       -£6,390
Assumption: Our payment
terms are 28 days, these
figures allow for 10% early
payment, 55% payment by
due date, 30% overdue by
28 days, 10& overdue by
more than 28 days and
5% bad debt.


TEC Training Grant                                 -£500         -£750         -£750          -£750         -£750
Assumption: this grant is
paid monthly in arrears

       Fixed Income
Start up Grant                         £0            £0            £0          £1,800           £0             £0
Assumption: Agreed
incontract with social
services, payments in 2
installemnts, April and
September

NHS Trust Contract          -£1,500       £0        £0    -£1,500       £0        £0
Assumptions:Payment
agreed quarterly in
advance

Total Income                -£2,000   -£3,300   -£5,345   -£6,060   -£6,855   -£7,140

Fixed Costs
       Property Costs
rent                        £5,400        £0        £0        £0        £0        £0
Assumptions: lease to be
paid in full in January
gas/electric                    £0        £0      £450        £0        £0      £350
Assumptions:Quarterly in
rates                           £0        £0        £0    £1,140        £0        £0
Assumptions:Payable in
    Administration Costs
telephone/fax/email             £0        £0      £145        £0        £0      £150
Assumptions:Quarterly in
stationery/printing             £0       £40       £40       £40       £40       £40
Assumptions:Paid monthly
postage                        £20       £20       £20       £20       £20       £20
Assumptions:Instant
payment
Photocopying                    £0        £0      £300        £0        £0      £300
Assumptions:Contract
quarterly in arrears
Office                         £30       £30       £30       £30       £30       £30
Materials/Consumables
Assumptions:Regular
spend on food, cleaning
etc
         Staff Costs
wages                       £2,583    £2,583    £2,583    £2,583    £2,583    £2,583
Assumptions: Payroll
monthly in arrears for
basic wages, expenses
one month later.
nat.ins & pension             £349      £349      £349      £349      £349      £349
Assumptions: Monthly in
arrears
Staff travel and training       £0      £200      £200      £200      £200      £200
Assumptions: Monthly in
arrears
         Other Costs
insurance                     £573        £0        £0      £573        £0        £0
Assumptions:Payable
quarterly in advance
advertising                   £180       £20       £20       £20       £20       £20
Assumptions:Loaded at
start for recruitment
marketing                             £400     £2,000     £300      £300      £300      £300
Assumptions: Flyer
production £400, brochure
printing £2000, other
marketing and promotion
costs £3000
        Variable Costs
Trainee allowances                  £166.00   £250.00   £250.00   £250.00   £250.00   £250.00
Assumptions:Payable
weekly
Cost of sales- materials                £0      £500      £550      £620      £670      £680
Assumptions:monthly in
arrears
Cost of sales transport                 £0      £250      £275      £310      £335      £340
Assumptions:monthly in
arrears
Sales staff commission                  £0      £500      £550      £620      £670      £680
Assumptions:Monthly in
arrears
Unforseen costs                        £50       £50       £50       £50       £50       £50
Assumptions:Provision for
miscellaneous items

Total Expenditure                    £9,751    £6,792    £6,112    £7,105    £5,517    £6,342

Total Income                        -£2,000   -£3,300   -£5,345   -£6,060   -£6,855   -£7,140

Balance                              £7,751    £3,492     £767     £1,045   -£1,338     -£798

Note: This is a sample
cashflow spreadsheet, none
of the timing of payments and
assumptions should be taken
as indicitive of practice in your
area. Your project will have
different cashflow trends.
Jul             Aug           Sep           Oct           Nov           Dec           total

      -£4,000     -£4,000       -£5,000       -£5,300       -£6,700      -£12,500      -£74,700




       -£600          -£600         -£750         -£750         -£750         -£600      -£8,300




       -£300          -£300         -£300         -£300         -£300         -£300      -£3,600




       -£500          -£500         -£500         -£500         -£500         -£500      -£6,000




      -£5,400     -£5,400       -£6,550       -£6,850       -£8,250      -£13,900      -£92,600



        £450          £450          £450          £450          £450          £450        £5,400
 £100     £120     £150     £150     £150     £200     £1,670




  £95      £95      £95      £95      £95      £95     £1,140




  £40      £40      £50      £50      £55      £75      £605




  £40      £40      £40      £40      £40      £40      £480




  £20      £20      £20      £20      £20     £120      £340



 £100     £100     £100     £100     £100     £100     £1,200




  £30      £30      £30      £30      £30      £30      £360



£2,583   £2,583   £2,583   £2,583   £2,583   £2,583   £30,996
  £349      £349      £349      £349      £349      £349    £4,184




  £200      £200      £200      £200      £200      £200    £2,400




  £191      £191      £191      £191      £191      £191    £2,292




   £30       £30       £30       £30       £30       £30     £360




  £450      £450      £450      £450      £450      £450    £5,400




£200.00   £200.00   £250.00   £250.00   £250.00   £200.00   £2,766
        £400          £400          £500           £530          £670      £1,250          £7,470




        £200          £200          £250           £265          £335          £625        £3,735




        £400          £400          £500           £530          £670      £1,250          £7,470


         £50           £50           £50            £50           £50           £50            £600



      £5,928      £5,948        £6,288            £6,363     £6,718        £8,288        £78,868

      -£5,400     -£5,400       -£6,550       -£6,850        -£8,250      -£13,900      -£92,600

        £528          £548          -£262         -£487      -£1,532       -£5,612      -£13,732




Jul             Aug           Sep           Oct            Nov           Dec           total

      -£6,260     -£4,980       -£4,200       -£4,380        -£4,955       -£6,355      -£57,130




       -£750          -£600         -£600         -£750          -£750         -£750      -£7,700




          £0            £0      £1,800               £0            £0            £0        £3,600
-£1,500       £0        £0    -£1,500       £0        £0     -£6,000




-£8,510   -£5,580   -£3,000   -£6,630   -£5,705   -£7,105   -£67,230



    £0        £0        £0        £0        £0        £0     £5,400


    £0        £0      £370        £0        £0      £500     £1,670

    £0        £0        £0        £0        £0        £0     £1,140


    £0        £0      £130        £0        £0      £180       £605

   £40       £40       £40       £40       £40       £40       £440

   £20       £20       £20       £20       £20      £120       £340


    £0        £0      £300        £0        £0      £300     £1,200


   £30       £30       £30       £30       £30       £30       £360




£2,583    £2,583    £2,583    £2,583    £2,583    £2,583    £30,996




  £349      £349      £349      £349      £349      £349     £4,184


  £200      £200      £200      £200      £200      £200     £2,200



  £573        £0        £0      £573        £0        £0     £2,292


   £20       £20       £20       £20       £20       £20       £400
  £300      £300      £300      £300      £300      £300     £5,400




£200.00   £200.00   £250.00   £250.00   £250.00   £200.00    £2,766


  £700      £400      £400      £500      £530      £670     £6,220


  £350      £200      £200      £250      £265      £335     £3,110


  £700      £400      £400      £500      £530      £670     £6,220


   £50       £50       £50       £50       £50       £50       £600



 £6,115    £4,792    £5,642    £5,665    £5,167    £6,547   £75,543

-£8,510   -£5,580   -£3,000   -£6,630   -£5,705   -£7,105   -£67,230

-£2,395     -£788    £2,642     -£965     -£538     -£558    £8,313

				
DOCUMENT INFO
Shared By:
Categories:
Stats:
views:0
posted:6/25/2012
language:
pages:12
Description: elearning, education