Question 2. (30 marks) Squamish Co. makes three product - road bikes, mountain bikes and hybrid bikes. The road bikes are a low volume product that is more specialized while the mountain bikes and hybrid bikes are of higher volume and easier to manufacture. Squamish Co. allocated manufacturing overhead costs to the three products for the month of May. Squamish Co. has an estimated overhead cost of $5,000,000 and uses 500,000 machine hours for the year. Squamish Co. has decided to allocated overheads on the basis of machine hours. At the end of June, Squamish Co. used 7,000 machine hours for manufacturing road bikes, 15,000 machine hours for manufacturing mountain bikes and 13,000 hours for manufacturing hybrid bikes. Squamish Co. estimates the following activities to be of importance and notes the Total Costs 2,500,000 estimated number of units: Activity Base Amount Purchase 450,000 pieces Materials Machine Setups 70.000 set ups Inspections 7.000 inspection hours Aunning 40,000 hours Machines TOEN Overhead 1.000.000 700,000 800,000 5,000,000 Hybrid Bike Road Bike 40 60 Mountain Bike 120 50 40 158 30 70 5.200 800 70 100 4.800 300 8 190 4,500 200 Information Opening Inventory Produced Inventory Ending Inventory Sold Inventory Sales Price Direct Materials per bike Direct Labour hours Direct Labour costs Purchase Materials pieces) Machine Setups set up Inspections hours Running Machines hour) 10 8 4 20 15 15 3.000 2.000 1.000 5,000 2.500 3.000 3,000 5.000 4.000 4,000 1.000 3,000 Part A: Given the following information prepare a schedule that calculates the full cost of the road bike using activity base costing