Spreadsheet: 92420d1291981993-working-on-rows-working
Sheet: Working

 |  |  |  |  |  | Internal Working Sheet
 |  |  |  | Selling Price |  | Material |  |  |  |  | Labour
S.No | Description | Qty | Unit | Unit Rate | Total Amount | Basic | Discount | Taxes | Freight | Total Unit Rate | Basic | Tax | Total Unit Rate | Margin
1 | Supply, Install & Commissioning of Sanitarywares
1a | Water Closet | 12 | Nos |  |  | 7500 | 0.05 | 0.15 | 0.03 |  | 750 | 0.12 |  | 0.1
 | Supports | 12 | Items |  |  | 500 |  | 0.15 | 0.03 |  |  |  |  | 0.1
 | Ancillaries | 12 | Items |  |  | 250 |  | 0.15 | 0.03 |  |  |  |  | 0.1
1b | Urinal | 2 | Nos |  |  | 9500 | 0.05 | 0.15 | 0.03 |  | 850 | 0.12 |  | 0.1
 | Supports | 2 | Items |  |  | 500 |  | 0.15 | 0.03 |  |  |  |  | 0.1
 | Ancillaries | 2 | Items |  |  | 250 |  | 0.15 | 0.03 |  |  |  |  | 0.1
1c | Bidet | 12 | Nos |  |  | 8000 | 0.05 | 0.15 | 0.03 |  | 800 | 0.12 |  | 0.1
 | Supports | 12 | Items |  |  | 500 |  | 0.15 | 0.03 |  |  |  |  | 0.1
 | Ancillaries | 12 | Items |  |  | 250 |  | 0.15 | 0.03 |  |  |  |  | 0.1
1d | Wash Basin | 12 | Nos |  |  | 9650 | 0.05 | 0.15 | 0.03 |  | 750 | 0.12 |  | 0.1
 | Supports | 12 | Items |  |  | 500 |  | 0.15 | 0.03 |  |  |  |  | 0.1
 | Ancillaries | 12 | Items |  |  | 250 |  | 0.15 | 0.03 |  |  |  |  | 0.1
2 | Supply, Installation of Hot/Cold Water Copper Piping
2a | 110mm | 25 | m |  |  | 450 |  | 0.07 | 0.03 |  |  | 0.12 |  | 0.15
 | Supports | 25 | Items |  |  |  |  | 0.15 | 0.03 |  |  |  |  | 0.15
2b | 76[NAME] | 40 | m |  |  | 385 |  | 0.07 | 0.03 |  |  | 0.12 |  | 0.15
 | Supports | 40 | Items |  |  |  |  | 0.15 | 0.03 |  |  |  |  | 0.15
2c | 65mm | 15 | m |  |  | 310 |  | 0.07 | 0.03 |  |  | 0.12 |  | 0.15
 | Supports | 15 | Items |  |  |  |  | 0.15 | 0.03 |  |  |  |  | 0.15
2d | 50mm | 45 | m |  |  | 275 |  | 0.07 | 0.03 |  |  | 0.12 |  | 0.15
 | Supports | 45 | Items |  |  |  |  | 0.15 | 0.03 |  |  |  |  | 0.15
2e | 27mm | 75 | m |  |  | 165 |  | 0.07 | 0.03 |  |  | 0.12 |  | 0.15
 | Supports | 75 | Items |  |  |  |  | 0.15 | 0.03 |  |  |  |  | 0.15
2f | 13mm | 150 | m |  |  | 120 |  | 0.07 | 0.03 |  |  | 0.12 |  | 0.15
 | Supports | 150 | Items |  |  |  |  | 0.15 | 0.03 |  |  |  |  | 0.15
3 | Supply, Installation of Soil/Waste PVC Piping
3a | 160mm | 80 | m |  |  | 175 |  | 0.07 | 0.03 |  |  | 0.12 |  | 0.15
 | Supports | 80 | Items |  |  |  |  | 0.15 | 0.03 |  |  |  |  | 0.15
3b | 110mm | 40 | m |  |  | 125 |  | 0.07 | 0.03 |  |  | 0.12 |  | 0.15
 | Supports | 40 | Items |  |  |  |  | 0.15 | 0.03 |  |  |  |  | 0.15
3c | 76[NAME] | 56 | m |  |  | 75 |  | 0.07 | 0.03 |  |  | 0.12 |  | 0.15
 | Supports | 56 | Items |  |  |  |  | 0.15 | 0.03 |  |  |  |  | 0.15
3d | 65mm | 80 | m |  |  | 70 |  | 0.07 | 0.03 |  |  | 0.12 |  | 0.15
 | Supports | 80 | Items |  |  |  |  | 0.15 | 0.03 |  |  |  |  | 0.15
3e | 50mm | 72 | m |  |  | 60 |  | 0.07 | 0.03 |  |  | 0.12 |  | 0.15
 | Supports | 72 | Items |  |  |  |  | 0.15 | 0.03 |  |  |  |  | 0.15
4 | Supply,Install & Commissioning of Hydro Pneumatic System wih Valves with Control Panel
4a | 150lps@40m Head | 1 | Set |  |  | 12500 |  | 0.15 | 0.03 |  | 1200 | 0.12 |  | 0.1
 | Valves Package | 1 | Items |  |  | 3500 |  | 0.15 | 0.03 |  |  |  |  | 0.1
 | Supports | 1 | Items |  |  | 1500 |  | 0.15 | 0.03 |  |  |  |  | 0.1
 | Vibration Isolators | 1 | Items |  |  | 750 |  | 0.15 | 0.03 |  |  |  |  | 0.1