Question

In: Accounting

1.Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and...

1.Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and Maintenance). During July, the following costs and service department usage ratios were recorded:

Supplying Department Using Department
Engineering Administration Maintenance Fabrication Assembly
Engineering 0 50 % 0 10 % 40 %
Administration 10 % 0 20 % 50 % 20 %
Maintenance 0 20 % 0 20 % 60 %
Direct cost $ 22,000 $ 193,300 $ 25,000 $ 180,000 $ 50,000

  
Required:

Allocate the service department costs to the two operating departments using the reciprocal method

Engineering

Administration

Maintenance

2. GG Products, Inc., prepares tips and stems from a joint process using asparagus. It produced 250,000 units of tips having a sales value at the split-off point of $60,000. It produced 250,000 units of stems having a sales value at split-off of $40,000. Using the net realizable value method, the portion of the total joint product costs allocated to tips was $52,500.

Required:

Compute the total joint product costs before allocation. (Do not round intermediate calculations.)

Total Cost=

Solutions

Expert Solution

1)

Let the total cost of three service department be "

Engineering = X

Administration =Y

Maintenance =Z

Engineering Administration Maintenance
E 0% 50% (Allocates 50% of total cost to Adm.dept ) 0%
A 10%   (allocates 10% of total cost to Eng.Dept) 0% 20%   (Allocates 20% of total cost to Main.Dept)
M 0% 20%    (allocates 20% of total cost to Adm.Dept ) 0%

Equation 1:

Total cost of Enginering department (X) = Direct cost +allocation from Administration department

                   X = 22000+ (y*10%)

Equation 2 :

Total cost of Administration department (Y) =Direct cost +Allocation from engineering dept +Allocation from maintenance department

Y = 193300 + (X* .50)+ (Z*.20)

Y = 193300 + .50X +.20 Z

Equation 3:

Total cost of maintenance department =Direct cost+ Allocation from admi.dept

                 Z = 25000 +.20Y

Putting the value of X and Z from equation 1 and 3 to equation 2

Y =193300 + [.50 * (22000+.10 Y) ] + [.20*(25000+.20Y)]

Y = 193300 + [(.50*22000)+(.50*.10Y)] +[(.20*25000)+(.20*.20Y)]

Y = 193300 + 11000+.05Y +5000 +.04Y

Y = 209300+.09Y

Y-.09Y = 209300

.91 Y= 209300

Y = 209300/.91

= 230000

Total cost of Administration department = 230000

No put the value of Y in equation 1 and 3

X= 22000+ (.10 *230000)

= 22000 + 23000

   =45000

Cost of maintenance department = 25000+ (230000*.20)

                          = 25000 +46000

                           = 71000

Allocation to production department

Fabrication Assembly
Direct cost 180000 50000
ENGINEERING 45000*10%=4500 45000*40%= 18000
Administration 230000*50%=115000 230000*20%= 46000
Maintenance 71000*20%= 14200 71000*60%= 42600
Total 313700 156600

2)

TIPS STEMS TOTAL
Net realizable value 60000 40000 100000
Joint cost allocated 52500

Joint cost allocated to TIPS = (Net realizable value of TIPS/Total NRV )*total joint cost

52500 = (60000/100000) * total joint cost

52500 = .60 *total joint cost

total joint cost = 52500 /.60

          = $ 87500


