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
Register

05 Mar 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

Posted at 17:19h in Finance / Accounting by

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

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.

Do you need an answer to this or any other questions?