Assist with Project Management (30. minute project for $15 just need to do summary not complete project)

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.

To

From Louisville (#4) Cincinnati (#5)

Muncie (#1) $8000 $6000

Brazil (#2) $3000 $8000

Xenia (#3) $9000 $3000

To

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.

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.
To
From Louisville (#4) Cincinnati (#5)
Muncie (#1) $8000 $6000
Brazil (#2) $3000 $8000
Xenia (#3) $9000 $3000
To
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.

Solve it without narrative

Contabilidad Análisis de negocios Búsqueda financiera Programación lineal Gestión de proyectos

Nº del proyecto: #6830831

Sobre el proyecto