Question
Shaker Stairs Co. designs and builds factory-made premium wooden stairways for homes. The manufactured stairway components (spindles, risers, hangers, hand rails) permit installation of stairways
Shaker Stairs Co. designs and builds factory-made premium wooden stairways for homes. The manufactured stairway components (spindles, risers, hangers, hand rails) permit installation of stairways of varying lengths and widths. All are of white oak wood. Budgeted manufacturing overhead costs for the year 2017 are as follows.
Overhead Cost Pools Amount
Purchasing 75,000
Handling materials 82,000
Production (cutting, milling, finishing) 210,000
Setting up machines 105,000
Inspecting 90,000
Inventory control (raw materials and finished goods) 126,000
Utilities 180,000
Total budgeted overhead costs $868,000
For the last 4 years, Shaker Stairs Co. has been charging overhead to products on the basis of machine hours. For the year 2017, 100,000 machine hours are budgeted.
Jeremy Nolan, owner-manager of Shaker Stairs Co., recently directed his accountant, Bill Seagren, to implement the activity-based costing system that he has repeatedly proposed. At Jeremy Nolan's request, Bill and the production foreman identify the following cost drivers and their usage for the previously budgeted overhead cost pools.
Activity Cost Pools/Cost Drivers/Expected Use of Cost Drivers
Purchasing/Number of orders/600
Handling materials/Number of moves/8,000
Production (cutting, milling, finishing)/Direct labor hours/100,000
Setting up machines/Number of setups/1,250
Inspecting/Number of inspections/6,000
Inventory control (raw materials and finished goods)/Number of components/168,000
Utilities/Square feet occupied/90,000
Steve Hannon, sales manager, has received an order for 250 stairways from Community Builders, Inc., a large housing development contractor. At Steve's request, Bill prepares cost estimates for producing components for 250 stairways so Steve can submit a contract price per stairway to Community Builders. He accumulates the following data for the production of 250 stairways.
Direct materials $103,600
Direct labor $112,000
Machine hours 14,500
Direct labor hours 5,000
Number of purchase orders 60
Number of material moves 800
Number of machine setups 100
Number of inspections 450
Number of components 16,000
Number of square feet occupied 8,000
Instructions: Please fill out tables below
(c) What is the manufacturing cost per stairway under the proposed activity-based costing? (Round to the nearest cent. Prepare all of the necessary schedules.)
activity cost pool | total estimated overhead | total est'd drivers | total est'd drivers | activity based overhead | activity based overhead |
Number | Driver | Rate | Per | ||
Purchasing | |||||
Handling materials | |||||
Production | |||||
Setting up machines | |||||
inspecting | |||||
inventory control | |||||
utilities | |||||
total |
ASSIGNMENT OF OVERHEAD TO ORDER OF 250 STAIRWAYS
activity cost pool | expected used of driver | expected used of driver | activity based overhead rate | cost assigned |
Number | Driver | |||
Purchasing | ||||
Handling materials | ||||
Production | ||||
Setting up machines | ||||
Inspecting | ||||
Inventory Control | ||||
Utilities | ||||
Total overhead assigned |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started