Management Accounting - It would be highly appreciated if someone could aid me in approaching this problem.
A) Income statement based on current allocatio system i.e., allocation of overhead cost using direct labour cost
TUTU LTD Income Statement(in $ Millions)
Year Ebnded December 31, 2016
Particulars | TA-01 | HB-02 | ET-03 | Toatal |
Sales | $880 | $495 | $262 | $1,637 |
Material Cost | ($200) | ($120) | ($40) | ($360) |
Labour Cost | ($54) | ($26) | ($10) | ($90) |
Overhead | ($658.8) | ($317.2) | ($122) | ($1,098) |
Net Income | ($32.8) | $31.8 | $90 | $89 |
Working for overheads allocation:
TA-01 = [$1,098/(54+26+10)]*54 = $658.8
HB-02 = [$1,098/(54+26+10)]*26 = $317.2
ET-03 = [$1,098/(54+26+10)]*10 = $122
B) Activity Based Costing Approcah
TUTU LTD Income Statement(in $ Millions)
Year Ebnded December 31, 2016
Activity Based Costing Approach |
Particulars | TA-01 | HB-02 | ET-03 | Toatal |
Sales | $880 | $495 | $262 | $1,637 |
Material Cost | ($200) | ($120) | ($40) | ($360) |
Direct Labour | ($54) | ($26) | ($10) | ($90) |
Overhead | ($315.51) | ($349.71) | ($432.78) | ($1,098) |
Net Income | $310.49 | ($0.71) | ($220.78) | $89 |
Allocation of overhead cost based on Activity Based Costing
Particulars | TA-01 | HB-02 | ET-03 | Total |
Labour Cost | 189 | 91 | 35 | 315 |
Machine Related | 69.21 | 86.51 | 21.27 | 272 |
Production order | 10.5 | 42 | 31.5 | 84 |
First Part Inspection | 18 | 72 | 54 | 144 |
Inventory Management | 12 | 33 | 60 | 105 |
Receiving and Shipping | 4.8 | 13.2 | 24 | 42 |
General Adinistration | 12 | 12 | 12 | 36 |
Toatal | 315.51 | 349.71 | 432.78 | 1098 |
Labour cost
TA-01 = [$315/(54+26+10)]*54 = 189
HB-02 = [$315/(54+26+10)]*26 = 91
ET-03 = [$315/(54+26+10)]*10 = 35
Machine Related
TA-01 = [$372/(0.16+0.2+0.5)]*0.16 = 69.21
HB-02 = [$372/(0.16+0.2+0.5)]*0.2 = 86.51
ET-03 = [$372/(0.16+0.2+0.5)]*0.5 = 216.27
Production order:
TA-01 = [$84/(5+20+15)]*5 = 10.5
HB-02 = [$84/(5+20+15)]*20 = 42
ET-03 = [$84/(5+20+15)]*15 = 31.5
First part Inspection:
TA-01 = [$144/(5+20+15)]*5 = 18
HB-02 = [$144/(5+20+15)]*20 = 72
ET-03 = [$144/(5+20+15)]*15 = 54
Inventory Management:
TA-01 = [$105/(40+110+200)]*40 = 12
HB-02 = [$105/(40+110+200)]*110 = 33
ET-03 = [$105/(40+110+200)]*200 = 60
Receiving and Shipping:
TA-01 = [$42/(40+110+200)]*40 = 4.8
HB-02 = [$42/(40+110+200)]*110 = 13.2
ET-03 = [$42/(40+110+200)]*200 = 24
C) Evaluation of Profitability of 3 Products:
TUTU Managements observations that product ET-03 is more profutable is wrong. Based on activity based costing approach product TA-01 is more profitable. Activity based costing approch is more accurate because they provie a more precise breakdown of indirect costs.
Therefore mangements decision with respect to product Et-03 is ore profitable is incorrect because traditioal method of costing does not provide accurate allocation of indirect costs.
D)Recommendations:
1.Management should concentarte on TA -01 procuct than ET-03 & HB-02 to maximise their profit
2. Reduction in price of TA-01 by 5% will surely increase the sales of TA-01
3. Production of ET-03 should be reduced so that the higher indirect cost incurred through Activity based costing approch can be avoided.
4. HB-02 is under breakeven point i.e., no loss or no profit situation. Management has to reduce its production too
Management Accounting - It would be highly appreciated if someone could aid me in approaching this...
Can someone solve all three points for me? Question 2 The management of Vegetarian Meals Ltd, who make three main product lines of ready-made vegetarian meals in batches for the restaurant trade, are reviewing the cost accounting policy in relation to overheads. Currently the company absorbs overheads on the basis of direct labour hours. Some of the management board feel that the company should switch to activity-based costing (ABC), as the product lines make different demands on the company's overhead...
Exercise 17-03 al-a2, b1-b2 EcoFabrics has budgeted overhead costs of $1,096,200. It has allocated overhead on a plantwide basis to its two products (wool and cotton) using direct labor hours which are estimated to be 522,000 for the current year. The company has decided to experiment with activity-based costing and has created two activity cost pools and related activity cost drivers. These two cost pools are cutting (cost driver is machine hours) and design (cost driver is number of setups)....
Exercise 17-03 al-a2, bl-b2 EcoFabrics has budgeted overhead costs of $973,350. It has allocated overhead on a plantwide basis to its two products (wool and cotton) using direct la bor hours which are estimated to be 463,500 for the current year. The company has decided to experiment with activity-based costing and has created two activity cost pools and related activity cost drivers. These two cost pools are cutting (cost driver is machine hours) and design (cost driver is number of...
also, Calculate the overhead rates using the traditional approach. Overhead Rates using the traditional approach is. ______$___________ per direct labor hour What amount of overhead would be allocated to the wool and cotton product lines using the traditional approach, assuming direct labor hours were incurred evenly between the wool and cotton? Overhead Allocated. for Wool Product Line is =____$_____ Overhead Allocated. for Cotton Product Line is =____$______ EcoFabrics has budgeted overhead costs of $1,105,650. It has allocated overhead on...
ULL FULL SON PRINTER VERSION BACK NEXT Exercise 17-03 a1-a2, b1-b2 Eco Fabrics has budgeted overhead costs of $1,134,000. It has allocated overhead on a plantwide basis tots two products (wool and cotton) using direct labor hours which are estimated to be 540,000 for the current year. The company has decided to experiment with activity-based costing and has created two activity cost pools and related activity cost drivers. These two cost pools are cutting (cost driver is machine hours) and...
EcoFabrics has budgeted overhead costs of $954,450. It has allocated overhead on a plantwide basis to its two products (wool and cotton) using direct labor hours which are estimated to be 454,500 for the current year. The company has decided to experiment with activity-based costing and has created two activity cost pools and related activity cost drivers. These two cost pools are cutting (cost driver is machine hours) and design (cost driver is number of setups). Overhead allocated to the...
please solve in excel/table format if possible. thank you. (traditional UUSUJ - Upelating MCMC (ULUNUI CUL). (UU U U U UIJ.) (d) Provide a rationale as to why the costs for Product 540X are approximately the same using either the traditional or activity-based costing system. E17-3 EcoFabrics has budgeted overhead costs of $945,000. It has allocated overhead on a plantwide basis to its two products (wool and cotton) using direct labor hours which are estimated to be 450,000 for the...
Management Accounting I'd be grateful if someone could show how to approach this management accounting problem. Thanks in advance. Gold Nest Company of Hong Kong is a family-owned enterprise that makes souvenirs for the tourist market. The company sells through an extensive network of trading companies that receive commissions on their sales. Transactions occur in Hong Kong dollars ($). The company uses a job-order costing system in which overhead is applied to jobs on the basis of direct labour cost....
EcoFabrics has budgeted overhead costs of $1,115,100. It has allocated overhead on a plantwide basis to its two products (wool and cotton) using direct labor hours which are estimated to be 531,000 for the current year. The company has decided to experiment with activity-based costing and has created two activity cost pools and related activity cost drivers. These two cost pools are cutting (cost driver is machine hours) and design (cost driver is number of setups). Overhead allocated to the...
EcoFabrics has budgeted overhead costs of $1,152,900. It has allocated overhead on a plantwide basis to its two products (wool and cotton) using direct labor hours which are estimated to be 549,000 for the current year. The company has decided to experiment with activity-based costing and has created two activity cost pools and related activity cost drivers. These two cost pools are cutting (cost driver is machine hours) and design (cost driver is number of setups). Overhead allocated to the...