Lusaka Pic Lusaka Pic is a large Lusaka Stock Exchange listed company. The company is a manufacturing company that produces a wide range of cosmetics products for both male customers and female customers. These cosmetic products include perfumes, body and hand lotions and hair creams. The cosmetic products are produced from the same type of aromati olis diluted alcohol, fragrances and petroleum jelly where applicable The perfumes are produced using aromatics oils and diluted alcohol and they are packed in 100 mitres (mi) bottes. Each 100 ml bottle of the male version of the perfume produced by mixing 90 ml of aromatics with 10 ml of diluted alcohol. On the other hand, each 100 ml bottle of the female version of the perfume is produced by ming 80 ml of aromatic oils with 15 ml of diluted alcohol and 5 ml of fragrances. Direct labour time required to produce a 100 ml bottle of each of the two versions of perfumes ls 30 minutes Body and hand lotions are produced from aromatic ols and fragrances and they are packed in 500 ml bottles. Each 500 ml bottle of lotions is produced by mixing 400 ml of aromatic oils with 100 ml of fragrances. Direct labour time required to produce a 500 ml bottle of the body and hand lotions is 15 minutes Hair creams are produced by mixing petroleum Jelly and fragrances. They are packed in 500 ml bottles. Each 500 ml bottle of the hair creams is produced by mixing 400 ml of petroleum lelly and 100 ml of fragrances. Direct labour required to produce a 500 ml bottle of the hair cream is 15 minutes Aromatic oils are purchased by the company at a price of K2.000 per tre whle diluted alcohol is purchased at a price of K3,500 per litre. Fragrances are purchased at a price of K1,800 per tre and petroleum Jelly is purchased at a price of K1,000 per litre. Labour is paid for at the rate of K250.00 per direct labour hour. Lusaka Pic operates three production departments and two service departments as cost centres. Production of the cosmetic products is undertaken in the production cost centres The service cost centres provide services to the three production cost centres. The perfumes are produced in production cost centre Pi while the body and hand lotions are produced in production cost centre P2 with the hair creams are produced in production cost centre P3. Lusaka Pic used a system of traditional absorption costing for the purposes of costing its products and reporting profits to management. At the end of each year, there are no inventores of finished cosmetic products to carry forward to the following year. Similarly, there are no Inventories of raw materials or work in progress carried forward from one year to another The following budgeted Information for the year ended 30 June 2019 was prepared during the last budget period and was approved on 15 June 2018 Budgeted production volumes: Product Volume Male version of the perfume 300 000 bres Female version of the perfume 450.000 tres Body and hand lotions 200.000 tres Petroleum jelly 150,000 tres Budgeted production overhead costs Production Cost Centre Service Cost Centres P1 P2 51 52 Alocated overheads Apportioned overheads 29,800.000 60.705.000 91,500,000 22,500,000 23,000,000 32.450.000 31,400,000 41.200.000 8.750.000 5,890,000 Production Cost Centres Service Cost Centres P3 $1 S2 P1 P2 Basis of re-apportionment 91 30% 45% 20% 25% 25% NIA 20% NIA The following actual results were reported for the year ended 30 June 2019: Product Volume Produced Direct labour hours Male version of the perfume 320,000 tres 81.000 hours Female version of the perfume 420.000 litres 106,000 hours Body and hand lotions 210.000 litres 104.000 hours Hair creams 140,000 litres 68.500 hours Actual production overheads for the year ended 30 June 2019 for each of the three production cost centres, after re-apportionment of the service cost centre overheads were as follows: Production department Actual overheads 65.136,600 98.900.000 143.250,000 Production overheads are absorbed in each of the three production cost centres at a predetermined overhead absorption rate based on direct labour hours. However, the production director has argued that actual overhead absorption rates should be used instead. He has also stated these actual overhead absorption rates should be company-wide overead absorption rates instead of being departmental overhead absorption rates Lusaka Pic distributes its products to wholesalers throughout Zambia and there is sufficient prot being generated by the company in this way. As a result, there are no intentions to change the policy on how the products reach the customers. There is, however some considerable competition as most of the cosmetic products on the Zambian martet are mported. Lusaka Pic needs to remain in the business and maintain its profitability Senior management in Lusaka Pic now need to assess the performance of each of the cost centres based on the Information relating to the ancial year ended 30 June 2019 For This purpose, both budgeted Information and actual Information are provided above Management w the need to review the company's operations based on the rest of the performance of the company. Each of the companys departmental cost accountants will need to be informed about their main roles in the organization as all of them have recenty been recruited from the University Required: (a) Re-apportion the overheads of the service cost centres S1 and 52 and calculate the predetermined direct labour hour overhead absorption rates to 2 decimal places [15 Marks] (D) Calculate the amount of over absorbed or under absorbed overheads in each of the production cost centres P1, P2 and P3 and Identify and explain TWO (2) causes of over or under absorption of production overheads. [15 Marks] NOTE: Up to 9 marks are available for calculations in part (1) c) Explain TWO (2) reasons why Lusaka Pie preters predetermined overhead absorption rates to overhead absorption rates based on the actual results. TG Marko] (d) Explain TWO (2) reasons why Lusaka Pic prefers departmental overhead absorption rates to company-wide overhead absorption rates [Markaj (e) Calculate the actual production cost for each of the following: 100 ml bottle of the male version of the perfume [ Marka] () 100 ml bottle of the female versions of the perfume [ Marks] (ill) 500 ml bottle of the body and hand lotion [ Marks] (V) 500 ml bottle of the hair cream to Marks) in Calculate the following ratios for each of the production cost centres and comment on the performance of each cost centre in the year ended 30 June 2019 Labour efficiency ratio [5 Marks] Labour capacity utilisation ratio Is Marks (W) Production volume ratio 15 Marks] NOTE: Up to 9 marks and are available for calculations in part 1 g) As Management Accountant for Lusaka Pic, prepare a memorandum to the departments cost accountants explaining why Information is important in Lusaka Pic and also explaining the qualties of useful information [15 Marka Marks for presentation and structure of the memorandum [4 Marks] (TOTAL: 100 MARKS] Lusaka Pic Lusaka Pic is a large Lusaka Stock Exchange listed company. The company is a manufacturing company that produces a wide range of cosmetics products for both male customers and female customers. These cosmetic products include perfumes, body and hand lotions and hair creams. The cosmetic products are produced from the same type of aromati olis diluted alcohol, fragrances and petroleum jelly where applicable The perfumes are produced using aromatics oils and diluted alcohol and they are packed in 100 mitres (mi) bottes. Each 100 ml bottle of the male version of the perfume produced by mixing 90 ml of aromatics with 10 ml of diluted alcohol. On the other hand, each 100 ml bottle of the female version of the perfume is produced by ming 80 ml of aromatic oils with 15 ml of diluted alcohol and 5 ml of fragrances. Direct labour time required to produce a 100 ml bottle of each of the two versions of perfumes ls 30 minutes Body and hand lotions are produced from aromatic ols and fragrances and they are packed in 500 ml bottles. Each 500 ml bottle of lotions is produced by mixing 400 ml of aromatic oils with 100 ml of fragrances. Direct labour time required to produce a 500 ml bottle of the body and hand lotions is 15 minutes Hair creams are produced by mixing petroleum Jelly and fragrances. They are packed in 500 ml bottles. Each 500 ml bottle of the hair creams is produced by mixing 400 ml of petroleum lelly and 100 ml of fragrances. Direct labour required to produce a 500 ml bottle of the hair cream is 15 minutes Aromatic oils are purchased by the company at a price of K2.000 per tre whle diluted alcohol is purchased at a price of K3,500 per litre. Fragrances are purchased at a price of K1,800 per tre and petroleum Jelly is purchased at a price of K1,000 per litre. Labour is paid for at the rate of K250.00 per direct labour hour. Lusaka Pic operates three production departments and two service departments as cost centres. Production of the cosmetic products is undertaken in the production cost centres The service cost centres provide services to the three production cost centres. The perfumes are produced in production cost centre Pi while the body and hand lotions are produced in production cost centre P2 with the hair creams are produced in production cost centre P3. Lusaka Pic used a system of traditional absorption costing for the purposes of costing its products and reporting profits to management. At the end of each year, there are no inventores of finished cosmetic products to carry forward to the following year. Similarly, there are no Inventories of raw materials or work in progress carried forward from one year to another The following budgeted Information for the year ended 30 June 2019 was prepared during the last budget period and was approved on 15 June 2018 Budgeted production volumes: Product Volume Male version of the perfume 300 000 bres Female version of the perfume 450.000 tres Body and hand lotions 200.000 tres Petroleum jelly 150,000 tres Budgeted production overhead costs Production Cost Centre Service Cost Centres P1 P2 51 52 Alocated overheads Apportioned overheads 29,800.000 60.705.000 91,500,000 22,500,000 23,000,000 32.450.000 31,400,000 41.200.000 8.750.000 5,890,000 Production Cost Centres Service Cost Centres P3 $1 S2 P1 P2 Basis of re-apportionment 91 30% 45% 20% 25% 25% NIA 20% NIA The following actual results were reported for the year ended 30 June 2019: Product Volume Produced Direct labour hours Male version of the perfume 320,000 tres 81.000 hours Female version of the perfume 420.000 litres 106,000 hours Body and hand lotions 210.000 litres 104.000 hours Hair creams 140,000 litres 68.500 hours Actual production overheads for the year ended 30 June 2019 for each of the three production cost centres, after re-apportionment of the service cost centre overheads were as follows: Production department Actual overheads 65.136,600 98.900.000 143.250,000 Production overheads are absorbed in each of the three production cost centres at a predetermined overhead absorption rate based on direct labour hours. However, the production director has argued that actual overhead absorption rates should be used instead. He has also stated these actual overhead absorption rates should be company-wide overead absorption rates instead of being departmental overhead absorption rates Lusaka Pic distributes its products to wholesalers throughout Zambia and there is sufficient prot being generated by the company in this way. As a result, there are no intentions to change the policy on how the products reach the customers. There is, however some considerable competition as most of the cosmetic products on the Zambian martet are mported. Lusaka Pic needs to remain in the business and maintain its profitability Senior management in Lusaka Pic now need to assess the performance of each of the cost centres based on the Information relating to the ancial year ended 30 June 2019 For This purpose, both budgeted Information and actual Information are provided above Management w the need to review the company's operations based on the rest of the performance of the company. Each of the companys departmental cost accountants will need to be informed about their main roles in the organization as all of them have recenty been recruited from the University Required: (a) Re-apportion the overheads of the service cost centres S1 and 52 and calculate the predetermined direct labour hour overhead absorption rates to 2 decimal places [15 Marks] (D) Calculate the amount of over absorbed or under absorbed overheads in each of the production cost centres P1, P2 and P3 and Identify and explain TWO (2) causes of over or under absorption of production overheads. [15 Marks] NOTE: Up to 9 marks are available for calculations in part (1) c) Explain TWO (2) reasons why Lusaka Pie preters predetermined overhead absorption rates to overhead absorption rates based on the actual results. TG Marko] (d) Explain TWO (2) reasons why Lusaka Pic prefers departmental overhead absorption rates to company-wide overhead absorption rates [Markaj (e) Calculate the actual production cost for each of the following: 100 ml bottle of the male version of the perfume [ Marka] () 100 ml bottle of the female versions of the perfume [ Marks] (ill) 500 ml bottle of the body and hand lotion [ Marks] (V) 500 ml bottle of the hair cream to Marks) in Calculate the following ratios for each of the production cost centres and comment on the performance of each cost centre in the year ended 30 June 2019 Labour efficiency ratio [5 Marks] Labour capacity utilisation ratio Is Marks (W) Production volume ratio 15 Marks] NOTE: Up to 9 marks and are available for calculations in part 1 g) As Management Accountant for Lusaka Pic, prepare a memorandum to the departments cost accountants explaining why Information is important in Lusaka Pic and also explaining the qualties of useful information [15 Marka Marks for presentation and structure of the memorandum [4 Marks] (TOTAL: 100 MARKS]