statement of cost of goods manufactured

EXCEL SHEET 1
Statement of cost of goods manufactured for a manufacturing companyCost data for Johnstone Manufacturing Company for the month ended March 31 are as follows:Inventories March 1 March 31Materials $240,000 $220,680Work in process 498,170 583,300Finished goods 669,950 703,870
Direct labor $4,000,000Materials purchased during March 3,047,080Factory overhead incurred during March:Indirect labor 365,710Machinery depreciation 240,000Heat, light, and power 200,000Supplies 39,880Property taxes 34,280Miscellaneous costs 52,230This 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 firmThe 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.