0% found this document useful (1 vote)
49 views11 pages

Sandwiches Cost ( ) Calories Bread

Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
Download as xlsx, pdf, or txt
You are on page 1/ 11

Sandwiches

Cost (£) Calories


Bread
White 0.20 150
Brown 0.15 130

Fillings
Cheese 0.50 200
Ham 0.75 120
Egg 0.35 75
Bacon 1.00 300
Tomato 0.10 20
Lettuce 0.10 10
Mayo 0.05 70
Mustard 0.02 10

Mon Cheese on white bread 0.70 350


Tue Cheese and tomato on white 0.80 370
Wed Egg and tomato with mustard on brown 0.62 235
Thu Ham and mustard on brown 0.92 260
Fri Bacon, lettuce and tomato with mayo on white 1.45 550

Total for week 4.49 1,765


Protein (g) Carbs (g) Fat (g)

2.4 15 1
2.5 19 0.5

12 0 15
10 1 6
5 0.5 4
10 0.5 15
1 4 0
0 0.25 0
0.25 2 8
0.25 0.25 0.15

14 15 16
15 19 16
9 24 5
13 20 7
14 22 24

65 100 67
Orders

Item price qty subtotal discount total


A4 Paper (ream) £5.00 4 £0.00
Elastic bands (box) £5.50 8 £0.00
Pencils (pack) £2.50 10 £0.00
Envelopes (pack) £6.75 6 £0.00
Photgraphic paper (pack) £12.00 3 £0.00
Ground coffee £4.00 5 £0.00
Waste bin £9.99 3 £0.00
-
Sandwiches
Cost (£) Calories Protein (g)
Bread
White 0.20 150 2.4
Brown 0.15 130 2.5

Fillings
Cheese 0.50 200 12
Ham 0.75 120 10
Egg 0.35 75 5
Bacon 1.00 300 10
Tomato 0.10 20 1
Lettuce 0.10 10 0
Mayo 0.05 70 0.25
Mustard 0.02 10 0.25

Mon Cheese on white bread


Tue Cheese and tomato on white
Wed Egg and tomato with mustard on brown
Thu Ham and mustard on brown
Fri Bacon, lettuce and tomato with mayo on white

Total for week


Carbs (g) Fat (g)

15 1
19 0.5

0 15
1 6
0.5 4
0.5 15
4 0
0.25 0
2 8
0.25 0.15

-
-
-
-
-

-
Accounts

Credits Debits Cash Flow


January 129.8 61.05
February 55.2 122.9
March 148.25 145.15
April 63.1 18.15
May 16 45.5
June 59.92 62.15
July 61.35 34.6
August 11.74 25.54
September 73.4 69.99
October 42.5 44.3
November 53.3 75.99
December 167.8 14.93

Total

- - - -
Energy Costs
Days in month 31 28 31 30 31 30 31 31 30 31 30
Month Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov

Usage - Electric meter readings


Start 1000 1102 1320 1505 1620 1705 1795 1905 1975 2030 2105
end 1102 1320 1505 1620 1705 1795 1905 1975 2030 2105 2210
used /kWh 102 218 185 115 85 90 110 70 55 75 105

Cost of units used


Monthly charge
Cost for month

Usage - Gas meter readings


Start 250 360 455 545 630 705 745 780 802 855 915
end 360 455 545 630 705 745 780 802 855 915 1002
used /kWh 110 95 90 85 75 40 35 22 53 60 87

Cost of units used


Monthly charge
Cost for month

Total Energy Cost


Cost per day
31 Unit costs
Dec Electricy /kWh 0.150
Gas /kWh 0.025

2210 Standard charges per day /£


2325 Electricity 0.200
115 Gas 0.170

-
- Total Costs /£
- Electricity -
Gas -
Total -
1002
1115 Number of days -
113 Mean daily cost -

-
-
-

-
-
Date Start miles End miles Distance Claim cost /£
8/1/2015 100.000 120.50000 21 -
8/2/2015 132.700 189.30000 57 -
8/2/2015 205.100 294.70000 90 -
8/3/2015 277.500 400.10000 123 -
8/4/2015 349.900 505.50000 156 -
8/5/2015 510.000 610.90000 101 -
8/6/2015 626.700 716.30000 90 -
8/7/2015 718.100 821.70000 104 -
8/8/2015 830.600 885.30000 55 -
8/9/2015 892.800 943.90000 51 -
8/9/2015 962.100 994.80000 33 -
8/11/2015 1045.200 1108.40000 63 -
8/12/2015 1122.300 1174.20000 52 -
8/13/2015 1185.900 1216.70000 31 -
8/14/2015 1280.500 1396.30000 116 -
Cost per mile 35.154 (pence)

Total Miles -
Total Cost -

You might also like