How is management accounting information used to make decisions, and how do spreadsheets and IT support the preparation of accounting information?
Using management accounting information (contribution, break-even and cost data) to make decisions such as accepting a special order, and the role of spreadsheets and IT in preparing and presenting accounting information.
A focused answer to the SQA National 5 Accounting content on decision-making and the use of IT, covering how contribution, break-even and cost information support decisions such as a special order or a make-or-buy choice, and the role of spreadsheets and information technology in preparing, presenting and updating accounting information.
Reviewed by: AI editorial process; not yet individually human-reviewed
Have a quick question? Jump to the Q&A page
Jump to a section
What this dot point is asking
The SQA wants you to use management accounting information - contribution, break-even and cost data - to make decisions such as whether to accept a special order, and to explain the role of spreadsheets and IT in preparing and presenting accounting information.
Using information to make decisions
Management accounting exists to help managers choose between options. The key tool at National 5 is contribution (selling price minus variable cost per unit), because in many short-term decisions the fixed costs do not change, so the best option is usually the one that adds the most contribution.
The special order decision
A common decision is whether to accept a one-off special order at a price below the normal selling price. If the business has spare capacity and its fixed costs are already covered by normal sales, the order is worth accepting as long as the price is above the variable cost - because the whole contribution is extra profit.
Other decisions guided by cost information
The same thinking supports other choices: setting a price that at least covers variable cost and contributes to fixed costs; deciding the output needed to reach a target profit (from break-even analysis); judging risk from the margin of safety; and comparing the cost of making an item in-house with buying it in. In every case, managers use the prepared cost information to decide.
Spreadsheets and IT in accounting
Accounting information is now prepared with spreadsheets and other software rather than by hand. The SQA expects you to know why this matters.
Examples in context
A manufacturer with idle machine time is offered a discounted bulk order; by checking that the price still beats the variable cost, the manager sees the order adds contribution and accepts it. The whole calculation sits in a spreadsheet, so when the customer negotiates the price down, the manager instantly sees the new contribution and whether the deal still pays. Using contribution to decide, and IT to model it quickly, is exactly what this dot point tests.
Try this
Q1. A special-order unit sells for with a variable cost of . Find the contribution per unit. [1 mark]
- Cue. .
Q2. For an order of 200 such units, find the total extra contribution. [1 mark]
- Cue. .
Q3. State one advantage of preparing a cash budget on a spreadsheet. [1 mark]
- Cue. Formulae recalculate automatically, so "what if" changes update every total instantly (or: fewer arithmetic errors).
Exam-style practice questions
Practice questions written in the style of SQA exam questions on this dot point, with worked answer explainers. The year tag is the paper they imitate, not the source.
SQA N5 style4 marksA business with spare capacity is offered a special order of 500 units at 14 pounds each. The variable cost is 9 pounds per unit and fixed costs are already covered by normal sales. Calculate the extra contribution and advise whether to accept the order.Show worked answer →
Contribution per unit on the special order selling price variable cost (1 mark). Total extra contribution (1 mark). Because fixed costs are already covered by normal sales and the business has spare capacity, the extra contribution is extra profit, so the order should be accepted (1 mark for the recommendation, 1 mark linked to the positive contribution). Markers reward calculating the extra contribution and a recommendation justified by the contribution being positive while fixed costs are already met.
SQA N5 style3 marksDescribe two advantages of using a spreadsheet to prepare a cash budget.Show worked answer →
Award 1 mark for each clear advantage, to a maximum of 3, with a brief development. A spreadsheet performs the calculations automatically using formulae, so totals and balances are worked out quickly and with fewer arithmetic errors (1 mark). It allows "what if" analysis: changing one figure, such as a sales forecast, instantly updates every linked total and the closing balances (1 mark). It also presents the budget clearly and can produce charts, and the file can be saved, edited and reused next period rather than being redrawn by hand (1 mark). Markers reward advantages such as automatic recalculation, fewer errors, easy "what if" changes, professional presentation, and reuse.
Related dot points
- Classifying costs by behaviour (fixed, variable, semi-variable), by traceability (direct, indirect) and by element (materials, labour, overheads), and calculating total and unit cost.
A focused answer to the SQA National 5 Accounting content on classifying costs, covering cost behaviour (fixed, variable and semi-variable costs), traceability (direct and indirect costs), the three cost elements (materials, labour and overheads), and how to calculate total cost and cost per unit.
- Costing the three cost elements - materials, labour and overheads - including valuing materials issued, calculating labour cost from rates and hours, sharing overheads, and preparing a cost statement showing prime cost and total cost.
A focused answer to the SQA National 5 Accounting content on costing the three elements, covering valuing materials issued to production, calculating direct labour cost from hours and rates including overtime, sharing overheads across output, and building a cost statement that shows prime cost and total cost.
- Calculating contribution per unit, the break-even point in units and in sales revenue, the margin of safety, and the output required for a target profit, and interpreting a break-even chart.
A focused answer to the SQA National 5 Accounting content on break-even analysis, covering contribution per unit, the break-even point in units and in sales revenue, the margin of safety, the output needed for a target profit, and how to read a break-even chart.
- Preparing a cash budget showing forecast receipts and payments each month, the net cash flow, and the opening and closing bank balances, and interpreting it to manage cash flow.
A focused answer to the SQA National 5 Accounting content on cash budgets, covering how to forecast monthly receipts and payments, calculate the net cash flow, carry the closing bank balance forward to the next month, and interpret the budget to spot when the business may need finance.
- Calculating and interpreting profitability ratios (gross profit percentage, profit for the year percentage), liquidity ratios (current ratio, acid test) and the efficiency ratio rate of inventory turnover.
A focused answer to the SQA National 5 Accounting content on ratio analysis, covering the gross profit percentage and profit for the year percentage, the current ratio and acid test ratio for liquidity, the rate of inventory turnover for efficiency, and how to interpret each ratio to judge business performance.