Please give positive ratings so I can keep answering. It would help me a lot. Please comment if you have any query. Thanks! |
Marine Company | Support Department | ||||
Direct Method | Design | Programming | Dept. 1 | Dept. 2 | Total |
Labor Hours- Design | - | 5,000.00 | 1,000.00 | 9,000.00 | 15,000.00 |
Labor Hours- Programming | 400.00 | - | 600.00 | 1,000.00 | 2,000.00 |
Costs before allocation | 157,200.00 | 65,200.00 | 222,400.00 | ||
Allocation of Design (1000:9000) | (157,200.00) | 15,720.00 | 141,480.00 | - | |
Allocation of Programming (600:1000) | (65,200.00) | 24,450.00 | 40,750.00 | - | |
Costs after allocation | - | - | 40,170.00 | 182,230.00 | 222,400.00 |
Support Department | |||||
Step Down Method | Design | Programming | Dept. 1 | Dept. 2 | Total |
Labor Hours- Design | - | 5,000.00 | 1,000.00 | 9,000.00 | 15,000.00 |
Labor Hours- Programming | 400.00 | - | 600.00 | 1,000.00 | 2,000.00 |
Costs before allocation | 157,200.00 | 65,200.00 | 222,400.00 | ||
Rank | Rank 1 | Rank 2 | |||
Design cost will be allocated first as it is higher than Programming cost. | |||||
Allocation of Design (500-:1000:9000) | (157,200.00) | 52,400.00 | 10,480.00 | 94,320.00 | - |
Total costs | - | 117,600.00 | 10,480.00 | 94,320.00 | 222,400.00 |
Allocation of Programming (600:1000) | - | (117,600.00) | 44,100.00 | 73,500.00 | - |
Costs after allocation | - | - | 54,580.00 | 167,820.00 | 222,400.00 |
Support Department | |||||
Reciprocal Method | Design | Programming | Dept. 1 | Dept. 2 | Total |
Labor Hours- Design | - | 5,000.00 | 1,000.00 | 9,000.00 | 15,000.00 |
Labor Hours- Programming | 400.00 | - | 600.00 | 1,000.00 | 2,000.00 |
Labor Hours- Design % | - | 33.33% | 6.67% | 60.00% | 100.00% |
Labor Hours- Programming % | 20.00% | - | 30.00% | 50.00% | 100.00% |
Costs before allocation | 157,200.00 | 65,200.00 | 222,400.00 |
Let Overhead cost of Design department is $ X and Overhead cost of Programming department is $ Y |
So, X= 157,200+ 20% of Y | Equation 1 |
Y= 65200+ 33.33% of X | Equation 2 |
Or, X= 157,200+ 0.20Y | |
Y= 65200+ 33.33% of X |
Substituting the value of X in equation 2: |
Y = 65200 + 33.33%(157200 + 0.20Y) |
Y = 65200 + 52400 + 0.066666Y |
Y – 0.066666Y = 117600 |
0.93333Y = 117600 |
Y = 117600/0.933333 |
Y = $ 126,000 |
Total Overhead cost of Programming department is $ 126,000. |
Substituting the value of Y in equation 1: |
Or, X= 157,200+ 0.20Y |
Or, X= 157,200+ 0.20*126000 |
Or, X= 157,200+ 25,200 |
X= 182,400 |
Total Overhead cost of Design department is $ 182,400. |
Allocation Summary | Support Department | ||||
Reciprocal Allocation Method | Design | Programming | Dept. 1 | Dept. 2 | Total |
Labor Hours- Design % | - | 33.33% | 6.67% | 60.00% | 100.00% |
Labor Hours- Programming % | 20.00% | - | 30.00% | 50.00% | 100.00% |
Costs before allocation | 157,200.00 | 65,200.00 | 222,400.00 | ||
Allocation | |||||
Allocation of Design costs | (182,400.00) | 60,800.00 | 12,160.00 | 109,440.00 | - |
Allocation of Programming costs | 25,200.00 | (126,000.00) | 37,800.00 | 63,000.00 | - |
Costs after allocation | - | - | 49,960.00 | 172,440.00 | 222,400.00 |
Final Answer | Dept. 1 | Dept. 2 | Total |
Direct Method | 40,170.00 | 182,230.00 | 222,400.00 |
Step Down Method | 54,580.00 | 167,820.00 | 222,400.00 |
Reciprocal Method | 49,960.00 | 172,440.00 | 222,400.00 |
Required information (The following information applies to the questions displayed below.) Marin Company produces two software...
Required information [The following information applies to the questions displayed below.] Marin Company produces two software products (Cloud-X and Cloud-Y) in two separate departments (A and B). These products are highly regarded network maintenance programs. Cloud-X is used for small networks and Cloud-Y is used for large networks. Marin is known for the quality of its products and its ability to meet dates promised for software upgrades. Department A produces Cloud-X, and department B produces Cloud-Y. The production departments are...
Data Performance, a computer software consulting company, has three major functional areas: computer programming, information systems consulting, and software training. Carol Bingham, a pricing analyst, has been asked to develop total costs for the functional areas. These costs will be used as a guide in pricing a new contract. In computing these costs, Carol is considering three different methods of the departmental allocation approach to allocate overhead costs: the direct method, the step method, and the reciprocal method. She assembled...
Required information [The following information applies to the questions displayed below.) Celestial Artistry Company is developing departmental overhead rates based on direct-labor hours for its two production departments, Etching and Finishing. The Etching Department employs 20 people and the Finishing Department employs 80 people. Each person in these two departments works 2,000 hours per year. The production-related overhead costs for the Etching Department are budgeted at $200,000, and the Finishing Department costs are budgeted at $320,000. Two service departments, Maintenance...
Required information [The following information applies to the questions displayed below.] Gipps Business College (GBC) has two degree programs, undergraduate (UG) and graduate (GRAD) and three service departments, information technology (IT), Event Planning (EP), and Career Services (CS). The CFO of GBC is conducting a profitability analysis of the two programs and wants to include the appropriate costs of the service departments in the costs of the two degree programs. As a part of the analysis, the CFO has collected...
Required information [The following information applies to the questions displayed below.] Tampa Instrument Company manufactures gauges for construction machinery. The company has two production departments: Machining and Assembly. There are three service departments: Maintenance, Human Resources (HR), and Computer Aided Design (CAD). The usage of these service departments’ output during the year just completed is as follows: Provision of Service Output (in hours of service) Provider of Service User of Service HR Maintenance CAD HR — — — Maintenance 1,000...
Required information [The following information applies to the questions displayed below.] Caro Manufacturing has two production departments, Machining and Assembly, and two service departments, Maintenance and Cafeteria. Direct costs for each department and the proportion of service costs used by the various departments for the month of August follow: Proportion of Services Used by Maintenance Cafeteria Machining Assembly Department Machining Assembly Maintenance Cafeteria Direct Costs $94,000 66,400 41,200 33,000 0.2 0.6 0.1 0.2 0.1 Required: Compute the allocation of service...
Required information [The following information applies to the questions displayed below.] Caro Manufacturing has two production departments, Machining and Assembly, and two service departments, Maintenance and Cafeteria. Direct costs for each department and the proportion of service costs used by the various departments for the month of August follow: Proportion of Services Used by Department Direct Costs Maintenance Cafeteria Machining Assembly Machining $ 104,000 Assembly 74,400 Maintenance 46,000 — 0.2 0.5 0.3 Cafeteria 37,000 0.6 — 0.2 0.2 Required: Compute...
Required information [The following information applies to the questions displayed below.] Caro Manufacturing has two production departments, Machining and Assembly, and two service departments, Maintenance and Cafeteria. Direct costs for each department and the proportion of service costs used by the various departments for the month of August follow: Proportion of Services Used by Department Direct Costs Maintenance Cafeteria Machining Assembly Machining $ 92,000 Assembly 62,400 Maintenance 38,800 — 0.2 0.6 0.2 Cafeteria 31,000 0.8 — 0.1 0.1 Required: Compute...
Required information [The following information applies to the questions displayed below.] Caro Manufacturing has two production departments, Machining and Assembly, and two service departments, Maintenance and Cafeteria. Direct costs for each department and the proportion of service costs used by the various departments for the month of August follow: Proportion of Services Used by Maintenance Cafeteria Machining Assembly Department Machining Assembly Maintenance Cafeteria Direct Costs $94,000 66,400 41,200 33,000 0.2 0.6 0.1 0.8 0.2 0.1 Required: Compute the allocation of...
Required information [The following information applies to the questions displayed below.] 10 Caro Manufacturing has two production departments, Machining and Assembly, and two service departments, Maintenance and Cafeteria. Direct costs for each department and the proportion of service costs used by the various departments for the month of August follow: points Proportion of Services Used by eBook Maintenance Cafeteria Machining Assembly Department Machining Assembly Maintenance Cafeteria Direct Costs $113,000 76,400 47,200 0.8 0.2 38,000 0.5 0.3 Print Required: Compute the...