know your numbers part one
play

Know Your Numbers: Part One Delivered on behalf of: Presented by - PowerPoint PPT Presentation

BUSINESS FUTURE PROOF SERIES Know Your Numbers: Part One Delivered on behalf of: Presented by BEN LEVER LETS BREAK IT DOWN Today we will discuss: GETTING TO 1. How data helps you to answer questions KNOW about all aspects of your


  1. BUSINESS FUTURE PROOF SERIES Know Your Numbers: Part One Delivered on behalf of: Presented by BEN LEVER

  2. LET’S BREAK IT DOWN Today we will discuss: GETTING TO 1. How data helps you to answer questions KNOW about all aspects of your business to make more money YOUR 2. Using data for looking backwards and NUMBERS looking forward 3. How spreadsheets can be used for modelling data and forecasting

  3. DATA HELPS YOU TO ANSWER QUESTIONS ABOUT MANY ASPECTS OF YOUR BUSINESS

  4. DATA IS RELEVANT THROUGH OUT ALL PARTS OF YOUR BUSINESS Image credit: Big Kiss Travel

  5. BUSINESS VIABILITY ● How much money did I make last year? ● Why did I lose money last year? FINANCIAL QUESTIONS ● Can I afford to hire new staff members? ● Should I raise my prices? Image credit: Big Kiss Travel

  6. BUSINESS FEASIBILITY ● Do I have too many staff? ● Do I have too few staff? OPERATIONAL ● What if we were more efficient? QUESTIONS ● How often are we using an asset? ● How much inventory do I waste? Image credit: Big Kiss Travel

  7. BUSINESS DESIRABILITY ● Who are my actual customers? ● Am I reaching my customers? CUSTOMER ● Do my services resonate with my QUESTIONS customers? ● What if I attracted different types of customers during the week? Image credit: Big Kiss Travel

  8. HOW CAN YOU USE DATA TO ANSWER THESE QUESTIONS?

  9. ANSWERING QUESTION ABOUT THE PAST LOOKING ● How much money did I make last year? BACKWARDS ● How much inventory do I waste? ● Who are my actual customers?

  10. Looking CAPTURE ANALYSE Backwards DATA

  11. TOOLS FOR CAPTURING AND ANALYSING DATA

  12. ANSWERING QUESTION ABOUT THE FUTURE LOOKING ● Can I afford to hire new staff members? FORWARD ● What if we were more efficient? ● What if I attracted different types of customers during the week?

  13. Looking CAPTURE ANALYSE Backwards DATA Looking MODEL FORECAST Forward DATA

  14. Looking CAPTURE ANALYSE Backwards DATA Looking MODEL FORECAST Forward DATA

  15. THE HUMBLE SPREADSHEET ● General purpose tool ● “Digital back-of-envelope” THE TOOL FOR ● Allows for varying degrees of complexity MODELLING ● Widely available and shareable AND ● Lots of resources FORECASTING Google Apple Microsoft Excel Sheets Numbers

  16. ● Income/expense forecast SPREADSHEET ● 3 business types: EXAMPLES ○ Food and Beverage Retailer ○ Accommodation Provider ○ Service Provider

  17. Explore the broader business Capture more data CLIMBING Model and forecast THE LADDER Analyse data Capture data

  18. But remember ... THE MAP IS NOT THE TERRITORY

  19. LET’S RECAP ● Data helps you to answer questions about many aspects of your business. ● We can use data to: look backwards and look forward . ● Spreadsheets are a powerful general purpose tool for modelling data and forecasting. ● Start simple before getting complicated.

  20. RESOURCES PRESENTATION VIDEO RECORDING HOW TO GUIDE: SLIDES KNOW YOUR & TOOLS NUMBERS F&B RETAILER ACCOMMODATION SERVICE PROVIDER SPREADSHEET PROVIDER SPREADSHEET SPREADSHEET

  21. Ben Lever P - 0408 533 801 E - ben@sparrowly.com W - sparrowly.com Check out our next webinar KNOW YOUR NUMBERS: PART TWO on Wednesday 23 September at 11:30am.

Recommend


More recommend