please solve question 9.32

if you use the execel sheet i will thumbs up

348 CHAPTER 9. TRANSPORTATION, ASSIGNMENT AND NETWORK MODELS Data for Problem 9-31 MISSION MAR APR JAN 12 FER 26 MAY 1 JUN 9 AUG. SEP. 19 6 1 4 10 9 10 7 1 9 4 9 7 6 2 + 6 7 ASTRONAUT Vincze Veit Anderson Herbert Schatz Plane Certo Moses Brandon Ditina 9 8 2 4 10 1 JAN. 27 5 7 2 8 3 1 10 4 10 10 9 3 5 8 2 7 4 5 10 7 7 1 1 10 + 1 10 9 7 8 1 9 2 7 1 2 9 3 5 10 7 1 3 10 7 4 10 6 9 7 8 7 + + 5 5 8 recomptes the schedule. Do any changes occur of the assignment, as shown in the table on this page over the schedule set in part(b)? The scale is I least desirable to 5 (most desirable) (d) What are the strengths and weaknesses of this Which mignments should be made if the total of the approach to scheduling ratings is to be maximized! 319-32 The XYZ. Corporation is expanding its market to 9-33 Bechtold Construction is in the process of installing include Texas Each salesperson is assigned to po power lines to a large housing development. Steve tential distributors in one of five different areas. It Bechtold wants to minimize the total length of wire is anticipated that the salesperson will spend about used, which will minimize his costs. The housing three to four weeks in the assigned area. A statewide development is shown as a network on this page. marketing campaign will begin once the product has Each house has been numbered, and the distances been delivered to the distributors. The five salespeo between houses are given in hundreds of fect. What ple who will be assigned to these areas (one person do you recommend for each area have rated the areas on the desirability Table for Problem 9-32 AUSTINSAN DALLASET EL PASOY HOLSTON CORPUS CHRISTURIO ANTONIO WORTH WEST TEXAS GALVESTON GRANDE VALLEY Erica 5 Louis 3 2 Maria 4 3 Paul Orlando Network for Problem 9-33 A B D E F G H 3 Y Z How N #VALUE! LHS 1 2 3 4. Decision Variables 5 6 7 8 9 10 11 12 Objective Function Coefficient 13 Constraints: 14 15 16 17 18 19 20 21 22 23 24 25 26 Sign RHS CE