Prepare the appropriate journal entries and 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 company's 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 1. Raw materials were purchased on account for $100,000. 2. Raw materials were requisitioned for use in production, $200,000 of which 75% were direct materials and the remainder was indirect materials 3. Employee costs were incurred: direct labor, $450,000; indirect factory labor, $250,000; and general and administrative salaries, $291.000 4. Advertising costs of $125,000 were incurred. 5. Utility costs of $39.000 were incurred for the factory and $61.000 were for the headquarters building 6. 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 7. Manufacturing overhead was applied to jobs. The actual level of machine hours for the year was 17.000 machine-hours 8. 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. 9. Goods with a cost of $500,000 were sold on account for 175% of cost. 10. The over or underapplied overhead journal entry must be made. (Be sure to indicate if overhead is over or underapplied.)