大連某公司年度產(chǎn)品生產(chǎn)計劃的優(yōu)化(完整版)
【正文】 $E$16總產(chǎn)值0 可變單元格數(shù)值表單元格名字初值終值$E$3115發(fā)電機0$E$400$E$500$E$600$E$700$E$8X711發(fā)電機02000 約束條件狀態(tài)表單元格名字單元格值公式狀態(tài)型數(shù)值$E$9熱處理（工時）$E$9=130000未到限制值$E$10機加工（工時）95000$E$10=96000到達限制值0$E$11總裝江（工時）$E$11=190000未到限制值$E$12生鐵（噸）$E$12=1552未到限制值$E$13焦碳（噸）$E$13=978未到限制值$E$14廢鋼（噸）$E$14=630未到限制值$E$15鋼材（噸）$E$15=470未到限制值$E$222000$E$22=3000到達限制值0$E$17$E$17=9000未到限制值$E$12生鐵（噸）$E$12=1552未到限制值$E$3115發(fā)電機$E$3=0未到限制值$E$8X711發(fā)電機2000$E$8=0未到限制值2000 3年輪番的生產(chǎn)計劃表年份安排生產(chǎn)的產(chǎn)品及產(chǎn)量（臺）總產(chǎn)值123 關(guān)于全面生產(chǎn)的討論為適應(yīng)市場要求，同時也不浪費設(shè)備，如果要求每年6種產(chǎn)品都必須生產(chǎn)，則可通過市場調(diào)查后確定產(chǎn)品的產(chǎn)量下限為：將上述3個產(chǎn)品產(chǎn)量下限作為約束條件加到原來的線性規(guī)劃模型中，－。Optimization Of The Annual Production Scheduling Of The Da Lian Pu Yang Electric Engine CompanyAbstract: This case describes the difficult position that the Da Lian Pu Yang electric engine pany confronted, points the annual production scheduling is the key of the whole planned system for the pany, analyses the production condition and correlation material of the pany. The mathematical model of the annual production scheduling is established using the multiple linear programming. The solutions of the linear programming problem are got by pany software Excel. A rather reasonable annual production scheduling is obtained. Moreover, discussing the solutions that the puter gets, all more optimization kinds of production scheduling plans are achieved. Key words: annual production scheduling。 目標單元格 (最大值)表單元格名字初值終值$E$16總產(chǎn)值 可變單元格數(shù)值表單元格名字初值終值$E$3115發(fā)電機00$E$4x115發(fā)電機$E$5X215發(fā)電機00$E$6X411發(fā)電機10001000$E$7X710發(fā)電機$E$8X711發(fā)電機0 約束條件狀態(tài)表單元格名字單元格值公式狀態(tài)型數(shù)值$E$9熱處理（工時）$E$9=130000未到限制值$E$10機加工（工時）$E$10=96000未到限制值$E$22$E$22=3000未到限制值$E$12生鐵（噸）$E$12=1552未到限制值$E$13焦碳（噸）$E$13=978未到限制值$E$14廢鋼（噸）$E$14=630未到限制值$E$15鋼材（噸）$E$15=470到達限制值0$E$12生鐵（噸）$E$12=1552未到限制值$E$170$E$17=9000未到限制值8000$E$18$E$18=2500未到限制值$E$190$E$19=5000未到限制值4000$E$201000$E$20=1500到達限制值0$E$21$E$21=2000未到限制值$E$11總裝江（工時）320000$E$11=330000未到限制值$E$3115發(fā)電機0$E$3=0到達限制值0$E$4x115發(fā)電機$E$4=0未到限制值$E$5X215發(fā)電機0$E$5=0到達限制值0$E$6X411發(fā)電機1000$E$6=0
化學相關(guān)推薦
鄂ICP備17016276號-1