Problems Prepare the problems below using Excel. Upload the workbook using the link. 1. (10 points) Alake Company is a manufacturing firm that uses job-order costing.The company applies overhead to jobs using a predetermined overhead rate based on direct labor hours. At the beginning of the year, the company estimated manufacturing overhead cost of $226,800 and estimated direct labor hours of 14,000 . The following transactions were recorded for the year: a. Advertising, $118,800. b. Raw materials were requisitioned for use in production, $542,110 ( $525,810 direct and $16,30b indirect). c. Depreciation for the year was $120,500, of which $113,300 is related to factory operations, $4,100 is related to sales equipment, and $3,100 is related to administative office equipment. d. Factory utility costs, $90,400. e. The following employee costs were incurred: direct labor, $267,225; indirect labor, $15,500; sales salaries, $49,800; sales commissions, $14,100; and administrative salaries, $49,600. f. Raw materials were purchased, $441,800. g. Manufacturing overhead was applied to jobs using the appropriate allocation base established above for applying overhead. Machine-hours worked for the year were 36,700. The average hourly rate for direct labor was $21.00 per hour. h. The cost of goods manufactured for the year was $948,200. i. Sales for the year totaled $1,131,700 and the costs on the job cost sheets of the goods that were sold totaled $824,600. j. The balance in the Manufacturing Overhead account was closed out to Cost of Goods Sold. Required: Use the horizontal model spreadsheet to record each of the transactions above (a. through j.). Assume that all transactions with employees, customers, and suppliers were conducted in cash