X V fx A B D E F G H Stanford Enterprises uses job-order costing. Overhead is applied on the basis of direct labor hours. The following information relates to the year just ended. 6 Data: Estimated total overhead costs $275,000 Estimated total direct labor hours 25,000 9 Actual total direct labor hours 27,760 10 11 Actual costs for the year: 12 Purchase of raw (direct) materials $375,000 13 Direct labor cost $536,300 14 Manufacturing overhead $302,750 15 16 Inventories: Beginning Ending 17 Raw (Direct) Materials $15,000 $11,375 18 Work in Process 27,875 22,350 19 Finished Goods 34,600 26,450 20 21 Required: 22 Use the data to fill in the following information. 23 (Use cells B6 to C18 from the given information to complete this question. If overhead is overapplied, your answer should be displayed as a 24 negative value. All answers should be input and displayed as positive values.) 25 26 1. Overhead: 27 Actual overhead cost 28 Predetermined overhead rate 29 Actual direct labor hours 30 Total overhead applied 31 (Over) or under applied overhead 32 33 2. Prepare a schedule of cost of goods manufactured: 34 35 (Use cells B6 to C18 from the given information to complete this question. All answers should be input and displayed as positive values.) 36 37 Stanford Enterprises 38 Schedule of Cost of Goods Manufactured 39 Direct materials: 40 Raw materials inventory, beginning 41 Add: Purchases of raw materials 42 Total raw materials available 43 Deduct: Raw materials inventory, ending 44 Raw materials used in production 45 Direct labor Applied manufacturing overhead 47 Total manufacturing costs 48 Add: Beginning work in process inventory 49 Total cost of work in process 50 Deduct: Ending work in process inventory 51 Cost of goods manufactured Graded Worksheet