Please help with my advance cost and Management accounting assignment

QUESTION1 (30 marks Home Appliance Limited which specializes in the production of kitchen appliances uses an Activity Based Costing system. The accountants of the company have identified the following three (3) activities and related cost drivers for manufacturing overhead costs. Activity Procurement Engineering Energy Cost Driver Number of Materials moves Engineering change notices Kilowatt hours Three (3) types of blenders are produced: B5, B6 and B7. The following information concerns each product for the month of June 2019: Direct materials cost Direct labour cost Materials moves Direct labour hours Kilowatt hours Engineering change notice Units produced and sold B5 $450,000 $234,000 500 500 10,000 48 1200 B6 $600,000 $186,000 400 200 4,000 36 800 B7 $1050,000 $168,000 300 400 3000 24 400 Overhead manufacturing costs for the month were: Procurement Engineering Energy Total overhead costs $240,000 $300,000 $552,000 $1,092,000 Required: a. Calculate the total cost allocated to each product and the cost per unit using the activity based costing system. (16 marks) b. Assuming that the company used the traditional system (overhead absorption) and used a labour hour rate; determine the total cost allocated to each product and the cost per unit (8 marks) a. Briefly explain the four (4) steps involved in setting up an Activity Based Costing system (6 marks) 2 2/5 QUESTION 2 [30 marks) PART A Montego Producers Limited (MPL) manufactures product PT10 which requires 3 hours of labour time. Labour is the bottle resource for the company. The factory operates five days per week and 50 weeks annually. The company sells each unit of this product for $580 and the product uses direct material costing $190 per unit. The average labour hour rate is $15 per hour and employees work 8 hours per day. There are 100 employees. The company employs and activity based costing system in its production process. The budgeted overheads are as follow: Inspection costs Material handling Machining costs $10,000,000 $6,000,000 $4,000,000 The budgeted activity levels and the drivers were also analyzed below: Number of inspections 400,000 Material moves 600,000 Machining Hours 2,000,000 The data below relating to the period is provided by the production department: Number of inspections 260,000 Material moves 150,000 Machining Hours 750,000 Required: a. Calculate the return per factory hour (2 marks) b. Calculate the cost per factory hour (4 marks) c. Calculate the TPAR (2 marks) d. Based on the TPAR calculated, what decision should management make? (2 marks) PART B Hanover Producers Limited manufactures three products, Rip, Rap and Rep. For the quarter ending 31 March 2019 information regarding the products is as follows: DETAILS PRODUCTS RAP Revenue per unit Direct Labour per unit Direct Material per unit Total Market Demand Machine hours per unit RIP $ 400.00 $ 100.00 $ 40.00 15,000 0.50 $360.00 $ 160.00 $ 60.00 12,000 0.25 REP $ 320.00 $ 120.00 $ 70.00 10,000 0.40 There are 13,000 machine hours available during the quarter. Annual fixed costs are estimated at $6,240,000. You may assume that fixed cost accrues evenly through the year Required: a. Calculate the optimal product mix for the quarter b. Calculate the optimal profit for the quarter. c. Explain, giving two (2) examples, what is a limiting factor (10 marks) (6 marks) (4 marks) 3 QUESTION 3 36 marks] PART A Hanover Construction Limited (HCL) is considering whether to accept a one-off contract. The customer is offering a price of $11,600,000. It has been established that total cost will include, direct material, direct labour, direct expenses and suitable overheads. HCL's policy is to apply a mark-up of 40% to all contracts. The following information is relevant to the special contract: 1. The contract requires 12,000 kilogram of a material: a special imported cement. Currently the company has 2,000 kilograms in stock from a previous contract. The cement cost $60 per kilogram when it was bought six months ago. The current special cement can be used in the contract but because of the length of time in storage it would need a new additive at an additional cost of $10 per gallon. The stock of special cement as is, can be sold on the market for $45 per gallon, however, management decided to use the cement in the contract. The current purchase price per kilogram of the special cement is $120. Additionally, the contract also requires 90 gallons of paint. The current price per gallon is $2,800, but 30 gallons are currently in the storeroom. The paints were bought last year at $1700 per kilogram. Management was offered $1400 per kilogram for each of the 30 gallons, but a decision was made to utilise it in this contract. In order to be sold, each gallon of paint in storage would require a new label at cost of $5 per gallon. Management decided to use the 30 gallons of paint in storage on the contract 2. Skilled workers are required. It was advised that 4,000 hours are required at $450 per hour. These workers will be employed specifically for this contract. Unskilled workers are currently paid a rate of $350 per hour. The entity employed 40 unskilled workers to work 7 hours per day for four days per week. The contract is expected to last eight weeks. However, they are currently employed by the company where they are earning a contribution for the company at $25 per hour. 3. The entity has fixed cost of $8,750,000 that is to be charged to the contract. Further analysis indicated that 50% of the fixed cost will continue whether or not the contract is accepted. 4. Finally, the contract requires 900 square feet of space. The space is currently producing 6,000 units of a product that can be sold for $700 each, total cost per unit is $500 (fixed cost per unit is 30% of total cost per unit. Management decided to use the space for the contract. Required: With the aid of computations and based on financial considerations only, advise the management of HCL whether the contract should be accepted (20 marks) QUESTION 3(continued) PART B Clarendon Producers Limited uses an activity base costing system to assess the profitability of its customers. The budgeted overhead for the period is analysed below: Sales order cost $48,000,000 Delivery cost $24,000,000 Special return cost $18,000,000 Below are the cost drivers and the budgeted cost driver levels for the budgeted cost highlighted above: Number of sales order 200,000 Number of deliveries 30,000 Number of special returns 20,000 For the period three customers were analysed and the actual information was produced by the marketing manager: Number of sales order Number of deliveries Number of special returns Contribution margin Angela Wong 570 150 143 $240,000 Garth Moore 390 275 45 $395,000 Mary Johnson 980 165 20 $460,000 Required: a. Prepare a customer profitability report using an ABC approach and rank the customers based on the profitability report (10 marks) b. Comment on the findings of the profitability analysis. What should the company do as a result of these findings? (6 marks)