资源描述：
《数据、模型与决策(运筹学)课后习题和案例答案003》由会员上传分享，免费在线阅读，更多相关内容在教育资源-天天文库。
1、CHAPTER3THEARTOFMODELINGWITHSPREADSHEETSReviewQuestions3.1-1Thelong-termloanhasalowerinterestrate.3.1-2Theshort-termloanismoreflexible.Theycanborrowthemoneyonlyintheyearstheyneedit.3.1-3Endwithaslargeacashbalanceaspossibleattheendofthetenyearsafterpayingoffalltheloans.3.2-1Visuali
2、zewhereyouwanttofinish.Whatshouldthe“answer”looklike?3.2-2First,itcanhelpclarifywhatformulashouldbeenteredforanoutputcell.Second,handcalculationshelptoverifythespreadsheetmodel.3.2-3Sketchalayoutofthespreadsheet.3.2-4Trynumbersinthechangingcellsforwhichyouknowwhatthevaluesoftheout
3、putcellsshouldbe.3.2-5Relativereferencesarebaseduponthepositionrelativetothecellcontainingtheformula.Absolutereferencesrefertoaspecificcelladdress.3.3-1Enterthedatafirst.3.3-2Numbersshouldbeenteredseparatelyfromformulasindatacells.3.3-3Withrangenames,theformulasandSolverdialoguebo
4、xcontaindescriptiverangenamesratherthanobscurecellreferences.Usearangenamethatcorrespondsexactlytothelabelonthespreadsheet.3.3-4Borders,shading,andcolorscanbeusedtodistinguishdatacells,changingcells,outputcells,andtargetcellsonaspreadsheet.3.3-5Three.Onefortheleft-hand-side,onefor
5、theinequalitysign,andonefortheright-hand-side.3.4-1Trydifferentvaluesforthechangingcellsforwhichyoucanpredictthecorrectresultintheoutputcellsandseeiftheycalculateasexpected.3.4-2Control-~onaPC(command-~onaMac).3.4-3Theauditingtoolscanbeusedtotracedependentsorprecedentsforagivencel
6、l.3-11Problems3.13.2a.TheCOOwillneedtoknowhowmanyofeachproducttoproduce.Thus,thedecisionsarehowmanyendtables,howmanycoffeetables,andhowmanydiningroomtablestoproduce.Theobjectiveistomaximizetotalprofit.b.Pinewoodused=(3endtables)(8pounds/endtable)+(3diningroomtables)(80pounds/dinin
7、groomtable)=264poundsLaborused=(3endtables)(1hour/endtable)+(3diningroomtables)(4hours/diningroomtable)=15hoursc.d.3.3a.Topmanagementwillneedtoknowhowmuchtoproduceineachquarter.Thus,thedecisionsaretheproductionlevelsinquarters1,2,3,and4.Theobjectiveistomaximizethenetprofit.3-11b.E
8、ndinginventory(Q1)=StartingInvent
