Cover lesson · Design Technology · Year 9 · Advanced
LNF: Numeracy → Number system → Financial literacy
Name: Class: Date:
What this practises: numeracy in Design Technology. Pupils cost an invented batch of 60 laser-cut acrylic keyrings for an invented school Christmas fair. They convert prices with and without VAT, compare suppliers for best value, find the cost per keyring, set a selling price that hits a profit target, work out profit or loss for 3 sales forecasts, the break-even number and the percentage profit, test a 10% discount, and write a budget plan with a recommendation. Costing a product is part of GCSE Design and Technology. This is a calculation lesson: no practical work is done.
Print: this sheet and the stimulus sheet “Enterprise fair costs: Tîm Draig keyrings”, one of each per pupil. Pupils need a pen and a calculator.
Run: 4 min read the stimulus sheet · 8 min Step 1, VAT and unit prices · 6 min Step 2, best buy · 6 min Step 3, total cost · 5 min Step 4, selling price · 8 min Step 5, profit and break-even · 7 min Step 6, the discount · 8 min Step 7, budget plan · 3 min Step 8, check. Total 55 minutes. Remind pupils to show their working: marks come from the method as well as the answer.
Collect: this sheet. The worked example has every answer with full working.
A good product can still lose money if it is priced badly. You are the finance manager for Tîm Draig. You will find the cheapest way to buy the materials, work out what each keyring really costs, and set a price that raises money for charity without scaring customers away. Write money as £ with 2 decimal places, and show every calculation.
Use section 3 of the stimulus sheet. Multiply by 1.2 to add VAT; divide by 1.2 to remove it. One sheet makes 12 keyrings. Row A is done for you.
| Supplier | Price per sheet ex VAT | Price per sheet inc VAT | Acrylic cost per keyring inc VAT | Working |
|---|---|---|---|---|
| A | £2.60 | £3.12 | £0.26 (26p) | 2.60 × 1.2 = 3.12; 3.12 ÷ 12 = 0.26 |
| B | ||||
| C |
(a) Which supplier has the lowest cost per keyring?
(b) How much of the £15.00 for a pack from supplier B is VAT?
You need exactly 5 sheets, 60 split rings and 60 gift bags. Packs cannot be split.
| Option | Working | Cost inc VAT |
|---|---|---|
| 5 sheets from A | ||
| 5 sheets from B | ||
| 5 sheets from C (how many packs?) | ||
| 60 split rings in packs of 25 | ||
| 60 split rings in a pack of 100 | ||
| 60 gift bags in packs of 20 |
(a) Work out the cost of one split ring in each pack size. Which pack size is cheaper for buying exactly 60? Is that the same as the cheaper price per ring?
(b) Ifan says: “Supplier C has the cheapest sheets, so it must be the best buy.” Is he right for this batch? Use your numbers.
Use your best buys from Step 2 and the fixed costs in section 5 of the stimulus sheet.
| Cost | £ |
|---|---|
| Acrylic (best buy) | |
| Split rings (best buy) | |
| Gift bags | |
| Stall fee | |
| Price sign and display card | |
| Total cost of the batch of 60 | |
| Cost per keyring (total ÷ 60) |
(a) The target is £60 profit if all 60 keyrings sell. How much money must the team take in total? What is the lowest price per keyring that hits the target?
(b) The team agrees a price of £2.00. Give 2 reasons why rounding up from your answer to (a) is sensible. Use £2.00 for the rest of the sheet.
All 60 keyrings are made before the fair, so the total cost from Step 3 is spent whatever happens. Profit = money taken − total cost. A negative answer is a loss.
| Keyrings sold | Money taken | Total cost | Profit or loss |
|---|---|---|---|
| 60 | |||
| 35 | |||
| 20 |
(a) Break-even is the number sold where money taken equals total cost. How many keyrings must be sold to break even?
(b) Percentage profit = profit ÷ total cost × 100. Find the percentage profit if all 60 sell.
(a) What is the price of one keyring with 10% off? What is the profit on one keyring at full price, and at the discount price? (Profit per keyring = price − cost per keyring.)
(b) Ifan says: “10% off the price means 10% less profit on each keyring.” Work out the real percentage fall in profit per keyring. Is he right?
(c) Forecast 1, no discount: 45 keyrings sell at £2.00. Forecast 2, discount in the last hour: 40 sell at £2.00, then 18 more sell at the discount price. Find the profit for each forecast. Which is better, and by how much?
The team has a £50 loan to spend before the fair.
| Item | What we will buy, and from whom | Cost |
|---|---|---|
| Acrylic | ||
| Split rings | ||
| Gift bags | ||
| Fixed costs | stall fee, price sign and display card | |
| Total spend | ||
| Money left from the £50 loan | ||
(a) If the team had followed Ifan and bought from supplier C, would it stay within the £50 budget? Show the new total.
(b) Write a recommendation to the team (60 to 80 words). Include which suppliers to use, the price, whether to use Seren’s discount, and how many keyrings must sell before any money reaches the food bank. Use at least 3 numbers from your working.