It is common for holiday companies to charge people more for self-catering accommodation if they do not have the number of adults in their group which the accommodation can hold. This is called an 'under-occupancy surcharge'.
Children in the group are often not treated as adults for occupancy targets. Companies use this policy to make up for lower restaurant and bar sales from children.
A newspaper published prices for holidays leaving on 3 August 2013. The prices were given for a group of four adults and for a family of two adults and two children, aged six and ten.
Complete the spreadsheet below.
ACCURACY: Round monetary values to the nearest penny and percentages to the nearest integer.