hello

kindly solve using excel or lindo and give a step-by-step answer to make it more understandable thanks

Problem Description A company has two factories, one each at Bristol and Leeds. The factories produce paints which are sold to five wholesalers. The wholesalers are either supplied directly from the factories or through one of the company warehouses, the transportation costs being paid by the company. The company has three warehouses, one each in London, Birmingham and Glasgow. Table 1 shows the transportation costs per ton for deliveries from the factories to the warehouses or wholesalers and also from the warehouses to the wholesalers, omitting entries when delivery from a certaln supplier or warehouse is impossi ble for some destination. The two factories at Eristol and Leeds can produce up to 50,000 and 60,000 tons per week respectively. No more than 25,000,20,000 and 16,000 tons can be moved each week through the warehouse in London, Birmingham and Glasgow, respectively. Wholesalers 1, 2, 3,4 and 5 require at least 20,000, 25,000, 13,000, 19,000 and 21,000 tons per week respecthely. Answer the following three parts of the problem. Parts A and B are worth 30 s each while part C is worth 408 of the overali mark for this problem. A. Formulate a linear programming model to determine the minimum cost trancportation schedule. Gearly explain the variables you use and the constraints you construct. What is the minimum cast. transportation schedule and what is the minimum transportation cost? B. Discuss the effect on the minimum tranaportation cost when capadty at each factory or warehouse is altered by adding or subtracting one ton. What are the minimum capacity changes (in both directions) at Giasgow that will alter the optimum set of routes and what will those alterations be? Explain how you arrive at each one of your answers. C. The management of the company is considering the possibilty af closing down ane of the warehouses as this is expected to resut in subatantial babour and maintenance savinge. Further, the manager of the Eirmingham warehouse is considering sub-letting some of the capacity of this warehouse. Such sub lets would have to be in exact mu tiples of 1000 tons. It is estimated that each 1000 tons of capacity could be let for 19,000 per week. Formulate a mined integer Inear programming model - or, if necessary, different model varlants - to examine and evaluate the alternathe courses of action. What would you recommend the company to do, and why? Discuss the alternathes, also taking into account the solution from part A and ceplain which additional information you might need (if anyd to ghe the company more specific advalce