First Version of Cheese Spreadsheet

Cheese
Camembert
Emmental
Gruyere
Edam
Gouda


Overall Profit/Loss on Cheeses (€)
14000


12000


10000
Profit/Loss (€)




8000


6000


4000


2000


0
Camembert Emmental Gruyere Edam Gouda

Cheese Name



Average monthly sales
900
850
875
825
700

, Overall Profit/Loss (€) Overall Profit/Loss (£) Profit/Loss per Sale(£)
10080 14400 16
10880 15543 18
12250 17500 20
9570 13671 17
8680 12400 18


Profit/Loss per sale on Cheeses (€)
25



20



15
Profit/Loss (€)




10



5



0
dam Gouda Camembert Emmental Gruyere Edam Go

Cheese Name



Sale Price per Kilo (£) Cost per Kilo (£) Cost per Kilo (€)
56 40 28
64 46 32
70 50 35
58 41 29
62 44 31