Work for Mr Jones - 8 May 2006

Period 4 - Year 12 GCE ICT

Continue investigating the 'Twisted Pear' spreadsheet model. Fnd out how it works and experiment with putting data into the input sheets. Look at the other documents provided too - the word document with information about % takeup at the concerts and the mileage csv file.

Plan the formula that will be needed to calculate the best ticket price to maximaise the profits - then try it in the spreadsheet. Don't be afraid to put data into the model - you can always recover it form the shred area if it goes wrong.

Have a look at the Thomas Telford materials on this unit for guidance.

You must understand how this model works before the exam on 24 May.