First, you can make sure your model is working correctly before you set up Solver to run Second, assign ing the plane fleet manually will demonstrate which constraints you must meet in solving the problem For instance, if a passenger or cargo utilization rate is over 1 0 0 , you have not assigned enough planes to carry all the passengers and cargo to a particular destination Therefore, one constraint is that the total passenger capacity for the planes assigned to a destination must be greater than or equal to the passenger bookings Another constraint is that the total cargo capacity for the planes assigned must be greater than the cargo shipments booked Given the fleet size, you can probably assign the fleet manually and meet all of your con straints However, will your total operating cost be the least expensive solution Running the problem manu ally will provide an initial operating cost to which you can compare your Solver solution later The Solver optimization tool should give you a better solution than assigning the fleet manually When attempting to assign the planes manually in the Plane Assignment section ( the changing cells ) , you must satisfy both the passenger and cargo demands for each destination in other words, the Total Passenger Capacity values in cells J 2 2 through J 2 8 and the Total Cargo Capacity values in cells L 2 2 through L 2 8 must be equal to or greater than the Daily Demand values in cells D 2 2 through D 2 8 and E 2 2 through E 2 8 If you have satisfied the passenger and air freight demands correctly, none of the utilization rates in cells K 2 2 through K 2 8 and M 2 2 through M 2 8 will exceed 1 0 0 In addition, the total planes assigned for each type ( cells F 2 9 through I 2 9 ) cannot exceed the available number of each plane type ( cells G 6 to G 9 ) Once you reach a solution that satisfies the preceding constraints, save your workbook Name the work sheet Rose Tree Guess and then right click the worksheet name tab, click Move or Copy, copy the worksheet, and rename the new copy Rose Tree Solver 1 You will use the new worksheet to complete the next part of the assignment

Question

First, you can make sure your model is working correctly before you set up Solver to run  Second, assign   ing the plane fleet manually will demonstrate which constraints you must meet in solving the problem  For instance, if a passenger or cargo utilization rate is over 1 0 0   , you have not assigned enough planes to carry all the passengers and cargo to a particular destination  Therefore, one constraint is that the total passenger capacity for the planes assigned to a destination must be greater than or equal to the passenger bookings  Another constraint is that the total cargo capacity for the planes assigned must be greater than the cargo shipments booked  Given the fleet size, you can probably assign the fleet manually and meet all of your con   straints  However, will your total operating cost be the least expensive solution  Running the problem manu   ally will provide an initial operating cost to which you can compare your Solver solution later  The Solver optimization tool should give you a better solution than assigning the fleet manually  When attempting to assign the planes manually in the Plane Assignment section ( the changing cells ) , you must satisfy both the passenger and cargo demands for each destination in other words, the Total Passenger Capacity values in cells J 2 2 through J 2 8 and the Total Cargo Capacity values in cells L 2 2 through L 2 8 must be equal to or greater than the Daily Demand values in cells D 2 2 through D 2 8 and E 2 2 through E 2 8   If you have satisfied the passenger and air freight demands correctly, none of the utilization rates in cells K 2 2 through K 2 8 and M 2 2 through M 2 8 will exceed 1 0 0     In addition, the total planes assigned for each type ( cells F 2 9 through I 2 9 ) cannot exceed the available number of each plane type ( cells G 6 to G 9 )   Once you reach a solution that satisfies the preceding constraints, save your workbook  Name the work   sheet Rose Tree Guess and then right   click the worksheet name tab, click Move or Copy, copy the worksheet, and rename the new copy Rose Tree Solver 1   You will use the new worksheet to complete the next part of the assignment

SolutionInn · Accepted Answer

The Answer is in the image, click to view ...

Question: First, you can make sure your model is working correctly before you set up Solver to run. Second, assign - ing the plane fleet manually

Step by Step Solution

Students Have Also Explored These Related General Management Questions!