Computer assignment
yunish
calculation.xlsxSheet1
| 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 |
