1. | |||||
Predetermined overhead | Estimated manufacturing costs/Estimated direct labor hours | ||||
Predetermined overhead | 275000/25000 | ||||
Predetermined overhead | $11.00 | per hour | |||
Actual manufacturing overhead rate | $302,750 | ||||
Predetermined overhead rate | 11 | ||||
Actual direct labor hours | 27760 | $305,360 | |||
Underapplied (overapplied) | -$2,610 | (302750-305360) | |||
Schedule of cost of goods manufactured | |||||
Direct materials | |||||
Beginning raw material inventory | $15,000 | ||||
Add: Purchases of raw material | $375,000 | ||||
Total raw material available (15,000+375,000) | $390,000 | ||||
Less: Raw material inventory, ending | $11,375 | ||||
Raw material used in production | $378,625 | (390000-11375) | |||
Direct labor | $536,300 | ||||
Manufacturing overhead applied to work in process | $305,360 | ||||
Total manufacturing costs | $1,220,285 | (378625+536300+305360) | |||
Add: Beginning work in process inventory | $27,875 | ||||
Total cost of work in process inventory | $1,248,160 | (1220285+27875) | |||
Less: Ending work in process inventory | $22,350 | ||||
Cost of goods manufactured | $1,225,810 | (1248160-22350) | |||
Schedule of cost of goods sold | |||||
Finished goods inventory, Beginning | $34,600 | ||||
Add: Cost of goods manufactured | $1,225,810 | ||||
Cost of goods available for sale | $1,260,410 | (34600+1225810) | |||
Less: Finished goods inventory, ending | $26,450 | ||||
Unadjusted cost of goods sold | $1,233,960 | (1260410-26450) | |||
Underapplied (overapplied) overhead | -$2,610 | ||||
Adjusted cost of goods sold | $1,231,350 | (1233960-2610) | |||
Next to each answer, may you please include the equation that was used to find the...
Compute a predetermined overhead rate. Prepare schedules of cost of goods manufactured and cost of goods sold and an income statement. Compute underapplied or overapplied overhead cost and prepare the journal entry to close the balance in Manufacturing Overhead to the appropriate accounts. Says 'all answers must be entered as a formula' 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...
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...
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...
DETAIL EVERY ANSWER WITH THE EXCEL FORMULA TO SOLVE THE EQUATION - EVERY ANSWER NEEDS AN EXCEL EQUATION DETAIL EVERY ANSWER WITH THE EXCEL FORMULA TO SOLVE THE EQUATION - EVERY ANSWER NEEDS AN EXCEL EQUATION DETAIL EVERY ANSWER WITH THE EXCEL FORMULA TO SOLVE THE EQUATION - EVERY ANSWER NEEDS AN EXCEL EQUATION DETAIL EVERY ANSWER WITH THE EXCEL FORMULA TO SOLVE THE EQUATION - EVERY ANSWER NEEDS AN EXCEL EQUATION DETAIL EVERY ANSWER WITH THE EXCEL FORMULA TO...
please WRITE THE FORMULA NEXT TO the answers, dont answer my question without the formula ( I did some of this so just do the ones i didnt do in yellow) PLEASE please write the formulas. thanks 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, Cost of Goods Manufactured and Cost of Goods Sold - Excel TAYOUT...
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. 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)...
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...
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...
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...