Hansen_4e_Ex04-22 example worked
.xlsx
keyboard_arrow_up
School
american national university *
*We aren’t endorsed by this school
Course
ACC203
Subject
Accounting
Date
Apr 3, 2024
Type
xlsx
Pages
3
Uploaded by kagordon192648
Exercise 4.22
Name:
example
Enter appropriate answers in the gray-shaded cells. The essay answer will not be graded.
1.
Activity Rates
Total Cost
Activity Capacity
Activity Rate
Setting up equipment
$126,000
÷
150
=
$840
per setup
Ordering materials
$18,000
÷
900
=
$20
per order
Machining
$126,000
÷
10,500
=
$12
per machin
Receiving
$30,000
÷
1,250
=
$24
per receivin
Overhead Cost Assignment
Activity
Activity
Rate
×
Usage
Model X
Model Y
Setting up equipment:
Model X
$840
×
100
$ 84,000 Model Y
$840
×
50
$ 42,000 Ordering materials:
Model X
$20
×
300
6,000 Model Y
$20
×
600
12,000 Machining:
Model X
$12
×
6,000
72,000 Model Y
$12
×
4,500
54,000 Receiving:
Model X
$24
×
375
9,000 Model Y
$24
×
875
21,000 Total OH assigned
$ 171,000 $ 129,000 2.
New Cost Pools
+
=
Setting up equipment
$126,000
+
$24,000
=
$150,000
Machining
$126,000
+
$24,000
=
$150,000
New Activity Rates
Total Cost
Activity Capacity
Activity Rate
Setting up equipment
$150,000
÷
150
=
$1,000
per setup
Machining
$150,000
÷
10,500
=
$14.29
per hour
Overhead Cost Assignment
Model X
Model Y
Setting up equipment:
$1,000
×
100
$ 100,000 Total Cost
Proration of Least Expensive Activities
New Cost Pool
$1,000
×
50
$ 50,000 Machining:
$14.29
×
6,000
85,740
$14.29
×
4,500
64,305
Total
$185,740
$114,305
3.
Percentage Error
Model X
Model Y
Overhead cost assignment from (1)
$ 185,740 $ 114,305 Overhead cost assignment from (2)
171,000 129,000 Difference
$ 14,740 $ (14,695)
÷ Overhead cost assignment from (1)
171,000 129,000 Percentage error
8.6%
-11.4%
[Key essay answer here]
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
Related Questions
Please do not give solution in image format thanku
arrow_forward
Please do not give solution in image format thanku
arrow_forward
-/1
Question 12
View Policies
Current Attempt in Progress
Thomsen Computer Company produces three products:
Earth, Wind, and Fire. Earth requires 80 machine setups,
Wind requires 60 setups, and Fire requires 180 setups.
Thomsen has identified an activity cost pool with allocated
overhead of $1500000 for which the cost driver is machine
setups. How much overhead is assigned to each product?
Fire
Wind
Earth
$843750
$281250
$375000
$234375
$703125
$312500
$500000
$500000
$500000
$281250
$500000
$718750
arrow_forward
stion 2: Allocating costs using ABC
have an ABC system with three pools
pol 1
pol 2
pol 3
total cost in the pool
$80,000
$60,000
$40,000
$
bol 1
per DL$
bol 2
per setup
pol 3
per hour
total allocated costs for each product
product A
4,000 DL$
pute the activity rates and the allocated costs for products A and B.
activity rate
allocated costs for
product A
$
20 setups
50 hours
$
$
$
+A
number of cost driver units
product B
6,000 DL$
30 setups
150 hours
$
allocated costs for
product B
$
LA
$
$
tA
total
10,000 DL$
50 setups
200 hours
$
arrow_forward
Please do not give solution in image format thanku
arrow_forward
A1
arrow_forward
B4
arrow_forward
ngageNOWv2 | Online teachin X +
om/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSession Locator=&inprogress...
€
Compute conversion costs given the following data: direct materials, $363,600; direct labor, $192,400; factory overhead, $204,500 and
selling expenses, $35,600.
Oa. $396,900
Ob. $568.100
Oc. $168,900
Od. $760,500
8
5/2
arrow_forward
Please do not give solution in image format thanku
arrow_forward
I need help with last three requirement
I need help with last three requirement
I need help with last three requirement
please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image)
arrow_forward
Info in images
Answer choices for Q1
a. $46,154
b. $29,970
c. $11,988
d. $41,958
arrow_forward
Task 2: CLO4
OBJECTIVE: To enable learners to identify the relevant costs and benefits from costs and revenue
information available in the financial database to aid decision making on time.
REQUIREMENT: Short term decision making
Question
Selma Corporation uses Part PB7 in one of its products. The company's Accounting Department reports the
following costs to produce 7,000 units of the PB7 that are needed every year.
$ per unit
Direct materials
7.00
Direct labour
6.00
Variable overhead
5.60
Supervisor's salary
Depreciation of special equipment
Allocated general overhead
4.70
1.50
5.40
An outside supplier has offered to make the part and sell it to the company for $28.30 each. If this offer is
accepted, the supervisor's salary and all of the variable costs, including direct labor, can be avoided. The
special equipment used to make the part was purchased many years ago and has no salvage value or other
use. The allocated general overhead represents fixed costs of the entire company. If…
arrow_forward
Activity Cost Pool
Cost Driver
EstimatedOverhead
Use perProduct A
Use perProduct B
Machine Setups
Setups
$144,000
6,000
2,000
Assembly
Number of Parts
71,000
25,000
46,000
Machine Maintenance
Machine Hours
200,000
13,000
37,000
Compare the overhead allocation using (A) the traditional allocation method and (B) the activity-based costing method. (Hint: the traditional method uses machine hours as the allocation base.) For those boxes in which you must enter subtractive or negative numbers use a minus sign.
arrow_forward
Please do not give solution in image format thanku
arrow_forward
I need help
arrow_forward
Q.
arrow_forward
Assignment 7.1: Session 7 Comprehensive Problem (Chapter 9)
Instructions
This section has a nine-part comprehensive problem with multiple questions to address. Download the Chapter 9 Comprehensive Problem Template below to complete all parts. You will need your Bergevin and MacQueen book for reference.
Redlands Inc. reported standard and actual costs for the product that it manufactures:
Item
Standard
Actual
Direct material price
$3 per lb.
$2 per lb.
Direct materials quantity
2 lbs.
4 lbs.
Direct labor price
$5
$7
Direct labor quantity
3 hours
2 hours
Factory overhead cost
$2 per machine hour
----
Machine hours per unit
2 machine hours
3 machine hours
Number of finished products made
10
12
Number of finished products sold
10
11
Sales per unit
$40
$40
* Redlands used machine hours to apply factory overhead costs. The company incurred $90 actual total factory overhead costs to make the 12 products.
Based on the information above, complete the following:
1.…
arrow_forward
Please do not give solution in image format thanku
arrow_forward
Assignment 7.1: Session 7 Comprehensive Problem (Chapter 9)
This section has a nine-part comprehensive problem with multiple questions to address. Download the Chapter 9 Comprehensive Problem Template below to complete all parts. You will need your Bergevin and MacQueen book for reference.
Redlands Inc. reported standard and actual costs for the product that it manufactures:
Item
Standard
Actual
Direct material price
$3 per lb.
$2 per lb.
Direct materials quantity
2 lbs.
4 lbs.
Direct labor price
$5
$7
Direct labor quantity
3 hours
2 hours
Factory overhead cost
$2 per machine hour
----
Machine hours per unit
2 machine hours
3 machine hours
Number of finished products made
10
12
Number of finished products sold
10
11
Sales per unit
$40
$40
* Redlands used machine hours to apply factory overhead costs. The company incurred $90 actual total factory overhead costs to make the 12 products.
1. Standard product cost
Item
Price
Quantity
Total
Direct materials…
arrow_forward
Question 4: A plant manager considers the operational cost per hour of five machine alternatives. The cost per hour
is sensitive to three potential weather conditions: cold, mild, and warm. The following table represents
the operations cost per hour for each alternative-state of nature combination:
States of Nature
Weather-related cost per hour
Mild cost/day
Alternatives
Cold
cost/day
$42
$45
$40
$60
Warm
Machine 1
Machine 2
Machine 3
Machine 4
Machine 5
$40
$42
$35
$30
cost/day
$45
$47
$54
$48
$45
$40
$45
Using the optimistic criterion, which alternative is best?
arrow_forward
B
NOWv2 | Online teachir X +
ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSession Locator=&inprogress...
Ⓒ
Thomlin Company forecasts that total factory overhead for the current year will be $17,280,000 with 180,000 total machine hours. Year to
date, the actual overhead is $8,220,000, and the actual machine hours are 82,200 hours. If Thomlin Company uses a predetermined
factory overhead rate based on machine hours for applying overhead, as of this point in time (year to date), the overhead is
a. $328,800 underapplied
Ob. $391,200 overapplied
Oc. $328,800 overapplied
Od. $391,200 underapplied
8:15 A
5/2/202
H
U
a
1
C
arrow_forward
Chapter 12: Applying Excel: Exercise (Part 2 of 2) (Algo)
2. The company is considering a project involving the purchase of new equipment. Change the data area of your worksheet to match
the following: Use Exhibit 128-1 and Exhibit 128-2. (Use appropriate factor(s) from the tables provided.)
A
B.
Chapter 12: Applying Excel
2
Data
4
Example E
Cost of equipment needed
430,000
45,000
35,000
20,000
6.
Working capital needed
Overhaul of equipment in four years
8.
Salvage value of the equipment in five years
$4
9.
Annual revenues and costs:
435,000
10
Sales revenues
11
Cost of goods sold
245,000
Out-of-pocket operating costs
%24
50,000
12
13
Discount rate
17 %
arrow_forward
Please do not give solution in image format thanku
arrow_forward
Question 3 of 7
Cost Pool
Product assembly
Machine setup and calibration
Product inspection
Raw materials storage
Overhead rate
ype here to search
Expected Cost
$
595,000
336.600
IT
64,860
56,000
(a) Calculate the company's traditional overhead rate based on machine hours.
$ 1,052,460
Expected Activities
42,500 machine hours
5,100 setups
1,410 batches
280,000 pounds
/MH
Address
arrow_forward
Assignment 7.1: Session 7 Comprehensive Problem (Chapter 9)
Instructions
This section has a nine-part comprehensive problem with multiple questions to address. Download the Chapter 9 Comprehensive Problem Template below to complete all parts. You will need your Bergevin and MacQueen book for reference.
Item
Standard
Actual
Direct material price
$3 per lb.
$2 per lb.
Direct materials quantity
2 lbs.
4 lbs.
Direct labor price
$5
$7
Direct labor quantity
3 hours
2 hours
Factory overhead cost
$2 per machine hour
----
Machine hours per unit
2 machine hours
3 machine hours
Number of finished products made
10
12
Number of finished products sold
10
11
Sales per unit
$40
$40
Redlands Inc. reported standard and actual costs for the product that it manufactures:
Based on the information above, complete the following:
1. Standard product cost (This section was completed)
2. Forecast income statement through gross profit(This section was completed)
3. Direct Materials…
arrow_forward
Assignment 7.1: Session 7 Comprehensive Problem (Chapter 9)
Instructions
This section has a nine-part comprehensive problem with multiple questions to address. Download the Chapter 9 Comprehensive Problem Template below to complete all parts. You will need your Bergevin and MacQueen book for reference.
Item
Standard
Actual
Direct material price
$3 per lb.
$2 per lb.
Direct materials quantity
2 lbs.
4 lbs.
Direct labor price
$5
$7
Direct labor quantity
3 hours
2 hours
Factory overhead cost
$2 per machine hour
----
Machine hours per unit
2 machine hours
3 machine hours
Number of finished products made
10
12
Number of finished products sold
10
11
Sales per unit
$40
$40
Redlands Inc. reported standard and actual costs for the product that it manufactures:
Based on the information above, complete the following:
1. Standard product cost (This section was completed)
2. Forecast income statement through gross profit(This section was completed)
3. Direct Materials…
arrow_forward
Question 7 of 7
Activity Cost Pool
Loading and unloading
Travel
Logistics
(a)
Activity Cost Pool
Loading and unloading
Travel
Cost Drivers
Logistics
Number of pieces
Miles driven
Hours
Compute the activity-based overhead rates for each pool. (Round answers to 2 decimal places, e.g. 12.75.)
Activity-Based
Overhead Rate
$
Estimated
Overhead
$95,655
453,750
86,240
$
Estimated Use of
Cost Driver
per Activity
per piece
per mile
91,100
605,000
3,080
per hour
arrow_forward
Solve Required 1 Only
arrow_forward
MI
* 00
關
%24
因
%24
%24
44
%#3
SI
Homework
Exercise 11-31 (Algo) Cost Allocation: Step Method (LO 11-3)
University Printers has two service departments (Maintenance and Personnel) and two operating departments (Printing and
Developing). Management has decided to allocate maintenance costs on the basis of machine-hours in each department and
personnel costs on the basis of labor-hours worked by the employees in each.
eBook
The following data appear in the company records for the current period:
Print
Maintenance
Printing
Developing
4,200
3,100
$11,700
Personnel
Machine-hours
1,400
References
Labor-hours
006
$14,500
006
Department direct costs
$12,800
008
Required:
Allocate the service department costs using the step method, starting with the Maintenance Department (Negative amounts should
be indicated by a minus sign. Do not round intermediate calculations.)
Maintenance
Personnel
Developing
Service department costs
24
(2,800)
12,800
Maintenance
099
(13,360)
Personnel
Total costs…
arrow_forward
New
arrow_forward
Please do not give solution in image format thanku
arrow_forward
A ezto.mheducation.com
tte.edu
S Module 2- Video Lecture: Fundamentals.
Assignments: 202180-Fall 2021-ACCT-2
M Question 1- Chapter 2 Lab Day - Connect
2 Lab Day i
Saved
Hel
Direct labor-hours
Machine-hours
Total fixed manufacturing overhead cost
Variable manufacturing overhead per machine-hour
Variable manufacturing overhead per direct labor-hour
Department
Cutting
6,700
64,300
$ 390,000
$ 3.00
Finishing
61,000
3,000
$ 514,000
$ 4.75
Required:
1. Compute the predetermined overhead rate for each department.
2. The job cost sheet for Job 203, which was started and completed during the year, showed the following:
Department
Cutting
Finishing
Direct labor-hours
Machine-hours
Direct materials
Direct labor cost
3
82
ces
16
$ 760
$ 69
4
$ 390
$ 368
Using the predetermined overhead rates that you computed in requirement (1), compute the total manufacturing cost assigned to Job
203.
3. Would you expect substantially different amounts of overhead cost to be assigned to some jobs if the company…
arrow_forward
1
2
3
4
5
6
7
8
Chapter 3: Applying Excel
Data
Allocation base
Machine-hours
Estimated manufacturing overhead cost
$416,000
Estimated total amount of the allocation base
64,000
machine-hours
Actual manufacturing overhead cost
$403,800
Actual total amount of the allocation base
69,000
machine-hours
If your formulas are correct, you should get the correct answers to the following questions.
(a) What is the Predetermined overhead rate? (Round your answer to 2 decimal places.)
(b) By how much is the manufacturing overhead underapplied or overapplied?
Change the estimated total amount of the allocation base to 65,000 machine-hours, but keep everything the same as in Requirement 2. The data area of your worksheet should now look like this:
1
2
3
4
5
6
7
8
Chapter 3: Applying Excel
Data
Allocation base
Machine-hours
Estimated manufacturing overhead cost
$416,000
Estimated total…
arrow_forward
CengageNOWv2 | Online teachin x
+
A v2.cengagenow.com/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSession. E *
Ch 20.2
Cost of Units Transferred Out and Ending Work in Process
The costs per equivalent unit of direct materials and conversion in the Filling Department of Ivy Cosmetics Company are $1.75 and
$1.85, respectively. The equivalent units to be assigned costs are as follows:
Equivalent Units
Direct Materials Conversion
Inventory in process, beginning of period
2,800
Started and completed during the period
46,000
46,000
Transferred out of Filling (completed)
46,000
48,800
Inventory in process, end of period
3,000
1,500
Total units to be assigned costs
49,000
50,300
The beginning work in process inventory had a cost of $1,570. Determine the cost of completed and transferred-out production and the
ending work in process inventory. If required, round to the nearest dollar.
Completed and transferred out of production
Inventory in process, ending
8,025
Feedback
V…
arrow_forward
Hello tutor solve this problem not use ai
arrow_forward
please answer both question or skip/leave attempt if you can answer both question with all working like explanation, computation, formula downvote if incomplet eor incorrect upvote if complete and correct answer in text
arrow_forward
Hi expart Provide correct answer
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
- Please do not give solution in image format thankuarrow_forwardPlease do not give solution in image format thankuarrow_forward-/1 Question 12 View Policies Current Attempt in Progress Thomsen Computer Company produces three products: Earth, Wind, and Fire. Earth requires 80 machine setups, Wind requires 60 setups, and Fire requires 180 setups. Thomsen has identified an activity cost pool with allocated overhead of $1500000 for which the cost driver is machine setups. How much overhead is assigned to each product? Fire Wind Earth $843750 $281250 $375000 $234375 $703125 $312500 $500000 $500000 $500000 $281250 $500000 $718750arrow_forward
- stion 2: Allocating costs using ABC have an ABC system with three pools pol 1 pol 2 pol 3 total cost in the pool $80,000 $60,000 $40,000 $ bol 1 per DL$ bol 2 per setup pol 3 per hour total allocated costs for each product product A 4,000 DL$ pute the activity rates and the allocated costs for products A and B. activity rate allocated costs for product A $ 20 setups 50 hours $ $ $ +A number of cost driver units product B 6,000 DL$ 30 setups 150 hours $ allocated costs for product B $ LA $ $ tA total 10,000 DL$ 50 setups 200 hours $arrow_forwardPlease do not give solution in image format thankuarrow_forwardA1arrow_forward
- B4arrow_forwardngageNOWv2 | Online teachin X + om/ilrn/takeAssignment/takeAssignmentMain.do?invoker=&takeAssignmentSession Locator=&inprogress... € Compute conversion costs given the following data: direct materials, $363,600; direct labor, $192,400; factory overhead, $204,500 and selling expenses, $35,600. Oa. $396,900 Ob. $568.100 Oc. $168,900 Od. $760,500 8 5/2arrow_forwardPlease do not give solution in image format thankuarrow_forward
- I need help with last three requirement I need help with last three requirement I need help with last three requirement please answer within the format by providing formula the detailed workingPlease provide answer in text (Without image)Please provide answer in text (Without image)Please provide answer in text (Without image)arrow_forwardInfo in images Answer choices for Q1 a. $46,154 b. $29,970 c. $11,988 d. $41,958arrow_forwardTask 2: CLO4 OBJECTIVE: To enable learners to identify the relevant costs and benefits from costs and revenue information available in the financial database to aid decision making on time. REQUIREMENT: Short term decision making Question Selma Corporation uses Part PB7 in one of its products. The company's Accounting Department reports the following costs to produce 7,000 units of the PB7 that are needed every year. $ per unit Direct materials 7.00 Direct labour 6.00 Variable overhead 5.60 Supervisor's salary Depreciation of special equipment Allocated general overhead 4.70 1.50 5.40 An outside supplier has offered to make the part and sell it to the company for $28.30 each. If this offer is accepted, the supervisor's salary and all of the variable costs, including direct labor, can be avoided. The special equipment used to make the part was purchased many years ago and has no salvage value or other use. The allocated general overhead represents fixed costs of the entire company. If…arrow_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