[求助]糖果厂生产糖果的最优比例

jerryh1984

<p> c4bp6fcI.rar (9.55 KB, 下载次数: 53)

2008-8-17 15:26 上传

点击文件名下载附件
[求助]EXCEL在生产管理中的应用

</p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 9pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">某糖果厂生产四种糖果</span><span lang="EN-US"><font face="Times New Roman">A,B,C,D.</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">下个月要求</span><span lang="EN-US"><font face="Times New Roman">A</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">的产量不少于</span><span lang="EN-US"><font face="Times New Roman">1000KG</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">，</span><span lang="EN-US"><font face="Times New Roman"> B</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">在</span><span lang="EN-US"><font face="Times New Roman">400KG</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">和</span><span lang="EN-US"><font face="Times New Roman">500KG</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">之间，</span><span lang="EN-US"><font face="Times New Roman">C</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">不多于</span><span lang="EN-US"><font face="Times New Roman">150KG</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">，</span><span lang="EN-US"><font face="Times New Roman">D</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">不多于</span><span lang="EN-US"><font face="Times New Roman">200KG</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">。现在糖果场有</span><span lang="EN-US"><font face="Times New Roman">1100KG</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">的坚果和</span><span lang="EN-US"><font face="Times New Roman">800KG</font></span><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">的巧克力, 求四种糖果的最优生产比例的问题</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 9pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;"></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 9pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">我做好了SOLVER的那个表</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 9pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">但是求最优解的时候遇到了麻烦</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 9pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">我有个疑问 使用利润求解的时候&nbsp; 是分别用四种产品的 还是是用总产品的</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 9pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;"></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 9pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">问题和EXCEL表格在附件里</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 9pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">麻烦各路高手帮我指正一下错误</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 9pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">谢谢</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 9pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;"></span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 9pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;">另外求关于最优解的教程</span></p><p class="MsoNormal" style="MARGIN: 0cm 0cm 0pt 9pt;"><span style="FONT-FAMILY: 宋体; mso-ascii-font-family: &quot;Times New Roman&quot;; mso-hansi-font-family: &quot;Times New Roman&quot;;"></span></p><p><br/></p>

[此贴子已经被作者于2008-8-17 15:30:58编辑过]

lanseqingren

使用利润求解的时候是用总产品的,(追求利润最大化)

jerryh1984

好的 谢谢 我在去算一次

lanseqingren

在追求“利润最大化”的同时千万不要忘记，“停工”造成的损失也要记入成本呦。所以，必须在保证“任务饱满”的前提下实现“利润最大化”。

n7272692

下来学习下！谢谢分享



灌得专业些好不好？看清楚人家这是求助贴！！！！

[ 本帖最后由 水平一般 于 2009-4-16 20:09 编辑 ]