Question

Sky Plasties: 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 companys three plastic water containers. He had been thinking of how to increase the while facing the international competition for plastic water containers. Usually, Sami time to review companys performance reports. Since profits were being made, Sami believed that companys exports did not spend a lot of accounting to was the responsibility of the financial director and his staff, In recent months, however, Sami has started pay much attention to the financial and management of the companys 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. 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 companys 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 Companys head office and factory are located in Jebel Ali, the major business district in Dubai. Fadi Sultan, the current chairmans 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 The company enjoys an international reputation as a producer of high quality plastic pipes. While the companys turnover is over U$ 10 million in 2003, its major export market is Russia. The company also produces plastic pipes for several famous brand names in Europe. At the end of 2003, Fadi Sultan retired from his chairman position and his son Sami Sultan became the chairman. Sami started working as the director of marketing following his graduation from business school in 1997. He was studying the expansion of the companys export product lines and was looking for growth opportunities. After considerable market research, the 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 using market-based systems. Sami knew that the marketing department has been studying the prices of similar products available in the marketplace. The accounting department used that information in setting the prices of companys products Sami, however, decided to follow a managerial approach different from his fathers approach. He believes that senior managers should be involved in every aspect of the companys operations including operational and management control. Sami knows that the company is profitable, but he is interested in knowing abo the profitability of each individual product line. Particularly, he wants to know about the cost information of the companys plastic water containers line, as he was not sure whether the prices set by the accounting epartment were correct
Two days ago, Sami met the financial director, Mr. Hany Sameer to find out the price-setting procedures for the water containers line. Hany joined the company in May 2006 after a long employment as accountant in one of the pioneering plastic manufacturers in Dubai. He was popular for refining the accounting system at the previous plastic company. Sami thought Hany would be cost accounting system at Sky Plastics and shared with him his concerns water containers product line. Sami is searching for ways to improve the export market water containers. He thinks share. The prices of the three products are as follows: the chief cost ideal for restructuring the about the pricing strategy of plastic share of these plastic that reducing the price of these products may lead to an increase in the market Product A Product IB Product C Sales price $ 50.00 S 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 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 vide 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 inform Sami that he was surprised to know that the companys pricing strategy is based on market prices. Hany tol Sami he wanted to use Activity-Based Costing (ABC) system as thus would provide better and more accurat cost information than the direct-labor-based costing system. ed Table 1: SKY PLASTICS Calculation of Product Costs: Direct-Labor-Based Costing System | Product B | Product C Product A Number of direct labor hours Single plan-wide factory overhead rate 40,000 20,000 140,000 Total factory overhead $ 320,000 s 160,000 S 1,120,000 Number of units Overhead cost per unit Direct labor cost per unit Direct materials cost per unit 25,000 S 12.80 20.00 5,000 S32.00 32.00 | 21.50 $ 22.40 22.00 17.00 $ 61.40 Total cost per unit $59 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 requested Hany to prepare a detailed cot analysis of the companys entire product line but first he wanted to know the cost information for the plastio 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. Finally, he gave up hoped that Hany would come up with a good solution. and
Hany requested Sari Sunnar, the assistant accountant, to prepare an analysis of activities and their relevant cost for plastic water containers. Sari spent a coup companys records and prepared a schedule showing the activity-base usage quantities and units each of the three products (Table 2). He also prepared a schedule of the annual overhead costs for the plastic Mater containers CTable 3) and a schedule of four major activities and their costs for the Production Support e of days in collecting relevant data from produced for Department (Table 4). Table 2 ACTIVITY DATA BY PRODUCT Products MachineOrders Number of Direct Labor Machine Production Hours 30 15 200 250 Product A Product B Prodact C Total 25,000 5,000 40 20 40 20,000 40.000 Table 3 FACTORY OVERHEAD COSTS FOR PLASTIC WATER CONTAINERS Department Factory Overhead $1, 200, 000 Production Support Production (factory overhead only) Total cost Table 4 PRODUCTION SUPPORT DEPARTMENT COSTS Production Support Activities Setup Production 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, Im 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 containens 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 the ABC system. He thought that Hany would be a real asset to the company. Sami tried to calculate the cost for each product using the cost schedules given by Hany but found it complicated and time consuming. He is finding it difficult to wait to hear about the ABC analysis from Hany Questions Imagine 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. ao poindeusineg infenini is ndkwng that e olowing activities consum support department resources: 1. Machine Setup 2. Production Control 3. Quality Control 4. Materials Management 5. Production Overhead costs and given the following activity drivers (cost drivers) for each of the above activity area, determi 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 Materials management Production Overhead costs Cost Driver Setups Production orders Inspections Requisitions Direct labor hours 3. 4. 5. (10 points) Calculate the product cost for each product using the Activity Based costing methoo (10 points) What you conclude about the ABC versus costing based on direct labour hours only (5 points) What changes do you advise management make to Sky Plastics pricing strategy?
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Overhead recaver ralte b number dvect lakes haurt 16,C0.CO 2cacoo (abor heurs 2. akutalken of farclayj Overtoad Cest per urit for Prodad tunu A, Ba ne thod RoductA PRoduet & Reduct C 9 Nlumber of divect abeur 40,a 40,uo,ocb A6,000 heuw (gven) b) Overheae vecavery al t 3 2 5000 22.40 e) tac 12.SU Punit Id3. Cal calahan 여 Acti-Based Cothnd Recovery votes : Cot Dnver Cost prol ce) CA) Nambenす machine atua のMachine $4;oooo (oot 40

Particulars Product A Product B Product C

a. Product cost per unit under single

plant wise overhead method (given) $ 59.30 $ 85.50 $ 61.40

b.  Product cost per unit under Activity

Based Costing Method (As above) $ 77.60 $ 134.50 $ 47.35

CONCLUSION: It has been observed that the product cost for Product A and B is lower under Single overhead rate method and is higher for Product C. Activity Based Costing (ABC) Method shows an accurate allocation of overhead cost based on the cost driver assigned to each overhead. Therefore, the cost of Product A and B should be increased by $18.30 ($ 77.60 - $ 59.30) and $ 49 ($ 134.50 - $ 85.50). Similarly, the cost of product C should be decreased by $14.05 ($ 47.35 - $ 61.40).

Therefore, the management should implement Activity Based Costing (ABC) Method for better allocation of Factory Overhead Costs.

Add a comment
Know the answer?
Add Answer to:
Sky Plasties: Activity-Based Costing System Case Study Mr. Sami Sultan, Chairman of Sky Plastics, was studying...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • Sultan Company uses an activity-based costing system.         At the beginning of the year, the company made...

    Sultan Company uses an activity-based costing system.         At the beginning of the year, the company made the following estimates of cost and activity for its five activity cost pools: Sultan Company uses an activity-based costing system. At the beginning of the year, the company made the following estimates of cost and activity for Its five activity cost pools: Activity Measure Expected Overhead Expected Activity DLHS Activity Cost Pool Cost 135,600 24 Labor-related Direct labor-hours 22,600 $ 8,400 $ 68,870 240...

  • Sultan Company uses an activity-based costing system. At the beginning of the year, the company made...

    Sultan Company uses an activity-based costing system. At the beginning of the year, the company made the following estimates of cost and activity for its five activity cost pools: Activity Cost Pool Labor-related Purchase orders Parts management Board etching General factory Activity Measure Direct labor-hours Number of orders Number of part types Number of boards Machine-hours Expected Overhead Cost $ 231,600 $ 15,015 $ 95,200 $ 106,800 $ 184,500 Expected Activity 38,600 DLHS 231 orders 112 part types 1,780 boards...

  • Thank you Sultan Company uses an activity-based costing system. At the beginning of the year, the...

    Thank you Sultan Company uses an activity-based costing system. At the beginning of the year, the company made the following estimates of cost and activity for its five activity cost pools: Activity Cost Pool Labor related Purchase orders Parts management Board etching General factory Activity Measure Direct labor-hours Number of orders Number of part types Number of boards Machine-hours Expected Overhead Cost $ 184,800 $ 6,909 $ 81,120 $ 45,000 $ 150, 300 Expected Activity 30,800 DLHS 230 orders 194...

  • Sultan Company uses an activity based costing system. At the beginning of the year, the company...

    Sultan Company uses an activity based costing system. At the beginning of the year, the company made the following estimates of cost and activity for its five activity cost pools: 3 Activity Cost Pool Labor-related Purchase orders Parts management Board etching General factory Activity Measure Direct labor-hours Number of orders Number of part types Number of boards Machine-hours Expected Overhead Cost $ 269,100 $ 11,000 $ 78,440 $ 85,950 $ 242,400 Expected Activity 29,900 DLHS 220 orders 106 part types...

  • Sultan Company uses an activity-based costing system. At the beginning of the year, the company made...

    Sultan Company uses an activity-based costing system. At the beginning of the year, the company made the following estimates of cost and activity for its five activity cost pools: 8 01:59:26 Activity Cost Pool Labor-related Purchase orders Parts management Board etching General factory Activity Measure Direct labor-hours Number of orders Number of part types Number of boards Machine-hours Expected Overhead Cost $ 241,500 $ 6,060 $ 90,300 $ 69,600 $ 193,000 Expected Activity 34,500 DLHS 202 orders 105 part types...

  • Sultan Company uses an activity-based costing system. At the beginning of the year, the company made...

    Sultan Company uses an activity-based costing system. At the beginning of the year, the company made the following estimates of cost and activity for its five activity cost pools: Activity Cost Pool Activity Measure Expected Overhead Cost Expected Activity Labor-related Direct labor-hours $ 241,500 34,500 DLHs Purchase orders Number of orders $ 6,060 202 orders Parts management Number of part types $ 90,300 105 part types Board etching Number of boards $ 69,600 1,740 boards General factory Machine-hours $ 193,000...

  • Sultan Company uses an activity-based costing system. At the beginning of the year, the company made...

    Sultan Company uses an activity-based costing system. At the beginning of the year, the company made the following estimates of cost and activity for its five activity cost pools: Activity Cost Pool Labor-related Purchase orders Parts management Board etching General factory Activity Measure Direct labor-hours Number of orders Number of part types Number of boards Machine-hours Expected Overhead Cost $ 156,000 $ 11,000 $ 80,000 $ 90,000 $ 180,000 Expected Activity 26,000 DLHS 220 orders 100 part types 2,000 boards...

  • Sultan Company uses an activity-based costing system. At the beginning of the year, the company made...

    Sultan Company uses an activity-based costing system. At the beginning of the year, the company made the following estimates of cost and activity for its five activity cost pools: Activity Cost Pool Labor-related Purchase orders Parts management Board etching General factory Activity Measure Direct labor-hours Number of orders Number of part types Number of boards Machine-hours Expected Overhead Cost $ 284.000 $ 6,790 $ 71,340 $ 57,900 $ 229,900 Expected Activity 35,500 DLHS 194 orders 82 part types 1.930 boards...

  • Sultan Company uses an activity-based costing system. At the beginning of the year, the company made...

    Sultan Company uses an activity-based costing system. At the beginning of the year, the company made the following estimates of cost and activity for its five activity cost pools: Activity Cost Pool Labor-related Purchase orders Parts management Board etching Ceneral factory Activity Measure Direct labor-hours Number of orders Number of part types Number of boards Machine-hours Expected Overhead Cost $ 269,100 $ 11,000 $78,440 $ 85,050 $ 242,400 Expected Activity 29,900 DLHS 220 orders 106 part types 1,890 boards 20,...

  • Sultan Company uses an activity-based costing system. At the beginning of the year, the company made...

    Sultan Company uses an activity-based costing system. At the beginning of the year, the company made the following estimates of cost and activity for its five activity cost pools: Activity Cost Pool Activity Measure Expected Overhead Cost Expected Activity Labor-related Direct labor-hours $ 174,000 34,800 DLHs Purchase orders Number of orders $ 7,200 240 orders Parts management Number of part types $ 66,500 95 part types Board etching Number of boards $ 64,800 1,620 boards General factory Machine-hours $ 115,200...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT