FY16 | ||||||
Factory Rent | $330,000 | |||||
Direct Materials Inventory, Beginning | 96,000 | |||||
Direct Materials Inventory, Ending | 87,000 | |||||
Direct Materials Purchases | 654,000 | |||||
Direct Labor-Wages | 425,000 | |||||
Indirect Labor-Wages | 28,000 | |||||
Finished Goods Inventory, Beginning | 25,000 | |||||
Finished Goods Inventory, Ending | 44,000 | |||||
Indirect Materials | 66,000 | |||||
Plant Utilities | 40,000 | |||||
General and Administrative | 101,350 | |||||
Work-in-Process Inventory, Beginning | 27,000 | |||||
Work-in-Process Inventory, Ending | 33,000 | |||||
Marketing Expenses | 225,000 | |||||
Sales Revenue | 2,550,000 | |||||
A. Prepare a statement of cost of goods manufactured and an income statement for the year ended December 31, 2016. | ||||||
B. For FY2016, calculate gross margin %. What is Jamison Tools largest expense as a % of revenue? | ||||||
C. Interpret the results of the financial statements |
A.
Jamison Tools |
||
Statement of Cost of Goods Manufactured For the for the year ended December 31,2016 |
||
Opening Inventory of Direct Material |
96000 |
|
Add: Purchases of Direct Materials |
654000 |
|
Less: Closing Inventory of Direct Material |
(87000) |
663000 |
Direct Labour-Wages |
425000 |
|
Prime Cost |
1,088,000 |
|
Add: Factory Overhead Cost |
4,64,000 |
|
Total Factory Cost |
1,552,000 |
|
Add: Opening work-in-process |
27,000 |
|
Less:Closing work-in-process |
(33000) |
|
Cost of Goods Manufactured |
1,546,000 |
|
Working note:Calculation of factory overheads:
Factory rent $ 330000
Indirect labour $ 28000
Indirect material $66000
Plant utilities $ 40000
TOTAL $464000
Jamison Tools |
||
Income statement for the year ended December 31,2016 |
||
Sales Revenue |
2,550,000 |
|
Cost of Goods Sold |
||
Cost of Goods Manufactured |
1,546,000 |
|
Add: Opening Finished Goods Inventory |
25,000 |
|
Goods Available for sale |
1,571,000 |
|
Less: Closing Finished Goods Inventory |
44,000 |
|
Gross Margin |
1,527,000 |
|
Less: Administrative Overheads |
(101350) |
|
Less: Marketing Expenses |
(225000) |
|
Income Before Taxes |
1,200,650 |
B. Gross Margin Percentage=(1,527,000*100)/ 2,550,000=59.8823%
Largest Expense as a percentage of Revenue=Expense of Direct Material
=654000*100/2550000=25.647 %
Calculation of factory overheads:
Factory rent $ 330000
Indirect labour $ 28000
Indirect material $66000
Plant utilities $ 40000
TOTAL $464000
FY16 Factory Rent $330,000 Direct Materials Inventory, Beginning 96,000 Direct Materials Inventory, Ending 87,000 Direct...
Hamza Corporation reported the following results for the current year: Revenue Beginning inventory, Direct Materials Ending inventory, Direct Materials Purchases - Direct Materials Direct Labor Manufacturing Equipment Depreciation Plant Utilities Indirect Plant Labor Marketing Customer Service Beginning Work-in Process Ending Work-in-Process Beginning Finished Goods Ending Finished Goods $800,000 35,000 20,000 175.000 225,000 90,000 50,000 60,000 30,000 40,000 80,000 85,000 90,000 75,000 Based on the data above, Cost of Goods Sold equals:
The following data relates to the Sunshine Company: Direct Materials Inventory, Beginning Direct Materials Inventory, Ending Direct Materials Purchases Direct Labor Finished Goods Inventory, Beginning Finished Goods Inventory, Ending Factory overhead Work-in-Process Inventory, Beginning Work-in-Process Inventory, Ending $ 40 50 210 350 100 95 153 65 80 Required: (a) Compute the direct materials used during the year. (b) Compute the cost of goods manufactured during the year. (c) Compute the cost of goods sold during the year.
Description Beginning raw materials inventory Ending raw materials inventory Materials purchased Beginning work in process inventory Ending work in process inventory Beginning finished goods inventory Ending finished goods inventory Direct Labor Manufacturing overhead (Fixed) Manufacturing overhead (Variable) Revenue General and Administrative Expenses Selling Expenses Amount $200,000 $500,000 $1,800,000 $650,000 $200,000 $300,000 $900,000 $1,500,000 $1,200,000 $800,000 $10,000,000 $2,500,000 $1,200,000 Prepare a variable costing income statement Revenue Cost of goods sold Gross Profit Expenses Total Expenses NET INCOME (LOSS)
Accounting 331 Description Beginning raw materials inventory Ending raw materials inventory Materials purchased Beginning work in process inventory Ending work in process inventory Beginning finished goods inventory Ending finished goods inventory Direct Labor Manufacturing overhead (Fixed) Manufacturing overhead (Variable) Revenue General and Administrative Expenses Selling Expenses Amount $200,000 $500,000 $1,800,000 $650,000 $200,000 $300,000 $900,000 $1,500,000 $1,200,000 $800,000 $10,000,000 $2,500,000 $1,200,000 Prepare an absorption costing income statement Revenue Cost of goods sold Gross Profit Expenses Total Expenses NET INCOME (LOSS)
$ 87 118 1,650 Information on January 1 (Beginning): Direct materials inventory Work-in-process inventory Finished goods inventory Information for the year: Administrative costs Direct labor Direct materials purchases Factory and machine depreciation Factory supervision Factory utilities Indirect factory labor Indirect materials and supplies Marketing costs Property taxes on factory Sales revenue Information on December 31 (Ending): Direct materials inventory Work-in-process inventory Finished goods inventory $ 3,610 12,050 8,280 11,630 746 943 2,870 681 1,520 293 45,700 $ 91 129 1,430...
Beginning finished goods inventory Beginning work in process inventory Beginning raw materials inventory (direct materials) Rental cost on factory equipment Direct labor Ending finished goods inventory Ending work in process inventory Ending raw materials inventory Factory utilities Factory supplies used (indirect materials) General and administrative expenses Indirect labor Repairs-Factory equipment Raw materials purchases Selling expenses Sales Cash Factory equipment, net Accounts receivable, net Garcon Company $ 13,400 16,000 7,700 32,250 23,600 20,900 26, 200 5,500 10,500 9,700 28,500 2,100 4,700...
$ 85 112 1,630 Information on January 1 (Beginning): Direct materials inventory Work-in-process inventory Finished goods inventory Information for the year: Administrative costs Direct labor Direct materials purchases Factory and machine depreciation Factory supervision Factory utilities Indirect factory labor Indirect materials and supplies Marketing costs Property taxes on factory Sales revenue Information on December 31 (Ending): Direct materials inventory Work-in-process inventory Finished goods inventory $ 3,660 12,950 8, 250 11,500 750 953 2,890 676 1,510 272 45,800 99 142 1,430...
Beginning 20,000 work in process inventory materials used Plus: Direct Beginning raw materials inventory Purchases of materials 51,000 Available for use 77,000 (26,000) Ending raw materials inventory Direct materials used Direct labor 49,000 costs 173,000 Manufacturing overhead Total manufacturing incurred during the month Total manufacturing to account for Less: Ending work in process inventory Cost of goods manufactured costs (21,000) Elly Manufacturing Company Income Statement Month Ended June 30 Sales revenue Cost of goods sold: Beginning finished goods inventory Cost...
Sales Raw materials inventory, beginning Work in process inventory, beginning Finished goods inventory, beginning Raw materials purchases Direct labor Factory supplies used (indirect materials) Indirect labor Repairs-Factory equipment Rent cost of factory building Advertising expense General and administrative expenses Raw materials inventory, ending Work in process inventory, ending Finished goods inventory, ending $ 1,115,000 36,000 51,600 67,500 158,200 235,000 22, 200 45,000 5,250 57,000 90,000 141,000 48,300 42,400 74,500 DELRAY MFG. Schedule of Cost of Goods Manufactured For Year Ended...
For last year, Lewisburn Manufacturing reported the following: Revenue $420,000 Beginning inventory of direct materials, January 1 22,000 Purchases of direct materials 146,000 Ending inventory of direct materials, December 31 16,000 Direct manufacturing labor 18,000 Indirect manufacturing costs 40,000 Beginning inventory of finished goods, January 1 35,000 Beginning inventory of work in process, January 1 4,000 Ending inventory of finished goods, December 31 36,000 Operating costs 140,000 Ending Inventory of work in process, December 31 110,000 What was Lewisbum's cost...