Sky Plastics: Activity-Based Costing System Case Study Mr. Sami Sultan, Chairman of Sky Plastics, was studying a schedule showing the product costs for each of the company' while facing the international competition for plastic water containers. Usually, Sami did not spend a lot of time to review company's performance reports. Since profits were being made, Sami believed that accounting was the responsibility of the financial director and his staff. In recent months, however, Sami has started to pay much attention to the financial and management of the company's products. This has been mainly due to his understanding that under the current business environment companies should pay much attention to the cost of products and services offered to their customers. s three plastic water containers. He had been thinking of how to increase the company's exports Recently, he had participated in several workshops on cost management in Dubai and knew that companies need to manage costs and focus on increasing efficiency and effectiveness in order to stay in market and grow its business. Sami learnt that senior managers must understand costs and revenues of company operations and should never rely on accountants only. With this understanding, Sami has been talking to the financial director about increasing the profitability of the company's product lines Background Sky Plastics was established in the 80s for the purpose of manufacturing high quality plastic pipes. The company is medium sized family business. The Company's head office and factory are located in Jebel Ali the major business district in Dubai. Fadi Sultan, the current chairman's father, founded the company. Fadi had worked as a university president for over 10 years and had wanted to start his own business. He started his business with a small amount of money which he saved from his previous work and over the years the company grew rapidly from a small factory to an export oriented business. The company specializes in the production of high quality plastic pipes. The company started producing plastic water containers early 2000. A separate manager heads each of these product lines under the direct supervision of the operations director. mpany enjoys an intenational reputation as a producer of high quality plastic pipes. While the ket is Russia. The company also retired company's turnover is over US 10 million in 2003, its major export mar produces plastic pipes for several famous brand names in Europe. At the end of 2003, Fadi Sultan from his chairman position of marketing following his graduation from business sc company's export product lines and was looking for growth opportunities. After considerable r and his son Sami Sultan became the chairman. Sami started working as the director hool in 1997. He was studying the expansion of the market research, he company started to produce and export three types of plastic water containers in March 2004. Cost Management at Sky Plastics The company has been setting its prices department has been studying the prices of similar products Sami knew that the marketing available in the marketplace. The accounting using market-based systems department used that information in setting the prices of company's products decided to follow a managerial approach different from his father's approach. He believes operational Sami, however, that senior managers should be involved in every aspect of the company's operations including and management control. Sami knows that the company the profitability of each individual product line. Particularly, he wants to know about the cost information of the company's plastic water containers line, as he was not sure whether the prices set by the accounting is profitable, but he is interested in knowing about department were correct. go, Sami met the financial director, Mr. Hany Sameer to find out the price-setting procedures for got iners' line. Hany joined the company in May 2006 after a long employment as the chief untant in one of the pioneering plastic manufacturers in Dubai. He was popular for refining the cost ing system at the previous plastic company. Sami thought Hany would be ideal for restructuring the accounting system at Sky Plastics and shared with him his concems about the pricing strategy of plastic containers' product line. Sami is searching for ways to improve the export market share of these plastic containers. He thinks that reducing the price of these products may lead to an increase in the market water c water share. The prices of the three products are as follows: Product A Product B Product C Sales price S 50.00 104.50 $90.50 Hany started to prepare an analysis of unit product costs for each of the three product lines, as he is sure such information will be useful in determining any adjustments in the product prices. Hany also revealed his intention about refining the existing cost accounting system. He told Sami that the company has been using a plantwide overhead rate system based on direct-labor-based costs, which is not very reliable in providing accurate information for making good decisions. Few days later, Hany met Sami and gave him a schedule showing his calculations of product costs for each product, under the existing system (Table 1) and informed Sami that he was surprised to know that the company's pricing strategy is based on market prices. Hany told Sami he wanted to use Activity-Based Costing (ABC) system as thus would provide better and more accurate cost information than the direct-labor-based costing system. Table 1: SKY PLASTICs Calculation of Product Costs: Direct-Labor-Based Costing System Product A Product B Product C 40,000 20,000 140,000 Number of direct labor hours Single plan-wide factory overhead rate $ 320,000 S 160,000 S 1,120,000 Total factory overhead 25,000 S 12.80 20.00 5,000 $ 32.00 32.00 21.50 50,000 $ 22.40 22.00 17.00 $ 6140 Number of units Overhead cost per unit Direct labor cost per unit Direct materials cost per unit Total cost per unit Sami was very annoyed by the results of the cost analysis as the company was selling Product A for $50 and it costs the company $59.30 to produce those products. Sami request analysis of the company's entire product line but first he wanted to know the cost information for the plastic water container product line. Sami was worried that other products might also have higher costs than their selling prices and decided to investigate the situation. He spent some time alone in his office thinking of how to solve this problem, which has been existing in the company over many years. hoped that Hany would come up with a good so ted Hany to prepare a detailed cost Finally, he gave up and Hany requested Sari Sunnar, the assistant accountant, to prepare an analysis of activities and their cost for plastic water containers. Sari spent a couple of days in collecting relevant data from records and prepared a schedule showing the activity-base usage quantities and units produced for coch of the three products (Table 2). He also prepared a schedule of the annual overhead costs for the plastic er containers (Table 3) and a schedule of four major activities and their costs for the Production Support water Department (Table 4). Table 2 ACTIVITY DATA BY PRODUCT Prodacts Number ofDirect Labor Machine Production Hours Requisition 25,000 5,000 50.000 100 40 100 30 15 Product A Product B Product C Total 20,000 250 20 200.000 Table 3 FACTORY OVERHEAD COSTS FOR PLASTIC WATER CONTAINERS Department Factory Overhead Production Support Production (factory overhead only) $1,200, 000 Total cost Table 4 PRODUCTION SUPPORT DEPARTMENT COSTS Production Support Activities Cost Setup Productiona control Quality control Materials management $400,000 300,000 300,000 Total cost Later on that day, Sami met with Hany to know the progress of the cost analysis. "Hany, I'm very upset that we are losing money from plastic water containers. Have you found any more useful information about their accurate product costs?" asked Sami. "I believe that over the coming 2 days we can find out the accurate product costs of water containers as we are already on the way to do an analysis of an Activity-Based Costing," replied Hany. "Activity Based Costing is a very accurate method of costing. Your company have allocated factory overhead based on a single plantwide rate method using direct labour hours. I recommend that the company allocates factory overhead using the actual usage rate of those facilities by each product," suggested Hany. He explained that ABC would produce more accurate costs of the three products than the labour-based costing would. Sami asked Hani, "Do you think that we can adopt ABC completely"? "In my previous work, we implemented an ABC system and within few months the company saved a huge amount of money. ABC is considered an important management advisory system and it helped us eliminate a large number of non value adding activities", replied Hani. Sami returned to his office with the schedules Hany had given to him. He wanted to know more about he ABC system. He thought that Hany would be a real asset to the company. Sami tried to calculate the cost or each product using the cost schedules given by Hany but found it complicated and time consuming. He is inding it difficult to wait to hear about the ABC analysis from Hany Questions magine that Sami has visited you and asked for your help. Following are the questions Sami had listed (5 points) Show how the factory overhead cost per unit for products A, B, and C under the single plantwide factory overhead method have been calculated in Table 1 1. 2. (20 points) Using information given in this case and knowing that the following activities consume support department resources: 1. 2. 3. 4. 5. Machine Setup Production Control Quality Control Materials Management Production Overhead costs and given the following activity drivers (cost drivers) for each of the above activity area, determine the factory overhead cost for products A, B, and C based on activity-based costing. ACTIVITY POOL Activity Area Machine Setup Production control Quality control Cost Driver Setups Production orders Inspections ials management Requisitions Production Overhead costs Direct labor hours 3. (10 pointsy) Calculate the product cost for each product using the Activity Based costing method 4. (10 points) What you conclude about the ABC versus costing based on direct labour hours only? 5. (5 points) What changes do you advise management make to Sky Plastics' pricing strategy