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 - EssayAbode

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

Related Tags

Academic APA Assignment Business Capstone College Conclusion Course Day Discussion Double Spaced Essay English Finance General Graduate History Information Justify Literature Management Market Masters Math Minimum MLA Nursing Organizational Outline Pages Paper Presentation Questions Questionnaire Reference Response Response School Subject Slides Sources Student Support Times New Roman Title Topics Word Write Writing