Question

In: Accounting

Kindly solve the question Bartez Company makes products C and D. Information for overhead costs and...

Kindly solve the question

Bartez Company makes products C and D. Information for overhead costs and for the two products appears below. The company makes 50,000 units of product C each year and 20,000 units of product D.

Activity                      Driver Total Overhead Cost  Prod C Usage Prod D usage

Setups                               # of setups                           $200,000              500 setups                        1,500 setups

Ordering parts                  # of parts                             $300,000         60,000 parts                           40,000 parts

Machining                        MH $600,000 12,000 MH                              6,000 MH

Inspections                       # of Insp                              $400,000 10,000 Insp                            40,000 Insp

Shipping                  # of shipments    $300,000 10,000 Ship   10,000 Ship

Total overhead                    $1,800,000

* MH – Machine Hours                    Insp – Inspections                                         Ship - Shipments

Assume that activity based costing is used, with each activity in its own cost pool. What is the rate per setup that should be used to

Solutions

Expert Solution

Activity Driver Total Cost Product C Usage Product D usage Total usage of C & D
Setup No. Of setup $2,00,000 500 1500 2000
Ordering Part No. Of Part $3,00,000 60000 40000 100000
Machining Machine Hours $6,00,000 12000 6000 18000
Inspection No. Of inspection $4,00,000 10000 40000 50000
shipping No. Of Shipment $3,00,000 10000 10000 20000
Total $18,00,000
Units made For C= 50000 units for D= 20000 units
Bifurcation of cost as per activity based cost:
Activity Total Cost For C For D
Amount Working Amount Working
Setup $2,00,000 $50,000 $200000X 500 /2000 $150,000 $200000X 1500 /2000
Ordering Part $3,00,000 $180,000 $300000 X 60000 / 100000 $120,000 $300000 X 40000 / 100000
Machining $6,00,000 $4,00,000 $600000 X 12000/ 18000 $2,00,000 $600000 X 6000/ 18000
Inspection $4,00,000 $80,000 $400000 X 10000/ 50000 $3,20,000 $400000 X 40000/ 50000
shipping $3,00,000 $150,000 $300000 X 10000/20000 $150,000 $300000 X 10000/20000
$18,00,000 $8,60,000 $9,40,000
The per unit cost of C= Total cost of C/ no. Of units
The per unit cost of C= $8,60,000/ 50000
The per unit cost of C= $17.20
The per unit cost of D= Total cost of D / no. Of units
The per unit cost of D= $9,40,000/ 20000
The per unit cost of D= $47.00
Rate per setup that should be used is:
For C: Cost of setup for product C / no. Of units
$50,000/ 50000
$1.00
For D: Cost of setup for product D / no. Of units
$1,50,000/ 20000
$7.50

Related Solutions

Jung Company uses activity-based costing. It makes two products, X and Y. The company's overhead costs...
Jung Company uses activity-based costing. It makes two products, X and Y. The company's overhead costs are traced to two activity cost pools. The following data are given: Activity cost pool Activity measure Estimated Overhead Cost Activity For X For Y Total Design Number of parts $32,000 200 parts 800 parts 1,000 parts Inspection Production units $18,000 2,000 units 1,000 units 3,000 units For the design activity, its activity rate (predetermined overhead rate) is:
Glover Company makes three products in a single facility with the following information: A B C...
Glover Company makes three products in a single facility with the following information: A B C Selling Price per unit $85.00 $97.00 $91.00 Direct Materials 16.00 11.00 14.00 Direct Labor 19.00 17.00 20.00 Variable Manufacturing 3.0 2.5 4.0 Fixed Manufacturing 22.00 24.00 30.00 Variable Selling Cost 3.00 2.50 1.90 Mixing Minutes / Unit 4.0 2.5 3.0 Monthly demand (units) 1,500 2,000 500 **The company only has 10,500 minutes available per month to mix these products** Calculate the contribution margin per...
please i need the solve for A&B&C&D&E ESPECIALLY B&C&D&E Company Information Wood Work Ltd manufacture specialist...
please i need the solve for A&B&C&D&E ESPECIALLY B&C&D&E Company Information Wood Work Ltd manufacture specialist wood furniture and sell their products all over Saudi  Arabia. The company was established three  years ago in Jeddah and is performing well to date. Wood work Ltd have three main product lines; TV tables, dining table and chairs. The following financial information has been provided.   Financial Information TV tables dining Tables Chairs Selling Price per unit SAR 1,000 SAR 5,000 SAR 700 Direct Materials (wood...
A business makes two products C and D with the following sales prices and cost data:...
A business makes two products C and D with the following sales prices and cost data:                                                                C                                 D Selling price per unit                             $25                             $30 Direct material cost per unit                 $8                                 $7 Direct labour cost (0.5 hrs. product     $8  per unit                    $6 per hour Variable overhead                                $1 per unit                    $2 per direct labour hour Required 1. Determine the forecast of total costs and profits for a month when the business expects to make and sell 1 200 units of product C and 1 800...
Question 1 Cawley Company makes three models of tasers. Information on the three products is given...
Question 1 Cawley Company makes three models of tasers. Information on the three products is given below. Tingler Shocker Stunner Sales $295,400 $496,600 $201,000 Variable expenses 150,300 196,800 136,900 Contribution margin 145,100 299,800 64,100 Fixed expenses 121,116 233,081 96,503 Net income $23,984 $66,719 $(32,403) Fixed expenses consist of $307,300 of common costs allocated to the three products based on relative sales, and additional fixed expenses of $29,700 (Tingler), $79,400 (Shocker), and $34,300 (Stunner). The common costs will be incurred regardless...
Solve the question Suppose C and D are two matrices where CD is defined a) fill...
Solve the question Suppose C and D are two matrices where CD is defined a) fill in the blank: Each column vector of CD is a linear combination of ___________ and each column vector of CD is in the span of_________ . b) Using part A, what is the relation of the column space of CD, the column space of C and the column space of D
From the information, determine the total amount of: (a) Manufacturing overhead $ (b) Product costs $ (c) Period costs $
Question Description Knight Company reports the following costs and expenses in May. Factory utilities   $15,500   Direct labor   $69,100 Depreciation on factory equipment   12,650   Sales salaries   46,400 Depreciation on delivery trucks   3,800   Property taxes on factory building   2,500 Indirect factory labor   48,900   Repairs to office equipment   1,300 Indirect materials   80,800   Factory repairs   2,000 Direct materials used   137,600   Advertising   15,000 Factory manager’s salary  ...
What are the manufacturing overhead costs? Assigned costs to products using a predetermined overhead rate using...
What are the manufacturing overhead costs? Assigned costs to products using a predetermined overhead rate using a standard costing system, as discussed, job costing, and manufacturing activity-based costing. Assume manufacturing overhead costs are often called overhead costs applied to products going through the Assembly department. The journal entry reflect manufacturing overhead costs applied to products going through the Finishing department is as follows: Transferred-In Costs The costs associated with manufacturing should transfer from the work-in-process inventory account for the production...
What are the drawbacks for a company who does not allocate overhead costs to its products?...
What are the drawbacks for a company who does not allocate overhead costs to its products? Why might a company do this and what other controls would they have to implement to insure optimal performance?
Kindly provide a detailed explanation to the following question. So i can understand and solve on...
Kindly provide a detailed explanation to the following question. So i can understand and solve on my own Milden Company has an exclusive franchise to purchase a product from the manufacturer and distribute it on the retail level. As an aid in planning, the company has decided to start using a contribution format income statement. To have data to prepare such a statement, the company has analyzed its expenses and has developed the following cost formulas. Cost of goods sold...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT