Question

In: Accounting

Calculating ABC Unit Costs Community Credit Union has collected the following information for four activities and...

Calculating ABC Unit Costs

Community Credit Union has collected the following information for four activities and two types of credit cards:

Activity Driver Classic Gold Activity Rate
Processing transactions Transactions processed 20,000 12,000 $0.20
Preparing statements Number of statements 20,000 12,000 0.85
Answering questions Number of calls 40,000 60,000 2.00
Providing ATMs ATM transactions 80,000 24,000 1.80

There are 12,500 holders of Silver cards and 50,000 holders of Premium cards.

Required:

Calculate the unit cost (rounded to the nearest cent) for Silver and Premium credit cards.

Unit cost for Silver $
Unit cost for Premium $

Solutions

Expert Solution

Total cost
Driver Classic Gold Activity Rate Classic Gold
Transactions processed 20,000 12,000 0.20 $         4,000 $         2,400
Number of statements 20,000 12,000 0.85 $       17,000 $       10,200
Number of calls 40,000 60,000 2.00 $       80,000 $   1,20,000
ATM transactions 80,000 24,000 1.80 $   1,44,000 $       43,200
Total cost for the cards $   2,45,000 $   1,75,800
Number of cards $       12,500 $       50,000
Unit cost $         19.60 $           3.52
Unit costs for the two cards are $19.60 and $3.52.
PLEASE NOTE THAT THE NAMES OF THE CARDS IN COLUMN 4 & 5 OF THE TABLE ARE GIVEN
AS CLASSIC AND GOLD; BUT MENTIONED AS SILVER AND PLATINUM THEREAFTER.
PLEASE USE NAMES APPROPRIATELY IN THE ANSWER, AFTER CHECKING WHICH IS CORRECT.

Related Solutions

