模型4-10银行年底最优收款计划

12345678910111213141516ABCDEFGHIJKLMx1x2inF5:=D5+E5inF7:逾期贷款到期贷款利润指标/回收额回收额总计客户偿还能力3384117贷款总额80100回收利息(利润）0.20.11515回收本利和1.21.11321321080117=MAX($F$5)2=COUNT($D$5:$E$5)TRUE{=$D$5:$E$5=$D$6:$E$6}TRUE=$F$7=$G$7TRUE=$F$8=$G$8100={100,100,0.000001,0.05,TRUE,FALSE,FALSE,1,1,1,0.001,TRUE}12345678910111213141516N{=SUM($D$5:$E$5*D7:E7)}