Chat with us, powered by LiveChat Create a spreadsheet just like the one in the book using the same labels – inputting the numbers given in the homework problem. Use the correct heading and for - NursingEssays

Create a spreadsheet just like the one in the book using the same labels – inputting the numbers given in the homework problem. Use the correct heading and for

Create a spreadsheet just like the one in the book using the same labels – inputting the numbers given in the homework problem. Use the correct heading and format for the problem assigned. Create one workbook with a worksheet for each problem.

PA  3. 

LO 6.2 A local picnic table manufacturer has budgeted these overhead costs:

Purchasing $70,000, Handling materials 33,333, Machine setups 70,500, Inspections 25,500, and Utilities 45,000.

They are considering adapting ABC costing and have estimated the cost drivers for each pool as shown:

Cost Drivers are: Orders, Material moves, Machine setups, Number of inspections, and Square feet. Activities are, respectively: 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:

Order (units) 1,000; Direct materials 112,700; Machine hours 15,200; Direct 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.

image1.jpeg

image2.jpeg

image3.jpeg

Are you struggling with this assignment?

Our team of qualified writers will write an original paper for you. Good grades guaranteed! Complete paper delivered straight to your email.

Place Order Now