Question 5. (16 marks) Heade Antoine Griezmann Inc. makes soccer balls for the UEFA Championship League. The following data is for the June to November. June July August Direct Labor Hours 50,000 65,000 62,000 57,000 39,000 30,000 Manufacturing Overhead $345,000 $370,000 $373,000 $297,250 $228,200 $212,500 September October November Submission Instructions: 1. Use the high-low method to estimate the cost formula 2. Estimate the total overhead cost at an activity level of 42,000 machine hours, using the separate estimates you obtained for its components. Tot Predictions: On 20C Total Overhead 5,000,000 Road Bike Mountain Bike Hybrid Bike 40 40 60 120 50 158 30 70 8 70 100 5,200 800 4,800 300 190 4,500 200 . 4 10 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 ups) Inspections (hours) Running Machines (hours) 8 15 20 15 1,000 3,000 2,000 2,500 3,000 5,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. Header