Ex_7-41
xlsx
keyboard_arrow_up
School
Brock University *
*We aren’t endorsed by this school
Course
5P06
Subject
Accounting
Date
Apr 3, 2024
Type
xlsx
Pages
10
Uploaded by DeaconDugongMaster1026
Ex 7-4
Data Section
Data from Ex 7-3
Overhead costs to be assigned using ABC:
Indirect factory salaries
$ 520,000 Delivery crew wages expense
$ 140,000 delivery vehicle operating expenses and depreciation
$ 95,000 $ 103,000 office expenses
$ 25,000 other administrative expenses
$ 225,000 Indirect factory salaries
50%
25%
Delivery crew wages expense
0%
75%
delivery vehicle operating expenses and depreciation
0%
80%
10%
10%
office expenses
15%
15%
other administrative expenses
15%
5%
Data from Ex 7-4
Cost pools and activity units
Activity
Total activity
Quality control & Inspection
4,800 units produced
Delivery & Installation
1,200 deliveries
procurement and order processing salaries and expenses
Distribution of resource consumption across the activity cost pools
Quality control & Inspection
Delivery & Installation
procurement and order processing salaries and expenses
Order processing
920 orders processed
Other
- Activity data for the leather recliner product line
Activity
Total activity
Quality control & Inspection
1,200 units produced
Delivery & Installation
300 deliveries
Order processing
230 orders processed
Other
20%
5%
10%
15%
10%
10%
65%
15%
35%
35%
40%
40%
Order processing
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Ex 7-4
Computations
Total of overhead costs to be assigned using ABC:
Indirect factory salaries
$ 520,000 Delivery crew wages expense
$ 140,000 delivery vehicle operating expenses and depre
$ 95,000 procurement and order processing salaries a
$ 103,000 office expenses
$ 25,000 other administrative expenses
$ 225,000 Total
$ 1,108,000
Distribution of resource consumption across the activity cost pools:totals
Other
Indirect factory salaries
50%
25%
20%
5%
Delivery crew wages expense
0%
75%
10%
15%
delivery vehicle operating expenses and depreciatio
0%
80%
10%
10%
procurement and order processing salaries and exp
10%
10%
65%
15%
office expenses
15%
15%
35%
35%
other administrative expenses
15%
5%
40%
40%
Quality control & Inspection
Delivery & Installatio
n
Order processing
Total
100%
100%
100%
100%
100%
100%
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
Ex 7-4
Part 1
First stage allocation of costs to activity pools:
Indirect factory salaries
$ 260,000 $ 130,000 Delivery crew wages expense
$ - $ 105,000 delivery vehicle operating expenses and depreciation
$ - $ 76,000 procurement and order processing salaries and expenses
$ 10,300 $ 10,300 office expenses
$ 3,750 $ 3,750 other administrative expenses
$ 33,750 $ 11,250 Totals
$ 307,800 $ 336,300 Activity rates for the ABC system:
Activity cost pool
Total cost
Total activity
Quality control & Inspection
$ 307,800 4,800 Delivery & Installation
$ 336,300 1,200 Order processing
$ 293,200 920 Quality control & Inspection
Delivery & Installation
Order processing
Other
Totals
$ 104,000 $ 26,000 $ 520,000 $ 14,000 $ 21,000 $ 140,000 $ 9,500 $ 9,500 $ 95,000 $ 66,950 $ 15,450 $ 103,000 $ 8,750 $ 8,750 $ 25,000 $ 90,000 $ 90,000 $ 225,000 $ 293,200 $ 170,700 $ 1,108,000 Activity Rate
units produced
$ 64.13 per unit
deliveries
$ 280.25 per delivery
orders processed
$ 318.70 per order
Ex 7-4
Part 2
Total overhead cost assigned to the leather recliner product line:
Activity cost pool
Activity Rate
Activity units
Quality control & Inspection
$ 64.13 per unit
1,200 Delivery & Installation
$ 280.25 per delivery
300 Order processing
$ 318.70 per order
230 Total overhead cost
$ 663.07
Your preview ends here
Eager to read complete document? Join bartleby learn and gain access to the full version
- Access to all documents
- Unlimited textbook solutions
- 24/7 expert homework help
ABC cost
units produced
$ 76,950.00 deliveries
$ 84,075.00 orders processed
$ 73,300.00 $ 234,325.00
Related Documents
Related Questions
Manufacturing Overhead Distribution Worksheet
The following are selected operating data for the production and service departments of Bluestone Compa
Departments
Service
Production
Overhead costs (identified by department)
$50.000 $1.032.000
$65,168 $2478.000
4.000
Indirect material
S96.800 S164A00
Indirect labor
$194400 $2.000
24.000
Square feet of building floor space used
Assessed value of equipment used
9.600
14.400
$252.000 5420.000
264000
$.00 $126 000
176.000
Cubic yards of factory space used
400.600
102.400
Machine hours
$40.000 s00.000
Direct labor
O is allocated on the basis of square feet of floor space. Personal property taxes of $72,000 are allocated on the
sbution worksheet for Bluestone Company similar to the one prepared for Exhibit 3-1s
when appropriate Under the Allocation Basis column, select the basis used to calculate each alocation
arrow_forward
Ans plz accounting question
arrow_forward
PROBLEM I
ABC Company's total overhead costs at various levels of activity are presented below:
March
April
May
June.
Machine Hours Total Overhead Costs
$216,800
$194,000
$239,600
$262,400
60,000
50,000
70,000
80,000
Assume that the overhead costs above consist of utilities, supervisory salaries, and
maintenance. At the 50,000 machine-hour level of activity these costs are:
Utilities (V).
Supervisory salaries (F).
Maintenance (M)..
Total overhead cost
V = Variable; F = Fixed; M = Mixed
The company wants to break down the maintenance cost into its basic variable and fixed
cost elements.
Required:
$ 54,000
62,000
78.000
$194.000
a. Estimate the maintenance cost for June.
b.
Use the high-low method to estimate the cost formula for maintenance cost.
c. Estimate the total overhead cost at an activity level of 55,000 machine hours.
arrow_forward
EstimatedFixedCost
EstimatedVariableCost(perunitsold)
Production costs:
Direct materials
$19
Direct labor
13
Factory overhead
$261,300
10
Selling expenses:
Sales salaries and commissions
54,300
4
Advertising
18,400
Travel
4,100
Miscellaneous selling expense
4,500
4
Administrative expenses:
Office and officers' salaries
53,100
Supplies
6,500
2
Miscellaneous administrative expense
6,040
2
Total
$408,240
$54
It is expected that 8,640 units will be sold at a price of $135 a unit. Maximum sales within the relevant range are 11,000 units.
Required:
Question Content Area
1. Prepare an estimated income statement for 20Y7.
Belmain Co.Estimated Income StatementFor the Year Ended December 31, 20Y7
$- Select -
Cost of goods sold:
$- Select -
- Select -
- Select -…
arrow_forward
Accounting question
arrow_forward
Direct labor cost
Factory overhead
Direct labor hours
Machine hours
Dept. A
$ 69,000
$115,920
Dept. B
$49,000
$54,855
6,900
2,900
9,900
15,900
of the year, the company made the following
What predetermined overhead rate would be used in Department A and Department B, respectively?
Multiple Choice
168% and 345%.
168% and $3.45.
)
$1.68 and 345%.
$1.68 and $3.45.
arrow_forward
Direct labor
17 per unit
11 per unit
24
Direct materials
$4
Overhead
Total variable overhead
Total fixed overhead
Expected units to be produced
$ 30,000
$100, 000
50,e00 units
Product cost per unit under absorption costing
arrow_forward
Sub: accounting 14
arrow_forward
General Accounting question
arrow_forward
First-stage allocation of overhead costs to the activity cost pools:
Overhead costs
Installing
floors
Job Support
Other
Total
Production overhead
76,000
76,000
38,000
190,000
(190000*40%)
(190000*40%)
(190000*20%)
Office expense
14,000
(140000*10%)
84,000
(140000*60%)
42,000
140,000
(140000*30%)
Total
90,000
160,000
80,000
330,000
Determination of Activity rates:
Overhead costs
Installing floors
Job support
Total activity
Activity rate
Overhead $ (A)
(B)
(A/B)
90,000
200
450 Per square
160,000
160
1,000 Per Job
Determination of Overhead costs based on activity rates for Job of 3.4 squares:
Overhead costs
Installing floors
Job support
Activity
Overhead
Activity rate (A) consumed by
allocated (A*B)
Job (B)
450
3.40
1,530
1,000
1.00
1,000
Total overhead cost
2,530
arrow_forward
1 Manufacturing Overhead Distribution Worksheet The following are selected operating data for 2 the production and service departments of Bluestone Company for 2019 3 Departments Service Production 4 1 2 1 2 6 Overhead costs (identified by department) $ 48,400 82,200 25,440 516,000 32,584 $1,439,000 Indirect materials 7 $97,200 $144,000 Indirect labor 8 7,200 9 Square feet of building floor space used 10 Assessed value of equipment used 11 Cubic yards of factory space used 4,800 24,000 12,000 $ 21,000 63,000 126,000 210,000 88,000 132,000 12
arrow_forward
Estimated manufacturing overhead
Estimated direct labor cost
Actual manufacturing overhead
Actual direct labor cost
$500,000
$250,000
$720,000
$300,000
Based on this information, the predetermined overhead rate per direct labor dollar is
arrow_forward
General Accounting Question
arrow_forward
General accounting question
arrow_forward
Unit
Direct materials
Direct labor
Variable manufacturing overhead
Fixed manufacturing overhead
Fixed selling expense
$ 7.00
$ 4.00
$ 1.50
$ 5.00
$ 3.50
Fixed administrative expense
$ 2.50
Sales commissions
$ 1.00
Variable administrative expense
$ 0.50
Required:
1. Assume the cost object is units of production:
a. What is the total direct manufacturing cost incurred to make 20,000 units?
b. What is the total indirect manufacturing cost incurred to make 20,000 units?
2. Assume the cost object is the Manufacturing Department and its total output is 20,000 units.
a. How much total manufacturing cost is directly traceable to the Manufacturing Department?
b. How much total manufacturing cost is an indirect cost that cannot be easily traced to the Manufacturing Department?
3. Assume the cost object is the company's various sales representatives. Furthermore, assume the company spent $50,000 of its
total fixed selling expense on advertising and the remainder of the total fixed selling expense…
arrow_forward
Posted in Subject - General Account question
arrow_forward
Need answer
arrow_forward
Activity Cost Pool
Activity Measure
Estimated Overhead Cost
Machining
24
378,000
Machine-hours
HR Supporting direct labour
%24
Direct labor-hours
238,800
Machine setups
24
Number of setups
93,100
Number of product
lines
Product-sustaining
$4
90,000
Total
%24
799,900
The expected activity for the year was distributed among the company's two product
lines as follows:
Activity Measure
Product A
Product B
Machine-hours
7900
6100
Direct labor-hours
7900
4100
Number of setups
40
150
Number of product lines
1
1
Required:
1. Based on the data of four cost pools and activity measures, compute the activity rate for each activity cost pool:
a. What is the activity rate for the Machining activity cost pool? Round to nearest dollar
Activity rate: $
per machine-hour
b. What is the activity rate for the Supporting Direct Labour activity cost pool? Round to nearest dollar
Activity rate: $
per direct labour-hour
arrow_forward
activity car pool
est. overhead cost
expected activity
A
B
total
#1
$29,200
1000
500
1500
#2
$40,000
200
800
1000
#3
$180,000
600
5400
6000
Chibucos Company has two products: A and B. The annual production and sales level of Product A is 9,094 units. The annual production and sales level of Product B is 15,826. The company uses activity-based costing and has prepared the following analysis showing the estimated total cost and expected activity for each of its three activity cost pools.
The overhead cost per unit of Product A under activity-based costing is closest to:
options:
1. $1.83
2. $1.98
3. $5.00
4. $10.00
arrow_forward
QUESTION 6
Your company currently produces a range of three products, D, E and F to which the following
details relate for Period 2.
Production (units)
Material cost per unit
Labour hours per unit
Machine hours per unit
D
1,500
RM 18
Set-up costs
Handling costs
Machining costs
Inspection costs
1
3
Labour costs are RM 8 per hour and production overheads are currently absorbed in the
conventional system by reference to machine hours. Total production overheads for Period 2
have been analysed as follows:
RM
327,250
187,000
140,250
280,500
935,000
E
2,500
RM 10
3
2
D
90
16
180
F
14,000
RM 20
2
6
(a) Calculate the cost per unit for each product using conventional methods.
The introduction of an ABC is being considered and to that end the following volume of
activities have been identified with the current output levels.
E
138
28
216
F
576
116
804
Number of set-ups
Number of material issues
Number of inspections
(b) Calculate the cost per unit for each product using the ABC approach.
(c)…
arrow_forward
General Accounting Question provide correct solution
arrow_forward
8
arrow_forward
pvn.1
arrow_forward
Total
Manufacturing
Overhead
Prime
Conversion
Cost
Direct
Materials
Direct
Labor
Manufacturing
Cost
Case
Cost
A
$
2,120 $
1,130 $
3,670
6,990
11,660
2,100
6,770
8,020
1,420
3,090
9,440
1,980
3,010
5,930
E
11,610
20,630
3,470
arrow_forward
Data for the past two years for Behavior Corp. are:
20A
20B
Units produced
10,000
11,000
Overhead applied per unit
P15
P15
Actual overhead:
Fixed
50,000
55,000
Variable
95,000
150,000
Estimated overhead:
Fixed
50,000
56,000
Variable
130,000
142,000
The company determines overhead rates based on estimated units to be produced.
Required:
Determine the estimated units of production used to obtain the overhead allocation rates in 20A and 20B.
Determine the over- or underapplied factory overhead for each of the two years.
arrow_forward
Provide this question solution general accounting
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you


Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,

Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON

Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education
Related Questions
- Manufacturing Overhead Distribution Worksheet The following are selected operating data for the production and service departments of Bluestone Compa Departments Service Production Overhead costs (identified by department) $50.000 $1.032.000 $65,168 $2478.000 4.000 Indirect material S96.800 S164A00 Indirect labor $194400 $2.000 24.000 Square feet of building floor space used Assessed value of equipment used 9.600 14.400 $252.000 5420.000 264000 $.00 $126 000 176.000 Cubic yards of factory space used 400.600 102.400 Machine hours $40.000 s00.000 Direct labor O is allocated on the basis of square feet of floor space. Personal property taxes of $72,000 are allocated on the sbution worksheet for Bluestone Company similar to the one prepared for Exhibit 3-1s when appropriate Under the Allocation Basis column, select the basis used to calculate each alocationarrow_forwardAns plz accounting questionarrow_forwardPROBLEM I ABC Company's total overhead costs at various levels of activity are presented below: March April May June. Machine Hours Total Overhead Costs $216,800 $194,000 $239,600 $262,400 60,000 50,000 70,000 80,000 Assume that the overhead costs above consist of utilities, supervisory salaries, and maintenance. At the 50,000 machine-hour level of activity these costs are: Utilities (V). Supervisory salaries (F). Maintenance (M).. Total overhead cost V = Variable; F = Fixed; M = Mixed The company wants to break down the maintenance cost into its basic variable and fixed cost elements. Required: $ 54,000 62,000 78.000 $194.000 a. Estimate the maintenance cost for June. b. Use the high-low method to estimate the cost formula for maintenance cost. c. Estimate the total overhead cost at an activity level of 55,000 machine hours.arrow_forward
- EstimatedFixedCost EstimatedVariableCost(perunitsold) Production costs: Direct materials $19 Direct labor 13 Factory overhead $261,300 10 Selling expenses: Sales salaries and commissions 54,300 4 Advertising 18,400 Travel 4,100 Miscellaneous selling expense 4,500 4 Administrative expenses: Office and officers' salaries 53,100 Supplies 6,500 2 Miscellaneous administrative expense 6,040 2 Total $408,240 $54 It is expected that 8,640 units will be sold at a price of $135 a unit. Maximum sales within the relevant range are 11,000 units. Required: Question Content Area 1. Prepare an estimated income statement for 20Y7. Belmain Co.Estimated Income StatementFor the Year Ended December 31, 20Y7 $- Select - Cost of goods sold: $- Select - - Select - - Select -…arrow_forwardAccounting questionarrow_forwardDirect labor cost Factory overhead Direct labor hours Machine hours Dept. A $ 69,000 $115,920 Dept. B $49,000 $54,855 6,900 2,900 9,900 15,900 of the year, the company made the following What predetermined overhead rate would be used in Department A and Department B, respectively? Multiple Choice 168% and 345%. 168% and $3.45. ) $1.68 and 345%. $1.68 and $3.45.arrow_forward
- Direct labor 17 per unit 11 per unit 24 Direct materials $4 Overhead Total variable overhead Total fixed overhead Expected units to be produced $ 30,000 $100, 000 50,e00 units Product cost per unit under absorption costingarrow_forwardSub: accounting 14arrow_forwardGeneral Accounting questionarrow_forward
- First-stage allocation of overhead costs to the activity cost pools: Overhead costs Installing floors Job Support Other Total Production overhead 76,000 76,000 38,000 190,000 (190000*40%) (190000*40%) (190000*20%) Office expense 14,000 (140000*10%) 84,000 (140000*60%) 42,000 140,000 (140000*30%) Total 90,000 160,000 80,000 330,000 Determination of Activity rates: Overhead costs Installing floors Job support Total activity Activity rate Overhead $ (A) (B) (A/B) 90,000 200 450 Per square 160,000 160 1,000 Per Job Determination of Overhead costs based on activity rates for Job of 3.4 squares: Overhead costs Installing floors Job support Activity Overhead Activity rate (A) consumed by allocated (A*B) Job (B) 450 3.40 1,530 1,000 1.00 1,000 Total overhead cost 2,530arrow_forward1 Manufacturing Overhead Distribution Worksheet The following are selected operating data for 2 the production and service departments of Bluestone Company for 2019 3 Departments Service Production 4 1 2 1 2 6 Overhead costs (identified by department) $ 48,400 82,200 25,440 516,000 32,584 $1,439,000 Indirect materials 7 $97,200 $144,000 Indirect labor 8 7,200 9 Square feet of building floor space used 10 Assessed value of equipment used 11 Cubic yards of factory space used 4,800 24,000 12,000 $ 21,000 63,000 126,000 210,000 88,000 132,000 12arrow_forwardEstimated manufacturing overhead Estimated direct labor cost Actual manufacturing overhead Actual direct labor cost $500,000 $250,000 $720,000 $300,000 Based on this information, the predetermined overhead rate per direct labor dollar isarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- AccountingAccountingISBN:9781337272094Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.Publisher:Cengage Learning,Accounting Information SystemsAccountingISBN:9781337619202Author:Hall, James A.Publisher:Cengage Learning,
- Horngren's Cost Accounting: A Managerial Emphasis...AccountingISBN:9780134475585Author:Srikant M. Datar, Madhav V. RajanPublisher:PEARSONIntermediate AccountingAccountingISBN:9781259722660Author:J. David Spiceland, Mark W. Nelson, Wayne M ThomasPublisher:McGraw-Hill EducationFinancial and Managerial AccountingAccountingISBN:9781259726705Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting PrinciplesPublisher:McGraw-Hill Education


Accounting
Accounting
ISBN:9781337272094
Author:WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:Cengage Learning,

Accounting Information Systems
Accounting
ISBN:9781337619202
Author:Hall, James A.
Publisher:Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis...
Accounting
ISBN:9780134475585
Author:Srikant M. Datar, Madhav V. Rajan
Publisher:PEARSON

Intermediate Accounting
Accounting
ISBN:9781259722660
Author:J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:McGraw-Hill Education

Financial and Managerial Accounting
Accounting
ISBN:9781259726705
Author:John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:McGraw-Hill Education