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 $70,000 Handling Materials 33,333 Machine Setups 70,500 Inspections 25,500 Utilities 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 Activities Orders 700 Material moves 1,334 Machine Setups 15,000 Number of Inspections 5,000 Square Feet 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) 1,000 Direct Materials 112,700 Machine Hours 15,200 Director labor hours 5,300 Number of Purchase orders 60 Number of material moves 800 Number of machine setups 100 Number of Inspections 450 Number of Square Feet Occupied 8,000 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): Purchasing $70,000 Handling Materials 33,333 Machine Setups 70,500 Inspections 25,500 Utilities 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 Activities Orders 700 Material moves 1,334 Machine Setups 15,000 Number of Inspections 5,000 Square Feet 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) 1,000 Direct Materials 112,700 Machine Hours 15,200 Director labor hours 5,300 Number of Purchase orders 60 Number of material moves 800 Number of machine setups 100 Number of Inspections 450 Number of Square Feet Occupied 8,000 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

Principles of Accounting Volume 2

19th Edition

ISBN:9781947172609

Author:OpenStax

Publisher:OpenStax

Chapter6: Activity-based, Variable, And Absorption Costing

Section: Chapter Questions

Problem 3PA: A local picnic table manufacturer has budgeted these overhead costs: They are considering adapting...

See similar textbooks

Related questions

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):

Purchasing	$70,000
Handling Materials	33,333
Machine Setups	70,500
Inspections	25,500
Utilities	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	Activities
Orders	700
Material moves	1,334
Machine Setups	15,000
Number of Inspections	5,000
Square Feet	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)	1,000
Direct Materials	112,700
Machine Hours	15,200
Director labor hours	5,300
Number of Purchase orders	60
Number of material moves	800
Number of machine setups	100
Number of Inspections	450
Number of Square Feet Occupied	8,000

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