Agrifarm Company is in the business of buying and selling grain. The main aspect of the
company’s business is arranging for the purchased grain to be shipped to customers. The
profitability of the business has declined in the recent years and the management believes that if it
can keep shipping costs low, profitability will improve.
The company recently purchased from its Midwestern contracted farms (supply chain partners) 3
rail cars of grain at Muncie, 6 rail cars at Brazil, and 5 rail cars at Xenia. At the same time, four
long term customers at the East Coast placed orders for processed grains. Their specific locations
and order sizes are as follow:
Location of customer Number of rail carloads of grain ordered
Macon, GA (#6) 3
Greenwood, SC (#7) 4
Concord, SC (#8) 3
Chatham, NC (#9) 6
All shipments must be routed through a grain processing center at either Louisville or Cincinnati
before sending to customer destinations. Shown below are the shipping costs per rail carload of
grain from the origins to Louisville and Cincinnati and the costs to ship from the processing center
to the final customer destinations.
From Louisville (#4) Cincinnati (#5)
Muncie (#1) $8000 $6000
Brazil (#2) $3000 $8000
Xenia (#3) $9000 $3000
From Macon (#6) Greenwood (#7) Concord (#8) Chatham (#9)
Louisville (#4) $44000 $34000 $34000 $32000
Cincinnati (#5) $57000 $35000 $28000 $24000
You are asked to conduct an analysis and make recommendations that will help Agrifarm increase
profitability by optimizing the performance of its agricultural distribution network. In summary,
you need to develop a logistic integer programming (IP) model, perform appropriate analysis using
Excel spreadsheet and solver, recommend a distribution system to be implemented by the
Agrifarm, and finally, present a formal business communication report.
you have to write just summary.
15 freelancers estão ofertando em média $880 para este trabalho
Hi! I am a business student in the University of the East (one of the most prestigious universities) in the Philippines. I have already done a lot of paper works and some thesis paper about business management.
Hi, Is it necessary to solve in excel? I mean can we use some other solver or software for making the integer program? I can solve this as I have a good experience in making optimization models. Regards, Asad
I am a certified PMP and having an academic background where i have taught operations research subject.. which includes linear programming methods...and many decision making tools.
I have 7 years of experience in IT and project management. I am able to handle tools such as OpenProj, Microsoft project. I am familiar with PM techniques.