PLEASE MAKE AN EXCEL

Northern Illinois Manufacturing provides products and the services needed to irrigate farms, parks, commercial products, and private homes. It has a centrally located factory that manufactures the products it markets to retail outlets across the nation. The month of November has just ended and Northern Illinois needs to generate a cost of goods manufactured and cost of goods sold for its income statement. The application of overhead is based on direct labor hours. At the beginning of the year, the company estimated direct labor hours of 40,000 and total estimated overhead of $2,000,000. During the month of November, the number of direct labor hours was 3,375. The following additional data for November is provided:

Indirect Materials in Manufacturing Overhead$ 17,250

Advertising Expense54,000

Depreciation Factory Equipment16,800

Depreciation Office Equipment2,500

'Direct Labor83,000

Factory Supplies11,800

Factory Utilities12,200

Finished Goods Inventory November 30 62,800

Finished Goods Inventory October 31 71,700

Indirect Labor58,000

Office Supplies Expense 2,400

Other Administrative Expenses 62,000

Raw Materials Inventory November 30 53,700

Raw Materials Inventory October 31 28,000

Raw Materials Purchases185,400

Rent Factory Equipment57,000

Repairs Factory Equipment5,200

Salaries323,000

Sales1,350,000

Sales Commissions40,500

Work In Process Inventory November 30 80,900

Work In Process Inventory October 31 75,100

Property Tax on Factory5,500

Instructions:From the above information, prepare a cost of goods manufactured schedule, cost of goods sold schedule, and an income statement to the net operating income.