A local picnic table manufacturer has budgeted these overhead costs - ERROR: "Handling materials" is $33,350 - (note their order as you will use the same order down below): Purchasing Handling materials Machine setups Inspections Utilities $70,000 33,333 70,500 25,500 45,000 They are considering adapting ABC costing and have estimated the cost drivers for each pool as shown (again, note their order): Cost Driver Activity Orders Material moves Machine setups Number of inspections Square feet 700 1,334 15,000 5,000 180,000 Recent success has yielded an order for 1,000 tables. Assume direct labor costs per hour of $20. Determine how much the job would cost given the following activities (once more, note their order for the last worksheet): Activity Order (units) Direct materials 1,000 112,700 15,200 5,300 60 Machine hours Direct labor hours Number of purchase orders Number of material moves Number of machine setups Number of inspections Number of square feet occupied 800 100 450 8,000

FINANCIAL ACCOUNTING
10th Edition
ISBN:9781259964947
Author:Libby
Publisher:Libby
Chapter1: Financial Statements And Business Decisions
Section: Chapter Questions
Problem 1Q
icon
Related questions
icon
Concept explainers
Topic Video
Question

A local picnic table manufacturer has budgeted these overhead costs - ERROR: "Handling materials" is $33,350 - (note their order as you will use the same order down below):

 

They are considering adapting ABC costing and have estimated the cost drivers for each pool as shown (again, note their order):

 

Recent success has yielded an order for 1,000 tables. Assume direct labor costs per hour of $20. Determine how much the job would cost given the following activities (once more, note their order for the last worksheet):

 

Using the following cost driver terms, complete the two worksheets below to: 

Number of material moves Direct labor Manufacturing overhead Number of purchase orders
Number of machine setups Number of inspections Direct materials Square feet occupied

PLEASE NOTE: For activity levels, use commas as needed (i.e. 1,234). Activity rates are rounded to two decimal places and shown with "$" and commas as needed (i.e. $1,234.56). All other dollar amounts are rounded to whole dollars and shown with "$" and commas as needed (i.e. $12,345).

(1) calculate the overhead assigned rate (note their order from above):

Overhead Cost Items Estimated Overhead Cost Driver Activity Levels Activity Rate

Purchasing

$70,000      
Handling materials $33,350      

Machine setups

$70,500      

Inspections

$25,500      

Utilities

$45,000      

(2) calculate the total order cost (again, note their order from above):

Activity Cost Drivers Activity Levels Activity Rate Assigned Costs
       
       
       
       
       
       
       
Total Order Cost      

Please fill in the chart as shown with terms provided

A local picnic table manufacturer has budgeted these overhead costs - ERROR: "Handling materials" is $33,350 - (note their order as you will use the same order down
below):
$70,000
Purchasing
Handling materials
Machine setups
Inspections
Utilities
33,333
70,500
25,500
45,000
They are considering adapting ABC costing and have estimated the cost drivers for each pool as shown (again, note their order):
Cost Driver
Activity
Orders
Material moves
Machine setups
Number of inspections
Square feet
700
1,334
15,000
5,000
180,000
Recent success has yielded an order for 1,000 tables. Assume direct labor costs per hour of $20. Determine how much the job would cost given the following activities
(once more, note their order for the last worksheet):
Activity
1,000
112,700
15,200
Order (units)
Direct materials
Machine hours
Direct labor hours
Number of purchase orders
Number of material moves
Number of machine setups
Number of inspections
Number of square feet occupied
5,300
60
800
100
450
8,000
Transcribed Image Text:A local picnic table manufacturer has budgeted these overhead costs - ERROR: "Handling materials" is $33,350 - (note their order as you will use the same order down below): $70,000 Purchasing Handling materials Machine setups Inspections Utilities 33,333 70,500 25,500 45,000 They are considering adapting ABC costing and have estimated the cost drivers for each pool as shown (again, note their order): Cost Driver Activity Orders Material moves Machine setups Number of inspections Square feet 700 1,334 15,000 5,000 180,000 Recent success has yielded an order for 1,000 tables. Assume direct labor costs per hour of $20. Determine how much the job would cost given the following activities (once more, note their order for the last worksheet): Activity 1,000 112,700 15,200 Order (units) Direct materials Machine hours Direct labor hours Number of purchase orders Number of material moves Number of machine setups Number of inspections Number of square feet occupied 5,300 60 800 100 450 8,000
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
Recommended textbooks for you
FINANCIAL ACCOUNTING
FINANCIAL ACCOUNTING
Accounting
ISBN:
9781259964947
Author:
Libby
Publisher:
MCG
Accounting
Accounting
Accounting
ISBN:
9781337272094
Author:
WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.
Publisher:
Cengage Learning,
Accounting Information Systems
Accounting Information Systems
Accounting
ISBN:
9781337619202
Author:
Hall, James A.
Publisher:
Cengage Learning,
Horngren's Cost Accounting: A Managerial Emphasis…
Horngren's Cost Accounting: A Managerial Emphasis…
Accounting
ISBN:
9780134475585
Author:
Srikant M. Datar, Madhav V. Rajan
Publisher:
PEARSON
Intermediate Accounting
Intermediate Accounting
Accounting
ISBN:
9781259722660
Author:
J. David Spiceland, Mark W. Nelson, Wayne M Thomas
Publisher:
McGraw-Hill Education
Financial and Managerial Accounting
Financial and Managerial Accounting
Accounting
ISBN:
9781259726705
Author:
John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles
Publisher:
McGraw-Hill Education