Product costs using activity rates Hercules Inc. manufactures elliptical exercise machines and treadmills. The products are produced in its Fabrication and Assembly production departments. In addition to production activities, several other activities are required to produce the two products. These activities and their associated activity rates are as follows: Activity Activity Rate Fabrication $32 per machine hour Assembly $34 per direct labor hour Setup $86 per setup Inspecting $24 per inspection Production scheduling $23 per production order Purchasing $14 per purchase order The activity-base usage quantities and units produced for each product were as follows: Activity Base Elliptical Machines Treadmill Machine hours 650   450   Direct labor hours 192   257   Setups 37   37   Inspections 31   38   Production orders 30   20   Purchase orders 318   93   Units produced 530   420   This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below.     Open spreadsheet   Use the activity rate and usage information to calculate the total activity cost and activity cost per unit for each product. If required, round the per unit answers to the nearest cent.   Total Activity Cost Activity Cost Per Unit Elliptical Machines $fill in the blank 2 $fill in the blank 3 Treadmill $fill in the blank 4 $fill in the blank 5

Managerial Accounting
15th Edition
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:Carl Warren, Ph.d. Cma William B. Tayler
Chapter4: Activity-based Costing
Section: Chapter Questions
Problem 10E: Hercules Inc. manufactures elliptical exercise machines and treadmills. The products are produced in...
icon
Related questions
icon
Concept explainers
Topic Video
Question

Product costs using activity rates

Hercules Inc. manufactures elliptical exercise machines and treadmills. The products are produced in its Fabrication and Assembly production departments. In addition to production activities, several other activities are required to produce the two products. These activities and their associated activity rates are as follows:

Activity Activity Rate
Fabrication $32 per machine hour
Assembly $34 per direct labor hour
Setup $86 per setup
Inspecting $24 per inspection
Production scheduling $23 per production order
Purchasing $14 per purchase order

The activity-base usage quantities and units produced for each product were as follows:

Activity Base Elliptical Machines Treadmill
Machine hours 650   450  
Direct labor hours 192   257  
Setups 37   37  
Inspections 31   38  
Production orders 30   20  
Purchase orders 318   93  
Units produced 530   420  

This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the question below.

 

 
Open spreadsheet

 

Use the activity rate and usage information to calculate the total activity cost and activity cost per unit for each product. If required, round the per unit answers to the nearest cent.

  Total Activity Cost Activity Cost Per Unit
Elliptical Machines $fill in the blank 2 $fill in the blank 3
Treadmill $fill in the blank 4 $fill in the blank 5
A
B
C
D
F
Product costs using activity rates
2
Hercules Inc. manufactures elliptical exercise machines and treadmills. The products are produced in its Fabrication and Assembly production
departments. In addition to production activities, several other activities are required to produce the two products. These activities and their associated
3 activity rates are as follows:
4
DATA
Activity Rate
6 Activity
7 Fabrication
8 Assembly
Setup
10 Inspecting
11 Production scheduling
12 Purchasig
32 per machine hour
34
hour
9
86 per setup
24 per inspection
23 per production order
14 per purchase order
13
14 The activity-base usage quantities and units produced for each product were as follows:
15
16
DATA
17 Activity Base
Treadmill
Elliptical Machines
650
18 Machine hours
450
19 Direct labor hours
20 Setups
21 Inspections
22 Production orders
192
257
37
37
31
38
30
20
23 Purchase orders
318
93
24 Units produced
25
530
420
Using formulas and cell references, perform the required analysis, and input your answers into Total Activity Cost and Activity Cost Per Unit columns.
26 Transfer the numeric results for the green entry cells (C29:D30) into the appropriate fields in CNOWV2 for grading.
27
28
Total Activity Cost
Activity Cost Per Unit
Formulas
29 Elliptical Machines
30 Treadmill
31
32
33
Transcribed Image Text:A B C D F Product costs using activity rates 2 Hercules Inc. manufactures elliptical exercise machines and treadmills. The products are produced in its Fabrication and Assembly production departments. In addition to production activities, several other activities are required to produce the two products. These activities and their associated 3 activity rates are as follows: 4 DATA Activity Rate 6 Activity 7 Fabrication 8 Assembly Setup 10 Inspecting 11 Production scheduling 12 Purchasig 32 per machine hour 34 hour 9 86 per setup 24 per inspection 23 per production order 14 per purchase order 13 14 The activity-base usage quantities and units produced for each product were as follows: 15 16 DATA 17 Activity Base Treadmill Elliptical Machines 650 18 Machine hours 450 19 Direct labor hours 20 Setups 21 Inspections 22 Production orders 192 257 37 37 31 38 30 20 23 Purchase orders 318 93 24 Units produced 25 530 420 Using formulas and cell references, perform the required analysis, and input your answers into Total Activity Cost and Activity Cost Per Unit columns. 26 Transfer the numeric results for the green entry cells (C29:D30) into the appropriate fields in CNOWV2 for grading. 27 28 Total Activity Cost Activity Cost Per Unit Formulas 29 Elliptical Machines 30 Treadmill 31 32 33
Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 2 steps

Blurred answer
Knowledge Booster
Costing Systems
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Managerial Accounting
Managerial Accounting
Accounting
ISBN:
9781337912020
Author:
Carl Warren, Ph.d. Cma William B. Tayler
Publisher:
South-Western College Pub
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
Managerial Accounting: The Cornerstone of Busines…
Managerial Accounting: The Cornerstone of Busines…
Accounting
ISBN:
9781337115773
Author:
Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:
Cengage Learning
Principles of Accounting Volume 2
Principles of Accounting Volume 2
Accounting
ISBN:
9781947172609
Author:
OpenStax
Publisher:
OpenStax College