Please follow up the instructions in the Assessment Document.
I’m adding some relevant templates as well.
T-
1
.8.1
Details of Assessment
Term and Year
Time allowed
7 Weeks
Assessment No
Assessment Weighting
100%
Assessment Type
Strategic & Business Plan
Due Date
Week 7
Room
TBA
Details of Subject |
|
Qualification |
BSB61015 Advanced Diploma of Leadership and Management |
Subject Name |
Strategic & Business Planning |
Details of Unit(s) of competency |
|
Unit Code (s) and Names |
BSBMGT617 Develop and implement a business plan |
BSBMGT616 Develop and Implement strategic plans |
Details of Student |
|
Student Name |
|
College |
Student ID |
Student Declaration: I declare that the work submitted is my own, and has not been copied or plagiarised from any person or source. |
Signature: ___________________________ Date: _______/________/_______________ |
Details of Assessor |
|||
Assessor’s Name |
|||
Assessment Outcome |
|||
Results |
|_| Competent |_| Not Yet Competent |
Marks |
/ 100 |
FEEDBACK TO STUDENT Progressive feedback to students, identifying gaps in competency and comments on positive improvements: |
|
________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________ |
|
Student Declaration: I declare that I have been assessed in this unit, and I have been advised of my result. I am also aware of my right to appeal and the reassessment procedure. Signature: ____________________________ Date: ____/_____/_____ |
Assessor Declaration: I declare that I have conducted a fair, valid, reliable and flexible assessment with this student, and I have provided appropriate feedback |_| Student did not attend the feedback session. Feedback provided on assessment. Signature: ____________________________ Date: ____/_____/_____ |
Purpose of the Assessment |
||
The purpose of this assessment is to assess the student in the following learning outcomes: |
Competent (C) |
Not Yet Competent (NYC) |
BSBMGT617 Develop and implement a business plan |
||
1.1 Review and evaluate pre existing strategic, business and operational plan, if available |
||
1.2 Analyse and interpret business vision, mission, values and objectives |
||
1.3 Consult with key stakeholders |
||
1.4 Review market requirements for the product or service, profile customer needs and research pricing options |
||
1.5 Develop performance objectives and measures through consultation with key stakeholders |
||
1.6 Identify financial, human and physical resource requirements for the business |
||
1.7 Consider any permits or licences that may be required for new activity |
||
1.8 Write business plan |
||
2.1 Communicate business plan to all relevant parties and ensure understanding of performance requirements and timeframes |
||
2.2 Ensure skilled labour is available to implement plan |
||
2.3 Test performance measurement systems and refine, if necessary |
||
2.4 Ensure timely reports on all key aspects of the business are available, user friendly and balanced in terms of financial and non financial performance |
||
2.5 Report system failures, product failures and variances to the business plan as they occur |
||
3.1 Analyse performance reports against planned objectives |
||
3.2 Review performance indicators and refine if necessary |
||
3.3 Ensure groups and individuals contributing to under performance are coached, and provide training where appropriate |
||
3.4 Review system processes and work methods regularly as part of continuous improvement |
||
BSBMGT616 Develop and implement strategic plans |
||
1.1 Check with stakeholders that organisational vision and mission are still held to be current and are supported |
||
1.2 Make any changes or refinements to vision or mission statement as required |
||
1.3 Review or develop organisational values to support the vision and mission statement |
||
1.4 Gain support for strategic planning process from all relevant stakeholders |
||
2.1 Determine information requirements and undertake or commission research to deliver relevant information |
||
2.2 Analyse political, economic, social, and technological developments in a global context |
||
2.3 Seek advice from appropriate experts wherever necessary |
||
2.4 Identify and consider strengths and weaknesses of existing and potential competitors and allies |
||
2.5 Analyse organisation’s strengths, weaknesses, opportunities and threats |
||
2.6 Consider cooperative ventures that are supported by risk and cost benefit analyses, are consistent with the organisational vision, mission and values and provide for due diligence |
||
2.7 Check that analysis of internal and external environment is consistent with the perspectives of other informed people |
||
3.1 Document relevant research and background for inclusion in the strategic plan |
||
3.2 Formulate strategic objectives and strategies needed for the future |
||
3.3 Detail each strategy with an assigned priority, a timeframe, responsible parties and measurable performance indicators |
||
3.4 Circulate strategic plan for comment, support and endorsement |
||
4.1 Communicate strategic plan to all relevant parties |
||
4.2 Brief people with a specific role in relation to strategies |
||
4.3 Use performance indicators to monitor progress in implementing plan |
||
4.4 Make necessary refinements to plan |
||
4.5 Evaluate achievement of objectives at agreed milestones |
||
4.6 Review effectiveness of plan and consider methods for improving strategic planning processes |
||
Assessment/evidence gathering conditions |
||
Each assessment component is recorded as either Competent (C) or Not Yet Competent (NYC). A student can only achieve competence when all assessment components listed under “Purpose of the assessment” section are recorded as competent. Your trainer will give you feedback after the completion of each assessment. A student who is assessed as NYC (Not Yet Competent) is eligible for re-assessment. |
||
Resources required for this Assessment |
||
1. Computer with relevant software applications and access to internet 1. Weekly eLearning notes relevant to the tasks/questions |
||
Instructions for Students |
||
Please read the following instructions carefully · This assessment has to be completed |X| In class |X| At home · The assessment is to be completed according to the instructions given by your assessor. |
ASSESSMENT BRIEF
This assessment comprises both the report and presentation as a summative assessment. You are required to prepare a strategic business plan report and perform a presentation for your business plan. To complete this assessment, you are required to follow the reporting structure as provided to complete the business plan (PART A) and perform a presentation of your business plan (PART B).
PART A – STRATEGIC BUSINESS PLAN – 70%
Using the Business Plan template (titled as “Main Template” and other additional templates) provided by your nominated trainer and assessor (also available in e-learning), develop a strategic business plan for a small business or enterprise of your choice or use the organisational context of Academies Australasia.
To demonstrate competency you will need to consider in your analysis the capabilities and resources of the new enterprise, vision, mission, trends and developments in the marketplace, comparative market information, and legal and ethical restraints on the proposed business activity. Finally, the business plan should provide a forecast for the long-range direction of the business and its strategic success.
You will be working to develop a business plan for your chosen business to open a new branch at Hobart. The paper and the presentation should include a well-laid process to actualize the business idea, strategic financial feasibility, marketing feasibility, and operational feasibility. In order to open a new branch to offer services at Hobart, the company needs to have the appropriate legal clearance from the relevant authority. You will also need to conduct an extensive research to identify the legal requirements and summarize your findings.
ORGANISATIONAL CONTEXT (if not using a business of your choice)
Academies Australasia is a leading education provider offering English language, Senior High School, Singapore Government School Preparatory Certificate, Diploma, Advanced Diploma, Bachelor and Master degree courses. They offer more than 100 qualifications to about 5,000 students across campuses in Sydney, Melbourne, Brisbane, Perth and Singapore. Currently, the company is planning for expansion and therefore exploring the viability of opening a branch at Hobart, Tasmania.
For more information on Academies Australasia and its operation, please visit the organisation’s website at
. Latest annual report of the company is available at
http://www.academies.edu.au/Annual-Reports.html#.Wkwgx1WWbGg
.
You will be working to develop a business plan for Academies Australasia to open a new campus at Hobart. The paper and the presentation should include a well-laid process to actualize the business idea, strategic financial feasibility, marketing feasibility, and operational feasibility. In order to open a new campus to offer vocational education qualification at Hobart, the company needs to have the appropriate legal clearance from the relevant authority. You will also need to conduct an extensive research to identify the legal requirements and summarize your findings.
There is no specific word limit on this report but you may use several templates from the detailed business plan template (titled as “Main Template”) provided and your report must follow the structure below:
STRUCTURE FOR THE STRATEGIC BUSINESS PLAN (70 %)
· Cover Page
· Executive Summary (5 marks)
· Table of Content
· Business Plan Summary (10 marks)
· The Business
· The Market
· The Future
· The Finances
· Business Plan Timeline (Gantt Chart)
· The Organisational structure & operational plan (15 marks)
· Business details
· Registration details
· Business premises
· The products and services to be offered by the organisation
· Organisation chart
· Management & ownership
· The key HR policies of the business regarding Recruitment of Staffs, Performance Appraisal, Salary and Compensations Structure.
· Key personnel
· Products/services
· Innovation
· Insurance
· Risk management
· Legal considerations
· Operations
· Sustainability plan
· The Market and market analysis (15 marks)
· Market research
· Market targets and 4 Ps of marketing for the business
· Your competitors
· Environmental/industry analysis (e.g. Porter’s five forces analysis)
· Your customers
· S.W.O.T. analysis that will identify certain strengths and opportunities of the proposed company and should address some key weaknesses and threats.
· Advertising & sales
· The Future (5 marks)
· Vision statement
· Mission statement
· Goals/objectives
· Action plan
· The Finances (20 marks)
· Key objectives, assumptions & financial review
· Start-up costs for [YEAR]
· Balance sheet forecast
· Profit and loss forecast
· Expected cash flow
· Break-even analysis
· Supporting documentation
PART B – PRESENTATION OF STRATEGIC BUSINESS PLAN – 30%
In this PART, you are required to prepare a presentation on the organisation’s strategic business plan and discuss the critical issues such as organisational details, business strategies, marketing strategies and analysis, operational plan, and financial plan. You can have a brainstorming session within your class to generate ideas.
· Your presentation will be a PowerPoint presentation of 15-20 slides. You may not use more than 20 slides.
· Include a list of reference or sources that you may have used to prepare the presentation.
· Marking weights for the presentation is within the marking criteria table.
· You are also required to attach the presentation slides at the very end of the report as APPENDIX section.
REPORT AND PRESENTATION MARKING CRITERIA (Trainer use only for marking purposes)
Learning Outcome |
Marks Allocated |
Marks received |
||||||
PART A – STRATEGIC BUSINESS PLAN REPORT |
||||||||
Executive Summary (5 marks) |
5 |
|||||||
Business Plan Summary (10 marks) |
10 |
|||||||
The Organisational structure & operational plan (15 marks) |
15 |
|||||||
The Market and market analysis (15 marks) |
||||||||
The Future (5 marks) |
||||||||
The Finances (20 marks) |
20 |
|||||||
PART B – PRESENTATION OF STRATEGIC BUSINESS PLAN |
||||||||
Presentation slides attached, presentation formatting, voice clarity, engaging and timely presentation |
||||||||
Discussion on organisational details |
||||||||
Discussion on business strategies |
||||||||
Discussion on marketing strategies and analysis |
||||||||
Discussion on operational plan |
||||||||
Discussion on financial plan |
||||||||
TOTAL |
100 |
|||||||
Additional Comments by Trainer & Assessor |
Strategic & Business Planning, Assessment No.1 Page 7
v1.1, Last updated on 10/08/2017
How to use this template
How to use this template
9
Set-up costs
Profit and loss forecast
Cash
flow forecast
Balance sheet forecast
Break-even analysis
Set-up costs
Setting up the business | ||||||
Accountant’s fees | $10,000 | |||||
Solicitor’s fees | $5,000 | |||||
Business registration | $3,000 | |||||
Domain name registration | $1,000 | |||||
Insurance | $1,200 | |||||
Licences | ||||||
Workers compensation | $4,000 | |||||
Setting up the premises | ||||||
Lease deposit and advance rent | $20,000 | |||||
Fitout | $1,500 | |||||
Utility bonds and connection | $800 | |||||
Stationery | $2,000 | |||||
Plant and equipment | ||||||
Equipment | $55,000 | |||||
Vehicles | $45,000 | |||||
Telecommunications | ||||||
Computers and software | $3,500 | |||||
Starting operations | ||||||
Advertising | ||||||
Raw materials and supplies | $16,000 | |||||
Working capital | ||||||
Start-up capital | ||||||
Equity investment | ||||||
Borrowings | ||||||
Total | $0 | |||||
The result | ||||||
Total set-up costs | $200,000 | |||||
Surplus funds | ||||||
Borrowings required |
Profit and loss forecast
Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Totals | ||||||||||||||||||||||||||||||||||||||
Sales | ||||||||||||||||||||||||||||||||||||||||||||||||||
Sales (invoiced) | $400 | $600,000.00 | $700,000.00 | $800,000 | $1,000,000.00 | $1,100,000.00 | $1,200,000.00 | $1,300,000.00 | $1,400,000.00 | $1,500,000.00 | $13,000,000.00 | |||||||||||||||||||||||||||||||||||||||
Cost of goods sold | $120,000 | $200,000.00 | $240,000.00 | $300,000.00 | $430,000.00 | $460,000.00 | $520,000.00 | $720,000.00 | $5,430,000.00 | |||||||||||||||||||||||||||||||||||||||||
Gross profit | $280,000.00 | $500,000 | $670,000.00 | $740,000.00 | $780,000.00 | $7,570,000.00 | ||||||||||||||||||||||||||||||||||||||||||||
Expenses | ||||||||||||||||||||||||||||||||||||||||||||||||||
Accounting fees | $10,000.00 | |||||||||||||||||||||||||||||||||||||||||||||||||
$12,000.00 | $14,000.00 | $16,000.00 | $19,000.00 | $21,000.00 | $22,000.00 | $25,000.00 | $209,000.00 | |||||||||||||||||||||||||||||||||||||||||||
Bank charges | $1,000.00 | |||||||||||||||||||||||||||||||||||||||||||||||||
Bank interest | $1,500.00 | $18,000.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
Depreciation | $2,190.00 | $26,280.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
Electricity and gas | $1,200.00 | $1,600.00 | $1,800.00 | $2,000.00 | $2,400.00 | $2,600.00 | $3,000.00 | $30,000.00 | $51,500.00 | |||||||||||||||||||||||||||||||||||||||||
Equipment hire/lease | $800.00 | $10,800.00 | $119,600.00 | |||||||||||||||||||||||||||||||||||||||||||||||
$14,400.00 | ||||||||||||||||||||||||||||||||||||||||||||||||||
Legal fees | ||||||||||||||||||||||||||||||||||||||||||||||||||
Motor vehicle expenses | ||||||||||||||||||||||||||||||||||||||||||||||||||
Postage, telephone and fax | $500.00 | $17,000.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
$21,600.00 | ||||||||||||||||||||||||||||||||||||||||||||||||||
Rent | $3,500.00 | $42,000.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
Repairs and maintenance | ||||||||||||||||||||||||||||||||||||||||||||||||||
Security | $2,500.00 | |||||||||||||||||||||||||||||||||||||||||||||||||
Sundries | ||||||||||||||||||||||||||||||||||||||||||||||||||
Superannuation | ||||||||||||||||||||||||||||||||||||||||||||||||||
Transport/courier costs | $5,000.00 | $60,000.00 | ||||||||||||||||||||||||||||||||||||||||||||||||
Wages | $15,000.00 | $20,000.00 | $24,000.00 | $28,000.00 | $32,000.00 | $45,000.00 | $424,000.00 | |||||||||||||||||||||||||||||||||||||||||||
$4,000.00 | $26,000.00 | $40,000.00 | $266,000 | |||||||||||||||||||||||||||||||||||||||||||||||
$0.00 | ||||||||||||||||||||||||||||||||||||||||||||||||||
$60,690.00 | $81,690.00 | $197,690.00 | $98,990.00 | $108,090.00 | $118,290.00 | $129,490.00 | $135,890.00 | $141,090.00 | $169,490.00 | $196,490.00 | $1,607,380 | |||||||||||||||||||||||||||||||||||||||
Result | ||||||||||||||||||||||||||||||||||||||||||||||||||
Net profit | $219,310.00 | $318,310.00 | $262,310.00 | $401,010.00 | $491,910.00 | $551,710.00 | $610,510.00 | $644,110.00 | $658,910.00 | $583,510.00 | $5,962,620 | |||||||||||||||||||||||||||||||||||||||
Gross profit margin | 70% | 67% | 66% | 63% | 60% | 61% | 62% | 57% | 52% | 58% | ||||||||||||||||||||||||||||||||||||||||
Net profit margin | 55% | 53% | 37% | 50% | 49% | 51% | 47% | 41% | 39% | 46% |
Cash flow forecast
Starting cash position | $20,250.00 | $168,500.00 | $464,750.00 | $806,000.00 | $1,127,250.00 | $1,473,500.00 | $1,814,750.00 | $2,196,000.00 | $2,435,250.00 | $2,724,500.00 | $3,028,750.00 | |||||||||||
Incoming | ||||||||||||||||||||||
Cash sales | $350,000.00 | $550,000.00 | $650,000.00 | $750,000 | $6,500,000.00 | |||||||||||||||||
Collections from accounts receivable | $100,000 | $250,000.00 | $325,000.00 | $375,000.00 | $450,000.00 | $525,000.00 | $575,000.00 | $625,000.00 | $725,000.00 | $5,450,000.00 | ||||||||||||
Other cash receipts | ||||||||||||||||||||||
$875,000.00 | $1,125,000.00 | $1,225,000.00 | $1,325,000.00 | $1,475,000.00 | $11,950,000.00 | |||||||||||||||||
Outgoing | ||||||||||||||||||||||
Fixed costs | $121,750.00 | $1,461,000.00 | ||||||||||||||||||||
Administration | ||||||||||||||||||||||
Marketing | $75,750.00 | |||||||||||||||||||||
Operations | ||||||||||||||||||||||
Variable costs | $68,000.00 | $130,000.00 | $182,000.00 | $262,000.00 | $432,000.00 | $532,000.00 | $662,000.00 | $722,000.00 | $964,000.00 | $1,064,000.00 | $1,074,000.00 | $1,084,000.00 | $7,176,000.00 | |||||||||
$84,000.00 | $410,000.00 | |||||||||||||||||||||
$64,000.00 | $74,000.00 | $94,000.00 | $104,000.00 | $114,000.00 | $124,000.00 | $134,000.00 | $144,000.00 | |||||||||||||||
$38,000.00 | $48,000.00 | $58,000.00 | $78,000.00 | $108,000.00 | $148,000.00 | $158,000.00 | $168,000.00 | |||||||||||||||
$189,750.00 | $251,750.00 | $303,750.00 | $383,750.00 | $553,750.00 | $653,750.00 | $783,750.00 | $843,750.00 | $1,085,750.00 | $1,185,750.00 | $1,195,750.00 | $1,205,750.00 | $8,637,000.00 | ||||||||||
Change during month | $10,250.00 | $148,250.00 | $296,250.00 | $341,250.00 | $321,250.00 | $346,250.00 | $381,250.00 | $239,250.00 | $289,250.00 | $304,250.00 | $294,250.00 | |||||||||||
Closing cash position | $3,323,000 |
Balance sheet forecast
As at | December 2009 | |
Assets | ||
Current assets | $4,901,620 | |
Petty cash | ||
Accounts receivable | ||
Stock | $96,620 | |
Short-term investment | ||
Prepaid expenses | ||
Long-term investment | $620,000 | |
Fixed assets | $2,370,000 | |
Land | $850,000 | |
Buildings | ||
Improvements | ||
Furniture | ||
Motor/vehicles | ||
Total assets | $7,271,620 | |
Liabilities | ||
Current liabilities | $1,309,000 | |
Accounts payable | ||
Interest payable | ||
Taxes payable | ||
Income tax | $178,000 | |
Sales tax | $390,000 | |
Payroll accrual | ||
Long-term liabilities | ||
Total liabilities | ||
Net assets | ||
Owner’s equity | ||
Retained earnings | ||
Current year earnings | ||
Total equity (should equal net assets) |
Break-even analysis
Average selling price per unit | |
Average cost of each unit | $150 |
Dollar sales to break even | $2,571,808 |
Number of unit sales to break even | 6,430 |
Advantages of proposition?
Capabilities?
Competitive advantages?
USP’s (unique selling points)?
Resources, Assets, People?
Experience, knowledge, data?
Financial reserves, likely returns?
Marketing – reach, distribution,
awareness?
Innovative aspects?
Location and geographical?
Price, value, quality?
Accreditations, qualifications,
certifications?
Processes, systems, IT,
communications?
Cultural, attitudinal, behavioural?
Management cover, succession?
Philosophy and values?
criteria examples
Disadvantages of proposition?
Gaps in capabilities?
Lack of competitive strength?
Reputation, presence and reach?
Financials?
Own known vulnerabilities?
Timescales, deadlines and
pressures?
Cashflow, start-up cash-drain?
Continuity, supply chain
robustness?
Effects on core activities,
distraction?
Reliability of data, plan
predictability?
Morale, commitment, leadership?
Accreditations, etc?
Processes and systems, etc?
Management cover, succession?
criteria examples
Market developments?
Competitors’ vulnerabilities?
Industry or lifestyle trends?
Technology development and
innovation?
Global influences?
New markets, vertical, horizontal?
Niche target markets?
Geographical, export, import?
New USP’s?
Tactics: eg, surprise, major contracts?
Business and product development?
Information and research?
Partnerships, agencies, distribution?
Volumes, production, economies?
Seasonal, weather, fashion
influences?
criteria examples
Political effects?
Legislative effects?
Environmental effects?
IT developments?
Competitor intentions – various?
Market demand?
New technologies, services, ideas?
Vital contracts and partners?
Sustaining internal capabilities?
Obstacles faced?
Insurmountable weaknesses?
Loss of key staff?
Sustainable financial backing?
Economy – home, abroad?
Seasonality, weather effects?
SWOT Analysis Template State what you are assessing here. Please note that these criteria examples relate to assessing a new business venture or proposition. Many listed
criteria can apply to other quadrants, and the examples are not exhaustive. You should identify and use any other criteria that are appropriate to your situation.
SWOT analysis template – a free resource from www.businessballs.com. Not to be sold or published. Template © Alan Chapman 2005.
- criteria examples
strengths
weaknesses
criteria examples
criteria examples
opportunities
threats
criteria examples
[Business Name]
Business Plan
[YEAR]
business.gov.au
Business Plan template
A good business plan can help you secure finance, define the direction of your business and create strategies to achieve your goals. The business.gov.au Business Plan template steps you through the process of creating a solid, well-structured plan tailored to your business.
New! Create your business plan on your tablet by downloading our free MyBizPlan tablet app. Visit
www.business.gov.au/apps
now!
Copies of the latest version of this template and the guide can be downloaded from
www.business.gov.au/businessplan
.
If you need further information, assistance or referral about a business issue, please contact business.gov.au on 13 28 46.
Using this template
Before you complete this business plan template and start using it, consider the following:
Do your research. You will need to make quite a few decisions about your business including structure, marketing strategies and finances before you can complete the template. By having the right information to hand you also can be more accurate in your forecasts and analysis.
Determine who the plan is for. Does it have more than one purpose? Will it be used internally or will third parties be involved? Deciding the purpose of the plan can help you target your answers. If third parties are involved, what are they interested in? Although don’t assume they are just interested in the finance part of your business. They will be looking for the whole package.
Do not attempt to fill in the template from start to finish. First decide which sections are relevant for your business and set aside the sections that don’t apply. You can always go back to the other sections later.
Use the [italicised text]. The italicised text is there to help guide you by providing some more detailed questions you may like to answer when preparing your response.
Please note:
If a question does not apply to your circumstances it can be ignored.
Download the Business Plan Guide. The business plan guide contains general advice on business planning, a complete overview of the business plan template and a glossary explaining the main terms used throughout this template.
Get some help. If you aren’t confident in completing the plan yourself, you can enlist the help of a professional (i.e. Single Business Service, Business Enterprise Centre, business adviser, or accountant) to look through your plan and provide you with advice.
Actual vs. expected figures. Existing businesses can include actual figures in the plan, but if your business is just starting out and you are using expected figures for turnover and finances you will need to clearly show that these are expected figures or estimates.
Write your summary last. Use as few words as possible. You want to get to the point but not overlook important facts. This is also your opportunity to sell yourself. But don’t overdo it. You want prospective banks, investors, partners or wholesalers to be able to quickly read your plan, find it realistic and be motivated by what they read.
Review. Review. Review. Your business plan is there to make a good impression. Errors will only detract from your professional image. So ask a number of impartial people to proofread your final plan.
For advice and examples on how to complete this template, please download the business.gov.au Business Plan guide from
www.business.gov.au/businessplan.
Scan to watch our business planning video:
[INSERT YOUR BUSINESS LOGO]
[Your Name]
[Your Title]
[Business Name]
[Main Business Address]
ABN: [ABN]
ACN: [ACN]
[Business Name]
Business Plan
Prepared: [Date prepared]
Contents
Business Plan template 1
Using this template 2
Business Plan Summary 4
The Business 4
The Market 4
The Future 4
The Finances 5
The Business 5
Business details 5
Registration details 5
Business premises 5
Organisation chart 5
Management & ownership 6
Key personnel 6
Products/services 8
Innovation 8
Insurance 8
Risk management 9
Legal considerations 9
Operations 9
Sustainability plan 11
The Market 12
Market research 12
Market targets 12
Environmental/industry analysis 12
Your customers 12
S.W.O.T. analysis 13
Your competitors 14
Advertising & sales 15
The Future 17
Vision statement 17
Mission statement 17
Goals/objectives 17
Action plan 17
The Finances 18
Key objectives & financial review 18
Assumptions 18
Start-up costs for [YEAR] 19
Balance sheet forecast 20
Profit and loss forecast 21
Expected cash flow 22
Break-even analysis 23
Supporting documentation 24
Business Plan Summary
[Please complete this page last]
[Your business summary should be no longer than a page and should focus on why your business is going to be successful. Your answers below should briefly summarise your more detailed answers provided throughout the body of this plan.]
The Business
Business name: [Enter your business name as registered in your state/territory. If you have not registered your business name, add your proposed business name.]
Business structure: [Sole trader, partnership, trust, company.]
ABN: [Registered Australian business number.]
ACN: [Registered Australian company number, if applicable.]
Business location: [Main business location]
Date established: [The date you started trading.]
Business owner(s): [List all of the business owners.]
Relevant owner experience: [Briefly outline your experience and/or years in the industry and any major achievements/awards.]
Products/services
: [What products/services are you selling? What is the anticipated demand for your products/services?]
The Market
Target market:
[Who are you selling to? Why would they buy your products/services over others?]
Marketing strategy:
[How do you plan to enter the market? How do you intend to attract customers? How and why will this work?]
The Future
Vision statement
:
[The vision statement briefly outlines your future plan for the business. It should state clearly what your overall goals for the business are.]
Goals/objectives
:
[What are your short & long term goals? What activities will you undertake to meet them?]
The Finances
[Briefly outline how much profit you intend on making in a particular timeframe. How much money will you need up-front? Where will you obtain these funds? What portion will you be seeking from other sources? How much of your own money are you contributing towards the business?]
The Business
Business details
Products/services: [What products/services are you selling? What is the anticipated demand for your products/services?]
Registration details
Business name: [Enter your business name as registered in your state/territory. If you have not registered your business name, add your proposed business name.]
Trading name(s): [Registered trading name(s).]
Date registered: [Date business name registered.]
Location(s) registered: [State(s) you are registered in.]
Business structure: [Sole trader, partnership, trust, company.]
ABN: [Registered Australian Business Number.]
ACN: [Registered Australian Company Number, if applicable.]
GST: [Are you registered for Goods and Services Tax? Date registered?]
Domain names: [Registered domain names.]
Licences & permits: [List all the licences or permits you have registered]
Business premises
Business location: [Describe the location and space occupied/required. What is the size of the space you occupy/require? Which city or town? Where in relation to landmarks/main areas? If you have a retail business, where are you in relation to other shops? What is the retail traffic like?]
Buy/lease: [If you have purchased a business premises or are currently leasing, briefly outline the arrangements. If you are still looking for a lease, outline your commercial lease requirements and any utilities/facilities required.]
Organisation chart
[Outline your business structure in an organisation chart.]
Figure 1: Example Organisation Chart.
Management & ownership
Names of owners: [List all of the business owners.]
Details of management & ownership: [As the owner(s), will you be running the business or will a Chief Executive Officer (CEO) be running the business on your behalf? What will be your involvement? If it is a partnership briefly outline % share, role in the business, the strengths of each partner and whether you have a partnership agreement/contract in place?]
Experience: [What experience do the business owner(s) have? How many years have you owned or run a business? List any previous businesses owned/managed. List any major achievements/awards. What other relevant experience do you have? Don’t forget to attach your resume(s) to the back of your plan.]
Key personnel
Current staff
[List your current staff in the table below.]
Job Title
Name
Expected staff turnover
Skills or strengths
[e.g. Marketing/ Sales Manager]
[Mr Chris Brantley]
[12-18 months]
[Relevant qualifications in Sales/Marketing. At least 5 years experience in the industry. Award in marketing excellence.]
[e.g. Marketing/ Sales Manager]
[Mr Chris Brantley]
[12-18 months]
[Relevant qualifications in Sales/Marketing. At least 5 years experience in the industry. Award in marketing excellence.]
[e.g. Marketing/ Sales Manager]
[Mr Chris Brantley]
[12-18 months]
[Relevant qualifications in Sales/Marketing. At least 5 years experience in the industry. Award in marketing excellence.]
[e.g. Marketing/ Sales Manager]
[Mr Chris Brantley]
[12-18 months]
[Relevant qualifications in Sales/Marketing. At least 5 years experience in the industry. Award in marketing excellence.]
Required staff
[List your required staff in the table below.]
Job Title
Quantity
Expected staff turnover
Skills necessary
Date required
[e.g. Office Manager]
[1]
[2-3 years]
[Relevant qualifications in Office Management. At least 2 years experience.]
[Month/Year]
[e.g. Office Manager]
[1]
[2-3 years]
[Relevant qualifications in Office Management. At least 2 years experience.]
[Month/Year]
[e.g. Office Manager]
[1]
[2-3 years]
[Relevant qualifications in Office Management. At least 2 years experience.]
[Month/Year]
[e.g. Office Manager]
[1]
[2-3 years]
[Relevant qualifications in Office Management. At least 2 years experience.]
[Month/Year]
Recruitment options
[How do you intend on obtaining your required staff? Advertising in the local paper, online advertising, and/or training current staff members?]
Training programs
[Are there any training programs you will be organising in the event you cannot find the required skills? Are these in-house or external providers? What training will you as the business owner/manager undertake to keep your skills current?]
Skill retention strategies
[What procedural documentation will you provide to ensure the skills of staff are maintained? Do you have an appropriate allocation of responsibilities? How are responsibilities documented and communicated to staff? What internal processes will you implement to regularly check that the current skills of staff members are still appropriate for the business?]
Products/services
Product/Service
Description
Price
[Product/service name]
[Brief product/service description]
[Price including GST]
[Product/service name]
[Brief product/service description]
[Price including GST]
[Product/service name]
[Brief product/service description]
[Price including GST]
[Product/service name]
[Brief product/service description]
[Price including GST]
Market position: [Where do your products/services fit in the market? Are they high-end, competitive or budget? How does this compare to your competitors?]
Unique selling position: [How will your products/services succeed in the market where others may have failed? What gives your products/services the edge?]
Anticipated demand: [What is the anticipated quantity of products/services your customers are likely to purchase? For example, how much will an individual customer buy in 6 months or 12 months?]
Pricing strategy: [Do you have a particular pricing strategy? Why have you chosen this strategy?]
Value to customer: [How do your customers view your products/services? Are they a necessity, luxury or something in between?]
Growth potential: [What is the anticipated percentage growth of the product in the future? What will drive this growth?]
Innovation
Research & development (R&D)/innovation activities
[What R&D activities will you implement to encourage innovation in your business? What financial and/or staff resources will you allocate?]
Intellectual property strategy
[How do you plan to protect your innovations? List any current trade marks, patents, designs you have registered. Do you have confidentiality agreements in place?]
Insurance
Workers compensation: [Provide details if you have workers compensation insurance? This is mandatory if you have employees.]
Public liability insurance: [Provide details if you have public liability insurance? This covers any third party death or injury.]
Professional indemnity: [Provide details if you have professional indemnity insurance? This covers any legal action taken out as a result of your professional advice.]
Product liability: [Provide details if you have product liability insurance? This covers any legal action taken out as a result of injury, damage or death from your product.]
Business assets: [Provide details if you have insured your business assets in the event of a fire, burglary, or damage? For example: building, contents, motor vehicles.]
Business revenue: [Provide details if you have insured your business in the event of business interruption where you cannot trade because of a particular event and are unable to make money?]
Risk management
[List the potential risks (in order of likelihood) that could impact your business.]
Risk
Likelihood
Impact
Strategy
[Description of the risk and the potential impact to your business.]
[Highly Unlikely, Unlikely, Likely, Highly Likely]
[High, Medium, Low]
[What actions will you take to minimise/mitigate the potential risk to your business?]
[Description of the risk and the potential impact to your business.]
[Highly Unlikely, Unlikely, Likely, Highly Likely]
[High, Medium, Low]
[What actions will you take to minimise/mitigate the potential risk to your business?]
[Description of the risk and the potential impact to your business.]
[Highly Unlikely, Unlikely, Likely, Highly Likely]
[High, Medium, Low]
[What actions will you take to minimise/mitigate the potential risk to your business?]
[Description of the risk and the potential impact to your business.]
[Highly Unlikely, Unlikely, Likely, Highly Likely]
[High, Medium, Low]
[What actions will you take to minimise/mitigate the potential risk to your business?]
Legal considerations
[List the legislation which will have some impact on the running of your business. For example: consumer law, business law, or specific legislation to your industry.]
Operations
Production process
[What is the process involved in producing your products or services. This process will vary depending on your product or service. Here are some examples of questions you may consider. Is there a manufacturing process? Who is involved in the process? Are there any third parties involved? What is involved in delivering the service to your customers?]
Suppliers
[Who are your main suppliers? What do they supply to your business? How will you maintain a good relationship with them?]
Plant & equipment
[List your current plant and equipment purchases. These can include vehicles, computer equipment, phones and fax machines.]
Equipment
Purchase date
Purchase price
Running cost
[e.g Personal Computer]
[eg. 20/03/2010]
[e.g $2100]
[e.g $100 a month]
[e.g Personal Computer]
[eg. 20/03/2010]
[e.g $2100]
[e.g $100 a month]
[e.g Personal Computer]
[eg. 20/03/2010]
[e.g $2100]
[e.g $100 a month]
[e.g Personal Computer]
[eg. 20/03/2010]
[e.g $2100]
[e.g $100 a month]
Inventory
[List your current inventory items in the table below. If you have a substantial inventory, you may prefer to attach a full inventory list to the back of this business plan.]
Inventory item
Unit price
Quantity in stock
Total cost
[e.g flour]
[e.g $5.00kg]
[e.g Five kilograms]
[e.g $25.00]
[e.g flour]
[e.g $5.00kg]
[e.g Five kilograms]
[e.g $25.00]
[e.g flour]
[e.g $5.00kg]
[e.g Five kilograms]
[e.g $25.00]
[e.g flour]
[e.g $5.00kg]
[e.g Five kilograms]
[e.g $25.00]
Technology (Software): [What technology do you require? For example: website, point of sale software or accounting package? What will be the main purpose for each? Will they be off-the-shelf or purpose built? What is the estimated cost of each technology solution?]
Trading hours: [What are your trading hours? What are your expected peak trading times? Which times do you expect to be more profitable? How will this change over different seasons? How do your trading hours accommodate these changes?]
Communication channels: [How can your customers get in contact with you? These channels can include: telephone (landline/mobile), post box, shopfront, email, fax, internet blog or social media channel.]
Payment types accepted: [What payment types will you accept. cash, credit, cheque, gift cards, Paypal etc]
Credit policy: [What is your credit policy for customers/suppliers? How long is the credit period? What are your collection strategies/procedures? What credit does your business receive? What are the terms?]
Warranties & refunds: [If you manufacture certain goods, what are the warranty terms? What is your business refund/exchange policy?]
Quality control: [Describe your quality control process. What checks or balances do you have in place to ensure the product or service you offer is produced to the same standard of quality? What steps do you take to meet product safety standards?]
Memberships & affiliations: [Is your business a member of any particular industry association or club? Do you have any affiliations with any other organisation?]
Sustainability plan
Environmental/resource impacts
[Describe the impact your business could potentially have on the environment. E.g. a particular manufacturing process may contribute negatively on the local water supply.]
Community impact & engagement
[How does your environmental impact affect the local community? How can you engage the community in minimising your impact?]
Risks/constraints
[List any risks/constraints to your business resulting from this environmental impact?]
Strategies
[What strategies will you implement to minimise/mitigate your environmental impact and any risks to your business? Will you conduct an environmental audit? Have you introduced an Environmental management system?]
Action plan
[List your key sustainability/environmental milestones below?]
Sustainability milestone
Target
Target date
[Reduce water consumption]
[60% reduction]
[Month/Year]
[Reduce water consumption]
[60% reduction]
[Month/Year]
[Reduce water consumption]
[60% reduction]
[Month/Year]
[Reduce water consumption]
[60% reduction]
[Month/Year]
The Market
Market research
[What statistical research have you completed to help you analyse your market? Did you use a survey/questionnaire? If so, you may like to attach a copy of your survey/questionnaire to the back of this plan.]
Market targets
[Outline your planned sales targets. What quantity of your products/services do you plan to sell in a planned timeframe? Are they monthly or yearly targets?]
Environmental/industry analysis
[Detail the results of the market research you have performed. Is the area experiencing population growth? Are there long-term employers in the area? Is the region’s economy stable? Are there seasonal variations?
What is the size of the market? What recent trends have emerged in the market? What growth potential is available and where do you fit in? How will the market/customers change when you enter the market?]
Your customers
Customer demographics
[Define who your target customers are and how they behave. You can include age, gender, social status, education and attitudes.]
Key customers
[Identify your key customers. (These can be large consumers of your products or individuals whose satisfaction is key to the success of your business.) How will you target your products/service to them?]
Customer management
[How will you maintain a good relationship with your customers? What techniques will you use? How will you keep your customers coming back? Have you introduced customer service standards? Do you follow any particular code of practice?]
Page 21
S.W.O.T. analysis
[List each of your businesses strengths, weaknesses, opportunities or threats in the table below and then outline how you plan to address each of the weaknesses/threats.]
Strengths
Weaknesses
[e.g High traffic location]
[e.g High rental costs]
Opportunities
Threats
[e.g build on customer and brand loyalty]
[e.g Cash flow problems]
Your competitors
[How do you rate against your competitors? How can your business improve on what they offer?]
Competitor details
[List at least 5 competitors in the table below.]
Competitor
Established date
Size
Market share (%)
Value to customers
Strengths
Weaknesses
[Competitor name]
[When were they established?]
[Number of staff and/or turnover]
[Estimated percentage of market share]
[Unique value to customers. E.g. convenience, quality, price or service?]
[What are your competitor’s main strengths?]
[What are your competitor’s main weaknesses?]
[Competitor name]
[When were they established?]
[Number of staff and/or turnover]
[Estimated percentage of market share]
[Unique value to customers. E.g. convenience, quality, price or service?]
[What are your competitor’s main strengths?]
[What are your competitor’s main weaknesses?]
[Competitor name]
[When were they established?]
[Number of staff and/or turnover]
[Estimated percentage of market share]
[Unique value to customers. E.g. convenience, quality, price or service?]
[What are your competitor’s main strengths?]
[What are your competitor’s main weaknesses?]
[Competitor name]
[When were they established?]
[Number of staff and/or turnover]
[Estimated percentage of market share]
[Unique value to customers. E.g. convenience, quality, price or service?]
[What are your competitor’s main strengths?]
[What are your competitor’s main weaknesses?]
[Competitor name]
[When were they established?]
[Number of staff and/or turnover]
[Estimated percentage of market share]
[Unique value to customers. E.g. convenience, quality, price or service?]
[What are your competitor’s main strengths?]
[What are your competitor’s main weaknesses?]
Advertising & sales
Advertising & promotional strategy
[What strategies do you have for promoting and advertising your products/services in the next 12 months?]
Planned promotion /advertising type
Expected business improvement
Cost ($)
Target date
[Print media advertising, online advertising, mail-out, giveaway, media release, social media campaign or event.]
[How do you expect it will improve your business success?]
[$]
[Month/Year]
[Print media advertising, online advertising, mail-out, giveaway, media release, social media campaign or event.]
[How do you expect it will improve your business success?]
[$]
[Month/Year]
[Print media advertising, online advertising, mail-out, giveaway, media release, social media campaign or event.]
[How do you expect it will improve your business success?]
[$]
[Month/Year]
[Print media advertising, online advertising, mail-out, giveaway, media release, social media campaign or event.]
[How do you expect it will improve your business success?]
[$]
[Month/Year]
Sales & marketing objectives
[Who makes up your sales team? What sales techniques will they use? What tools/material will they use to help sell your products/services? What sales goals/targets will they meet?]
Unique selling position
[Why do you have an advantage over your competitors? How will your products/services succeed in the market where others may have failed?]
Sales & distribution channels
Channel type
Products/services
Percentage of sales (%)
Advantages
Disadvantages
[e.g. Shopfront, internet, direct mail, export or wholesale]
[List all the products/services sold via this channel]
[What percentage of overall sales do you expect to sell via this channel?]
[What advantages are there of using this channel for these products?]
[What challenges do you expect to face using this channel? How will you overcome them?]
[e.g. Shopfront, internet, direct mail, export or wholesale]
[List all the products/services sold via this channel]
[What percentage of overall sales do you expect to sell via this channel?]
[What advantages are there of using this channel for these products?]
[What challenges do you expect to face using this channel? How will you overcome them?]
[e.g. Shopfront, internet, direct mail, export or wholesale]
[List all the products/services sold via this channel]
[What percentage of overall sales do you expect to sell via this channel?]
[What advantages are there of using this channel for these products?]
[What challenges do you expect to face using this channel? How will you overcome them?]
[e.g. Shopfront, internet, direct mail, export or wholesale]
[List all the products/services sold via this channel]
[What percentage of overall sales do you expect to sell via this channel?]
[What advantages are there of using this channel for these products?]
[What challenges do you expect to face using this channel? How will you overcome them?]
The Future
Vision statement
[What is your business’ vision statement? It should briefly outline your future plan for the business and include your overall goals.]
Mission statement
[What is your business’ mission statement? I.e. how will you achieve your vision?]
Goals/objectives
[What are your short & long term goals? What activities will you undertake to meet them?]
Action plan
Please note: This table does not include sustainability milestones as they are listed in the sustainability section above.
Milestone
Date of expected completion
Person responsible
[What are the business milestones that you need to complete starting from today?]
[When do you expect to complete them?]
[Who is responsible for delivering this milestone?]
[What are the business milestones that you need to complete starting from today?]
[When do you expect to complete them?]
[Who is responsible for delivering this milestone?]
[What are the business milestones that you need to complete starting from today?]
[When do you expect to complete them?]
[Who is responsible for delivering this milestone?]
[What are the business milestones that you need to complete starting from today?]
[When do you expect to complete them?]
[Who is responsible for delivering this milestone?]
The Finances
Key objectives & financial review
Financial objectives
[List your key financial objectives. These can be in the form of sales or profit targets. You could also list your main financial management goals such as cost reduction targets.]
Finance required
[How much money up-front do you need? Where will you obtain the funds? What portion will you be seeking from loans, investors, business partners, friends or relatives, venture capital or government funding? How much of your own money are you contributing towards the business?]
Assumptions
The financial tables on the subsequent pages are based on the assumptions listed below:
[List your financial assumptions. These can include seasonal adjustments, drought or interest rates etc.]
Start-up costs for [YEAR]
[Double-click the table below to enter your details or attach your own start up costing sheet at the back of this business plan.]
Balance sheet forecast
[Double-click the table below to enter your details or attach your own profit & loss sheet at the back of this business plan]
Profit and loss forecast
[Double-click the table below to enter your details or attach your own profit & loss sheet at the back of this business plan]
Expected cash flow
[Double-click the table below to enter your details or attach your own profit & loss sheet at the back of this business plan]
Break-even analysis
[Double-click the table below to enter your details or attach your own table. Refer to the Business Plan guide from
www.business.gov.au/businessplan
for the calculations.]
[Business Name] Business Plan [YEAR]
Page 25
Supporting documentation
Attached is my supporting documentation in relation to this business plan. The attached documents include:
[List all of your attachments here. These may include resumes, inventory list, survey/questionnaire and/or financial documents.].
Page 26
START-UP COSTSCost ($)EQUIPMENT/CAPITAL COSTSCost ($)
Registrations Business purchase price
Business nameFranchise fees
LicencesStart-up capital
PermitsPlant & equipment
Domain namesVehicles
Trade marks/designs/patentsComputer equipment
Vehicle registrationComputer software
More…Phones
Membership feesFax machine
Accountant feesMore…
Solicitor feesSecurity system
Rental lease cost (Rent advance/deposit)Office equipment
Utility connections & bonds (Electricity, gas, water)Furniture
Phone connectionShop fitout
Internet connectionMore…
Computer software
Training
Wages
Stock/raw materials
Insurance
Building & contents
Vehicle
Public liability
Professional indemnity
Product liability
Workers compensation
Business assets
Business revenue
Printing
Stationery & office supplies
Marketing & advertising
More…
Total start-up costs$0Total equipment/capital costs$0
Sheet1
START-UP COSTS Cost ($) EQUIPMENT/CAPITAL COSTS Cost ($)
Registrations Business purchase price
Business name Franchise fees
Licences Start-up capital
Permits Plant & equipment
Domain names Vehicles
Trade marks/designs/patents Computer equipment
Vehicle registration Computer software
More… Phones
Membership fees Fax machine
Accountant fees More…
Solicitor fees Security system
Rental lease cost (Rent advance/deposit) Office equipment
Utility connections & bonds (Electricity, gas, water) Furniture
Phone connection Shop fitout
Internet connection More…
Computer software
Training
Wages
Stock/raw materials
Insurance
Building & contents
Vehicle
Public liability
Professional indemnity
Product liability
Workers compensation
Business assets
Business revenue
Printing
Stationery & office supplies
Marketing & advertising
More…
Total start-up costs $0 Total equipment/capital costs $0
BALANCE SHEET FORECAST[Year 1][Year 2][Year 3]
Current assets
Cash
Petty cash
Inventory
Pre-paid expenses
Fixed assets
Leasehold
Property & land
Renovations/improvements
Furniture & fitout
Vehicles
Equipment/tools
Computer equipment
More…
Total assets$0$0$0
Current/short-term liabilities
Credit cards payable
Accounts payable
Interest payable
Accrued wages
Income tax
More…
Long-term liabilities
Loans
More…
Total liabilities$0$0$0
NET ASSETS$0$0$0
Sheet1
BALANCE SHEET FORECAST [Year 1] [Year 2] [Year 3]
Current assets
Cash
Petty cash
Inventory
Pre-paid expenses
Fixed assets
Leasehold
Property & land
Renovations/improvements
Furniture & fitout
Vehicles
Equipment/tools
Computer equipment
More…
Total assets $0 $0 $0
Current/short-term liabilities
Credit cards payable
Accounts payable
Interest payable
Accrued wages
Income tax
More…
Long-term liabilities
Loans
More…
Total liabilities $0 $0 $0
NET ASSETS $0 $0 $0
PROFIT & LOSS FORECAST[Year 1][Year 2][Year 3]
Sales
less cost of goods sold
More…
Gross profit/net sales$0$0$0
Expenses
Accountant fees
Advertising & marketing
Bank fees & charges
Bank interest
Credit card fees
Utilities (electricity, gas, water)
Telephone
Lease/loan payments
Rent & rates
Motor vehicle expenses
Repairs & maintenance
Stationery & printing
Insurance
Superannuation
Income tax
Wages (including PAYG)
More…
Total expenses$0$0$0
NET PROFIT$0$0$0
Sheet1
PROFIT & LOSS FORECAST [Year 1] [Year 2] [Year 3]
Sales
less cost of goods sold
More…
Gross profit/net sales $0 $0 $0
Expenses
Accountant fees
Advertising & marketing
Bank fees & charges
Bank interest
Credit card fees
Utilities (electricity, gas, water)
Telephone
Lease/loan payments
Rent & rates
Motor vehicle expenses
Repairs & maintenance
Stationery & printing
Insurance
Superannuation
Income tax
Wages (including PAYG)
More…
Total expenses $0 $0 $0
NET PROFIT $0 $0 $0
EXPECTED CASHFLOW
[YEAR]
JanFebMarAprMayJunJulAugSepOctNovDec
OPENING BALANCE$0$0$0$0$0$0$0$0$0$0$0$0
Cash incoming
Sales
Asset sales
Debtor receipts
Other income
Total incoming$0$0$0$0$0$0$0$0$0$0$0$0
Cash outgoing
Purchases (Stock etc)
Accountant fees
Solicitor fees
Advertising & marketing
Bank fees & charges
Interest paid
Credit card fees
Utilities (electricity, gas,
water)
Telephone
Lease/loan payments
Rent & rates
Motor vehicle expenses
Repairs & maintenance
Stationery & printing
Membership & affiliation fees
Licensing
Insurance
Superannuation
Income tax
Wages (including PAYG)
More…
Total outgoing$0$0$0$0$0$0$0$0$0$0$0$0
Monthly cash balance$0$0$0$0$0$0$0$0$0$0$0$0
CLOSING BALANCE$0$0$0$0$0$0$0$0$0$0$0$0
Sheet1
EXPECTED CASHFLOW [YEAR] Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
OPENING BALANCE $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Cash incoming
Sales
Asset sales
Debtor receipts
Other income
Total incoming $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Cash outgoing
Purchases (Stock etc)
Accountant fees
Solicitor fees
Advertising & marketing
Bank fees & charges
Interest paid
Credit card fees
Utilities (electricity, gas, water)
Telephone
Lease/loan payments
Rent & rates
Motor vehicle expenses
Repairs & maintenance
Stationery & printing
Membership & affiliation fees
Licensing
Insurance
Superannuation
Income tax
Wages (including PAYG)
More…
Total outgoing $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Monthly cash balance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
CLOSING BALANCE $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Timeframe (e.g. monthly/yearly)
Average price of each product/service sold
Average cost of each product/service to make/deliver
Fixed costs for the month/year
Percentage of price that is profit#DIV/0!
Total sales needed to break-even#DIV/0!
Number of units sold needed to break-even#DIV/0!
BREAK-EVEN CALCULATOR
Sheet1
BREAK-EVEN CALCULATOR
Timeframe (e.g. monthly/yearly)
Average price of each product/service sold
Average cost of each product/service to make/deliver
Fixed costs for the month/year
Percentage of price that is profit $0.00
Total sales needed to break-even $0.00
Number of units sold needed to break-even $0.00
PEST Analysis Template
Situation being analysed: ______________________________________________________________________
PEST analysis (political, economical, social, technological) assesses a market, including competitors, from the
standpoint of a particular proposition or a business.
ecological/environmental
current legislation
future legislation
international legislation
regulatory bodies and
processes
government policies
government term and
change
trading policies
funding, grants and
initiatives
home market pressure-
groups
international pressure-
groups
wars and conflicts
political economical
criteria examples
home economy
economy trends
overseas economies
general taxation
taxation specific to
product/services
seasonality issues
market/trade cycles
specific industry factors
market routes trends
distribution trends
customer/end-user drivers
interest/ exchange rates
international trade and
monetary issues
criteria examples
lifestyle trends
demographics
consumer attitudes and
opinions
media views
law changes affecting
social factors
brand, company,
technology image
consumer buying patterns
fashion and role models
major events and
influences
buying access and trends
ethnic/religious factors
advertising and publicity
ethical issues
social technological criteria examples
competing technology
development
research funding
associated/dependent
technologies
replacement
technology/solutions
maturity of technology
manufacturing maturity
and capacity
information and
communications
consumer buying
mechanisms/technology
technology legislation
innovation potential
technology access,
licencing, patents
intellectual property issues
global communications
Note: PEST analysis can be useful before SWOT analysis because PEST helps to identify SWOT factors. PEST
and SWOT are two different perspectives but can contain common factors. SWOT stands for strengths,
weaknesses, opportunities, threats. SWOT analysis explanation and templates are at
www.businessballs.com/swotanalysisfreetemplate.htm
© Businessballs 2009. A free PDF version of this tool and information about PEST analysis methods are available at
www.businessballs.com/pestanalysisfreetemplate.htm A free resource from www.businessballs.com Not to be sold or published.
http://www.businessballs.com/
http://www.businessballs.com/swotanalysisfreetemplate.htm
http://www.businessballs.com/pestanalysisfreetemplate.htm
- criteria examples
criteria examples
criteria examples
>GanttChart
2 08 Vertex 2 LLC 0 Doe
Date:
/ /09
2 1/5/09 /09
/09
/09
/09
/09
2/24/09 Start John 1/05/09 1 1 0 1 1/05/09 1/05/09 1 0% 1 0 1 Sub Task level 2 1/05/09 1/05/09 1 0% 1 0 1 1/05/09 1/05/09 1 0% 1 0 1 Sub Task level 3 1/05/09 1/05/09 1 0% 1 0 1 Sub Task level 2 1/05/09 1/05/09 1 0% 1 0 1 Sub Task level 2 1/05/09 1/05/09 1 0% 1 0 1 1/05/09 1/11/09 7 5 1 6 Sub Task level 2 1/05/09 1/11/09 7 25% 5 1 6 Sub Task level 2 1/05/09 1/11/09 7 25% 5 1 6 1/05/09 25 17 17 Sub Task level 2 1/12/09 6 50% 5 3 3 Sub Task level 2 1/19/09 1/24/09 6 50% 5 3 3 Sub Task level 2 1/26/09 1/31/09 6 50% 5 3 3 Sub Task level 2 2/07/09 6 50% 5 3 3 Bill 1/05/09 1/05/09 1 0% 1 0 1 Sub Task level 2 1/05/09 1/05/09 1 0% 1 0 1 Sub Task level 2 1/05/09 1/05/09 1 0% 1 0 1 Sub Task level 2 1/05/09 1/05/09 1 0% 1 0 1 Sub Task level 2 1/05/09 1/05/09 1 0% 1 0 1 1.1 Sub Task level 2 1/05/09 1/05/09 1 0% 1 0 1 1/05/09 1/05/09 1 0% 1 0 1 Level 3 Task 1/05/09 1/05/09 1 0% 1 0 1 1/05/09 1/05/09 1 0% 1 0 1 1.3 Sub Task level 2 1/05/09 1/05/09 1 0% 1 0 1 &L&8 by Vertex42.com&R&8 HELP and Copyright: © http://www.vertex42.com/ExcelTemplates/excel-gantt-chart.html http://www.vertex42.com/ExcelTemplates/excel-gantt-chart.html http://www.vertex42.com/ExcelTemplates/excel-gantt-chart.html2
Gantt Chart
©
0
4
HELP
[Project Name]
[Company Name]
Today’s Date:
2/24/09
Tuesday
(vertical red line)
Project Lead:
John
[42]
Start
1
5
Monday
[42]
First Day of Week (Mon=2):
1/
6
1/
7
1/8/09
1/9/09
1/10/09
1/11/09
1/12/09
1/1
3
1/14/09
1/15/09
1/16/09
1/
17
1/18/09
1/19/09
1/20/09
1/21/09
1/22/09
1/23/09
1/24/09
1/
25
1/26/09
1/27/09
1/28/09
1/29/09
1/30/09
1/31/09
2/1/09
2/2/09
2/3/09
2/4/09
2/5/09
2/6/09
2/7/09
2/8/09
2/9/09
2/10/09
2/11/09
2/12/09
2/13/09
2/14/09
2/15/09
2/16/09
2/17/09
2/18/09
2/19/09
2/20/09
2/21/09
2/22/09
2/23/09
2/25/09
2/26/09
2/27/09
2/28/09
3/1/09
3/2/09
3/3/09
3/4/09
3/5/09
3/6/09
3/7/09
3/8/09
3/9/09
3/10/09
3/11/09
3/12/09
3/13/09
3/14/09
3/15/09
3/16/09
3/17/09
3/18/09
3/19/09
3/20/09
3/21/09
3/22/09
3/23/09
3/24/09
3/25/09
3/26/09
3/27/09
3/28/09
3/29/09
3/30/09
3/31/09
4/1/09
4/2/09
4/3/09
4/4/09
4/5/09
4/6/09
4/7/09
4/8/09
4/9/09
4/10/09
4/11/09
4/12/09
4/13/09
4/14/09
4/15/09
4/16/09
4/17/09
4/18/09
4/19/09
4/20/09
4/21/09
4/22/09
4/23/09
4/24/09
4/25/09
4/26/09
4/27/09
4/28/09
4/29/09
4/30/09
5/1/09
5/2/09
5/3/09
5/4/09
5/5/09
5/6/09
5/7/09
5/8/09
5/9/09
5/10/09
5/11/09
5/12/09
5/13/09
5/14/09
5/15/09
5/16/09
5/17/09
5/18/09
5/19/09
5/20/09
5/21/09
5/22/09
5/23/09
5/24/09
5/25/09
5/26/09
5/27/09
5/28/09
5/29/09
5/30/09
5/31/09
6/1/09
6/2/09
6/3/09
6/4/09
6/5/09
6/6/09
6/7/09
6/8/09
6/9/09
6/10/09
6/11/09
6/12/09
6/13/09
6/14/09
6/15/09
6/16/09
6/17/09
6/18/09
6/19/09
6/20/09
6/21/09
6/22/09
6/23/09
6/24/09
6/25/09
6/26/09
6/27/09
6/28/09
6/29/09
6/30/09
7/1/09
7/2/09
7/3/09
7/4/09
7/5/09
7/6/09
7/7/09
7/8/09
7/9/09
7/10/09
7/11/09
7/12/09
7/13/09
7/14/09
7/15/09
7/16/09
7/17/09
7/18/09
7/19/09
7/20/09
7/21/09
7/22/09
7/23/09
7/24/09
7/25/09
7/26/09
7/27/09
7/28/09
7/29/09
7/30/09
7/31/09
8/1/09
8/2/09
8/3/09
8/4/09
8/5/09
8/6/09
8/7/09
8/8/09
8/9/09
8/10/09
8/11/09
8/12/09
8/13/09
8/14/09
8/15/09
8/16/09
8/17/09
8/18/09
8/19/09
8/20/09
8/21/09
8/22/09
8/23/09
8/24/09
8/25/09
8/26/09
8/27/09
8/28/09
8/29/09
8/30/09
WBS
Tasks
Task
LeadEnd
Duration (Days)
% Complete
Working Days
Days Complete
Days Remaining
05 – Jan – 09
12 – Jan – 09
19 – Jan – 09
26 – Jan – 09
02 – Feb – 09
09 – Feb – 09
16 – Feb – 09
23 – Feb – 09
02 – Mar – 09
09 – Mar – 09
16 – Mar – 09
23 – Mar – 09
30 – Mar – 09
06 – Apr – 09
13 – Apr – 09
20 – Apr – 09
27 – Apr – 09
04 – May – 09
11 – May – 09
18 – May – 09
25 – May – 09
01 – Jun – 09
08 – Jun – 09
15 – Jun – 09
22 – Jun – 09
29 – Jun – 09
06 – Jul – 09
13 – Jul – 09
20 – Jul – 09
27 – Jul – 09
03 – Aug – 09
10 – Aug – 09
17 – Aug – 09
24 – Aug – 09
1
Task Category 1
1/05/09
0%
1.1
Sub Task level 2
1.2
1.
2.1
Sub Task level 3
1.
2.2
1.3
1.4
2
Task Category 2
Jane
25%
2.1 Sub Task level 2 1/05/09 1/11/09 7 25% 5 1 6
2.2 Sub Task level 2 1/05/09 1/11/09 7 25% 5 1 6
2.3
2.4
3
Task Category 3
Bill
2/07/09
34
50%
3.1
1/17/09
3.2
3.3
3.4
2/02/09
4
Task Category 4
4.1
4.2
4.3
4.4
TEMPLATE ROWS: Copy and insert the entire section, or just the specific sub tasks, depending on which level you want to use (formulas are different for different WBS levels)
1 Task Category 1 1/05/09 1/05/09 1 0% 1 0 1
1.2 Sub Task level 2 1/05/09 1/05/09 1 0% 1 0 1
1.2.1
Level 3 Task
1.2.2
1.2.2.1
Level 4 task
1.4 Sub Task level 2 1/05/09 1/05/09 1 0% 1 0 1Gantt Chart Template
© 2008 Vertex42 LLC
– Modify the GREEN cells and the Tasks, and Task Lead columns.
– The number of weeks shown in the gantt chart is limited by the maximum number of columns available in Excel.
– The Start Date that you choose determines the first week in the gantt chart.
– Change the first day of the week via cell K8
– Use the slider to adjust the range of dates shown in the gantt chart.
– Only 34 weeks (7 1/2 months) can be shown/printed at one time, because each week uses up 7 columns.
Q: The Working Days column shows “###”. How do I fix that?
You need to install the Analysis ToolPak add-in that comes with Excel. Go to Tools > Add-ins, and select Analysis ToolPak.
Q: How do I make Task 2 start the day after the end of Task 1?
Use the following formula for the start date of Task 2:
=EndDate+1
where EndDate is the reference to the cell containing the end date of task 1
Q: How do I add/insert tasks and subtasks?
Copy the entire ROW (or a group of rows) for the type of task(s) you want to add and then right-click on the row where you want to insert the new tasks, then select Insert Copied Cells. You can copy rows from within the gantt chart, or copy rows from the Template Rows.
Important Note: When inserting a new subtask after the last subtask or before the first subtask, you will need to update the formulas for calculating the Level 1 %Complete and Duration (see below) to include the new subtask, because the ranges won’t automatically expand to include the additional row.
Q: How do I calculate the %Complete for a Level 1 task based upon the %Complete of all of the associated subtasks?
Example: If Task 1 is on row 10 and the subtasks are on rows 11-14, use the following formula:
=SUMPRODUCT(F11:F14,G11:G14)/SUM(F11:F14)
Q: How do I calculate the Duration for a Level 1 task based upon the largest end date of a sub task?
Example: If the Level 1 task is on row 10 and the sub tasks are on rows 11-14, use the following formula
=MAX(D11:D14)-C10+1
Q: How can I include holidays in the calculation of the Working Days?
You can add a list of holidays to exclude in the NETWORKDAYS function. See Excel’s help (F1) for more information.
Q: How do I change the print settings?
Select the entire range of cells that you want to print and then go to File > Print Area > Set Print Area. Then go to File > Page Setup or File > Print Preview and adjust the Scaling and Page Orientation as desired.
Q: How do I use grouping?
You can expand or collapse a group of rows using Excel’s “Group and Outline” feature. To define a group of rows, select the rows and go to Data > Group and Outline and select Group …
Q: How do I change the background color of the bars in the Gantt Chart?
The colors used for the bars in the Gantt Chart are set using Conditional Formatting. The simplest approach for Excel 2002/2003 would be to change the colors via the color palette. Go to Tools > Options > Color tab. Or, you can select all of the cells in the Gantt Chart and go to Format > Conditional Formatting to change the colors.
Work Breakdown Structure
Level 1: 1, 2, 3, …
Level 2: 1.1, 1.2, 1.3, …
Level 3: 1.1.1, 1.1.2, 1.1.3, …
The WBS is automatically entered, but the formulas are different for different levels.
End Date
The ending date is calculated by adding the Duration (calendar days) to the Start date minus 1 day, because the task duration is from the beginning of the Start day to the end of the End day.
Start Date
Enter the starting date for this task. To associate the start date with the end of another task, enter a formula in the start date that refers to the end date of that task.
To purchase an unlocked version of this template, visit
http://www.vertex42.com/ExcelTemplates/excel-gantt-chart.html
Terms of Use
See the Terms Of Use worksheet and the license agreement on Vertex42.com for information about terms of use, copyright, warranties, and disclaimers. Removing copyright notices is illegal.
Duration (Calendar Days)
Enter the number of calendar days for the given task. Refer to the Working Days column or use a calendar to determine the corresponding working days. The duration is from the beginning of the Start date to the ending of the End Date.
When the duration is calculated, it is calculated as End Date minus the Start Date plus 1 day, so that a task starting and ending on the same day has a duration of 1 day.
Percent Complete
Update the status of this task by entering the percent complete (between 0% and 100%).
Working Days
Counts the number of working days using the NETWORKDAYS() formula, which excludes weekends. When planning work based upon the number of working days, adjust the Duration until the desired # of working days is reached.
Calendar Days Complete
This column is calculated by multiplying the Duration by the %Complete and rounding down to the nearest integer.
Calendar Days Remaining
This column is calculated by subtracting the Days Complete from the Duration.
HELP
Gantt Chart Template
© 2008-2009 Vertex42 LLC
http://www.vertex42.com/ExcelTemplates/excel-gantt-chart.html
TermsOfUse
Terms of Use
© 2006-2009 Vertex42 LLC. All rights reserved.
This TermsOfUse worksheet may not be modified, removed, or deleted.
Limited Use Policy
You may make archival copies and customize this template (the “Software”) for personal use or for your
company use. The customized template (with your specific personal or company information) may be
used and shared within your company, but this template or any document including or derived from
this template may NOT be sold, distributed, or placed on a public server such as the internet.
No Warranties
THE SOFTWARE AND ANY RELATED DOCUMENTATION ARE PROVIDED TO YOU “AS IS.”
VERTEX42, LLC MAKES NO WARRANTIES, EXPRESS OR IMPLIED, AND EXPRESSLY DISCLAIMS ALL
REPRESENTATIONS, ORAL OR WRITTEN, TERMS, CONDITIONS, AND WARRANTIES, INCLUDING BUT NOT
LIMITED TO, IMPLIED WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE, AND
NONINFRINGEMENT. WITHOUT LIMITING THE ABOVE YOU ACCEPT THAT THE SOFTWARE MAY NOT MEET
YOUR REQUIREMENTS, OPERATE ERROR FREE, OR IDENTIFY ANY OR ALL ERRORS OR PROBLEMS, OR DO
SO ACCURATELY. This Agreement does not affect any statutory rights you may have as a consumer.
Limitation of Liability
IN NO EVENT SHALL VERTEX42, LLC BE LIABLE TO YOU, FOR ANY DAMAGES, INCLUDING ANY LOST PROFITS,
LOST SAVINGS, OR ANY OTHER DIRECT, INDIRECT, SPECIAL, INCIDENTAL, OR CONSEQUENTIAL DAMAGES
ARISING FROM THE USE OR THE INABILITY TO USE THE SOFTWARE (EVEN IF WE OR AN AUTHORIZED DEALER
OR DISTRIBUTOR HAS BEEN ADVISED OF THE POSSIBILITY OF THESE DAMAGES), OR ANY MISTAKES AND
NEGLIGENCE IN DEVELOPING THIS SOFTWARE, OR FOR ANY CLAIM BY ANY OTHER PARTY. THE
ORGANIZATION, BUSINESS, OR PERSON USING THIS SOFTWARE BEARS ALL RISKS AND RESPONSIBILITY
FOR THE QUALITY AND PERFORMANCE OF THIS SOFTWARE.
Somes states do not allow the limitation or exclusion of liability for incidental or consequential damages,
so the above limitation may not apply to you.