We should lay this out on our spreadsheet so that we can make use of this information.

Finally we need to include total columns which tell use how much profit is made per item. The profit is the selling price minus the cost per item. We also need to total profit by item for the number sold. This would be the total amount of money made per item minus the total costs per item

Graphs

You should now draw a graph of your results. We can present the results in two ways

Menu Item against profit per item

and

Menu item against total profit of all sold

Assessment

You will be graded against these criteria

Have you used the correct formulae to calculate the values you need

Is the spreadsheet laid out neatly

Is all the data you have been given used

Have you used formatting to highlight the important cells, like profit, income.

Are the graphs in the correct format (column graph) and are the parts of the graph labelled (axes, units etc)

## Objectives

## Tasks

A Sandwich Bar

This word document will give the instructions of how to begin to lay out your spreadsheet.

You should now have worked out how much income the sandwich bar has. We now need to work out how much each of the items on the menu costs to make.

This word document will tell you how much everything costs.

A Sandwich Bar - costs

We should lay this out on our spreadsheet so that we can make use of this information.

Finally we need to include total columns which tell use how much profit is made per item. The profit is the selling price minus the cost per item. We also need to total profit by item for the number sold. This would be the total amount of money made per item minus the total costs per item

## Graphs

You should now draw a graph of your results. We can present the results in two ways

Menu Item against profit per item

and

Menu item against total profit of all sold

## Assessment

You will be graded against these criteria