Q23E

Question

Question: Treat Dog Collars uses activity-based costing. Treat’s system has the following features:

___________________________________________________________________

Activity Allocation BasePredetermined

Overhead Allocation Rate

Purchasing Number of purchase orders \( 60.00 per purchase order

Assembling Number of parts 0.36 per part

Packaging Number of finished collars 0.19 per collar

___________________________________________________________________

Each collar has three parts, direct materials cost is \)5.00 per collar, and direct laborcost is \(4.00 per collar. Suppose Animal Hut has asked for a bid on 30,000 dog collars.Treat will issue a total of 175 purchase orders if Animal Hut accepts Treat’s bid.

Requirements

1. Compute the total estimated cost Treat will incur to purchase the needed materialsand then assemble and package 30,000 dog collars. Also compute the cost percollar.

2. For bidding, Treat adds a 40% markup to total cost. What total price will the companybid for the entire Animal Hut order?

3. Suppose that instead of an ABC system, Treat has a traditional product costingsystem that allocates indirect costs at the rate of \)9.50 per direct labor hour. Thedog collar order will require 9,000 direct labor hours. What total price will Treat bidusing this system’s total cost?

4. Use your answers to Requirements 2 and 3 to explain how ABC can help Treatmake a better decision about the bid price it will offer Animal Hut.

Step-by-Step Solution

Verified

Answer

Total estimated cost under ABC:$308,160

Total estimated cost under traditional method:$355,500

Bidding price under ABC:$431,424

Bidding price under traditional method:$497,700

1Step-by-Step-Solution Step1: 1) Computation of total estimated cost and per-unit cost

No. of dog collars: 30,000

No. of purchase orders: 1 (one purchase order has 30,000 collars)

$P u r c h a s i n g c o s t = P r e d e t e r m i n e d o v e r e d a l l o c a t i o n r a t e \times N o . o f p u r h c a a e o r d e r s = $ 60 \times 1 = $ 60 A s s e m b l i n g c o s t = P r e d e t e r m i n e d o v e r e d a l l o c a t i o n r a t e \times N o . o f p a r t s = $ 0.36 \times (3 \times 30, 000) = $ 0.36 \times 90, 000 = $ 32, 400 P a c k a g i n g c o s t = P r e d e t e r m i n e d o v e r e d a l l o c a t i o n r a t e \times N o . o f f i n i s h e d c o l l a r s = $ 0.19 \times 30, 000 = $ 5, 700 D i r e c t M a t e r i a l c o s t = P e r u n i t c o s t \times N o . o f c o l l a r s = $ 5 \times 30, 000 = $ 150, 000 D i r e c t L a b o r c o s t = P e r u n i t c o s t \times N o . o f c o l l a r s = $ 4 \times 30, 000 = $ 120, 000 T o t a l e s t i m a t e d c o s t = D i r e c t m a t e r i a l c o s t + D i r e c t l a b o r c o s t + T o t a l m a n u f a c t u r i n g c o s t = $ 150, 000 + $ 120, 000 + ($ 60 + $ 32, 400 + $ 5, 700) = $ 270, 000 + $ 38, 160 = $ 308, 160$ uncaught exception: Invalid chunk

