Em Andamento

linear programming at excel and one and half page summery(can you do this )

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

Habilidades: Contabilidade, Pesquisa financeira, Programação Linear, Fabricação de produtos, Gestão de projetos

Ver mais: you do it, time in ga, supply one, report programming, programming model, programming in excel, programming for excel, programming center, one coast, nc time, nc programming, linear programming solver excel, linear programming project, linear programming model, linear programming in excel, linear programming in business, linear programming help, integer programming solver, excel spreadsheet business, excel linear programming help, excel help business, concord 4 programming, can you do, aspect programming, 3-4 linear programming

Acerca do Empregador:
( 0 comentários ) Lahore, Pakistan

ID do Projeto: #6831268

Premiar a:

Gkiprop

A proposal has not yet been provided

$25 USD em 1 dia
(1 Comentário)
0.8