Hi, please help :)

QUESTION 2 [25 marks Daniel has recently been appointed as the managerial accountant for Akmal Pharmaceutical Bhd. Upon checking the costing system used by the company, Daniel noticed that the company uses traditional costing system. Daniel believes that activity-based costing (ABC) and cost-volume- profit analysis (CVP) are better costing methods and decides to present the ABC and CVP methods to the management. The information of the three products produced by the company is as follows: Products DA SI LA 150,000 90,000 325.00 120,000 450.00 200.00 275.00 80.00 100.00 Sales and production (units) Selling price / unit (RM) Direct materials (RM) Direct labour (RM) ) Assembly department (machine hour per unit) Quality control department (labour hour per unit) 40.00 100.00 80.00 7 4 6 1 1.5 2 Fixed overhead allocated to the production departments is RM2,000,000 each year. Daniel opines that the overhead could be further analysed into the following activities and cost drivers: Department Activity Estimated overhead (RM) Cost drivers Expected use of cost drivers 600,000 4,000 Pre-treatment Product fabrica- tion Assembly 1,000,000 200,000 Post-treatment 230,000 Number of treat- ments Machine hours Number of ser- vices Number of in- spections Number of boxes 15,000 90,000 10,000 Quality assess- ment Final Packaging Quality Control 80,000 3,000 2,000,000 Page 4 of 5 AFMB114 Special Semester, 2020/2021 Activities Expected Activities DA SI 1,400 1,600 40,000 100,000 LA 1,000 Pre Treatment Fabrication Process 60,000 3,000 7,000 5,000 Post Treatment Packaging & Optical test Final Packaging 3,000 4,000 1,500 3,000 1,000 500 Required: (a) If the company plans to adopt a single plant-wide overhead absorption rate, determine the best allocation base AND calculate the overhead absorption rate. [2 marks] (b) Compute the product cost per unit for each product using the overhead absorption rate in (a). [3 marks] (c) Compute the product cost per unit for each product if the company adopts the ABC method. [13 marks) (d) Using your answers in (c), compute the minimum unit that needs to be produced to achieve a profit for each product based on the CVP analysis. [4 marks] (e) Based on your answers in (c), determine which product the company should produce AND justify your answer. [3 marks] -END OF QUESTION PAPER- AFMB114 - Class examples - Excel Home Insert Page Layout Formulas Data Review View Tell me what you want to do... Cut Copy Format Painter Calibri - 11AA Wrap Text General BIU...A. Merge & Center. .% Insert Delete Format AutoSum - A Z Fill So Clear Fil Editing 0.00 Conditional Format as Cell Formatting Table Styles Styles 00 board Font Alignment Number Cells f Activity B D G H K L OAR 275.00 4.00 Overhead Cost driver 550,000 # of treatments 700,000 Labor hours 150,000 # of services 96,500 # of inspections 100,000 # of boxes Expected use 2,000 175,000 12,000 9,650 1,000 12.50 10.00 100.00 Activity Pre-treatment Fabrication Post-treatment Packaging Final packaging Total overhead (RM) Sales units Overhead per unit (RM) Add: Direct material per unit (RM) Add: Direct labour cost per unit (RM) Total production cost per unit (RM) R 700 192,500.CO 35,000 140,000.CO 2,000 25,000.CO 2,500 25,000.CO 150 15,000.CO 397,500.CO 50,000.00 M 600 165,000.00 85,000 340,000.00 6,000 75,000.00 3,650 36,500.00 550 55,000.00 671,500.00 +40,000.00 16.79 108.00 60.00 184.79 A 700 192,500.00 55,000 220,000.00 4,000 50,000.00 3,500 35,000.00 300 30,000.00 527,500.00 30,000.00 17.58 70.00 50.00 137.58 7.95 40.00 24.00 71.95 Selling price per unit (RM) Variable cost per unit (RM) Selling price minus variable cost BEP Units to be produced to earn to profit 129.00 64.00 65.00 6,115.38 6,116.00 229.00 168.00 61.00 11,008.20 11,009.00 189.00 120.00 69.00 7,644.93 7,645.00 Gross profit per unit (RM) 44.21 57.05 1.00 51.42 2.00 3.00 Sheet3 Sheets Sheet6 Sheet8 Sheet7 OSA P1 Q1 Average: 9932968519 Count: 45 Min: 4 Max 700000 Sum: 26819015