z answer all parts of question.its urgent,i am stuck ,i need your help ,plz do excel work and show with its working and formulas ,thanks alot

Question 1 - Total Marks 40 You are a newly qualified management accountant recently appointed by JMP Limited. JMP is a long- a established manufacturing company. The company manufactures and sells three products, Product 1. Product 2 & Product 3. Product 3 has been attracting additional business with overheads increasing however Product 2 has been losing market share. JMP have approached you with a view to introducing a new costing system. Since its creation JMP have been using a single direct labour cost percentage to assign overhead costs to products A team lead by the senior management accountant have spent several weeks collecting data for the different activities and products. For the accounting period 31st December 2020, the following data relates to the three product lines for JMP. Product 1 7,600 48.00 19.00 4.20 Product 2 12,600 81.00 25.50 8.10 Product 3 4,100 70.00 16.75 6.50 Production Volumes Selling Price per unit Material Cost per unit Direct Labour Cost per unit Additional Information Materials Movements Machine Hours per unit Set-ups (in total) Orders packed (in total) Proportion of Engineering work 50 8 0.6 2 0.6 10 14 25% 100 0.3 10 22 40% 2 35% Cost Pools Packaging Engineering Set-up Labour Machine Maintenance & Depreciation Materials Receiving & Handling Total Overhead Cost 60,000 110,000 19,650 400,000 155,000 744,650 (a) Calculate the overhead rate and the product unit costs for each product under the existing costing system. (8 Marks) (b) Identify the appropriate cost driver for each overhead activity, calculate the overhead absorption rate for each cost pool. (15 Marks) (c) Calculate the product unit costs for each product using an activity based costing system. (6 Marks) (d) Comment on the results of each costing system in particular the profits for each product. (11 Marks)