Computer assignment

I have a list of product list with the price – i want to use a excel sheet which can reflcet and compare the usage of ammenting and total consumtion  in price in a chart form . this sould be made in such a way that we enter data every day and end of the month it add up and compars with every day consumpiton with previous month.

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