In: Accounting
Pribil Farm Equipment is a job-order costing manufacturer that uses a plantwide overhead rate based on direct labor hours. Estimations for the year include $250,000 in Overhead and 50,000 direct labor hours. Pribil worked on five jobs in March. Data are as follows:
|
Job 89 |
Job 90 |
Job 91 |
Job 92 |
Job 93 |
|
|
Balance, 3/1 |
$23,110 |
$18,240 |
$ 9,510 |
$0 |
$0 |
|
Direct Materials |
13,000 |
17,210 |
22,900 |
15,240 |
8,210 |
|
Direct Labor cost |
8,075 |
11,500 |
16,250 |
9,750 |
4,860 |
|
Direct Labor Hours |
1,615 |
2,300 |
3,250 |
1,950 |
972 |
By March 31, Jobs 89 and 91 were completed and sold at Cost plus 55%. The rest of the jobs remained in process.
Calculate the plantwide overhead rate.
Create Job Cost Reports for the month.
Calculate the Work-in-Process on March 31 and COGS.
Income Statement for the Month of March
| Answer | |||||
| Predetermined Overhead rate= | |||||
| Estimated Overhead/Estimated Direct Labor Hours | |||||
| 420000/30000 | |||||
| 14.00 per hour |
| A) | Job Costing Report | |||||
| Job 89 | Job 90 | Job 91 | Job 92 | Job 93 | ||
| Opening balance | $ 23,110 | $ 18,240 | $ 9,510 | $ - | $ - | |
| Direct Materials | $ 13,000 | $ 17,210 | $ 22,900 | $ 15,240 | $ 8,210 | |
| Direct Labor | $ 8,075 | $ 11,500 | $ 16,250 | $ 9,750 | $ 4,860 | |
| Overhead | 22610(1615*14) | 32200(2300*14) | 45500(3250*14) | 27300(1950*14) | 13608(972*14) | |
| Total Costs | $ 66,795 | $ 79,150 | $ 94,160 | $ 52,290 | $ 26,678 | |
| B) | Job 89 | Job 90 | Job 91 | Job 92 | Job 93 | |
| Total Costs | $ 66,795 | $79,150 | $94,160 | $52,290 | $26,678 | |
| Completed and sold | $ 66,795 | $ - | $94,160 | $ - | $ - | |
| Closing balance WIP | $ - | $79,150 | $ - | $52,290 | $26,678 | |
| COGS (66795+94160) | $1,60,955 | |||||
| Add: 55% markup | $ 88,525 | |||||
| Sales | $2,49,480 | |||||
| Since all other jobs are in progress value of finished goods is 0 | ||||||
| C) | Income Statement | |
| Sales | $ 2,49,480 | |
| Less: COGS | $ 1,60,955 | |
| Net Income | $ 88,525 | |
| Please like ( Positive Rating ) | ||