EXCEL SHEET 1
Statement of cost of goods manufactured for a manufacturing company
Cost data for Johnstone Manufacturing Company for the month ended March 31 are as follows:
Inventories March 1 March 31
Materials $240,000 $220,680
Work in process 498,170 583,300
Finished goods 669,950 703,870
Direct labor $4,000,000
Materials purchased during March 3,047,080
Factory overhead incurred during March:
Indirect labor 365,710
Machinery depreciation 240,000
Heat, light, and power 200,000
Supplies 39,880
Property taxes 34,280
Miscellaneous costs 52,230
This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.
EXCEL SHEET 2
Financial statements of a manufacturing firm
The following events took place for Sorensen Manufacturing Company during January, the first month of its operations as a producer of digital video monitors:
Purchased $248,000 of materials.
Used $178,560 of direct materials in production.
Incurred $446,400 of direct labor wages.
Incurred $178,600 of factory overhead.
Transferred $753,900 of work in process to finished goods.
Sold goods for $1,190,400.
Sold goods with a cost of $669,600.
Incurred $213,300 of selling expense.
Incurred $124,000 of administrative expense.
This information has been collected in the Microsoft Excel Online file. Open the spreadsheet, perform the required analysis, and input your answers in the questions below.
The post EXCEL SHEET 1
Statement of cost of goods manufactured for a manufacturing compan appeared first on Skilled Papers.