Among the objectives are to determine the total amount of costs added in October to WIP and
to Job No.	6528
The Costs per unit for each type of input by category are given in the table below.
Machine costs are treated as overhead. Direct costs pertain to materials and labor.
There are two types of labor, "skilled" and "normal". Each has a separate
cost per labor hour. There are three types of materials used by TruBent,
once again each material is measured in an appropriate input unit and the
cost per unit is with respect to that input unit.
Type	Category	Cost per unit
OH	Machine T1	$ 35.00
	Machine T2	$ 42.00
	Machine T3	$ 45.00
Materials	Mat X1	$ 5.25
	Mat X2	$ 7.50
	Mat X3	$ 13.20
Labor	Normal	$ 29.00
	Skilled	$ 41.00
Required - Part 1
Questions 1 to 6 pertain only to Job No. ===>			6528
Enter your answers in the appropriate Yellow shaded cell!!!
Determine the total Direct Material costs added (to WIP) in October		Q1
Determine the total Direct Labor costs added in October			Q2
Determine the total Machine 1 related OH costs added in October		Q3
Determine the total Machine 2 related OH costs added in October		Q4
Determine the total Machine 3 related OH costs added in October		Q5
Determine the total manufacturing costs added in October			Q6
Required - Part 2
Questions 7 to 12 pertain to all work done in October (i.e., include all jobs)
Determine the total Direct Material costs added in October			Q7
Determine the total Direct Labor costs added in October			Q8
Determine the total Machine 1 related OH costs added in October		Q9
Determine the total Machine 2 related OH costs added in October		Q10
Determine the total Machine 3 related OH costs added in October		Q11
Determine the total manufacturing costs added in October			Q12
Required - Part 3
Questions 13 to 18 pertain to all work done on October 27 through October 30 (inclusive)
Determine the total Direct Material costs added				Q13
Determine the total Direct Labor costs added				Q14
Determine the total Machine 1 related OH costs added			Q15
Determine the total Machine 2 related OH costs added			Q16
Determine the total Machine 3 related OH costs added			Q17
Determine the total manufacturing costs added				Q18
Required - Part 4
Questions 19 to 20
Assume the actual overhead for the October is:	$ 172,900
Answer the following two questions regarding the closing of the mfg. overhead
accounts for the month. You should create PivotTables that show the overhead
applied for the month, the amount of overhead applied by job, and the amount of
overhead applied to each job as a percentage of the total OH applied.
What is the total amount of overhead under (use a positive number) or over		Q19
(use a negative number) applied during the month?
What is the total amount of adjustment required to be made to Job 6500?		Q20
Use a positive number to indicate that the adjustment is a debit to WIP - Job 6500
and a negative number to indicate the adjustment is a credit to WIP - Job 6500