Carolina Stoneware Company manufactures pottery in two production departments, P1 and P2. The production departments receive...
Carolina Stoneware Company manufactures pottery in two production departments, P1 and P2. The production departments receive services from four support departments, S1, S2, S3 and S4, which also provide some services to each other.
The costs of operating the support departments for last year are as follows:
Dept. Costs
Dept. S1 $12,000
Dept. S2 15,000
Dept. S3 10,000
Dept. S4 25,000
The percentages of service provided by the support departments to other departments are:
To
S1 S2 S3 S4 P1 P2
From S1 -- 10% 10% 5% 30% 45%
S2 10% -- 30% 10% 35% 15%
S3 20% 20% -- 10% 30% 20%
S4 15% 10% 15% -- 20% 40%
REQUIREMENTS:
a. Develop the equations needed to allocate support department costs to other departments using the reciprocal method.
b. Using excel, calculate the allocation of the support department costs to other departments and the total amount allocated to each production department. Since you are not given the direct overhead in the production departments, you are not able to calculate the total overhead for each department.
Homework Answers
| S1 = | 12000 | +10%S2 | +20%S3 | +15%S4 |
| S2= | 15000 | +10%S1 | +20%S3 | +10%S4 |
| S3= | 10000 | +10%S1 | +30%S2 | +15%S4 |
| S4= | 25000 | +5%S1 | +10%S2 | +10%S3 |
| S1 | S2 | S3 | S4 | P1 | P2 | ||
| S1 | 10 | 10 | 5 | 30 | 45 | 100 | |
| S2 | 10 | 30 | 10 | 35 | 15 | 100 | |
| S3 | 20 | 20 | 10 | 30 | 20 | 100 | |
| S4 | 15 | 10 | 15 | 20 | 40 | 100 | |
| 45 | 40 | 55 | 25 | 115 | 120 | ||
| Allocation Of cost first Interval | |||||||
| 12,000.00 | - | 1,200.00 | 1,200.00 | 600.00 | 3,600.00 | 5,400.00 | 12,000.00 |
| 15,000.00 | 1,500.00 | - | 4,500.00 | 1,500.00 | 5,250.00 | 2,250.00 | 15,000.00 |
| 10,000.00 | 2,000.00 | 2,000.00 | - | 1,000.00 | 3,000.00 | 2,000.00 | 10,000.00 |
| 25,000.00 | 3,750.00 | 2,500.00 | 3,750.00 | - | 5,000.00 | 10,000.00 | 25,000.00 |
| 7,250.00 | 5,700.00 | 9,450.00 | 3,100.00 | 16,850.00 | 19,650.00 | ||
| Reallocation of cost from support Department | |||||||
| 7,250.00 | - | 725.00 | 725.00 | 362.50 | 2,175.00 | 3,262.50 | 7,250.00 |
| 5,700.00 | 570.00 | - | 1,710.00 | 570.00 | 1,995.00 | 855.00 | 5,700.00 |
| 9,450.00 | 1,890.00 | 1,890.00 | - | 945.00 | 2,835.00 | 1,890.00 | 9,450.00 |
| 3,100.00 | 465.00 | 310.00 | 465.00 | - | 620.00 | 1,240.00 | 3,100.00 |
| 2,925.00 | 2,925.00 | 2,900.00 | 1,877.50 | 7,625.00 | 7,247.50 | ||
| Reallocation of cost from support Department | |||||||
| 2,925.00 | - | 292.50 | 292.50 | 146.25 | 877.50 | 1,316.25 | 2,925.00 |
| 2,925.00 | 292.50 | - | 877.50 | 292.50 | 1,023.75 | 438.75 | 2,925.00 |
| 2,900.00 | 580.00 | 580.00 | - | 290.00 | 870.00 | 580.00 | 2,900.00 |
| 1,877.50 | 281.63 | 187.75 | 281.63 | - | 375.50 | 751.00 | 1,877.50 |
| 1,154.13 | 1,060.25 | 1,451.63 | 728.75 | 3,146.75 | 3,086.00 | ||
| Reallocation of cost from support Department | |||||||
| 1,154.13 | - | 115.41 | 115.41 | 57.71 | 346.24 | 519.36 | 1,154.13 |
| 1,060.25 | 106.03 | - | 318.08 | 106.03 | 371.09 | 159.04 | 1,060.25 |
| 1,451.63 | 290.33 | 290.33 | - | 145.16 | 435.49 | 290.33 | 1,451.63 |
| 728.75 | 109.31 | 72.88 | 109.31 | - | 145.75 | 291.50 | 728.75 |
| 505.66 | 478.61 | 542.80 | 308.89 | 1,298.56 | 1,260.22 | ||
| Reallocation of cost from support Department | |||||||
| 505.66 | - | 50.57 | 50.57 | 25.28 | 151.70 | 227.55 | 505.66 |
| 478.61 | 47.86 | - | 143.58 | 47.86 | 167.51 | 71.79 | 478.61 |
| 542.80 | 108.56 | 108.56 | - | 54.28 | 162.84 | 108.56 | 542.80 |
| 308.89 | 46.33 | 30.89 | 46.33 | - | 61.78 | 123.56 | 308.89 |
| 202.76 | 190.02 | 240.48 | 127.42 | 543.83 | 531.46 | ||
| Reallocation of cost from support Department | |||||||
| 202.76 | - | 20.28 | 20.28 | 10.14 | 60.83 | 91.24 | 202.76 |
| 190.02 | 19.00 | - | 57.00 | 19.00 | 66.51 | 28.50 | 190.02 |
| 240.48 | 48.10 | 48.10 | - | 24.05 | 72.15 | 48.10 | 240.48 |
| 127.42 | 19.11 | 12.74 | 19.11 | - | 25.48 | 50.97 | 127.42 |
| 86.21 | 81.11 | 96.39 | 53.19 | 224.96 | 218.81 | ||
| Reallocation of cost from support Department | |||||||
| 86.21 | - | 8.62 | 8.62 | 4.31 | 25.86 | 38.80 | 86.21 |
| 81.11 | 8.11 | - | 24.33 | 8.11 | 28.39 | 12.17 | 81.11 |
| 96.39 | 19.28 | 19.28 | - | 9.64 | 28.92 | 19.28 | 96.39 |
| 53.19 | 7.98 | 5.32 | 7.98 | - | 10.64 | 21.28 | 53.19 |
| 35.37 | 33.22 | 40.93 | 22.06 | 93.81 | 91.52 | ||
| Total Cost Alloted | 29,849.57 | 32,150.43 | 62,000.00 | ||||
| Total Cost of Product wise | |||||||
| P1 | 29,849.57 | ||||||
| P2 | 32,150.43 | ||||||
Since Length is not allowed more than 65000 characters other tables
are not pasted
Add Answer to:
Carolina Stoneware Company manufactures pottery in two
production departments, P1 and P2. The production departments
receive...
Carolina Stoneware Company manufactures pottery in two production departments, P1 and P2. The production departments receive...
Carolina Stoneware Company manufactures pottery in two production departments, P1 and P2. The production departments receive services from four support departments, S1, S2, S3 and S4, which also provide some services to each other. The costs of operating the support departments for last year are as follows: Dept. S1 Dept. S2 Dept. S3 Dept. S4 Dept. Costs $12,000 15,000 10,000 25,000 The percentages of service provided by the support departments to other departments are: SA p1 From S1 10% S3...
Robinson Products Company has two service departments (S1 and S2) and two production departments (P1 and...
Robinson Products Company has two service departments (S1 and S2) and two production departments (P1 and P2). The distribution of each service department's efforts (in percentages) to the other departments is: To S1 P1 From S1 S2 S2 10% 20% ? P2 ?% 30 10% The direct operating costs of the departments (including both variable and fixed costs) are: S1 S2 P1 P2 $ 225,000 72,000 59,000 165,000 Required: 1. Determine the total cost of P1 and P2 using the...
Robinson Products Company has two service departments (S1 and S2) and two production departments (P1 and P2). The distribution of each service department's efforts (in percentages) to the other d...
Robinson Products Company has two service departments (S1 and S2) and two production departments (P1 and P2). The distribution of each service department's efforts (in percentages) to the other departments is: To From S1 S2 P1 P2 S1 78 -20% 30% S2 20% 2 40 The direct operating costs of the departments (including both variable and fixed costs) are: Si $255,000 85,000 63,000 P2 185,000 S2 P1 Required: 1. Determine the total cost of P1 and P2 using the direct...
Robinson Products Company has two service departments (S1 and S2) and two production departments (P1 and...
Robinson Products Company has two service departments (S1 and S2) and two production departments (P1 and P2). The distribution of each service department’s efforts (in percentages) to the other departments is: From To S1 S2 P1 P2 S1 — 20% 30% ? % S2 20% — ? 40 The direct operating costs of the departments (including both variable and fixed costs) are: S1 $ 205,000 S2 71,000 P1 58,000 P2 160,000 Required: 1. Determine the total cost of P1 and...
Robinson Products Company has two service departments (S1 and S2) and two production departments (P1 and P2). The distribution of each service department's efforts (in percentages) to the other d...
Robinson Products Company has two service departments (S1 and S2) and two production departments (P1 and P2). The distribution of each service department's efforts (in percentages) to the other departments is: To From S1 S2 P1 P2 S1 78 -20% 30% S2 20% 2 40 The direct operating costs of the departments (including both variable and fixed costs) are: Si $255,000 85,000 63,000 P2 185,000 S2 P1 Required: 1. Determine the total cost of P1 and P2 using the direct...
The DuffyDog Company has three service departments, S1, S2, and S3, and two production departments, P1...
The DuffyDog Company has three service departments, S1, S2, and
S3, and two production departments, P1 and P2. The following data
relate to DuffyDog’s allocation of service department costs:
Budgeted Costs
Number of Employees
S1
$4,637,000
89
S2
3,262,000
58
S3
2,618,000
40
P1
196
P2
294
Service department costs are allocated by the direct method. The
number of employees is used as the allocation base for all service
department costs.
(a)
Your answer is correct.
Allocate service department costs...
Robinson Products Company has two service departments (51 and 52) and two production departments (P1 and...
Robinson Products Company has two service departments (51 and 52) and two production departments (P1 and P2). The distribution of each service department's efforts in percentages) to the other departments is: S1 From S1 S2 To S2 P1 20% 30% P2 ?% 40 20% The direct operating costs of the departments (including both variable and fixed costs) are: S1 S2 P1 P2 $ 235,000 77,000 64,000 190,000 Required: 1. Determine the total cost of P1 and P2 using the direct...
The Springfield Company has three service departments, S1, S2, and S3, and two production departments, P1...
The Springfield Company has three service departments, S1, S2,
and S3, and two production departments, P1 and P2. The following
data relate to Springfield’s allocation of service department
costs:
Budgeted Costs
Number of Employees
S1
$4,588,000
92
S2
2,834,000
64
S3
2,760,000
41
P1
196
P2
294
Service department costs are allocated by the direct method. The
number of employees is used as the allocation base for all service
department costs.
(a)
Allocate service department costs to production departments.
Service...
Craylon Corp has two service departments, S1 and S2, and two production departments, P1 and P2....
Craylon Corp has two service departments, S1 and S2, and two production departments, P1 and P2. The data for April were as follows: Services provided to: Activity Costs S1 S2 P1 P2 S1 $100,000 20% 40% 50% S2 $80,000 10% 55% 25% Fixed Costs P1 $400,000 P2 $500,000 Required: Allocate the service departments' (S1 & S2) costs to the two operating divisions using the reciprocal method.
The Ceradyne Company has three service departments, S1, S2, and S3, and two production departments, P1...
The Ceradyne Company has three service departments, S1, S2, and
S3, and two production departments, P1 and P2. The following data
relate to Ceradyne’s allocation of service department
costs:
Budgeted Costs
Number of Employees
S1
$4,101,000
87
S2
3,110,000
58
S3
2,865,000
37
P1
204
P2
306
Service department costs are allocated by the direct method. The
number of employees is used as the allocation base for all service
department costs.
Calculate the total service department cost allocated to each...
Carolina Stoneware Company manufactures pottery in two production departments, P1 and P2. The production departments receive services from four support departments, S1, S2, S3 and S4, which also provide some services to each other. The costs of operating the support departments for last year are as follows: Dept. S1 Dept. S2 Dept. S3 Dept. S4 Dept. Costs $12,000 15,000 10,000 25,000 The percentages of service provided by the support departments to other departments are: SA p1 From S1 10% S3...
Robinson Products Company has two service departments (S1 and S2) and two production departments (P1 and P2). The distribution of each service department's efforts (in percentages) to the other departments is: To S1 P1 From S1 S2 S2 10% 20% ? P2 ?% 30 10% The direct operating costs of the departments (including both variable and fixed costs) are: S1 S2 P1 P2 $ 225,000 72,000 59,000 165,000 Required: 1. Determine the total cost of P1 and P2 using the...
Robinson Products Company has two service departments (S1 and S2) and two production departments (P1 and P2). The distribution of each service department's efforts (in percentages) to the other departments is: To From S1 S2 P1 P2 S1 78 -20% 30% S2 20% 2 40 The direct operating costs of the departments (including both variable and fixed costs) are: Si $255,000 85,000 63,000 P2 185,000 S2 P1 Required: 1. Determine the total cost of P1 and P2 using the direct...
Robinson Products Company has two service departments (S1 and S2) and two production departments (P1 and P2). The distribution of each service department's efforts (in percentages) to the other departments is: To From S1 S2 P1 P2 S1 78 -20% 30% S2 20% 2 40 The direct operating costs of the departments (including both variable and fixed costs) are: Si $255,000 85,000 63,000 P2 185,000 S2 P1 Required: 1. Determine the total cost of P1 and P2 using the direct...
The DuffyDog Company has three service departments, S1, S2, and
S3, and two production departments, P1 and P2. The following data
relate to DuffyDog’s allocation of service department costs:
Budgeted Costs
Number of Employees
S1
$4,637,000
89
S2
3,262,000
58
S3
2,618,000
40
P1
196
P2
294
Service department costs are allocated by the direct method. The
number of employees is used as the allocation base for all service
department costs.
(a)
Your answer is correct.
Allocate service department costs...
Robinson Products Company has two service departments (51 and 52) and two production departments (P1 and P2). The distribution of each service department's efforts in percentages) to the other departments is: S1 From S1 S2 To S2 P1 20% 30% P2 ?% 40 20% The direct operating costs of the departments (including both variable and fixed costs) are: S1 S2 P1 P2 $ 235,000 77,000 64,000 190,000 Required: 1. Determine the total cost of P1 and P2 using the direct...
The Springfield Company has three service departments, S1, S2,
and S3, and two production departments, P1 and P2. The following
data relate to Springfield’s allocation of service department
costs:
Budgeted Costs
Number of Employees
S1
$4,588,000
92
S2
2,834,000
64
S3
2,760,000
41
P1
196
P2
294
Service department costs are allocated by the direct method. The
number of employees is used as the allocation base for all service
department costs.
(a)
Allocate service department costs to production departments.
Service...
The Ceradyne Company has three service departments, S1, S2, and
S3, and two production departments, P1 and P2. The following data
relate to Ceradyne’s allocation of service department
costs:
Budgeted Costs
Number of Employees
S1
$4,101,000
87
S2
3,110,000
58
S3
2,865,000
37
P1
204
P2
306
Service department costs are allocated by the direct method. The
number of employees is used as the allocation base for all service
department costs.
Calculate the total service department cost allocated to each...
Most questions answered within 3 hours.
-
Where is the error in this code sequence?
String s1 = "Hello";
String s2 = "ello";...
asked 11 months ago -
Financial data for Joel de Paris, Inc., for last year
follow:
Joel de Paris, Inc.
Balance...
asked 11 months ago -
Consider this reaction:
Al2(SO4)3 (aq)+ BaCl3
(aq) Al2Cl6 (aq)- +
3BaSO4(s) . What is the...
asked 11 months ago -
Suppose that Savneet is considering increasing her
recent random sample from 20 car rentals to 40...
asked 11 months ago -
Trucks arrive at an unloading terminal at an average rate of 120
per hour.
Trucks arrive...
asked 11 months ago -
Why are methanol and ethanol completely soluble in water while
octanol is not very little soluble....
asked 11 months ago -
A facilities manager at a university reads in a research report
that the mean amount of...
asked 11 months ago -
When the CuSO4 is rehydrated by adding water to the anhydrous
compound, is this an endothermic...
asked 11 months ago -
A ray of sunlight is passing from diamond into crown glass; the
angle of incidence is...
asked 11 months ago -
A block of mass 0.249 kg is placed on top of a light, vertical
spring of...
asked 11 months ago -
how do the kidneys compensate in the presences of acidosis
a) trigger hyperventilate
b) reserve acid...
asked 11 months ago -
Question 501 pts
The rental rate of capital to the firm increases. Which of the
following...
asked 11 months ago