Ensign Landscape Design designs landscape plans and plants the material for clients. On April 1, there were three jobs in process, Jobs 39, 40, and 41. During April, two more jobs were started, Jobs 42 and 43. By April 30, Jobs 40, 41, and 43 were completed and sold. The following data were gathered:
Job 39 | Job 40 | Job 41 | Job 42 | Job 43 | |
Balance, April 1 | $500 | $3,370 | $3,010 | — | — |
Direct materials | 650 | 530 | 350 | $3,450 | $6,890 |
Direct labor | 550 | 590 | 520 | 2,490 | 2,980 |
Overhead is applied at the rate of 110% of direct labor cost. Jobs are sold at cost plus 30%. Selling and administrative expenses for April totaled $4,575. (Round all amounts to the nearest dollar.)
Required: | |
1. | Prepare job-order cost sheets for each job as of April 30. |
2. | Calculate the ending balance in Work in Process (as of April 30) and Cost of Goods Sold for April. |
3. | Construct an income statement for Ensign Landscape Design for the month of April. |
Labels and Amount Descriptions
Refer to the list below for the exact wording of text items within your job-cost sheets and income statement.
Labels | |
Add | |
Less | |
Amount Descriptions | |
Applied overhead | |
Beginning balance | |
Cost of goods sold | |
Direct labor | |
Direct materials | |
Gross margin | |
Operating income | |
Operating loss | |
Sales | |
Selling and administrative expenses | |
Total |
Job-Order Cost Sheets
1. Prepare job-order cost sheets for each job as of April 30. Refer to the list of Labels and Amount Descriptions for the exact wording of text items within your job-cost sheets.
Ensign Landscape Design |
Job-Order Cost Sheets |
For the Month of April |
1 |
Job 39 |
Job 40 |
Job 41 |
Job 42 |
Job 43 |
|
2 |
Beginning balance |
|||||
3 |
||||||
4 |
||||||
5 |
||||||
6 |
Calculations
2. Calculate the ending balance in Work in Process (as of April 30) and Cost of Goods Sold for April.
Ending Balance in Work in Process | |
Cost of Goods Sold for April |
Income Statement
3. Construct an income statement for Ensign Landscape Design for the month of April. Refer to the list of Labels and Amount Descriptions for the exact wording of text items within your income statement. If a net loss has been incurred, enter that amount as a negative number using a minus sign.
Ensign Landscape Design |
Income Statement |
For the Month Ended April 30 |
1 |
||
2 |
||
3 |
||
4 |
||
5 |
||
6 |
1. Prepare job-order cost sheets for each job as of April 30. Refer to the list of Labels and Amount Descriptions for the exact wording of text items within your job-cost sheets.
Ensign Landscape Design |
Job-Order Cost Sheets |
For the Month of April |
1 |
Job 39 |
Job 40 |
Job 41 |
Job 42 |
Job 43 |
|
2 |
Beginning balance |
500 | 3370 | 3010 | ||
3 |
Direct material | 650 | 530 | 350 | 3450 | 6890 |
4 |
Direct labor | 550 | 590 | 520 | 2490 | 2980 |
5 |
Overhead | 605 | 649 | 572 | 2739 | 3278 |
6 |
Total | 2305 | 5139 | 4452 | 8679 | 13148 |
Calculations
2. Calculate the ending balance in Work in Process (as of April 30) and Cost of Goods Sold for April.
Ending Balance in Work in Process | 2305+8679 = 10984 |
Cost of Goods Sold for April | 5139+4452+13148 = 22739 |
Income Statement
3. Construct an income statement for Ensign Landscape Design for the month of April. Refer to the list of Labels and Amount Descriptions for the exact wording of text items within your income statement. If a net loss has been incurred, enter that amount as a negative number using a minus sign.
Ensign Landscape Design |
Income Statement |
For the Month Ended April 30 |
1 |
Sales revenue (22739*1.3) | 29560.70 |
2 |
Cost of goods sold | 22739 |
3 |
Gross margin | 6821.70 |
4 |
Selling and administrative expense | -4575 |
5 |
Operating income | 2246.70 |
6 |
Ensign Landscape Design designs landscape plans and plants the material for clients. On April 1, there...
Ensign Landscape Design designs landscape plans and plants the material for clients. On April 1, there were three jobs in process, Jobs 39, 40, and 41. During April, two more jobs were started, Jobs 42 and 43. By April 30, Jobs 40, 41, and 43 were completed and sold. The following data were gathered: Job 39 Job 40 Job 41 Job 42 Job 43 Balance, April 1 $570 $3,450 $3,000 - Direct materials 690 600 410 520 $3,520 $6,880 2,550...
Instructions Ensign Landscape Design design landscape plans and plants the material for clients. On April 1, there were three jobs in prooess, Jobs 39, 40, and 41. During April, two more jobs were started, Jobs 42 and 43. By April 30, Jobs 40, 41, and 43 were completed and sold. The following data were gathered: Job 39 Job 40 Job 41 Job 42 Job 43 Balance, April 1 5540 $3,400 $2,990 Direct materials 700 560 375 $3,500 50,000 Direct labor...
Ensign Landscape Design designs landscape plans and plants the material for clients. On April 1, there were three jobs in process, Jobs 39, 40, and 41. During April, two more jobs were started, Jobs 42 and 43. By April 30, Jobs 40, 41, and 43 were completed and sold. The following data were gathered: Job 39 Job 40 Job 41 Job 42 Job 43 Balance, April 1 $570 $3,380 $3,010 — — Direct materials 740 610 370 $3,450 $6,880 Direct...
Ensign Landscape Design designs landscape plans and plants the
material for clients. On April 1, there were three jobs in process,
Jobs 39, 40, and 41. During April, two more jobs were started, Jobs
42 and 43. By April 30, Jobs 40, 41, and 43 were completed and
sold. The following data were gathered:
Job 39
Job 40
Job 41
Job 42
Job 43
Balance, April 1
$570
$3,430
$2,990
—
—
Direct materials
750
520
350
$3,540
$6,870
Direct...
Ensign Landscape Dosign designs landscape plans and plants the material for more jobs were started, Jobs 42 and 43. By April 30. Ihsan and w o mpleted and sold. The following data word game monts. On April 1, there were throo jobs in process, Jobs 39, 40, and 41. During April, two Job 39 Job 40 Job 41 Job 42 Job 43 Balance, April 1 $570 $3,450 $3,000 Direct materials 690 600 410 $3,520 $6,880 Direct labor 520 590 520...
Instructions Ensign Landscape Design designs landscape plans and plants the material for clients. On April 1, there were three jobs in prodals, Jobs 39, 40, and 41. During April, two more jobs were started, Jobs 42 and 43. By April 30, Jobs 40, 41, and 43 were completed and sold. The following data were gathered: Job 39 Job 40 Job 41 Job 42 Job 43 Balance, April 1 $520 $3,350 $2,990 Direct materials 730 530 370 $3,510 2,470 $6,850 3,000...
Ensign Landscape Design designs landscape plans and plants the materials for clients. On April 1, there were three jobs in process - Job 39, 40 and 41. During April, two more jobs were started 42 and 43. By April 30, Jobs 39 and 40 were completed and sold; Jobs 41 and 42 were completed and not sold; and Job 43 was not completed. Direct labor is $10/hour. Overhead is applied at the rate of $32 per direct labor hour. Jobs...
Exercise 4-49: Assume Direct Labor workers make $20 per hour, so with the given labor cost per job, you can determine the number of hours worked. CHANGE the Exercise to say that Overhead is applied at the rate of $32 per direct labor hour. ALSO CHANGE to say that Job #39 and Job #40 were completed and sold, while Job #41 and Job #42 are complete but not sold, and Job #43 is not completed yet. Ensign Landscape Design designs...
Job-Order Cost Sheets, Balance in Work in Process and Finished Goods Golding Company, a job-order costing firm, worked on three jobs in July. Data are as follows: Balance, July 1 Direct materials Direct labor Machine hours Job 106 $21,310 $10,450 $16,000 500 Job 107 $6,250 $12,300 $12,200 300 Job 108 $0 $16,150 $24,000 1,000 Overhead is applied to jobs at the rate of $16 per machine hour. By July 31, Jobs 106 and 108 were completed. Jobs 102 and 106...
Instructions At the beginning of June, Rhone Company had two jobs in process, Job 44 and Job 45, with the following accumulated cost information: Job 44 Job 45 Direct materials $5,250 $1,600 Direct labor 1,500 3,300 Applied overhead 1.125 2,475 Balance, June 1 $7.875 $7,375 During June, two more jobs (46 and 47) were started. The following direct materials and direct labor costs were added to the four jobs during the month of June: Job 64 Job 45 Job 46...