in file: /var/www/html/integration/lib/com/wiris/plugin/impl/HttpImpl.class.php line 68
#0 /var/www/html/integration/lib/php/Boot.class.php(769): com_wiris_plugin_impl_HttpImpl_1(Object(com_wiris_plugin_impl_HttpImpl), NULL, 'http://www.wiri...', 'Invalid chunk') #1 /var/www/html/integration/lib/haxe/Http.class.php(532): _hx_lambda->execute('Invalid chunk') #2 /var/www/html/integration/lib/php/Boot.class.php(769): haxe_Http_5(true, Object(com_wiris_plugin_impl_HttpImpl), Object(com_wiris_plugin_impl_HttpImpl), Array, Object(haxe_io_BytesOutput), true, 'Invalid chunk') #3 /var/www/html/integration/lib/com/wiris/plugin/impl/HttpImpl.class.php(30): _hx_lambda->execute('Invalid chunk') #4 /var/www/html/integration/lib/haxe/Http.class.php(444): com_wiris_plugin_impl_HttpImpl->onError('Invalid chunk') #5 /var/www/html/integration/lib/haxe/Http.class.php(458): haxe_Http->customRequest(true, Object(haxe_io_BytesOutput), Object(sys_net_Socket), NULL) #6 /var/www/html/integration/lib/com/wiris/plugin/impl/HttpImpl.class.php(43): haxe_Http->request(true) #7 /var/www/html/integration/lib/com/wiris/plugin/impl/RenderImpl.class.php(268): com_wiris_plugin_impl_HttpImpl->request(true) #8 /var/www/html/integration/lib/com/wiris/plugin/impl/RenderImpl.class.php(307): com_wiris_plugin_impl_RenderImpl->showImage('9b45cdd2562d224...', NULL, Object(PhpParamsProvider)) #9 /var/www/html/integration/createimage.php(17): com_wiris_plugin_impl_RenderImpl->createImage(' $" width="0" height="0" style="max-width: none;" > P u r c h a s i n g c o s t = P r e d e t e r m i n e d o v e r e d a l l o c a t i o n r a t e \times N o . o f p u r h c a a e o r d e r s = $ 60 \times 1 = $ 60 A s s e m b l i n g c o s t = P r e d e t e r m i n e d o v e r e d a l l o c a t i o n r a t e \times N o . o f p a r t s = $ 0.36 \times (3 \times 30, 000) = $ 0.36 \times 90, 000 = $ 32, 400 P a c k a g i n g c o s t = P r e d e t e r m i n e d o v e r e d a l l o c a t i o n r a t e \times N o . o f f i n i s h e d c o l l a r s = $ 0.19 \times 30, 000 = $ 5, 700 D i r e c t M a t e r i a l c o s t = P e r u n i t c o s t \times N o . o f c o l l a r s = $ 5 \times 30, 000 = $ 150, 000 D i r e c t L a b o r c o s t = P e r u n i t c o s t \times N o . o f c o l l a r s = $ 4 \times 30, 000 = $ 120, 000 T o t a l e s t i m a t e d c o s t = D i r e c t m a t e r i a l c o s t + D i r e c t l a b o r c o s t + T o t a l m a n u f a c t u r i n g c o s t = $ 150, 000 + $ 120, 000 + ($ 60 + $ 32, 400 + $ 5, 700) = $ 270, 000 + $ 38, 160 = $ 308, 160 P e r u n i t c o s t = \frac{T o t a l C o s t}{N o . o f c o l l a r s} = \frac{$ 308, 160}{30, 000} = $ 10.27 uncaught exception:$ Invalid chunk

in file: /var/www/html/integration/lib/com/wiris/plugin/impl/HttpImpl.class.php line 68
#0 /var/www/html/integration/lib/php/Boot.class.php(769): com_wiris_plugin_impl_HttpImpl_1(Object(com_wiris_plugin_impl_HttpImpl), NULL, 'http://www.wiri...', 'Invalid chunk') #1 /var/www/html/integration/lib/haxe/Http.class.php(532): _hx_lambda->execute('Invalid chunk') #2 /var/www/html/integration/lib/php/Boot.class.php(769): haxe_Http_5(true, Object(com_wiris_plugin_impl_HttpImpl), Object(com_wiris_plugin_impl_HttpImpl), Array, Object(haxe_io_BytesOutput), true, 'Invalid chunk') #3 /var/www/html/integration/lib/com/wiris/plugin/impl/HttpImpl.class.php(30): _hx_lambda->execute('Invalid chunk') #4 /var/www/html/integration/lib/haxe/Http.class.php(444): com_wiris_plugin_impl_HttpImpl->onError('Invalid chunk') #5 /var/www/html/integration/lib/haxe/Http.class.php(458): haxe_Http->customRequest(true, Object(haxe_io_BytesOutput), Object(sys_net_Socket), NULL) #6 /var/www/html/integration/lib/com/wiris/plugin/impl/HttpImpl.class.php(43): haxe_Http->request(true) #7 /var/www/html/integration/lib/com/wiris/plugin/impl/RenderImpl.class.php(268): com_wiris_plugin_impl_HttpImpl->request(true) #8 /var/www/html/integration/lib/com/wiris/plugin/impl/RenderImpl.class.php(307): com_wiris_plugin_impl_RenderImpl->showImage('05578823bf4acf7...', NULL, Object(PhpParamsProvider)) #9 /var/www/html/integration/createimage.php(17): com_wiris_plugin_impl_RenderImpl->createImage(' $" width="0" height="0" style="max-width: none;" > P u r c h a s i n g c o s t = P r e d e t e r m i n e d o v e r e d a l l o c a t i o n r a t e \times N o . o f p u r h c a a e o r d e r s = $ 60 \times 1 = $ 60 A s s e m b l i n g c o s t = P r e d e t e r m i n e d o v e r e d a l l o c a t i o n r a t e \times N o . o f p a r t s = $ 0.36 \times (3 \times 30, 000) = $ 0.36 \times 90, 000 = $ 32, 400$

