Prepare a excel sheet

Prepare a excel sheet – I have list of all the ammenties with the price used in the hotel room we need to prepare excel sheet in such a way that it allow us to enter the total consumption of ammenties every day and it show automatically calculate the total price cosumed .it should basically  track waht ammenties and how many been used and after entering the data it should refet in a chart form.and end of the day and year i want to compare every ammenities used in referennce to the number and price and compare in daily + month basis.i have attached the price and product list

2

>Sheet

1

of the room

s

done for the month

Used

Total cost Services Qty

1

.15

1

0.28 Service

1 0.28 0.28

Towel

1

0.27

2

0

2

6

1

0.32

3 0.32

3

1

0.41

2

0.28

1

0.21

1 0.21 0.21

1 0.21 0.21

1 0.21 0.21

2

2

1

0.19

1

0.12

1

0.02

1

Reception2: Reception2:
Needs to be updated in reference to the spreadsheet sent by Natalie

17.89

1

31.25

1

5.83

1 0

1 0.4 0.4

1

0.53

Tea 4

4 0.14

4 0.19

4 0.12

4 0.12 0.48

4

Paper 4

Ammenities

Diswashing Liquid 0.15 0
Dishwashing Powder 0.28 0
Laundry Powder 0.28 0

0.27 0

Bath towels 0.57 0
Face towel

0

Hand Towel 0.32 0
Bath Matt 0.41 0
Soap Bar 0.14 0
Shampooo 0.21 0
Body Lotion 0.21 0
Body Conditioner 0.21 0
Body Wash 0.21 0

0.69 0

Tissue Box 0.86 0
Grooming Kit 0.19 0
Sanitory Bag 0.12 0
Bin liner 0.02 0
Housekeeping 0 0
Rent 31.25 0
Electricity 5.83 0
Note Pad 0
Pen 0.4 0
Milk 0.53 0
Tea 0.032 0
Coffee 0.14 0
Decaff 0.19 0
Sugar 0.12 0
Equal 0.12 0
Salt 0.06 0
Paper 0.09 0

0

																																																																													Total cost	Total		Service
	Ammenities		Qty	Cost/Unit
	Diswashing Liquid																																					0	0.15	Departure
	Dishwashing Powder							0.28
	Laundry Powder	Linen
		Tea			0.27
	Bath towels		0.57	1.1							4	Total Services
	Face towel	0.2		3				0.4
	Hand Towel				0.32
pillow cover	0.96
bedsheet	0.98	2.94
	Bath Matt			0.41
	Soap Bar				0.14
	Shampooo												0.21
	Body Lotion
	Body Conditioner
	Body Wash
Toilet		Paper		0.69	1.38
	Tissue Box		0.86	1.72
	Grooming Kit					0.19
	Sanitory Bag							0.12
	Bin liner			0.02
	Housekeeping		17.89
	Rent			31.25
	Electricity			5.83
	Note Pad
	Pen
	Milk			0.53
	0.032	0.128
	Coffee	0.56
	Decaff	0.76
	Sugar		0.48
	Equal
	Salt		0.06	0.24
	0.09	0.36
Total Cost In a room	70.668
Total Stock order this month
Qty in unit	Price/Unit	Total Consumpltion
Tea Towel
0.23
Toilet Paper
Total Cunsumtion of ammentins/linen
Total Avergae cost of a room this month	ERROR:#DIV/0!
Differece between the acutal cost and the consumption	ERROR:#DIV/0! Reception2: Reception2: the value should always be in positive
Reception2: Reception2: Needs to be updated in reference to the spreadsheet sent by Natalie

Sheet2

Sheet3