Luxed Construction Ltd (LCL) is a large service firm with two products in its product mix – SP General and SP Special. LCL’s 2018 books contain the following pieces of information (all budgeted data in the table below):
Activities Total Costs Applicable cost drivers
Clients Inquiries $201,000 8,900 Inquiry hours
Clients billing $239,500 871,500 bills
Clients credit check $124,900 63,000 accounts
Clients correspondence $ 31,900 13,500 letters
Total costs $597,300
The two products’ consume LCL’s resources (i.e. use the business ‘activities’) in the following manner to run their respective day to day business affairs (all actual data in the table below):
SP General SP Special
Clients Inquiries 2,900 hours 6,000 hours
Clients billing 271,500 bills 600,000 bills
Clients credit check 23,000 accounts 40,000 accounts
Clients correspondence 5,500 letters 8,000 letters
Brand managers for SP General and SP Specials are paid annual retainer of $129,000 and $141,000, respectively.
Required: Work out the following showing all necessary calculations/working out (round the final answers to the nearest dollar; round individual indirect cost rates to 2 decimal places):
TOTAL COST ASSIGNED TO SP GENERAL :
Clients inquiries = 201000*2900/8900
= 65494.38
Clients billing = 239500*271500/871500
= 74611.88
Clients credit check = 124900*23000/63000
= 45598.41
Clients correspondence = 31900*5500/13500
= 12996.30
Brand Manager's salary = 129000
Therefore, TOTAL COST = 65494.38 + 74611.88 + 45598.41 + 12996.30 + 129000
= $ 327700.97
TOTAL COST ASSIGNED TO SP SPECIAL :
Clients inquiries = 201000*6000/8900
= 135505.62
Clients billing = 239500*600000/871500
= 164888.12
Clients credit check = 124900*40000/63000
= 79301.59
Clients correspondence = 31900*8000/13500
= 18903.70
Brand Manager's salary = 141000
Therefore, TOTAL COST = 135505.62 + 164888.12 + 79301.59 + 18903.70 + 141000
= $ 539599.03
Total cost assigned to SP GENERAL = $ 327700.97
Total cost assigned to SP SPECIAL = $ 539599.03
Luxed Construction Ltd (LCL) is a large service firm with two products in its product mix...
Luxed Construction Ltd (LCL) is a large service firm with two products in its product mix – SP General and SP Special. Both products are allocated LCL’s head office’s Call Centre support costs on the basis of one cost allocation base – the Sales revenues. Currently, as a standard practice LLC allocates 0.75% of the sales revenue figure as the LCL’s head office’s Call Centre support cost to each of the two products. LCL’s head office’s Call Centre support costs...
Extreme Manufacturing Company provides the following ABC costing information: Activities Total Costs Activity-cost drivers Account inquiry $320,000 16,000 hours Account billing $200,000 4,000,000 lines Account verification accounts $173,250 70,000 accounts Correspondence letters $24,000 4,000 letters Total costs $717,250 The above activities are used by Departments A and B as follows: Department A Department B Account inquiry hours 2,700 hours ...
Extreme Manufacturing Company provides the following ABC costing information: Activities Total Costs Activity dash– cost drivers Account inquiry $420,000 14,000 hours Account billing $140,000 7,000,000 lines Account verification accounts $148,500 60,000 accounts Correspondence letters $32,500 5,000 letters Total costs $741,000 The above activities are used by Departments A and B as follows: A B Account inquiry hours 2,200 hours 3,700 hours Account billing lines 800,000 lines 650,000 lines Account verification accounts 7,000 accounts 5,000 accounts Correspondence letters 1,000 letters 1,400...
Premium Company provides the following ABC costing information: Activities Total Costs Activity-cost drivers Account inquiry $200,000 10,000 hours Account billing $140,000 4,000,000 lines Account verification accounts $75,000 40,000 accounts Correspondence letters $ 25,000 4,000 letters Total costs $440,000 The above activities are used by Departments A and B as follows: Department A Department B Account inquiry hours 2,500 hours 4,000 hours Account billing lines 400,000 lines 250,000 lines Account verification accounts 10,000 accounts 8,000 accounts Correspondence letters 1,200 letters 1,600 letters 1- How...
Extreme Manufacturing Company provides the following ABC costing information: Activities Total Costs Activity-cost drivers Account inquiry $320,000 16,000 hours Account billing $220,000 4,000,000 lines Account verification accounts $182,000 80,000 accounts Correspondence letters $25,000 4,000 letters Total costs $747,000 The above activities are used by Departments A and B as follows: Account inquiry hours Account billing lines Account verification accounts Correspondence letters Department A 2,200 hours 600,000 lines 5,000 accounts 1,000 letters Department B 3,700 hours 450,000 lines 3,000 accounts 1,400...
Extreme Manufacturing Company provides the following ABC costing information: Activities Account inquiry Account billing Account verification accounts Correspondence letters Total costs Total Costs $600,000 $125,000 $148,500 $27,000 $900,500 Activity. - cost drivers 15,000 hours 5,000,000 lines 60,000 accounts 4,000 letters The above activities are used by Departments A and B as follows: Account inquiry hours Account billing lines Account verification accounts Correspondence letters Department A 2,300 hours 700,000 lines 6,000 accounts 1,800 letters Department B 3,800 hours 550,000 lines 4,000...
Extreme Manufacturing Company provides the following ABC costing information: Activities Account inquiry Account billing Account verification accounts Correspondence letters Total costs Total Costs $320,000 $200,000 $175,250 S24.000 $717.250 Activity-cost drivers 16,000 hours 4,000,000 lines 70,000 accounts 4,000 letters The above activities are used by Departments A and B as follows: Account inquiry hours Account billing lines Account verification accounts Correspondence letters Department A 2,700 hours 900,000 lines 8,000 accounts 1,400 letters Department B 4,200 hours 750,000 lines 6,000 accounts 1,800...
Extreme Manufacturing Company provides the following ABC costing information: Activities Account inquiry Account billing Account verification accounts Correspondence letters Total costs Total Costs $320,000 $140,000 $118,750 $49,500 $628,250 Activity. - cost drivers 16,000 hours 4,000,000 lines 50,000 accounts 9,000 letters The above activities are used artments A and B as follows: Department A Account inquiry hours Department B 4,500 hours 3,000 hours O A. $124,000 OB. $131,300 OC. $158,500 O D. $138,750 Account billing lines Account verification accounts Correspondence letters...
Extreme Manufacturing Company provides the following ABC costing information: Activities Total Costs Activityminus−cost drivers Account inquiry $420,000 14,000 hours Account billing $220,000 4,000,000 lines Account verification accounts $173,250 70,000 accounts Correspondence letters $13,500 2,000 letters Total costs $826,750 The above activities are used by Departments A and B as follows: Department A Department B Account inquiry hours 2,700 hours 4,200 hours Account billing lines 700,000 lines 550,000 lines Account verification accounts 9,000 accounts 7,000 accounts Correspondence letters 1,000 letters 1,400...
Extreme Manufacturing Company provides the following ABC costing information: Activities Account inquiry Account billing Account verification accounts Correspondence letters Total costs Total Costs $240,000 $210,000 $158,000 $67,500 $675,500 Activity – cost drivers 12,000 hours 7,000,000 lines 80,000 accounts 9,000 letters The above activities are used by Departments A and B as follows: Department A 2,500 hours Department B 4,000 hours Account inquiry hours O A. $15,800 O B. $158,000 O C. $79,000 OD. $11,850 Account billing lines Account verification accounts...