Please show all calculations and in excel format. Thanks!

NAME: Normal Costing Review Problem Yuletide Company is a manufacturing firm that uses normal costing. The company's inventory balances were as follows at the beginning and end of the calendar year 2016. Beginning Balance Direct Materials $14,000 Work in Process $27,000 Finished Goods$62,000 Ending Balance $22,000 $9,000 $77,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 it would work 33,000 machine hours and incur $231,000 in overhead cost. The following information may be useful to you as you complete your tasks. A. Direct Materials purchased during 2016 cost a total of $315,000 B. The following employee costs were incurred: i. Direct Labor $377,000 I i Administrative Salaries 172,000 ii. Sales Salaries $147,000 C. Factory Utility Costs: $10,000 D. Depreciation for the year was $127,000 of which $120,000 is related to factory operations and $7,000 is related to selling and administrative activities. E. Machine Hours: Actual machine hours incurred in 2016 were 35,000 G. Ending Accounts Receivable Balance: $84, 000 H. Ending Prepaid Expenses: $25,000 I. Administrative Expense: $74,000 . Finished Goods Warehousing Expense was $38,000 L. M. Overhead: Assume that any under or over-applied overhead is closed 100% to Cost of Good Sold. Sales for year totaled $1,363,000 Factory Maintenance Costs: $122,000 Tasks for our homework: A. Prepare a Schedule of Cost of Goods Manufactured in Good Form (Remember that means a proper B. Prepare an Income Statement in Good Form as well. heading too!)