Cover lesson · Design Technology · Year 9 · Advanced

Pricing a product for a school enterprise fair

LNF: Numeracy → Number system → Financial literacy

Name: Class: Date:

Cover teacher: you need no subject knowledge

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.

What you are doing

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.

Step 1: VAT and unit prices

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.

SupplierPrice per sheet ex VATPrice per sheet inc VATAcrylic cost per keyring inc VATWorking
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?

Step 2: the best buy for this batch

You need exactly 5 sheets, 60 split rings and 60 gift bags. Packs cannot be split.

OptionWorkingCost 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.

Step 3: the total cost of the batch

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)

Step 4: set the selling price

(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.

Step 5: profit, loss and break-even

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 soldMoney takenTotal costProfit 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.

Step 6: test the 10% discount

(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?

Step 7: budget plan and recommendation

The team has a £50 loan to spend before the fair.

ItemWhat we will buy, and from whomCost
Acrylic
Split rings
Gift bags
Fixed costsstall 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.

Step 8: check your work

Step by step

  1. 4 min Read the stimulus sheet.
  2. 8 min Step 1: VAT and unit prices.
  3. 6 min Step 2: find the best buy for this batch.
  4. 6 min Step 3: total cost and cost per keyring.
  5. 5 min Step 4: set the selling price.
  6. 8 min Step 5: profit, loss and break-even.
  7. 7 min Step 6: test the discount.
  8. 8 min Step 7: budget plan and recommendation.
  9. 3 min Step 8: check your work.

Success criteria

If you finish early