All questions must be answered in this Excel file and refracting

B E 1 Palmer Company is a manufacturing firm that uses a job-order costing accounting system. 2 The company uses a Just-in-time purchasing system and therefore does not have any raw materials inventory. 3 The company's inventory balances at the beginning and end of the year were as follows: 4 5 Beginning Ending 6 Raw Materials $ $ 7 Work in process $ 27,000 $ 9,000 8 Finished goods $ 62,000 $ 77,000 9 10 The company applies overhead to jobs using a predetermined overhead rate based on machine hours. 11 At the beginning of the year, the company estimated the following: 12 13 Manufacturing overhead cost $ 221,460 14 Machine hours 33,000 15 16 The following actual transactions and activities were recorded for the year: 17 18 Raw materials purchased and used in production: 19 Direct materials $ 281,000 Indirect materials 2n 26000 D E F A B 16 The following actual transactions and activities were recorded for the year: 17 18 Raw materials purchased and used in production: 19 Direct materials $ 20 Indirect materials 21 Direct labour $ 22 Indirect labour $ 23 Administrative salaries $ 24 Sales salaries $ 25 Utilities - Factory $ 26 Depreciation - Factory $ 27 Depreciation - Selling & Administrative 28 Sales 29 Machine hours 281,000 26,000 377,000 96,000 172,000 147,000 10,000 120,000 7,000 1,253,000 34,000 30 31 Required: 32 33 1 (a) Compute the predetermined overhead rate for the year. 34 /machine hour D E A B 35 36 1 (b) Compute the amount of applied overhead for the year. 37 38 39 1 (c) Was the manufacturing overhead underapplied or overapplied? 40 What amount was this balance in manufacturing overhead account? 41 42 2. Prepare a schedule of cost of goods manufactured for the year. 43 44 Palmer Company 45 Schedule of Cost of Goods Manufactured 46 For the year ended XXXXXXX, 20XX 47 11 48 49 50 51 52 Total manufacturing costs 53 54 A B D E F 52 53 Total manufacturing costs 54 55 56 Cost of goods manufactured 57 58 3. Compute the unadjusted and adjusted cost of goods sold for the year. The company considers the current balance in the manufacturing account 59 to not be materially significant and, as such, closes any underapplied or overapplied overhead to cost of goods sold at year end. 60 61 62 63 64 65 66 Unadjusted Cost of Goods Sold 67 68 Adjusted Cost of Goods Sold 69 70