Job Cost Sheets; Departmental Rates, Pivot Tables in Excel (see also 4-50)
Decker Screw Manufacturing Company produces special screws made to customer specifications. During June, the following data pertained to these costs:
Summary of Direct Materials Requisitions | ||||
Department Number | Job Number | Requisition Number | Quantity | Cost per Unit |
1 | 2906 | B9766 | 4,550 | $ 1.34 |
2 | 2907 | B9767 | 110 | 22.18 |
1 | 2908 | B9768 | 1,000 | 9.00 |
1 | 2906 | B9769 | 4,430 | 1.35 |
2 | 2908 | B9770 | 23 | 48.00 |
Summary of Direct Labor Time Tickets | ||||
Department Number | Job Number | Ticket Number | Hours | Cost per Hour |
1 | 2906 | 1056-1168 | 1,102 | $6.50 |
2 | 2907 | 2121-2130 | 136 | 8.88 |
1 | 2908 | 1169-1189 | 151 | 6.50 |
2 | 2908 | 2131-1239 | 32 | 8.88 |
1 | 2906 | 1190-1239 | 810 | 6.50 |
| Summary of Factory Overhead Application Rates |
Department Number | Basis of Application Rates |
1 | $3 per direct labor-hour |
2 | 150% of direct labor cost |
Decker had no beginning work-in-process inventory for June. Of the jobs begun in June, Job 2906 was completed and sold on account for $30,000, Job 2907 was completed but not sold, and Job 2908 was still in process.
Required
1. Calculate the direct materials, direct labor, factory overhead, and total costs for each job started in June, using EXCEL.
2. Perform the same calculations as in requirement (1), but assume that the direct labor-rate per hour increased by 10 percent in Department 1 and 25 percent in Department 2.
3. Perform the same calculations in part (1) except that you should use Pivot Tables in Excel to arrive at the answer.
4. Perform the same calculations in part (2) except that you should use Pivot Tables in Excel to arrive at the answer.
We need at least 10 more requests to produce the solution.
0 / 10 have requested this problem solution
The more requests, the faster the answer.