Reference no: EM132905972

The Emerald Valley Country Club has three tractors that are used for cutting grass. Each is of a different size and has different capabilities. The largest tractor cuts fairways and other large areas very efficiently, but has trouble around bunkers and trees. The smallest tractor cuts very quickly around small objects but takes more time on the open expanses of grass. The middle-sized tractor operates as a compromise between the other two. The 18-hole golf course is divided into three parts for cutting purposes: holes 1-6; holes 7-12; and holes 13-18. The club wants to determine which tractor should be assigned to which part of the course so as to minimize total cutting time. The table shows cutting times (in minutes) for the tractors in each of the three sections of the golf course:

?Section of Course
Tractor 1-6 7-12 13-18
Large 270 473 512
Medium 386 395 483
Small 456 409 476

U?sing Excel solve this assignment problem and then write down the following:

Which tractor should be assigned to which part of the course so as to minimize total cutting time-------also write explicitly the minimum total cutting time