A service company, SUPER CLEAN, provides commercial and residential cleaning services. The company is currently using...

  

Transcribed Image Text:

A service company, SUPER CLEAN, provides commercial and residential cleaning services. The company is currently using a job costing system. Overhead are allocated based on the direct labour hours. A. Traditional Costing with plant wide method: Using traditional costing the company calculated the overhead cost based on 15 000 hours of activity: Activity cost pools Receptionist Office supplies Estimated cost $ 25,000 $ 3,000 $ 32,500 $ 37,500 $ 98,000 Gas Depreciation Total Required - Part A: 1. Calculate the overhead rate using the plant wide method (one rate). 2. Calculate the overhead rate using the departmental method for residential and commercial. Provide your responses on the spreadsheet titled Required 1 and 2'. B. Activity Based Costing: SUPER CLEAN realises that the traditional method of allocating overhead is not accurate because the gas and depreciation do not vary with direct labour. The company wants to use the activity-based-costing system to allocate the costs of the receptionist, office supplies, gas and car usage (depreciation) to get more accurate cost estimates. This information will help management to give more accurate quotes and improve the company's profitability. Break-down of costs between commercial and residential cleanings. Commercial Activity cost pools Cost driver (allocation based) $ 13,000 Direct labour hour Estimated cost Total Quantity of Unit allocation based 9,000 hour 9,000 | hour Receptionist Office supplies $ 1,500 | Direct labour hour $ 13,000 KM $ 15,000 KM $ 42,500 110,000 KM 110,000 KM Gas Depreciation Total Residential Estimated cost Cost driver (allocation Total Quantity of allocation based Activity cost pools Receptionist Office supplies Unit based) $ 12,000 Direct labour hour $ 1,500 Direct labour hour $ 19,500 KM $ 22,500 KM 6,000 hour 6,000 hour 140,000 KM 140,000 KM Gas Depreciation Total $ 55,500 The direct labour is $22/hour and the cleaning supplies (direct material) cost is $6.00 per liter. The cleaning supplies are 0.25 liter per labour hour for commercial cleaning and 0.15 liter per labour hour for residential cleaning. During the week, SUPER CLEAN worked on two jobs. Job 1 (residential) 125 hours 0.15 liter per direct labour hour 0.25 liter per direct labour hour 1,700 KM Job 2 (commercial) 200 hours Direct labour Direct material 1200КМ KM Required - Part B: 3. Calculate the overhead rates for each activity cost pool for commercial and residential cleanings. Provide your response on the spreadsheet titled 'Required 3'. 4. Estimate the total overhead costs and overhead cost per unit hour for each job. 5. Estimate the total costs (including direct labour and material) and total cost per unit for job 1 (residential) and job 2 (commercial). 6. Estimate total cost for Jobs 1 and 2 using traditional costing Provide your responses on the spreadsheet titled 'Required 4-5-6'. Required - Part C: 7. Write a memo to the CEO of SUPERCLEAN with your recommendation as to which of the two costing methods (Traditional or Activity Based Costing), they should adopt? Backup your recommendation by including the following discussion points: At least two advantages of Activity Based Costing At least two disadvantages of Activity Based Costing At least two challenges that can arise in implementing Activity Based Costing The memo should be no more than 250 words, 1.5 line spacing, Arial font and MS Word format. A service company, SUPER CLEAN, provides commercial and residential cleaning services. The company is currently using a job costing system. Overhead are allocated based on the direct labour hours. A. Traditional Costing with plant wide method: Using traditional costing the company calculated the overhead cost based on 15 000 hours of activity: Activity cost pools Receptionist Office supplies Estimated cost $ 25,000 $ 3,000 $ 32,500 $ 37,500 $ 98,000 Gas Depreciation Total Required - Part A: 1. Calculate the overhead rate using the plant wide method (one rate). 2. Calculate the overhead rate using the departmental method for residential and commercial. Provide your responses on the spreadsheet titled Required 1 and 2'. B. Activity Based Costing: SUPER CLEAN realises that the traditional method of allocating overhead is not accurate because the gas and depreciation do not vary with direct labour. The company wants to use the activity-based-costing system to allocate the costs of the receptionist, office supplies, gas and car usage (depreciation) to get more accurate cost estimates. This information will help management to give more accurate quotes and improve the company's profitability. Break-down of costs between commercial and residential cleanings. Commercial Activity cost pools Cost driver (allocation based) $ 13,000 Direct labour hour Estimated cost Total Quantity of Unit allocation based 9,000 hour 9,000 | hour Receptionist Office supplies $ 1,500 | Direct labour hour $ 13,000 KM $ 15,000 KM $ 42,500 110,000 KM 110,000 KM Gas Depreciation Total Residential Estimated cost Cost driver (allocation Total Quantity of allocation based Activity cost pools Receptionist Office supplies Unit based) $ 12,000 Direct labour hour $ 1,500 Direct labour hour $ 19,500 KM $ 22,500 KM 6,000 hour 6,000 hour 140,000 KM 140,000 KM Gas Depreciation Total $ 55,500 The direct labour is $22/hour and the cleaning supplies (direct material) cost is $6.00 per liter. The cleaning supplies are 0.25 liter per labour hour for commercial cleaning and 0.15 liter per labour hour for residential cleaning. During the week, SUPER CLEAN worked on two jobs. Job 1 (residential) 125 hours 0.15 liter per direct labour hour 0.25 liter per direct labour hour 1,700 KM Job 2 (commercial) 200 hours Direct labour Direct material 1200КМ KM Required - Part B: 3. Calculate the overhead rates for each activity cost pool for commercial and residential cleanings. Provide your response on the spreadsheet titled 'Required 3'. 4. Estimate the total overhead costs and overhead cost per unit hour for each job. 5. Estimate the total costs (including direct labour and material) and total cost per unit for job 1 (residential) and job 2 (commercial). 6. Estimate total cost for Jobs 1 and 2 using traditional costing Provide your responses on the spreadsheet titled 'Required 4-5-6'. Required - Part C: 7. Write a memo to the CEO of SUPERCLEAN with your recommendation as to which of the two costing methods (Traditional or Activity Based Costing), they should adopt? Backup your recommendation by including the following discussion points: At least two advantages of Activity Based Costing At least two disadvantages of Activity Based Costing At least two challenges that can arise in implementing Activity Based Costing The memo should be no more than 250 words, 1.5 line spacing, Arial font and MS Word format.