12应收信用期决策.xls

1、1001.5 信用期年销量29654435563341472247481053389959298865110777101166770125482913438881432决决策策变变量量单价31单位变动成本11利率40%40信用期592预计年销量988折扣期85折扣10%10预计享受折扣的比例43%43收账费用占销售收入比例5%5坏账损失占应收账款比例7%7决决策策目目标标相关收益19760.00应收款占用资金应计利息4516.14年收账费用1531.40年坏账损失2227.28现金折扣1317.00相关净收益10168.181000800 600 400 200 0 0 2000 4000 6

2、000 8000 10000 12000 信用期相关净收益相关收益应计利息收账费用坏账损失现金折扣相关净收益10880.001364.82843.20673.10725.157273.7312656.001848.59980.84911.69843.528071.3614432.002405.601118.481186.40961.898759.6216208.003035.871256.121497.241080.269338.5117984.003739.381393.761844.191198.639808.0319760.004516.141531.402227.281317.0010168.1821536.005366.141669.042646.481435.3710418.9623312.006289.391806.683101.811553.7410560.3725088.007285.891944.323593.271672.1210592.4026864.008355.642081.964120.851790.4910515.0728640.009498.632219.604684.551908.8610328.367273.7310592.40