Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

this is for cost management. I need help filling out this excel sheet. All the information that is need is in the first picture. What

this is for cost management. I need help filling out this excel sheet. All the information that is need is in the first picture. What needs to be filled out is in the second picture.

image text in transcribed

image text in transcribed

The ABC Company makes special order industrial grinding machines for customers from different parts/components. All of their labor is paid at a rate of $20 per hour and Factory Overhead is applied at a rate of 180% of Direct Labor Cost. The ABC Company has agreed to make a special order grinding machine for the XYZ Company by December 1, 2014, work will begin on the grinder on November 3 and end on November 7. It is your job to fill in ABC Company's Job Cost Sheet for job number 781 for XYZ Company's grinding machine using this information and the information provided below: The grinder will require four types of components/parts - one base unit, 2 grinding heads, safety shields, and a control panel. The requistion numbers and dates for the parts are as follows: November 3 - Material Requisition #R-404, 1 base unit @ $16,000 each. November 4 - Material Requisition #R-405, 1 set of safety shields @ $400 each. November 5 - Material Requisition #R-406, 2 grinding heads @ $1,100 each. November 6 - Material Requisition #R-407, 1 control panel @ $8,250 each. The following time ticket information pertains to job number 781: November 3 - Time Ticket # T-310, 2 employees 4 hours each November 4 - Time Ticket #T-311, 2 employees 2 hours each November 5 - Time Ticket # T-312, 6 employees 8 hours each November 7 - Time Ticket # T-313, 4 employees 4 hours each You now have all the information you need to complete the yellow boxes on the "Job Cost Sheet" tab. ABC Company - Job Cost Sheet Celemek Main Ne. kildest tiptum 14 Premium ISHIN Tulem! Direct Materials Requisition Direct labor Time Ticket Factory Overhead Date Rate Date Cost Date Cost Cost Total Totall Totall

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Income Tax Fundamentals 2013

Authors: Gerald E. Whittenburg, Martha Altus Buller, Steven L Gill

31st Edition

1111972516, 978-1285586618, 1285586611, 978-1285613109, 978-1111972516

Students also viewed these Accounting questions

Question

Discuss whether happier people make more money.

Answered: 1 week ago