• Use a spreadsheet to analyse profit / loss
  • Use formulas to calculate income and costs for your merchendising products.


  1. Write a spreadsheet which will calculate the profit and loss for each merchanidising item you have in your catalogue.


  • cost price - The price each item is sold for.
  • income - The total money you make. This is the cost price times number sold.
  • outgoings - The amount of money it costs you to make an item. Then you will need to mulitply this by the number sold.
  • profit or loss - The difference between income and outgoings. If it is positive you make a profit, if it is negative you make a loss