模型4-02银行扶助企业贷款的最优发放安排

1234567891011121314ABCDEFGHIJKLMinF5:{=SUM($D$4:$E$4*D5:E5)}inG7:甲类企业乙类企业65总计可提供额固定资金贷款1012120120流动资金贷款1048080创造利润1514总利润160160=MAX($G$7)2=COUNT($D$4:$E$4)FALSE{=$D$4:$E$4=INT($D$4:$E$4)}FALSE{=$F$5:$F$6=$G$5:$G$6}100={100,100,0.000001,0.05,TRUE,FALSE,FALSE,1,1,1,0.001,TRUE}1234567891011121314N{=SUM($D$4:$E$4*D7:E7)}