学习任务4-1Excel在资金需要量预测中的应用（高低点法）.xlsxVIP免费

中兴公司甲产品资金需要量预测年度20095000323201055003362011600034120126600345201370003500.0135255.57800360.8公式定义说明B8=(VLOOKUP(MAX(B3:B7),B3:C7,2,FALSE)-VLOOKUP(MIN(B3:B7),B3:B9=VLOOKUP(MAX(B3:B7),B3:C7,2,FALSE)-B8*MAX(B3:B7)B11=B9+B8*B10产量x（件）资金占用量y（万元）单位变动资金b固定资金a2014年计划产量x预计资金需要量y中兴公司甲产品资金需要量预测年度20095000323201055003362011600034120126600345201370003500.0135255.57800360.8公式定义说明B8=(VLOOKUP(MAX(B3:B7),B3:C7,2,FALSE)-VLOOKUP(MIN(B3:B7),B3:C7,2,FALSE))/(MAX(B3:B7)-MIN(B3:B7))B9=VLOOKUP(MAX(B3:B7),B3:C7,2,FALSE)-B8*MAX(B3:B7)B11=B9+B8*B10产量x（件）资金占用量y（万元）单位变动资金b固定资金a2014年计划产量x预计资金需要量y