please include all work. thank you.

it is an excel assignment.

Northern Illinois Manufacturing provides products and services needed to irrigate farms, parks, commercial properties, 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,275 . The following additional data for November is provided: Instructions: From the above information: a. Prepare a cost of goods manufactured schedule b. Prepare a cost of goods sold schedule c. Prepare an income statement to the net operating income