Question #1 Perkins National Bank has collected the following information for four activities and two types...
Question #1 Perkins National Bank has collected the following information for four activities and two types of credit cards: Activity Driver Classic Gold Activity Rate ($) Processing transactions Transactions processed 12,000 7,200 0.20 Preparing statements Number of statements 12,000 7,200 0.95 Answering questions Number of calls 24,000 36,000 4.00 Providing ATMs ATM transactions 48,000 14,400 1.50 There are 4,900 holders of Classic cards and 19,600 holders of the Gold cards. Required: Calculate the unit cost (rounded to the nearest cent)...
1. The Soft Toys Company has collected information on fixed andvariable costs for four potential...
1. The Soft Toys Company has collected information on fixed and variable costs for four potential plant locations.LocationAnnual Fixed CostUnit Variable CostABCD$200,000$300,000$400,000$600,000$70$65$45$40a. Plot the total cost curves for the four plant locations on a single graph (Use Excel or hand-drawing).Hint: You can start with different Q (output quantity) such as 0, 5000, 10000, 15000, etc. and record responding total costs of each location. Accordingly, you can draw a line of each location on Excel worksheet (hand-drawing is fine) while X-axis...
Figure 4-10 The Manoli Company has collected the following data for use in calculating product costs:...
Figure 4-10 The Manoli Company has collected the following data for use in calculating product costs: Activity Data: (expected and actual) rug cleaners     sweepers         total units produced                                    100,000             250,000           350,000 prime costs                                          $200,000         $584,000         $784,000 direct labor hours                                10,000                40,000              50,000 machine hours                                     20,000                10,000              30,000 number of setups                                 25                              75                   100 inspection hours                                  1,600   2,400 4,000 number of moves                                140   160 300 Departmental Data: (expected and actual) molding           assembly         total direct labor hours rug cleaners   5,000 5,000               10,000 sweepers                          5,000   35,000               40,000 total                                 10,000   40,000               50,000 machine hours rug cleaners 17,000 3,000               20,000 sweepers                       3,000 7,000               10,000 total                                   20,000   10,000               30,000 overhead costs machining                      $130,000    $ 40,000...
a company provides the following abc costing information: activities total costs activity cost drivers labor 384000...
a company provides the following abc costing information: activities total costs activity cost drivers labor 384000 8000 hours gas 36000 6000 gallons invoices 180000 total costs 600000 the above activities used by their three departments are : department 1 department 2 department 3 labor 2500 hours 1400 hours 4100 hours gas 1800 gallons 1000 gallons 3200 gallons invoices 1300 invoices 300 invoices 5900 invoices how much of invoice cost will be assigned to department 2?
Allentown Credit Union (ACU) is located in a rural community in Canada. Membership is open to...
Allentown Credit Union (ACU) is located in a rural community in Canada. Membership is open to people in the community and the surrounding area. The local economy, which is predominantly agricultural, has been harmed by droughts in recent years and by declines in commodity prices, leading to a decline in ACU’s profitability. ACU has always had an external audit and has always prepared its financial statements in accordance with International Financial Reporting Standards. Ellino & Co. has audited ACU for...
P17-1A Assign overhead using traditional costing and ABC; compute unit costs; classify activities as value- or...
P17-1A Assign overhead using traditional costing and ABC; compute unit costs; classify activities as value- or non-value-added Combat Fire, Inc. manufactures steel cylinders and nozzles for two models of fire extinguishers: (1) a home fire extinguisher and (2) a commercial fire extinguisher. The home model is a high-volume (54,000 units), half-gallon cylinder that holds 2 1/2 pounds of multi-purpose dry chemical at 480 PSI. The commercial model is a low-volume (10,200 units), two-gallon cylinder that holds 10 pounds of multi-purpose...
Equally Accurate Reduced ABC System Silven Company has identified the following overhead activities, costs, and activity...
Equally Accurate Reduced ABC System Silven Company has identified the following overhead activities, costs, and activity drivers for the coming year: Activity Expected Cost Activity Driver Activity Capacity Setting up equipment $126,000 Number of setups 150 Ordering materials 18,000 Number of orders 900 Machining 126,000 Machine hours 10,500 Receiving 30,000 Receiving hours 1,250 Silven produces two models of cell phones with the following expected activity demands: Model X Model Y Units completed 5,000 10,000 Number of setups 100 50 Number...
1) Extreme Manufacturing Company provides the following ABC costing​ information: Activities Total Costs Activity−cost drivers Account...
1) 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: Department A Department B Account inquiry hours ​2,200 hours ​3,700 hours Account billing lines ​600,000 lines ​450,000 lines Account verification accounts ​5,000 accounts ​3,000 accounts Correspondence letters ​1,000 letters...
From the following information on costs of production of the ABC corporation, calculate
From the following information on costs of production of the ABC corporation, calculate a) Total Fixed Cost (TFC), Total Varibale Cost (TVC), Average Fixed Cost (AFC), Average Variable Cost (AVC), Average Total Cost (ATC), and Marginal Cost (MC).Quantity ProducedTotal CostTotal Fixed Cost (TFC)Total Variable Cost (TVC)Average Fixed Cost (AFC)Average Variable Cost (AVC)Average Total Cost (ATC)Marginal Cost (MC)0$120$120----1135$135214974.5316254417443.5518837.6620434722432824730.9927530.5Graph the average fixed cost (AFC), average variable cost (AVC), average total cost ATC), and the marginal cost (MC) curves on one graph and...
Happy Valley Land and Snow Company provides the following ABC costing information: Activities                          &nbsp
Happy Valley Land and Snow Company provides the following ABC costing information: Activities                             Total Costs         Activity-cost drivers Labor hours                          $420,000                     8,000 hours Gas                                       $136,000                     6,000 gallons Invoices                                $140,000                     2,500 invoices    Total costs                         $696,000 The above activities used by their three departments are: Lawn Department   Bush Department   Plowing Department Labor hours 2,500 hours          1,200 hours                 4,300 hours Gas 1,500 gallons           800 gallons 3,700 gallons Invoices 1,600 invoices         400 invoices 500 invoices a) How much of the total costs will be assigned to the Lawn Department? $...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT