The following data appeared in Dublin Flooring's records on 31 December of last year: Sales revenue...

 

Transcribed Image Text:

The following data appeared in Dublin Flooring's records on 31 December of last year: Sales revenue Direct material used Work-in-progress inventory, 31 December 812,500 191,050 12,300 Raw material inventory, 31 December 42,500 Raw material purchased during the year 180,000 Finished goods inventory, 31 December 45,000 Indirect labour 16,000 Direct labour 195,000 Plant heat, light and power 22,600 Building depreciation (7/9 is for manufacturing) 40,500 Administrative salaries 24,900 Miscellaneous factory cost 16,950 Selling costs 19,300 Maintenance on factory machines 6,050 Insurance on factory equipment Distribution costs Taxes on manufacturing property 9,500 800 6,550 Legal fees on customer complaint 4,100 On 1 January, last year, the Finished goods inventory account had a balance of 40,000, and the Work-in- progress inventory account had a balance of 12,950. Required Build a spreadsheet to prepare a schedule of cost of sales and a statement of income. The following data appeared in Dublin Flooring's records on 31 December of last year: Sales revenue Direct material used Work-in-progress inventory, 31 December 812,500 191,050 12,300 Raw material inventory, 31 December 42,500 Raw material purchased during the year 180,000 Finished goods inventory, 31 December 45,000 Indirect labour 16,000 Direct labour 195,000 Plant heat, light and power 22,600 Building depreciation (7/9 is for manufacturing) 40,500 Administrative salaries 24,900 Miscellaneous factory cost 16,950 Selling costs 19,300 Maintenance on factory machines 6,050 Insurance on factory equipment Distribution costs Taxes on manufacturing property 9,500 800 6,550 Legal fees on customer complaint 4,100 On 1 January, last year, the Finished goods inventory account had a balance of 40,000, and the Work-in- progress inventory account had a balance of 12,950. Required Build a spreadsheet to prepare a schedule of cost of sales and a statement of income.