dcf.cymru stimulus sheet · Food and Nutrition · Year 10
The café and its manager are invented. The nutrition figures are typical values for UK foods, rounded. Real products vary, so a real café would use the values on its own packets.
Caffi’r Bont is a community café in Rhondda Cynon Taf. The manager, Siân, wants to add Welsh rarebit to the lunch menu. She wants to show customers the nutrition of one portion, and she wants to offer a lighter version too. She has started a spreadsheet, but she thinks something is wrong with it.
Siân’s targets for the lighter version, per portion:
| Energy | Saturates | Salt | Fibre |
|---|---|---|---|
| 300 kcal or less | 9.0 g or less | 1.2 g or less | 2.5 g or more |
Method: melt the butter in a pan, stir in the flour and cook for 1 minute to make a roux. Gradually stir in the milk to make a thick sauce. Take it off the heat and stir in the cheese and mustard. Toast the bread, spread the cheese mixture on top and grill until bubbling and golden.
| Ingredient | Energy (kcal) | Saturates (g) | Salt (g) | Fibre (g) |
|---|---|---|---|---|
| Wholemeal bread | 217 | 0.5 | 1.0 | 7.0 |
| Mature Cheddar | 416 | 21.7 | 1.8 | 0.0 |
| Semi-skimmed milk | 46 | 1.1 | 0.1 | 0.0 |
| Salted butter | 744 | 52.1 | 1.6 | 0.0 |
| Plain flour | 341 | 0.2 | 0.0 | 3.1 |
| Swap options | ||||
| Reduced fat mature Cheddar | 314 | 13.8 | 1.8 | 0.0 |
| Unsalted butter | 744 | 52.1 | 0.0 | 0.0 |
| White bread | 219 | 0.4 | 1.0 | 2.9 |
The same data is in rarebit-nutrition-data.csv.
Row numbers are down the left and column letters along the top, as in any spreadsheet. She has only done the Energy column. Something in it is wrong.
| A | B | C | D | E | F | G | H | I | J | |
|---|---|---|---|---|---|---|---|---|---|---|
| 2 | Ingredient | Weight (g) | Energy per 100 g (kcal) | Energy in recipe (kcal) | Saturates per 100 g (g) | Saturates in recipe (g) | Salt per 100 g (g) | Salt in recipe (g) | Fibre per 100 g (g) | Fibre in recipe (g) |
| 3 | Wholemeal bread | 160 | 217 | 347.2 | 0.5 | 1.0 | 7.0 | |||
| 4 | Mature Cheddar | 200 | 416 | 832.0 | 21.7 | 1.8 | 0.0 | |||
| 5 | Semi-skimmed milk | 60 | 46 | 27.6 | 1.1 | 0.1 | 0.0 | |||
| 6 | Salted butter | 20 | 744 | 148.8 | 52.1 | 1.6 | 0.0 | |||
| 7 | Plain flour | 20 | 341 | 682.0 | 0.2 | 0.0 | 3.1 | |||
| 8 | Total | 460 | 1355.6 | |||||||
| 9 | Per portion | 338.9 | ||||||||
| 10 | Per 100 g | 294.7 | ||||||||
| 11 | % of reference intake per portion | 16.9 |
Formula view: the formulas Siân typed into columns B and D.
The mustard is left out of the model. It is 5 g out of 465 g and changes the totals very little.
Reference intakes for an average adult, per day: energy 2000 kcal, saturates 20 g, salt 6 g. There is no reference intake for fibre on labels: adults should aim for 30 g of fibre a day, and 11 to 16 year olds for 25 g.
Front-of-pack traffic light colours, UK guidance for foods, per 100 g. Energy is shown on labels but is not given a colour.
| Green (low) | Amber (medium) | Red (high) | |
|---|---|---|---|
| Saturates | 1.5 g or less | more than 1.5 g, up to 5.0 g | more than 5.0 g |
| Salt | 0.3 g or less | more than 0.3 g, up to 1.5 g | more than 1.5 g |
For a portion bigger than 100 g, the colour is also red if one portion gives more than 30% of the reference intake: more than 6.0 g of saturates or more than 1.8 g of salt.