Says 'all answers must be entered as a formula'
Ans.
1. Predetermined Overhead rate = Estimated Manufacturing Overhead / Estimated Direct Labor Hours = $275,000 / 25000 = $11 per direct labor hour
Computation of applied overhead and determination of underapplied or overapplied overhead
Actual Manufacturing Overhead Cost (a) | $ 302,750.00 | |
Predetermined Overhead Rate (b) | $ 11.00 | |
Actual Direct Labor Hours © | 27,760.00 | |
Manufacturing Overhead applied (d = b * c) | $ 305,360.00 | |
Underapplied (Overapplied) manufacturing Overhead (e = a-d) | $ (2,610.00) |
2. Prepare schedules of cost of goods manufactured
Stanford Enterprises | ||
Schedule of Cost of Goods Manufactured | ||
Direct materials | ||
Beginning raw materials inventory (a) | $ 15,000.00 | |
Add: Purchases of raw materials (b) | $ 375,000.00 | |
Total raw materials available (c= a+b) | $ 390,000.00 | |
Deduct: Ending raw materials inventory( d) | $ 11,375.00 | |
Raw materials used in production (e = c-d) | $ 378,625.00 | |
Direct labor (f) | $ 536,300.00 | |
Manufacturing overhead applied to work in process (g) | $ 305,360.00 | |
Total manufacturing costs (h = e + f + g) | $ 1,220,285.00 | |
Add: Beginning work in process inventory (i) | $ 27,875.00 | |
Total Cost of work in proces (j= h+i) | $ 1,248,160.00 | |
Deduct: Ending work in process inventory (k) | $ 22,350.00 | |
Cost of goods manufactured (l = j-k) | $ 1,225,810.00 |
2. Prepare schedules of cost of goods sold
Stanford Enterprises | |
Schedule of Cost of Goods Sold | |
Finished goods inventory,Beginning (a) | $ 34,600.00 |
Add: Cost of goods manufactured (b) | $ 1,225,810.00 |
Cost of goods available for sale (c= a+b) | $ 1,260,410.00 |
Deduct: Finished goods inventory,Ending ( d) | $ 26,450.00 |
Unadjusted cost of goods sold (e= c-d) | $ 1,233,960.00 |
Underapplied (Overapplied) overhead (f) | $ (2,610.00) |
Adjusted cost of goods sold (g = e+f) | $ 1,231,350.00 |
2. Income Statement
Stanford Enterprises | ||
Income Statement | ||
Sales (a) | NA | |
Less: Cost of goods sold (b) | $ 1,231,350.00 | |
Gross margin (c = a-b) | NA | |
Less: Selling and administrative expenses Selling expenses (d) | NA | |
Net Operating Income (e = c -d) | NA |
As the information is not available in question i write NA.
3.
Computation of applied overhead and determination of underapplied or overapplied overhead
Actual Manufacturing Overhead Cost (a) | $ 302,750.00 | |
Predetermined Overhead Rate (b) | $ 11.00 | |
Actual Direct Labor Hours (c) | 27,760.00 | |
Manufacturing Overhead applied (d = b * c) | $ 305,360.00 | |
Underapplied (Overapplied) manufacturing Overhead (e = a-d) | $ (2,610.00) |
Prepare the journal entry to close the balance in Manufacturing Overhead to the appropriate accounts
Date | Particulars | Debit | Credit |
Manufacturing Overhead | $ 2,610.00 | ||
Cost of Goods Sold | $ 2,610.00 |
Compute a predetermined overhead rate. Prepare schedules of cost of goods manufactured and cost of goods...
1. Calculate and dispose of overapplied or underapplied manufacturing overhead. 2. Calculate the cost of goods manufactured and cost of goods sold. 3. Prepare an income statement for a manufacturing firm. 5 ? X . HOME - Sign In FILE INSERT Cost of Goods Manufactured and Cost of Goods Sold - Excel PAGE LAYOUT FORMULAS DATA REVIEW VIEW AA = % D D A. Alignment Number Conditional Format as Cell - Formatting Table Styles - Calibri B I - Paste...
1. Calculate and dispose of overapplied or underapplied manufacturing overhead. 2. Calculate the cost of goods manufactured and cost of goods sold. 3. Prepare an income statement for a manufacturing firm. 1 DB5 Cost of Goods Manufactured and Cost of Goods Sold - Excel Ch2 Excel Simulations F22 H F E D 1 1 А B с 1 Stanford Enterprises uses job-order costing. 2 Overhead is applied on the basis of direct labor hours. 3 The following information relates to...
G B с D E 1 Stanford Enterprises uses job-order costing. 2 The allocation base for overhead is direct labor hours. 3 4 Data for the year just ended: 5 Estimated total manufacturing overhead cost $ 275.000 6 Estimated total direct labor hours 25,000 7 Actual total direct labor hours 27,760 8 9 Actual costs for the year: 10 Purchase of raw materials (all direct) $375.000 11 Direct labor cost $536,300 12 Manufacturing overhead costs $302.750 13 14 Inventories: Beginning...
Next to each answer, may you please include the equation that was used to find the solution. 1. Compute a predetermined overhead rate. 2. Prepare schedules of cost of goods manufactured and cost of goods sold and an income statement. 3. Compute underapplied or overapplied overhead cost and prepare the journal entry to dlose the balance in Manufacturing Overhead to the appropriate accounts. Cost of Goods Manufactured and Cost of Goods Sold - Excel FILE REVIEW HOME INSERT PAGE LAYOUT...
Please give answers in the yellow boxes as an excel function and using cell references when needed. B F G H D i Stanford Enterprises uses job-order costing. 2 The allocation base 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)...
ANSWERS MUST BE FOUND BY USING FORMULAS !!!! с E G H A B D F 1 Stanford Enterprises uses job-order costing. 2 The allocation base for overhead is direct labor hours. 3 4 Data for the year just ended: 5 Estimated total manufacturing overhead cost $ 275,000 6 Estimated total direct labor hours 25,000 7 Actual total direct labor hours 27,760 8 9 Actual costs for the year: 10 Purchase of raw materials (all direct) $375,000 11 Direct labor...
a. Prepare a schedule of cost of goods manufactured. b. Was the overhead underapplied or overapplied? By how much? c. Prepare an income statement for the year. The company closes any underapplied or overapplied overhead to Cost of Goods Sold. Baab Corporation is a manufacturing firm that uses job-order costing. The company's inventory balances were as follows at the beginning and end of the year: Raw materials Work in process Finished Goods Beginning Ending Balance Balance $ 14,150 $22,150 $...
Each answer must made in the form of a formula where the yellow boxes lie, thankyou! 1 Stanford Enterprises uses job-order costing. 2 The allocation base for overhead is direct labor hours. 3 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 8 $375,000 $536,300 $302,750 9 Actual costs for the year: 10 Purchase of raw materials (all direct) 11...
Please give answers in the yellow boxes as an excel function and using cell references when needed. Н 1 Stanford Enterprises uses job-order costing. 2 The allocation base for overhead is direct labor hours. 3 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: $375,000 Purchase of raw materials (all direct) 10 $536,300 $302,750...
Stanford Enterprises has provided its manufacturing estimated and actual data for the year end. The Controller has asked you to compute the predetermined overhead rate, the schedule of cost of goods manufactured, and the schedule of cost of goods sold. Use the information included in the Excel Simulation and the Excel functions described below to complete the task. • Cell Reference: Allows you to refer to data from another cell in the worksheet. From the Excel Simulation below. If in...