数据模型与决策运筹学课后习题和案例答案

《数据模型与决策运筹学课后习题和案例答案》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。

1、CHAPTER2LINEARPROGRAMMING:BASICCONCEPTSReviewQuestions2.1-1PonderosaIndustrialuseslinearprogrammingmonthlytoguidetheproduct-mixdecision.2.1-2Overallprofitabilityhasincreasedby20%.Betterutilizationofrawmaterial,capitalequipment,andpersonnelalsoresulted.2.1-3Thegoalw

2、astoimprovetheutilizationofreservationpersonnelbymatchingworkschedulestocustomerneeds.2.1-4UnitedAirlinessavedmorethan$6millionannuallyindirectsalaryandbenefitcosts.Customerservicealsoimprovedandworkloadswerereducedforsupportstaff.2.1-5TheSDMsystemisusedtocoordinat

3、ethesupply,distributionandmarketingofeachofCitgo’smajorproductsthroughouttheUnitedStates.2.1-6Citgosavedabout$14millionannuallyininterestexpenses.Improvementsincoordination,pricing,andpurchasingdecisionsaddedatleast$2.5millionmoretoannualprofits.2.2-1Theyprovidethe

4、highestqualityavailableintheindustryforthemostdiscriminatingbuyers.2.2-21)Shouldthecompanylaunchthetwonewproducts?2)Whatshouldbetheproductmixforthetwonewproducts?2.2-3Thegroupwasaskedtoanalyzeproductmix.2.2-4Whichcombinationofproductionratesforthetwonewproductswoul

5、dmaximizethetotalprofitfrombothofthem.2.2-51)availableproductioncapacityineachoftheplants2)howmuchoftheproductioncapacityineachplantwouldbeneededbyeachproduct3)profitabilityofeachproduct2.3-11)Whatarethedecisionstobemade?2)Whataretheconstraintsonthesedecisions?3)Wh

6、atistheoverallmeasureofperformanceforthesedecisions?2.3-2Whenformulatingalinearprogrammingmodelonaspreadsheet,thecellsshowingthedatafortheproblemarecalledthedatacells.Thechangingcellsarethecellsthatcontainthedecisionstobemade.Theoutputcellsarethecellsthatprovideout

7、putthatdependsonthechangingcells.Thetargetcellisaspecialkindofoutputcellthatshowstheoverallmeasureofperformanceofthedecisiontobemade.2-652.3-3TheExcelequationforeachoutputcellcanbeexpressedasaSUMPRODUCTfunction,whereeachterminthesumistheproductofadatacellandachangi

8、ngcell.2.4-11)Gathertherelevantdata.2)Identifythedecisionstobemade.3)Identifytheconstraintsonthesedecisions.4)Identifytheoverallmeasureofperforma