A simple little Break-Even calculator

A simple little Break-Even calculator

Exactly as the title says. This simple Excel spreadsheet allows a student to plug in some fixed costs, variable costs and a selling price to see what the breakeven level of output would be. Use it as a demonstration to show what happens in real time if costs / revenues change, or as a tool to support students in analysing break even where performing the calcualations is not necessary. The first tab is an example (as seen in the image) with explanations/instructions that teachers/students can refer to. The second tab is a fill-in sheet to build your own! Oh, the example tab (as per the image) is locked to try to stop students accidentally breaking it - but there is no password!
jjd.turner
BUSS3 Finance in a Nutshell Revision Sheets

BUSS3 Finance in a Nutshell Revision Sheets

A series of printable summaries - if done on a double sided print out each on e is double sided. Summaries key meaning, and features exam tips for BUSS3! Download includes : Balance Sheet in a Nutshell Income Statement in a Nutshell Investment Appraisal in a Nutshell Liquidity Ratios in a Nutshell Shareholders Ratios in a Nutshell Efficiency Ratios in a Nutshell (Does not include Profitability as this is an AS concept)
jjd.turner
Exam Pack - Unit 12 AQA A2 Applied Business  (BS12)

Exam Pack - Unit 12 AQA A2 Applied Business (BS12)

An editable exam pack that features the following ; An overview of the exam (including dates, structure, timing and key tips) Breakdown of levels of response marks in BS12, and how to achieve them* A list of common trigger words to show exam skills required in responses* Outline revision strategies* A learning styles questionnaire and suggested strategies to suit based on VAK learning styles* Revision Activities All past paper case studies and questions dating back to January 2007 (14 papers) [*Please note: These features are common to other exam packs I have uploaded]
jjd.turner
Increasing Productivity and Efficiency 2 hour lesson including activities

Increasing Productivity and Efficiency 2 hour lesson including activities

A resource to designed to meet the needs of the 7132 Alevel Business AQA specification; Section 4.3: Increasing efficiency and productivity The resource contains a 13 slide PowerPoint driven by visuals, to which I have added my delivery notes along the bottom including links to media and when activities are undertaken. All resources can be edited as required. The content was delivered over two one hour lessons and includes; A literacy task composing a tweet to define efficiency or productivity A numeracy task involving calculating operations data to identify trends linked to efficiency and productivity Introduction of economies and diseconomies of scale A sequential consideration of how capacity, productivity and lean production can be used to improve efficiency and productivity Contextual tasks to put together a package to increase the productivity of a lazy six former Two linked video case studies – [c.20 minutes in total and requires YouTube access] to consider the changes in operational approach in factories 50 years apart with a student worksheet. Included in the resources here are a ppt (including printable resource slides); a five page key notes hand-out with space for notes and activities (I have never been a fan of getting students copying from the board).
jjd.turner
KS4 Demand, Supply and commodities lesson with 'Gold Exchange' activity

KS4 Demand, Supply and commodities lesson with 'Gold Exchange' activity

A resource designed to meet the needs of the GCSE Edexcel Business specification; Unit 1 Topic 5 - but could be used outside of this as a general introduction to supply and demand. The resource contains a PowerPoint driven by visuals, to which I have added my delivery notes along the bottom including how and when activities are undertaken. All resources can be edited as required. The content was delivered over a one hour lesson and includes; A spot the 'commodity' sorting task A guess the price of the commodity game Notes to define commodity, supply and demand -including external links to exemplify the impact on price A 'gold exchange' whole class activity A comparison of two businesses to assess the impact of changing commodity prices on business costs Included in the resources here are a ppt (including printable resource slides); a two page key notes hand-out with space for notes and activities (I have never been a fan of getting students copying from the board).
jjd.turner
Stakeholder 2 hour lesson including activities

Stakeholder 2 hour lesson including activities

A resource to designed to meet the needs of the 7132 Alevel Business AQA specification; Section 2.3: Stakeholders. The resource contains a 16 slide PowerPoint driven by visuals, to which I have added my delivery notes along the bottom including links to media and when activities are undertaken. All resources can be edited as required. The content was delivered over two one hour lessons and includes; A student focused started of who their ‘stakeholders’ might be A short crossword activity to identify common business stakeholders and their needs Introduction of stakeholder maps and application to the role-play Consideration of how organisations may differ the focus of communication with key stakeholders An extended whole class role play activity looking at conflicting and convergent stakeholder needs in the context of a planning permission meeting for a new McDonalds restaurant A homework research task A video case study – [54 minutes and requires YouTube access] to consider the role of ethics in stakeholder mapping, and pull the threads of stakeholder theory together. Included in the resources here are a ppt (including printable resource slides); a six page key notes hand-out with space for notes and activities (I have never been a fan of getting students copying from the board).
jjd.turner
GCSE Business Exam Skills Lessons

GCSE Business Exam Skills Lessons

