41+51X42+25X43+46X44Р(3)根据决策变量写出约束条件:指派问题约束反映的情况如下:每个临时工被赋予一项任务,并且每项任务被赋予一个临时工。Р这些约束条件如下:Р安的指派:X11 + X12 + X13 + X14 = 1Р伊恩的指派:X21 + X22 + X23 + X24 = 1Р琼的指派:X31 + X32 + X33 + X34 = 1Р肖恩的指派:X41 + X4 2+ X43 + X44 = 1Р文字处理:X11 + X21 X31 X41 = 1Р绘图:X12 + X22 + X31 + X42 = 1Р材料准备:X13 + X23 + X33 + X43 = 1Р记录:X14 + X24 + X34 + X44 = 1Р(4)根据步骤(2)(3)写出模型目标函数,并建立数学模型:РMin Z = 35X11+41 X12+27 X13+40 X14+47X21+45X22+32X23+51X24+39X31+56X32+36X33+43X34Р+32X41+51X42+25X43+46X44Рs.t: X11 + X12 + X13 + X14 = 1Р X21 + X22 + X23 + X24 = 1Р X31 + X32 + X33 + X34 = 1Р X41 + X4 2+ X43 + X44 = 1Р X11 + X21 X31 X41 = 1Р X12 + X22 + X31 + X42 = 1Р X13 + X23 + X33 + X43 = 1Р X14 + X24 + X34 + X44 = 1Р =1,2,3,4;j=1,2,3,4Р(5)在工作表中建模:根据题意,在excel表格中输入相应的数据:Р图2.1.1在表中输入与题目相关的数据Р(6)在excel中确定决策变量的位置,利用sumproduct函数进行求解:
全文预览
