Dynamic Modelling Tool 180 minutes

Activity 5: Finance and Business Decision Making

Business Studies Grade 11

Activity Purpose

To develop learners' financial reasoning and decision-making skills by managing a virtual café enterprise through an Excel spreadsheet model, manipulating variables and observing real-time consequences of business decisions.

Learner Engagement

Learners manage Bean There Café, a virtual enterprise modelled in Excel. They manipulate variables including selling price, meals sold, variable costs, employee costs, advertising spend, fixed costs, revenue, and profit to explore business decision-making.

Teacher Role

The teacher introduces the virtual enterprise, explains the spreadsheet model structure, guides experimentation, facilitates discussion of findings, and assesses the analytical report.

Digital Tools

Microsoft Excel (spreadsheet modelling and simulation)

Activity Brief

Scenario: Bean There Café , Learners take on the role of business managers, using an Excel model to run experiments and make strategic decisions.

The model includes these variables that learners can manipulate:

  • Selling Price per meal
  • Number of Meals Sold per month
  • Variable Cost per meal
  • Employee Costs (monthly)
  • Advertising Spend (monthly)
  • Fixed Costs (rent, utilities)

Learners run three structured experiments:

  1. Pricing Strategy Experiment: A 10% price increase leads to reduced demand. Learners observe the tension between higher margins and lower volume, discovering that price elasticity affects total revenue.
  2. Advertising Strategy Experiment: Increasing the advertising budget by R5,000 brings 150 additional meals per month. Learners calculate whether the increased revenue justifies the advertising spend.
  3. Sales Growth Experiment: Scaling from 1,000 to 1,250 meals per month. Learners discover how increased volume affects variable costs, capacity constraints, and overall profitability.

Example of Learner Work

An illustration of how the completed activity looks using the digital Mind Tool.

Example: the Bean There Café dynamic Excel model, where changing variables such as price and sales instantly recalculates revenue and profit.
Example: the Bean There Café dynamic Excel model, where changing variables such as price and sales instantly recalculates revenue and profit.

MindTool Characteristics

How this activity demonstrates the three defining features of cognitive tools.

Representation

The Excel model represents the business as a system of interconnected variables. Cells, formulas, and calculated outputs simulate how a real café operates, making abstract financial concepts concrete and manipulable.

Distributed Cognition

Cognitive work is shared between the learners (strategic thinking, hypothesis generation), the Excel model (calculations, scenario processing), and the teacher (scaffolding, guided inquiry). No single agent holds all the intelligence.

Interactivity

Learners manipulate variables and immediately see real-time results. This "what if" exploration , changing prices, adjusting budgets, scaling production , creates a dynamic feedback loop that deepens financial understanding.