LINEAR PROGRAMMING MODELING APPLICATIONS WITH COMPUTER ANALYSES IN EXC Table for Problem 45 CUSTOMERS ($ PER UNIT SHIPPED) PLANT SAVANNAH MOBILE ROANOKE AVAILABLE posn tou Sh#14 $42 $38 450 Columbia Greensboro Required $13 $25 250 $17 290 $48 225 210 would like to determine the least wasteful way (i.e., minimize the amount of paper wasted). What is the solution with this revised objective, and what is the new cost? the distances (in miles) ar table. ATTENDANCE ZONE NORTH so 8 4 Central High School Northwestern High School Southeastern High School Number of Students 16 903 15 A company that manufactures products in two plants ships locally using its own transportation system, but it has orders that must be sent to customers too far away to be serviced by the local fleet. It therefore contracts with a middle-distance carrier to complete its shipping. The locations of the two manufacturing plants, amounts available at each plant to be shipped per week, locations of the three customers, their weekly requirements, and shipping costs ($ per unit) between each plant and customer are shown in the table at the top of this page. What is the optimal shipping plan to satisfy the demand at the lowest total shipping cost? A school district must determine which students from each of the four attendance zones will attend which of the three high schools. The north atten- dance zone is 8 miles from Central High School, 4 miles from Northwestern High School, and 16 miles from Southeastern High School. All of Each school can have as enrolled. The school dis the allocation of students mize the number of miles students. 47 The school district in Pro an additional constraint o enroll the same number three schools. Solve for students to schools that of miles necessary to trans