schaffer_BT7e_E4_23A_start_tutorial
xlsx
School
Kent State University *
*We aren’t endorsed by this school
Course
36085
Subject
Accounting
Date
Feb 20, 2024
Type
xlsx
Pages
5
Uploaded by LieutenantDinosaur3611
Activity-Based Costing, Lean Operations, and the Costs of Quality
Compute activity rates and apply to jobs
Activity
Allocation Base
Materials handling
$12,000 Number of parts
Machine setup
3,400 Number of setups
Insertion of parts
48,000 Number of parts
Finishing
80,000 Finishing direct labor hours
Total
$143,400 Parts
Setups
3,000 10 2,000 Parts Used
Job 420
200
2
130
Job 510
425
4
350
Use the blue shaded areas on the ENTERANSWERS tab for inputs.
Requirements
1 Compute the cost allocation rate for each activity.
2 Compute the manufacturing overhead cost that should be assigned to Job 420.
3 Compute the manufacturing overhead cost that should be assigned to Job 510.
Fuller Company uses ABC to account for its chrome wheel manufacturing process. Company managers have identified four manufacturing activities that incur manufacturing overhead costs: materials handling, machine setup, insertion of parts, and finishing. The budgeted activity costs for the upcoming year and their allocation bases are as follows:
Total Budgeted Manufacturing Overhead Cost
Fuller Company expects to produce 1,000 chrome wheels during the year. The wheels are expected to use:
Finishing Hours Consumed
Setups Required
Finishing Hours Consumed
Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong.
For help completing the requirements, watch the video walk through.
Saving & Submitting Solution
1
Save file to desktop.
a.
Create folder on desktop, and label COMPLETED EXCEL PROJECTS
2
Upload and submit your file to be graded.
a.
Navigate back to the activity window - screen where you downloaded the initial spreadsheet
b.
Click Choose button under step 3; locate the file you just saved and click Open
c.
Click Upload button under step 3
d.
Click Submit button under step 4
Viewing Results
1
Click on Results tab in MyAccountingLab
2
Click on the Assignment you were working on
3 Click on Project link; this will bring up your Score Summary
4 Within Score Summary window, click on Download (upper right) to download the spreadsheet wit
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
t
th feedback
1. Compute the cost allocation rate for each activity.
Fuller Company
Computation of Cost Allocation Rates
Activity
Materials handling
per part
Machine setup
per setup
Insertion of parts
per part
Finishing
per hour
2. Compute the manufacturing overhead cost that should be assigned to Job 420.
Job 420
Manufacturing overhead allocation
Activity
MOH assigned
Materials handling
Machine setup
Insertion of parts
Finishing
Total
3. Compute the manufacturing overhead cost that should be assigned to Job 510.
Job 510
Manufacturing overhead allocation
Activity
MOH assigned
Materials handling
Machine setup
Insertion of parts
Finishing
Total
(Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong.)
Activity Cost Allocation Rate
(Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong.)
(Always use cell references and formulas where appropriate to receive full credit. If you copy/paste from the Instructions tab or if you type the numbers in, you will be marked wrong.)
Related Documents
Related Questions
Carlise has identified the following information about its overhead activity pools and the two product lines:
Cost Assigned
to Pool
$ 20,910
$ 85,120
$ 34,790
Activity Pools
Materials handling
Quality control
Machine maintenance
Cost Driver
Number of moves
Number of inspections
Number of machine hours
Quantity or Amount Consumed by Quantity or Amount Consumed by
Indoor Line
Outdoor Line
Complete this question by entering your answers in the tabs below.
Indoor Model
Outdoor Model
Total
Required:
1. Suppose Carlise used a traditional costing system with machine hours as the cost driver. Determine the amount of
overhead assigned to each product line.
2. Calculate the activity proportions for each activity pool in Carlise's ABC system.
3. Calculate the amount of overhead that Carlise will assign to the Indoor line if it uses an ABC system.
4. Determine the amount of overhead Carlise will assign to the Outdoor line if it uses an ABC system.
5. Compare the results for a traditional system…
arrow_forward
Compute the cost that is assigned to the car wheels and truck wheels product lines using an activity-based costing system, given
the following information.
Use of Cost Drivers per Product
Number of setups
Direct labor hours
Number of inspections
Setting up machines
Assembling
Inspection
Total cost assigned
LA
LA
$
+A
Car
200
39,000
100
Truck
800
33,000
1,100
Car Wheels
ta
$
tA
$
Truck Wheels
arrow_forward
General accounting
arrow_forward
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
Please avoid solutions in an image format thanks
arrow_forward
How much overhead cost would be assigned to product
arrow_forward
Altex Inc. manufactures two products: car wheels and truck wheels. To determine the amount of overhead to assign to each product
line, the controller, Robert Hermann, has developed the following information.
Car
Truck
Estimated wheels produced
36,000
15,000
Direct labor hours per wheel
3
Total estimated overhead costs for the two product lines are $858,600.
Calculate overhead rate. (Round answer to 2 decimal places, e.g. 12.25.)
Overhead rate s
858600
per direct labor hour
eTextbook and Media
Compute the overhead cost assigned to the car wheels and truck wheels, assuming that direct labor hours is used to allocate
overhead costs.
Car wheels
36000
Truck wheels
45000
eTextbook and Media
Hermann is not satisfied with the traditional method of allocating overhead because he believes that most of the overhead costs
relate to the truck wheels product line because of its complexity. He therefore develops the following three activity cost pools
and related cost drivers to better understand…
arrow_forward
How much overhead cost would be assigned to product?
arrow_forward
Please explain proper steps by Step and Do Not Give Solution In Image Format ? And Fast Answering Please ?
arrow_forward
Rex Industries has identified three different activities as cost drivers: machine setups, machine hours, and inspections. The overhead and estimated usage are:
Compute the overhead rate for each activity. Round your answers to two decimal places.
Activity
Overheadper Activity
AnnualUsage
OverheadRate perActivity
Machine Setups
$156,825
4,100
$fill in the blank 1
Machine Hours
352,750
14,110
$fill in the blank 2
Inspections
110,550
3,300
$fill in the blank 3
arrow_forward
How much overhead cost?
arrow_forward
Comfort Foods Inc. uses activity-based costing to determine product costs. For each activity listed
in the left column, match an appropriate activity base from the right column. You may use items in
the activity-base list more than once or not at all.
Activity
Activity Base
Cafeteria
Engineering change orders
Customer return processing
Electric power
Kilowatt hours used
Number of customers
Human resources
Number of customer orders
Number of customer returns
Inventory control
Invoice and collecting
Machine depreciation
Materials handling
Order shipping
Payroll
Performance reports
Number of employees
Number of inspections
Number of inventory transactions
Number of machine hours
Number of material moves
Number of payroll checks processed
Number of performance reports
Number of production orders
Number of purchase orders
Production control
Production setup
Purchasing
Quality control
Sales order processing
Number of sales orders
Number of setups
arrow_forward
What's overhead cost?
arrow_forward
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
xterior door?
job-costing system. Total budgeted costs in each indirect-cost pool and the budgeted quantity of activity
The company is in the process of bidding on two jobs: Job 220, an order of 17 intricate personalized
overhead allocated under the current simple job-costing system and a newly designed activity-based
frames, and Job 330, an order of 5 standard personalized frames. The controller wants you to compare
5-29 Activity-based costing. The job-costing system at Melody's Custom Framing has five indirect
cost pools (purchasing, material handling, machine maintenance, product inspection, and packaging).
goods, milk and fruit juice, and frozen foods. It
upermarkets (FS) operates at capacity and de-
nformation from its activity-based costing system
Fes that account for the store support costs,
rs?
vs:
driver are as follows.
$95 per purchase order
$76 per delivery
$19 per hour
S 0.15 per item sold
Budgeted Quantity of
Activity Driver
TET
Budgeted Overhead
Activity Driver
Purchase…
arrow_forward
Carlise has identified the following information about its overhead activity pools and the two product lines:
Activity Pools
Materials handling
Quality control
Machine maintenance
Cost Driver
Number of moves
Number of inspections
Number of machine hours
Cost Assigned
to Pool
Indoor Model
$ 20,910
$ 85,120
$ 34,790
Materials Handling
Quality Control
Machine Maintenance
Total Overhead Assigned
Quantity or Amount Consumed by Quantity or Amount Consumed by
Indoor Line
Outdoor Line
Required:
1. Suppose Carlise used a traditional costing system with machine hours as the cost driver. Determine the amount of
overhead assigned to each product line.
Complete this question by entering your answers in the tabs below.
2. Calculate the activity proportions for each activity pool in Carlise's ABC system.
3. Calculate the amount of overhead that Carlise will assign to the Indoor line if it uses an ABC system.
4. Determine the amount of overhead Carlise will assign to the Outdoor line if it uses an ABC…
arrow_forward
Desjariais Corporation uses the following activity rates from its activity-based costing to assign overhead costs to products.
Activity Coat Pools
Setting up batches
Assembling products
Processing customer orders.
Data concerning two products appear below:
Number of batches
Number of assembly hours.
Number of customer orders
a. Product S96U
b. Product QO6F
Overhead cost
Activity Rate
$ 123.70 per batch
$ 7.32 per assembly hour
$ 59.76 per customer order
Product S960
36
192
23
Required:
a. How much overhead cost would be assigned to Product S96U using the company's activity-based costing system?
b. How much overhead cost would be assigned to Product Q06F using the company's activity-based costing system?
Note: Do not round intermediate calculations. Round your final answers to 2 decimal places.
Product 006F
45
870
42
arrow_forward
Forner, Inc., manufactures and sells two products: Product Z1 and Product Z8. The company has an activity-based costing system with the following activity cost pools, activity measures, and expected
activity
Estimated
Expected Activity
Activity
Overhead
Activity Cost Pools
Labor-related
Measures
Cost
Product Z1
Product Z8
Total
DLHS
$112,190
40,440
609,770
600
2,000
Machine setups
Оrder size
2,600
1,200
6, 200
setups
500
700
MHs
3,000
3,200
$762,400
The activity rate for the Machine Setups activity cost pool under activity-based costing is closest to:
Multiple Cholce
$203.26 per setup
$190.55 per setup
$122.97 per setup
92 F AQI 61
nere to search
DELL
arrow_forward
Subject: acounting
arrow_forward
I need help with accounting question
arrow_forward
Combat Fire, Inc. manufactures steel cylinders and nozzles for two models of fire extinguishers: (1) a home fire extinguisher and (2) a
commercial fire extinguisher. The home model is a high-volume (54.,000 units), half-gallon cylinder that holds 2 1/2 pounds of multi-
purpose dry chemical at 480 PSI. The commercial model is a low-volume (10,200 units), two-gallon cylinder that holds 10 pounds of
multi-purpose dry chemical at 390 PSI. Both products require 1.5 hours of direct labor for completion. Therefore, total annual direct
labor hours are 96,300 or (1.5 hours x (54,000 + 10,200)). Estimated annual manufacturing overhead is $ 1,585,316. Thus, the
predetermined overhead rate is $ 16.46 or (S 1,585,316 - 96,300) per direct labor hour. The direct materials cost per unit is $18.50
for the home model and $26.50 for the commercial model. The direct labor cost is $19 per unit for both the home and the
commercial models.
The company's managers identified six activity cost pools and related…
arrow_forward
Analyzing cost data, recording completion and sales of jobs
Clement Manufacturing makes carrying cases for portable electronic devices. Its costing records yield the following information:
Requirements
Which type of costing system is Clement using? What piece of data did you base your answer on?
Use the dates in the table to identify the status of each job at October 31 and November 50. Compute Clements account balances at October 31 for Work-in-Process Inventory, Finished Goods Inventory, and Cost of Goods Sold. Compute, by job, account balances at November 30 for Work-in-Process Inventory, Finished Goods Inventory, and Cost of Goods Sold.
Prepare journal entries to record the transfer of completed jobs from Work-in-Process Inventory to Finished Goods Inventory for October and November.
Record the sale of job 3 for $2,300 on account.
What is the gross profit for Job 3?
arrow_forward
SEE MORE QUESTIONS
Recommended textbooks for you

Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub

Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning
Related Questions
- Carlise has identified the following information about its overhead activity pools and the two product lines: Cost Assigned to Pool $ 20,910 $ 85,120 $ 34,790 Activity Pools Materials handling Quality control Machine maintenance Cost Driver Number of moves Number of inspections Number of machine hours Quantity or Amount Consumed by Quantity or Amount Consumed by Indoor Line Outdoor Line Complete this question by entering your answers in the tabs below. Indoor Model Outdoor Model Total Required: 1. Suppose Carlise used a traditional costing system with machine hours as the cost driver. Determine the amount of overhead assigned to each product line. 2. Calculate the activity proportions for each activity pool in Carlise's ABC system. 3. Calculate the amount of overhead that Carlise will assign to the Indoor line if it uses an ABC system. 4. Determine the amount of overhead Carlise will assign to the Outdoor line if it uses an ABC system. 5. Compare the results for a traditional system…arrow_forwardCompute the cost that is assigned to the car wheels and truck wheels product lines using an activity-based costing system, given the following information. Use of Cost Drivers per Product Number of setups Direct labor hours Number of inspections Setting up machines Assembling Inspection Total cost assigned LA LA $ +A Car 200 39,000 100 Truck 800 33,000 1,100 Car Wheels ta $ tA $ Truck Wheelsarrow_forwardGeneral accountingarrow_forward
- 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_forwardPlease avoid solutions in an image format thanksarrow_forwardHow much overhead cost would be assigned to productarrow_forward
- Altex Inc. manufactures two products: car wheels and truck wheels. To determine the amount of overhead to assign to each product line, the controller, Robert Hermann, has developed the following information. Car Truck Estimated wheels produced 36,000 15,000 Direct labor hours per wheel 3 Total estimated overhead costs for the two product lines are $858,600. Calculate overhead rate. (Round answer to 2 decimal places, e.g. 12.25.) Overhead rate s 858600 per direct labor hour eTextbook and Media Compute the overhead cost assigned to the car wheels and truck wheels, assuming that direct labor hours is used to allocate overhead costs. Car wheels 36000 Truck wheels 45000 eTextbook and Media Hermann is not satisfied with the traditional method of allocating overhead because he believes that most of the overhead costs relate to the truck wheels product line because of its complexity. He therefore develops the following three activity cost pools and related cost drivers to better understand…arrow_forwardHow much overhead cost would be assigned to product?arrow_forwardPlease explain proper steps by Step and Do Not Give Solution In Image Format ? And Fast Answering Please ?arrow_forward
- Rex Industries has identified three different activities as cost drivers: machine setups, machine hours, and inspections. The overhead and estimated usage are: Compute the overhead rate for each activity. Round your answers to two decimal places. Activity Overheadper Activity AnnualUsage OverheadRate perActivity Machine Setups $156,825 4,100 $fill in the blank 1 Machine Hours 352,750 14,110 $fill in the blank 2 Inspections 110,550 3,300 $fill in the blank 3arrow_forwardHow much overhead cost?arrow_forwardComfort Foods Inc. uses activity-based costing to determine product costs. For each activity listed in the left column, match an appropriate activity base from the right column. You may use items in the activity-base list more than once or not at all. Activity Activity Base Cafeteria Engineering change orders Customer return processing Electric power Kilowatt hours used Number of customers Human resources Number of customer orders Number of customer returns Inventory control Invoice and collecting Machine depreciation Materials handling Order shipping Payroll Performance reports Number of employees Number of inspections Number of inventory transactions Number of machine hours Number of material moves Number of payroll checks processed Number of performance reports Number of production orders Number of purchase orders Production control Production setup Purchasing Quality control Sales order processing Number of sales orders Number of setupsarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubPrinciples of Cost AccountingAccountingISBN:9781305087408Author:Edward J. Vanderbeck, Maria R. MitchellPublisher:Cengage LearningExcel Applications for Accounting PrinciplesAccountingISBN:9781111581565Author:Gaylord N. SmithPublisher:Cengage Learning

Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub

Principles of Cost Accounting
Accounting
ISBN:9781305087408
Author:Edward J. Vanderbeck, Maria R. Mitchell
Publisher:Cengage Learning

Excel Applications for Accounting Principles
Accounting
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Cengage Learning