XLS《浴室改造费用》

浴室改造费用 "浴室改造费用工作表" "注意:如果实际金额超过预计金额,表中将显示差额列.

红色数字表示金额超出(负数),黑色表示盈余(正数) ,,

,"明细费用 ($)",,

,"总费用 ($)",,

"区域","物品?","数量","估计","实际","差额","估计 ","实际 ","差额 " "浴室/淋浴","浴缸,铸铁,5 英尺,标准",1,250,261,-11,250,261,-11 "浴室/淋浴","浴室门,铰链式,标准",1,200,210,-10,200,210,-10 "浴室/淋浴","喷头,标准",1,50,68,-18,50,68,-18 "浴室/淋浴","浴缸壁围绕物,标准",1,200,206,-6,200,206,-6 "橱柜","药柜,24 英寸,豪华",1,200,220,-20,200,220,-20 "橱柜","单元式梳妆台,30 英寸,标准",2,100,115,-15,200,230,-30 "台面","瓷砖,豪华(数量以英尺为单位)",5,22.5,40,-17.5,112.5,200,-87.5 "水龙头","水龙头,浴缸,标准",1,90,102,-12,90,102,-12 "水龙头","水龙头,淋浴,单把手,标准",1,115,120,-5,115,120,-5 "水龙头","水槽水龙头,标准",1,95,107,-12,95,107,-12 "地板","瓷砖,标准(数量以平方英尺为单位)",35,12,24,-12,420,840,-420 "硬件","毛巾杆,标准",2,15,34,-19,30,68,-38 "硬件","卫生纸架",1,10,13,-3,10,13,-3 "照明","嵌壁灯,标准",4,25,44,-19,100,176,-76 "水槽","盥洗台,标准",2,60,72,-12,120,144,-24 "其他",,

1,20,26,-6,20,26,-6 "小计",,

,1464.5,1662,-197.5,2212.5,2991,-778.5 "非预期支出(预计加 30%)",,

,439.34999999999997,,

,663.75,,

"总费用",,

,1464.5,,

,2876.25,,