Job Costing Assignment - Excel Spreadsheet

profiledhriase
Jobcosting.xlsx
Home>Business & Finance homework help>Accounting homework help>Job Costing Assignment - Excel Spreadsheet

Problem

This tool demonstrates a basic job costing system. The following assumptions apply: (1) There are three specific jobs: X, Y, and Z (2) There are two employees: A and B (3) There are three days of activity: 1, 2, and 3 (4) There are three types of direct material: AA, BB, and CC (5) A is paid $15 per hour and B is paid $20 per hour (6) AA costs $11, BB costs $23, and CC costs $9 (7) Overhead is applied at $20 per direct labor hour (8) Each employee is only allowed to requisition one item of direct material daily
Complete each time card below by assigning exactly 8 hours of work to each day for each employee (use the pick lists accessible from within the boxed areas; it is up to you to choose how many hours are worked on each job or on administrative time that is not charged to a specific job). Similarly, use the pick lists within the material requisition cards to decide which materials were used by each employee on each day. The job costs sheets will be automatically prepared based on your selections. Carefully tie the job costs sheets to the entries you made on the time sheets and material requisitions. Contemplate how this type of system is used in actual business environments to accurately trace time and materials to specific productive activities.
Employee A: Time Card Employee B: Time Card
Day Job Hours Daily Total Day Job Hours Daily Total X 0
1 X 0 1 X 0 Y 1
1 Y 0 1 Y 0 Z 2
1 Z 0 1 Z 0 Admin 3
1 Admin 0 error 1 Admin 0 error 4
2 X 0 2 X 0 5
2 Y 0 2 Y 0 6
2 Z 0 2 Z 0 7
2 Admin 0 error 2 Admin 0 error 8
3 X 0 3 X 0
3 Y 0 3 Y 0
3 Z 0 3 Z 0
3 Admin 0 error 3 Admin 0 error
Employee A: Material Requisition Employee B: Material Requisition -
Day Job Item Qty Day Job Item Qty AA
1 X - 0 1 X - 0 BB
1 Y - 0 1 Y - 0 CC
1 Z - 0 1 Z - 0
2 X - 0 2 X - 0
2 Y - 0 2 Y - 0
2 Z - 0 2 Z - 0
3 X - 0 3 X - 0
3 Y - 0 3 Y - 0
3 Z - 0 3 Z - 0
JOB X Cost Sheet
Direct Labor Materials Overhead
Day 1
Employee Hours Rate Total Item Qty Cost Per Total $20 per DL hour
A 0 $ 15.00 $ - 0 - 0 $ - 0 $ - 0 $ - 0
B 0 20.00 - 0 - 0 - 0 - 0 - 0
Day 2
A 0 15.00 - 0 - 0 - 0 - 0 - 0
B 0 20.00 - 0 - 0 - 0 - 0 - 0
Day 3
A 0 15.00 - 0 - 0 - 0 - 0 - 0
B 0 20.00 - 0 - 0 - 0 - 0 - 0
$0.00 = $ - 0 $ - 0 $ - 0
JOB Y Cost Sheet
Direct Labor Materials Overhead
Day 1
Employee Hours Rate Total Item Qty Cost Per Total $20 per DL hour
A 0 $ 15.00 $ - 0 - 0 $ - 0 $ - 0 $ - 0
B 0 20.00 - 0 - 0 - 0 - 0 - 0
Day 2
A 0 15.00 - 0 - 0 - 0 - 0 - 0
B 0 20.00 - 0 - 0 - 0 - 0 - 0
Day 3
A 0 15.00 - 0 - 0 - 0 - 0 - 0
B 0 20.00 - 0 - 0 - 0 - 0 - 0
$0.00 = $ - 0 $ - 0 $ - 0
JOB Z Cost Sheet
Direct Labor Materials Overhead
Day 1
Employee Hours Rate Total Item Qty Cost Per Total $20 per DL hour
A 0 $ 15.00 $ - 0 - 0 $ - 0 $ - 0 $ - 0
B 0 20.00 - 0 - 0 - 0 - 0 - 0
Day 2
A 0 15.00 - 0 - 0 - 0 - 0 - 0
B 0 20.00 - 0 - 0 - 0 - 0 - 0
Day 3
A 0 15.00 - 0 - 0 - 0 - 0 - 0
B 0 20.00 - 0 - 0 - 0 - 0 - 0
$0.00 = $ - 0 $ - 0 $ - 0

&"Myriad Web Pro,Bold"&20I-17.03