Prepare the appropriate journal entries or calculations in good form using an excel spreadsheet .

Ahmed Company is a manufacturing firm that uses job-order costing. At the beginning of the year, the companys inventory balances were as follows:

Raw materials.. $250,000

Work in process... 200,000

Finished goods. 510,000

The company applies overhead to jobs using a predetermined overhead rate based on machine-hours. At the beginning of the year, the company estimated that it would work 15,000 machine-hours and incur $450,000 in manufacturing overhead cost. The following transactions were recorded for the year:

Raw materials were purchased on account for $100,000.

Raw materials were requisitioned for use in production, $200,000 of which 75% were direct materials and the remainder was indirect materials.

Employee costs were incurred: direct labor, $450,000; indirect factory labor, $250,000; and general and administrative salaries, $291,000.

Advertising costs of $125,000 were incurred.

Utility costs of $39,000 were incurred for the factory and $61,000 were for the headquarters building.

Depreciation for the year was $300,000 of which $175,000 is related to the factory and $125,000 is related to the headquarters office building.

Manufacturing overhead was applied to jobs. The actual level of machine hours for the year was 17,000 machine-hours.

The goods with direct material costs of $100,000, direct labor costs of $159,000 and manufacturing overhead cost of $200,000 were completed and moved to the delivery area.

Goods with a cost of $500,000 were sold on account for 175% of cost.

The over or under applied overhead journal entry must be made. (Be sure to indicate if overhead is over or under applied.)