1. Business
  2. Accounting
  3. please solve the yellow cells you must show formula if...

Question: please solve the yellow cells you must show formula if...

Question details
Please solve the yellow cells. You must show formula. If you don’t show formula, don’t answer it please. I need to insert the answer with the formula.
1. Compute a predetermined overhead rate 2. Prepare schedules of cost of goods manufactured and cost of goods sold All answers must be entered as a formula. < Prev 11 of 11 MacBook 3 4 5 8 9
Cost of Goods Manufactured and Cost of Goods Sold-Exce FILE HOME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW Sign In Paste·t B 1 u. 田·クー. Alignment Number Cor ditto al Formatas Styles . Cells Editing Formatting Table Clipboard Font Styles ㄨ .. The allocation basef0r overhead is direct labor hours. A2 ˇ · ˇ 1 Stanford Enterprises uses job-order costing. 2 The allocation bbse for overhead is direct labor hours. 4 Data for the year just ended: 5 Estimated total manufacturing overhead cost 6 Estimated total direct labor hours 7 Actual total direct labor hours 275,000 25,000 27,760 9 Actual costs for the year: 10 Purchase of raw materials (all direct 11 Direct labor cost 12 Manufacturing overhead costs 13 14 Inventories: 15 Raw materials (all direct) 16 Work in process $375,000 $536,300 302,750 Beginning Ending S15,000 11,375 27,87522,350 K Prev11 of 11 E
12 Manuracturing overnead costs 13 15,000 Ending $27,87522,350 34,600$ 26,450 Beginning 14 Inventories: 15 Raw materials (all direct) 16 Work in process 17 Finished goods 18 9 Use the data to answer the following. 20 21 1. Compute applied overhead and determine the amount of underapplied or overapplied overhead: 22 Actual manufacturing overhead cost 23 Predetermined overhead rate 24 Actual direct labor hours 25 Manufacturing overhead applied 26 27 Underapplied (overapplied) manufacturing overhead 28 29 2. Prepare a schedule of cost of goods manufactured: 11,375 30 31 Stanford Enterprises Schedule of Cost of Goods Manufactured 32 33 Direct materials: 4 Raw materials inventory, beginning .. Sheet1... READY 囲回凹- +100% Attempt(s)
Saved Help Save & Exit Stanford Enterprises Schedule of Cost of Goods Manufactured Direct materials: Raw materials inventory, beginning Add: Purchases of raw materials Total raw materials available Deduct: Raw materials inventory, ending Raw materials used in production Direct labor O Manufacturing overhead applied to work in process Total manufacturing costs Add: Beginning work in process inventory Total cost of work in process 4 Deduct: Ending work in process inventory S Cost of goods manufactured 7 3. Prepare a schedule of cost of goods sold. 9 50 51 52 Stanford Enterprises Schedule of Cost of Goods Sold Finished goods inventory, beginning Sheet1 READY 囲回凹 100% Attempt(s) < Prev 11 of 11 Next

Saved Help Save& Exit Su 41 iotai manuracturing costs 42 Add: Beginning work in process inventory 43 Total cost of work in process 44 Deduct: Ending work in process inventory 4S Cost of goods manufactured 46 47 13, Prepare a schedule of cost of goods sold. 48 49 50 51 Stanford Enterprises Schedule of Cost of Goods Sold 52 Finished goods inventory, beginning 3 Add: Cost of goods manufactured 54 Cost of goods available for sale 55 Deduct: Finished goods inventory, ending 56 Unadjusted cost of goods sold S7 Underapplied (overapplied) overhead S8 Adjusted cost of goods sold 59 60 61 62 .. Sheet1 +100% Attempt(s) < Prev 11 of 11Next
Solution by an expert tutor
Blurred Solution
This question has been solved
Subscribe to see this solution