Job costing assignment – excel spreadsheet

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.

Calculate your order
Pages (275 words)
Standard price: $0.00
Client Reviews
Our Guarantees
100% Confidentiality
Information about customers is confidential and never disclosed to third parties.
Original Writing
We complete all papers from scratch. You can get a plagiarism report.
Timely Delivery
No missed deadlines – 97% of assignments are completed in time.
Money Back
If you're confident that a writer didn't follow your order details, ask for a refund.

Calculate the price of your order

You will get a personal manager and a discount.
We'll send you the first draft for approval by at
Total price:
Power up Your Academic Success with the
Team of Professionals. We’ve Got Your Back.
Power up Your Study Success with Experts We’ve Got Your Back.