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.
Document Preview:
1 0.15 0.15 1 0.28000000000000003 0.28000000000000003 1 0.28000000000000003 0.28000000000000003 1 0.27 0.27 2 0.56999999999999995 1.1399999999999999 0 2 0.23 0.46 1 0.32 0.32 3 0.32 0.96 3 0.98 2.94 1 0.41 0.41 2 0.14000000000000001 0.28000000000000003 1 0.21 0.21 1 0.21 0.21 1 0.21 0.21 1 0.21 0.21 2 0.69 1.38 2 0.86 1.72 1 0.19 0.19 1 0.12 0.12 1 0.02 0.02 1 17.89 17.89 1 31.25 31.25 1 5.83 5.83 1 0 1 0.4 0.4 1 0.53 0.53 4 3.2000000000000001E-2 0.128 4 0.14000000000000001 0.56000000000000005 4 0.19 0.76 4 0.12 0.48 4 0.12 0.48 4 0.06 0.24 4 0.09 0.36 70.668000000000021 0.15 0 0.28000000000000003 0 0.28000000000000003 0 0.27 0 0.56999999999999995 0 0.23 0 0.32 0 0.41 0 0.14000000000000001 0 0.21 0 0.21 0 0.21 0 0.21 0 0.69 0 0.86 0 0.19 0 0.12 0 0.02 0 0 0 31.25 0 5.83 0 0 0.4 0 0.53 0 3.2000000000000001E-2 0 0.14000000000000001 0 0.19 0 0.12 0 0.12 0 0.06 0 0.09 0 0 Total cost of the room Ammenities Diswashing Liquid Dishwashing Powder Laundry Powder Tea Towel Bath towels Face towel Hand Towel Bath Matt Soap Bar Shampooo Body Lotion Body Conditioner Body Wash Toilet Paper Tissue Box Grooming Kit Sanitory Bag Bin liner Housekeeping Rent Electricity Note Pad Pen Milk Tea Coffee Decaff Sugar Equal Salt Paper Qty Used Cost/Unit Total cost Total Cost In a room Total Stock order this month Qty Price/Unit Total Services done for the month Departure Service Linen Services Total Services Total Consumpltion Total Cunsumtion of ammentins/linen bedsheet pillow cover Qty in unit Total Avergae cost of a room this month Differece between the acutal cost and the consumption Reception2: Needs to be updated in reference to the spreadsheet sent by Natalie Reception2: the value should always be in positive
Attachments:
No comments:
Post a Comment