Answered step by step
Verified Expert Solution
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.
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
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started