Table 2.13 shows (i) the nutritional contents of five foods in grams per 100g (ii) their costs per 100g, and (iii) the minimum weekly requirements for an adult (in grams).

Table 2.13 Protein Fat Carbohydrate Cost (pence)

Wholemeal bread 8 1 56 8 Margarine – 84 – 16 Cheese 25 35 – 38 Breakfast cereal 10 2 77 24 Diet snack bar 10 – 49 40 Weekly adult requirements (g) 500 600 2100 Using Excel’s Solver, find the cheapest combination of foods that will meet the weekly adult minimum requirements.

(Answer: 6250g of wholemeal bread and 640g of margarine, costing a total of £6.02.)