(含公式自动计算)收支平衡分析表模板.doc

(含公式自动计算)收支平衡分析表模板 固定成本计算 可变成本计算 生产一单位产品所需花费的产品成本 生产一单位产品所需花费的其他附加成本 类型定义 费用金额 类型定义 费用金额 管理费 100.00 原材料费 2.50 职工福利费 100.00 办公辅助用品费 100.00 管理人员工资 200.00 运输费 100.00 返工费 100.00 产品售出单价: 5.00 * 向每一位客户卖出一份产品的单位价格 预计总销量: 310 * 一段时间内预计可售出的产品数量 保本销售量: PSW_Sheet %3c%3fxml+version%3d%221.0%22+encoding%3d%22utf-16%22%3f%3e%0d%0a%3cPageInputCells+xmlns%3axsi%3d%22http%3a%2f%2%2f2001%2fXMLSchema-instance%22+xmlns%3axsd%3d%22http%3a%2f%2%2f2001%2fXMLSchema%22%3e%0d%0a++%3cInputCells+InputPrefix%3d%22PSWInput_%22+ListPrefix%3d%22PSWList_%22+CellCount%3d%2242%22%3e%0d%0a++++%3cCells%3e%0d%0a++++++%3cAddress%3e%3d#039;BreakEven+Data#039;!%24C%248%3c%2fAddress%3e%0d%0a++++++%3cListItemsAddress+%2f%3e%0d%0a++++++%3cNameIndex%3e0%3c%2fNameIndex%3e%0d%0a++++++%3cIsHidingEnabled%3efalse%3c%2fIsHidingEnabled%3e%0d%0a++++++%3cIsDisablingEnabled%3efalse%3c%2fIsDisablingEnabled%3e%0d%0a++++++%3cRequiresValidation%3efalse%3c%2fRequiresValidation%3e%0d%0a++++++%3cIsRequired%3efalse%3c%2fIsRequired%3e%0d%0a++++++%3cType%3eText+Box%3c%2fType%3e%0d%0a++++++%3cDefaultValue+%2f%3e%0d%0a++++++%3cValueType+%2f%3e%0d%0a++++%3c%2fCells%3e%0d%0a++++%3cCells%3e%0d%0a++++++%3cAddress%3e%3d#039;BreakEven+Data#039;!%24K%248%3c%2fAddress%3e%0d%0a++++++%3cListItemsAddress+%2f%3e%0d%0a++++++%3cNameIndex%3e1%3c%2fNameIndex%3e%0d%0a++++++%3cIsHidingEnabled%3efalse%3c%2fIsHidingEnabled%3e%0d%0a++++++%3cIsDisablingEnabled%3efalse%3c%2fIsDisablingEnabled%3e%0d%0a++++++%3cRequiresValidation%3efalse%3c%2fRequiresValidation%3e%0d%0a++++++%3cIsRequired%3efalse%3c%2fIsRequired%3e%0d%0a++++++%3cType%3eText+Box%3c%2fType%3e%0d%0a++++++%3cDefaultValue+%2f%3e%0d%0a++++++%3cValueType+%2f%3e%0d%0a++++%3c%2fCells%3e%0d%0a++++%3cCells%3e%0d%0a++++++%3cAddress%3e%3d#039;BreakEven+Data#039;!%24C%249%3c%2fAddress%3e%0d%0a++++++%3cListItemsAddress+%2f%3e%0d%0a++++++%3cNameIndex%3e2%3c%2fNameIndex%3e%0d%0a++++++%3cIsHidingEnabled%3efalse%3c%2fIsHidingEnabled%3e%0d%0a++++++%3cIsDisablingEnabled%3efalse%3c%2fIsDisablingEn