Question 2 (50 Marks) The PaveRight Road Construction Company undertake road work throughout the Northern NSW region. They have two distribution facilities: one at the Gold Coast and one at Grafton. Currently, they have four construction sites, one at Lismore, one at Tenterfield, one at Casino, and one at Bryon Bay, with the road construction projects requiring delivery of pre-stressed concrete bridge girders (deck units). The Lismore site requires 25 deck units, Tenterfield requires 40, Casino requires 10, and Byron Bay requires 20. The deck unit stock on hand at Gold Coast is 40, and at Grafton, it is 65. The cost of transporting a deck unit from each distribution facility to each construction site is shown in the following table: Lismore Tenterfield Casino Bryon B'ay Gold Coast $1800 $2800 $2000 $1500 Grafton $2000 $2300 $1600 $2500 a) Explain the operations research technique that could be used to solve the problem. Include your reasoning in your answer. (25 marks) b) Use the technique described in (a), implemented in Microsoft Excel, to determine the number of deck units that should be shipped from each distribution facility to each site to give the lowest cost. What is your recommended solution, including the total cost, to the company? 25 marks