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 ) |