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.