4 Stanfind Enterprises uses job-order costing Overhead is applied on the basis of direct labor hours 5 The following information relates to the year just ended Data 7 Estimated total overhead cos Estimated total direct labor hours 3 Actual total direct labor hours $275,000 25,000 27,760 11 Actual costs for the year 12 Pathase of raw (direct) material $375,000 13 Direct labor cont $536.300 14 Manufacturing overhead 5302,750 15 16ventories Beginning Inding 17 Raw (Direct) Materials $15,000 $11.375 18 Work in Proces 27.875 22.350 15 Finished Goods 34,600 26,450 D Required: 22 Use the data to fill in the following information 23 (Use cells 86 to C18 from the given information to complete this question. If overhead is overapplied, your answer should be displayed as a 24 megative value. All answers should be input and displayed as positive values) 25 26 1 Overhead 27 Actual overhead cost $302,750 28 Predetermined overhead rate $11.00 29 Actual direct labor hours 27,760 30 Total overhead applied 305,360 31 (Over) or under applied overhead 152.610) 32 33 2. Prepare a schedule of cost of goods manufactured 34 35 (Use cells 86 to C18 from the given information to complete this question. All answers should be input and displayed as poutive values.) Stanford Enterprises Schedule of Cost of Goods Manufactured 37 38 39 Direct materials 40 Raw materials inventory beginning $15,000 41 Add. Purchases of raw materials 375,000 42 Total raw materials available $390,000 45 Deduct: Raw materials inventory, ending 11,375 44 Raw materials uned in production $378.625 536,300 305,360 $1,220.285 O 45 Direct labor 46 Applied manufacturing overhead 47 total manufacturing costs 45 Add: Beginning work in process inventory 4 Total cost of work in process 50 Deduct: Ending work in process inventory 51 Cost of goods manufactured 52 53 Prepare a schedue of cost of goods sold 56 27.875 $5.525 22,350 $1,225.810 O (Use cells B6 to C38 from the given information to complete this question. If overhead is overapplied, your answer should be displayed as a 55 negative value. All answers should be input and displayed as positive values) 56 57 Stanford Enterprises 58 Schedule of Cost of Goods Sold 59 Finished goods inventory, beginning 60 Add Cost of goods manufactured 61 Cost of goods avalable for sale 62 Deduct Finished goods inventory ending 63 Unarfjusted cost of goods sold 64 Underapplied (overapplied) overhead 65 Adjusted cost of goods sold " $34,600 C 1,225,810 $8,150 O 26.4500 51.231,960 (2,610 $1.211.350