$P a c k a g i n g c o s t = P r e d e t e r m i n e d o v e r e d a l l o c a t i o n r a t e \times N o . o f f i n i s h e d c o l l a r s = $ 0.19 \times 30, 000 = $ 5, 700$

$D i r e c t M a t e r i a l c o s t = P e r u n i t c o s t \times N o . o f c o l l a r s = $ 5 \times 30, 000 = $ 150, 000$

$D i r e c t L a b o r c o s t = P e r u n i t c o s t \times N o . o f c o l l a r s = $ 4 \times 30, 000 = $ 120, 000$

$T o t a l e s t i m a t e d c o s t = D i r e c t m a t e r i a l c o s t + D i r e c t l a b o r c o s t + T o t a l m a n u f a c t u r i n g c o s t = $ 150, 000 + $ 120, 000 + ($ 60 + $ 32, 400 + $ 5, 700) = $ 270, 000 + $ 38, 160 = $ 308, 160$

$P e r u n i t c o s t = \frac{T o t a l C o s t}{N o . o f c o l l a r s} = \frac{$ 308, 160}{30, 000} = $ 10.27$

2Step 2: 2) Price for bidding

$B i d d i n g P r i c e = T o t a l c o s t \times 100 + M a r k u p p e r c e n t = $ 308, 160 \times (\frac{100 + 40}{100}) = $ 308, 160 \times 1.4 = $ 431, 424$

3Step 3: Bid price using traditional system

$T o t a l I n d i r e c t c o s t = N o . o f d i r e c t l a b o r h o u r p e r o r d e r \times P e r h o u r d i r e c t l a b o u r r a t e = 9, 000 \times $ 9.50 = $ 85, 500$

$T o t a l e s t i m a t e d c o s t = D i r e c t m a t e r i a l c o s t + D i r e c t l a b o r c o s t + T o t a l m a n u f a c t u r i n g c o s t = $ 150, 000 + $ 120, 000 + $ 85, 500 = $ 355, 500$

$B i d d i n g P r i c e = D i r e c t m a t e r i a l c o s t + D i r e c t l a b o r c o s t + T o t a l m a n u f a c t u r i n g c o s t = $ 150, 000 + $ 120, 000 + $ 85, 500 = $ 355, 500$

$B i d d i n g P r i c e = T o t a l c o s t \times 100 + M a r k u p p e r c e n t = $ 355, 500 \times (\frac{100 + 40}{100}) = $ 355, 500 \times 1.4 = $ 497, 700$

4Step 4: Comparison of bidding price under two methods

Under activity-based costing, the indirect cost is allocated based on the proportion of different activities. This makes the cost allocation fair and no cost is over-allocated to any product or job. On the contrary, in the traditional method, some cost is over-allocated due to the uniform base of allocation.

In the given case, direct material cost and direct labor cost are the same in both cases. But the indirect cost is over-allocated in the traditional method. This has made the bidding price costly and the offer may be rejected. But the activity-based costing has allocated the cost very appropriately and the bidding price is lower in this case.

So, this method would provide a better offer to Animal Hut

Q9-26E

Q24E

Other exercises in this chapter

19-22E

Refer to Exercises E19-20 and E19-21. Controller Michael Bender is surprised by the increase in cost of the deluxe model under ABC. Market research shows that f

View solution

Q9-26E

Measuring and recording goodwill Princeton has acquired several other companies. Assume that Princeton purchased Kelleher for \(9,000,000 cash. The book value o

View solution

Q24E

Question: Western, Inc. is a technology consulting firm focused on Web site development and integration of Internet business applications. The president of

View solution

Q25E

Question: Refer to Exercise E19-24. The president of Western suspects that her allocation of indirect costs could be giving misleading results, so she deci

View solution