Prepare a excel sheet
yunishcalculation.xlsx
Sheet1
Total cost of the room | Total Services done for the month | ||||||||||
Ammenities | Qty Used | Cost/Unit | Total cost | Services | Qty | ||||||
Diswashing Liquid | 1 | 0.15 | 0.15 | Departure | |||||||
Dishwashing Powder | 1 | 0.28 | 0.28 | Service | |||||||
Laundry Powder | 1 | 0.28 | 0.28 | Linen | |||||||
Tea Towel | 1 | 0.27 | 0.27 | ||||||||
Bath towels | 2 | 0.57 | 1.14 | Total Services | 0 | ||||||
Face towel | 2 | 0.23 | 0.46 | ||||||||
Hand Towel | 1 | 0.32 | 0.32 | ||||||||
pillow cover | 3 | 0.32 | 0.96 | ||||||||
bedsheet | 3 | 0.98 | 2.94 | ||||||||
Bath Matt | 1 | 0.41 | 0.41 | ||||||||
Soap Bar | 2 | 0.14 | 0.28 | ||||||||
Shampooo | 1 | 0.21 | 0.21 | ||||||||
Body Lotion | 1 | 0.21 | 0.21 | ||||||||
Body Conditioner | 1 | 0.21 | 0.21 | ||||||||
Body Wash | 1 | 0.21 | 0.21 | ||||||||
Toilet Paper | 2 | 0.69 | 1.38 | ||||||||
Tissue Box | 2 | 0.86 | 1.72 | ||||||||
Grooming Kit | 1 | 0.19 | 0.19 | ||||||||
Sanitory Bag | 1 | 0.12 | 0.12 | ||||||||
Bin liner | 1 | 0.02 | 0.02 | ||||||||
Housekeeping | 1 | 17.89 Reception2: Reception2: Needs to be updated in reference to the spreadsheet sent by Natalie | 17.89 | ||||||||
Rent | 1 | 31.25 | 31.25 | ||||||||
Electricity | 1 | 5.83 | 5.83 | ||||||||
Note Pad | 1 | 0 | |||||||||
Pen | 1 | 0.4 | 0.4 | ||||||||
Milk | 1 | 0.53 | 0.53 | ||||||||
Tea | 4 | 0.032 | 0.128 | ||||||||
Coffee | 4 | 0.14 | 0.56 | ||||||||
Decaff | 4 | 0.19 | 0.76 | ||||||||
Sugar | 4 | 0.12 | 0.48 | ||||||||
Equal | 4 | 0.12 | 0.48 | ||||||||
Salt | 4 | 0.06 | 0.24 | ||||||||
Paper | 4 | 0.09 | 0.36 | ||||||||
Total Cost In a room | 70.668 | ||||||||||
Total Stock order this month | |||||||||||
Ammenities | Qty in unit | Price/Unit | Total Consumpltion | ||||||||
Diswashing Liquid | 0.15 | 0 | |||||||||
Dishwashing Powder | 0.28 | 0 | |||||||||
Laundry Powder | 0.28 | 0 | |||||||||
Tea Towel | 0.27 | 0 | |||||||||
Bath towels | 0.57 | 0 | |||||||||
Face towel | 0.23 | 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 | |||||||||
Toilet Paper | 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 | |||||||||
Total Cunsumtion of ammentins/linen | 0 | ||||||||||
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 |