USING EXCEL SHEET!!! PLS HELPPPPPP. problem 3.1: shipping wood to the market

1 and 3 houn on matine 2 . Masiefe 1 wit be nulable br 16 hous inet the not two ilgs and matire 2 sill be salable quaties that vill masimus to iral prefi. bak kave far dis grobina can handie 20.000 copies a dog and cood S6oon Nodel B cas Case 3-1 Shipping Wood to Market h be pat, at conpany has shipged the nood by fir However, becaue shipping costs bave been increating. ilvernatve of taing thipg to make some of the delivet h. Formulne this sme model in algetraic form The purchase rice would be $201 million for each to rese pare. 5150 milica for cach iscdium-range plate, werifucl of all dotances a expected so be vufficiently lartes Nase, 59 milinon per modum-tange plane, land 56.9 mills that rang plant II is problicted dor ceough trained polots will be inaily plenet wers purchased the maintesance faclities would te nurirnisce foilines. De isformanan given here was oblained by a prelinde sabusef the frodem. A roore detailed analysis will be ofe upeasinuson, nanagement wishes to know bow many plea of eat gre ibould he purthased to maximaize profic. problem: f) Formalae ttis model in algehraio form. ril and by water (uhes feasible) is given by the abrne able for cach route. The capinal imsctmen (in thousands of dollan) in ships required for each million boand fost to be inamported annally by thip aloig cosh roult is given nest Comidering the esposted useful life of the ships and the time value of mosen, the expivalcat unifores annual cost of these invest ments is one-tent the amoun given in the bble. The cbjoctive. Case 3-2 Capacity Concerns ates joit upelght in their evensulfed chain He theorms the frost page of the The Wall siree henrnat on lop of The New York Tieser and wathes a his mapciates siden their sye once leavy wath boredoas Me. Hanilhon wanh to make a bie poine of the newapect pile and watches as tih aseocianes dab the fine beads of sweat off sheir beows. ues' minds. "I have just pescered you with thice leading founcial declares la a bght, angy voice "My dear associahes, our compary is going is tell in a hand bovet! Shall I rcad you the hesd: to lowea in 52 weeks.' Fron The Wair Siret fournal 'Comone year;, Ob, and iny favecile, fum the Financial Tines. Com. congary fall into sach dire strais?" Mr. Hamilian nat disglios a wecred grob ithowing a line