Question
In: Accounting
Manufacturing Overhead Distribution Worksheet The following are selected operating data for the production and service departments...
Manufacturing Overhead Distribution Worksheet
The following are selected operating data for the production and service departments of Bluestone Company for 2016.
| Departments | |||||
|---|---|---|---|---|---|
| Service | Production | ||||
| 1 | 2 | 1 | 2 | ||
| Overhead costs (identified by department) | |||||
| Indirect material | $121,000 | $205,500 | $63,600 | $1,290,000 | |
| Indirect labor | $243,000 | $360,000 | $81,460 | $3,597,500 | |
| Square feet of building floor space used | 12,000 | 18,000 | 30,000 | 60,000 | |
| Assessed value of equipment used | $52,500 | $157,500 | $315,000 | $525,000 | |
| Cubic yards of factory space used | 220,000 | 330,000 | |||
| Machine hours | 128,000 | 512,000 | |||
| Direct labor | $50,000 | $1,000,000 | |||
Building depreciation of $240,000 is allocated on the basis of square feet of floor space. Personal property taxes of $90,000 are allocated on the basis of assessed values of equipment used. Costs for service departments 1 and 2 are allocated to production departments on the basis of cubic yards of factory space and machine hours, respectively.
Required
a. Prepare a 2016 overhead distribution worksheet for Bluestone Company similar to the one prepared for Exhibit 3-15.
Use negative signs with answers, when appropriate. Under the Allocation Basis column, select the basis used to calculate each allocation.
Solutions
Expert Solution
| Bluestone Company | |||||||||||||
| Overhead Distribution Worsksheet | |||||||||||||
| For the Year Ended December 31, 2016 | |||||||||||||
| Service departments | Production departments | Allocation basis | |||||||||||
| 1 | 2 | 1 | 2 | ||||||||||
| Directly identifiable with departments: | |||||||||||||
| Indirect material | 121000 | 205500 | 63600 | 1290000 | |||||||||
| Indirect labor | 243000 | 360000 | 81460 | 3597500 | |||||||||
| Allocated to departments: | |||||||||||||
| Building depreciation | 24000 | 36000 | 60000 | 120000 | Square feet of building floor space used | ||||||||
| ($ 240000 at 12000:18000:30000:60000 or 2:3:5:10) | 240000*(2/20) | 240000*(3/20) | 240000*(5/20) | 240000*(10/20) | |||||||||
| Personal property taxes | 4500 | 13500 | 27000 | 45000 | Assessed value of equipment used | ||||||||
| ($ 90000 at 52500:157500:315000:525000 or 1:3:6:10) | 90000*(1/20) | 90000*(3/20) | 90000*(6/20) | 90000*(10/20) | |||||||||
| Total overhead | 392500 | 615000 | 232060 | 5052500 | |||||||||
| Allocation of service departments: | |||||||||||||
| Dept. 1 | ($392500 at 220000:330000 or 2:3) | -392500 | 0 | 157000 | 235500 | Cubic yards of factory space used | |||||||
| 392500*(2/5) | 392500*(3/5) | ||||||||||||
| Dept. 2 | ($615000 at 128000:512000 or 1:4) | 0 | -615000 | 123000 | 492000 | ||||||||
| 615000*(1/5) | 615000*(4/5) | ||||||||||||
| Total allocated overhead | 0 | 0 | 512060 | 5780000 | |||||||||
ekkarill92 answered 11 months agoRelated Solutions
Arbon Company has three service departments and two operating departments. Selected data concerning the five departments...
Arbon Company has three service departments and two operating
departments. Selected data concerning the five departments are
presented below:
Service Departments
Operating Departments
Administrative
Janitorial
Equipment
Maintenance
Prep
Finishing
Total
Costs
$
92,000
$
67,800
$
36,000
$
256,100
$
498,600
$
950,500
Number of employees
80
60
240
600
300
1,280
Square metres of space occupied
300
1,200
1,000
2,000
7,000
11,500
Machine-hours
26,000
54,000
80,000
The company allocates service
department costs by the step-down method in the following...
Rafner Manufacturing identified the following budgeted data in its two production departments. Assembly Finishing Manufacturing overhead...
Rafner Manufacturing identified the following budgeted data in its
two production departments.
Assembly
Finishing
Manufacturing overhead costs
$
1,218,700
$
620,000
Direct labor hours
12,200
DLH
20,200
DLH
Machine hours
6,200
MH
16,200
MH
Required:
1. What is the company’s single plantwide overhead rate based on
direct labor hours?
2. What is the company’s single plantwide overhead rate based on
machine hours?
The Ferre Publishing Company has three service departments and two operating departments. Selected data from a...
The Ferre Publishing Company has three service departments and
two operating departments. Selected data from a recent period on
the five departments follow:
Service Departments
Operating Departments
Administration
Janitorial
Maintenance
Binding
Printing
Total
Costs
$72,000
$73,000
$44,000
$245,000
$545,000
$979,000
Number of employees
112
80
320
800
400
1,712
Square feet of space
occupied
3,000
12,000
10,000
20,000
70,000
115,000
Hours of press time
18,000
37,000
55,000
The company allocates service department costs by the step-down
method in the following...
The Ferre Publishing Company has three service departments and two operating departments. Selected data from a...
The Ferre Publishing Company has three service departments and
two operating departments. Selected data from a recent period on
the five departments follow:
Service Departments
Operating
Departments
Administrative
Janitorial
Maintenance
Binding
Printing
Total
Costs
$93,300
$66,200
$44,800
$248,300
$490,600
$943,200
Number of employees
60
90
260
630
320
1,360
Square feet of space occupied
3,100
11,800
8,800
10,400
68,900
103,000
Hours of press time
9,600
28,200
37,800
Required:
Assuming that the company uses the direct method rather than the
step-down...
Macy Manufacturing Corporation has two service departments, Custodial Services and Maintenance, and three production (operating) departments,...
Macy Manufacturing Corporation has two service departments,
Custodial Services and Maintenance, and three production
(operating) departments, Cutting, Milling, and Assembly. The
company allocates the cost of Custodial Services on the basis of
square footage and Maintenance on the basis of labor-hours. No
distinction is made between variable and fixed costs. Budgeted
operating data for the year just completed follow: Service
Departments Operating Departments Custodial Maintenance Cutting
Milling Assembly Budgeted costs before allocation $24,000 $12,000
$120,000 $75,000 $135,000 Square feet 2,000...
Woodbury Hospital has three service departments and three operating departments. Estimated cost and operating data for...
Woodbury Hospital has three service departments and three
operating departments. Estimated cost and operating data for all
departments in the hospital for the forthcoming quarter are
presented in the table below:
Service Departments
Operating Departments
Housekeeping Services
Food Services
Administrative Services
Laboratory
Radiology
General Hospital
Total
Total cost
$107,000
$341,060
$289,020
$455,900
$600,500
$545,800
$2,339,280
Meals served
2,800
6,000
3,000
80,000
91,800
Square feet of space
7,000
19,000
10,500
16,000
9,500
128,000
190,000
Files processed
24,000
17,000
45,000
86,000
The...
Woodbury Hospital has three service departments and three operating departments. Estimated cost and operating data for...
Woodbury Hospital has three service departments and three
operating departments. Estimated cost and operating data for all
departments in the hospital for the forthcoming quarter are
presented in the table below:
Service Departments
Operating Departments
Housekeeping Services
Food Services
Administrative Services
Laboratory
Radiology
General Hospital
Total
Total cost
$93,000
$313,060
$261,020
$420,900
$544,500
$496,800
$2,129,280
Meals served
1,400
3,200
1,600
71,600
77,800
Square feet of space
5,600
14,800
7,700
11,800
8,100
114,000
162,000
Files processed
17,000
10,000
31,000
58,000
The...
Woodbury Hospital has three service departments and three operating departments. Estimated cost and operating data for...
Woodbury Hospital has three service departments and three
operating departments. Estimated cost and operating data for all
departments in the hospital for the forthcoming quarter are
presented in the table below:
Service Departments
Operating Departments
Housekeeping Services
Food Services
Administrative Services
Laboratory
Radiology
General Hospital
Total
Total cost
$105,000
$337,060
$285,020
$450,900
$592,500
$538,800
$2,309,280
Meals served
2,600
5,600
2,800
78,800
89,800
Square feet of space
6,800
18,400
10,100
15,400
9,300
126,000
186,000
Files processed
23,000
16,000
43,000
82,000
The...
The Merchant Manufacturing Company has two service departments — purchasing and maintenance, and two production departments...
The Merchant Manufacturing Company has two service departments —
purchasing and maintenance, and two production departments —
fabrication and assembly. The distribution of each service
department's efforts to the other departments is shown below:
FROM
TO
Purchasing
Maintenance
Fabrication
Assembly
Purchasing
0
%
15
%
75
%
10
%
Maintenance
55
%
0
%
35
%
10
%
The direct operating costs of the departments (including both
variable and fixed costs) were as follows:
Purchasing
$
156,000
Maintenance
78,000
Fabrication...
a. Caro Manufacturing has two production departments, Machining and Assembly, and two service departments, Maintenance and...
a. 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
$
98,000
Assembly
74,400
Maintenance
46,000
—
0.2
0.6
0.2
Cafeteria
37,000
0.6
—
0.1
0.3
Exercise 11-27 (Algo) Cost Allocation: Direct Method (LO
11-2)
Required:
Compute the...
ADVERTISEMENT
ADVERTISEMENT
Latest Questions
- An electron of kinetic en- ergy 1.20 keV circles in a plane per- pendicular to a...
- a.Name the class of drug and the subjective effects it has on a user. In addition...
- Ethics deals with morality and I would contend that capitalism is an amoral economic model! (Amoral means...
- Pro forma income statement The marketing department of Metroline Manufacturing estimates that its sales in 2020...
- Using MATLAB A list of 30 test scores is: 31, 70, 92, 5, 47, 88, 73,...
- Looking for a response to the following statement: There are four forms of business organizations: sole...
- 3. A 200 lbmol/hr stream that is 95 mole% methylformate and 5% methanol is to be...
ADVERTISEMENT