use excel or digital calculations. put answers on top pls

QUESTION THURON LTD HURON Ltd makes shoes in two renges such es Besic and Super Information relating to each of these products le set out below: Basic Super Selling price per unit 2180 9250 Material Cost per unit 220 280 Labout time per unit 4 Labour rate per hour 215 215 Number of Units Produced tech Year 2.000 5,000 Cost Drivers Number of Quality Inspections so 550 Number of Sales invoices sued each year 20 180 Number of batches per total production 10 40 Machine Hours total eco 5.400 The Director of Huron Ltches produced the following analysis of total overheads per year and their relevant cost drivers Cost Pool Cost Drivers 140,000 Number of Quality Inspections Inspection Se es invoicing Number of Sales involces issued each 80,000 year Material Mending Other Overheads Number of batches per total production 60,000 120,000 Mechine Hours total 400,000 Required Calculete full cost per unit and profit per unit for each product using - Trectional cost method of overheed ebsorption besed on direct lebour hours (15 marks) - Activity-based costine ABC) method (20 marks) (Total: 35 marks)