In: Accounting
The following data were taken from the records of Flexsteel Manufacturing Company for the year ended May 31, 2016.
Raw Materials |
Factory Insurance |
$7,000 |
|
Inventory 6/1/15 |
$47,000 |
Factory Mach-Depreciation |
4,000 |
Raw Materials |
Plant Manager’s Salary |
30,000 |
|
Inventory 5/31/16 |
44,000 |
Factory Utilities |
12,900 |
Finished Goods |
Operating Expenses |
100,000 |
|
Inventory 6/1/15 |
85,000 |
Sales Revenue |
475,000 |
Finished Goods |
Sales Discounts |
2,500 |
|
Inventory 5/31/16 |
77,000 |
Short-term investments |
5,000 |
Work in Process |
Factory Property Taxes |
6,000 |
|
Inventory 6/1/15 |
9,500 |
Factory Repairs |
1,000 |
Work in Process |
Raw Materials Purchases |
67,500 |
|
Inventory 5/31/16 |
8,000 |
Cash |
28,000 |
Direct Labor |
145,000 |
Prepaid Expenses |
2,000 |
Indirect Labor |
18,000 |
Accounts Receivable |
27,000 |
Instructions
(a) Prepare a cost of goods manufactured schedule. (Assume all raw materials used were direct materials.)
(b) Prepare an entire income statement through net income .
(c) Prepare the current asset section of the balance sheet at May 31, 2016.
RAW MATERIAL ACCOUNT | ||||||
Debit | Credit | |||||
A | Raw Materials Beginning Inventory | $47,000 | ||||
B | Raw materials Purchases | $67,500 | ||||
D=A+B-C | Raw materials used for production | $70,500 | ||||
C | Raw Materials Ending Inventory | $44,000 | ||||
Manufacturing Overheads: | ||||||
E | Indirect labor | $18,000 | ||||
F | Factory Insurance | $7,000 | ||||
G | Factory Machine -Depreciation | $4,000 | ||||
H | Plant Manager'sSalary | $30,000 | ||||
X | Factory Property taxes | $6,000 | ||||
Y | Factory repairs | $1,000 | ||||
I | Factory Utilities | $12,900 | ||||
J=E+F+G+H+I+X+Y | Total Manufacturing Overhead | $78,900 | ||||
WORK IN PROCESS INVENTORY ACCOUNT | ||||||
Debit | Credit | |||||
K | Beginning Work in process inventory | $9,500 | ||||
D | Raw materials used for production | $70,500 | ||||
L | Direct labor costs | $145,000 | ||||
J | Total Manufacturing Overhead | $78,900 | ||||
N=K+D+L+J-M | Cost of goods manufactured | $295,900 | ||||
M | Ending Work in process inventory | $8,000 | ||||
COST OF GOODS MANUFACTURE SCHEDULE | ||||||
Raw materials used for production | $70,500 | |||||
Direct labor costs | $145,000 | |||||
Total Manufacturing Overhead | $78,900 | |||||
Decrease in work in process inventory | $1,500 | |||||
Cost of goods manufactured | $295,900 | |||||
FINISHED GOODS INVENTORY ACCOUNT | ||||||
Debit | Credit | |||||
P | Beginning Finished goods inventory | $85,000 | ||||
N | Goods transferred from Workin process | $295,900 | ||||
Q=P+N-R | Transferred to cost of goods sold | $303,900 | ||||
R | Ending Finished goods inventory | $77,000 | ||||
INCOME STATEMENT | ||||||
Sales Revenue | $475,000 | |||||
Less:Sales Discount | $2,500 | |||||
Net Sales | $472,500 | |||||
Cost of goods sold | $303,900 | |||||
Gross Profit | $168,600 | |||||
Less: Operating expenes | $100,000 | |||||
Net Income | $68,600 | |||||
BALANCE SHEET (Part) | ||||||
As on May 31, 2016 | ||||||
CURRENT ASSETS | ||||||
Cash | $28,000 | |||||
Account Receivable | $27,000 | |||||
Prepaid expenses | $2,000 | |||||
Short term investments | $5,000 | |||||
Inventory: | ||||||
Raw Materials Inventory | $44,000 | |||||
Work in process inventory | $8,000 | |||||
Finished goods inventory | $77,000 | |||||
Total Current Assets | $191,000 | |||||