模型4-03信用社最优贷款安排方案

123456789101112131415161718ABCDEFGHIJKLMNinG4:=SUM(D4:F4)inD6:生产设备贷款生产费用贷款农户贷款总计可提供量银行拨款01000100100自有资金4011030180180总计4021030需要量4021030生产设备贷款生产费用贷款农户贷款银行拨款480600720总利息自有资金660690900189300189300=MAX($G$11)6=COUNT($D$4:$F$5)FALSE{=$G$4:$G$5=$H$4:$H$5}FALSE{=$D$6:$F$6=$D$7:$F$7}100={100,100,0.000001,0.05,TRUE,FALSE,FALSE,1,1,1,0.001,TRUE}贷款(万元)利息(元)123456789101112131415161718OPQR=SUM(D4:D5)inG11:{=SUM(D4:F5*D10:F11)}