Related Solutions

Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and...
Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and Maintenance). During July, the following costs and service department usage ratios were recorded. Supplying Department Using Department Engineering Administration Maintenance Fabrication Assembly Engineering 0 40 % 0 15 % 45 % Administration 20 % 0 25 % 45 % 10 % Maintenance 0 30 % 0 15 % 55 % Direct cost $ 42,000 $ 248,550 $ 45,000 $ 230,000 $ 80,000 Required: Allocate...
Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and...
Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and Maintenance). During July, the following costs and service department usage ratios were recorded. Supplying Department Using Department Engineering Administration Maintenance Fabrication Assembly Engineering 0 40 % 0 15 % 45 % Administration 20 % 0 25 % 45 % 10 % Maintenance 0 30 % 0 15 % 55 % Direct cost $ 42,000 $ 248,550 $ 45,000 $ 230,000 $ 80,000 Required: Allocate...
Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and...
Midland Resources has two production departments (Fabrication and Assembly) and three service departments (Engineering, Administration, and Maintenance). During July, the following costs and service department usage ratios were recorded. Supplying Department Using Department Engineering Administration Maintenance Fabrication Assembly Engineering 0 50 % 0 10 % 40 % Administration 10 % 0 20 % 50 % 20 % Maintenance 0 50 % 0 20 % 30 % Direct cost $ 24,000 $ 179,500 $ 25,000 $ 185,000 $ 50,000    Required:...
Av-Y6 Company operates three service departments, administration, maintenance, and personnel and two production departments, assembly and...
Av-Y6 Company operates three service departments, administration, maintenance, and personnel and two production departments, assembly and packaging. Information for the three service departments is given below: Admin Maint Person Directly traced overhead $68,000 $46,000 $77,000 Square feet occupied 2,000 3,500 3,000 Number of employees 36 24 30 Maintenance hours 2,500 2,000 4,000 Information for the two production departments is given below: Assembly Packaging Directly traced overhead $167,060 $120,090 Square feet occupied 2,100 1,400 Number of employees 42 18 Maintenance hours...
Av-Y6 Company operates three service departments, administration, maintenance, and personnel and two production departments, assembly and...
Av-Y6 Company operates three service departments, administration, maintenance, and personnel and two production departments, assembly and packaging. Information for the three service departments is given below: Admin Maint Person Directly traced overhead $65,000 $33,000 $74,000 Square feet occupied 2,000 3,500 3,000 Number of employees 42 24 30 Maintenance hours 2,500 2,000 4,000 Information for the two production departments is given below: Assembly Packaging Directly traced overhead $167,030 $114,090 Square feet occupied 2,100 1,400 Number of employees 36 18 Maintenance hours...
Av-Y6 Company operates three service departments, administration, maintenance, and personnel and two production departments, assembly and...
Av-Y6 Company operates three service departments, administration, maintenance, and personnel and two production departments, assembly and packaging. Information for the three service departments is given below: Admin Maint Person Directly traced overhead $68,000 $46,000 $77,000 Square feet occupied 2,000 3,500 3,000 Number of employees 36 24 30 Maintenance hours 2,500 2,000 4,000 Information for the two production departments is given below: Assembly Packaging Directly traced overhead $167,060 $120,090 Square feet occupied 2,100 1,400 Number of employees 42 18 Maintenance hours...
The Buckaneer Clinic has two service departments (Human Resources and Information Resources) and two "production" departments...
The Buckaneer Clinic has two service departments (Human Resources and Information Resources) and two "production" departments (In-patient Treatment and Out-patient Treatment). The service departments service the "production" departments as well as each other, and studies have shown that Information Resources provides the greater amount of service. Which of the following allocations would occur if Buckaneer uses the direct method of cost allocation? Multiple Choice Information Resources cost would be allocated to In-patient Treatment. Information Resources cost would be allocated to...
State Financial Corp. has three service departments (Administration, Communications, and Facilities), and two production departments (Deposits...
State Financial Corp. has three service departments (Administration, Communications, and Facilities), and two production departments (Deposits and Loans). A summary of costs and other data for each department prior to allocation of service department costs for the year ended December 31 follows. Administration Communications Facilities Deposits Loans Direct costs $ 210,000 $ 320,000 $ 253,000 $ 8,220,000 $ 4,600,000 Employee hours 20,500 34,000 21,000 480,000 365,000 Number of employees 9 15 7 230 160 Square footage occupied 5,100 13,300 5,800...
State Financial Corp. has three service departments (Administration, Communications, and Facilities), and two production departments (Deposits...
State Financial Corp. has three service departments (Administration, Communications, and Facilities), and two production departments (Deposits and Loans). A summary of costs and other data for each department prior to allocation of service department costs for the year ended December 31 follows. Administration Communications Facilities Deposits Loans Direct costs $ 240,000 $ 330,000 $ 260,000 $ 7,890,000 $ 5,400,000 Employee hours 21,000 37,000 20,500 476,000 334,000 Number of employees 7 10 6 210 130 Square footage occupied 5,300 13,400 5,100...
State Financial Corp. has three service departments (Administration, Communications, and Facilities), and two production departments (Deposits...
State Financial Corp. has three service departments (Administration, Communications, and Facilities), and two production departments (Deposits and Loans). A summary of costs and other data for each department prior to allocation of service department costs for the year ended December 31 follows: Administration Communications Facilities Deposits Loans Direct costs $ 240,000 $ 300,000 $ 256,000 $ 8,170,000 $ 4,800,000 Employee hours 23,000 34,000 23,000 420,000 367,000 Number of employees 9 17 4 230 160 Square footage occupied 4,500 14,300 5,500...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT