{"text_format":"3","workbook":"xls","n_sheets":10,"sheets":["规划求解 ","移动平均法","Chart1","预测函数","运算结果报告1","敏感性报告 1","极限值报告 1","方案摘要 ","方案数据透视表","规划求解"],"not_rendered":{"charts":1,"external_links":1,"defined_names":62},"unopened":[{"sheet":"Chart1","index":2,"reason":"not_a_worksheet"}],"read":"whole","date_system":"1900","formulas":"cached_only"}

{"sheet":"规划求解 ","index":0,"n_rows":10,"n_cols":6,"rows_kept":10,"merged":[[0,0,0,5]],"flags":["formulas_cached_only"]}
["甲、乙两种规格显卡的生产规划"]
["规格","成本（元）","生产时间（小时）","毛利（元）","生产量","销售利润小计（元）"]
["甲",400,5,100,0,0]
["乙",450,6.5,120,33,3960]
[]
["生产成本限制（元）",15000]
["生产时间限制（小时）",450]
["实际生产成本（元）",14850]
["实际生产时间（小时）",214.5]
["销售利润合计（元）",3960]

{"sheet":"移动平均法","index":1,"n_rows":16,"n_cols":4,"rows_kept":16,"merged":[[0,0,0,3],[13,0,13,1],[14,0,14,1],[15,0,15,1]],"flags":["formulas_cached_only"]}
["销售收入预测"]
["月份","主营业务收入","一次移动平均","二次移动平均"]
[1,{"v":5000,"d":"5000.00"}]
[2,{"v":4500,"d":"4500.00"}]
[3,{"v":1250,"d":"1250.00"}]
[4,{"v":3500,"d":"3500.00"},{"v":3562.5,"d":"3562.50"},3562.5]
[5,{"v":2600,"d":"2600.00"},{"v":2962.5,"d":"2962.50"},3262.5]
[6,{"v":2540,"d":"2540.00"},{"v":2472.5,"d":"2472.50"},2999.1666666666665]
[7,{"v":5123,"d":"5123.00"},3440.75,3109.5625]
[8,{"v":5454,"d":"5454.00"},3929.25,3201.25]
[9,{"v":4000,"d":"4000.00"},4279.25,3530.4375]
[10,{"v":3800,"d":"3800.00"},4594.25,4060.875]
[]
["a",null,{"v":5127.625,"d":"5127.63"}]
["b",null,{"v":355.5833333333333,"d":"355.58"}]
["2004年12月主营业务收入",null,{"v":5838.791666666667,"d":"5838.79"}]

{"sheet":"预测函数","index":3,"n_rows":6,"n_cols":8,"rows_kept":6,"merged":[[0,0,0,7]],"flags":["formulas_cached_only"]}
["预测函数的应用"]
["年度",1998,1999,2000,2001,2002,2003,2004]
["销售收入",{"v":20000,"d":"20000.00"},{"v":18900,"d":"18900.00"},{"v":25400,"d":"25400.00"},{"v":30000,"d":"30000.00"},{"v":26580,"d":"26580.00"},{"v":29800,"d":"29800.00"},{"v":35000,"d":"35000.00"}]
[]
["预测年度",2005]
["预测收入",36237.142857142724]

{"sheet":"运算结果报告1","index":4,"n_rows":24,"n_cols":7,"rows_kept":24,"flags":["formulas_cached_only"]}
["Microsoft Excel 11.0 运算结果报告"]
["工作表 [利润规划.xls]规划求解"]
["报告的建立: 2005-10-27 15:30:41"]
[]
[]
["目标单元格 (最大值)"]
[null,"单元格","名字","初值","终值"]
[null,"$B$10","销售利润合计（元） 成本（元）",3960,3960]
[]
[]
["可变单元格"]
[null,"单元格","名字","初值","终值"]
[null,"$E$3","甲 生产量",0,0]
[null,"$E$4","乙 生产量",33,33]
[]
[]
["约束"]
[null,"单元格","名字","单元格值","公式","状态","型数值"]
[null,"$B$9","实际生产时间（小时） 成本（元）",214.5,"$B$9<=$B$7","未到限制值",235.5]
[null,"$B$8","实际生产成本（元） 成本（元）",14850,"$B$8<=$B$6","未到限制值",150]
[null,"$E$3","甲 生产量",0,"$E$3=整数","到达限制值",0]
[null,"$E$4","乙 生产量",33,"$E$4=整数","到达限制值",0]
[null,"$E$3","甲 生产量",0,"$E$3>=0","到达限制值",0]
[null,"$E$4","乙 生产量",33,"$E$4>=0","未到限制值",33]

{"sheet":"敏感性报告 1","index":5,"n_rows":16,"n_cols":5,"rows_kept":16,"flags":["formulas_cached_only"]}
["Microsoft Excel 11.0 敏感性报告"]
["工作表 [利润规划.xls]规划求解"]
["报告的建立: 2005-10-27 15:45:53"]
[]
[]
["可变单元格"]
[{"$nulls":3},"终","递减"]
[null,"单元格","名字","值","梯度"]
[null,"$E$3","甲 生产量",0,-6.666666666666671]
[null,"$E$4","乙 生产量",33.333333333333336,0]
[]
["约束"]
[{"$nulls":3},"终","拉格朗日"]
[null,"单元格","名字","值","乘数"]
[null,"$B$9","实际生产时间（小时） 成本（元）",216.66666666666669,0]
[null,"$B$8","实际生产成本（元） 成本（元）",15000,0.26666666666666666]

{"sheet":"极限值报告 1","index":6,"n_rows":14,"n_cols":10,"rows_kept":14,"flags":["formulas_cached_only"]}
["Microsoft Excel 11.0 极限值报告"]
["工作表 [利润规划.xls]极限值报告 1"]
["报告的建立: 2005-10-27 15:49:26"]
[]
[]
[null,null,"目标式"]
[null,"单元格","名字","值"]
[null,"$B$10","销售利润合计（元） 成本（元）",4000]
[]
[]
[null,null,"变量",null,null,"下限","目标式",null,"上限","目标式"]
[null,"单元格","名字","值",null,"极限","结果",null,"极限","结果"]
[null,"$E$3","甲 生产量",0,null,0,4000,null,0,4000]
[null,"$E$4","乙 生产量",33.333333333333336,null,0,0,null,33.333333333333336,4000]

{"sheet":"方案摘要 ","index":7,"n_rows":12,"n_cols":5,"rows_kept":12,"flags":["formulas_cached_only"]}
[]
[null,"方案摘要"]
[{"$nulls":3},"当前值:","利润最大方案"]
[{"$nulls":4},"创建者 sun 日期 2005-10-27\n修改者 sun 日期 2005-10-27"]
[null,"可变单元格:"]
[null,null,"$E$3",0,0]
[null,null,"$E$4",33.3333333333333,33.3333333333333]
[null,"结果单元格:"]
[null,null,"$B$10",4000,4000]
[null,"注释: “当前值”这一列表示的是在"]
[null,"建立方案汇总时，可变单元格的值。"]
[null,"每组方案的可变单元格均以灰色底纹突出显示。"]

{"sheet":"方案数据透视表","index":8,"n_rows":5,"n_cols":2,"rows_kept":5,"flags":["formulas_cached_only"]}
["$E$3:$E$4 由","(全部)"]
[]
["$B$10"]
["$E$3:$E$4","汇总"]
["利润最大方案",4000]

{"sheet":"规划求解","index":9,"n_rows":10,"n_cols":6,"rows_kept":10,"merged":[[0,0,0,5]],"flags":["formulas_cached_only"]}
["甲、乙两种规格显卡的生产规划"]
["规格","成本（元）","生产时间（小时）","毛利（元）","生产量","销售利润小计（元）"]
["甲",400,5,100,0,0]
["乙",450,6.5,120,33.3333333333333,3999.999999999996]
[]
["生产成本限制（元）",15000]
["生产时间限制（小时）",450]
["实际生产成本（元）",14999.999999999985]
["实际生产时间（小时）",216.66666666666646]
["销售利润合计（元）",3999.999999999996]