Resources to help deliver the principles of 'Knowledge, Application, Analysis and Evaluation' at GCSE Business Studies. The resources are designed to be fun and engaging, and meet a range of learning styles. Student notes to accompany each presentation with space for activities to be recorded are included. Although this resource supports Edexcel 5BS03, I deliver it in year 10 to be able to get my classes writing effectively early. As such you may want to tweak the subject of questions to suit. Each resource can be edited fully to meet a groups needs, and I have included notes at the foot of each resource to explain how they are intended to be used, including how to run the range of activities each is reinforced with. I would recommend reading the notes at the bottom of each slide beforehand to know when sugar paper, scissors glue and cut-ups need to be pre-prepared! The two presentations (33 slides) cover approximately three hours of learning; I delivered the assessment objectives PowerPoint over two one hour lessons. The model answer provided is based on a case study in the 'Unit 1: Introduction to Business' book - ISBN 978-1-8469-0496-7.
jjd.turner
Leadership & Management 2 hour lesson including activities

Leadership & Management 2 hour lesson including activities

A resource to designed to meet the needs of the 7132 Alevel Business AQA specification; Section 2.1: Management and Leadership. The resource contains a 28 slide PowerPoint driven by visuals, to which I have added my delivery notes along the bottom including links to media and when activities are undertaken. The content was delivered over two one hour lessons and includes; A discussion of what a manager is/does How managers and leaders differ Bennis Leadership Traits activities Leadership profiling based on trait theory The main leadership styles (Autocratic to Laissez-faire) The Tannenbaum-Schmidt Continuum The Blake Mouton Grid Included in the resources here are a ppt (including printable resource slides); a five page key notes hand-out with space for notes (I have never been a fan of getting students copying from the board); and a Blake-Mouton questionnaire for students to identify where they are on the grid.
jjd.turner
Applied Business BS08 Assignment & Resources

Applied Business BS08 Assignment & Resources

A proven and refined task sheet (and supplementary appendix material) that has been used successfully over a number of years to deliver outstanding results in Unit 8 (including over 20% A* each year and regular 70 mark pieces). The assignment has been broken down into 14 parts to aid management of the unit, and includes 'exploded' and additional guidance in the form of ten detailed appendices. Also included is a range of PowerPoint's used to introduce and deliver the content, as well as a support spread sheet that has been developed to simplify the financial considerations. The spread sheet is available as a separate download if needed.
jjd.turner
Social Science A Level Subject Knowledge Audits

Social Science A Level Subject Knowledge Audits

A set of five teacher "Subject Knowledge Audits" for the A level (Sept 2015 onwards) 'Social Science' subjects; Business (AQA 7132) Computer Science (OCR H446) Economics (AQA 7136) Psychology (AQA 7182) Sociology (AQA 7192) These have been produced to allow a RAG+ rating of all aspects of the A level curriculum coverage of each specification in a self-calculating spread sheet optimised for printing if required. A rating is entered as a number 1,2,3,4, or 5 against each element. The 'Analysis' tab compiles all of the information onto one page to allow; an overview of CPD need; identification of delivery responsibility and inform subject priority. The RAG+ rating (which can be edited) defines as: 5 (Purple) I have expertise in this topic; I would be confident to provide CPD in this area; I know how to deliver this content to allow students to confidently access full marks in exams. 4 (Blue) I have very secure subject knowledge in this area; I know how this topic area will be assessed in exams 3 (Green) I understand the key features of this topic, but would need to spend some time brushing up on aspects before delivering it; I would welcome chance to discuss this topic in the department to clarify some points; I have not taught this topic before, and may not be able to answer some student questions. 2 (Amber) I have an outline understanding of the topic but would need support to feel confident enough to teach it; I would feel uncomfortable if students asked stretching questions in this area. 1 (Red) I am unfamiliar with this topic, and would not be able to deliver it without significant preparation which may include internal/external support. Teachers can add comments against each section when a RAG+ rating does not allow a representative picture. The two images in the files section will give you a preview of a completed audit for Business.
jjd.turner
Exam Pack - Unit 11 AQA A2 Applied Business  (BS11)

Exam Pack - Unit 11 AQA A2 Applied Business (BS11)

An editable exam pack that features the following ; An overview of the exam (including dates, structure, timing and key tips) Breakdown of levels of response marks in BS11, and how to achieve them* A list of common trigger words to show exam skills required in responses* Outline revision strategies* A learning styles questionnaire and suggested strategies to suit based on VAK learning styles* Revision Activities All past paper case studies and questions dating back to June 2007 (11 papers) [*Please note: These features are common to other exam packs I have uploaded]
jjd.turner
Exam Pack - Unit 4 AQA AS Applied Business (BS04)

Exam Pack - Unit 4 AQA AS Applied Business (BS04)

