please answer in an excel format. thank you

Problem 3-16 (Algo) Comprehensive Problem (LO3-1, LO3-2, LO3-4) Gold Nest Company of Guandong, China, is a family-owned enterprise that makes birdcages for the South China market. The company sells its birdcages through an extensive network of street vendors who receive commissions on their sales. The company uses a job-order costing system in which overhead is applied to jobs on the basis of direct labor cost. Its predetermined overhead rate is based on a cost formula that estimated $84,000 of manufacturing overhead for an estimated activity level of $40,000 direct labor dollars. At the beginning of the year, the inventory balances were as follows: raw materials Work in process Finished goods $10,600 $ 4.300 $ 8,500 During the year, the following transactions were completed: a. Raw materials purchased on account, $165,000. b. Raw materials used in production, $141,000 (materials costing $126,000 were charged directly to jobs; the remaining materials were indirect). c. Costs for employee services were incurred as follows: Direct labor Indirect labor Sales commissions Administrative salaries $ 168,000 $ 270,900 $ 22,000 $ 50,000 d. Rent for the year was $18.600 ($13,900 of this amount related to factory operations, and the remainder related to selling and administrative activities). e. Utility costs incurred in the factory, $14,000, Advertising costs incurred, $11,000. 9. Depreciation recorded on equipment . $24,000. ($17,000 of this amount related to equipment used in factory operations, the remaining $7.000 related to equipment used in selling and administrative activities.) h. Manufacturing overhead cost was applied to jobs, $_? 1. Goods that had cost $225,000 to manufacture according to their job cost sheets were completed. J Sales for the year (all paid in cash) totaled $510,000. The total cost to manufacture these goods according to their job cost sheets was $219,000 Required: 1. Prepare journal entries to record the transactions for the year. 2. Prepare T-accounts for each inventory account Manufacturing Overhead, and Cost of Goods Sold. Post relevant data from your Journal entries to these T-accounts (don't forget to enter the beginning balances in your inventory accounts). 3A. Is Manufacturing Overhead underapplied or overapplied for the year? 38. Prepare a journal entry to close any balance in the Manufacturing Overhead account to Cost of Goods Sold 4. Prepare an income statement for the year. All of the information needed for the income statement is available in the journal entries and T-accounts you have prepared. Complete this question by entering your answers in the tabs below. Reg 2 Req Reg 1 Reg 38 Reg 4 Prepare journal entries to record the transactions for the year. (If no entry is required for a transaction/event, select "No journal entry required in the first account held. Do not round Intermediate calculations.) View transaction list Journal entry worksheet Complete this question by entering your answers in the tabs below. Reg 1 Reg 2 Req Reg 3B Reg 4 Is Manufacturing Overhead underapplied or overapplied for the year? Underapplied Overapplied Complete this question by entering your answers in the tabs below. Reg 1 Req 2 Reg 3A Reg 3B Req 4 Prepare a journal entry to close any balance in the Manufacturing Overhead account to cost of Goods Sold. (if no entry is required for a transaction/event, select "No journal entry required" in the first account Meld.) View transaction list Journal entry worksheet Record the entry to close any balance in the Manufacturing Overhead account to Cost of Goods Sold. Note: Enter debits before credits Dobit Credit Transaction General Journal 1 View general Journal Record entry Clear entry Complete this question by entering your answers in the tabs below. Reg 1 Reg 2 Req Reg 38 Reg 4 Prepare an Income statement for the year. (All of the information needed for the income statement is available in the journal entries and T-accounts you have prepared.) Gold Nost Company Income Statement For the Year Ended Selling and administrative expenses.