留学顾问の QQ：2128789860
留学顾问の微信：risepaper
本次展示的是第九次作业
Assignment 9: Transportation Planning With LP
A. You are a transportation economist for an Italian firm. In the next planning period, the firm must ship a product from Milan, Florence and Venice, to Turin, Genoa, Pisa, Modena and Padua. The quantities available by source, the quantities needed by destination, and unit transportation costs are as follows
Download the Excel file named MEL09-F15 Tran LP.xls. Set up this partially completed worksheet to solve minimum cost transportation problems with up to six sources and up to six destinations. Add the constraint equations (out-shipments by source and in-shipments by destination) and the objective/target equation (total transportation cost). Hint: this is a very good place to use the SUMPRODUCT function.
Set up the solver to find the minimum cost transportation plan for any problem with up to six sources and six destinations. Select the non-negative decision variables option and Simplex LP solution method. Enter the data for the problem above and find the optimal shipping plan using the Excel solver. Save the answer and sensitivity report tabs – you will be submitting your Excel file.
B. In the next shipping period, the per unit transport costs for shipments from Venice will be 25% higher due to road construction projects. Modify the problem and solve it for the new rate structure. Again, save the answer report and sensitivity report tabs.
C. Prepare a Word document with a complete description of the analyses you completed for problems A and B, and the results of the analyses. Write your report in the form of a memo to your company’s Director of Logistics.Your memo should be clear in meaning and free of errors. Use of linear programming and related economic terms and concepts should be correct and consistent – you may assume that the Director is familiar with these concepts and terms. Your memo should be complete, including data tables and tables of results.
D. For this assignment, you will submit your xlsx file with the two answer and sensitivity reports, and your docx file with the memo to the Director of Logistics. Details about submitting your assignment will be provided at the December 2 labs session.