September 28, 2025 Claire B 0 Comments

Activity
5.5 –Module Problems
Problems

Complete
the following problems and submit the results in either a Microsoft Word
document or a Microsoft Excel spreadsheet. If you choose to use an Excel
spreadsheet, place each problem on a separate sheet and label the tab with
problem number. Save your document with a descriptive file name, including
the assignment and your name.
05-Jan TheOutdoorFurnitureCorporationmanufacturestwoproducts,benchesandpicnictables,foruseinyardsandparks.Thefirmhastwomainresources:itscarpenters(laborforce)andasupplyofredwoodforuseinthefurniture.Duringthenextproductioncycle,1,200hoursoflaborareavailableunderaunionagreement.Thefirmalsohasastockof3,500boardfeetofgood-qualityredwood.EachbenchthatOutdoorFurnitureproducesrequires4laborhoursand10boardfeetof
redwood;eachpicnictabletakes6laborhoursand35boardfeetofredwood.Completedbencheswillyieldaprofitof$9each,andtableswillresultinaprofitof$20each.
a. HowmanybenchesandtablesshouldOutdoorFurnitureproducetoobtainthelargestpossibleprofit?UsethegraphicalLPapproach. (Submit both the QM and the graphical
solution.)
05-Feb MSAComputerCorporationmanufacturestwomodelsofminicomputers,theAlpha4andtheBeta5.Thefirmemployssixtechnicians,working160hourseachpermonth,onitsassemblyline.Managementinsiststhatfullemployment(i.e.,all
160hoursoftime)bemaintainedforeachworkerduringnextmonth’soperations.Itrequires20laborhourstoassembleeachAlpha4computerand25laborhourstoassembleeachBeta5model.MSAwantstoseeatleast10Alpha4sandatleast15Beta5sproducedduringtheproductionperiod.Alpha4sgenerate$1,200profitperunit,andBeta5syield$1,800each.
a. Determinethemostprofitablenumberofeachmodelofminicomputertoproduceduringthecomingmonth.
b. What
would the profit be if they decided to make at least 15 of each model?
05-Mar WooferPetFoodsproducesalow-caloriedogfoodforoverweightdogs.Thisproductismadefrombeefproductsandgrain.Eachpoundofbeefcosts$1.50,andeachpoundofgraincosts$0.70.Apoundofthedogfoodmustcontainatleast9unitsofVitamin1,10unitsofVitamin2,
and 6 units of Vitamin 3.Apoundofbeefcontains6unitsofVitamin1,
12unitsofVitamin2, and 4 units of Vitamin
3.Apoundofgraincontains12unitsofVitamin1,9unitsofVitamin2, and 10 units of
Vitamin 3.FormulatethisasaLPproblemtominimizethecostofthedogfood.
a. Howmanypoundsofbeefandgrainshouldbeincludedineachpoundofdogfood?
b.
Whatisthecostandvitamincontentofthefinalproduct?
c. What
would the distribution of beef and grain be if the cost of beef increased to
$3.50 per pound?

05-Apr TheFeed‘NShipRanchfattenscattleforlocalfarmersandshipsthemtomeatmarketsinKansasCityandOmaha.Theownersoftheranchseektodeterminetheamountsofcattlefeedtobuysothatminimumnutritionalstandardsaresatisfied,andatthesametimetotalfeedcostsareminimized.Thefeedmixcanbemadeupofthethreegrainsthatcontainthefollowingingredientsperpoundoffeed:
FEED (OZ)
INGREDIENT STOCK X STOCK Y STOCK Z
A 3 2 4
B 2 3 1
C 1 0 2
D 6 8 4
ThecostperpoundofstocksX,Y,andZare$3.50,$4.75,and$4.50,respectively.Theminimumrequirementpercowpermonthis4poundsofingredientA,5poundsofingredientB,1poundofingredientC,and8poundsofingredientD.Theranchfacesoneadditionalrestriction:itcanonlyobtain500poundsofstockZpermonthfromthefeedsupplierregardlessofitsneed.Becausethereareusually100cowsattheFeed‘NShipRanchatanygiventime,thismeansthatnomorethan5poundsofstockZcanbecountedonforuseinthefeedofeachcowpermonth.
a. FormulatethisasanLPproblem.
b. SolveusingLPsoftware.
You
may submit just the answers or you may submit the answers and the QM
worksheets you used to arrive at the answer. Choosing the latter will afford
instructors the opportunity to review your work and determine if you
understand the concept but have made some minor computational error,
therefore allowing them to assign some credit based on your understanding.
Submitting just the answers does not provide for any partial credit.

Order a similar assignment, and have writers from our team of experts write it for you, guaranteeing you an A

Order Solution Now

Categories: