ERP沙盘创业之星预算表

现金链状况,,,,,,,,,,,,,,,,,

项目,,第一季,,第二季,,第三季,,第四季,,第五季,,第六季,,第七季,,第八季,

,,发生额,余额,发生额,余额,发生额,余额,发生额,余额,发生额,余额,发生额,余额,发生额,余额,发生额,余额

期初余额,,600000,,"573,540.00",,"550,080.00",,526620,,"503,160.00",,"479,700.00",,"456,240.00",,"432,780.00",

期初余额,注册费用,"3,000.00","587,000.00",,"563,540.00",,"540,080.00",,"516,620.00",,"493,160.00",,"469,700.00",,"446,240.00",,"422,780.00"

,应收账款,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,

,税金,,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,

,原材料,,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,

,办公室租金,"10,000.00",,"10,000.00",,"10,000.00",,"10,000.00",,"10,000.00",,"10,000.00",,"10,000.00",,"10,000.00",

,采购误差调整,,"587,000.00",0.00,"563,540.00",0.00,"540,080.00",0.00,"516,620.00",0.00,"493,160.00",0.00,"469,700.00",0.00,"446,240.00",0.00,"422,780.00"

紧急贷款,紧急贷款,0.00,"587,000.00",0.00,"563,540.00",0.00,"540,080.00",0.00,"516,620.00",0.00,"493,160.00",0.00,"469,700.00",0.00,"446,240.00",0.00,"422,780.00"

,紧贷利息,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,

借款贴现,贴现现金,0.00,"587,000.00",0.00,"563,540.00",0.00,"540,080.00",0,"516,620.00",0.00,"493,160.00",0.00,"469,700.00",0.00,"446,240.00",0.00,"422,780.00"

,贴息,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,

,银行借款,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,

,利息,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,

固定资产,生产线+厂房,0.00,"587,000.00",0.00,"563,540.00",0.00,"540,080.00",0.00,"516,620.00",0.00,"493,160.00",0.00,"469,700.00",0.00,"446,240.00",0.00,"422,780.00"

,变卖生产线,,,0.00,,0.00,,,,,,,,,,,

,设备升级,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,

市场投资,市场开发,,"587,000.00",0.00,"563,540.00",0.00,"540,080.00",0.00,"516,620.00",0.00,"493,160.00",0.00,"469,700.00",0.00,"446,240.00",0.00,"422,780.00"

,ISO9001,,,0.00,,0.00,,,,,,,,,,,

,ICP,,,,,,,0.00,,0.00,,0.00,,,,,

,广告,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,

产品研发,产品设计,0.00,"587,000.00",0.00,"563,540.00",0.00,"540,080.00",0.00,"516,620.00",0.00,"493,160.00",0.00,"469,700.00",0.00,"446,240.00",0.00,"422,780.00"

,产品开发,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,

人力,人员招聘,0.00,"587,000.00",0.00,"563,540.00",0.00,"540,080.00",0.00,"516,620.00",0.00,"493,160.00",0.00,"469,700.00",0.00,"446,240.00",0.00,"422,780.00"

,人员培训,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,

,人员辞退,0.00,,0.00,,0.00,,0.00,,,,,,,,,

购买原料,原材料,0.00,"587,000.00",0.00,"563,540.00",0.00,"540,080.00",0.00,"516,620.00",0.00,"493,160.00",0.00,"469,700.00",0.00,"446,240.00",0,"422,780.00"

交付订单,收得现金,0.00,"587,000.00",0.00,"563,540.00",0.00,"540,080.00",0.00,"516,620.00",0.00,"493,160.00",0.00,"469,700.00",0.00,"446,240.00",0.00,"422,780.00"

借款贴现,贴现现金,0.00,"587,000.00",0.00,"563,540.00",0.00,"540,080.00",0.00,"516,620.00",0.00,"493,160.00",0.00,"469,700.00",0.00,"446,240.00",0.00,0.00

,贴息,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,

,银行借款,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,

,利息,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,

期末费用,加工费用,0.00,"573,540.00",0.00,"550,080.00",0.00,"526,620.00",0.00,"503,160.00",0.00,"479,700.00",0.00,"456,240.00",0.00,"432,780.00",0.00,"(13,460.00)"

,生产线维护,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,

,厂房租金,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,

,工人工资,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,

,管理人员成本,"13,460.00",,"13,460.00",,"13,460.00",,"13,460.00",,"13,460.00",,"13,460.00",,"13,460.00",,"13,460.00",

,销售人员工资,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,

,行政管理费用,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,

,罚单,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,

,银行还款,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,

,预出售设备款,0.00,"573,540.00",0.00,"550,080.00",0.00,"526,620.00",0.00,"503,160.00",0.00,"479,700.00",0.00,"456,240.00",0.00,"432,780.00",0.00,"(13,460.00)"

紧急贷款,紧急贷款,0.00,"573,540.00",0.00,"550,080.00",0.00,"526,620.00",0.00,"503,160.00",0.00,"479,700.00",0.00,"456,240.00",0.00,"432,780.00","16,825.00",0.00

,紧贷利息,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,0.00,,"3,365.00",

期末余额,,"573,540.00",,"550,080.00",,"526,620.00",,"503,160.00",,"479,700.00",,"456,240.00",,"432,780.00",,0.00,

,季度末权益,573540,,550080,,526620,,