Santa's Deliveries

Last year, Santa ran into problems getting all of the presents delivered on time around the World.

The Problem

The elves went on strike because Santa didn't pay them on time.

This was because Santa didn't keep track of the costs involved in creating and delivering the presents.

Nor did he keep track of the income he made, so he wasn't sure if he had enough money to give the elves a pay rise.

Your Task

Use the information below to design a spreadsheet model which could be used by Santa to work out how much it costs to deliver all of the Christmas presents.

Information you need

Try to think about how you can set out the spreadsheet. The three tables above should give you some idea of how to start.

Modelling Tasks

Once you have created your spreadsheet model try answering the following questions by changing your model:

1. Can Santa afford to increase the elves' wages to 10p a present?

2. Can Santa afford to increase the elves' wages to 20p a present?

3. If the number of presents to be delivered rises to 25,000,000 how much can Santa afford to pay the elves and not go into debt?

4. Try changing one other thing in your model and see what happens.