Answer below

GreenCIean Bamboo Products, Inc. produces sustainable paper products such as bath rolls and paper towels using bamboo instead of wood. The CEO of GreenCIean, Annika Janeway, wants to ensure that a steady, adequate flow of bamboo to the four paper-processing plants is maintained to capitalize on the growing demand for sustainable products in the market. The bamboo arrives from four major locations and the distance from each location to the processing plants is shown in the figure below. Annika's goal is to ensure that the transportation costs are minimized to the extent possible in order to maintain profitability in the company. The average haul cost is $2 per mile for both loaded and empty trucks because the company uses biofuel to minimize their carbon footprint. The intake manager has estimated the number of truckloads of bamboo that can be obtained from each location every week. The processing managers at each plant have estimated the truckloads of bamboo their plants require every week. These estimates are also provided in the figure below. Distance to Plant (miles) Maximum Farm Plant1 Plant2 Plant3 Plant4 Truckloads LandA 8 15 50 10 50 LandB 1o 17 20 18 40 LandC 30 26 15 20 35 LandD 40 12 25 5 25 Plant Demand 45 40 40 25 Draw the Network Diagram showing costs oftransportation (do this in your excel le that you will upload later on, not to be pasted here). Write out the Linear Program (equations) to minimize the costs of transportation in the space below: You will be using the Excel Solver to nd the solution to the question on how many truckloads should be sent form each land area and to which plants and what is the total cost of transportation per week. Fill in the blanks below with your responses. Truckloads to Plant Maximum Fa rm Plantl Plant2 Plant3 Plant4 Truckloads La ndA 50 La ndB 40 La ndC 35 La ndD 25 Plant Demand 45 40 40 25 Total Cost: $