应收折扣决策模型
- 格式:xls
- 大小:29.50 KB
- 文档页数:2
决策变量0.3折扣享受折扣的比例相关收益
单价720.50%31.00%2070.00
单位变动成本40.60%31.20%2070.00
利率67%670.70%31.40%2070.00
信用期179
0.80%31.60%2070.00
预计年销量690
0.90%31.80%2070.00
折扣期31
1.00%32.00%2070.00
折扣1.00%
1.001.10%32.20%2070.00
预计享受折扣的比例32%
1.20%32.40%2070.00
收账费用占销售收入比例10%
101.30%32.60%2070.00
坏账损失占应收账款比例3%
31.40%32.80%2070.00
1.50%33.00%2070.00
决策目标
相关收益2070.00
应收款占用资金应计利息
676.19
年收账费用483.00
年坏账损失52.99
现金折扣15.46
相关净收益842.37
842.10
842.15
842.20
842.25
842.30
842.35
842.40
0.00%0.20%0.40%
相
关
净
收
益
应计利息收账费用坏账损失现金折扣相关净收益
683.79483.0053.587.49842.14最小值842.11
682.27483.0053.469.04842.22最大值842.37
680.75483.0053.3410.62842.29
679.23483.0053.2212.21842.33
677.71483.0053.1013.82842.36
676.19483.0052.9915.46842.37
674.67483.0052.8717.11842.36
673.15483.0052.7518.78842.32
671.63483.0052.6320.47842.27
670.11483.0052.5122.18842.20
668.59483.0052.3923.91842.11
%0.60%0.80%1.00%1.20%1.40%1.60%
折扣