An editable exam pack that features the following ; An overview of the exam (including dates, structure, timing and key tips) Breakdown of levels of response marks in BS04, and how to achieve them* A list of common trigger words to show exam skills required in responses* Outline revision strategies* A learning styles questionnaire and suggested strategies to suit based on VAK learning styles* Revision Activities All past paper case studies and questions dating back to January 2007 (12 papers) [*Please note: These features are common to other exam packs I have uploaded]
jjd.turner
Investment Appraisal Answer Calculator

Investment Appraisal Answer Calculator

An Excel 2010 worksheet that allows you to fill in the intial investment and cash flows information for up to four five year investments. The worksheet then shows on separate tabs the Payback period; Average Rate of Return (ARR) and Net Present Value (NPV) of the investments. The NPV discount rate can be chosen (between 1% & 15%) with a discount factor to 3d.p. used to complete the calcuations. This can be used to allow the generation and easy checking unlimited practice scenarios.
jjd.turner
Ratio Analysis Answer Calculator

Ratio Analysis Answer Calculator

An Excel 2010 spreadsheet, that allows you to change the 'blue' cells to reflect any stimulus material. The spreadsheet will then calculate the following formulas to give the answers for the four sets of ratios (liquidity, efficiency, profitability and shareholder ratios); Current Ratio Acid Test Ratio ROCE % Asset Turnover Inventory Turnover Payables Days Receivables Days Gearing DPS Dividend Yield The 'Your Response' column turns green when the correct answer is entered (as per the d.p indicated). The correct answers can also be seen by pressing the 'Show Answers' button, and hidden again by pressing 'hide'.
jjd.turner
BS08 Self-calculating Financial Documents Template

BS08 Self-calculating Financial Documents Template

A set of nine linked worksheets which can be used to produce a full set of accounts, including all of the financial planning documents needed for the AQA A2 Applied Business BS08 portfolio. The document makes use of detailed formulas and drop-down menus to minimise data input to the following requirements. 1) Sales Forecast 2) Operations (Costs) Forecast 3) Start-up Costs (including appropriate sources of finance required) From the above data the following can be automatically produced... 4) Break Even Forecast (including graph) 5) Cash Flow Forecast for the start-up phase (3 month) and first year trading 6) Profit & Loss Account (Income Statement) for the first year 7) Balance Sheet for the first day of trading 8) Ratio Analysis (includes NPM, GPM, ROCE, and Gearing) 9) Payback Calculation Each page is protected to stop students deleting important formulas, but there is no password!
jjd.turner
BUSS3 Finance in a Nutshell Revision Sheets

BUSS3 Finance in a Nutshell Revision Sheets

A series of printable summaries - if done on a double sided print out each on e is double sided. Summaries key meaning, and features exam tips for BUSS3! Download includes : Balance Sheet in a Nutshell Income Statement in a Nutshell Investment Appraisal in a Nutshell Liquidity Ratios in a Nutshell Shareholders Ratios in a Nutshell Efficiency Ratios in a Nutshell (Does not include Profitability as this is an AS concept)
jjd.turner
GCSE Business Revision Game (Edexcel 5BS01)

GCSE Business Revision Game (Edexcel 5BS01)

A PowerPoint based quiz. Click on the number to select a random question (based on past papers) - once finished, click on the man and you come back to the number board to go again (the already chosen numbers fade out). Simple. You can use this as one at a time "pick a number challenge"; "teams challenge" etc... All slides can be edited to change the questions - you can add what ever you like; as long as the number board and man are not deleted you can put what ever you like on the slides. Perhaps make the colours relevant to more and less able students, or for different sub modules within the course. The options are boundless. Feel free to use and modify as you see fit.
jjd.turner
GCSE Business (Edexcel) Unit 1 Mindmaps

GCSE Business (Edexcel) Unit 1 Mindmaps

Exactly what it says in the title! In PPT format so that they can be tweaked or repurposed - the mindmap itself is an image however. If there are any errors let me know, they have been checked but you never know! Designed not to be fully comprehensive as I use them as a wall display - they could form the basis of a starting point for student notes.
jjd.turner
GCSE Business (Edexcel) Unit 3 Mindmaps

GCSE Business (Edexcel) Unit 3 Mindmaps

Exactly what it says in the title - this is for the 'Building a Business' unit. In PPT format so that they can be tweaked or repurposed - the mindmap itself is an image however. If there are any errors let me know, they have been checked but you never know! Designed not to be fully comprehensive as I use them as a wall display - they could form the basis of a starting point for student notes.
jjd.turner
BS03 Applied Business Pre-release: Focus on Financial Management

BS03 Applied Business Pre-release: Focus on Financial Management

A deconstruction of the financial position of SYS and the key features relevant to addressing the number crunching bits of the case study ahead of the May 2016 pre-release exam based on Store-Your-Stuff. Tips, facts and opinion on a single page summary to support revision and consolidate learning.
jjd.turner