Description of this paper

Hi i need this supply chain model assignment completed

Description

solution


Question

Hi i need this supply chain model assignment completed in excel and word document. It is somewhat a report and problem solving. It is mostly linear programming about minimizing costs with;Attachment Preview;HW1_SCMA_probs_Oct_14.pdf Download Attachment;SupplyChainModelingandAnalysis;Fall2014;DepartmentofManagement;Homework1;Instructions;ThisassignmentisdueatthestartofclassonTuesday,October21,2014.;Thisisagroupassignment.;Eachgroupwillsubmitatypedreportansweringthethreequestions.;Ifyouuseamathematicalformulation(LinearProgrammingetc.),pleaseprovidea;formulationinyourreportwithacleardescriptionofthedecisionvariablesand;constraints.;IfyouuseExcelforcomputations,pleasesendthespreadsheetviaemailto;hari@miami.edu.;Pleasedonotshare/consultwithstudentsoutsideyourgroup/section/classetc.Any;outsidesources(magazines,websitesetc.)thatprovidesupportingmaterialmustbe;clearlystated.Plagiarismofanyformwillresultinafailinggrade.Ifyourgrouphasany;unresolvedquestion(s),pleasecontactme.Ifyouaresendingmeanemail,pleasewrite;acleardetaileddescriptionofyourconcern,soIcanaddressitaccurately.;Problem1;Achemicalcompanyownsfourfactoriesthatmanufactureacertainchemicalinrawform.Thecompany;wouldliketogetinthebusinessofrefiningthechemical.Itisinterestedinbuildingrefiningfacilities;andithasidentifiedthreepossiblesites.Table1containsvariablecosts,fixedcosts,weeklycapacities;forthethreepossiblerefiningfacilitysites,andweeklyproductionamountsforeachfactory.The;variablecostsareindollarsperweekandincludetransportationcosts.Thefixedcostsareindollarsper;year.Theproductionamountsandcapacitiesareintonsperweek.;Refiningsites;1;1;2;3;4;2;3;Factory;production;1000;1000;500;500;25;20;15;Factory;15;25;20;locations;20;15;25;25;15;15;500,000 500,000 500,000;Fixedcost;1500;1500;1500;Capacity;Table1.Cost,capacity,andproductioninformationforthechemicalcompany.;a) Formulatealinearprogramthatcanhelpidentifythefacilityconfigurationthatminimizesthe;totalcosts.;b) Ateachsite,thecompanycanalsoopenasmallersizefacilitywithcapacityof750atafixedcost;of300,000.Ifallotherinformationremainsthesame,formulatealinearoptimizationmodel;thatminimizesthetotalcosts.;c) Thecompanyhasrevampeditsproductionprocessinfactory3.Thenewprocessproduced;betterqualityproduct,buthasahigherproductioncost.Supposetheincreaseinproduction;costduetothenewprocessis$4perton.Then,istheformulationinpart(a)stillvalid?Ifnot;whatchangeswouldyousuggest?;Problem2;StraubLtd.hasfiveplantsrunningatfullcapacityinDesMoines,IA,Racine,WI,Gary,IN,Kalamazoo,MI;andDuluth,MN.TheseplantssupplyfourdistributionwarehousesinSt.Paul,MN,Milwaukee,WI;Chicago,ILandDetroit,MI.Thefollowingtablespecifiesthetransportationcostperunitfromeach;planttodistributionwarehouse.;Thenexttablespecifiestheproductioncapacityofeachplantandthedemandateachwarehouse.;a) Formulatealinearprogramtodeterminethedistributionplanthatminimizesthetotalcosts.;b) Recently,thestateofMichiganhasimposedanewtariffthatimpactsallinterstatetrafficthat;arrivesinMichigan.ForStraubLtd.,thetariffincreasesthecostofshipmentstoMichiganfrom;otherstatesby$2.Howdoesthischangeimpactthemodelformulationinpart(a)?;Problem3;Consideracompanythatfacesthefollowingdemandoverthenextsixmonths45000,55000,70000;100000,80000,and60000.Thecompanyhasapatentedproductionprocessthatrequiresspecial;components.Thecostofmaterialsis$5perunit.Thecostofholdinginventoryis$1.25perunitper;monthandinventoryisassessedbasedontheamountheldattheendofthemonth.Thecompany;backlogsitsdemandandthecostofbackloggingis$2perunitpermonth.Hiringandtraininganew;MGT445Fall2014HPN;Homework1;Page2;workercosts$200perworkerandfiringaworkercosts$250perworker.Thecompanyhasastarting;inventoryof2500unitsandanendinginventorytarget(attheendofsixmonths)of4500units.The;numberofworkingdaysintheupcomingmonthsis20permonth.Theproductrequires0.15labor;hoursperunit.Eachworkerispaid$8perhour.Theworkingdayconsistsofasingle8hourshift.;a) Evaluatethecostofthechasestrategy.;b) Evaluatethecostofthelevelstrategy.;c) Assumingthatbackloggingisnotallowed,formulatealinearprogramtodeterminetheoptimal;aggregateproductionplan.;MGT445Fall2014HPN;Homework1;Page3

 

Paper#18061 | Written in 18-Jul-2015

Price : $22
SiteLock