Lance Armweak runs a bike tour company. He offers two types of bike tours - an easy tour which lasts 3 days and an advanced 5-day bike tour. Lance has provided you with the following break-down of his projected overhead costs and activities associated with all the tours to take place in 2020. Activity Total Overhead ($) Advertising Use of Bikes Guides Activity Driver Number of tours Number of people Total distance ridden (kms) 2,000 17,500 45,000 Number of Activity Drivers 200 1,750 9,000 He also provided you with the following activity break-down for each of these two types of tours. Easy Tour Advanced Tour Number of tours 50 Number of people per tour 10 Number of days per tour Distance ridden per tour(km) 20 120 150 5 5 3 In the past, Lance has followed the traditional method with one pre-determined overhead rate based on the number of tours to be undertaken. Required: a) Calculate the total projected overhead for all tours. Show all calculations. b) Calculate the predetermined overhead rate under the traditional method used by Lance, based on the number of tours to be undertaken. Show all calculations. c) Calculate the overhead cost of each type of tour (Easy and Advanced) using the traditional method. Show all calculations. d) Calculate the overhead cost of each tour (Easy and Advanced) using the activity drivers and associated activity costs. Show all calculations. e) Discuss in detail the conclusions you reached regarding the overhead costs for each type of tour for each cost allocation method